public DataSet PerCredPersonLoad(Int32 userID, Int32 personID, Int32?divisionID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.PersonCredentialing.PersonLoad]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@personID", ParameterType.DBString, personID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@divisionID", ParameterType.DBString, divisionID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
DataSet IUserRepository.loadUserFormInfo(Int32?personUserID, Int32 userID, String LAWA_OAS)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Security.DisplayUserInfo.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@personUserID", ParameterType.DBString, personUserID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@LAWA_OAS", ParameterType.DBString, LAWA_OAS));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
public DataSet PerCredSAFELoad(Int32 userID, Int32 personID, Int32?citationID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.SAFEInformation.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@personID", ParameterType.DBString, personID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@citationID", ParameterType.DBString, citationID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
public DataSet LoadAdditionalAccessRequestForm(Int32 CompanyID, Int32 DivisionID, Int32 LocationID, int UserID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.AdditionalAccessRequestForm.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@companyID", ParameterType.DBString, CompanyID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@divisionID", ParameterType.DBString, DivisionID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@locationID", ParameterType.DBString, LocationID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, UserID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
public void SaveTransferEmployeeForm(DataTable EmployeeToSave, DataTable specialAccess, int UserID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = _Schema + ".[Data.TransferEmployeeForm.Save]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@TransferTableTypes", ParameterType.Structured, EmployeeToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@SpecialAccessTableTypes", ParameterType.Structured, specialAccess));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, UserID));
ret = storedProcedure.ExecuteMultipleDataSet();
}
// this method may be obsolete as of 6/29/2012 ------------------------------------------------
DataSet IReviewRepository.loadAuditSpecificationList(Int32 userID, Int32?companyID, Int32?divisionID, Int32?auditID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.ReviewDetail.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@companyID", ParameterType.DBString, companyID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@divisionID", ParameterType.DBString, divisionID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@auditID", ParameterType.DBString, auditID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
DataSet IAdminRepository.LoadGroupsOfUsers(Int32 userID, Int32?groupId, int applicationId, Int32?dataUserID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = adminSchema + ".[Security.UserGroupsForm.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@ApplicationId", ParameterType.DBString, applicationId));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@GroupID", ParameterType.DBString, groupId));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBString, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@DataUserID", ParameterType.DBString, dataUserID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
/// <summary>
/// Returns the badge details for the invalidate badge screen
/// </summary>
/// <param name="userId">The user id.</param>
/// <param name="badgeNumber">The badge number.</param>
/// <returns></returns>
public DataTable InvalidateBadgeDetails(int userId, int badgeId)
{
var storedProcedure = new StoredProcedure()
{
StoredProcedureName = schema + ".[Badging.InvalidateBadgeDetails]"
};
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userId", ParameterType.DBInteger, userId));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@badgeId", ParameterType.DBInteger, badgeId));
var result = storedProcedure.ExecuteMultipleDataSet();
return(result != null && result.Tables.Count > 0 ? result.Tables[0] : null);
}
public DataSet BadgeInfoByBadgeNumber(string badgeNumber, int userID)
{
DataSet result = null;
var storedProcedure = new StoredProcedure {
StoredProcedureName = schema + ".[Review.Badge.Info.ByBadgeNumber]"
};
storedProcedure.Parameters.Add(new StoredProcedureParameter("@BadgeNumber", ParameterType.DBString, badgeNumber));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, userID));
result = storedProcedure.ExecuteMultipleDataSet();
return(result);
}
public void saveBadgeMaintenanceForm(DataTable BadgeMaintenanceFormToSave, int userID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.BadgeMaintenanceForm.Save]";
//rguidi 3/4/2013 #20202
//storedProcedure.Parameters.Add(new StoredProcedureParameter("@BadgeMaintenanceTypes", ParameterType.DBString, BadgeMaintenanceFormToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@BadgeMaintenanceTypes", ParameterType.Structured, BadgeMaintenanceFormToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, userID));
ret = storedProcedure.ExecuteMultipleDataSet();
}
DataSet IUserRepository.LoadUserDataOnly(Int16 applicationID, string userLoginName, string facilityCode)
{
DataSet ret = null;
string dc = ((char)1).ToString();
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Security.Login.LoadUserDataOnly]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@applicationID", ParameterType.DBString, applicationID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userLoginName", ParameterType.DBString, userLoginName));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@facilityCode", ParameterType.DBString, facilityCode));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
public DataSet LoadExtendContractForm(Int32 CompanyID, Int32 DivisionID, Int32 AgreementID, int UserID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.ExtendContractForm.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@companyID", ParameterType.DBString, CompanyID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@divisionID", ParameterType.DBString, DivisionID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@agreementID", ParameterType.DBString, AgreementID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, UserID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
public DataSet GetCitationDetails(int citationID, int userID)
{
DataSet result = null;
var storedProcedure = new StoredProcedure {
StoredProcedureName = schema + ".[Review.Bages.CitationDetails]"
};
storedProcedure.Parameters.Add(new StoredProcedureParameter("@CitationID", ParameterType.DBInteger, citationID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, userID));
result = storedProcedure.ExecuteMultipleDataSet();
return(result);
}
public DataSet loadIndividualSpecialAccessRequestForm(short CompanyID, short DivisionID, short LocationID, Int32 userID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.IndividualSpecialAccessRequestForm.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@companyID", ParameterType.DBString, CompanyID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@divisionID", ParameterType.DBString, DivisionID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@locationID", ParameterType.DBString, LocationID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
public DataSet loadCompanyList(Int32?companyID, string companyCriteria, string divisionCriteria, int UserID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.Company.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@companyID", ParameterType.DBString, companyID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@companyCriteria", ParameterType.DBString, companyCriteria));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@divisionCriteria", ParameterType.DBString, divisionCriteria));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, UserID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
// ---------Manage Users Info -----------------------
DataSet IUserRepository.loadManageUserInfo(String personNameCriteria, Int32 userID, String LAWA_OAS, Boolean isNonUser)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Security.ManageUserInfo.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@personNameCriteria", ParameterType.DBString, personNameCriteria));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@LAWA_OAS", ParameterType.DBString, LAWA_OAS));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@IsNonUser", ParameterType.DBString, isNonUser));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
DataSet ICompanyRepository.LoadContractVerificationForm(Int32 CompanyID, Int32 DivisionID, Int32 AgreementID, Int32 IndustryTypeID, int UserID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.ContractVerificationForm.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@companyID", ParameterType.DBString, CompanyID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@divisionID", ParameterType.DBString, DivisionID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@agreementID", ParameterType.DBString, AgreementID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@industryTypeID", ParameterType.DBString, IndustryTypeID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, UserID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
public void Delete(int queryId, int UserID)
{
var storedProcedure = new StoredProcedure()
{
StoredProcedureName = "[App.Sbo].[QueryBrowser.DeleteQuery]"
};
StoredProcedureParameter dbParam = new StoredProcedureParameter("@pkQueryId", ParameterType.DBInteger, queryId);
StoredProcedureParameter dbUserIDParam = new StoredProcedureParameter("@UserID", ParameterType.DBInteger, UserID);
storedProcedure.Parameters.Add(dbParam);
storedProcedure.Parameters.Add(dbUserIDParam);
storedProcedure.ExecuteMultipleDataSet();
}
/// <summary>
/// Get company/division info based on company or division code by subject to whether or not data already exists in the shadow tables for that company
/// </summary>
public DataSet ShadowGetCompanyCodeCompany(String companyCode, String divisionCode, int userID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = _ShadowSchema + ".[Data.CompanyCodeCompany.Load]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@companySearchTerm", ParameterType.DBString, companyCode));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@divisionCode", ParameterType.DBString, divisionCode));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
public DataSet LoadSAFE(Int32 userID, Int32 personID, Int32?citationID)
{
DataSet result = null;
var storedProcedure = new StoredProcedure {
StoredProcedureName = schema + ".[Data.SAFEInformation.Load]"
};
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBInteger, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@personID", ParameterType.DBInteger, personID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@citationID", ParameterType.DBInteger, citationID));
result = storedProcedure.ExecuteMultipleDataSet();
return(result);
}
public DataSet WorkQueueLoad(int userID)
{
DataSet result = null;
var storedProcedure = new StoredProcedure()
{
StoredProcedureName = _Schema + ".[WorkQueue.Load]"
};
StoredProcedureParameter paramUserID = new StoredProcedureParameter("@UserID", ParameterType.DBInteger, userID);
storedProcedure.Parameters.Add(paramUserID);
result = storedProcedure.ExecuteMultipleDataSet();
return(result);
}
public DataSet GetCitationsForPreviousNMonths(int personID, int userID, int numberOfMonths)
{
DataSet result = null;
var storedProcedure = new StoredProcedure {
StoredProcedureName = schema + ".[Review.Badge.CitationTotals]"
};
storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonID", ParameterType.DBInteger, personID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@NumberOfMonths", ParameterType.DBInteger, numberOfMonths));
result = storedProcedure.ExecuteMultipleDataSet();
return(result);
}
public DataSet GetSpecificationInfo(int auditSpecificationID)
{
DataSet result = null;
var storedProcedure = new StoredProcedure {
StoredProcedureName = _schema + ".[Audit.Info.Inspections]"
};
var paramAuditSpecificationID = new StoredProcedureParameter("@AuditSpecificationID", ParameterType.DBInteger, auditSpecificationID);
storedProcedure.Parameters.Add(paramAuditSpecificationID);
result = storedProcedure.ExecuteMultipleDataSet();
return(result);
}
public DataSet AuditHelperDeactivateBadgesTest(DataTable deactivateBadges)
{
DataSet result = null;
var storedProcedure = new StoredProcedure {
StoredProcedureName = _schema + ".[Audit.Helper.DeactivateBadgesTest]"
};
var paramDeactivateBadges = new StoredProcedureParameter("@DeactivateBadges", ParameterType.Structured, deactivateBadges);
storedProcedure.Parameters.Add(paramDeactivateBadges);
result = storedProcedure.ExecuteMultipleDataSet(); //whats wrong here???????
return(result);
}
DataSet IReviewRepository.loadChangeLogAgreementList(Int32?agreementID, DateTime beginDateTime, DateTime endDateTime, String rollupValue, Int32 userID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[DataChangeLogging.ShowEntityChanges.Agreement]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@agreementID", ParameterType.DBInteger, agreementID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@beginDateTime", ParameterType.DBDateTime, beginDateTime));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@endDateTime", ParameterType.DBDateTime, endDateTime));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@rollupValue", ParameterType.DBDateTime, rollupValue));
//storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
void IOASRepository.saveBadgePage1Form(DataTable appToSave, DataTable aliasToSave, DataTable govIDToSave, DataTable felonyAnswers, int userID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.PersonIWSBiographics.Save]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonBiographicsTableType", ParameterType.Structured, appToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonAliasTableType", ParameterType.Structured, aliasToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonGovernmentID", ParameterType.Structured, govIDToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonFelonyAnswers", ParameterType.Structured, felonyAnswers));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, userID));
ret = storedProcedure.ExecuteMultipleDataSet();
}
void IAdminRepository.saveGroupForm(Int32?groupID, String groupName, String groupDescription, Int32 applicationID, Int32?copyGroupID, Int32 userID, String action)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = adminSchema + ".[Security.GroupsForm.Save]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@GroupID", ParameterType.DBString, groupID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@GroupName", ParameterType.DBString, groupName));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@GroupDescription", ParameterType.DBString, groupDescription));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@ApplicationID", ParameterType.DBString, applicationID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@CopyGroupID", ParameterType.DBString, copyGroupID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBString, userID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@_Action", ParameterType.DBString, action));
ret = storedProcedure.ExecuteMultipleDataSet();
}
DataTable IOASRepository.SaveTQTFingerprintForm(DataTable appToSave, DataTable aliasToSave, DataTable govIDToSave, int userID)
{
DataSet ret = null;
DataTable rt = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.PersonIWSBiographics.Save]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonBiographicsTableType", ParameterType.Structured, appToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonAliasTableType", ParameterType.Structured, aliasToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonGovernmentID", ParameterType.Structured, govIDToSave));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, userID));
ret = storedProcedure.ExecuteMultipleDataSet();
rt = ret.Tables[0];
return(rt);
}
public DataSet AuditFormLoad(int auditID, int divisionID)
{
DataSet result = null;
var storedProcedure = new StoredProcedure {
StoredProcedureName = _schema + ".[Audit.Editor.Load]"
};
var paramAuditID = new StoredProcedureParameter("@AuditId", ParameterType.DBInteger, auditID);
var paramDivisionID = new StoredProcedureParameter("@DivisionId", ParameterType.DBInteger, divisionID);
storedProcedure.Parameters.Add(paramAuditID);
storedProcedure.Parameters.Add(paramDivisionID);
result = storedProcedure.ExecuteMultipleDataSet();
return(result);
}
// begin obsolete ---------------------
DataSet IReviewRepository.loadChangeLogList(Int32?tableGroupID, Int32?tableID, Int32?primaryKey, DateTime beginDateTime, DateTime endDateTime, Int32 userID)
{
DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[DataChangeLogging.GetChangesWrapper]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@tableGroupID", ParameterType.DBInteger, tableGroupID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@tableID", ParameterType.DBInteger, tableID));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@rowID", ParameterType.DBInteger, primaryKey));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@beginDateTime", ParameterType.DBDateTime, beginDateTime));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@endDateTime", ParameterType.DBDateTime, endDateTime));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@userID", ParameterType.DBString, userID));
ret = storedProcedure.ExecuteMultipleDataSet();
return(ret);
}
