internal int InsertOIStgInputCompanyMatchRefresh(OIInpCompanyEntityMatchRefresh objCompany) { int result = 0; try { StoredProcedureEntity sproc = new StoredProcedureEntity(); sproc.StoredProcedureName = "oi.OIInsertStgInputCompanyMatchRefresh"; sproc.StoredProceduresParameter.Add(GetParam("@ImportProcessId", objCompany.ImportProcessId.ToString().Trim(), SQLServerDatatype.IntDataType)); sproc.StoredProceduresParameter.Add(GetParam("@orb_num", !string.IsNullOrEmpty(objCompany.OrbNumber) ? objCompany.OrbNumber.ToString().Trim() : null, SQLServerDatatype.VarcharDataType)); result = Convert.ToInt32(sql.ExecuteScalar(CommandType.StoredProcedure, sproc)); } catch (Exception) { throw; } return(result); }
public int InsertOIStgInputCompanyMatchRefresh(OIInpCompanyEntityMatchRefresh objCompany) { return(rep.InsertOIStgInputCompanyMatchRefresh(objCompany)); }