public async static Task <IDTO> AddUpdateMode(Acttribute busnies)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (busnies.ID.HasValue)
{
oracleParams.Add(AttributesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)busnies.ID ?? DBNull.Value);
SPName = AttributesPName.SP_UPADTE_Attribute;
message = "Updated Successfully";
}
else
{
oracleParams.Add(AttributesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = AttributesPName.SP_INSERT_Attribute;
message = "Inserted Successfully";
}
oracleParams.Add(AttributesSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)busnies.Name ?? DBNull.Value, 1000);
oracleParams.Add(AttributesSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)busnies.Name2 ?? DBNull.Value, 1000);
oracleParams.Add(AttributesSpParams.PARAMETER_TYPE, OracleDbType.Long, ParameterDirection.Input, (object)busnies.Type ?? DBNull.Value, 1000);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdateMode(ReportGroup bank)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (bank.ID.HasValue)
{
oracleParams.Add(ReportGroupSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)bank.ID ?? DBNull.Value);
SPName = ReportGroupSPName.SP_UPADTE_ReportGroup;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ReportGroupSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ReportGroupSPName.SP_INSERT_ReportGroup;
message = "Inserted Successfully";
}
oracleParams.Add(ReportGroupSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.Name ?? DBNull.Value, 500);
oracleParams.Add(ReportGroupSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.Name2 ?? DBNull.Value, 500);
oracleParams.Add(ReportGroupSpParams.PARAMETER_ORDER_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)bank.OrderBy ?? DBNull.Value, 50);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AutoAdd(Attachment attachment)
{
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
oracleParams.Add(AttachmentsSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.DocumentID ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_UW_RISK_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.RiskID ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_CLM_ID, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.ClaimID ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_LOC_LEVEL, OracleDbType.Int64, ParameterDirection.Input, (object)attachment.Level ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)attachment.CreatedBy ?? DBNull.Value);
oracleParams.Add(AttachmentsSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)attachment.CreationDate ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(AttachmentsSpName.SP_AUTO_INSERT_ATTACHMENT, oracleParams) == -1)
{
complate.message = "Operation Success";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> UpdateMode(Currency currency)
{
OracleDynamicParameters dyParam = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
dyParam.Add(CurrencySpParams.PARAMETER_CURRENCY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.Code ?? DBNull.Value, 30);
dyParam.Add(CurrencySpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.Name ?? DBNull.Value, 500);
dyParam.Add(CurrencySpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.Name2 ?? DBNull.Value, 500);
dyParam.Add(CurrencySpParams.PARAMETER_DECIMAL_PLACES, OracleDbType.Int32, ParameterDirection.Input, (object)currency.DecimalPlaces ?? DBNull.Value, 5);
dyParam.Add(CurrencySpParams.PARAMETER_SIGN, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.Sign ?? DBNull.Value, 200);
dyParam.Add(CurrencySpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)currency.Status ?? DBNull.Value);
dyParam.Add(CurrencySpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)currency.StatusDate ?? DBNull.Value);
dyParam.Add(CurrencySpParams.PARAMETER_FRACT, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.FractName ?? DBNull.Value, 500);
dyParam.Add(CurrencySpParams.PARAMETER_FRACT2, OracleDbType.Varchar2, ParameterDirection.Input, (object)currency.FractName2 ?? DBNull.Value, 500);
if (await NonQueryExecuter.ExecuteNonQueryAsync(CurrencySPName.SP_UPDATE_CURRENCY, dyParam) == -1)
{
complate.message = "Operation Successed";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Domain.Entities.ProductSetup.ProductColumns productColumns)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (productColumns.ID.HasValue)
{
oracleParams.Add(ProductColumnSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ID ?? DBNull.Value);
SPName = ProductColumnsSpName.SP_UPADTE_COLUMN;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ProductColumnSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ProductColumnsSpName.SP_INSERT_COLUMN;
message = "Inserted Successfully";
}
oracleParams.Add(ProductColumnSpParam.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable2 ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_COL_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ColumnType ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.Status ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)productColumns.StatusDate ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.LineOfBusniess ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_SUB_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.SubLineOfBusniess ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_LOC_LEVEL, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.LocLevel ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_PRD_CLO_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.PrdColumnID ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_PRD_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductCategoryID ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.CategoryID ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductID ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductDetailID ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_COL_ORDER, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.Order ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ColumnID ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_DIC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.DictionaryID ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_ST_DIC_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.DictionaryColumnID ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_REF_TABLE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.RefTable ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_WHERE_COND, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.WhereCondition ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.CreateBy ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)productColumns.CreationDate ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.ModifiedBy ?? DBNull.Value);
oracleParams.Add(ProductColumnSpParam.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)productColumns.ModificationDate ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Installment installment)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (installment.ID.HasValue)
{
oracleParams.Add(InstallmetSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)installment.ID ?? DBNull.Value);
SPName = InstallmentSpName.SP_UPADTE_INSTALLMENT;
message = "Updated Successfully";
}
else
{
oracleParams.Add(InstallmetSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = InstallmentSpName.SP_INSERT_INSTALLMENT;
message = "Inserted Successfully";
}
oracleParams.Add(InstallmetSpParams.PARAMETER_DUE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)installment.DueDate ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_GROSS_AMOUNT, OracleDbType.Double, ParameterDirection.Input, (object)installment.GrossAmount ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_GROSS_AMOUNT_LC, OracleDbType.Double, ParameterDirection.Input, (object)installment.GrossAmountLc ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_NET_AMOUNT, OracleDbType.Double, ParameterDirection.Input, (object)installment.NetAmount ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_NET_AMOUNT_LC, OracleDbType.Double, ParameterDirection.Input, (object)installment.NetAmountLc ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_INST_FEES, OracleDbType.Double, ParameterDirection.Input, (object)installment.FeesAmount ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_INST_FEES_LC, OracleDbType.Double, ParameterDirection.Input, (object)installment.FeesAmountLC ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_EXRATE, OracleDbType.Double, ParameterDirection.Input, (object)installment.Exrate ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)installment.CreatedBy ?? DBNull.Value, 1000);
oracleParams.Add(InstallmetSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)installment.CreationDate ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)installment.ModifiedBy ?? DBNull.Value, 1000);
oracleParams.Add(InstallmetSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)installment.ModificationDate ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)installment.DocumentID ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_INST_COMM, OracleDbType.Decimal, ParameterDirection.Input, (object)installment.CommissionAmount ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_INST_COMM_LC, OracleDbType.Decimal, ParameterDirection.Input, (object)installment.CommissionAmountLc ?? DBNull.Value);
oracleParams.Add(InstallmetSpParams.PARAMETER_INS_PERCENT, OracleDbType.Decimal, ParameterDirection.Input, (object)installment.Percent ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = "Operation Success";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdateMode(Company company)
{
string SPName = "";
string message = "";
OracleDynamicParameters dyParam = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (company.ID.HasValue)
{
dyParam.Add(CompanySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)company.ID ?? DBNull.Value);
SPName = CompanySPName.SP_UPADTE_COMPANY;
message = "Updated Successfully";
}
else
{
dyParam.Add(CompanySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = CompanySPName.SP_INSERT_COMPANY;
message = "Inserted Successfully";
}
dyParam.Add(CompanySpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Name ?? DBNull.Value, 500);
dyParam.Add(CompanySpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Name ?? DBNull.Value, 500);
dyParam.Add(CompanySpParams.PARAMETER_PHONE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Phone ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_COUNTRY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.CountryCode ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_MOBILE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Mobile ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_FAX, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Fax ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_EMAIL, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Email ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_WEBSITE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Website ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_ADDRESS, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Address ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_ADDRESS2, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Address2 ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_CONTACT_PERSON, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.ContactPerson ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Code ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_COUNTRY_CURRENCY_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.CurrencyCode ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_COUNTRY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)company.CountryID ?? DBNull.Value);
dyParam.Add(CompanySpParams.PARAMETER_LOGO, OracleDbType.Varchar2, ParameterDirection.Input, (object)company.Logo ?? DBNull.Value, 30);
dyParam.Add(CompanySpParams.PARAMETER_PASS_MLENGHT, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinLength ?? DBNull.Value);
dyParam.Add(CompanySpParams.PARAMETER_PASS_MUPPER, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinUpperCase ?? DBNull.Value);
dyParam.Add(CompanySpParams.PARAMETER_PASS_MLOWER, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinLowerCase ?? DBNull.Value);
dyParam.Add(CompanySpParams.PARAMETER_PASS_MDIGITS, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinNumbers ?? DBNull.Value);
dyParam.Add(CompanySpParams.PARAMETER_PASS_MSPECIAL, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordMinSpecialCharacters ?? DBNull.Value);
dyParam.Add(CompanySpParams.PARAMETER_PASS_EXPIRY_PERIOD, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordExpiryDays ?? DBNull.Value);
dyParam.Add(CompanySpParams.PARAMETER_PASS_LOGATTEMPTS, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordFailedLoginAttempts ?? DBNull.Value);
dyParam.Add(CompanySpParams.PARAMETER_PASS_REPEAT, OracleDbType.Int32, ParameterDirection.Input, (object)company.PasswordRepeats ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, dyParam) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Entities.Financial.CustomerCommission customerCommission)
{
string SPName = "";
string message = "";
ComplateOperation <int> complate = new ComplateOperation <int>();
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
if (customerCommission.ID.HasValue)
{
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.ID ?? DBNull.Value);
SPName = CustomerCommissionSpName.SP_UPADTE_CUSTOMER_COMM;
message = "Updated Successfully";
}
else
{
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = CustomerCommissionSpName.SP_INSERT_CUSTOMER_COMM;
message = "Inserted Successfully";
}
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.CustomerID ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_LOC_CUST_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.LocCustomerType ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerCommission.CreatedBy ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerCommission.CreationDate ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerCommission.ModifiedBy ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerCommission.ModificationDate ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_COMM_PERC, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.ComissionPercentage ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_COMM_AMOUNT, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.CommissionAmount ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_COMM_AMOUNT_LC, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.CommissionAmount ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.ProductId ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.ProductDetailId ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.LineOfBusiness ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.SubLineOfBusiness ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_DRT_CR, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.DrtCr ?? DBNull.Value);
oracleParams.Add(CustomerCommissionSpParams.PARAMETER_LOC_COMM_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)customerCommission.LocCommissionType ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Pricing pricing)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (pricing.ID.HasValue)
{
oracleParams.Add(PricingSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.ID ?? DBNull.Value);
SPName = PricingSpName.SP_UPADTE_PRICING;
message = "Updated Successfully";
}
else
{
oracleParams.Add(PricingSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = PricingSpName.SP_INSERT_PRICING;
message = "Inserted Successfully";
}
oracleParams.Add(PricingSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.Name ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.Name2 ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.CreatedBy ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.CreationDate ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricing.ModifiedBy ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.ModificationDate ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.Status ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.StatusDate ?? DBNull.Value, 1000);
oracleParams.Add(PricingSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.ProductID ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.EffectiveDate ?? DBNull.Value, 1000);
oracleParams.Add(PricingSpParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricing.ExpiryDate ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_LOC_PRICE_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.PricingType ?? DBNull.Value);
oracleParams.Add(PricingSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricing.CustomerID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.ID = oracleParams.Get(0);
complate.message = message;
}
else
{
complate.message = message;
}
return(complate);
}
public async static Task<IDTO> DeleteCompaniesAsync(long[] IDs)
{
ComplateOperation<int> complate = new ComplateOperation<int>();
if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Company), IDs)) == -1)
complate.message = "Operation Successed";
else
complate.message = "Operation Failed";
return complate;
}
public async static Task <IDTO> AddUpdate(FactorDetail factor)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (factor.ID.HasValue)
{
oracleParams.Add(FactorDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ID ?? DBNull.Value);
SPName = FactorDetailSpName.SP_UPADTE_FACTOR_DETAIL;
message = "Updated Successfully";
}
else
{
oracleParams.Add(FactorDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = FactorDetailSpName.SP_INSERT_FACTOR_DETAIL;
message = "Inserted Successfully";
}
oracleParams.Add(FactorDetailSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.Name ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.Name2 ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_DIC_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.DictionaryID ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_ENTRY_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.EntryType ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_FACT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.FactorID ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_FROM_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.FromValue ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_TO_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ToValue ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_F_FROM_DATE, OracleDbType.Date, ParameterDirection.Input, (object)factor.FromDate ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_F_TO_DATE, OracleDbType.Date, ParameterDirection.Input, (object)factor.ToDate ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_CHG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ChargeID ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductID ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductDetailID ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_FRRMULA_EDOTORS, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.FrrmulaEdotors ?? DBNull.Value);
oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_FACD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductFacdID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = "Operation Success";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> DeleteAttributesAsync(long[] IDs)
{
ComplateOperation <int> operation = new ComplateOperation <int>();
if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Acttribute), IDs)) == -1)
{
operation.message = "Operation Successed";
}
else
{
operation.message = "Operation Failed";
}
return(operation);
}
public async static Task <IDTO> AddUpdateMode(Share share)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (share.ID.HasValue)
{
oracleParams.Add(SharesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.ID ?? DBNull.Value);
SPName = SharesSpName.SP_UPADTE_SHARE;
message = "Updated Successfully";
}
else
{
oracleParams.Add(SharesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = SharesSpName.SP_INSERT_SHARE;
message = "Inserted Successfully";
}
oracleParams.Add(SharesSpParams.PARAMETER_LOC_SHARE_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)share.LocShareType ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_PRCNT, OracleDbType.Decimal, ParameterDirection.Input, (object)share.Percent ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_SHARE_PER, OracleDbType.Decimal, ParameterDirection.Input, (object)share.SharePercent ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_AMOUNT, OracleDbType.Decimal, ParameterDirection.Input, (object)share.Amount ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_AMOUNT_LC, OracleDbType.Decimal, ParameterDirection.Input, (object)share.AmountLC ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_NOTES, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.Notes ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.CreatedBy ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)share.CreationDate ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)share.ModifiedBy ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)share.ModificationDate ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.DocumentID ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)share.CustomerId ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)share.StLOB ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)share.StSubLOB ?? DBNull.Value);
oracleParams.Add(SharesSpParams.PARAMETER_DR_CR, OracleDbType.Int64, ParameterDirection.Input, (object)share.DrCr ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
complate.ID = oracleParams.Get(0);
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Column column)
{
var SPName = default(string);
var message = default(string);
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (column.ID.HasValue)
{
oracleParams.Add(ColumnSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ID ?? DBNull.Value);
SPName = ColumnSpName.SP_UPADTE_COLUMN;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ColumnSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ColumnSpName.SP_INSERT_COLUMN;
message = "Inserted Successfully";
}
oracleParams.Add(ColumnSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Name ?? DBNull.Value, 1000);
oracleParams.Add(ColumnSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Name2 ?? DBNull.Value, 1000);
oracleParams.Add(ColumnSpParams.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Lable ?? DBNull.Value, 1000);
oracleParams.Add(ColumnSpParams.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Lable2 ?? DBNull.Value, 1000);
oracleParams.Add(ColumnSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)column.Status ?? DBNull.Value);
oracleParams.Add(ColumnSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)column.StatusDate ?? DBNull.Value);
oracleParams.Add(ColumnSpParams.PARAMETER_COLUMN_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)column.ColumnType ?? DBNull.Value);
oracleParams.Add(ColumnSpParams.PARAMETER_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)column.LineOfBusniess ?? DBNull.Value);
oracleParams.Add(ColumnSpParams.PARAMETER_SUB_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)column.SubLineOfBusniess ?? DBNull.Value);
oracleParams.Add(ColumnSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.CreateBy ?? DBNull.Value, 20);
oracleParams.Add(ColumnSpParams.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)column.CreationDate ?? DBNull.Value);
oracleParams.Add(ColumnSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.ModifiedBy ?? DBNull.Value, 20);
oracleParams.Add(ColumnSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)column.ModificationDate ?? DBNull.Value);
oracleParams.Add(ColumnSpParams.PARAMETER_CATEGORY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.CategoryID ?? DBNull.Value);
oracleParams.Add(ColumnSpParams.PARAMETER_REF_TABLE_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.RefTableName ?? DBNull.Value, 1000);
oracleParams.Add(ColumnSpParams.PARAMETER_REF_MAJOR_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.RefMajorCode ?? DBNull.Value, 1000);
oracleParams.Add(ColumnSpParams.PARAMETER_REF_COL_DETAILS, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.RefColDetailsID ?? DBNull.Value, 1000);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(PricingDetail pricingDetail)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (pricingDetail.ID.HasValue)
{
oracleParams.Add(PricingDetailsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ID ?? DBNull.Value);
SPName = PricingDetailsSpName.SP_UPADTE_PRICING_DETAIL;
message = "Updated Successfully";
}
else
{
oracleParams.Add(PricingDetailsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = PricingDetailsSpName.SP_INSERT_PRICING_DETAIL;
message = "Inserted Successfully";
}
oracleParams.Add(PricingDetailsSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricingDetail.CreatedBy ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.CreationDate ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)pricingDetail.ModifiedBy ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.ModificationDate ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.Status ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.StatusDate ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.EffectiveDate ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)pricingDetail.ExpiryDate ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ProductID ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.ProductDetailID ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.LineOfBusiness ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.SubLineOfBusiness ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_IS_FACTOR, OracleDbType.Int16, ParameterDirection.Input, (object)pricingDetail.IsFactor ?? DBNull.Value);
oracleParams.Add(PricingDetailsSpParams.PARAMETER_ST_PRD_PRIC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)pricingDetail.PricingID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = "Operation Success";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdateMode(Domain.Entities.ProductSetup.ProductWordingDetails wording)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (wording.ID.HasValue)
{
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.ID ?? DBNull.Value);
SPName = ProductWordDetailSpName.SP_UPADTE_PRODUCT_WORDING_DETAIL;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ProductWordDetailSpName.SP_INSERT_PRODUCT_WORDING_DETAIL;
message = "Inserted Successfully";
}
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_SERIAL, OracleDbType.Int64, ParameterDirection.Input, (object)wording.Serial ?? DBNull.Value, 500);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_DESCRIPTION, OracleDbType.Varchar2, ParameterDirection.Input, (object)wording.Description ?? DBNull.Value, 4000);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_DESCRIPTION2, OracleDbType.Varchar2, ParameterDirection.Input, (object)wording.Description2 ?? DBNull.Value, 4000);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_WORD_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)wording.WordType ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)wording.Status ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)wording.StatusDate ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_WORD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.WordId ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_IS_AUTO_ADD, OracleDbType.Int64, ParameterDirection.Input, (object)wording.IsAutoAdd ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.ProductId ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.ProductDetailId ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)wording.LineOfBusiness ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)wording.SubLineOfBusiness ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_ST_SRVCS_ID, OracleDbType.Int64, ParameterDirection.Input, (object)wording.ServiceID ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)wording.CreateBy ?? DBNull.Value, 50);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)wording.CreationDate ?? DBNull.Value);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)wording.ModifiedBy ?? DBNull.Value, 50);
oracleParams.Add(ProductWordDetailSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)wording.ModificationDate ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Entities.Financial.CustomerLicense customerLicense)
{
string SPName = "";
string message = "";
ComplateOperation <int> complate = new ComplateOperation <int>();
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
if (customerLicense.ID.HasValue)
{
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.ID ?? DBNull.Value);
SPName = CustomerLicenseSpName.SP_UPADTE_CUSTOMER_LICENSE;
message = "Updated Successfully";
}
else
{
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = CustomerLicenseSpName.SP_INSERT_CUSTOMER_LICENSE;
message = "Inserted Successfully";
}
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LICNESNO, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerLicense.LicenseNo ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_EFF_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerLicense.EffectiveDate ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_EXP_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerLicense.ExpireDate ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerLicense.CreatedBy ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerLicense.CreationDate ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerLicense.ModifiedBy ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerLicense.ModificationDate ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.CustomerID ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LOC_SPT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.LocSptID ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LOC_COD, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.LocCode ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LOC_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.Status ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_STATUS_DATE, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.StatuseDate ?? DBNull.Value);
oracleParams.Add(CustomerLicenseSpParams.PARAMETER_LOC_PROVIDER_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)customerLicense.LocProviderTyoe ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> DeleteProductReportsAsync(long[] IDs)
{
ComplateOperation <int> complate = new ComplateOperation <int>();
if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Domain.Entities.ProductSetup.ProductReport), IDs)) == -1)
{
complate.message = "Operation Successed";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> DeleteQuestionsAsync(long[] IDs)
{
ComplateOperation <int> complate = new ComplateOperation <int>();
if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Question), IDs)) == -1)
{
complate.message = "Operation Successed";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task<IDTO> DeleteCompanyAsync(Company company)
{
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation<int> complate = new ComplateOperation<int>();
var dyParam = new OracleDynamicParameters();
dyParam.Add(CompanySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)company.ID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(CompanySPName.SP_DELETE_COMPANY, dyParam) == -1)
complate.message = "Operation Successed";
else
complate.message = "Operation Failed";
return complate;
}
public async static Task <IDTO> DeleteCurrenciesAsync(string[] Codes)
{
ComplateOperation <int> complate = new ComplateOperation <int>();
if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Currency), Codes)) == -1)
{
complate.message = "Operation Successed";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> DeleteCommissions(long[] IDs)
{
ComplateOperation <int> complate = new ComplateOperation <int>();
if (await NonQueryExecuter.ExecuteNonQueryAsync(MultiDeleteFormater.Format(typeof(Entities.Financial.CustomerCommission), IDs)) == -1)
{
complate.message = "Operation Successed";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Entities.Financial.CustomerGroupRelation customerGroupRelation)
{
string SPName = "";
string message = "";
ComplateOperation <int> complate = new ComplateOperation <int>();
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
if (customerGroupRelation.ID.HasValue)
{
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.ID ?? DBNull.Value);
SPName = CustomerGrRelationSpName.SP_UPADTE_CUSTOMER_GROUP_RELATIONS;
message = "Updated Successfully";
}
else
{
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = CustomerGrRelationSpName.SP_INSERT_CUSTOMER_GROUP_RELATIONS;
message = "Inserted Successfully";
}
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.Name ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.Name2 ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.CreatedBy ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerGroupRelation.CreationDate ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.ModifiedBy ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerGroupRelation.ModificationDate ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_ST_PARTD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.ProductDetailId ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_LOC_UNITT, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.LocUnit ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_PRICE_AMOUNT, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.PriceAmount ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_FREQ, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.Freq ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_REF_NO, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerGroupRelation.ReferenceNo ?? DBNull.Value);
oracleParams.Add(CustomerGrRelationSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerGroupRelation.CustomerID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdateMode(CustomerContact customerContact)
{
string SPName = "";
string message = "";
ComplateOperation <int> complate = new ComplateOperation <int>();
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
if (customerContact.ID.HasValue)
{
oracleParams.Add(CustomerContactsSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerContact.ID ?? DBNull.Value);
SPName = CustomerContactsSpName.CUSTOMER_CONTACT_UPDATE;
message = "Updated Successfully";
}
else
{
oracleParams.Add(CustomerContactsSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = CustomerContactsSpName.CUSTOMER_CONTACT_INSERT;
message = "Inserted Successfully";
}
oracleParams.Add(CustomerContactsSpParam.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)customerContact.CustomerID ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Name ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Name2 ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_POHNE_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.PhoneCode ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_PHONE, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Phone ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_MOBILE, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Mobile ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_EMAIL, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.Email ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_ST_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)customerContact.LineOfBusiness ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_LOC_INS_DEPT, OracleDbType.Int64, ParameterDirection.Input, (object)customerContact.LocCustomerDept ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.CreatedBy ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_CREATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerContact.CreationDate ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)customerContact.ModifiedBy ?? DBNull.Value);
oracleParams.Add(CustomerContactsSpParam.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)customerContact.ModificationDate ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdateMode(ProductDynamicColumn column)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (column.UwColID.HasValue)
{
oracleParams.Add(ColumnsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.UwColID ?? DBNull.Value);
SPName = ColumsSpName.SP_UPADTE_COLUMNS;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ColumnsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ColumsSpName.SP_INSERT_COLUMNS;
message = "Inserted Successfully";
}
oracleParams.Add(ColumnsSpParams.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Lable ?? DBNull.Value, 100);
oracleParams.Add(ColumnsSpParams.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.Lable2 ?? DBNull.Value, 100);
oracleParams.Add(ColumnsSpParams.PARAMETER_UW_COL_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.UnderWritingColCatID ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_ST_PRD_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ProductCategoryID ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_ST_PRD_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ProductColumnID ?? DBNull.Value, 50);
oracleParams.Add(ColumnsSpParams.PARAMETER_VALUE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)column.ValueDate ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_VALUE_AMOUNT, OracleDbType.Int64, ParameterDirection.Input, (object)column.ValueAmount ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_VALUE_DESC, OracleDbType.Varchar2, ParameterDirection.Input, (object)column.ValueDesc ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_VAL_LOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ValueLockUpID ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_UW_RISK_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.UnderWritingRiskID ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.UnderWritingDocID ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_COL_ORDER, OracleDbType.Int64, ParameterDirection.Input, (object)column.ColumnOrder ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_ST_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.ColumnID ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_ST_DIC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.Dictionary ?? DBNull.Value);
oracleParams.Add(ColumnsSpParams.PARAMETER_ST_DIC_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)column.DictionaryColumnID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Domain.Entities.ProductSetup.ProductColumnValidation productColumns)
{
string SPName = "";
string message = "";
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (productColumns.ID.HasValue)
{
oracleParams.Add(ProductValidationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ID ?? DBNull.Value);
SPName = ProductValidationSpName.SP_UPADTE_VALIDATION;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ProductValidationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ProductValidationSpName.SP_INSERT_VALIDATION;
message = "Inserted Successfully";
}
oracleParams.Add(ProductValidationSpParams.PARAMETER_LABLE, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_LABLE2, OracleDbType.Varchar2, ParameterDirection.Input, (object)productColumns.Lable2 ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_DATA_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.DataType ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_LOC_VALD_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.LocValidType ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_IS_MANDETORY, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.IsMandetory ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_MAX_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.MaxValue ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_MIN_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.MinValue ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_CHECK_DUPLICATION, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.CheckDuplication ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_CAT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.CategoryID ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductID ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ProductDetailID ?? DBNull.Value);
oracleParams.Add(ProductValidationSpParams.PARAMETER_ST_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)productColumns.ColumnID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.ID = oracleParams.Get(0);
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(Product Product)
{
var SPName = default(string);
var message = default(string);
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (Product.ID.HasValue)
{
oracleParams.Add(ProductSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ID ?? DBNull.Value);
SPName = ProductSPName.SP_UPADTE_PRODUCT;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ProductSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ProductSPName.SP_INSERT_PRODUCT;
message = "Inserted Successfully";
}
oracleParams.Add(ProductSPParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Name ?? DBNull.Value, 1000);
oracleParams.Add(ProductSPParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Name2 ?? DBNull.Value, 1000);
oracleParams.Add(ProductSPParams.PARAMETER_STATUS, OracleDbType.Int64, ParameterDirection.Input, (object)Product.Status ?? DBNull.Value);
oracleParams.Add(ProductSPParams.PARAMETER_STATUS_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.StatusDate ?? DBNull.Value);
oracleParams.Add(ProductSPParams.PARAMETER_LOGO, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Logo ?? DBNull.Value, 1000);
oracleParams.Add(ProductSPParams.PARAMETER_CODE, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.Code ?? DBNull.Value, 30);
oracleParams.Add(ProductSPParams.PARAMETER_EFFECTIVE_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.EffectiveDate ?? DBNull.Value);
oracleParams.Add(ProductSPParams.PARAMETER_EXPIRY_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.ExpiryDate ?? DBNull.Value);
oracleParams.Add(ProductSPParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.CreateBy ?? DBNull.Value, 50);
oracleParams.Add(ProductSPParams.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.CreationDate ?? DBNull.Value);
oracleParams.Add(ProductSPParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.ModifiedBy ?? DBNull.Value, 50);
oracleParams.Add(ProductSPParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.ModificationDate ?? DBNull.Value);
oracleParams.Add(ProductSPParams.PARAMETER_LOCK_INDV_GROUPE, OracleDbType.Int16, ParameterDirection.Input, (object)Product.LockIndvGroup ?? DBNull.Value);
oracleParams.Add(ProductSPParams.PARAMETER_COMPANY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.CompanyID ?? DBNull.Value);
oracleParams.Add(ProductSPParams.PARAMETER_FIN_CUSTOMER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.FCustomerID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.ID = oracleParams.Get(0);
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> DeleteProducReportAsync(Domain.Entities.ProductSetup.ProductReport report)
{
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
var dyParam = new OracleDynamicParameters();
dyParam.Add(ProductReportSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)report.ID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(ProductReportSpName.SP_DELETE_PRODUCT_REPORT, dyParam) == -1)
{
complate.message = "Operation Successed";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> DeleteQuestionAsync(Question question)
{
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
var dyParam = new OracleDynamicParameters();
dyParam.Add(QuestionSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)question.ID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(QuestionSpName.SP_DELETE_QUESTION, dyParam) == -1)
{
complate.message = "Operation Successed";
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}
public async static Task <IDTO> AddUpdate(ProductSubjectType Product)
{
var SPName = default(string);
var message = default(string);
OracleDynamicParameters oracleParams = new OracleDynamicParameters();
ComplateOperation <int> complate = new ComplateOperation <int>();
if (Product.ID.HasValue)
{
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ID ?? DBNull.Value);
SPName = ProductSubjectsTypiesSPName.SP_UPADTE_PRODUCT_SUBJECT_TYPE;
message = "Updated Successfully";
}
else
{
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output);
SPName = ProductSubjectsTypiesSPName.SP_INSERT_PRODUCT_SUBJECT_TYPE;
message = "Inserted Successfully";
}
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_EXCESS_PERC, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ExcessPerc ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_EXCESS_MIN, OracleDbType.Int64, ParameterDirection.Input, (object)Product.MinExcess ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_EXCESS_MAX, OracleDbType.Int64, ParameterDirection.Input, (object)Product.MaxExcess ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_EXCESS_FROM, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ExcessFrom ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_SUBJECT_TYPE_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.SubjectTypeID ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_SUBJECT_TYPE_PARENT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.SubjectTypeParentID ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_LINE_OF_BUSSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)Product.LineOfBusniess ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_SUB_LINE_OF_BUSSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)Product.SubLineOfBusniess ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_CREATED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.CreateBy ?? DBNull.Value, 20);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_CREATATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.CreationDate ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_MODIFIED_BY, OracleDbType.Varchar2, ParameterDirection.Input, (object)Product.ModifiedBy ?? DBNull.Value, 20);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_MODIFICATION_DATE, OracleDbType.Date, ParameterDirection.Input, (object)Product.ModificationDate ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_PRODUCT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ProductID ?? DBNull.Value);
oracleParams.Add(ProductSubjectsTypiesSPParams.PARAMETER_PRODUCT_DETAILS_ID, OracleDbType.Int64, ParameterDirection.Input, (object)Product.ProductDetailsID ?? DBNull.Value);
if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1)
{
complate.message = message;
}
else
{
complate.message = "Operation Failed";
}
return(complate);
}