public ZBKViewModel EditCopy(Guid ZBKCopyId)
{
ZBKViewModel model = new ZBKViewModel();
OBK_ZBKCopy zbkCopy = AppContext.OBK_ZBKCopy.FirstOrDefault(o => o.Id == ZBKCopyId);
var stageExpDocument = AppContext.OBK_StageExpDocument.FirstOrDefault(o => o.Id == zbkCopy.OBK_StageExpDocumentId);
var declaration = AppContext.OBK_AssessmentDeclaration.FirstOrDefault(o => o.Id == stageExpDocument.AssessmentDeclarationId);
var contract = AppContext.OBK_Contract.FirstOrDefault(o => o.Id == declaration.ContractId);
var declarantContact = AppContext.OBK_DeclarantContact.FirstOrDefault(o => o.Id == contract.DeclarantContactId);
var declarant = AppContext.OBK_Declarant.FirstOrDefault(o => o.Id == contract.DeclarantId);
var organization = AppContext.Dictionaries.FirstOrDefault(o => o.Id == declarant.OrganizationFormId);
var refType = AppContext.OBK_Ref_Type.FirstOrDefault(o => o.Id == declaration.TypeId);
var directionPayment = AppContext.OBK_DirectionToPayments.FirstOrDefault(o => o.ZBKCopy_id == ZBKCopyId);
var cerCompition = AppContext.OBK_CertificateOfCompletion.FirstOrDefault(o => o.ZBKCopyId == ZBKCopyId);
if (zbkCopy.StatusId != null)
{
var refStatus = AppContext.OBK_Ref_Status.FirstOrDefault(o => o.Id == zbkCopy.StatusId);
if (refStatus != null)
{
model.refStatus = int.Parse(refStatus.Code);
}
}
model.Declarer = declarantContact.BossLastName + " " + declarantContact.BossFirstName
+ " " + declarantContact.BossMiddleName;
model.ConclusionNumber = stageExpDocument.ExpConclusionNumber;
model.ContractNumber = contract.Number;
model.DeclarationNumber = declaration.Number;
model.StartDate = stageExpDocument.ExpStartDate;
model.ExpireDate = stageExpDocument.ExpEndDate;
model.OrganizationName = organization.Name;
model.CopyQuantity = zbkCopy.CopyQuantity;
model.DeclarationType = refType.NameRu;
model.ContractId = contract.Id;
model.AttachPath = zbkCopy.AttachPath;
model.Id = zbkCopy.Id;
model.ExpApplication = stageExpDocument.ExpApplication;
model.CopyQuantity = zbkCopy.CopyQuantity;
model.Notes = zbkCopy.Notes;
model.Nds = TaxHelper.GetNdsRef() + 1;
model.LetterNumber = zbkCopy.LetterNumber;
model.LetterDate = zbkCopy.LetterDate;
model.actNumber1C = (cerCompition != null && cerCompition.ActNumber1C != null && cerCompition.ActReturnedBack == true);
if (directionPayment != null && directionPayment.ZBKCopy_id != null && directionPayment.InvoiceNumber1C != null)
{
var directionSignData = AppContext.OBK_DirectionSignData.FirstOrDefault(o => o.DirectionToPaymentId == directionPayment.Id);
if (directionSignData != null && directionSignData.ChiefAccountantSign != null)
{
model.PaymentInvoice = true;
}
}
return(model);
}
/// <summary>
/// расчет стоимости без НДС
public decimal GetTotalPriceWithoutNds(OBK_ZBKCopy copy)
{
var refType = AppContext.OBK_Ref_Type.FirstOrDefault(o => o.Code == "5");
var ref_PriceList = AppContext.OBK_Ref_PriceList.FirstOrDefault(o => o.TypeId == refType.Id);
var sum = ref_PriceList.Price * copy.CopyQuantity;
if (copy.ExpApplication == false)
{
return(Math.Round(Convert.ToDecimal(sum * 2), 2));
}
return(Math.Round(Convert.ToDecimal(sum), 2));
}
public ZBKViewModel CreateCopy(Guid stageExpDocId, Guid?ZBKCopyId)
{
ZBKViewModel model = new ZBKViewModel();
var stageExpDocument = AppContext.OBK_StageExpDocument.FirstOrDefault(o => o.Id == stageExpDocId);
var declaration = AppContext.OBK_AssessmentDeclaration.FirstOrDefault(o => o.Id == stageExpDocument.AssessmentDeclarationId);
var contract = AppContext.OBK_Contract.FirstOrDefault(o => o.Id == declaration.ContractId);
var declarantContact = AppContext.OBK_DeclarantContact.FirstOrDefault(o => o.Id == contract.DeclarantContactId);
var declarant = AppContext.OBK_Declarant.FirstOrDefault(o => o.Id == contract.DeclarantId);
var organization = AppContext.Dictionaries.FirstOrDefault(o => o.Id == declarant.OrganizationFormId);
var refType = AppContext.OBK_Ref_Type.FirstOrDefault(o => o.Id == declaration.TypeId);
OBK_ZBKCopy zbkCopy = AppContext.OBK_ZBKCopy.FirstOrDefault(o => o.Id == ZBKCopyId);
var status = AppContext.OBK_Ref_Status.FirstOrDefault(o => o.Code.Equals(CodeConstManager.STATUS_OBK_DRAFT_ID.ToString()));
if (zbkCopy == null)
{
zbkCopy = new OBK_ZBKCopy();
zbkCopy.Id = Guid.NewGuid();
zbkCopy.AttachPath = FileHelper.GetObjectPathRoot();
zbkCopy.OBK_StageExpDocumentId = stageExpDocId;
zbkCopy.ExpApplication = stageExpDocument.ExpApplication;
AppContext.OBK_ZBKCopy.Add(zbkCopy);
AppContext.SaveChanges();
zbkCopy.StatusId = status.Id;
}
model.Declarer = declarantContact.BossLastName + " " + declarantContact.BossFirstName
+ " " + declarantContact.BossMiddleName;
model.ConclusionNumber = stageExpDocument.ExpConclusionNumber;
model.ContractNumber = contract.Number;
model.DeclarationNumber = declaration.Number;
model.StartDate = stageExpDocument.ExpStartDate;
model.ExpireDate = stageExpDocument.ExpEndDate;
model.OrganizationName = organization.Name;
model.CopyQuantity = zbkCopy.CopyQuantity;
model.DeclarationType = refType.NameRu;
model.ContractId = contract.Id;
model.AttachPath = zbkCopy.AttachPath;
model.Id = zbkCopy.Id;
model.ExpApplication = stageExpDocument.ExpApplication;
model.CopyQuantity = zbkCopy.CopyQuantity;
model.Nds = TaxHelper.GetNdsRef() + 1;
return(model);
}
public string GetSignData(Guid id)
{
var zbkCopy = AppContext.OBK_ZBKCopy.FirstOrDefault(o => o.Id == id);
if (zbkCopy == null)
{
return(null);
}
OBK_ZBKCopy zc = new OBK_ZBKCopy
{
Id = zbkCopy.Id,
OBK_StageExpDocumentId = zbkCopy.Id
};
var xmlData = SerializeHelper.SerializeDataContract(zc);
return(xmlData.Replace("utf-16", "utf-8"));
}
