public void SaveCertificateOfCompletion(Guid id) { var declaration = AppContext.OBK_AssessmentDeclaration.FirstOrDefault(e => e.Id == id); var directToPay = AppContext.OBK_DirectionToPayments.FirstOrDefault(e => e.ContractId == declaration.ContractId); var contractPrice = AppContext.OBK_ContractPrice.Where(e => e.ContractId == declaration.ContractId); double taxValue = TaxHelper.GetNdsRef(); var totalPrice = Convert.ToDecimal(contractPrice.Sum(e => (e.OBK_Ref_PriceList.Price * taxValue + e.OBK_Ref_PriceList.Price) * e.Count)); if (declaration != null) { OBK_CertificateOfCompletion act = new OBK_CertificateOfCompletion { Id = Guid.NewGuid(), Number = declaration.Number, ContractId = (Guid)declaration.ContractId, AssessmentDeclarationId = id, InvoiceNumber1C = directToPay?.InvoiceNumber1C, InvoiceDatetime1C = directToPay?.InvoiceDatetime1C, TotalPrice = totalPrice, CreateDate = DateTime.Now, SendDate = DateTime.Now, ActNumber1C = null, ActDate1C = null, ActReturnedBack = false, SendNotification = false }; AppContext.OBK_CertificateOfCompletion.Add(act); AppContext.SaveChanges(); } }
public string SaveSignedZbkCopyStage(Guid id, string signedData) { OBK_ZBKCopyStageSignData signData = new OBK_ZBKCopyStageSignData(); signData.Id = Guid.NewGuid(); signData.StageId = id; signData.SignDateTime = DateTime.Now; signData.SignerId = UserHelper.GetCurrentEmployee().Id; signData.SignXmlData = signedData; AppContext.OBK_ZBKCopyStageSignData.Add(signData); var stage = AppContext.OBK_ZBKCopyStage.FirstOrDefault(o => o.Id == id); var copy = AppContext.OBK_ZBKCopy.FirstOrDefault(o => o.Id == stage.OBK_ZBKCopyId); var copyStatus = AppContext.OBK_Ref_Status.FirstOrDefault(o => CodeConstManager.STATUS_OBK_SIGN_ACT.ToString().Equals(o.Code)); copy.StatusId = copyStatus.Id; var stageStatus = AppContext.OBK_Ref_StageStatus.FirstOrDefault(o => OBK_Ref_StageStatus.Completed.ToString().Equals(o.Code)); stage.StageStatusId = stageStatus.Id; var stageCoz = AppContext.OBK_ZBKCopyStage.FirstOrDefault(o => o.OBK_ZBKCopyId == copy.Id && o.StageId == CodeConstManager.STAGE_OBK_COZ); var stageStatusCoz = AppContext.OBK_Ref_StageStatus.FirstOrDefault(o => OBK_Ref_StageStatus.RequiresIssuingZBKCopy.ToString().Equals(o.Code)); stageCoz.StageStatusId = stageStatusCoz.Id; var payment = AppContext.OBK_DirectionToPayments.FirstOrDefault(o => o.ZBKCopy_id == copy.Id); OBK_CertificateOfCompletion certificate = new OBK_CertificateOfCompletion(); certificate.Id = Guid.NewGuid(); certificate.CreateDate = DateTime.Now; certificate.TotalPrice = payment.TotalPrice; certificate.InvoiceNumber1C = payment.InvoiceNumber1C; certificate.InvoiceDatetime1C = payment.InvoiceDatetime1C; certificate.SendDate = DateTime.Now; certificate.ZBKCopyId = copy.Id; AppContext.OBK_CertificateOfCompletion.Add(certificate); AppContext.SaveChanges(); return("Успешно подписан!"); }
public void UpdateNotificationToAct(OBK_CertificateOfCompletion act) { AppContext.SaveChangesAsync(); }