protected void btnSave_Click(object sender, EventArgs e) { CusPrefDetails details = new CusPrefDetails(); if (drpID.SelectedIndex != 0) { details.CustomerSerial = Convert.ToInt16(drpID.SelectedValue); if (dgvCxLike.Rows.Count > 0) { for (int i = 0; i < dgvCxLike.Rows.Count; i++) { details.CustomerLike = dgvCxLike.Rows[i].Cells[2].Text; details.CustomerDisLike = dgvCxLike.Rows[i].Cells[3].Text; details.CustomerFeedBack = dgvCxLike.Rows[i].Cells[4].Text; CustomerPrefData.insertCustomerPref(details); } } Clear(); } else { } }
public static bool updateCustomerPref(CusPrefDetails cus) { bool inserted = false; //string queary = "UPDATE CustomerPreference SET CustomerId='" + cus.CustomerId + "', CustomerLike='" + cus.CustomerLike + "', CustomerDisLike='" + cus.CustomerDisLike + "', CustomerFeedBack='" + cus.CustomerFeedBack + "' WHERE CustomerPreferenceSerial='" + cus.CustomerPreferenceSerial + "'"; //DataAccess da = new DataAccess(); //inserted = da.setData(queary); return(inserted); }
public static bool insertCustomerPref(CusPrefDetails cus) { bool inserted = false; string queary = "INSERT INTO CustomerPreference(CustomerSerial,CustomerLike,CustomerDisLike,CustomerFeedBack) VALUES('" + cus.CustomerSerial + "','" + cus.CustomerLike + "','" + cus.CustomerDisLike + "','" + cus.CustomerFeedBack + "')"; DataAccess da = new DataAccess(); inserted = da.setData(queary); return(inserted); }