//public async Task<int> InsertOLPRRIncidentRecord(ApOlprrInsertIncident apOLPRRInsertIncident)
public async Task <int> InsertOLPRRIncidentRecord(ApOLPRRInsertIncident apOLPRRInsertIncident)
{
var incident = _mapper.Map <ApOLPRRInsertIncident, EntityDto.ApOlprrInsertIncident>(apOLPRRInsertIncident);
var result = await _lustRepository.InsertOLPRRIncidentRecord(incident);
return(result);
}
public async Task <int> InsertOLPRRIncidentRecord(ApOLPRRInsertIncident apOLPRRInsertIncident)
{
var result = await _dbContext.Database.ExecuteSqlCommandAsync("execute dbo.apOLPRRInsertIncident " +
" @ErrNum ,@CONTRACTOR_UID, @CONTRACTOR_PWD, @REPORTED_BY, @REPORTED_BY_PHONE, @REPORTED_BY_EMAIL, @RELEASE_TYPE, @DATE_RECEIVED,@FACILITY_ID, @SITE_NAME,@SITE_COUNTY" +
", @STREET_NBR, @STREET_QUAD,@STREET_NAME,@STREET_TYPE,@SITE_ADDRESS,@SITE_CITY,@SITE_ZIPCODE,@SITE_PHONE, @INITIAL_COMMENT, @DISCOVERY_DATE, @CONFIRMATION_CODE" +
", @DISCOVERY_CODE,@CAUSE_CODE,@SOURCEID,@RP_FIRSTNAME,@RP_LASTNAME,@RP_ORGANIZATION,@RP_ADDRESS,@RP_ADDRESS2,@RP_CITY,@RP_STATE,@RP_ZIPCODE,@RP_PHONE,@RP_EMAIL" +
", @IC_FIRSTNAME,@IC_LASTNAME,@IC_ORGANIZATION,@IC_ADDRESS,@IC_ADDRESS2,@IC_CITY,@IC_STATE,@IC_ZIPCODE,@IC_PHONE,@IC_EMAIL" +
", @GROUNDWATER,@SURFACEWATER,@DRINKINGWATER,@SOIL,@VAPOR,@FREEPRODUCT,@UNLEADEDGAS,@LEADEDGAS,@MISGAS,@DIESEL,@WASTEOIL,@HEATINGOIL,@LUBRICANT,@SOLVENT" +
", @OTHERPET,@CHEMICAL,@UNKNOWN,@MTBE,@SUBMIT_DATETIME,@DEQ_OFFICE", BuildSqlParams(apOLPRRInsertIncident));
return(result);
}
private IEnumerable <SqlParameter> BuildSqlParams(ApOLPRRInsertIncident apOLPRRInsertIncident)
{
IList <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter {
ParameterName = "@ErrNum", SqlDbType = SqlDbType.SmallInt, Direction = ParameterDirection.Output
});
list.Add(new SqlParameter("@CONTRACTOR_UID", apOLPRRInsertIncident.ContractorUid));
list.Add(new SqlParameter("@CONTRACTOR_PWD", apOLPRRInsertIncident.ContractorPwd));
list.Add(new SqlParameter("@REPORTED_BY", apOLPRRInsertIncident.ReportedBy));
list.Add(new SqlParameter("@REPORTED_BY_PHONE", apOLPRRInsertIncident.ReportedByPhone));
list.Add(new SqlParameter("@REPORTED_BY_EMAIL", apOLPRRInsertIncident.ReportedByEmail));
list.Add(new SqlParameter("@RELEASE_TYPE", apOLPRRInsertIncident.ReleaseType));
list.Add(new SqlParameter("@DATE_RECEIVED", apOLPRRInsertIncident.DateReceived));
list.Add(new SqlParameter("@FACILITY_ID", apOLPRRInsertIncident.FacilityId));
list.Add(new SqlParameter("@SITE_NAME", apOLPRRInsertIncident.SiteName));
list.Add(new SqlParameter("@SITE_COUNTY", apOLPRRInsertIncident.SiteCounty));
list.Add(new SqlParameter("@STREET_NBR", apOLPRRInsertIncident.StreetNbr));
list.Add(new SqlParameter("@STREET_QUAD", apOLPRRInsertIncident.StreetQuad));
list.Add(new SqlParameter("@STREET_NAME", apOLPRRInsertIncident.StreetName));
list.Add(new SqlParameter("@STREET_TYPE", apOLPRRInsertIncident.StreetType));
list.Add(new SqlParameter("@SITE_ADDRESS", apOLPRRInsertIncident.SiteAddress));
list.Add(new SqlParameter("@SITE_CITY", apOLPRRInsertIncident.SiteCity));
list.Add(new SqlParameter("@SITE_ZIPCODE", apOLPRRInsertIncident.SiteZipcode));
list.Add(new SqlParameter("@SITE_PHONE", apOLPRRInsertIncident.SitePhone));
list.Add(new SqlParameter("@INITIAL_COMMENT", apOLPRRInsertIncident.InitialComment));
list.Add(new SqlParameter("@DISCOVERY_DATE", apOLPRRInsertIncident.DiscoveryDate));
list.Add(new SqlParameter("@CONFIRMATION_CODE", apOLPRRInsertIncident.ConfirmationCode));
list.Add(new SqlParameter("@DISCOVERY_CODE", apOLPRRInsertIncident.DiscoveryCode));
list.Add(new SqlParameter("@CAUSE_CODE", apOLPRRInsertIncident.CauseCode));
list.Add(new SqlParameter("@SOURCEID", apOLPRRInsertIncident.SourceId));
list.Add(new SqlParameter("@RP_FIRSTNAME", apOLPRRInsertIncident.RpFirstName));
list.Add(new SqlParameter("@RP_LASTNAME", apOLPRRInsertIncident.RpLastName));
list.Add(new SqlParameter("@RP_ORGANIZATION", apOLPRRInsertIncident.RpOrganization));
list.Add(new SqlParameter("@RP_ADDRESS", apOLPRRInsertIncident.RpAddress));
list.Add(new SqlParameter("@RP_ADDRESS2", apOLPRRInsertIncident.RpAddress2));
list.Add(new SqlParameter("@RP_CITY", apOLPRRInsertIncident.RpCity));
list.Add(new SqlParameter("@RP_STATE", apOLPRRInsertIncident.RpState));
list.Add(new SqlParameter("@RP_ZIPCODE", apOLPRRInsertIncident.RpZipcode));
list.Add(new SqlParameter("@RP_PHONE", apOLPRRInsertIncident.RpPhone));
list.Add(new SqlParameter("@RP_EMAIL", apOLPRRInsertIncident.RpEmail));
list.Add(new SqlParameter("@IC_FIRSTNAME", apOLPRRInsertIncident.IcFirstName));
list.Add(new SqlParameter("@IC_LASTNAME", apOLPRRInsertIncident.IcLastName));
list.Add(new SqlParameter("@IC_ORGANIZATION", apOLPRRInsertIncident.IcOrganization));
list.Add(new SqlParameter("@IC_ADDRESS", apOLPRRInsertIncident.IcAddress));
list.Add(new SqlParameter("@IC_ADDRESS2", apOLPRRInsertIncident.IcAddress2));
list.Add(new SqlParameter("@IC_CITY", apOLPRRInsertIncident.IcCity));
list.Add(new SqlParameter("@IC_STATE", apOLPRRInsertIncident.IcState));
list.Add(new SqlParameter("@IC_ZIPCODE", apOLPRRInsertIncident.IcZipcode));
list.Add(new SqlParameter("@IC_PHONE", apOLPRRInsertIncident.IcPhone));
list.Add(new SqlParameter("@IC_EMAIL", apOLPRRInsertIncident.IcEmail));
list.Add(new SqlParameter("@GROUNDWATER", apOLPRRInsertIncident.GroundWater));
list.Add(new SqlParameter("@SURFACEWATER", apOLPRRInsertIncident.SurfaceWater));
list.Add(new SqlParameter("@DRINKINGWATER", apOLPRRInsertIncident.DringkingWater));
list.Add(new SqlParameter("@SOIL", apOLPRRInsertIncident.Soil));
list.Add(new SqlParameter("@VAPOR", apOLPRRInsertIncident.Vapor));
list.Add(new SqlParameter("@FREEPRODUCT", apOLPRRInsertIncident.FreeProduct));
list.Add(new SqlParameter("@UNLEADEDGAS", apOLPRRInsertIncident.UnleadedGas));
list.Add(new SqlParameter("@LEADEDGAS", apOLPRRInsertIncident.LeadedGas));
list.Add(new SqlParameter("@MISGAS", apOLPRRInsertIncident.MisGas));
list.Add(new SqlParameter("@DIESEL", apOLPRRInsertIncident.Diesel));
list.Add(new SqlParameter("@WASTEOIL", apOLPRRInsertIncident.WasteOil));
list.Add(new SqlParameter("@HEATINGOIL", apOLPRRInsertIncident.HeatingOil));
list.Add(new SqlParameter("@LUBRICANT", apOLPRRInsertIncident.Lubricant));
list.Add(new SqlParameter("@SOLVENT", apOLPRRInsertIncident.Solvent));
list.Add(new SqlParameter("@OTHERPET", apOLPRRInsertIncident.OtherPet));
list.Add(new SqlParameter("@CHEMICAL", apOLPRRInsertIncident.Chemical));
list.Add(new SqlParameter("@UNKNOWN", apOLPRRInsertIncident.Unknown));
list.Add(new SqlParameter("@MTBE", apOLPRRInsertIncident.Mtbe));
list.Add(new SqlParameter("@SUBMIT_DATETIME", apOLPRRInsertIncident.SubmitDateTime));
list.Add(new SqlParameter("@DEQ_OFFICE", apOLPRRInsertIncident.DeqOffice));
IEnumerable <SqlParameter> myParams = list;
return(myParams);
}
public async Task <int> InsertOLPRRIncidentRecord_SAVE1(ApOLPRRInsertIncident apOLPRRInsertIncident)
{
object[] parameters =
{
new SqlParameter
{
ParameterName = "@ErrNum",
SqlDbType = SqlDbType.SmallInt,
Direction = ParameterDirection.Output
}
, new SqlParameter("@CONTRACTOR_UID", apOLPRRInsertIncident.ContractorUid)
, new SqlParameter("@CONTRACTOR_PWD", apOLPRRInsertIncident.ContractorPwd)
, new SqlParameter("@REPORTED_BY", apOLPRRInsertIncident.ReportedBy)
, new SqlParameter("@REPORTED_BY_PHONE", apOLPRRInsertIncident.ReportedByPhone)
, new SqlParameter("@REPORTED_BY_EMAIL", apOLPRRInsertIncident.ReportedByEmail)
, new SqlParameter("@RELEASE_TYPE", apOLPRRInsertIncident.ReleaseType)
, new SqlParameter("@DATE_RECEIVED", apOLPRRInsertIncident.DateReceived)
, new SqlParameter("@FACILITY_ID", apOLPRRInsertIncident.FacilityId)
, new SqlParameter("@SITE_NAME", apOLPRRInsertIncident.SiteName)
, new SqlParameter("@SITE_COUNTY", apOLPRRInsertIncident.SiteCounty)
, new SqlParameter("@STREET_NBR", apOLPRRInsertIncident.StreetNbr)
, new SqlParameter("@STREET_QUAD", apOLPRRInsertIncident.StreetQuad)
, new SqlParameter("@STREET_NAME", apOLPRRInsertIncident.StreetName)
, new SqlParameter("@STREET_TYPE", apOLPRRInsertIncident.StreetType)
, new SqlParameter("@SITE_ADDRESS", apOLPRRInsertIncident.SiteAddress)
, new SqlParameter("@SITE_CITY", apOLPRRInsertIncident.SiteCity)
, new SqlParameter("@SITE_ZIPCODE", apOLPRRInsertIncident.SiteZipcode)
, new SqlParameter("@SITE_PHONE", apOLPRRInsertIncident.SitePhone)
, new SqlParameter("@INITIAL_COMMENT", apOLPRRInsertIncident.InitialComment)
, new SqlParameter("@DISCOVERY_DATE", apOLPRRInsertIncident.DiscoveryDate)
, new SqlParameter("@CONFIRMATION_CODE", apOLPRRInsertIncident.ConfirmationCode)
, new SqlParameter("@DISCOVERY_CODE", apOLPRRInsertIncident.DiscoveryCode)
, new SqlParameter("@CAUSE_CODE", apOLPRRInsertIncident.CauseCode)
, new SqlParameter("@SOURCEID", apOLPRRInsertIncident.SourceId)
, new SqlParameter("@RP_FIRSTNAME", apOLPRRInsertIncident.RpFirstName)
, new SqlParameter("@RP_LASTNAME", apOLPRRInsertIncident.RpLastName)
, new SqlParameter("@RP_ORGANIZATION", apOLPRRInsertIncident.RpOrganization)
, new SqlParameter("@RP_ADDRESS", apOLPRRInsertIncident.RpAddress)
, new SqlParameter("@RP_ADDRESS2", apOLPRRInsertIncident.RpAddress2)
, new SqlParameter("@RP_CITY", apOLPRRInsertIncident.RpCity)
, new SqlParameter("@RP_STATE", apOLPRRInsertIncident.RpState)
, new SqlParameter("@RP_ZIPCODE", apOLPRRInsertIncident.RpZipcode)
, new SqlParameter("@RP_PHONE", apOLPRRInsertIncident.RpPhone)
, new SqlParameter("@RP_EMAIL", apOLPRRInsertIncident.RpEmail)
, new SqlParameter("@IC_FIRSTNAME", apOLPRRInsertIncident.IcFirstName)
, new SqlParameter("@IC_LASTNAME", apOLPRRInsertIncident.IcLastName)
, new SqlParameter("@IC_ORGANIZATION", apOLPRRInsertIncident.IcOrganization)
, new SqlParameter("@IC_ADDRESS", apOLPRRInsertIncident.IcAddress)
, new SqlParameter("@IC_ADDRESS2", apOLPRRInsertIncident.IcAddress2)
, new SqlParameter("@IC_CITY", apOLPRRInsertIncident.IcCity)
, new SqlParameter("@IC_STATE", apOLPRRInsertIncident.IcState)
, new SqlParameter("@IC_ZIPCODE", apOLPRRInsertIncident.IcZipcode)
, new SqlParameter("@IC_PHONE", apOLPRRInsertIncident.IcPhone)
, new SqlParameter("@IC_EMAIL", apOLPRRInsertIncident.IcEmail)
, new SqlParameter("@GROUNDWATER", apOLPRRInsertIncident.GroundWater)
, new SqlParameter("@SURFACEWATER", apOLPRRInsertIncident.SurfaceWater)
, new SqlParameter("@DRINKINGWATER", apOLPRRInsertIncident.DringkingWater)
, new SqlParameter("@SOIL", apOLPRRInsertIncident.Soil)
, new SqlParameter("@VAPOR", apOLPRRInsertIncident.Vapor)
, new SqlParameter("@FREEPRODUCT", apOLPRRInsertIncident.FreeProduct)
, new SqlParameter("@UNLEADEDGAS", apOLPRRInsertIncident.UnleadedGas)
, new SqlParameter("@LEADEDGAS", apOLPRRInsertIncident.LeadedGas)
, new SqlParameter("@MISGAS", apOLPRRInsertIncident.MisGas)
, new SqlParameter("@DIESEL", apOLPRRInsertIncident.Diesel)
, new SqlParameter("@WASTEOIL", apOLPRRInsertIncident.WasteOil)
, new SqlParameter("@HEATINGOIL", apOLPRRInsertIncident.HeatingOil)
, new SqlParameter("@LUBRICANT", apOLPRRInsertIncident.Lubricant)
, new SqlParameter("@SOLVENT", apOLPRRInsertIncident.Solvent)
, new SqlParameter("@OTHERPET", apOLPRRInsertIncident.OtherPet)
, new SqlParameter("@CHEMICAL", apOLPRRInsertIncident.Chemical)
, new SqlParameter("@UNKNOWN", apOLPRRInsertIncident.Unknown)
, new SqlParameter("@MTBE", apOLPRRInsertIncident.Mtbe)
, new SqlParameter("@SUBMIT_DATETIME", apOLPRRInsertIncident.SubmitDateTime)
, new SqlParameter("@DEQ_OFFICE", apOLPRRInsertIncident.DeqOffice)
};
var pErrNum = new SqlParameter
{
ParameterName = "@ErrNum",
SqlDbType = SqlDbType.SmallInt,
Direction = ParameterDirection.Output
//SqlValue = 0
//Value = 0
}
;
var pContractorUid = new SqlParameter("@CONTRACTOR_UID", apOLPRRInsertIncident.ContractorUid);
var pContractorPwd = new SqlParameter("@CONTRACTOR_PWD", apOLPRRInsertIncident.ContractorPwd);
var pReportedBy = new SqlParameter("@REPORTED_BY", apOLPRRInsertIncident.ReportedBy);
var pReportedByPhone = new SqlParameter("@REPORTED_BY_PHONE", apOLPRRInsertIncident.ReportedByPhone);
var pReportedByEmail = new SqlParameter("@REPORTED_BY_EMAIL", apOLPRRInsertIncident.ReportedByEmail);
var pReleaseType = new SqlParameter("@RELEASE_TYPE", apOLPRRInsertIncident.ReleaseType);
var pDateReceived = new SqlParameter("@DATE_RECEIVED", apOLPRRInsertIncident.DateReceived);
var pFacilityId = new SqlParameter("@FACILITY_ID", apOLPRRInsertIncident.FacilityId);
var pSiteName = new SqlParameter("@SITE_NAME", apOLPRRInsertIncident.SiteName);
var pSiteCounty = new SqlParameter("@SITE_COUNTY", apOLPRRInsertIncident.SiteCounty);
var pStreetNbr = new SqlParameter("@STREET_NBR", apOLPRRInsertIncident.StreetNbr);
var pStreetQuad = new SqlParameter("@STREET_QUAD", apOLPRRInsertIncident.StreetQuad);
var pStreetName = new SqlParameter("@STREET_NAME", apOLPRRInsertIncident.StreetName);
var pStreetType = new SqlParameter("@STREET_TYPE", apOLPRRInsertIncident.StreetType);
var pSiteAddress = new SqlParameter("@SITE_ADDRESS", apOLPRRInsertIncident.SiteAddress);
var pSiteCity = new SqlParameter("@SITE_CITY", apOLPRRInsertIncident.SiteCity);
var pSiteZipcode = new SqlParameter("@SITE_ZIPCODE", apOLPRRInsertIncident.SiteZipcode);
var pSitePhone = new SqlParameter("@SITE_PHONE", apOLPRRInsertIncident.SitePhone);
var pInitialComment = new SqlParameter("@INITIAL_COMMENT", apOLPRRInsertIncident.InitialComment);
var pDiscoveryDate = new SqlParameter("@DISCOVERY_DATE", apOLPRRInsertIncident.DiscoveryDate);
var pConfirmationCode = new SqlParameter("@CONFIRMATION_CODE", apOLPRRInsertIncident.ConfirmationCode);
var pDiscoveryCode = new SqlParameter("@DISCOVERY_CODE", apOLPRRInsertIncident.DiscoveryCode);
var pCauseCode = new SqlParameter("@CAUSE_CODE", apOLPRRInsertIncident.CauseCode);
var pSourceId = new SqlParameter("@SOURCEID", apOLPRRInsertIncident.SourceId);
var pRpFirstName = new SqlParameter("@RP_FIRSTNAME", apOLPRRInsertIncident.RpFirstName);
var pRpLastName = new SqlParameter("@RP_LASTNAME", apOLPRRInsertIncident.RpLastName);
var pRpOrganization = new SqlParameter("@RP_ORGANIZATION", apOLPRRInsertIncident.RpOrganization);
var pRpAddress = new SqlParameter("@RP_ADDRESS", apOLPRRInsertIncident.RpAddress);
var pRpAddress2 = new SqlParameter("@RP_ADDRESS2", apOLPRRInsertIncident.RpAddress2);
var pRpCity = new SqlParameter("@RP_CITY", apOLPRRInsertIncident.RpCity);
var pRpState = new SqlParameter("@RP_STATE", apOLPRRInsertIncident.RpState);
var pRpZipcode = new SqlParameter("@RP_ZIPCODE", apOLPRRInsertIncident.RpZipcode);
var pRpPhone = new SqlParameter("@RP_PHONE", apOLPRRInsertIncident.RpPhone);
var pRpEmail = new SqlParameter("@RP_EMAIL", apOLPRRInsertIncident.RpEmail);
var pIcFirstName = new SqlParameter("@IC_FIRSTNAME", apOLPRRInsertIncident.IcFirstName);
var pIcLastName = new SqlParameter("@IC_LASTNAME", apOLPRRInsertIncident.IcLastName);
var pIcOrganization = new SqlParameter("@IC_ORGANIZATION", apOLPRRInsertIncident.IcOrganization);
var pIcAddress = new SqlParameter("@IC_ADDRESS", apOLPRRInsertIncident.IcAddress);
var pIcAddress2 = new SqlParameter("@IC_ADDRESS2", apOLPRRInsertIncident.IcAddress2);
var pIcCity = new SqlParameter("@IC_CITY", apOLPRRInsertIncident.IcCity);
var pIcState = new SqlParameter("@IC_STATE", apOLPRRInsertIncident.IcState);
var pIcZipcode = new SqlParameter("@IC_ZIPCODE", apOLPRRInsertIncident.IcZipcode);
var pIcPhone = new SqlParameter("@IC_PHONE", apOLPRRInsertIncident.IcPhone);
var pIcEmail = new SqlParameter("@IC_EMAIL", apOLPRRInsertIncident.IcEmail);
var pGroundWater = new SqlParameter("@GROUNDWATER", apOLPRRInsertIncident.GroundWater);
var pSurfaceWater = new SqlParameter("@SURFACEWATER", apOLPRRInsertIncident.SurfaceWater);
var pDringkingWater = new SqlParameter("@DRINKINGWATER", apOLPRRInsertIncident.DringkingWater);
var pSoil = new SqlParameter("@SOIL", apOLPRRInsertIncident.Soil);
var pVapor = new SqlParameter("@VAPOR", apOLPRRInsertIncident.Vapor);
var pFreeProduct = new SqlParameter("@FREEPRODUCT", apOLPRRInsertIncident.FreeProduct);
var pUnleadedGas = new SqlParameter("@UNLEADEDGAS", apOLPRRInsertIncident.UnleadedGas);
var pLeadedGas = new SqlParameter("@LEADEDGAS", apOLPRRInsertIncident.LeadedGas);
var pMisGas = new SqlParameter("@MISGAS", apOLPRRInsertIncident.MisGas);
var pDiesel = new SqlParameter("@DIESEL", apOLPRRInsertIncident.Diesel);
var pWasteOil = new SqlParameter("@WASTEOIL", apOLPRRInsertIncident.WasteOil);
var pHeatingOil = new SqlParameter("@HEATINGOIL", apOLPRRInsertIncident.HeatingOil);
var pLubricant = new SqlParameter("@LUBRICANT", apOLPRRInsertIncident.Lubricant);
var pSolvent = new SqlParameter("@SOLVENT", apOLPRRInsertIncident.Solvent);
var pOtherPet = new SqlParameter("@OTHERPET", apOLPRRInsertIncident.OtherPet);
var pChemical = new SqlParameter("@CHEMICAL", apOLPRRInsertIncident.Chemical);
var pUnknown = new SqlParameter("@UNKNOWN", apOLPRRInsertIncident.Unknown);
var pMtbe = new SqlParameter("@MTBE", apOLPRRInsertIncident.Mtbe);
var pSubmitDateTime = new SqlParameter("@SUBMIT_DATETIME", apOLPRRInsertIncident.SubmitDateTime);
var pDeqOffice = new SqlParameter("@DEQ_OFFICE", apOLPRRInsertIncident.DeqOffice);
//var result = await _dbContext.Database.ExecuteSqlCommandAsync("execute dbo.apOLPRRInsertIncident {0} @ErrNum OUTPUT", apOLPRRInsertIncident, outParameter);
//var result = await _dbContext.Set<OutParam>().AsNoTracking().FromSql("execute dbo.apOLPRRInsertIncident @CONTRACTOR_UID ", pContractorUid).FirstOrDefaultAsync();
//var result = await _dbContext.Set<OutParam>().AsNoTracking().FromSql("execute dbo.apOLPRRInsertIncident @ErrNum OUTPUT, @CONTRACTOR_UID, @CONTRACTOR_PWD, @ "
// , outParameter, pContractorUid).FirstOrDefaultAsync();
//var result = await _dbContext.Set<OutParam>().AsNoTracking().FromSql("execute dbo.apOLPRRInsertIncident " +
// " @ErrNum OUTPUT, @CONTRACTOR_UID, @CONTRACTOR_PWD, @REPORTED_BY, @REPORTED_BY_PHONE, @REPORTED_BY_EMAIL, @RELEASE_TYPE, @DATE_RECEIVED,@FACILITY_ID, @SITE_NAME,@SITE_COUNTY" +
// ", @STREET_NBR, @STREET_QUAD,@STREET_NAME,@STREET_TYPE,@SITE_ADDRESS,@SITE_CITY,@SITE_ZIPCODE,@SITE_PHONE, @INITIAL_COMMENT, @DISCOVERY_DATE, @CONFIRMATION_CODE" +
// ", @DISCOVERY_CODE,@CAUSE_CODE,@SOURCEID,@RP_FIRSTNAME,@RP_LASTNAME,@RP_ORGANIZATION,@RP_ADDRESS,@RP_CITY,@RP_STATE,@RP_ZIPCODE,@RP_PHONE,@RP_EMAIL" +
// ", @IC_FIRSTNAME,@IC_LASTNAME,@IC_ORGANIZATION,@IC_ADDRESS,@IC_CITY,@IC_STATE,@IC_ZIPCODE,@IC_PHONE,@IC_EMAIL" +
// ", @GROUNDWATER,@SURFACEWATER,@DRINKINGWATER,@SOIL,@VAPOR,@FREEPRODUCT,@UNLEADEDGAS,@LEADEDGAS,@MISGAS,@DIESEL,@WASTEOIL,@HEATINGOIL,@LUBRICANT,@SOLVENT" +
// ", @OTHERPET,@CHEMICAL,@UNKNOWN,@MTBE,@SUBMIT_DATETIME,@DEQ_OFFICE"
//, outParameter, pContractorUid, pContractorPwd, pReportedBy, pReportedByPhone, pReportedByEmail, pReleaseType, pDateReceived, pFacilityId, pSiteName, pSiteCounty
//, pStreetNbr , pStreetQuad, pStreetName, pStreetType, pSiteAddress, pSiteCity, pSiteZipcode, pSitePhone, pInitialComment, pDiscoveryDate, pConfirmationCode
//, pDiscoveryCode, pCauseCode, pSourceId, pRpFirstName, pRpLastName, pRpOrganization, pRpAddress, pRpAddress2, pRpCity, pRpState, pRpZipcode, pRpPhone, pRpEmail
//, pIcFirstName, pIcLastName, pIcOrganization, pIcAddress, pIcAddress2, pIcCity, pIcState, pIcZipcode, pIcPhone, pIcEmail
//, pGroundWater, pSurfaceWater, pDringkingWater, pSoil, pVapor, pFreeProduct, pUnleadedGas, pLeadedGas, pMisGas, pDiesel, pWasteOil, pHeatingOil, pLubricant, pSolvent
//, pOtherPet, pChemical, pUnknown, pMtbe, pSubmitDateTime, pDeqOffice).FirstOrDefaultAsync();
var result = await _dbContext.Set <OutParam>().AsNoTracking().FromSql("execute dbo.apOLPRRInsertIncident " +
" @ErrNum, @CONTRACTOR_UID, @CONTRACTOR_PWD, @REPORTED_BY, @REPORTED_BY_PHONE, @REPORTED_BY_EMAIL, @RELEASE_TYPE, @DATE_RECEIVED,@FACILITY_ID, @SITE_NAME,@SITE_COUNTY" +
", @STREET_NBR, @STREET_QUAD,@STREET_NAME,@STREET_TYPE,@SITE_ADDRESS,@SITE_CITY,@SITE_ZIPCODE,@SITE_PHONE, @INITIAL_COMMENT, @DISCOVERY_DATE, @CONFIRMATION_CODE" +
", @DISCOVERY_CODE,@CAUSE_CODE,@SOURCEID,@RP_FIRSTNAME,@RP_LASTNAME,@RP_ORGANIZATION,@RP_ADDRESS,@RP_ADDRESS2,@RP_CITY,@RP_STATE,@RP_ZIPCODE,@RP_PHONE,@RP_EMAIL" +
", @IC_FIRSTNAME,@IC_LASTNAME,@IC_ORGANIZATION,@IC_ADDRESS,@IC_ADDRESS2,@IC_CITY,@IC_STATE,@IC_ZIPCODE,@IC_PHONE,@IC_EMAIL" +
", @GROUNDWATER,@SURFACEWATER,@DRINKINGWATER,@SOIL,@VAPOR,@FREEPRODUCT,@UNLEADEDGAS,@LEADEDGAS,@MISGAS,@DIESEL,@WASTEOIL,@HEATINGOIL,@LUBRICANT,@SOLVENT" +
", @OTHERPET,@CHEMICAL,@UNKNOWN,@MTBE,@SUBMIT_DATETIME,@DEQ_OFFICE"
, pErrNum, pContractorUid, pContractorPwd, pReportedBy, pReportedByPhone, pReportedByEmail, pReleaseType, pDateReceived, pFacilityId, pSiteName, pSiteCounty
, pStreetNbr, pStreetQuad, pStreetName, pStreetType, pSiteAddress, pSiteCity, pSiteZipcode, pSitePhone, pInitialComment, pDiscoveryDate, pConfirmationCode
, pDiscoveryCode, pCauseCode, pSourceId, pRpFirstName, pRpLastName, pRpOrganization, pRpAddress, pRpAddress2, pRpCity, pRpState, pRpZipcode, pRpPhone, pRpEmail
, pIcFirstName, pIcLastName, pIcOrganization, pIcAddress, pIcAddress2, pIcCity, pIcState, pIcZipcode, pIcPhone, pIcEmail
, pGroundWater, pSurfaceWater, pDringkingWater, pSoil, pVapor, pFreeProduct, pUnleadedGas, pLeadedGas, pMisGas, pDiesel, pWasteOil, pHeatingOil, pLubricant, pSolvent
, pOtherPet, pChemical, pUnknown, pMtbe, pSubmitDateTime, pDeqOffice).FirstOrDefaultAsync();
//int test = 0;
//var result = await _dbContext.Set<OutParam>().AsNoTracking().FromSql($"execute dbo.apOLPRRInsertIncident " +
//" {'0'} , {apOLPRRInsertIncident.ContractorUid}, {apOLPRRInsertIncident.ContractorPwd}, {apOLPRRInsertIncident.ReportedBy}, {apOLPRRInsertIncident.ReportedByEmail},{apOLPRRInsertIncident.ReleaseType}, {apOLPRRInsertIncident.DateReceived},{apOLPRRInsertIncident.FacilityId}, {apOLPRRInsertIncident.SiteName},{apOLPRRInsertIncident.SiteCounty}" +
//", {apOLPRRInsertIncident.StreetNbr}, {apOLPRRInsertIncident.StreetQuad},{apOLPRRInsertIncident.StreetName},{apOLPRRInsertIncident.StreetType},{apOLPRRInsertIncident.SiteAddress},{apOLPRRInsertIncident.SiteCity},{apOLPRRInsertIncident.SiteZipcode},{apOLPRRInsertIncident.SitePhone}, {apOLPRRInsertIncident.InitialComment},{ apOLPRRInsertIncident.DiscoveryDate},{ apOLPRRInsertIncident.ConfirmationCode)" +
//", {apOLPRRInsertIncident.DiscoveryCode},{apOLPRRInsertIncident.CauseCode},{apOLPRRInsertIncident.SourceId},{apOLPRRInsertIncident.RpFirstName},{apOLPRRInsertIncident.RpLastName},{apOLPRRInsertIncident.RpOrganization},{apOLPRRInsertIncident.RpAddress},{apOLPRRInsertIncident.RpCity},{apOLPRRInsertIncident.RpState},{apOLPRRInsertIncident.RpZipcode},{apOLPRRInsertIncident.RpPhone},{apOLPRRInsertIncident.RpEmail}" +
//", {apOLPRRInsertIncident.IcFirstName},{apOLPRRInsertIncident.IcLastName},{apOLPRRInsertIncident.IcOrganization},{apOLPRRInsertIncident.IcAddress},{apOLPRRInsertIncident.IcAddress2},{apOLPRRInsertIncident.IcCity},{apOLPRRInsertIncident.IcState},{apOLPRRInsertIncident.IcZipcode},{apOLPRRInsertIncident.IcPhone},{apOLPRRInsertIncident.IcEmail}" +
//", {apOLPRRInsertIncident.GroundWater},{apOLPRRInsertIncident.SurfaceWater},{apOLPRRInsertIncident.DringkingWater},{apOLPRRInsertIncident.Soil},{apOLPRRInsertIncident.Vapor},{apOLPRRInsertIncident.FreeProduct},{apOLPRRInsertIncident.UnleadedGas},{apOLPRRInsertIncident.LeadedGas},{apOLPRRInsertIncident.MisGas},{apOLPRRInsertIncident.Diesel},{apOLPRRInsertIncident.WasteOil},{apOLPRRInsertIncident.HeatingOil},{apOLPRRInsertIncident.Lubricant},{apOLPRRInsertIncident.Solvent}" +
//", [apOLPRRInsertIncident.OtherPet},{apOLPRRInsertIncident.Chemical},{apOLPRRInsertIncident.Unknown},{apOLPRRInsertIncident.Mtbe},{apOLPRRInsertIncident.SubmitDateTime},{apOLPRRInsertIncident.DeqOffice").FirstOrDefaultAsync();
return(1);
}
