public User GetUser(string userName)
{
User user = new UnknownUser();
MMData d = new MMData();
try {
DataSet x = d.GetStProcDataSet(MMWebSiteConstants.DatabaseName(), SelectUser + " WHERE (U_Login = @aLogin) and (U_IsActive=1)",
new StProcParam[] { new StProcParam("@aLogin", DbType.AnsiString, userName) });
if ((x.Tables.Count == 1) & (x.Tables[0].Rows.Count == 1))
{
user = BuildUserFromRow(x.Tables[0].Rows[0]);
}
} catch { }
return(user);
}
public User GetUserID(string userID)
{
User user = new UnknownUser();
MMData d = new MMData();
try {
DataSet x = d.GetStProcDataSet(MMWebSiteConstants.DatabaseName(), SelectUser + "WHERE (U_ID = cast( @aID as int ))",
new StProcParam[] { new StProcParam("@aID", DbType.String, userID) });
if ((x.Tables.Count == 1) & (x.Tables[0].Rows.Count == 1))
{
user = BuildUserFromRow(x.Tables[0].Rows[0]);
}
} catch { }
return(user);
}
public void UserUpdate(User toUpdate)
{
MMData d = new MMData();
DataSet ud = d.GetStProcDataSet(MMWebSiteConstants.DatabaseName(), "exec dbo.sp_AddUpdateUsers00 @aU_ID, @aU_C_ID, @aU_Login, @aU_Password, @aU_Name, @aU_Email, @aU_SALT, @aU_IsUserAdmin, @aU_IsInhouseStaff, @aU_Domain, @aU_IsActive ",
new StProcParam[] {
new StProcParam("@aU_ID", DbType.Int32, toUpdate.UserID),
new StProcParam("@aU_C_ID", DbType.Int32, toUpdate.U_C_ID),
new StProcParam("@aU_Login", DbType.String, toUpdate.LoginName),
new StProcParam("@aU_Password", DbType.String, toUpdate.Password),
new StProcParam("@aU_Name", DbType.String, toUpdate.Name),
new StProcParam("@aU_Email", DbType.String, toUpdate.Email),
new StProcParam("@aU_SALT", DbType.String, toUpdate.Salter),
new StProcParam("@aU_IsUserAdmin", DbType.Boolean, toUpdate.IsUserAdmin),
new StProcParam("@aU_IsInhouseStaff", DbType.Boolean, toUpdate.IsInhouseStaff),
new StProcParam("@aU_Domain", DbType.String, toUpdate.Domain),
new StProcParam("@aU_IsActive", DbType.Boolean, toUpdate.IsActive)
});
}
