public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(GroupSpParams.PARAMETER_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)ID ?? DBNull.Value);
dyParam.Add(GroupSpParams.PARAMETER_LANG_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
dyParam.Add(GroupSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Group>(GroupSpName.SP_LOAD_GROUP, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var @params = new OracleDynamicParameters();
@params.Add(ReportGroupSpParams.PARAMETER_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)ID ?? DBNull.Value);
@params.Add(ReportGroupSpParams.PARAMETER_LANG, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
@params.Add(ReportGroupSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <ReportGroup>(ReportGroupSPName.SP_LOAD_ReportGroup, @params));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(AttachmentParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
dyParam.Add(AttachmentParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
dyParam.Add(AttachmentParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Domain.Entities.ProductSetup.Attachment>(AttachmentSpName.SP_LOAD_ATTACHMENT, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(DocumentSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(DocumentSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(DocumentSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Document>(DocumentSpName.SP_LOAD_DOCUMENT, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(ProductSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(ProductSPParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)this.Name ?? DBNull.Value);
parameters.Add(ProductSPParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(ProductSPParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Product>(ProductSPName.SP_LOAD_PRODUCT, parameters));
}
public async Task <List <UserGroup> > GetUserRelation()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(UserGroupSpParams.PARAMETER_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)ID ?? DBNull.Value);
dyParam.Add(UserGroupSpParams.PARAMETER_USER_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)UserID ?? DBNull.Value);
dyParam.Add(UserGroupSpParams.PARAMETER_LANG_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
dyParam.Add(UserGroupSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <UserGroup>(UserGroupSpName.SP_LOAD_USER_GROUP, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(AttributesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(AttributesSpParams.PARAMETER_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)this.Type ?? DBNull.Value);
parameters.Add(AttributesSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(AttributesSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Acttribute>(AttributesPName.SP_LOAD_Attribute, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(AnswerSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(AnswerSpParams.PARAMETER_ST_QUS_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.QuestionnaireID ?? DBNull.Value);
parameters.Add(AnswerSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(AnswerSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Answer>(AnswerSpName.SP_LOAD_ANSWER, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(CurrencySpParams.PARAMETER_CURRENCY_CODE, OracleDbType.Int64, ParameterDirection.Input, (object)this.Code ?? DBNull.Value);
dyParam.Add(CurrencySpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
dyParam.Add(CurrencySpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Currency>(CurrencySPName.SP_LOAD_CURRENCY, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(SubjectTypepParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(SubjectTypepParams.PARAMETER_LINEOFBUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)this.LineOfBusniessID ?? DBNull.Value);
parameters.Add(SubjectTypepParams.PARAMETER_SUBLINEOFBUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)this.SubLineOfBusniessID ?? DBNull.Value);
parameters.Add(SubjectTypepParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(SubjectTypepParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <SubjectType>(SubjectTypeSPName.SP_LOAD_SubjectType, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(BusinessSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(BusinessSpParams.PARAMETER_CODE, OracleDbType.Int64, ParameterDirection.Input, (object)this.LineOfBusiness ?? DBNull.Value);
parameters.Add(BusinessSpParams.PARAMETER_LOC_MODULE, OracleDbType.Int64, ParameterDirection.Input, (object)this.Module ?? DBNull.Value);
parameters.Add(BusinessSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(BusinessSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <BusinessLine>(BusinessSPName.SP_LOAD_Busnies, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(BankBranchSpParams.PARAMETER_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)ID ?? DBNull.Value);
dyParam.Add(BankBranchSpParams.PARAMETER_BANK_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)BankID ?? DBNull.Value);
dyParam.Add(BankBranchSpParams.PARAMETER_LANG_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
dyParam.Add(BankBranchSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <BankBranch>(BankBranchSPName.SP_LOAD_BANCK_BRANCH, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(DictionariyColumnSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(DictionariyColumnSpParams.PARAMETER_DICTIONARY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.DictionaryID ?? DBNull.Value);
parameters.Add(DictionariyColumnSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(DictionariyColumnSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <DictionaryColumn>(DictionariyColumnSpNames.SP_LOAD_DICTIONARY_COL, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(ProductQuestionearsSPParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(ProductQuestionearsSPParams.PARAMETER_PRODUCT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ProductID ?? DBNull.Value);
parameters.Add(ProductQuestionearsSPParams.PARAMETER_PRODUCT_DETAILS_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ProductDetailedID ?? DBNull.Value);
parameters.Add(ProductQuestionearsSPParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(ProductQuestionearsSPParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <ProductQuestionnaire>(ProductQuestionearsSPName.SP_LOAD_PRODUCT_Question, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(CustomerContactsSpParam.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)ID ?? DBNull.Value);
dyParam.Add(CustomerContactsSpParam.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)CustomerID ?? DBNull.Value);
dyParam.Add(CustomerContactsSpParam.PARAMETER_LANG_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
dyParam.Add(CustomerContactsSpParam.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <CustomerContact>(CustomerContactsSpName.CUSTOMER_CONTACT_LOAD, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(AttributesGroupSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(AttributesGroupSpParams.PARAMETER_ATTRIBUTE_GROUP, OracleDbType.Int64, ParameterDirection.Input, (object)this.ATT_GRP_ID ?? DBNull.Value);
parameters.Add(AttributesGroupSpParams.PARAMETER_SERVICE_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.SRVCS_ID ?? DBNull.Value);
parameters.Add(AttributesGroupSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(AttributesGroupSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <AttributeGroup>(AttributeGroupsPName.SP_LOAD_AttributeGroup, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(DepartmentSpParams.PARAMETER_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)ID ?? DBNull.Value);
dyParam.Add(DepartmentSpParams.PARAMETER_COMPANY_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)CompanyID ?? DBNull.Value);
dyParam.Add(DepartmentSpParams.PARAMETER_LANG_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
dyParam.Add(DepartmentSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Department>(DepartmentSPName.SP_LOAD_COMPANY_DEPARTMENT, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(MenuSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
dyParam.Add(MenuSpParams.PARAMETER_MENU_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)this.Type ?? DBNull.Value);
dyParam.Add(MenuSpParams.PARAMETER_ST_MENUE_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.SubMenuID ?? DBNull.Value);
dyParam.Add(MenuSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
dyParam.Add(MenuSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Menu>(MenuSPName.SP_LOAD_Menu, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(QuestionnaireSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(QuestionnaireSpParams.PARAMETER_QUS_LEVEL, OracleDbType.Int64, ParameterDirection.Input, (object)this.QustionnaireLevel ?? DBNull.Value);
parameters.Add(QuestionnaireSpParams.PARAMETER_ST_LOB_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LineOfBusiness ?? DBNull.Value);
parameters.Add(QuestionnaireSpParams.PARAMETER_ST_SUB_LOB_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.SubLineOfBusiness ?? DBNull.Value);
parameters.Add(QuestionnaireSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(QuestionnaireSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Questionnaire>(QuestionnaireSpName.SP_LOAD_QUESTIONNAIRE, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(SubBusniesSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)ID ?? DBNull.Value);
parameters.Add(SubBusniesSpParams.PARAMETER_ST_LOB_ID, OracleDbType.Int64, ParameterDirection.Input, (object)LineOfBusniess ?? DBNull.Value);
parameters.Add(SubBusniesSpParams.PARAMETER_SUB_LOB, OracleDbType.Int64, ParameterDirection.Input, (object)BasicLineOfBusniess ?? DBNull.Value);
parameters.Add(SubBusniesSpParams.PARAMETER_LANG_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
parameters.Add(SubBusniesSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <SubLineOfBusnies>(SubBusniesSPName.SP_LOAD_SubBusnies, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(ProductWordDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
dyParam.Add(ProductWordDetailSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ProductId ?? DBNull.Value);
dyParam.Add(ProductWordDetailSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ProductDetailId ?? DBNull.Value);
dyParam.Add(ProductWordDetailSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
dyParam.Add(ProductWordDetailSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Domain.Entities.ProductSetup.ProductWordingDetails>(ProductWordDetailSpName.SP_LOAD_PRODUCT_WORDING_DETAIL, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(RiskSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(RiskSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.UwDocumentID ?? DBNull.Value);
parameters.Add(RiskSpParams.PARAMETER_SERIAL, OracleDbType.Int64, ParameterDirection.Input, (object)this.Serial ?? DBNull.Value);
parameters.Add(RiskSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)this.Name ?? DBNull.Value);
parameters.Add(RiskSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(RiskSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Risk>(RiskSpName.SP_LOAD_RISK, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(PricingDetailsSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(PricingDetailsSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ProductID ?? DBNull.Value);
parameters.Add(PricingDetailsSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ProductDetailID ?? DBNull.Value);
parameters.Add(PricingDetailsSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(PricingDetailsSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <PricingDetail>(PricingDetailsSpName.SP_LOAD_PRICING_DETAIL, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(AreaSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
dyParam.Add(AreaSpParams.PARAMETER_COUNTRY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.CountryID ?? DBNull.Value);
dyParam.Add(AreaSpParams.PARAMETER_CITY_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.CityID ?? DBNull.Value);
dyParam.Add(AreaSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
dyParam.Add(AreaSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Area>(AreaSPName.SP_LOAD_AREA, dyParam));
}
public async Task <IEnumerable> Login(Auth auth)
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(UserSpParams.PARAMETER_USERNAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)auth.UserName ?? DBNull.Value, 30);
dyParam.Add(UserSpParams.PARAMETER_PASSWORD, OracleDbType.Varchar2, ParameterDirection.Input, (object)Encryption.EncryptPassword(auth.Password) ?? DBNull.Value, 1000);
dyParam.Add(UserSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)auth.langId ?? DBNull.Value);
dyParam.Add(UserSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
List <User> users = await QueryExecuter.ExecuteQueryAsync <User>(UserSpName.SP_LOGIN_USER, dyParam);
return(users);
}
public async Task <IEnumerable> QueryAsync()
{
var parameters = new OracleDynamicParameters();
parameters.Add(CategorySpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ID ?? DBNull.Value);
parameters.Add(CategorySpParams.PARAMETER_CAT_LEVEL, OracleDbType.Int64, ParameterDirection.Input, (object)this.CategoryLevel ?? DBNull.Value);
parameters.Add(CategorySpParams.PARAMETER_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)this.LineOfBusniess ?? DBNull.Value);
parameters.Add(CategorySpParams.PARAMETER_SUB_LINE_OF_BUSNIESS, OracleDbType.Int64, ParameterDirection.Input, (object)this.SubLineOfBusniess ?? DBNull.Value);
parameters.Add(CategorySpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(CategorySpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Category>(CategorySpName.SP_LOAD_CATEGORY, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(LockUpSpParams.PARAMETER_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)ID ?? DBNull.Value);
dyParam.Add(LockUpSpParams.PARAMETER_MAJOR_CODE, OracleDbType.Decimal, ParameterDirection.Input, (object)MajorCode ?? DBNull.Value);
dyParam.Add(LockUpSpParams.PARAMETER_ST_MINOR_CODE, OracleDbType.Decimal, ParameterDirection.Input, (object)MinorCode ?? DBNull.Value);
dyParam.Add(LockUpSpParams.PARAMETER_ST_LOCKUP_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LockUpID ?? DBNull.Value);
dyParam.Add(LockUpSpParams.PARAMETER_LANG_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
dyParam.Add(LockUpSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Lockup>(LockUpSPName.SP_LOAD_LOCKUPS, dyParam));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(CustomerGrRelationSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)ID ?? DBNull.Value);
dyParam.Add(CustomerGrRelationSpParams.PARAMETER_ST_PARTD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)ProductDetailId ?? DBNull.Value);
dyParam.Add(CustomerGrRelationSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)CustomerID ?? DBNull.Value);
dyParam.Add(CustomerGrRelationSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
dyParam.Add(CustomerGrRelationSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <Entities.Financial.CustomerGroupRelation>(CustomerGrRelationSpName.SP_LOAD_CUSTOMER_GROUP_RELATIONS, dyParam));
}
public async Task <IEnumerable> QueryFull()
{
var parameters = new OracleDynamicParameters();
parameters.Add(AttachmentsSpParams.PARAMETER_UW_DOC_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.DocumentID ?? DBNull.Value);
parameters.Add(AttachmentsSpParams.PARAMETER_UW_RISK_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.RiskID ?? DBNull.Value);
parameters.Add(AttachmentsSpParams.PARAMETER_CLM_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.ClaimID ?? DBNull.Value);
parameters.Add(AttachmentsSpParams.PARAMETER_LOC_LEVEL, OracleDbType.Int64, ParameterDirection.Input, (object)this.Level ?? DBNull.Value);
parameters.Add(AttachmentsSpParams.PARAMETER_LANG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)this.LangID ?? DBNull.Value);
parameters.Add(AttachmentsSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <AttachmentProdSetup>(AttachmentsSpName.SP_LOAD_ATTACHMENT_FULL, parameters));
}
public async Task <IEnumerable> QueryAsync()
{
var dyParam = new OracleDynamicParameters();
dyParam.Add(CustomerTypeSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)ID ?? DBNull.Value);
dyParam.Add(CustomerTypeSpParams.PARAMETER_FIN_CST_ID, OracleDbType.Int64, ParameterDirection.Input, (object)CustomerID ?? DBNull.Value);
dyParam.Add(CustomerTypeSpParams.PARAMETER_LOC_CUST_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)LocCustomerType ?? DBNull.Value);
dyParam.Add(CustomerTypeSpParams.PARAMETER_FIN_GL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)FinGlID ?? DBNull.Value);
dyParam.Add(CustomerTypeSpParams.PARAMETER_LANG_ID, OracleDbType.Decimal, ParameterDirection.Input, (object)LangID ?? DBNull.Value);
dyParam.Add(CustomerTypeSpParams.PARAMETER_REF_SELECT, OracleDbType.RefCursor, ParameterDirection.Output);
return(await QueryExecuter.ExecuteQueryAsync <CustomerType>(CustomerTypesSpName.SP_LOAD_CUSTOMER_TYPE, dyParam));
}
