protected void AddNewMedicine(object sender, EventArgs e)
{
int? MedicineCatid = 0;
int? MedicineCompanyID = 0;
string MedicineName = ((TextBox)gvMedicine.FooterRow.FindControl("addtxtMedicineName")).Text;
string MedicineCategoryName = ((DropDownList)gvMedicine.FooterRow.FindControl("addMedicineCategoryName")).SelectedItem.ToString();
dc.GetMedicineCategoryID(MedicineCategoryName, ref MedicineCatid);
//errlbl.Text = prodid.ToString();
string MedicineCompanyName = ((DropDownList)gvMedicine.FooterRow.FindControl("addMedicineCompanyName")).SelectedItem.ToString();
dc.GetMedicineCompanyID(MedicineCompanyName, ref MedicineCompanyID);
string Price = ((TextBox)gvMedicine.FooterRow.FindControl("addtxtprice")).Text;
string ManufactureDate = ((TextBox)gvMedicine.FooterRow.FindControl("addtxtManufactureDate")).Text;
string ExpiryDate = ((TextBox)gvMedicine.FooterRow.FindControl("addtxtExpiryDate")).Text;
string Amount = ((TextBox)gvMedicine.FooterRow.FindControl("addtxtAmount")).Text;
Medicine_In_Stock mis = new Medicine_In_Stock
{
MedicineName = MedicineName,
Price = Convert.ToDecimal(Price),
ManufactureDate = Convert.ToDateTime(ManufactureDate),
//ArrivalDate = DateTime.ParseExact(ArrivalDateAjax,"MM/dd/yyyy hh:mm:ss tt", System.Globalization.CultureInfo.InvariantCulture),
ExpiryDate = Convert.ToDateTime(ExpiryDate),
MedicineCategoryID = MedicineCatid,
MedicineCompanyID = MedicineCompanyID,
Amount = Convert.ToDecimal(Amount)
};
dc.Medicine_In_Stocks.InsertOnSubmit(mis);
dc.SubmitChanges();
BindGridDataMedicine();
}
//protected void lnkUpload_Click(object sender, EventArgs e)
//{
// //if (fileupload1.PostedFile != null)
// //{
// // string FileName = Path.GetFileName(fileupload1.PostedFile.FileName);
// // //Save files to disk
// // fileupload1.SaveAs(Server.MapPath("../ProductImages/" + FileName));
// // Medicine_In_Stock mis = new Medicine_In_Stock
// // {
// // Image = "../ProductImages/" + FileName
// // };
// // dc.Medicine_In_Stocks.InsertOnSubmit(mis);
// // dc.SubmitChanges();
// // //BindGridDataMedicine();
// //}
// //else
// //{
// // //lblMessage.ForeColor = System.Drawing.Color.Red;
// // lblerr.Text = "File format not recognised." + " Upload Image/Word/PDF/Excel formats";
// //}
//}
protected void AsyncFileUpload1_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e)
{
string filename = System.IO.Path.GetFileName(AsyncFileUpload1.FileName);
AsyncFileUpload1.SaveAs(Server.MapPath("../ProductImages/") + filename);
Medicine_In_Stock mis = new Medicine_In_Stock
{
Image = "../ProductImages/" + filename
};
dc.Medicine_In_Stocks.InsertOnSubmit(mis);
dc.SubmitChanges();
}
protected void btnSaveMedicine_Click(object sender, EventArgs e)
{
Page.Validate();
//if (Page.IsValid)
//{
if (customIsValid)
{
int?medicineid = 0;
// int? newMedicineID=0;
// bool flag = false;
// Button lnk = (Button)sender;
// var gvrow = (GridViewRow)lnk.NamingContainer;
foreach (GridViewRow gvrow in gvAddBatchNumber.Rows)
{
lblOrderIDToMC = ((Label)gvrow.Cells[0].FindControl("lblOrderIDToMC"));
lblmediname = ((Label)gvrow.Cells[1].FindControl("lblMedicineName"));
lblAmount = ((Label)gvrow.Cells[2].FindControl("lblMedicineQuantity"));
TextBox txtBatch = ((TextBox)gvrow.Cells[4].FindControl("txtBatchNumber"));
TextBox txtManufactureDate = ((TextBox)gvrow.Cells[5].FindControl("AddtxtManufactureDate"));
TextBox txtExpiryDate = ((TextBox)gvrow.Cells[6].FindControl("AddtxtExpiryDate"));
TextBox txtPackSize = ((TextBox)gvrow.Cells[7].FindControl("txtPackSize"));
txtPrice = ((TextBox)gvrow.Cells[3].FindControl("txtPrice"));
// dc.GetMaxMedicineID(lblmediname.Text,ref medicineid);
var getCompany = (from a in dc.Medicine_In_Stocks
where a.MedicineName == lblmediname.Text
select a).First();
//var getmediInfo = from a in dc.Medicine_In_Stocks
// where a.MedicineName == lblmediname.Text
// select a;
//foreach (Medicine_In_Stock item in getmediInfo)
//{
// item.Price =Convert.ToDecimal( txtPrice.Text);
//}
//try
//{
// dc.SubmitChanges();
//}
//catch (Exception ex)
//{
// lblch.Text = ex.ToString();
//}
if (gvrow.RowType == DataControlRowType.DataRow)
{
Medicine_In_Stock ms = new Medicine_In_Stock
{
MedicineName = lblmediname.Text,
Amount = Convert.ToInt32(lblAmount.Text),
BatchNo = txtBatch.Text,
ManufactureDate = Convert.ToDateTime(txtManufactureDate.Text),
ExpiryDate = Convert.ToDateTime(txtExpiryDate.Text),
PackSize = txtPackSize.Text,
Price = Convert.ToDecimal(txtPrice.Text),
MedicineCategoryID = getCompany.MedicineCategoryID,
MedicineCompanyID = getCompany.MedicineCompanyID,
Image = getCompany.Image,
Description = getCompany.Description
};
dc.Medicine_In_Stocks.InsertOnSubmit(ms);
dc.SubmitChanges();
dc.GetMaxMedicineID(lblmediname.Text, ref medicineid);
// Label lb = (gvrow.Cells[0].FindControl("lblOrderIDtoMC") as Label);
//var s = (from a in dc.Order_To_Medicine_Company_Per_Medicines
// join medi in dc.Medicine_In_Stocks on a.MedicineID equals medi.MedicineID
// where a.OrderIDToMC == Convert.ToInt32(lb.Text) && medi.MedicineName==Convert.ToString ((Label)gvrow.Cells[1].FindControl("lblMedicineName"))
// select medi.BatchNo).Single();
// if (s == Convert.ToString((Label)gvrow.Cells[2].FindControl("txtBatchNumber")))
// {
//var sub = dc.Medicine_In_Stocks
// .Where(m => m.MedicineName == Convert.ToString((Label)gvrow.Cells[1].FindControl("lblMedicineName")) && m.BatchNo == Convert.ToString((Label)gvrow.Cells[2].FindControl("txtBatchNumber")))
// .FirstOrDefault();
//int q = Convert.ToInt32(sub.Amount);
// int q = Convert.ToInt32((Label)gvrow.Cells[2].FindControl("lblMedicineQuantity"));
//// int.TryParse(quantity, out q);
//var mediInStock = from m in dc.Medicine_In_Stocks
// where m.MedicineName == Convert.ToString((Label)gvrow.Cells[1].FindControl("lblMedicineName")) && m.BatchNo == Convert.ToString((Label)gvrow.Cells[2].FindControl("txtBatchNumber"))
// select m;
//foreach (Medicine_In_Stock mis in mediInStock)
//{
// mis.Amount = q;
//};
//try
//{
// dc.SubmitChanges();
//}
//catch (Exception ex)
//{
// lblerr.Text = ex.ToString();
//}
//if (flag == false)
//{
//}
//}
}
}
var o = from or in dc.Order_To_Medicine_Companies
where or.OrderIDToMC == Convert.ToInt32(lblOrderIDToMC.Text)
select or;
foreach (Order_To_Medicine_Company om in o)
{
om.Status = "Delivered";
}
try
{
dc.SubmitChanges();
}
catch (Exception ex)
{
lblch.Text = ex.ToString();
}
decimal id = 0;
var ordermedi = from or in dc.Order_To_Medicine_Company_Per_Medicines
//join ord in dc.Order_To_Medicine_Company_Per_Medicines on or.OrderIDToMC equals ord.OrderIDToMC
//join mediname in dc.Medicine_In_Stocks on ord.MedicineID equals mediname.MedicineID
where or.OrderIDToMC == Convert.ToInt32(lblOrderIDToMC.Text)
select or;
foreach (Order_To_Medicine_Company_Per_Medicine item in ordermedi)
{
var a = (from s in dc.Medicine_In_Stocks
where s.MedicineID == item.MedicineID //&& s.MedicineName == lblmediname.Text
select s.MedicineID).First();
if (a > 0)
{
id = a;
break;
}
}
var orderidmedi = from or in dc.Order_To_Medicine_Company_Per_Medicines
// join ord in dc.Order_To_Medicine_Company_Per_Medicines on or.OrderIDToMC equals ord.OrderIDToMC
//join mediname in dc.Medicine_In_Stocks on ord.MedicineID equals mediname.MedicineID
where or.OrderIDToMC == Convert.ToInt32(lblOrderIDToMC.Text) && or.MedicineID == id
select or;
foreach (Order_To_Medicine_Company_Per_Medicine item in orderidmedi)
{
item.MedicineID = medicineid;
item.NetAmount = (Convert.ToInt32(lblAmount.Text) * Convert.ToDecimal(txtPrice.Text));
}
try
{
dc.SubmitChanges();
}
catch (Exception ex)
{
lblerr.Text = ex.ToString();
}
Purchase sp = new Purchase
{
Date = DateTime.Now,
OrderIDToMC = Convert.ToInt32(lblOrderIDToMC.Text)
};
// flag = true;
dc.Purchases.InsertOnSubmit(sp);
dc.SubmitChanges();
var sname = (from a in dc.Order_To_Medicine_Companies
join medi in dc.Medicine_Companies on a.MedicineCompanyID equals medi.MedicineCompanyID
where a.OrderIDToMC == Convert.ToInt32(lblOrderIDToMC.Text)
select medi.MedicineCompanyName).First();
Transaction tc = new Transaction
{
Order_ = Convert.ToInt32(lblOrderIDToMC.Text),
Date = DateTime.Now.Date,
Time = Convert.ToDateTime(DateTime.Now),
Type = "Purchase from Company",
Client_Supplier = sname
};
dc.Transactions.InsertOnSubmit(tc);
dc.SubmitChanges();
BindGridDataOrders();
//}
}
}
