private void SavePurchaseSub(PharmacyDbContext db, string purchaseMainId) { foreach (ListViewItem item in lvPurchaseMedicine.Items) { PurchaseSub sub = new PurchaseSub(); sub.Id = Guid.NewGuid().ToString(); sub.MainId = purchaseMainId; sub.MedicinId = MedicineFactory.GetMedicineIdByName(item.SubItems[2].Text, db); sub.Quantity = Convert.ToInt32(item.SubItems[3].Text); sub.UnitPrice = Convert.ToDecimal(item.SubItems[4].Text); sub.Total = Convert.ToDecimal(item.SubItems[5].Text); sub.CreatedBy = currentUser; sub.CreatedDate = DateTime.Now; db.PurchaseSub.Add(sub); } }
private void button1_Click(object sender, EventArgs e) { PharmacyDbContext db = new PharmacyDbContext(); PurchaseSub sub = db.PurchaseSub.FirstOrDefault(a => a.Id == purchasedId.Text); if (sub != null) { sub.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text); sub.Quantity = int.Parse(txtQuantity.Text); sub.Total = (sub.Quantity * sub.UnitPrice); db.PurchaseSub.AddOrUpdate(sub); } Medicine medicine = db.Medicine.FirstOrDefault(a => a.Id == medicineId.Text); if (medicine != null) { medicine.ExpiredDate = dtpExpiredDate.Value; db.Medicine.AddOrUpdate(medicine); } db.SaveChanges(); MessageBox.Show(@"Update successful!", "Success", MessageBoxButtons.OK); this.Close(); }