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();
}
void placeOrder(string name, string quantity)
{
int? MedicineCompanyID = 0;
string MedicineCompanyName = ddlMedicineCompany.SelectedItem.Text;
int? MedicineID = 0;
dc.GetMedicineID(name, ref MedicineID);
dc.GetMedicineCompanyID(MedicineCompanyName, ref MedicineCompanyID);
if (chk1 == 1)
{
var username = (from a in dc.Users
where a.UserId == Convert.ToInt32(Session["AdminUserID"])
select a.Username).Single();
Order_To_Medicine_Company obms = new Order_To_Medicine_Company
{
MedicineCompanyID = MedicineCompanyID,
Due_Date = Convert.ToDateTime(txtDueDate.Text),
Order_Date = DateTime.Now,
Placed_By = Convert.ToString(username),
Status = "Pending"
};
dc.Order_To_Medicine_Companies.InsertOnSubmit(obms);
dc.SubmitChanges();
}
var s = dc.Order_To_Medicine_Companies
.OrderByDescending(m => m.OrderIDToMC)
.FirstOrDefault();
Order_To_Medicine_Company_Per_Medicine obmsm = new Order_To_Medicine_Company_Per_Medicine
{
MedicineID = MedicineID,
Amount = Convert.ToInt32(quantity),
OrderIDToMC = Convert.ToDecimal(s.OrderIDToMC)
};
dc.Order_To_Medicine_Company_Per_Medicines.InsertOnSubmit(obmsm);
dc.SubmitChanges();
}