public List <RoleModel> GetUserRole(int userId)
{
var db = new StoreProcdureManagement();
db.AddParameter("@UserId", userId);
return(db.RunSp <RoleModel>(ConnectionString, "sp_UserRoles"));
}
public List <ProgramModel> GetPrograms()
{
var db = new StoreProcdureManagement();
var programs = db.RunSp <ProgramModel>(ConnectionString, "sp_Programs");
return(programs);
}
public List <PartModel> GetParts(PartTypeEnum partTypeEnum)
{
var db = new StoreProcdureManagement();
db.AddParameter("@PartTypeId", (int)partTypeEnum);
return(db.RunSp <PartModel>(ConnectionString, "sp_Parts"));
}
public List <PartModel> GetUserPart(int userId, int programId)
{
var db = new StoreProcdureManagement();
db.AddParameter("@UserId", userId);
db.AddParameter("@ProgramId", programId);
return(db.RunSp <PartModel>(ConnectionString, "sp_UserParts"));
}
public List <UserBasicInfoModel> GetUserJobTitles(int userId, int programId)
{
var db = new StoreProcdureManagement();
db.AddParameter("@ProgramId", programId);
db.AddParameter("@UserId", userId);
return(db.RunSp <UserBasicInfoModel>(ConnectionString, "sp_UserJobTitles"));
}
public List <UserJobTitleModel> GetPartJobTitleUsers(int partId, JobTitleEnum jobTitle)
{
var db = new StoreProcdureManagement();
db.AddParameter("@JobTitleId", (int)jobTitle);
db.AddParameter("@PartId", partId);
return(db.RunSp <UserJobTitleModel>(ConnectionString, "sp_PartJobTitleUser"));
}
public List <RoleModel> GetProgramRoles(int programId)
{
var db = new StoreProcdureManagement();
db.AddParameter("@ProgramId", ProgramId.ToString());
var roles = db.RunSp <RoleModel>(ConnectionString, "sp_ProgramRoles");
return(roles);
}
public static string GetPhoto(int userId)
{
var storeProcdureManagement = new StoreProcdureManagement();
storeProcdureManagement.AddParameter("@UserId", userId);
return(storeProcdureManagement.RunSp(ConnectionNameEnum.LaboratoryConnectionString,
"sp_GetBase64Photo").ToString());
}
public List <UserModel> GetAllUsers()
{
var db = new StoreProcdureManagement();
var users = db.RunSp <UserModel>(ConnectionString, "sp_Users");
if (users.Any())
{
return(users);
}
return(new List <UserModel>());
}
public ProgramModel GetProgram(int programId)
{
var db = new StoreProcdureManagement();
db.AddParameter("@ProgramId", ProgramId.ToString());
var program = db.RunSp <ProgramModel>(ConnectionString, "sp_Program");
if (program.Any())
{
return(program[0]);
}
return(new ProgramModel());
}
/// <summary>
/// Gets the user.
/// </summary>
/// <param name="userId">The user identifier.</param>
/// <param name="programId">The program identifier. If this parameter set as NULL value, then user will return without consider about his/her program.</param>
/// <returns></returns>
public UserModel GetUser(int userId, int?programId = null)
{
var db = new StoreProcdureManagement();
db.AddParameter("@UserId", userId);
db.AddParameter("@ProgramId", programId);
var user = db.RunSp <UserModel>(ConnectionString, "sp_User");
if (user.Any())
{
return(user[0]);
}
return(new UserModel());
}
public UserModel Login(int userId, string password)
{
var db = new StoreProcdureManagement();
db.AddParameter("@ProgramId", ProgramId);
db.AddParameter("@UserId", userId);
var user = db.RunSp <UserModel>(ConnectionString, "sp_User");
if (user.Any())
{
if (VerifyHashedPassword(user[0].PasswordHash, password))
{
return(user[0]);
}
}
return(null);
}
public List <BranchModel> GetBranches()
{
var db = new StoreProcdureManagement();
return(db.RunSp <BranchModel>(ConnectionString, "sp_Branches"));
}
public List <PartTypeModel> GetPartTypes()
{
var db = new StoreProcdureManagement();
return(db.RunSp <PartTypeModel>(ConnectionString, "sp_PartTypes"));
}
