public User(int userId, EnumUser type, string username, string password)
{
this.userId = userId;
this.type = type;
this.username = username;
this.password = password;
}
/// <summary>
/// Gets all User objects
/// <remarks>
/// Returns User objects in an array list
/// using the given criteria
/// </remarks>
/// <retvalue>ArrayList containing User object</retvalue>
/// </summary>
public ArrayList Get(long pLngUserID, long pLngUserRoleID, DateTime pDtBeginDateCreated, DateTime pDtEndDateCreated, DateTime pDtBeginDateModified, DateTime pDtEndDateModified, string pStrFirstname, string pStrMiddlename, string pStrLastname, string pStrUsername, string pStrPasswd, string pStrPictureUrl, byte[] pBytPicture, bool?pBolIsDisabled, DateTime pDtBeginLastLoginDate, DateTime pDtEndLastLoginDate)
{
User data = null;
_arrlstEntities = new ArrayList();
EnumUser enumUser = new EnumUser(_conn);
enumUser.SP_ENUM_NAME = (!string.IsNullOrEmpty(SP_ENUM_NAME)) ? SP_ENUM_NAME : enumUser.SP_ENUM_NAME;
enumUser.UserID = pLngUserID;
enumUser.UserRoleID = pLngUserRoleID;
enumUser.BeginDateCreated = pDtBeginDateCreated;
enumUser.EndDateCreated = pDtEndDateCreated;
enumUser.BeginDateModified = pDtBeginDateModified;
enumUser.EndDateModified = pDtEndDateModified;
enumUser.Firstname = pStrFirstname;
enumUser.Middlename = pStrMiddlename;
enumUser.Lastname = pStrLastname;
enumUser.Username = pStrUsername;
enumUser.Passwd = pStrPasswd;
enumUser.PictureUrl = pStrPictureUrl;
enumUser.Picture = pBytPicture;
enumUser.IsDisabled = pBolIsDisabled;
enumUser.BeginLastLoginDate = pDtBeginLastLoginDate;
enumUser.EndLastLoginDate = pDtEndLastLoginDate;
enumUser.EnumData();
while (enumUser.hasMoreElements())
{
data = (User)enumUser.nextElement();
_arrlstEntities.Add(data);
}
enumUser = null;
ArrayList.ReadOnly(_arrlstEntities);
return(_arrlstEntities);
}
public static IConnectionDefinition GetConnectionParameter(EnumUser user)
{
switch (user)
{
case EnumUser.HqHome:
return(ConParHqHome());
case EnumUser.HqRemote:
return(ConParHqRemote());
case EnumUser.LocalExpressDomainUser:
return(ConParLocalExpressDomainUser());
}
;
return(new MsSqlConnection());
}
/// <summary>
/// UserGetList
/// </summary>
/// <param name="">pEnumUser</param>
/// <returns>ArrayList</returns>
///
public ArrayList UserGetList(EnumUser pEnumUser)
{
ArrayList items = null;
bool bConn = false;
SqlConnection conn = getDBConnection();
if (conn != null)
{
BusUser busUser = null;
busUser = new BusUser(conn);
items = busUser.Get(pEnumUser);
// close the db connection
bConn = CloseConnection(conn);
_hasError = busUser.HasError;
if (busUser.HasError)
{
// error
ErrorCode error = new ErrorCode();
}
}
return(items);
}
public ArrayList Find(string username)
{
ArrayList arUser = null;
try
{
if ((!string.IsNullOrEmpty(username)))
{
EnumUser enumUser = new EnumUser()
{
Username = username
};
arUser = UserGetList(enumUser);
}
}
catch (Exception ex)
{
_hasError = true;
_errorMessage = ex.Message;
_errorStacktrace = ex.StackTrace;
}
return(arUser);
}
/// <summary>
/// Gets all User objects
/// <remarks>
/// Returns ArrayList containing object passed in
/// </remarks>
/// <param name="o">User to be returned</param>
/// <retvalue>ArrayList containing User object</retvalue>
/// </summary>
public ArrayList Get(EnumUser o)
{
return(Get(o.UserID, o.UserRoleID, o.BeginDateCreated, o.EndDateCreated, o.BeginDateModified, o.EndDateModified, o.Firstname, o.Middlename, o.Lastname, o.Username, o.Passwd, o.PictureUrl, o.Picture, o.IsDisabled, o.BeginLastLoginDate, o.EndLastLoginDate));
}
internal ContextFactory(EnumUser dataset)
{
ConnectionDefinition = InitConnection.GetConnectionParameter(dataset);
Context = new MsSqlContextSingleton(EnumContextFabricateBy.ConnectionString, ConnectionDefinition.ConnectionString);
}
