private void btnsell_Click(object sender, EventArgs e) { string buyMedText = ""; decimal totalPrice = 0; for (int i = chkList.Items.Count - 1; i >= 0; i--) { string buyMedName = chkList.Items[i].ToString(); int medCount = Convert.ToInt32(buyMedName.Substring(buyMedName.LastIndexOf(",") + 1)); string medName = buyMedName.Substring(0, buyMedName.LastIndexOf(",")); Medicine selectedMed = db.Medicines.First(m => m.Name == medName); db.Orders.Add(new Order() { WorkerID = 1, Amount = medCount, MedicineID = selectedMed.Id, PurchaseDate = DateTime.Now, }); db.SaveChanges(); selectedMed.Quantity -= medCount; db.SaveChanges(); buyMedText += string.Format($"{medName} count: {medCount}, price: {selectedMed.Price} Azn\n"); totalPrice += selectedMed.Price * medCount; } MessageBox.Show(buyMedText + $"\n Total price: {totalPrice}\nBuy succesfully", "BUY", MessageBoxButtons.OK, MessageBoxIcon.Information); FillDataGridMedicine(); }
public ActionResult Details(int?id, string Status) { var stock = db.Stocks.Find(id); stock.Status = Status; db.SaveChanges(); return(RedirectToAction("Index", "Stocks")); }
public ActionResult Create([Bind(Include = "ID,CateName,CateCode")] Category category) { if (ModelState.IsValid) { db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(category)); }
public ActionResult Create([Bind(Include = "ID,Firstname,Lastname,Gender,BirthDay,Weight,Height,Description")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult Create([Bind(Include = "ID,CateID,ProductName,Buy,Size,Code,Ingredients,ImagePath,Description,Unit,Barcode,Sale")] Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CateID = new SelectList(db.Categories, "ID", "CateName", product.CateID); return(View(product)); }
public ActionResult Create(Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); } ViewBag.Category = new SelectList(db.ProductCategories, "ProductTypeCode", "ProductType", product.ProductTypeCode); return(View(product)); }
private void addButton_Click_1(object sender, EventArgs e) { using (PharmacyEntities db = new PharmacyEntities()) { PointsOfSale buff = new PointsOfSale(); try { buff.id = Convert.ToInt32(idTextBox.Text); } catch (FormatException) { MessageBox.Show("Неверно введенные данные!"); return; } buff.AddressOfPoint = adressTexBox.Text; db.PointsOfSale.Add(buff); try { db.SaveChanges(); } catch (DbUpdateException) { MessageBox.Show("ID не должен повторяться!"); return; } } Close(); }
public int HaveFirms(string frm) { Firm hasFirm = db.Firms.FirstOrDefault(x => x.Name == frm); if (hasFirm == null) { Firm newFirm = new Firm() { Name = frm }; db.Firms.Add(newFirm); db.SaveChanges(); return(newFirm.ID); } return(hasFirm.ID); }
public ActionResult Deletes(int id) { PurchaseItem purchaseitem = db.PurchaseItems.Find(id); db.PurchaseItems.Remove(purchaseitem); db.SaveChanges(); return(Json("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult Create(CreateClientModel model) { if (ModelState.IsValid) { PharmacyEntities entities = new PharmacyEntities(); entities.MainClientDatas.Add(model.MainData); entities.SaveChanges(); int mainDataId = entities.MainClientDatas.First(x => x.Email == model.MainData.Email).id; model.OtherData.ClientId = mainDataId; model.EyeData.ClientId = mainDataId; entities.OtherClientDatas.Add(model.OtherData); entities.EyeClientDatas.Add(model.EyeData); entities.SaveChanges(); return(RedirectToAction("FindClient")); } else { return(View(model)); } }
private void addButton_Click(object sender, EventArgs e) { using (PharmacyEntities db = new PharmacyEntities()) { ProductList buff = new ProductList(); try { buff.ProductID = Convert.ToInt32(idTextBox.Text); } catch (FormatException) { MessageBox.Show("Неверно введенные данные!"); return; } foreach (var item in db.MedicalPreparations) { if (medicalPreparationsComboBox.Text == item.NamePreparation) { buff.ProductID = item.id; break; } } foreach (var item in db.PointsOfSale) { if (pointsOfSaleComboBox.Text == item.AddressOfPoint) { buff.PointOfSaleID = item.id; break; } } buff.shelfLife = dateTimePicker1.Value; try { db.SaveChanges(); } catch (DbUpdateException) { MessageBox.Show("ID не должен повторяться!"); return; } } }
private void editButton_Click(object sender, EventArgs e) { using (PharmacyEntities db = new PharmacyEntities()) { db.PointsOfSale.Find(id).AddressOfPoint = adressTexBox.Text; try { db.SaveChanges(); } catch (DbUpdateException) { MessageBox.Show("Ошибка!"); return; } Close(); } }
private void AddButton_Click(object sender, EventArgs e) { using (PharmacyEntities db = new PharmacyEntities()) { MedicalPreparations buff = new MedicalPreparations(); try { buff.id = Convert.ToInt32(idTextBox.Text); buff.NamePreparation = nameTextBox.Text; foreach (var item in db.Manufactures) { if (manufacturesComboBox.Text == item.NameManufacture) { buff.ManufactureID = item.id; break; } } buff.Price = Convert.ToDouble(priceTextBox.Text); buff.CountInPackage = Convert.ToInt32(countTextBox.Text); } catch (FormatException) { MessageBox.Show("Неверно введенные данные!"); return; } db.MedicalPreparations.Add(buff); try { db.SaveChanges(); } catch (DbUpdateException) { MessageBox.Show("ID не должен повторяться!"); return; } } this.Close(); }
private void editButton_Click(object sender, EventArgs e) { using (PharmacyEntities db = new PharmacyEntities()) { try { db.ProductList.Find(id).id = Convert.ToInt32(idTextBox.Text); } catch (FormatException) { MessageBox.Show("Неверно введенные данные!"); return; } foreach (var item in db.MedicalPreparations) { if (medicalPreparationsComboBox.Text == item.NamePreparation) { db.ProductList.Find(id).ProductID = item.id; } } foreach (var item in db.PointsOfSale) { if (pointsOfSaleComboBox.Text == item.AddressOfPoint) { db.ProductList.Find(id).PointOfSaleID = item.id; } } db.ProductList.Find(id).shelfLife = dateTimePicker.Value; try { db.SaveChanges(); } catch (DbUpdateException) { MessageBox.Show("Ошибка"); return; } } Close(); }
private void AddButton_Click(object sender, EventArgs e) { using (PharmacyEntities db = new PharmacyEntities()) { db.Manufactures.Find(this.id).NameManufacture = nameTextBox.Text; try { db.SaveChanges(); } catch (DbUpdateException) { MessageBox.Show("ID не должен повторяться!"); return; } } this.Close(); }