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")); }