private async Task EvaluateSupplierPoints(PreQualificationApplyDocumentsModel applyDocumentsModel, string supplierCr) { await PrepareQualificationDataBeforeEvaluation(applyDocumentsModel); applyDocumentsModel.SupplierId = supplierCr; await _SupplierQualificationDocumentsAppService.ApplyDocsforSupplier(applyDocumentsModel, true); }
public PreQualificationApplyDocumentsModel GetApplyDocumentsModelMediumQulaification() { PreQualificationApplyDocumentsModel applyDocumentsModel = new PreQualificationApplyDocumentsModel() { QualificationTypeId = (int)Enums.PreQualificationType.Medium, SupplierId = "5956275283", PreQualificationIdString = Util.Encrypt(1), QualificationStatusId = 1, lstQualificationSupplierDataModel = GetListOfMediumQualificationTechDataModel(), preQualificationSupplierAttachmentModels = new List <PreQualificationSupplierAttachmentModel> { new PreQualificationSupplierAttachmentModel { FileName = "Test File", FileNetReferenceId = "ddv122122" } }, QualityAssuranceStandardsAttachmentModels = new List <QualificationAttachmentModel>() { new QualificationAttachmentModel() { AttachmentId = 1, FileName = "323", FileNetReferenceId = "32", SupPreQAttachmentId = 2 } }, EnvironmentalHealthSafetyStandardsAttachmentModels = new List <QualificationAttachmentModel>() { new QualificationAttachmentModel() { FileName = "Name", AttachmentId = 1, FileNetReferenceId = "refere", SupPreQAttachmentId = 1 } } }; return(applyDocumentsModel); }
public async Task <PreQualificationApplyDocumentsModel> GetQualificationSupplierData(int qualificationId, string supplierId) { var model = new PreQualificationApplyDocumentsModel() { PreQualificationResult = 0, PreQualificationIdString = Util.Encrypt(qualificationId) }; List <QualificationSupplierDataModel> lstQualificationSupplierDataModel = await GetQualificationSupplierDataModel(qualificationId, supplierId); model = await PrepareQualificationData(model, lstQualificationSupplierDataModel); model.EditMode = true; return(model); }
private async Task PrepareQualificationDataBeforeEvaluation(PreQualificationApplyDocumentsModel applyDocumentsModel) { applyDocumentsModel.preQualificationSupplierAttachmentModels = await PreparePostedSupplierAttachmentsModel(applyDocumentsModel.AttachmentRefrences); applyDocumentsModel.InsuranceAttachmentModels = await PrepareQualificationAttachmentModels(applyDocumentsModel.FileReferenceForInsurance); applyDocumentsModel.QualityAssuranceStandardsAttachmentModels = await PrepareQualificationAttachmentModels(applyDocumentsModel.FileReferenceForQualityAssuranceStandards); applyDocumentsModel.EnvironmentalHealthSafetyStandardsAttachmentModels = await PrepareQualificationAttachmentModels(applyDocumentsModel.FileReferenceForEnvironmentalHealthSafetyStandards); applyDocumentsModel.lstQualificationSupplierDataModel = applyDocumentsModel.lstQualificationSupplierTechDataModel != null ? applyDocumentsModel.lstQualificationSupplierTechDataModel.Concat(applyDocumentsModel.lstQualificationSupplierFinancialDataModel).ToList() : applyDocumentsModel.lstQualificationSupplierDataModel; }
public PreQualificationApplyDocumentsModel GetApplyDocumentsModelSmallQulaification() { PreQualificationApplyDocumentsModel applyDocumentsModel = new PreQualificationApplyDocumentsModel() { QualificationTypeId = (int)Enums.PreQualificationType.Small, SupplierId = "5956275283", PreQualificationIdString = Util.Encrypt(1), QualificationStatusId = 1, lstQualificationSupplierDataModel = GetListOfSmallQualificationTechDataModel(), preQualificationSupplierAttachmentModels = new List <PreQualificationSupplierAttachmentModel> { new PreQualificationSupplierAttachmentModel { FileName = "Test File", FileNetReferenceId = "ddv122122" } }, }; return(applyDocumentsModel); }
public PreQualificationApplyDocumentsModel GetApplyDocumentsModelLargeQulaification() { PreQualificationApplyDocumentsModel applyDocumentsModel = new PreQualificationApplyDocumentsModel() { QualificationTypeId = (int)Enums.PreQualificationType.Large, SupplierId = "1010000154", PreQualificationIdString = Util.Encrypt(1), QualificationStatusId = 1, lstQualificationSupplierDataModel = GetListOfLargeQualificationTechDataModel(), preQualificationSupplierAttachmentModels = new List <PreQualificationSupplierAttachmentModel> { new PreQualificationSupplierAttachmentModel { FileName = "Test File", FileNetReferenceId = "ddv122122" } }, lstQualificationSupplierProjectModel = new List <QualificationSupplierProjectModel>() { new QualificationSupplierProjectModel() { TenderId = 1, ContractName = "Con Name", ContractValue = 1000, Description = "Des", OwnerName = "Owner Name", StartDate = DateTime.Now, EndDate = DateTime.Now.AddDays(1) } }, QualityAssuranceStandardsAttachmentModels = new List <QualificationAttachmentModel>() { new QualificationAttachmentModel() { AttachmentId = 1, FileName = "323", FileNetReferenceId = "32", SupPreQAttachmentId = 2 } }, EnvironmentalHealthSafetyStandardsAttachmentModels = new List <QualificationAttachmentModel>() { new QualificationAttachmentModel() { FileName = "Name", AttachmentId = 1, FileNetReferenceId = "refere", SupPreQAttachmentId = 1 } } }; return(applyDocumentsModel); }
public async Task RemoveSupplierDocAndEvaluationAsync(PreQualificationApplyDocumentsModel model, string supplierId) { model.PreQualificationId = Util.Decrypt(model.PreQualificationIdString); var supplierFinancialData = await _context.QualificationSupplierDataYearly.Where(a => a.TenderId == model.PreQualificationId && a.SupplierSelectedCr == supplierId).ToListAsync(); var supplierData = await _context.QualificationSupplierData.Where(a => a.SupplierSelectedCr == supplierId && a.TenderId == model.PreQualificationId).Includes(a => a.QualificationSupplierProjects).Includes(a => a.QualificationConfigurationAttachments).ToListAsync(); var finalresult = await _context.QualificationFinalResult.Where(a => a.SupplierSelectedCr == supplierId && a.TenderId == model.PreQualificationId).FirstOrDefaultAsync(); _context.QualificationSupplierDataYearly.RemoveRange(supplierFinancialData); _context.QualificationSupplierData.RemoveRange(supplierData); _context.QualificationFinalResult.RemoveRange(finalresult); await _context.SaveChangesAsync(); }
private async Task <PreQualificationApplyDocumentsModel> bindFinancialPropertyAsync(PreQualificationApplyDocumentsModel model) { if (model.lstQualificationSupplierFinancialDataModel.FirstOrDefault().QualificationTypeId == (int)Enums.PreQualificationType.Small) { model.CashEquivalents = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CashEquivalents && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.AccountsReceivable = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.AccountsReceivable && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.CurrentLiabilities = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CurrentLiabilities && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; } else if (model.lstQualificationSupplierFinancialDataModel.FirstOrDefault().QualificationTypeId == (int)Enums.PreQualificationType.Medium || model.lstQualificationSupplierFinancialDataModel.FirstOrDefault().QualificationTypeId == (int)Enums.PreQualificationType.Large) { model.CurrentAssets = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CurrentAssets && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.CashEquivalents = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CashEquivalents && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.AccountsReceivable = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.AccountsReceivable && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.CurrentLiabilities = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CurrentLiabilities && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.CurrentAssets1 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CurrentAssets && a.QualificationYearId == (int)Enums.QualificationYear.SecondYear).FirstOrDefault().SupplierValue; model.CashEquivalents1 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CashEquivalents && a.QualificationYearId == (int)Enums.QualificationYear.SecondYear).FirstOrDefault().SupplierValue; model.AccountsReceivable1 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.AccountsReceivable && a.QualificationYearId == (int)Enums.QualificationYear.SecondYear).FirstOrDefault().SupplierValue; model.CurrentLiabilities1 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CurrentLiabilities && a.QualificationYearId == (int)Enums.QualificationYear.SecondYear).FirstOrDefault().SupplierValue; model.CurrentAssets2 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CurrentAssets && a.QualificationYearId == (int)Enums.QualificationYear.ThirdYear).FirstOrDefault().SupplierValue; model.CashEquivalents2 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CashEquivalents && a.QualificationYearId == (int)Enums.QualificationYear.ThirdYear).FirstOrDefault().SupplierValue; model.AccountsReceivable2 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.AccountsReceivable && a.QualificationYearId == (int)Enums.QualificationYear.ThirdYear).FirstOrDefault().SupplierValue; model.CurrentLiabilities2 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.CurrentLiabilities && a.QualificationYearId == (int)Enums.QualificationYear.ThirdYear).FirstOrDefault().SupplierValue; if (model.lstQualificationSupplierFinancialDataModel.FirstOrDefault().QualificationTypeId == (int)Enums.PreQualificationType.Large) { model.NetProfit = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.NetProfit && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.NetProfit1 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.NetProfit && a.QualificationYearId == (int)Enums.QualificationYear.SecondYear).FirstOrDefault().SupplierValue; model.NetProfit2 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.NetProfit && a.QualificationYearId == (int)Enums.QualificationYear.ThirdYear).FirstOrDefault().SupplierValue; model.TotalRevenue = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalRevenue && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.TotalRevenue1 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalRevenue && a.QualificationYearId == (int)Enums.QualificationYear.SecondYear).FirstOrDefault().SupplierValue; model.TotalRevenue2 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalRevenue && a.QualificationYearId == (int)Enums.QualificationYear.ThirdYear).FirstOrDefault().SupplierValue; model.TotalLiabilities = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalLiabilities && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.TotalLiabilities1 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalLiabilities && a.QualificationYearId == (int)Enums.QualificationYear.SecondYear).FirstOrDefault().SupplierValue; model.TotalLiabilities2 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalLiabilities && a.QualificationYearId == (int)Enums.QualificationYear.ThirdYear).FirstOrDefault().SupplierValue; model.TotalAssets = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalAssets && a.QualificationYearId == (int)Enums.QualificationYear.CurrentYear).FirstOrDefault().SupplierValue; model.TotalAssets1 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalAssets && a.QualificationYearId == (int)Enums.QualificationYear.SecondYear).FirstOrDefault().SupplierValue; model.TotalAssets2 = model.lstQualificationSupplierDataYearlyViewModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.TotalAssets && a.QualificationYearId == (int)Enums.QualificationYear.ThirdYear).FirstOrDefault().SupplierValue; } } return(model); }
private async Task <PreQualificationApplyDocumentsModel> PrepareQualificationData(PreQualificationApplyDocumentsModel model, List <QualificationSupplierDataModel> lstQualificationSupplierDataModel) { model.lstQualificationSupplierTechDataModel = lstQualificationSupplierDataModel.Where(l => l.QualificationCategoryId == (int)Enums.QualificationItemCategory.Technical).ToList(); model.lstQualificationSupplierFinancialDataModel = lstQualificationSupplierDataModel.Where(l => l.QualificationCategoryId == (int)Enums.QualificationItemCategory.Financial).ToList(); model.lstQualificationSupplierDataYearlyViewModel = lstQualificationSupplierDataModel.FirstOrDefault().lstQualificationSupplierDataYearlyViewModel; model.lstQualificationSupplierProjectModel = lstQualificationSupplierDataModel.FirstOrDefault().lstQualificationSupplierProjectModel; // bind data model = await bindFinancialPropertyAsync(model); model.FileReferenceForQualityAssuranceStandards = model.lstQualificationSupplierTechDataModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.QualityAssuranceStandards).FirstOrDefault()?.FileReferenceForQualityAssuranceStandards; model.FileReferenceForEnvironmentalHealthSafetyStandards = model.lstQualificationSupplierTechDataModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.EnvironmentalHealthSafetyStandards).FirstOrDefault()?.FileReferenceForEnvironmentalHealthSafetyStandards; model.FileReferenceForInsurance = model.lstQualificationSupplierTechDataModel.Where(a => a.QualificationItemId == (int)Enums.QualificationEvaluationItems.InsuranceOfGeneralCommercialResponsibility || a.QualificationItemId == (int)Enums.QualificationEvaluationItems.InsuranceOfProfessionalCompensation || a.QualificationItemId == (int)Enums.QualificationEvaluationItems.LiabilityInsurance).FirstOrDefault()?.FileReferenceForInsurance; if (lstQualificationSupplierDataModel != null && lstQualificationSupplierDataModel.Count > 0) { model.QualificationTypeId = lstQualificationSupplierDataModel.FirstOrDefault().QualificationTypeId; model.QualificationStatusId = lstQualificationSupplierDataModel.FirstOrDefault().QualificationStatusId; model.SupplierId = lstQualificationSupplierDataModel.FirstOrDefault().SupplierSelectedCr; model.OfferCheckingDate = lstQualificationSupplierDataModel.FirstOrDefault().OfferCheckingDate != null?lstQualificationSupplierDataModel.FirstOrDefault().OfferCheckingDate : null; model.OffersCheckingDateHijri = lstQualificationSupplierDataModel.FirstOrDefault().OffersCheckingDateHijri; } return(model); }