public GetModulesByUser ( int userid ) : List |
||
userid | int | |
return | List |
public List<Module> GetModulesByUser(int userid)
{
List<Module> lstModules = null;
Module module = null;
using (var conn = new SqlConnection(PrescienceRxConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(GetModulesByUserIdSp, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@UserId", System.Data.SqlDbType.Int);
cmd.Parameters["@UserId"].Value = userid;
using (var myReader = cmd.ExecuteReader())
{
try
{
if (myReader.HasRows)
{
lstModules = new List<Module>();
while (myReader.Read())
{
module = new Module(myReader);
lstModules.Add(module);
}
}
}
catch (Exception ex)
{
// TODO Logg Error here
}
}
}
}
return lstModules;
}
public UserProfile GetUser(int userId) { UserProfile user = null; using (var conn = new SqlConnection(PrescienceRxConnectionString)) { conn.Open(); using (var cmd = new SqlCommand(GetUesrByIdSp, conn)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@UserId", System.Data.SqlDbType.Int); cmd.Parameters["@UserId"].Value = userId; using (var myReader = cmd.ExecuteReader()) { try { if (myReader.HasRows) { myReader.Read(); user = new UserProfile(myReader); AdminRepository admrep = new AdminRepository(); List<Module> modules = admrep.GetModulesByUser(userId); user.LstModules = new List<int>(); foreach (var item in modules) { user.LstModules.Add(item.ModuleId); } } } catch (Exception ex) { // TODO Logg Error here } } } } return user; }