public override bool IsUserInRole(string username, string roleName)
{
using (MaaseDBEntities db = new MaaseDBEntities())
{
T_Users user = db.T_Users.FirstOrDefault(u => u.UserName.Equals(username, StringComparison.CurrentCultureIgnoreCase));
var roles = from ur in user.T_UsersInRoles
from r in db.T_UserRoles
where ur.RoleId == r.RoleId
select r.RoleName;
if (user != null)
{
return(roles.Any(r => r.Equals(roleName, StringComparison.CurrentCultureIgnoreCase)));
}
else
{
return(false);
}
}
}
public override string[] GetRolesForUser(string username)
{
using (MaaseDBEntities db = new MaaseDBEntities())
{
T_Users user = db.T_Users.FirstOrDefault(u => u.UserName.Equals(username, StringComparison.CurrentCultureIgnoreCase));
var roles = from ur in user.T_UsersInRoles
from r in db.T_UserRoles
where ur.RoleId == r.RoleId
select r.RoleName;
if (roles != null)
{
return(roles.ToArray());
}
else
{
return new string[] { }
};;
}
}
public ActionResult LogOn(Account loginInfo, string returnUrl, FormCollection frm)
{
if (frm["DBYear"].ToString() != "")
{
Session["DBConnection"] = frm["DBYear"].ToString();
Session["ReportConnection"] = "report" + frm["DBYear"].ToString().Substring(15);
Session["DBYearName"] = frm["DBYear"].ToString().Substring(15) + " سال";
//Statics.dbconnection = frm["DBYear"].ToString();
//Session["ReportConnection"].ToString() = "report"+frm["DBYear"].ToString().Substring(15);
//Statics.DBYearName = frm["DBYear"].ToString().Substring(15)+" سال";
}
else
{
Session["DBYearName"] = "";
Session["ReportConnection"] = "";
Session["DBYearName"] = "";
}
string a = Session["DBYearName"].ToString();
string b = Session["ReportConnection"].ToString();
string c = Session["DBYearName"].ToString();
db = new MaaseDBEntities();
if (this.ModelState.IsValid)
{
if (LoginUser(loginInfo.Username, loginInfo.Password))
{
FormsAuthentication.SetAuthCookie(loginInfo.Username, loginInfo.RememberMe);
if (shouldRedirect(returnUrl))
{
return(Redirect(returnUrl));
}
FormsAuthentication.RedirectFromLoginPage(loginInfo.Username, loginInfo.RememberMe);
}
ViewBag.err = "نام کاربری یا رمز عبور اشتباه است";
}
List <DataBase> dblist = Statics.GetDataDases();
List <SelectListItem> list = new List <SelectListItem>();
for (int i = 0; i < dblist.Count; i++)
{
SelectListItem s = new SelectListItem();
s.Text = dblist[i].Text;
s.Value = dblist[i].DBName;
list.Add(s);
}
SelectList sl = new SelectList(list.OrderByDescending(m => m.Value), "Value", "Text");
ViewBag.DBYear = sl;
//ViewBag.Error = "Login faild! Make sure you have entered the right user name and password!";
return(View(loginInfo));
}
