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