//
public Company GetCompnay(int companyId)
{
Company company = null;
using (var conn = new SqlConnection(PrescienceRxConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(GetCompanyByIdSp, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@CompanyId", System.Data.SqlDbType.Int);
cmd.Parameters["@CompanyId"].Value = companyId;
using (var myReader = cmd.ExecuteReader())
{
try
{
if (myReader.HasRows)
{
myReader.Read();
company = new Company(myReader);
AdminRepository admrep = new AdminRepository();
List<Module> modules = admrep.GetModulesByCompany(Convert.ToInt32(myReader["CompanyId"]));
company.LstModules = new List<int>();
foreach (var item in modules)
{
company.LstModules.Add(item.ModuleId);
}
}
}
catch (Exception ex)
{
// TODO Logg Error here
}
}
}
}
return company;
}
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;
}
//
public List<Company> GetCompanies(string companyName)
{
var company = new List<Company>();
AdminRepository admrep = new AdminRepository();
using (var conn = new SqlConnection(PrescienceRxConnectionString))
{
conn.Open();
using (var cmd = new SqlCommand(GetCompaniesSp, conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Name", SqlDbType.VarChar);
cmd.Parameters["@Name"].Value = companyName;
using (var myReader = cmd.ExecuteReader())
{
try
{
while (myReader.Read())
{
company.Add(new Company(myReader));
List<Module> modules = admrep.GetModulesByCompany(Convert.ToInt32(myReader["CompanyId"]));
company[company.Count - 1].LstModules = new List<int>();
foreach (var item in modules)
{
company[company.Count - 1].LstModules.Add(item.ModuleId);
}
}
}
catch (Exception ex)
{
// TODO Logg Error here
}
}
}
}
return company;
}