public ActionResult Create([Bind(Include = "MedPot_Id,Medicine_Id,Potency_Id,Price,ExpiryDate,NoOfItem")] MedicinePotency medicinePotency) { if (ModelState.IsValid) { MedicinePotency meddpot = db.MedicinePotencies.FirstOrDefault(u => u.Medicine_Id == (medicinePotency.Medicine_Id) && u.Potency_Id == medicinePotency.Potency_Id); if (meddpot == null) { db.MedicinePotencies.Add(medicinePotency); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("Medicine_Id", "Medicine with given potency is alredy present in Record."); ViewBag.Medicine_Id = new SelectList(db.Medicines, "Medicine_Id", "Name", medicinePotency.Medicine_Id); ViewBag.Potency_Id = new SelectList(db.Potencies, "Potency_Id", "Potency_Id", medicinePotency.Potency_Id); return(View(medicinePotency)); } } ViewBag.Medicine_Id = new SelectList(db.Medicines, "Medicine_Id", "Name", medicinePotency.Medicine_Id); ViewBag.Potency_Id = new SelectList(db.Potencies, "Potency_Id", "Potency_Id", medicinePotency.Potency_Id); return(View(medicinePotency)); }
public ActionResult Create([Bind(Include = "Medicine_Id,Name,Description,ExpiryDate,CategoryID,SupplierID")] Medicine medicine) { Medicine medicines = db.Medicines.FirstOrDefault(u => u.Name == medicine.Name); if (ModelState.IsValid) { if (medicines == null) { db.Medicines.Add(medicine); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("Name", "Medicine with same name is Alredy Present."); ViewBag.CategoryID = new SelectList(db.Categories, "Category_Id", "Category_Name", medicine.CategoryID); ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "CompanyName", medicine.SupplierID); return(View(medicine)); } } ViewBag.CategoryID = new SelectList(db.Categories, "Category_Id", "Category_Name", medicine.CategoryID); ViewBag.SupplierID = new SelectList(db.Suppliers, "SupplierID", "CompanyName", medicine.SupplierID); return(View(medicine)); }
public ActionResult Create([Bind(Include = "SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Country,Fax")] Supplier supplier) { if (ModelState.IsValid) { db.Suppliers.Add(supplier); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(supplier)); }
public ActionResult Create([Bind(Include = "Customer_Id,Customer_Name,Contact,Address,Added_On")] Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult SignUp([Bind(Include = "FirstName,LastName,Contact,Email,Address,Country,DateOfBirth,Gender,Discriminator,Password,ConfirmPassword ")] User userrr) { using (DB53Entities db = new DB53Entities()) { Person persuser = db.People.FirstOrDefault(u => u.Email == (userrr.Email)); if (userrr.Discriminator == "Admin") { Login oldlog = db.Logins.FirstOrDefault(u => u.Discriminator == userrr.Discriminator); if (oldlog != null) { ModelState.AddModelError("Discriminator", "Admin is alredy present. There can be only one Admin."); return(View(userrr)); } } if (persuser == null) { Person pers = new Person(); pers.Address = userrr.Address; pers.Contact = userrr.Contact; pers.Country = userrr.Country; pers.DateOfBirth = userrr.DateOfBirth; pers.Email = userrr.Email; pers.FirstName = userrr.FirstName; pers.LastName = userrr.LastName; pers.Gender = userrr.Gender; db.People.Add(pers); db.SaveChanges(); Person user = db.People.FirstOrDefault(newuser => newuser.Email == (userrr.Email)); Login newlog = new Login(); newlog.Login_Id = user.Id; newlog.Email = userrr.Email; newlog.Password = userrr.Password; newlog.Discriminator = userrr.Discriminator; db.Logins.Add(newlog); db.SaveChanges(); return(RedirectToAction("Index", "People")); } else { return(View()); } } }
public ActionResult Create([Bind(Include = "Category_Id,Category_Name,Discription")] Category category) { if (ModelState.IsValid) { Category cat = db.Categories.FirstOrDefault(u => u.Category_Name == category.Category_Name); if (cat == null) { db.Categories.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("Category_Name", "Category already added"); return(View(category)); } } return(View(category)); }
public ActionResult Create([Bind(Include = "Staff_Id,Salary,Designation")] Staff staff) { if (ModelState.IsValid) { Staff user = db.Staffs.FirstOrDefault(u => u.Staff_Id == staff.Staff_Id); if (user == null) { db.Staffs.Add(staff); db.SaveChanges(); return(RedirectToAction("Index")); } else { ModelState.AddModelError("Staff_Id", "Staff Already Added."); ViewBag.Staff_Id = new SelectList(db.People, "Id", "FirstName", staff.Staff_Id); return(View(staff)); } } ViewBag.Staff_Id = new SelectList(db.People, "Id", "FirstName", staff.Staff_Id); return(View(staff)); }
public ActionResult Create([Bind(Include = "Sold_Id,NoOfItem,Date,Staff_Id,Customer_Id,Medicine_Id,Potency_Id")] SalesObjectclass salesobj) { Sale sale = new Sale(); MedicinePotency medpot = db.MedicinePotencies.FirstOrDefault(u => u.Medicine_Id == salesobj.Medicine_Id && u.Potency_Id == salesobj.Potency_Id); if (medpot != null) { if (medpot.NoOfItem >= salesobj.NoOfItem) { if (ModelState.IsValid) { sale.MedPot_Id = medpot.MedPot_Id; sale.NoOfItem = salesobj.NoOfItem; sale.Staff_Id = salesobj.Staff_Id; sale.Date = salesobj.Date; sale.Customer_Id = salesobj.Customer_Id; db.Sales.Add(sale); db.SaveChanges(); medpot.NoOfItem = (medpot.NoOfItem) - (salesobj.NoOfItem); db.Entry(medpot).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } else { ModelState.AddModelError("NoOfItem", "Medicine is out of stock."); ViewBag.Customer_Id = new SelectList(db.Customers, "Customer_Id", "Customer_Name", salesobj.Customer_Id); ViewBag.Medicine_Id = new SelectList(db.Medicines, "Medicine_Id", "Name", salesobj.Medicine_Id); ViewBag.Potency_Id = new SelectList(db.Potencies, "Potency_Id", "Potency_mg", salesobj.Potency_Id); ViewBag.Staff_Id = new SelectList(db.People, "Id", "FirstName", salesobj.Staff_Id); return(View(salesobj)); } } ViewBag.Customer_Id = new SelectList(db.Customers, "Customer_Id", "Customer_Name", salesobj.Customer_Id); ViewBag.Medicine_Id = new SelectList(db.Medicines, "Medicine_Id", "Name", salesobj.Medicine_Id); ViewBag.Potency_Id = new SelectList(db.Potencies, "Potency_Id", "Potency_mg", salesobj.Potency_Id); ViewBag.Staff_Id = new SelectList(db.People, "Id", "FirstName", salesobj.Staff_Id); return(View(salesobj)); }
public ActionResult Create([Bind(Include = "Id,FirstName,LastName,Contact,Email,Address,Country,DateOfBirth,Gender,Discriminator")] Person person) { string pass = "******"; Login newuser = new Login(); newuser.Login_Id = person.Id; newuser.Password = pass; newuser.Email = person.Email; newuser.Discriminator = "Admin"; if (ModelState.IsValid) { db.People.Add(person); db.Logins.Add(newuser); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Id = new SelectList(db.Logins, "Login_Id", "Email", person.Id); ViewBag.Id = new SelectList(db.Staffs, "Staff_Id", "Designation", person.Id); return(View(person)); }