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 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 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 JsonResult LineChart() { DateTime dt = Convert.ToDateTime(DateTime.Today); List <ClosingDisplay> lstclose = new List <ClosingDisplay>(); List <tblUserRole> lstur = _db.tblUserRoles.Where(u => u.RoleId == 2).ToList(); foreach (var ur in lstur) { tblUser tb = _db.tblUsers.Where(u => u.UserId == ur.UserId).FirstOrDefault(); tblUserBranch tub = _db.tblUserBranches.Where(u => u.UserId == ur.UserId).FirstOrDefault(); tblBranch tbbra = _db.tblBranches.Where(b => b.BranchId == tub.BranchId).FirstOrDefault(); decimal amount = 0M; List <tblInvoice> lst = _db.tblInvoices.Where(t => t.InvoiceDate == dt).Where(u => u.UserId == ur.UserId).ToList(); if (lst.Count > 0) { foreach (var item in lst) { amount += Convert.ToDecimal(item.NetAmount); } ClosingDisplay cd = new ClosingDisplay(); cd.UserId = ur.UserId; cd.TotalAmount = amount; cd.Username = tb.Username; cd.BranchName = tbbra.BranchName; cd.BranchId = tbbra.BranchId; lstclose.Add(cd); } } List <object> iData = new List <object>(); //Creating sample data DataTable dtt = new DataTable(); dtt.Columns.Add("Username", System.Type.GetType("System.String")); dtt.Columns.Add("TotalAmount", System.Type.GetType("System.Decimal")); foreach (var item in lstclose) { DataRow dr = dtt.NewRow(); dr["Username"] = item.Username; dr["TotalAmount"] = item.TotalAmount; dtt.Rows.Add(dr); } //Looping and extracting each DataColumn to List<Object> foreach (DataColumn dc in dtt.Columns) { List <object> x = new List <object>(); x = (from DataRow drr in dtt.Rows select drr[dc.ColumnName]).ToList(); iData.Add(x); } //Source data returned as JSON return(Json(iData, JsonRequestBehavior.AllowGet)); }
public ActionResult MakeClosing() { DateTime dt = Convert.ToDateTime(DateTime.Today); List <ClosingDisplay> lstclose = new List <ClosingDisplay>(); List <tblUserRole> lstur = db.tblUserRoles.Where(u => u.RoleId == 2).ToList(); foreach (var ur in lstur) { tblUser tb = db.tblUsers.Where(u => u.UserId == ur.UserId).FirstOrDefault(); bool i = cdb.CheckClosingDate(tb.UserId); if (!i) { tblUserBranch tub = db.tblUserBranches.Where(u => u.UserId == ur.UserId).FirstOrDefault(); tblBranch tbbra = db.tblBranches.Where(b => b.BranchId == tub.BranchId).FirstOrDefault(); decimal amount = 0M; List <tblInvoice> lst = db.tblInvoices.Where(t => t.InvoiceDate == dt).Where(u => u.UserId == ur.UserId).ToList(); if (lst.Count > 0) { foreach (var item in lst) { amount += Convert.ToDecimal(item.NetAmount); } ClosingDisplay cd = new ClosingDisplay(); cd.UserId = ur.UserId; cd.TotalAmount = amount; cd.Username = tb.Username; cd.BranchName = tbbra.BranchName; cd.BranchId = tbbra.BranchId; lstclose.Add(cd); } ViewBag.Records = lstclose; } } return(View()); }