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 ActionResult AddOrEdit(int id = 0) { if (id == 0) { using (ELaundryDBEntities db = new ELaundryDBEntities()) { ViewBag.Categories = db.tblCategories.ToList(); return(View(new GarmentViewModel())); } } else { using (ELaundryDBEntities db = new ELaundryDBEntities()) { ViewBag.Categories = db.tblCategories.ToList(); GarmentViewModel sub = new GarmentViewModel(); var menu = db.tblGarments.Where(x => x.GarmentId == id).FirstOrDefault(); sub.GarmentId = menu.GarmentId; sub.GarmentName = menu.GarmentName; sub.UnitPrice = menu.UnitPrice; sub.CategoryId = menu.tblCategory.CategoryId; return(View(sub)); } } }
public JsonResult GetData() { using (ELaundryDBEntities db = new ELaundryDBEntities()) { MyRoleProvider mr = new MyRoleProvider(); db.Configuration.LazyLoadingEnabled = false; List <UserViewModel> lstuser = new List <UserViewModel>(); var lst = db.tblUsers.ToList(); string[] str = new string[] { }; foreach (var item in lst) { string roles = ""; str = mr.GetRolesForUser(item.Username); if (str.Length > 0) { foreach (var r in str) { roles += r.ToString() + ","; } roles = roles.Remove(roles.IndexOf(',')); } tblUserBranch tbub = db.tblUserBranches.Where(u => u.UserId == item.UserId).FirstOrDefault(); tblBranch br = db.tblBranches.Where(u => u.BranchId == tbub.BranchId).FirstOrDefault(); lstuser.Add(new UserViewModel() { UserId = item.UserId, Username = item.Username, Fullname = item.Fullname, RoleName = roles, BranchName = br.BranchName }); } return(Json(new { data = lstuser }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Login(LoginViewModel l, string ReturnUrl = "") { using (ELaundryDBEntities db = new ELaundryDBEntities()) { string password = Utilities.Base64Encode(l.Password); var users = db.tblUsers.Where(a => a.Username == l.Username && a.Password == password).FirstOrDefault(); if (users != null) { tblUserBranch ubra = db.tblUserBranches.Where(u => u.UserId == users.UserId).FirstOrDefault(); Session.Add("branchid", ubra.BranchId); tblBranch br = db.tblBranches.Where(b => b.BranchId == ubra.BranchId).FirstOrDefault(); Session.Add("branchname", br.BranchName); Session.Add("username", users.Username); Session.Add("fullname", users.Fullname); FormsAuthentication.SetAuthCookie(l.Username, true); if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } else { Session.Add("userid", users.UserId); return(RedirectToAction("DashBoard", "Admin")); } } else { ModelState.AddModelError("", "Invalid User"); } } return(View()); }
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 ActionResult AddOrEdit() { using (ELaundryDBEntities db = new ELaundryDBEntities()) { ViewBag.Roles = db.tblRoles.ToList(); ViewBag.Branches = db.tblBranches.ToList(); return(View()); } }
/// <summary>Gets the data.</summary> /// <returns>JsonResult.</returns> public JsonResult GetData() { using (ELaundryDBEntities db = new ELaundryDBEntities()) { db.Configuration.LazyLoadingEnabled = false; List <SettingViewModel> lst = new List <SettingViewModel>(); var empList = db.tblSettings.ToList(); foreach (var x in empList) { lst.Add(new SettingViewModel() { SettingId = x.SettingId, DiscountRate = x.DiscountRate, Description = x.Description, IsActive = x.IsActive }); } return(Json(new { data = lst }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetData() { using (ELaundryDBEntities db = new ELaundryDBEntities()) { db.Configuration.LazyLoadingEnabled = false; List <GarmentViewModel> lstitem = new List <GarmentViewModel>(); var lst = db.tblGarments.Include("tblCategory").ToList(); foreach (var item in lst) { lstitem.Add(new GarmentViewModel() { GarmentId = item.GarmentId, CategoryName = item.tblCategory.CategoryName, GarmentName = item.GarmentName, UnitPrice = item.UnitPrice }); } return(Json(new { data = lstitem }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetData() { using (ELaundryDBEntities db = new ELaundryDBEntities()) { db.Configuration.LazyLoadingEnabled = false; List <CategoryViewModel> lst = new List <CategoryViewModel>(); var empList = db.tblCategories.Select(x => new { CategoryId = x.CategoryId, CategoryName = x.CategoryName }).ToList(); foreach (var item in empList) { lst.Add(new CategoryViewModel() { CategoryId = item.CategoryId, CategoryName = item.CategoryName }); } return(Json(new { data = lst }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { using (ELaundryDBEntities db = new ELaundryDBEntities()) { return(View(new CategoryViewModel())); } } else { using (ELaundryDBEntities db = new ELaundryDBEntities()) { CategoryViewModel sub = new CategoryViewModel(); var menu = db.tblCategories.Where(x => x.CategoryId == id).FirstOrDefault(); sub.CategoryId = menu.CategoryId; sub.CategoryName = menu.CategoryName; return(View(sub)); } } }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { using (ELaundryDBEntities db = new ELaundryDBEntities()) { return(View(new SettingViewModel())); } } else { using (ELaundryDBEntities db = new ELaundryDBEntities()) { SettingViewModel sub = new SettingViewModel(); var menu = db.tblSettings.Where(x => x.SettingId == id).FirstOrDefault(); sub.SettingId = menu.SettingId; sub.DiscountRate = menu.DiscountRate; sub.Description = menu.Description; sub.IsActive = menu.IsActive; return(View(sub)); } } }
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()); } }