public bool UpdateUserVerified(int tblUserID, bool Verified) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@tblUserID", tblUserID); p.AddWithValue("@Verified", Verified); return(UpdateCommand("UpdateUserVerified", p)); }
public bool UpdateUserActive(int tblUserID, bool Active) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@tblUserID", tblUserID); p.AddWithValue("@Active", Active); return(UpdateCommand("UpdateUserActive", p)); }
public bool UpdateGrantActive(ref GrantsDto dto) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@ID", dto.ID); p.AddWithValue("@Active", dto.Active); return(UpdateCommand("UpdateGrantActive", p)); }
public bool SavePassword(ref UserDto dto) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@tblUserID", dto.tblUserID); p.AddWithValue("@Password", dto.Password); p.AddWithValue("@IdentityVal", 0, SqlDbType.Int, ParameterDirection.Output); return(SaveCommand("SavePassword", p)); }
public bool SaveGrantRecords(ref SearchGrantsDto dto) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@ID", dto.ID); p.AddWithValue("@tblUserID", dto.tblUserID); p.AddWithValue("@moreInfoID", dto.moreInfoID); p.AddWithValue("@IdentityVal", 0, SqlDbType.Int, ParameterDirection.Output); return(SaveCommand("SaveGrantRecords", p)); }
// verify a user can successfully login public DataSet VerifyLogin(string email, string password) { SQLParamCollection p = new SQLParamCollection("@Email", email); p.AddWithValue("@Password", password); return(SelectCommand("VerifyLogin", p)); }
public bool SaveSearchRecords(ref SearchRecordsDto dto) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@ID", dto.ID); p.AddWithValue("@tblUserID", dto.tblUserID); p.AddWithValue("@ProgramName", dto.ProgramName); p.AddWithValue("@GrantSubject", dto.GrantSubject); p.AddWithValue("@AgencyName", dto.AgencyName); p.AddWithValue("@LastUpdated", dto.LastUpdated); p.AddWithValue("@CostShareType", dto.CostShareType); p.AddWithValue("@FundingType", dto.FundingType); p.AddWithValue("@IdentityVal", 0, SqlDbType.Int, ParameterDirection.Output); return(SaveCommand("SaveSearchRecords", p)); }
// selects all grants that pertain to a specific filter, used in main search for search table public DataSet SelectAllGrantsFilter(int ID, string ProgramName, string GrantSubject, string AgencyName, string LastUpdated, string CostShareType, string FundingType) { SQLParamCollection p = new SQLParamCollection("@ID", ID); p.AddWithValue("@ProgramName", ProgramName); p.AddWithValue("@GrantSubject", GrantSubject); p.AddWithValue("@AgencyName", AgencyName); p.AddWithValue("@LastUpdated", LastUpdated); p.AddWithValue("@CostShareType", CostShareType); p.AddWithValue("@FundingType", FundingType); return(SelectCommand("SelectAllGrantsFilter", p)); }
public bool SaveProfile(ref UserDto dto) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@tblUserID", dto.tblUserID); p.AddWithValue("@Email", dto.Email); p.AddWithValue("@Alias", dto.Alias); p.AddWithValue("@FirstName", dto.FirstName); p.AddWithValue("@LastName", dto.LastName); p.AddWithValue("@IdentityVal", 0, SqlDbType.Int, ParameterDirection.Output); return(SaveCommand("SaveProfile", p)); }
public bool SaveGrants(ref GrantsDto dto) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@ID", dto.ID); p.AddWithValue("@GrantID", dto.GrantID); p.AddWithValue("@ProgramName", dto.ProgramName); p.AddWithValue("@AgencyName", dto.AgencyName); p.AddWithValue("@ContactInformation", dto.ContactInformation); p.AddWithValue("@GrantSubject", dto.GrantSubject); p.AddWithValue("@EligibleActivities", dto.EligibleActivities); p.AddWithValue("@LastUpdated", dto.LastUpdated); p.AddWithValue("@CostShareType", dto.CostShareType); p.AddWithValue("@CostShareDescription", dto.CostShareDescription); p.AddWithValue("@OtherProgramCharacteristics", dto.OtherProgramCharacteristics); p.AddWithValue("@ApplicationDueDate", dto.ApplicationDueDate); p.AddWithValue("@DueDate", dto.DueDate); p.AddWithValue("@ApplicationSubType", dto.ApplicationSubType); p.AddWithValue("@FundingType", dto.FundingType); p.AddWithValue("@Active", dto.Active); p.AddWithValue("@CreatedByUserID", dto.CreatedByUserID); p.AddWithValue("@LastUpdatedByUserID", dto.LastUpdatedByUserID); p.AddWithValue("@IdentityVal", 0, System.Data.SqlDbType.Int, ParameterDirection.Output); return(SaveCommand("SaveGrants", p)); }
public bool SaveUser(ref UserDto dto) { SQLParamCollection p = new SQLParamCollection(); p.AddWithValue("@tblUserID", dto.tblUserID); p.AddWithValue("@Email", dto.Email); p.AddWithValue("@Password", dto.Password); p.AddWithValue("@Alias", dto.Alias); p.AddWithValue("@FirstName", dto.FirstName); p.AddWithValue("@LastName", dto.LastName); p.AddWithValue("@luRoleID", dto.luRoleID); p.AddWithValue("@OrganizationShortName", "MES"); p.AddWithValue("@OrganizationFullName", "Maryland Environmental Service"); p.AddWithValue("@Active", dto.Active); p.AddWithValue("@CreatedByUserID", dto.CreatedByUserID); p.AddWithValue("@DateCreated", DateTime.Now); p.AddWithValue("@LastUpdatedByUserID", dto.LastUpdatedByUserID); p.AddWithValue("@DateLastUpdated", DateTime.Now); p.AddWithValue("@Verified", dto.Verified); p.AddWithValue("@IdentityVal", 0, SqlDbType.Int, ParameterDirection.Output); return(SaveCommand("SaveUser", p)); }