public List <Roles_Model> GetUserbyRoles(string usename)
{
using (SqlConnection con = new SqlConnection(cs))
{
List <Roles_Model> Grol = new List <Roles_Model>();
Roles_Model Obj = new Roles_Model();;
//LoginEntity userDetail = new LoginEntity();
con.Open();
SqlCommand cmd = new SqlCommand("spGetUserByRole", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", usename);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
isnull = false;
Obj = new Roles_Model();
Obj.User_id = Convert.ToInt32(dr["EmpId"]);
Obj.User_type = dr["UserType"].ToString();
//Obj.Password = dr["Password"].ToString();
Grol.Add(Obj);
}
if (isnull)
{
return(null);
}
else
{
return(Grol);
}
}
}
}
public ActionResult UserLogin(LoginModel loginObj, string returnUrl)
{
try
{
LoginBL loginBl = new LoginBL();
// UserRolesDetail rol = new UserRolesDetail();
LoginEntity loginEntity = new LoginEntity();
LoginEntity newloginEntity = new LoginEntity();
Roles_Model rm = new Roles_Model();
LoginModel loginmodel = new LoginModel();
int i = 0;
// string UserType = "";
if (ModelState.IsValid)
{
loginEntity.UserName = loginObj.UserName;
loginEntity.Password = loginObj.Password;
i = loginBl.UserLoginCheck(loginEntity);
if (i == 1)
{
newloginEntity = loginBl.GetUserDetails(loginEntity);
Session["Username"] = newloginEntity.UserName;
Session["UserType"] = newloginEntity.UserType;
Session["Password"] = newloginEntity.Password;
Session["UserPage"] = newloginEntity.Userpage;
Session["Controler_Name"] = newloginEntity.ActionName;
FormsAuthentication.SetAuthCookie(Session["Username"].ToString(), false);
Username = Session["Username"].ToString();
// int IsAuth=loginBl.UserPageAuth(Session["Username"].ToString(), Session["UserType"].ToString());
var Toppage = loginBl.GetTopPageMenu(Session["Username"].ToString());
return(Redirect(returnUrl ?? Url.Action(Toppage.Userpage, Toppage.ActionName)));
// return RedirectToAction(Toppage.Userpage.ToString(), Toppage.Controller_Name.ToString());
}
ModelState.AddModelError("", "Incorrect Username and Password");
Session["Username"] = "";
Session["Password"] = "";
Session["UserType"] = "";
Session["UserId"] = "";
}
}
catch (Exception ex)
{
}
return(View("LoginPage"));
}
// [Authorize]
public ActionResult UserLogin(LoginModel loginObj, string returnUrl)
{
try
{
LoginBL loginBl = new LoginBL();
LoginEntity loginEntity = new LoginEntity();
LoginEntity newloginEntity = new LoginEntity();
Roles_Model rm = new Roles_Model();
LoginModel loginmodel = new LoginModel();
int i = 0;
if (ModelState.IsValid)
{
loginEntity.UserName = loginObj.UserName;
loginEntity.Password = loginObj.Password;
i = loginBl.UserLoginCheck(loginEntity);
if (i == 1)
{
newloginEntity = loginBl.GetUserDetails(loginEntity);
Session["Username"] = newloginEntity.UserName;
Session["UserType"] = newloginEntity.UserType;
Session["Password"] = newloginEntity.Password;
Session["UserPage"] = newloginEntity.Userpage;
Session["Controler_Name"] = newloginEntity.ActionName;
Session["UserID"] = Convert.ToString(newloginEntity.UserId);
string Loginame = Request.Form["UserName"].ToString();
Username = Session["Username"].ToString();
Password = Session["Password"].ToString();
if (Loginame.ToUpper() == Username.ToUpper())
{
FormsAuthentication.SetAuthCookie(Session["Username"].ToString(), true);
var Toppage = loginBl.GetTopPageMenu(Session["Username"].ToString());
return(Redirect(returnUrl ?? Url.Action(Toppage.Userpage, Toppage.ActionName)));
}
}
ModelState.AddModelError("", "Incorrect Username and Password");
Session["Username"] = "";
Session["Password"] = "";
Session["UserType"] = "";
Session["UserId"] = "";
FormsAuthentication.SignOut();
Session.Abandon();
}
}
catch (Exception ex)
{
}
return(View("LoginPage"));
}
public List <Roles_Model> GetUser_Roles(string usename, string User_type)
{
List <Roles_Model> objget = new List <Roles_Model>();
using (SqlConnection con = new SqlConnection(cs))
{
Roles_Model Obj;
//LoginEntity userDetail = new LoginEntity();
con.Open();
SqlCommand cmd = new SqlCommand("spGetPageByRoles", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserName", usename);
cmd.Parameters.AddWithValue("@User_Type", User_type);
bool isnull = true;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Obj = new Roles_Model();
isnull = false;
//userLogin =
Obj.User_type = dr["RolName"].ToString();
Obj.Page_name = dr["Page_Name"].ToString();
Obj.ActionName = dr["ActionName"].ToString();
Obj.MenuLink = dr["Menu_Link"].ToString();
// Obj.
objget.Add(Obj);
}
if (isnull)
{
return(null);
}
else
{
return(objget);
}
}
}
}
public static List <Roles_Model> ListarRoles()
{
var Roles = new List <Roles_Model>();
var DtResultados = new DataTable("Lista_Roles");
try
{
SqlCon.Open();
SqlCommand SqlCmd = new SqlCommand("spRoles_Listar", SqlCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter SqlDta = new SqlDataAdapter(SqlCmd);
SqlDta.Fill(DtResultados);
foreach (DataRow item in DtResultados.Rows)
{
var obj = new Roles_Model()
{
IdRol = (int)item[0],
Descripcion = (string)item[1],
Estado = (int)item[2],
IdUsuario = (int)item[3],
FechaCreacion = (DateTime)item[4],
FechaActualizacion = (DateTime)item[5]
};
Roles.Add(obj);
}
}
catch (Exception ex)
{
Roles = null;
MessageBox.Show(ex.ToString(), "SAIP", MessageBoxButton.OK, MessageBoxImage.Error);
}
finally
{
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
return(Roles);
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
var list = "";
LoginBL loginBl = new LoginBL();
List <Roles_Model> rol = new List <Roles_Model>();
List <Roles_Model> Pages = new List <Roles_Model>();
Roles_Model findpage;
Roles_Model obj = new Roles_Model();
var isAuthorised = base.AuthorizeCore(httpContext);
if (isAuthorised == false)
{
return(false);
}
string CurrentUser = HttpContext.Current.User.Identity.Name.ToString();
if (CurrentUser != null && CurrentUser != " ")
{
var rd = httpContext.Request.RequestContext.RouteData;
string currentAction = rd.GetRequiredString("action");
string currentController = rd.GetRequiredString("controller");
rol = loginBl.GetUserroles(CurrentUser);
string[] UR = new string[1];
foreach (Roles_Model item in rol)
{
UR[0] = item.User_type.ToString();
}
Pages = loginBl.GetPagebyroles(CurrentUser, UR[0].ToString());
int i = 0;
if (Pages != null)
{
string[] arrpage = new string[Pages.Count];
foreach (Roles_Model itm in Pages)
{
arrpage[i] = itm.Page_name.ToString();
//findpage = new Roles_Model();
//findpage.Page_name = item.Page_name;
i++;
}
list = Array.Find(arrpage,
element => element.StartsWith(currentAction,
StringComparison.Ordinal));
}
if (list == currentAction)
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
//return isAuthorised;
}