private void UpdateCustomerMain(PharmacyDbContext db) { SaleMain main = db.SaleMain.Where(a => a.CustomerId == _customerId).OrderByDescending(x => x.Id).FirstOrDefault(); main.DuePaid += Convert.ToDecimal(txtDuePay.Text); db.Entry(main).State = EntityState.Modified; }
public ActionResult Edit([Bind(Include = "Id,Name,Code,AvailableQuantity")] Medicine medicine) { if (ModelState.IsValid) { db.Entry(medicine).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(medicine)); }
public RackViewModel UpdateRack(RackViewModel model) { var result = new PHRMRackModel() { RackId = model.RackId, Name = model.Name, Description = model.Description, CreatedBy = model.CreatedBy, CreatedOn = model.CreatedOn }; db.Entry(result).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(model); }
public ActionResult Edit([Bind(Include = "Id,Address,FirstName,LastName,EGN")] Person person) { var found = db.Persons.Where(f => f.EGN == person.EGN && f.Id != person.Id).FirstOrDefault(); if (found != null) { ModelState.AddModelError("EGN", "EGN already exists!!!"); } if (ModelState.IsValid) { db.Entry(person).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(person)); }
public ActionResult Edit([Bind(Include = "Id,Number,DoneAt,CounterpartyId")] Sell sell) { var found = db.Sells.Where(s => s.Number == sell.Number && s.Id != sell.Id).FirstOrDefault(); if (found != null) { ModelState.AddModelError("Number", "Number already exists in different sell!!!"); } if (ModelState.IsValid) { db.Entry(sell).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CounterpartyId = new SelectList(db.Counterparties, "Id", "Stringed", sell.CounterpartyId); return(View(sell)); }
public ActionResult Edit([Bind(Include = "Id,Price,Quantity,MedicineId,SellId")] SoldMedicine soldMedicine) { var found = db.Medicines.Find(soldMedicine.MedicineId).AvailableQuantity - soldMedicine.Quantity; if (found < 0) { ModelState.AddModelError("Quantity", "Quantity too low!!!"); } if (ModelState.IsValid) { db.Entry(soldMedicine).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MedicineId = new SelectList(db.Medicines, "Id", "Name", soldMedicine.MedicineId); ViewBag.SellId = new SelectList(db.Sells, "Id", "Number", soldMedicine.SellId); return(View(soldMedicine)); }
public ActionResult Edit([Bind(Include = "Id,Address,Name,Code,EIK")] Firm firm) { var found = db.Firms.Where(f => f.EIK == firm.EIK && f.Id != firm.Id).FirstOrDefault(); if (found != null) { ModelState.AddModelError("EIK", "EIK already exists!!!"); } if (!this.IsRealEIK(firm.EIK)) { ModelState.AddModelError("EIK", "EIK is fake!!!"); } if (ModelState.IsValid) { db.Entry(firm).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(firm)); }
public ActionResult Edit([Bind(Include = "Id,Price,Quantity,MedicineId,DeliveryId")] DeliveredMedicine deliveredMedicine) { var error = string.Empty; if (ModelState.IsValid) { try { db.Entry(deliveredMedicine).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } catch (DbUpdateException ex) { error = ex.GetDeepestMessage(); } } ViewBag.DeliveryId = new SelectList(db.Deliveries, "Id", "Number", deliveredMedicine.DeliveryId); ViewBag.MedicineId = new SelectList(db.Medicines, "Id", "Name", deliveredMedicine.MedicineId); ViewBag.Error = error; return(View(deliveredMedicine)); }
public static Boolean StockTransferToPharmacy(List <WARDStockModel> stkTransfer, WardSupplyDbContext wardSupplyDbContext, PharmacyDbContext pharmacyDbContext, RbacUser currentUser) { //Transaction Begins using (var dbContextTransaction = wardSupplyDbContext.Database.BeginTransaction()) { try { if (stkTransfer != null) { for (int i = 0; i < stkTransfer.Count; i++) { var stockId = stkTransfer[i].StockId; WARDStockModel updatedStock = (from stock in wardSupplyDbContext.WARDStockModel where stock.StockId == stockId select stock ).FirstOrDefault(); updatedStock.AvailableQuantity = (int)(Convert.ToDecimal(stkTransfer[i].AvailableQuantity)) - (int)(Convert.ToDecimal(stkTransfer[i].DispachedQuantity)); wardSupplyDbContext.Entry(updatedStock).Property(a => a.AvailableQuantity).IsModified = true; //transaction table var selectedstockTxnItm = new WARDTransactionModel(); selectedstockTxnItm.WardId = updatedStock.WardId; selectedstockTxnItm.ItemId = updatedStock.ItemId; selectedstockTxnItm.StockId = updatedStock.StockId; selectedstockTxnItm.TransactionId = 0; selectedstockTxnItm.Quantity = (int)(Convert.ToDecimal(stkTransfer[i].DispachedQuantity)); selectedstockTxnItm.TransactionType = "WardToPharmacy"; selectedstockTxnItm.Remarks = "Sent From Ward To Pharmacy"; selectedstockTxnItm.CreatedBy = currentUser.UserName; selectedstockTxnItm.CreatedOn = DateTime.Now; selectedstockTxnItm.IsWard = true; wardSupplyDbContext.TransactionModel.Add(selectedstockTxnItm); wardSupplyDbContext.SaveChanges(); //pharmacy stock changes var itemId = stkTransfer[i].ItemId; var batchNo = stkTransfer[i].BatchNo; PHRMStockModel updatedPharmacyStock = (from stock in pharmacyDbContext.PHRMStock where stock.ItemId == itemId && stock.BatchNo == batchNo select stock ).FirstOrDefault(); updatedPharmacyStock.AvailableQuantity = (int)(Convert.ToDecimal(updatedPharmacyStock.AvailableQuantity)) + (int)(Convert.ToDecimal(stkTransfer[i].DispachedQuantity)); pharmacyDbContext.Entry(updatedPharmacyStock).Property(a => a.AvailableQuantity).IsModified = true; //Pharmacy Transaction Table var phrmStockTxn = new PHRMStockTransactionItemsModel(); phrmStockTxn.ItemId = updatedPharmacyStock.ItemId; phrmStockTxn.BatchNo = updatedPharmacyStock.BatchNo; phrmStockTxn.ExpiryDate = stkTransfer[i].ExpiryDate; phrmStockTxn.Quantity = (int)(Convert.ToDecimal(stkTransfer[i].DispachedQuantity)); phrmStockTxn.FreeQuantity = 0; phrmStockTxn.Price = (int)(Convert.ToDecimal(stkTransfer[i].MRP)); phrmStockTxn.DiscountPercentage = 0; phrmStockTxn.VATPercentage = 0; phrmStockTxn.SubTotal = (int)(Convert.ToDecimal(phrmStockTxn.Quantity)) * (int)(Convert.ToDecimal(phrmStockTxn.Price)); phrmStockTxn.TotalAmount = phrmStockTxn.SubTotal; phrmStockTxn.InOut = "in"; phrmStockTxn.CreatedBy = currentUser.UserId; phrmStockTxn.CreatedOn = DateTime.Now; phrmStockTxn.MRP = phrmStockTxn.Price; phrmStockTxn.TransactionType = "WardToPharmacy"; pharmacyDbContext.PHRMStockTransactionModel.Add(phrmStockTxn); pharmacyDbContext.SaveChanges(); } } dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); throw ex; } } }