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>()));
}
}
