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