public ActionResult AddOrEdit(GarmentViewModel sm) { using (ELaundryDBEntities db = new ELaundryDBEntities()) { if (sm.GarmentId == 0) { tblGarment tb = new tblGarment(); tb.CategoryId = sm.CategoryId; tb.GarmentName = sm.GarmentName; tb.UnitPrice = sm.UnitPrice; db.tblGarments.Add(tb); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { tblGarment tbm = db.tblGarments.Where(m => m.GarmentId == sm.GarmentId).FirstOrDefault(); tbm.CategoryId = sm.CategoryId; tbm.GarmentName = sm.GarmentName; tbm.UnitPrice = sm.UnitPrice; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddOrEdit(SettingViewModel sm) { using (ELaundryDBEntities db = new ELaundryDBEntities()) { if (sm.SettingId == 0) { tblSetting tb = new tblSetting(); tb.DiscountRate = sm.DiscountRate; tb.Description = sm.Description; tb.IsActive = sm.IsActive; db.tblSettings.Add(tb); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { tblSetting tbm = db.tblSettings.Where(m => m.SettingId == sm.SettingId).FirstOrDefault(); tbm.DiscountRate = sm.DiscountRate; tbm.Description = sm.Description; tbm.IsActive = sm.IsActive; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddOrEdit(UserViewModel sm) { using (ELaundryDBEntities db = new ELaundryDBEntities()) { tblUser tb = new tblUser(); string password = Utilities.Base64Encode(sm.Password); tb.Username = sm.Username; tb.Password = password; tb.Fullname = sm.Fullname; db.tblUsers.Add(tb); db.SaveChanges(); tblUserRole tu = new tblUserRole(); tu.RoleId = sm.RoleId; tu.UserId = tb.UserId; db.tblUserRoles.Add(tu); db.SaveChanges(); tblUserBranch br = new tblUserBranch(); br.UserId = tb.UserId; br.BranchId = sm.BranchId; db.tblUserBranches.Add(br); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateGarmentStatus(int id) { tblTempOrder tb = _db.tblTempOrders.Where(k => k.TempOrderId == id).FirstOrDefault(); if (tb != null) { tb.ItemState = "Completed"; _db.SaveChanges(); } return(Json(1, JsonRequestBehavior.AllowGet)); }
public ActionResult Delete(int id) { using (ELaundryDBEntities db = new ELaundryDBEntities()) { tblSetting sm = db.tblSettings.Where(x => x.SettingId == id).FirstOrDefault(); db.tblSettings.Remove(sm); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult InsertClosing(tblClosing tb) { tb.ClosingDateTime = DateTime.Now; db.tblClosings.Add(tb); db.SaveChanges(); return(Json(1, JsonRequestBehavior.AllowGet)); }
public ActionResult ChangePassword(ChangePasswordViewModel ch) { string username = Session["username"].ToString(); string password = Utilities.Base64Encode(ch.OldPassword); tblUser us = _db.tblUsers.Where(u => u.Username == username && u.Password == password).FirstOrDefault(); if (us != null) { string newpassword = Utilities.Base64Encode(ch.NewPassword); us.Password = newpassword; _db.SaveChanges(); ViewBag.Message = "Change Password Successfully"; ModelState.Clear(); } else { ViewBag.Message = "Wrong Old Password"; } return(View()); }
public JsonResult InsertInvoice(tblInvoice tb) { tblInvoice tbl = _db.tblInvoices.OrderByDescending(ti => ti.InvoiceId).Take(1).FirstOrDefault(); tblSetting tbs = _db.tblSettings.OrderByDescending(s => s.SettingId).Take(1).FirstOrDefault(); tblInvoice t = new tblInvoice(); if (tbl != null) { t.InvoiceId = tbl.InvoiceId; } else { t.InvoiceId = 1; } t.OrderId = tb.OrderId; decimal taxamount = Convert.ToDecimal(tb.GrossAmount * 15 / 100); decimal grossamount = Convert.ToDecimal(tb.GrossAmount + taxamount); decimal discountamount = Convert.ToDecimal(tbs.DiscountRate / 100 * grossamount); t.DiscountAmount = discountamount; t.TaxAmount = taxamount; t.GrossAmount = tb.GrossAmount; t.NetAmount = tb.GrossAmount + taxamount - discountamount; t.InvoiceDate = DateTime.Today; t.UserId = Convert.ToInt32(Session["userid"]); t.BranchId = Convert.ToInt32(Session["branchid"]); _db.tblInvoices.Add(t); _db.SaveChanges(); return(Json(1, JsonRequestBehavior.AllowGet)); }
public ActionResult SchedulePickUp(FormCollection collection) { try { // TODO: Add insert logic here ELaundryDBEntities _db = new ELaundryDBEntities(); //Creating variable to get the value string TimeSlot = collection["TimeSlot"]; string FullName = collection["FullName"]; string Phone = collection["Phone"]; string Email = collection["Email"]; string Address = collection["Address"]; string SecondaryAddress = collection["SecondaryAddress"]; string PickupDate = collection["PickupDate"]; string DeliveryDate = collection["DeliveryDate"]; tblSchedulePickup obj = new tblSchedulePickup(); obj.FullName = FullName; obj.Phone = Phone; obj.Email = Email; obj.Address = Address; obj.SecondaryAddress = SecondaryAddress; obj.PickupDate = PickupDate; obj.DeliveryDate = DeliveryDate; obj.TimeSlot = TimeSlot; obj.Userid = 5; _db.tblSchedulePickups.Add(obj); _db.SaveChanges(); return(RedirectToAction("Thankyou")); } catch { return(View()); } }