public List <U_Menu> GetMenus()
{
var entities = new List <U_Menu>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_U_Menu_Repository_GetMenus, null)) {
while (rdr.Read())
{
var entity = new U_Menu();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Icon = SqlTypeConverter.DBNullStringHandler(rdr["Icon"]);
entity.Url = SqlTypeConverter.DBNullStringHandler(rdr["Url"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Index = SqlTypeConverter.DBNullInt32Handler(rdr["Index"]);
entity.LastId = SqlTypeConverter.DBNullInt32Handler(rdr["LastId"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
public U_Menu GetMenu(int id)
{
SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.Int) };
parms[0].Value = SqlTypeConverter.DBNullInt32Checker(id);
U_Menu entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_U_Menu_Repository_GetMenu, parms)) {
if (rdr.Read())
{
entity = new U_Menu();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Icon = SqlTypeConverter.DBNullStringHandler(rdr["Icon"]);
entity.Url = SqlTypeConverter.DBNullStringHandler(rdr["Url"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Index = SqlTypeConverter.DBNullInt32Handler(rdr["Index"]);
entity.LastId = SqlTypeConverter.DBNullInt32Handler(rdr["LastId"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
}
}
return(entity);
}
public List <U_Menu> GetMenusInRole(Guid id)
{
SqlParameter[] parms = { new SqlParameter("@RoleId", SqlDbType.VarChar, 100) };
parms[0].Value = SqlTypeConverter.DBNullGuidChecker(id);
var entities = new List <U_Menu>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_U_Menu_Repository_GetMenusInRole, parms)) {
while (rdr.Read())
{
var entity = new U_Menu();
entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Icon = SqlTypeConverter.DBNullStringHandler(rdr["Icon"]);
entity.Url = SqlTypeConverter.DBNullStringHandler(rdr["Url"]);
entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]);
entity.Index = SqlTypeConverter.DBNullInt32Handler(rdr["Index"]);
entity.LastId = SqlTypeConverter.DBNullInt32Handler(rdr["LastId"]);
entity.Enabled = SqlTypeConverter.DBNullBooleanHandler(rdr["Enabled"]);
entities.Add(entity);
}
}
return(entities);
}
