public ActionResult UpdateMedicine(Medicine Medicine) { if (ModelState.IsValid) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { db.Medicines.Attach(Medicine); db.Entry(Medicine).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("MedicinesList")); } } catch (Exception ex) { Console.WriteLine(ex.Message); ViewBag.ErrorMessage = "Unable to edit medicine."; return(View("EditMedicine", Medicine)); } } else { FillDropdowns(); return(View("EditMedicine", Medicine)); } }
public ActionResult UpdateSupplier(Supplier supplier) { if (ModelState.IsValid) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { db.Suppliers.Attach(supplier); db.Entry(supplier).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(PartialView("_SuppliersList", GetAllSuppliers())); //return View("Index", new SupplierViewModel { Supplier = new Supplier(), SuppliersList = GetAllSuppliers()}); //return RedirectToAction("Index"); } else { ModelState.AddModelError("Name", "Invalid Name"); //return PartialView("_SuppliersList", GetAllSuppliers()); //return View("Index", new SupplierViewModel { Supplier = new Supplier(), SuppliersList = GetAllSuppliers() }); return(RedirectToAction("Index")); } }
public ActionResult UpdateInventorySetting(Medicine medicine) { try { if (medicine.StockCapacity == 0 || medicine.ReorderLevel == 0 || medicine.BufferLevel == 0) { return(Json("Invalid Data", JsonRequestBehavior.AllowGet)); } using (PharmAssistantContext db = new PharmAssistantContext()) { db.Medicines.Attach(medicine); //db.Entry(medicine).State = EntityState.Modified; db.Entry(medicine).Property("StockCapacity").IsModified = true; db.Entry(medicine).Property("ReorderLevel").IsModified = true; db.Entry(medicine).Property("BufferLevel").IsModified = true; db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //TempData["UpdateSuccess"] = "Record updated successfully."; //return RedirectToAction("AvailableStock"); return(Json(GetInventorySettings(), JsonRequestBehavior.AllowGet)); }
public ActionResult GetMemberships() { try { using (PharmAssistantContext db = new PharmAssistantContext()) { var membershipAcounts = (from c in db.Customers join ma in db.MembershipAccounts on c.CustomerId equals ma.CustomerId join mtype in db.MembershipTypes on ma.MembershipTypeId equals mtype.MembershipTypeId select new { CustomerId = c.CustomerId, CustomerName = c.CustomerName, MembershipId = ma.MembershipId, MembershipTypeId = mtype.MembershipTypeId, MembershipType = mtype.MembershipTypeName, JoiningDate = ma.JoiningDate, TotalPurchase = ma.TotalPurchaseAmount, BonusPoints = ma.BonusPoints }).ToList(); return(Json(membershipAcounts, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } }
//[ValidateAntiForgeryToken] public HttpStatusCodeResult NewMembershipAccount(int CustomerId, int MembershipTypeId) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { MembershipAccount membershipAccount = new MembershipAccount { CustomerId = CustomerId, MembershipTypeId = MembershipTypeId, JoiningDate = DateTime.Now }; db.MembershipAccounts.Add(membershipAccount); db.SaveChanges(); Customer customer = db.Customers.Where(c => c.CustomerId == CustomerId).FirstOrDefault(); customer.MembershipId = db.MembershipAccounts.Where(ma => ma.CustomerId == CustomerId).FirstOrDefault().MembershipId; db.Customers.Attach(customer); db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); } return(new HttpStatusCodeResult(HttpStatusCode.OK)); } catch (Exception ex) { Console.WriteLine(ex.Message); return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
public JsonResult GetSuppliersOfCategories(int CategoryId) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { var AllSuppliers = new List <Object>(); //var AllSuppliers = db.Suppliers.ToList(); var Suppliers = db.MedicineCategories.Where(m => m.CategoryId == CategoryId).FirstOrDefault().Suppliers.ToList(); foreach (var supplier in db.Suppliers.ToList()) { if (Suppliers.Contains(supplier)) { AllSuppliers.Add(new { SupplierId = supplier.SupplierId, SupplierName = supplier.SupplierName, Select = 1 }); } else { AllSuppliers.Add(new { SupplierId = supplier.SupplierId, SupplierName = supplier.SupplierName, Select = 0 }); } } //var Suppliers = db.Suppliers.Where(s => s.MedicineCategories.Contains(db.MedicineCategories.Where(c => c.CategoryId == CategoryId).FirstOrDefault())).Select(s => new { SuplierId = s.SupplierId, SupplierName = s.SupplierName }).ToList(); return(Json(AllSuppliers, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(Json(new { }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddShelf(Shelf Shelf) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { var existingShelf = db.Shelves.Where(s => s.ShelfName == Shelf.ShelfName && s.ShelfId == Shelf.ShelfId).FirstOrDefault(); if (existingShelf == null) { db.Shelves.Add(Shelf); db.SaveChanges(); return(PartialView("_ShelvesList", db.Shelves.ToList())); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Shelf Already Exists.")); } } } catch (Exception ex) { Console.WriteLine(ex.Message); return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Something went wrong. Please try again later.")); } }
public ActionResult AssociateSuppliersToMedicine(MedicineSupplierViewModel MedicineSupplierData) { Console.WriteLine(MedicineSupplierData); using (PharmAssistantContext db = new PharmAssistantContext()) { try { Medicine medicine = db.Medicines.Where(m => m.MedicineId == MedicineSupplierData.MedicineId).FirstOrDefault(); var suppliers = db.Suppliers; foreach (var supplier in suppliers) { if (MedicineSupplierData.SelectedSuppliersForMedicine.Contains(supplier.SupplierId) && !medicine.Suppliers.Contains(supplier)) { medicine.Suppliers.Add(supplier); } else if (!MedicineSupplierData.SelectedSuppliersForMedicine.Contains(supplier.SupplierId) && medicine.Suppliers.Contains(supplier)) { medicine.Suppliers.Remove(supplier); } } db.SaveChanges(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } return(RedirectToAction("ManageSuppliers")); }
public ActionResult AddCategory(MedicineCategory Category) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { var existingCategory = db.MedicineCategories.Where(c => c.MedicineCategoryName == Category.MedicineCategoryName).FirstOrDefault(); if (existingCategory == null) { db.MedicineCategories.Add(Category); db.SaveChanges(); return(PartialView("_MedicineCategoryList", GetAllCategories())); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Categoty Already Exists.")); } } } catch (Exception ex) { Console.WriteLine(ex.Message); return(new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Something went wrong. Please try again later.")); } }
public ActionResult AddManufacturer(Manufacturer manufacturer) { if (ModelState.IsValid) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { db.Manufacturers.Add(manufacturer); db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(PartialView("_ManufacturersList", GetAllManufacturers())); //return View("Index", new ManufacturerViewModel { Manufacturer = new Manufacturer(), ManufacturersList = GetAllManufacturers()}); //return RedirectToAction("Index"); } else { ModelState.AddModelError("Name", "Invalid Name"); //return PartialView("_ManufacturersList", GetAllManufacturers()); //return View("Index", new ManufacturerViewModel { Manufacturer = new Manufacturer(), ManufacturersList = GetAllManufacturers() }); return(RedirectToAction("Index")); } }
public ActionResult AddCustomer(Customer customer) { if (ModelState.IsValid) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { db.Customers.Add(customer); db.SaveChanges(); TempData["SuccessMessage"] = "Customer added successfully"; return(RedirectToAction("Index")); } } catch (Exception ex) { Console.WriteLine(ex.Message); TempData["ErrorMessage"] = "Unable to add customer. Please try again later."; return(RedirectToAction("Index")); } } else { return(View("NewCustomer", customer)); } }
public ActionResult EditOrder(string OrderId) { string[] uri = Request.UrlReferrer == null ? new string[] { "PurchaseOrdersList" } : Request.UrlReferrer.ToString().Split('/'); PurchaseOrderViewModel PurchaseOrderModel = new PurchaseOrderViewModel(); if (uri.Contains("PurchaseOrdersList")) { using (PharmAssistantContext db = new PharmAssistantContext()) { PurchaseOrderModel.PurchaseOrder = db.PurchaseOrders.Include("Supplier").Where(o => o.PurchaseOrderId == OrderId).FirstOrDefault(); PurchaseOrderModel.PurchaseOrderItems = db.PurchaseOrderItems.Where(i => i.PurchaseOrderId == OrderId).ToList(); } Session["PurchaseOrderModel"] = PurchaseOrderModel; } else { PurchaseOrderModel = (PurchaseOrderViewModel)Session["PurchaseOrderModel"]; //PurchaseOrderModel.PurchaseOrder = new PurchaseOrder { PurchaseOrderId = Convert.ToInt64(DateTime.Now.ToString("ffffssmmhhMMddyyyy")) }; } ViewBag.MedicineCategories = new SelectList(db.MedicineCategories.Where(m => m.Suppliers.Contains(db.Suppliers.Where(s => s.SupplierId == PurchaseOrderModel.PurchaseOrder.SupplierId).FirstOrDefault())).ToList(), "CategoryId", "MedicineCategoryName"); //FillDropdowns(); return(View(PurchaseOrderModel)); }
public ActionResult ReceiveOrder(string OrderId, ICollection <long> BatchNumbers, ICollection <DateTime> ExpiryDates) { using (PharmAssistantContext db = new PharmAssistantContext()) { try { db.Database.BeginTransaction(); PurchaseOrder order = db.PurchaseOrders.Where(o => o.PurchaseOrderId == OrderId).FirstOrDefault(); ICollection <PurchaseOrderItem> OrderItems = db.PurchaseOrderItems.Where(i => i.PurchaseOrderId == OrderId).ToList(); StockEntry stockEntry; order.OrderStatus = true; long[] batchNumbers = BatchNumbers.ToArray(); DateTime[] expiryDates = ExpiryDates.ToArray(); int counter = 0; foreach (var OrderItem in OrderItems) { OrderItem.BatchNumber = batchNumbers[counter]; OrderItem.ExpiryDate = expiryDates[counter++]; db.PurchaseOrderItems.Attach(OrderItem); db.Entry(OrderItem).State = EntityState.Modified; stockEntry = new StockEntry { MedicineId = OrderItem.MedicineId, PurchaseOrderId = OrderItem.PurchaseOrderId, BatchNumber = OrderItem.BatchNumber.ToString(), Quantity = OrderItem.Quantity, CostPrice = OrderItem.CostPrice, SellingPrice = OrderItem.SellingPrice, ExpiryDate = OrderItem.ExpiryDate }; db.StockEntries.Add(stockEntry); } db.SaveChanges(); db.PurchaseOrders.Attach(order); db.Entry(order).State = EntityState.Modified; db.SaveChanges(); db.Database.CurrentTransaction.Commit(); } catch (Exception ex) { Console.WriteLine(ex.Message); db.Database.CurrentTransaction.Rollback(); } } return(RedirectToAction("PurchaseOrdersList")); }
public ActionResult NewMedicine() { using (PharmAssistantContext db = new PharmAssistantContext()) { ViewBag.Manufacturers = Manufacturers; // new SelectList(db.Manufacturers.ToList(), "ManufacturerId", "Name"); ViewBag.Categories = Categories; // new SelectList(db.MedicineCategories.ToList(), "CategoryId", "Name"); //ViewBag.Suppliers = Suppliers; // new SelectList(db.Suppliers.ToList(), "SupplierId", "Name"); ViewBag.Shelves = Shelves; // new SelectList(db.Shelves.ToList(), "ShelfId", "ShelfName"); } return(View(new Medicine())); }
public ActionResult EditMedicine(int MedicineId) { using (PharmAssistantContext db = new PharmAssistantContext()) { ViewBag.Manufacturers = Manufacturers; ViewBag.Categories = Categories; ViewBag.Shelves = Shelves; Medicine Medicine = db.Medicines.Where(m => m.MedicineId == MedicineId).FirstOrDefault(); return(View(Medicine)); } }
public ActionResult AddMedicineToOrder(PurchaseOrderItem PurchaseOrderItem) { using (PharmAssistantContext db = new PharmAssistantContext()) { PurchaseOrderViewModel PurchaseOrderModel; try { var medicine = db.Medicines.Where(m => m.MedicineId == PurchaseOrderItem.MedicineId).FirstOrDefault(); PurchaseOrderItem.SellingPrice = medicine.SellingPrice; PurchaseOrderItem.MedicineName = medicine.MedicineName; if (Session["PurchaseOrderModel"] == null) { PurchaseOrderModel = new PurchaseOrderViewModel(); PurchaseOrderModel.PurchaseOrderItems = new List <PurchaseOrderItem>(); PurchaseOrderModel.PurchaseOrderItems.Add(PurchaseOrderItem); Session["PurchaseOrderModel"] = PurchaseOrderModel; } else { PurchaseOrderModel = (PurchaseOrderViewModel)Session["PurchaseOrderModel"]; if (PurchaseOrderModel.PurchaseOrderItems.Where(i => i.MedicineId == PurchaseOrderItem.MedicineId).Count() > 0) { throw new Exception(PurchaseOrderItem.MedicineName + " already exists in order."); } PurchaseOrderModel.PurchaseOrderItems.Add(PurchaseOrderItem); Session["PurchaseOrderModel"] = PurchaseOrderModel; } } catch (Exception ex) { if (ex.Message.Contains(" already exists in order.")) { Response.StatusCode = (int)HttpStatusCode.BadRequest; // Or another code return(Json(new { message = ex.Message })); } else { //return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, "Something went wrong. Try again later."); Response.StatusCode = (int)HttpStatusCode.BadRequest; // Or another code return(Json(new { message = "Something went wrong. Please try again." })); } } return(PartialView("_PurchaseOrderItems", PurchaseOrderModel)); } }
public ActionResult GetMembershipById(int membershipId) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { return(Json(db.MembershipAccounts.Where(m => m.MembershipId == membershipId).FirstOrDefault(), JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } }
public static AppUserManager Create(IdentityFactoryOptions <AppUserManager> options, IOwinContext context) { PharmAssistantContext db = context.Get <PharmAssistantContext>(); AppUserManager manager = new AppUserManager(new UserStore <AppUser>(db)); manager.PasswordValidator = new PasswordValidator { RequiredLength = 6, RequireNonLetterOrDigit = false, RequireDigit = false, RequireLowercase = true, RequireUppercase = true }; return(manager); }
public ActionResult GetMembershipTypes() { try { using (PharmAssistantContext db = new PharmAssistantContext()) { return(Json(db.MembershipTypes.ToList(), JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); } }
private List <Manufacturer> GetAllManufacturers() { try { using (PharmAssistantContext db = new PharmAssistantContext()) { return(db.Manufacturers.ToList()); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(null); }
public ActionResult EditCustomer(int CustomerId) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { return(View(db.Customers.Where(c => c.CustomerId == CustomerId).FirstOrDefault())); } } catch (Exception ex) { Console.WriteLine(ex.Message); TempData["ErrorMessage"] = "Unable to edit customer. Please try again later."; return(RedirectToAction("Index")); } }
public JsonResult GetMedicineCategories(int SupplierId) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { var MedicineCategories = db.MedicineCategories.Where(m => m.Suppliers.Contains(db.Suppliers.Where(s => s.SupplierId == SupplierId).FirstOrDefault())).Select(m => new { CategoryId = m.CategoryId, MedicineCategotyName = m.MedicineCategoryName.Trim() }).ToList(); return(Json(MedicineCategories, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(Json(new { }, JsonRequestBehavior.AllowGet)); } }
private ICollection <MedicineCategory> GetAllCategories() { try { using (PharmAssistantContext db = new PharmAssistantContext()) { return(db.MedicineCategories.ToList()); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(null); }
public List <InventoryViewModel> GetInventorySettings(int CategoryId = -1) { List <InventoryViewModel> InventoryStock; try { ViewBag.MedicineCategories = MedicineCategories; using (PharmAssistantContext db = new PharmAssistantContext()) { InventoryStock = new List <InventoryViewModel>(); var InventoryData = from m in db.Medicines select new { CategoryId = m.CategoryId, MedicineId = m.MedicineId, MedicineName = m.MedicineName, StockCapacity = m.StockCapacity, ReorderLevel = m.ReorderLevel, BufferLevel = m.BufferLevel }; if (CategoryId != -1) { InventoryData = InventoryData.Where(m => m.CategoryId == CategoryId); } foreach (var data in InventoryData) { InventoryStock.Add(new InventoryViewModel { MedicineId = data.MedicineId, MedicineName = data.MedicineName, StockCapacity = data.StockCapacity, ReorderLevel = data.ReorderLevel, BufferLevel = data.BufferLevel }); } return(InventoryStock); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }
public ActionResult DeleteMedicine(int MedicineId) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { db.Medicines.Remove(db.Medicines.Where(m => m.MedicineId == MedicineId).FirstOrDefault()); db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(RedirectToAction("MedicinesList")); }
private ICollection <Medicine> GetAllMedicines() { try { using (PharmAssistantContext db = new PharmAssistantContext()) { var Medicines = db.Medicines.Include("MedicineCategory").Include("Shelf").Include("Manufacturer").ToList(); return(Medicines); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }
public ActionResult EditUser(string id) { UserViewModel userData = new UserViewModel();; using (PharmAssistantContext db = new PharmAssistantContext()) { AppUser user = UserManager.FindById(id); userData.User = new CreateUserModel { Name = user.UserName, PhoneNumber = long.Parse(user.PhoneNumber), Email = user.Email, City = user.City }; userData.UsersList = UserManager.Users; } ViewBag.UserId = id; return(View("Index", userData)); }
public ActionResult DeleteCategory(long Id) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { MedicineCategory existingCategory = db.MedicineCategories.Where(c => c.CategoryId == Id).FirstOrDefault(); db.MedicineCategories.Remove(existingCategory); db.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(RedirectToAction("MedicineCategories")); }
public JsonResult GetMedicines(int CategoryId) { try { using (PharmAssistantContext db = new PharmAssistantContext()) { var Medicines = db.Medicines.Where(m => m.CategoryId == CategoryId).Select(m => new { MedicineId = m.MedicineId, Name = m.MedicineName.Trim() }).ToList(); return(Json(Medicines, JsonRequestBehavior.AllowGet)); //return Json(new { }, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(Json(new { }, JsonRequestBehavior.AllowGet)); } }
// GET: PurchaseOrders public ActionResult PurchaseOrdersList() { try { using (PharmAssistantContext db = new PharmAssistantContext()) { ICollection <PurchaseOrder> PurchaseOrders = db.PurchaseOrders.Include("Supplier").ToList(); return(View(PurchaseOrders)); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(View(new List <PurchaseOrder>())); } }