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