public int AuditProposalSave(DataSet ds, int userID)
{
const int tblAuditSpecifications = 0;
const int tblAuditDivisions = 1;
int result = -1;
StoredProcedure storedProcedure;
StoredProcedureParameter sppAuditSpecificationsTable;
StoredProcedureParameter sppAuditDivisionsTable;
StoredProcedureParameter sppUserID;
//TODO: use names for tables and columns
try
{
sppAuditSpecificationsTable = new StoredProcedureParameter
{
Name = "@AuditSpecificationsTable",
DBValueType = ParameterType.Structured,
Value = ds.Tables[tblAuditSpecifications]
};
sppAuditDivisionsTable = new StoredProcedureParameter
{
Name = "@AuditDivisionsTable",
DBValueType = ParameterType.Structured,
Value = ds.Tables[tblAuditDivisions]
};
sppUserID = new StoredProcedureParameter
{
Name = "@UserID",
DBValueType = ParameterType.DBInteger,
Value = userID
};
storedProcedure = new StoredProcedure {
StoredProcedureName = _schema + ".[Audit.Proposal.Save]"
};
storedProcedure.Parameters.Add(sppAuditSpecificationsTable);
storedProcedure.Parameters.Add(sppAuditDivisionsTable);
storedProcedure.Parameters.Add(sppUserID);
storedProcedure.ExecuteDataSetWithIDOutputParam(out result);
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveContractVerificationForm(DataSet contractVerificationFormToSave, int UserID, out string ID)
{
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.ContractVerificationForm.Save]";
storedProcedure.Parameters.Add(new StoredProcedureParameter("@CompanyTypes", ParameterType.Structured, (contractVerificationFormToSave.Tables[0].Rows.Count > 0) ? contractVerificationFormToSave.Tables[0] : null));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@CompanyIndustryTypes", ParameterType.Structured, (contractVerificationFormToSave.Tables[1].Rows.Count > 0) ? contractVerificationFormToSave.Tables[1] : null));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@DivisionTypes", ParameterType.Structured, (contractVerificationFormToSave.Tables[2].Rows.Count > 0) ? contractVerificationFormToSave.Tables[2] : null));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@AgreementsTableTypes", ParameterType.Structured, (contractVerificationFormToSave.Tables[3].Rows.Count > 0) ? contractVerificationFormToSave.Tables[3] : null));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@ServicesProvidedTableTypes", ParameterType.Structured, (contractVerificationFormToSave.Tables[4].Rows.Count > 0) ? contractVerificationFormToSave.Tables[4] : null));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@AgreementJobRolesTableTypes", ParameterType.Structured, (contractVerificationFormToSave.Tables[5].Rows.Count > 0) ? contractVerificationFormToSave.Tables[5] : null));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@AgreementLocationsTableTypes", ParameterType.Structured, (contractVerificationFormToSave.Tables[6].Rows.Count > 0) ? contractVerificationFormToSave.Tables[6] : null));
storedProcedure.Parameters.Add(new StoredProcedureParameter("@UserID", ParameterType.DBInteger, UserID));
storedProcedure.ExecuteDataSetWithIDOutputParam(out ID);
}
void IOASRepository.saveFingerprintForm(DataTable appToSave, DataTable aliasToSave, DataTable govIDToSave, int userID, out int ID)
{
//DataSet ret = null;
var storedProcedure = new StoredProcedure();
storedProcedure.StoredProcedureName = schema + ".[Data.PersonIWSBiographics.Save]";
//rguidi 3/4/2013 #20202
//storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonBiographicsTableType", ParameterType.DBString, appToSave));
//storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonAliasTableType", ParameterType.DBString, aliasToSave));
//storedProcedure.Parameters.Add(new StoredProcedureParameter("@PersonGovernmentID", ParameterType.DBString, govIDToSave));
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));
storedProcedure.ExecuteDataSetWithIDOutputParam(out ID);
//ret = storedProcedure.ExecuteMultipleDataSet();
}
