public async Task <WebApiResult <MPRelatedInfo> > Handle(MPRelatedQueryCommand request, CancellationToken cancellationToken) { try { MPRelatedInfo relatedInfo = new MPRelatedInfo(); var mp_contract_types = await preminumFinanceRepository.GetMPContractTypes(request.id_version); relatedInfo.mp_contract_types = mp_contract_types; var mp_payment = await preminumFinanceRepository.GetMPPayments(request.id_version); relatedInfo.mp_payments = mp_payment; var mp_subcontracts = await preminumFinanceRepository.GetMPSubContract(request.id_version); relatedInfo.mp_subcontracts = mp_subcontracts; return(new WebApiResult <MPRelatedInfo>(relatedInfo)); } catch (Exception ex) { return(WebApiResult <MPRelatedInfo> .Error(ex.Message)); } }
public async Task <WebApiResult <IEnumerable <VersionInfo> > > Handle(VersionsQueryCommand request, CancellationToken cancellationToken) { try { var result = await preminumFinanceRepository.GetAllVersion(); return(new WebApiResult <IEnumerable <VersionInfo> >(result)); } catch (Exception ex) { return(WebApiResult <IEnumerable <VersionInfo> > .Error(ex.Message)); } }
public async Task <WebApiResult <IEnumerable <IDictionary <string, object> > > > Handle(ContractTypeQueryCommand request, CancellationToken cancellationToken) { try { var contracts = (await preminumFinanceRepository.GetContractType()).Select(a => (IDictionary <string, object>)a); return(new WebApiResult <IEnumerable <IDictionary <string, object> > >(contracts)); } catch (Exception ex) { return(WebApiResult <IEnumerable <IDictionary <string, object> > > .Error(ex.Message)); } }
public async Task <WebApiResult <IEnumerable <states> > > Handle(StatesQueryByCountryIdCommand request, CancellationToken cancellationToken) { try { var result = await preminumFinanceRepository.GetStateByCountryId(request.id_country); return(new WebApiResult <IEnumerable <states> >(result)); } catch (Exception ex) { return(WebApiResult <IEnumerable <states> > .Error(ex.Message)); } }
public async Task <WebApiResult <IEnumerable <IDictionary <string, object> > > > Handle(StateQueryCommand request, CancellationToken cancellationToken) { try { var result = (await preminumFinanceRepository.GetStateByVersionId(request.VersionId)).Select(a => (IDictionary <string, object>)a); return(new WebApiResult <IEnumerable <IDictionary <string, object> > >(result)); } catch (Exception ex) { return(WebApiResult <IEnumerable <IDictionary <string, object> > > .Error(ex.Message)); } }
public async Task <WebApiResult <bool> > Handle(StateAddCommand request, CancellationToken cancellationToken) { var result = false; try { StateInfo stateInfo = new StateInfo() { effective_date = request.effective_date, expiration_date = request.effective_date, hasexpiration = request.hasexpiration, license = request.license, state_id = request.state_id }; //await preminumFinanceRepository.AddState(stateInfo, 1 ); result = true; return(new WebApiResult <bool>(result)); } catch (Exception ex) { return(WebApiResult <bool> .Error(ex.Message)); } }
public async Task <WebApiResult <IEnumerable <UnitTreeOut> > > Handle(UnitLobCoverageDivisionTreeQueryCommand request, CancellationToken cancellationToken) { try { List <UnitTreeOut> result = new List <UnitTreeOut>(); var data = (await preminumFinanceRepository.GetLobUnitsCoverageDivision()).ToList(); if (data.Any()) { // group by product_id var product_ids = from product in data group product by product.id_product into g select g; if (product_ids.Any()) { foreach (var productId in product_ids) { var product = data.FirstOrDefault(a => a.id_product == productId.Key); UnitTreeOut producttree = new UnitTreeOut() { id = product.id_division_product, Data = new Data() { id_division_product = product.id_division_product, id_product = product.id_product, }, Text = product.product_name }; data.Remove(product); var lob_data = data.Where(a => a.id_product == productId.Key).ToList(); var lob_ids = from lobitem in lob_data group lobitem by lobitem.id_lob into g select g; if (lob_ids.Any()) { List <UnitTreeOut> lobs = new List <UnitTreeOut>(); foreach (var lob_id in lob_ids) { var lob = lob_data.FirstOrDefault(a => a.id_lob == lob_id.Key); lob_data.Remove(lob); UnitTreeOut lobtree = new UnitTreeOut() { id = lob.id_division_product, Data = new Data() { id_product = producttree.Data.id_product, id_lob = lob.id_lob, id_division_product = producttree.Data.id_division_product }, Text = lob.lob_name }; var division_data = lob_data.Where(a => a.id_lob == lob_id.Key).ToList(); var division_ids = from divisionitem in division_data group divisionitem by divisionitem.id_division into g select g; if (division_ids.Any()) { List <UnitTreeOut> divisions = new List <UnitTreeOut>(); foreach (var division_id in division_ids) { var division = division_data.FirstOrDefault(a => a.id_division == division_id.Key); division_data.Remove(division); UnitTreeOut divisiontree = new UnitTreeOut() { id = division.id_division_product, Data = new Data() { id_product = lobtree.Data.id_product, id_division = division.id_division, id_division_product = lobtree.Data.id_division_product, id_lob = lobtree.Data.id_lob, }, Text = division.division_name }; var coverage_data = division_data.Where(a => a.id_division == division_id.Key); List <UnitTreeOut> coverages = new List <UnitTreeOut>(); foreach (var coverageitem in coverage_data) { UnitTreeOut treecoverage = new UnitTreeOut() { id = coverageitem.id_division_product, Data = new Data() { id_division = divisiontree.Data.id_division, id_coverage = coverageitem.id_coverage, id_division_product = divisiontree.Data.id_division_product, id_lob = divisiontree.Data.id_lob, id_product = divisiontree.Data.id_product }, Text = coverageitem.coverage_name }; coverages.Add(treecoverage); } divisiontree.Children = coverages; coverages = new List <UnitTreeOut>(); divisions.Add(divisiontree); } lobtree.Children = divisions; divisions = new List <UnitTreeOut>(); } lobs.Add(lobtree); } producttree.Children = lobs; lobs = new List <UnitTreeOut>(); } result.Add(producttree); } } } return(new WebApiResult <IEnumerable <UnitTreeOut> >(result)); } catch (Exception ex) { return(WebApiResult <IEnumerable <UnitTreeOut> > .Error(ex.Message)); } }
public async Task <WebApiResult <IEnumerable <ContractTree> > > Handle(ContractTreeQueryCommand request, CancellationToken cancellationToken) { try { var selected = await preminumFinanceRepository.GetMPSubContract(request.id_version); var result = new List <ContractTree>(); var contracts = await preminumFinanceRepository.GetContractTree(); var contracts_format = contracts.Select(a => (IDictionary <string, object>)a); var bp_ids = from bp in contracts_format group bp by bp["id_bp"] into g select g; if (bp_ids.Any()) { foreach (var item in bp_ids) { var bp = contracts_format.FirstOrDefault(a => a["id_bp"] == item.Key); ContractTree bp_entity = new ContractTree() { id = Convert.ToInt32(bp["id_bp"]) + 10000, Data = new ContractData() { id_bp = Convert.ToInt32(bp["id_bp"]), bp_name = bp["bp_name"].ToString(), id = Convert.ToInt32(bp["id_bp"]) + 10000 }, State = new ContractTreeState(), text = bp["bp_name"]?.ToString() ?? "", Children = new List <ContractTree>() }; var contract_contracts = contracts_format.Where(a => Convert.ToInt32(a["id_bp"]) == Convert.ToInt32(item.Key)); if (contract_contracts.Any()) { var contract_ids = from contract in contract_contracts group contract by contract["id_contract"] into g select g; if (contract_ids.Any()) { foreach (var contract_id in contract_ids) { var contract = contract_contracts.FirstOrDefault(a => a["id_contract"] == contract_id.Key); ContractTree contract_entity = new ContractTree() { id = Convert.ToInt32(contract["id_contract"]) + 100000, Data = new ContractData() { contract_name = contract["contract_name"]?.ToString() ?? "", id_contract = Convert.ToInt32(contract["id_contract"]), id = Convert.ToInt32(contract["id_contract"]) + 100000 }, text = contract["contract_name"]?.ToString() ?? "", State = new ContractTreeState(), Children = new List <ContractTree>() }; var subcontracts = contract_contracts.Where(a => Convert.ToInt32(a["id_contract"]) == Convert.ToInt32(contract_id.Key)); if (subcontracts.Any()) { foreach (var subcontract in subcontracts) { ContractTree subcontract_entity = new ContractTree() { Data = new ContractData() { subcontract_name = subcontract["subcontract_name"]?.ToString() ?? "empty", id = Convert.ToInt32(subcontract["subcontract_id"]) }, id = Convert.ToInt32(subcontract["subcontract_id"]), State = new ContractTreeState(), text = subcontract["subcontract_name"]?.ToString() ?? "empty" }; if (selected.Any(a => a == subcontract_entity.id)) { subcontract_entity.State.Selected = true; contract_entity.State.Opened = true; } contract_entity.Children.Add(subcontract_entity); } } if (selected.Any(a => a == contract_entity.id)) { contract_entity.State.Selected = true; bp_entity.State.Opened = true; } bp_entity.Children.Add(contract_entity); } } } result.Add(bp_entity); } } return(new WebApiResult <IEnumerable <ContractTree> >(result)); } catch (Exception ex) { return(WebApiResult <IEnumerable <ContractTree> > .Error(ex.Message)); } }