public StringBuilder AgencyActiveInactiveDAL(ActiveInactiveAgencySearch activeInactiveAgencySearch)
{
try
{
SqlParameter[] P = new SqlParameter[] {
new SqlParameter("@AgencyID", activeInactiveAgencySearch.AgencyID),
new SqlParameter("@ActiveInactive", activeInactiveAgencySearch.ActiveInactive),
new SqlParameter("@CreatedBy", activeInactiveAgencySearch.CreatedBy),
};
var jsonResult = new StringBuilder();
jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.GetConnectionString, SPKeys.SPSetAgencyActiveInactive, P);
return(jsonResult);
}
catch { throw; }
}
public StringBuilder ProgramAdminActiveInactive(ActiveInactiveAgencySearch activeInactiveAgencySearch)
{
try
{
SqlParameter[] P = new SqlParameter[] {
new SqlParameter("@UserInfoID", activeInactiveAgencySearch.UserInfoID),
new SqlParameter("@ActiveInactive", activeInactiveAgencySearch.ActiveInactive),
new SqlParameter("@CreatedBy", activeInactiveAgencySearch.CreatedBy),
};
var jsonResult = new StringBuilder();
jsonResult = DataLib.JsonStringExecuteReader(DataLib.Connection.GetConnectionString, SPKeys.SPSetUserManagementActiveInactive, P);
return(jsonResult);
}
catch { throw; }
}
