public static SRPUser FetchByUsername(string pUsername) { var arrParams = new SqlParameter[1]; arrParams[0] = new SqlParameter("@Username", pUsername); var reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "cbspSRPUser_GetByUsername", arrParams); SRPUser u = GetFromReader(reader); return(u); }
public static SRPUser Fetch(int pUid) { var arrParams = new SqlParameter[1]; arrParams[0] = new SqlParameter("@UID", pUid); var reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "cbspSRPUser_Get", arrParams); SRPUser u = GetFromReader(reader); return(u); }
protected override bool CheckBusinessRules(BusinessRulesValidationMode validationMode) { // Remove any old error Codes ClearErrorCodes(); ClearErrorCodes(); if (validationMode == BusinessRulesValidationMode.INSERT) { SRPUser obj = FetchByUsername(Username); if (obj != null) { AddErrorCode(new BusinessRulesValidationMessage("Username", "Username", "Username already exists.", BusinessRulesValidationCode.UNSPECIFIED)); } } return(ErrorCodes.Count == 0); //return true; }
public static List <SRPUser> FetchAll() { var reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, "cbspSRPUser_GetAll"); List <SRPUser> retValue = new List <SRPUser>(); while (reader.Read()) { SRPUser aUser = new SRPUser(); aUser.Uid = (int)reader["UID"]; aUser.Username = (string)reader["Username"]; aUser.Password = (string)reader["Password"]; aUser.FirstName = (string)reader["FirstName"]; aUser.LastName = (string)reader["LastName"]; aUser.EmailAddress = (string)reader["EmailAddress"]; aUser.Division = (string)reader["Division"]; aUser.Department = (string)reader["Department"]; aUser.Title = (string)reader["Title"]; aUser.IsActive = (bool)reader["IsActive"]; aUser.MustResetPassword = (bool)reader["MustResetPassword"]; aUser.IsDeleted = (bool)reader["IsDeleted"]; aUser.LastPasswordReset = reader.IsDBNull(reader.GetOrdinal("LastPasswordReset")) ? null : (DateTime?)reader["LastPasswordReset"]; aUser.DeletedDate = reader.IsDBNull(reader.GetOrdinal("DeletedDate")) ? null : (DateTime?)reader["DeletedDate"]; aUser.LastModDate = reader.IsDBNull(reader.GetOrdinal("LastModDate")) ? null : (DateTime?)reader["LastModDate"]; aUser.AddedDate = reader.IsDBNull(reader.GetOrdinal("AddedDate")) ? null : (DateTime?)reader["AddedDate"]; aUser.LastModUser = (string)reader["LastModUser"]; aUser.AddedUser = (string)reader["AddedUser"]; retValue.Add(aUser); } return(retValue); }
public static int Insert(SRPUser u) { if (u == null) { return(-1); } var arrParams = new SqlParameter[12]; arrParams[0] = new SqlParameter("@Username", u.Username); arrParams[1] = new SqlParameter("@Password", u.Password); arrParams[2] = new SqlParameter("@FirstName", u.FirstName); arrParams[3] = new SqlParameter("@LastName", u.LastName); arrParams[4] = new SqlParameter("@EmailAddress", u.EmailAddress); arrParams[5] = new SqlParameter("@Division", u.Division); arrParams[6] = new SqlParameter("@Department", u.Department); arrParams[7] = new SqlParameter("@Title", u.Title); arrParams[8] = new SqlParameter("@IsActive", u.IsActive); arrParams[9] = new SqlParameter("@MustResetPassword", u.MustResetPassword); arrParams[10] = new SqlParameter("@ActionUsername", ((SRPUser)HttpContext.Current.Session[SessionData.UserProfile.ToString()]).Username); arrParams[11] = new SqlParameter("@Return_Value", -1); arrParams[11].Direction = ParameterDirection.ReturnValue; u.Uid = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.StoredProcedure, "dbo.cbspSRPUser_Insert", arrParams)); return((int)u.Uid); }