public List <ListMenuByUserLoginViewModal> ListMenuByIdUserLogin(int roleid, int userid, int branchId, int idMember, int idrole)
{
try
{
var db = new DB_CSEntities1();
List <ListMenuByUserLoginViewModal> list = new List <ListMenuByUserLoginViewModal>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("sp_getall_menu_import_to_account_member", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@roleid", roleid));
cmd.Parameters.Add(new SqlParameter("@userid", userid));
cmd.Parameters.Add(new SqlParameter("@idMember", idMember));
cmd.Parameters.Add(new SqlParameter("@idRoleMem", idrole));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
int idParent = 0;
ListMenuByUserLoginViewModal item = new ListMenuByUserLoginViewModal();
item.MenuId = Int32.Parse(rowItem["MenuId"].ToString());
item.MenuText = rowItem["MenuText"].ToString();
item.MenuURL = rowItem["MenuURL"].ToString();
int.TryParse(rowItem["ParentId"].ToString(), out idParent);
item.ParentId = idParent;
list.Add(item);
}
return(list);
}
catch (Exception e)
{
return(null);
}
}
public List <ListMenuByUserLoginViewModal> BS_Danhsachmenuthemmoivaoquyen(int roleid_login, int userid, int idrole)
{
try
{
var db = new DB_CSEntities1();
List <ListMenuByUserLoginViewModal> list = new List <ListMenuByUserLoginViewModal>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("Role_ListMenuThemMoiVaoRole", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@roleid_login", roleid_login));
cmd.Parameters.Add(new SqlParameter("@userid", userid));
cmd.Parameters.Add(new SqlParameter("@idrole_add", idrole));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
int idParent = 0;
ListMenuByUserLoginViewModal item = new ListMenuByUserLoginViewModal();
item.MenuId = Int32.Parse(rowItem["MenuId"].ToString());
item.MenuText = rowItem["MenuText"].ToString();
item.MenuURL = rowItem["MenuURL"].ToString();
int.TryParse(rowItem["ParentId"].ToString(), out idParent);
item.ParentId = idParent;
list.Add(item);
}
return(list);
}
catch (Exception e)
{
return(null);
}
}
public List <ListMenuByUserLoginViewModal> ListMenuByIdUserLogin(int roleid, int userid, int branchId, int idrole)
{
try
{
var db = new DB_CSEntities1();
List <ListMenuByUserLoginViewModal> list = new List <ListMenuByUserLoginViewModal>();
var checkMenuInvailRole =
db.MenuPermission.FirstOrDefault(m => m.RoleId == idrole && m.UserId == null);
if (checkMenuInvailRole != null)
{
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("[sp_getall_menubyparent]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@roleid", roleid));
cmd.Parameters.Add(new SqlParameter("@userid", userid));
//cmd.Parameters.Add(new SqlParameter("@idRoleMem", idrole));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
int idParent = 0;
ListMenuByUserLoginViewModal item = new ListMenuByUserLoginViewModal();
// item.id = Int32.Parse(rowItem["Id"].ToString());
item.MenuId = Int32.Parse(rowItem["MenuId"].ToString());
item.MenuText = rowItem["MenuText"].ToString();
item.MenuURL = rowItem["MenuURL"].ToString();
int.TryParse(rowItem["ParentId"].ToString(), out idParent);
item.ParentId = idParent;
var kq = db.MenuPermission.FirstOrDefault(x =>
(x.RoleId == idrole && x.MenuId == item.MenuId && x.UserId == null));
if (kq != null)
{
item.trangthai = 1;
}
else
{
item.trangthai = 0;
}
bool IsRead = false;
bool IsCreate = false;
bool IsUpdate = false;
bool IsDelete = false;
bool IsExport = false;
bool.TryParse(rowItem["IsRead"].ToString(), out IsRead);
bool.TryParse(rowItem["IsCreate"].ToString(), out IsCreate);
bool.TryParse(rowItem["IsUpdate"].ToString(), out IsUpdate);
bool.TryParse(rowItem["IsDelete"].ToString(), out IsDelete);
bool.TryParse(rowItem["IsExport"].ToString(), out IsExport);
item.IsRead = IsRead;
item.IsCreate = IsCreate;
item.IsUpdate = IsUpdate;
item.IsDelete = IsDelete;
item.IsExport = IsExport;
list.Add(item);
}
return(list);
}
else
{
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("[sp_getall_menubyparent]", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@roleid", roleid));
cmd.Parameters.Add(new SqlParameter("@userid", userid));
// cmd.Parameters.Add(new SqlParameter("@idRoleMem", idrole));
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow rowItem in dt.Rows)
{
int idParent = 0;
ListMenuByUserLoginViewModal item = new ListMenuByUserLoginViewModal();
// item.id = Int32.Parse(rowItem["Id"].ToString());
item.MenuId = Int32.Parse(rowItem["MenuId"].ToString());
item.MenuText = rowItem["MenuText"].ToString();
item.MenuURL = rowItem["MenuURL"].ToString();
int.TryParse(rowItem["ParentId"].ToString(), out idParent);
item.ParentId = idParent;
bool IsRead = false;
bool IsCreate = false;
bool IsUpdate = false;
bool IsDelete = false;
bool IsExport = false;
bool.TryParse(rowItem["IsRead"].ToString(), out IsRead);
bool.TryParse(rowItem["IsCreate"].ToString(), out IsCreate);
bool.TryParse(rowItem["IsUpdate"].ToString(), out IsUpdate);
bool.TryParse(rowItem["IsDelete"].ToString(), out IsDelete);
bool.TryParse(rowItem["IsExport"].ToString(), out IsExport);
item.IsRead = IsRead;
item.IsCreate = IsCreate;
item.IsUpdate = IsUpdate;
item.IsDelete = IsDelete;
item.IsExport = IsExport;
list.Add(item);
}
return(list);
}
}
catch (Exception e)
{
return(null);
}
}
