public LstMenuViewModel BS_ListMenuInRole(string searchValue, int currPage, int recodperpage, int Id)
{
LstMenuViewModel result = new LstMenuViewModel();
try
{
List <Menureturn> list = new List <Menureturn>();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("Role_ListMenuInRole", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Id", Id));
cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue));
cmd.Parameters.Add(new SqlParameter("@currPage", currPage));
cmd.Parameters.Add(new SqlParameter("@recodperpage", 10));
cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
int total = Convert.ToInt16(cmd.Parameters["@totalCount"].Value);
foreach (DataRow rowItem in dt.Rows)
{
Menureturn item = new Menureturn();
item.IdPer = Int32.Parse(rowItem["Id"].ToString());
item.IdMenu = Int32.Parse(rowItem["MenuId"].ToString());
item.MenuName = rowItem["MenuText"].ToString();
item.IsRead = rowItem["IsRead"].ToString();
item.IsCreate = rowItem["IsCreate"].ToString();
item.IsUpdate = rowItem["IsUpdate"].ToString();
item.IsDelete = rowItem["IsDelete"].ToString();
item.IsExport = rowItem["IsExport"].ToString();
list.Add(item);
}
result.Data = list;
result.Total = total;
return(result);
}
catch (Exception e)
{
return(null);
}
}
public LstMenuViewModel ListMenuOfRoleAndAccount(string searchValue, int currPage, int recodperpage, int iduser, int idrole)
{
LstMenuViewModel result = new LstMenuViewModel();
List <Menureturn> list = new List <Menureturn>();
var db = new DB_CSEntities1();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("getall_menuby_user", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@iduser", iduser));
cmd.Parameters.Add(new SqlParameter("@idrole", idrole));
cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue));
cmd.Parameters.Add(new SqlParameter("@currPage", currPage));
cmd.Parameters.Add(new SqlParameter("@recodperpage", 10));
cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
int total = Convert.ToInt16(cmd.Parameters["@totalCount"].Value);
foreach (DataRow rowItem in dt.Rows)
{
Menureturn item = new Menureturn();
item.IdPer = Int32.Parse(rowItem["Id"].ToString());
item.IdMenu = Int32.Parse(rowItem["MenuId"].ToString());
item.MenuName = rowItem["MenuText"].ToString();
item.RoleName = rowItem["RoleName"].ToString();
if (string.IsNullOrEmpty(rowItem["UserId"].ToString()))
{
lsIsCreate c = new lsIsCreate();
c.IsCreate = rowItem["IsCreate"].ToString();
c.status = false;
item.Create = c;
lsIsRead r = new lsIsRead();
r.IsRead = rowItem["IsRead"].ToString();
r.status = false;
item.Read = r;
lsIsUpdate u = new lsIsUpdate();
u.IsUpdate = rowItem["IsUpdate"].ToString();
u.status = false;
item.Update = u;
lsIsDelete d = new lsIsDelete();
d.IsDelete = rowItem["IsDelete"].ToString();
d.status = false;
item.Delete = d;
lsIsExport x = new lsIsExport();
x.IsExport = rowItem["IsExport"].ToString();
x.status = false;
item.Export = x;
OptionMenu op = new OptionMenu();
op.IdPermis = Int32.Parse(rowItem["Id"].ToString());
op.status = false;
item.Option = op;
}
else
{
lsIsCreate c = new lsIsCreate();
c.IsCreate = rowItem["IsCreate"].ToString();
c.status = true;
item.Create = c;
lsIsRead r = new lsIsRead();
r.IsRead = rowItem["IsRead"].ToString();
r.status = true;
item.Read = r;
lsIsUpdate u = new lsIsUpdate();
u.IsUpdate = rowItem["IsUpdate"].ToString();
u.status = true;
item.Update = u;
lsIsDelete d = new lsIsDelete();
d.IsDelete = rowItem["IsDelete"].ToString();
d.status = true;
item.Delete = d;
lsIsExport x = new lsIsExport();
x.IsExport = rowItem["IsExport"].ToString();
x.status = false;
item.Export = x;
OptionMenu op = new OptionMenu();
op.IdPermis = Int32.Parse(rowItem["Id"].ToString());
op.status = true;
item.Option = op;
}
list.Add(item);
}
result.Data = list;
result.Total = total;
return(result);
}
