protected void updateMedicine(object sender, GridViewUpdateEventArgs e)
{
this.gvMedicine.Columns[1].Visible = true;
int? MedicineCatID = 0;
int? MedicineCompanyID = 0;
string MedicineID = ((Label)gvMedicine.Rows[e.RowIndex].FindControl("editlblMedicineID")).Text;
string MedicineName = ((TextBox)gvMedicine.Rows[e.RowIndex].FindControl("edittxtMedicineName")).Text;
string Price = ((TextBox)gvMedicine.Rows[e.RowIndex].FindControl("edittxtPrice")).Text;
string MedicineCatName = ((DropDownList)gvMedicine.Rows[e.RowIndex].FindControl("editMedicineCategoryName")).Text;
//dc.GetMedcineCategoryID(MedicineCatName, ref MedicineCatID);
dc.GetMedicineCategoryID(MedicineCatName, ref MedicineCatID);
string MedicineCompanyName = ((DropDownList)gvMedicine.Rows[e.RowIndex].FindControl("editMedicineCompanyName")).Text;
dc.GetMedicineCompanyID(MedicineCompanyName, ref MedicineCompanyID);
string ManufactureDate = ((TextBox)gvMedicine.Rows[e.RowIndex].FindControl("edittxtManufactureDate")).Text;
string ExpiryDate = ((TextBox)gvMedicine.Rows[e.RowIndex].FindControl("edittxtExpiryDate")).Text;
string Amount = ((TextBox)gvMedicine.Rows[e.RowIndex].FindControl("edittxtAmount")).Text;
var q = from medi in dc.Medicine_In_Stocks
where medi.MedicineID == Convert.ToInt32(MedicineID)
select medi;
foreach (Medicine_In_Stock mis in q)
{
mis.MedicineName = MedicineName;
mis.Price = Convert.ToDecimal(Price);
mis.MedicineCategoryID = MedicineCatID;
mis.MedicineCompanyID = MedicineCompanyID;
mis.ManufactureDate = Convert.ToDateTime(ManufactureDate);
mis.ExpiryDate = Convert.ToDateTime(ExpiryDate);
mis.Amount = Convert.ToDecimal(Amount);
}
try
{
dc.SubmitChanges();
}
catch (Exception ex)
{
lblerr.Text = ex.ToString();
}
gvMedicine.EditIndex = -1;
BindGridDataMedicine();
}
