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);
}
