internal int InsertOIStgInputCompany(OIInpCompanyEntity objCompany)
{
int result = 0;
try
{
StoredProcedureEntity sproc = new StoredProcedureEntity();
sproc.StoredProcedureName = "ext.InsertOIStgInputCompany";
sproc.StoredProceduresParameter.Add(GetParam("@ImportProcessId", objCompany.ImportProcessId.ToString().Trim(), SQLServerDatatype.IntDataType));
sproc.StoredProceduresParameter.Add(GetParam("@SrcRecordId", objCompany.SrcRecordId.ToString().Trim(), SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CompanyName", !string.IsNullOrEmpty(objCompany.CompanyName) ? objCompany.CompanyName.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Address1", !string.IsNullOrEmpty(objCompany.Address1) ? objCompany.Address1.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Address2", !string.IsNullOrEmpty(objCompany.Address2) ? objCompany.Address2.ToString().Trim() : "", SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@City", !string.IsNullOrEmpty(objCompany.City) ? objCompany.City.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@State", !string.IsNullOrEmpty(objCompany.State) ? objCompany.State.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PostalCode", !string.IsNullOrEmpty(objCompany.PostalCode) ? objCompany.PostalCode.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Country", !string.IsNullOrEmpty(objCompany.Country) ? objCompany.Country.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@PhoneNbr", !string.IsNullOrEmpty(objCompany.PhoneNbr) ? objCompany.PhoneNbr.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Tags", !string.IsNullOrEmpty(objCompany.OrbSingleEntryTags) ? objCompany.OrbSingleEntryTags.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@EIN", !string.IsNullOrEmpty(objCompany.EIN) ? objCompany.EIN.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@OrbNum", !string.IsNullOrEmpty(objCompany.OrbNum) ? objCompany.OrbNum.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@CEOName", !string.IsNullOrEmpty(objCompany.CEOName) ? objCompany.CEOName.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Website", !string.IsNullOrEmpty(objCompany.Website) ? objCompany.Website.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AltCompanyName", !string.IsNullOrEmpty(objCompany.AltCompanyName) ? objCompany.AltCompanyName.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AltAddress1", !string.IsNullOrEmpty(objCompany.AltAddress1) ? objCompany.AltAddress1.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AltAddress2", !string.IsNullOrEmpty(objCompany.AltAddress2) ? objCompany.AltAddress2.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AltCity", !string.IsNullOrEmpty(objCompany.AltCity) ? objCompany.AltCity.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AltState", !string.IsNullOrEmpty(objCompany.AltState) ? objCompany.AltState.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AltPostalCode", !string.IsNullOrEmpty(objCompany.AltPostalCode) ? objCompany.AltPostalCode.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@AltCountry", !string.IsNullOrEmpty(objCompany.AltCountry) ? objCompany.AltCountry.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
sproc.StoredProceduresParameter.Add(GetParam("@Email", !string.IsNullOrEmpty(objCompany.Email) ? objCompany.Email.ToString().Trim() : null, SQLServerDatatype.VarcharDataType));
result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc));
}
catch (Exception)
{
throw;
}
return(result);
}
public int InsertOIStgInputCompany(OIInpCompanyEntity objCompany)
{
return(rep.InsertOIStgInputCompany(objCompany));
}
