SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["ComplaintReportsConnectionSt  ring1"].ConnectionString);
conn1.Open();
 string query1 = String.Format("Insert Into Customer(Customer_id,NRIC,First_Name,Last_Name,Company_Name,Phone_No,Fax_No,Email,Address_Line1,Address_Line2,City,State_Province,Postal_Code,Country)VALUES(@NRIC,@NRIC,@First_Name,@Last_Name,@Company_Name,@Phone_No,@Fax_No,@Email,@Address_Line1,@Address_Line2,@City,@State_Province,@Postal_Code,@Country)", conn1);
SqlCommand cmd1 = new SqlCommand(query1, conn1);
                cmd1.Parameters.AddWithValue("@NRIC", TextBox2.Text);
                cmd1.Parameters.AddWithValue("@First_Name", TextBox3.Text);
                cmd1.Parameters.AddWithValue("@Last_Name", TextBox4.Text);
                cmd1.Parameters.AddWithValue("@Company_Name", TextBox5.Text);
                cmd1.Parameters.AddWithValue("@Phone_No", TextBox6.Text);
                cmd1.Parameters.AddWithValue("@Fax_No", TextBox7.Text);
                cmd1.Parameters.AddWithValue("@Email", TextBox8.Text);
                cmd1.Parameters.AddWithValue("@Address_Line1", TextBox9.Text);
                cmd1.Parameters.AddWithValue("@Address_Line2", TextBox10.Text);
                cmd1.Parameters.AddWithValue("@City", TextBox11.Text);
                cmd1.Parameters.AddWithValue("@State_Province", TextBox12.Text);
                cmd1.Parameters.AddWithValue("@Postal_Code", TextBox13.Text);
                cmd1.Parameters.AddWithValue("@Country", TextBox14.Text);
                //cmd1.Parameters.AddWithValue("@Customer_id", TextBox17.Text);

                cmd1.ExecuteNonQuery();
                conn1.Close();

//INSERT INTO Complaint
             SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ComplaintReportsConnectionString1"].ConnectionString);
             conn2.Open();

             string query2 = String.Format("Insert Into Complaint(Complaint_Date,Complaint_Details,Type_id,Status_id,Channel_id)VALUES(@Complaint_Date,@Complaint_Details,@Type_id,@Status_id,@Channel_id)", conn2);
             SqlCommand cmd2 = new SqlCommand(query2,conn2);

             cmd2.Parameters.AddWithValue("@Complaint_Date", TextBox16.Text);
             cmd2.Parameters.AddWithValue("@Complaint_Details", TextBox15.Text);

             //customerID from customer's table
             cmd2.Parameters.AddWithValue("@Customer_id", TextBox2.Text);

             cmd2.Parameters.AddWithValue("@Type_id", type.SelectedValue);
             cmd2.Parameters.AddWithValue("@Channel_id", Channel.SelectedValue);
             cmd2.Parameters.AddWithValue("@Status_id", Status.SelectedValue);

             cmd2.ExecuteNonQuery();
             conn2.Close();
             Response.Redirect("CustomerComplaint.aspx");