public override string[] GetRolesForUser(string username) { using (EcommerceDBEntities _db = new EcommerceDBEntities()) { var objUser = _db.tblUsers.FirstOrDefault(u => u.Username == username); if (objUser == null) { return(null); } else { string[] rtn = objUser.tblUserRoles.Select(u => u.tblRole.roleName).ToArray(); return(rtn); } } }
public ActionResult Login(LoginViewModel l, string ReturnUrl = "") { using (EcommerceDBEntities _db = new EcommerceDBEntities()) { var users = _db.tblUsers.Where(u => u.Username == l.Username && u.Password == l.Password).FirstOrDefault(); if (users != null) { FormsAuthentication.SetAuthCookie(l.Username, l.Rememberme); if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } else { return(RedirectToAction("Index", "Home")); } } else { ModelState.AddModelError("", "InvalidUser!!!"); } } return(View()); }
public BaseService() { DBModel = DBHelper.CreateDBConnection(); }
public StockModel() { DBModel = new EcommerceDBEntities(); }
public LogModel() { DBModel = new EcommerceDBEntities(); }
public static EcommerceDBEntities CreateDBConnection() { DBConnection = DBConnection ?? new EcommerceDBEntities(); return(DBConnection); }