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);
}