public ActionResult ActExportFilePdf(Guid id)
{
string name = "Акт выполненных работ.pdf";
StiReport report = new StiReport();
try
{
report.Load(Server.MapPath("~/Reports/Mrts/OBK/1c/ObkCertificateOfCompletion.mrt"));
foreach (var data in report.Dictionary.Databases.Items.OfType <StiSqlDatabase>())
{
data.ConnectionString = UserHelper.GetCnString();
}
report.Dictionary.Variables["AssessmentDeclarationId"].ValueObject = id;
report.Dictionary.Variables["ContractId"].ValueObject = expRepo.GetAssessmentDeclaration(id).ContractId;
report.Dictionary.Variables["ValueAddedTax"].ValueObject = expRepo.GetValueAddedTax();
var totalCount = expRepo.GetContractPrice(expRepo.GetAssessmentDeclaration(id).ContractId);
report.Dictionary.Variables["TotalCount"].ValueObject = totalCount;
var priceText = RuDateAndMoneyConverter.CurrencyToTxtTenge(Convert.ToDouble(totalCount), false);
report.Dictionary.Variables["TotalCountText"].ValueObject = priceText;
report.Render(false);
}
catch (Exception ex)
{
LogHelper.Log.Error("ex: " + ex.Message + " \r\nstack: " + ex.StackTrace);
}
var stream = new MemoryStream();
report.ExportDocument(StiExportFormat.Pdf, stream);
stream.Position = 0;
return(File(stream, "application/pdf", name));
}
public ActionResult GetPaymentTemplatePdf(Guid id)
{
var payRepo = new OBKPaymentRepository();
string name = "Счет на оплату.pdf";
StiReport report = new StiReport();
try
{
report.Load(Server.MapPath("~/Reports/Mrts/OBK/1c/ObkInvoicePayment.mrt"));
foreach (var data in report.Dictionary.Databases.Items.OfType <StiSqlDatabase>())
{
data.ConnectionString = UserHelper.GetCnString();
}
report.Dictionary.Variables["ContractId"].ValueObject = id;
//итого
var totalPriceWithCount = payRepo.GetTotalPriceCount(id);
report.Dictionary.Variables["TotalPriceWithCount"].ValueObject = totalPriceWithCount;
//в том числе НДС
var totalPriceNDS = payRepo.GetTotalPriceNDS(totalPriceWithCount);
report.Dictionary.Variables["TotalPriceNDS"].ValueObject = totalPriceNDS;
//прописью
var priceText = RuDateAndMoneyConverter.CurrencyToTxtTenge(Convert.ToDouble(totalPriceWithCount), false);
report.Dictionary.Variables["TotalPriceWithCountName"].ValueObject = priceText;
//report.Dictionary.Variables["ChiefAccountant"].ValueObject = payRepo.GetEmpoloyee(Guid.Parse("E1EE3658-0C35-41EB-99FD-FDDC4D07CEC4"));
//report.Dictionary.Variables["Executor"].ValueObject = payRepo.GetEmpoloyee(Guid.Parse("55377FAC-A5F0-4093-BBB6-18BD28E53BE1"));
report.Render(false);
}
catch (Exception ex)
{
LogHelper.Log.Error("ex: " + ex.Message + " \r\nstack: " + ex.StackTrace);
}
var stream = new MemoryStream();
var contractId = payRepo.GetContractIdGuid(id);
var directionToPayment = payRepo.GetDirectionToPayments(contractId);
var signPayment = payRepo.GetDirectionSignData(directionToPayment.Id);
if (signPayment.ChiefAccountantSign != null && signPayment.ExecutorSign != null)
{
try
{
report.ExportDocument(StiExportFormat.Word2007, stream);
stream.Position = 0;
Aspose.Words.Document doc = new Aspose.Words.Document(stream);
doc.InserQrCodesToEnd("ChiefAccountantSign", signPayment.ChiefAccountantSign);
var pdfFile = new MemoryStream();
doc.Save(pdfFile, SaveFormat.Pdf);
pdfFile.Position = 0;
stream.Close();
return(new FileStreamResult(pdfFile, "application/pdf"));
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
report.ExportDocument(StiExportFormat.Pdf, stream);
stream.Position = 0;
return(new FileStreamResult(stream, "application/pdf"));
}
public string GetSignData(Guid id)
{
var payment = AppContext.OBK_DirectionToPayments.FirstOrDefault(e => e.Id == id);
var contract = AppContext.OBK_Contract.FirstOrDefault(e => e.Id == payment.ContractId);
var unitsBank = AppContext.UnitsBanks.FirstOrDefault(e => e.UnitsId == contract.ExpertOrganization);
if (payment?.OBK_DirectionSignData.ExecutorSign != null)
{
var xmlData = SerializeHelper.SerializeDataContract(payment.OBK_DirectionSignData.ExecutorSign);
return(xmlData.Replace("utf-16", "utf-8"));
}
else
{
List <ContractPriceSignData> contractPriceSign = AppContext.OBK_ContractPrice
.Where(e => e.ContractId == contract.Id)
.Select(e => new ContractPriceSignData()
{
ContractPriceName = e.OBK_RS_Products.NameRu,
ContractPriceDicName = e.OBK_Ref_PriceList.NameRu,
ContractPrice = e.OBK_Ref_PriceList.Price * 1.12,
ContractPriceCount = e.Count,
ContractPriceTotal = e.OBK_Ref_PriceList.Price * 1.12 * e.Count,
})
.ToList();
var result = new OBKPaymentSignData
{
Id = id,
ContractId = payment?.ContractId,
ContactNumber = contract?.Number,
ContactStartDate = contract?.StartDate,
ContactTypeName = contract?.OBK_Ref_Type.NameRu,
UnitsName = contract?.Unit.Name,
UnitsAddress = contract?.Unit.LegalAddress,
UnitsPhone = contract?.Unit.Phone,
UnitsBin = contract?.Unit.Bin,
UnitsIIk = unitsBank?.IIK,
UnitsKbe = unitsBank?.KBE,
UnitsBankName = unitsBank?.BankNameRu,
UnitsBankSwift = unitsBank?.SWIFT,
UnitsBankCode = unitsBank?.Code,
InvoiceNuber1C = payment?.InvoiceNumber1C,
InvoiceDate1C = payment?.InvoiceDatetime1C,
DeclarantBin = contract?.OBK_Declarant.Bin,
DeclarantOrgName = GetDictionary(contract?.OBK_Declarant.OrganizationFormId).Name,
DeclarantName = contract?.OBK_Declarant.NameRu,
DeclarantCountryName = GetDictionary(contract?.OBK_DeclarantContact.CurrencyId).Name,
DeclarantAddressLegal = contract?.OBK_DeclarantContact.AddressLegalRu,
ContractPriceNds = GetTotalPriceCount(payment.ContractId),
ContractPriceTotalText =
RuDateAndMoneyConverter.CurrencyToTxtTenge(
Convert.ToDouble(GetTotalPriceCount(payment.ContractId)), false),
ChiefAccountant = null, //GetEmpoloyee(Guid.Parse("E1EE3658-0C35-41EB-99FD-FDDC4D07CEC4"))?.ShortName,
Executor = null, //GetEmpoloyee(Guid.Parse("55377FAC-A5F0-4093-BBB6-18BD28E53BE1"))?.ShortName,
ContractPriceSignDatas = contractPriceSign
};
var xmlData = SerializeHelper.SerializeDataContract(result);
return(xmlData.Replace("utf-16", "utf-8"));
}
}
public ActionResult GetContractTemplatePdf(Guid id)
{
var db = new ncelsEntities();
string name = "Договор_на_проведение_оценки_безопасности_и_качества.pdf";
StiReport report = new StiReport();
try
{
report.Load(obkRepo.GetContractTemplatePath(id));//(Server.MapPath("~/Reports/Mrts/OBK/ObkContractDec.mrt"));
foreach (var data in report.Dictionary.Databases.Items.OfType <StiSqlDatabase>())
{
data.ConnectionString = UserHelper.GetCnString();
}
report.Dictionary.Variables["ContractId"].ValueObject = id;
var price = new OBKContractRepository().GetPriceCount(id);
report.Dictionary.Variables["PriceCount"].ValueObject = price;
var priceText = RuDateAndMoneyConverter.ToTextTenge(Convert.ToDouble(price), false);
report.Dictionary.Variables["PriceCountName"].ValueObject = priceText;
report.Render(false);
}
catch (Exception ex)
{
LogHelper.Log.Error("ex: " + ex.Message + " \r\nstack: " + ex.StackTrace);
}
Stream stream = new MemoryStream();
report.ExportDocument(StiExportFormat.Word2007, stream);
stream.Position = 0;
Aspose.Words.Document doc = new Aspose.Words.Document(stream);
try
{
var signData = db.OBK_ContractSignedDatas.Where(x => x.ContractId == id).FirstOrDefault();
if (signData != null && signData.ApplicantSign != null && signData.CeoSign != null)
{
doc.InserQrCodesToEnd("ApplicantSign", signData.ApplicantSign);
doc.InserQrCodesToEnd("CeoSign", signData.CeoSign);
}
}
catch (Exception ex)
{
}
var file = new MemoryStream();
doc.Save(file, Aspose.Words.SaveFormat.Pdf);
file.Position = 0;
//return new FileStreamResult(stream, "application/pdf");
return(File(file, "application/pdf", name));
}
/// <summary>
/// Акт выполненных работ
/// </summary>
/// <returns></returns>
public ActionResult CertOfComplectFilePdf(Guid id)
{
OBKExpDocumentRepository expRepo = new OBKExpDocumentRepository();
string name = "Акт выполненных работ.pdf";
StiReport report = new StiReport();
try
{
report.Load(Server.MapPath("~/Reports/Mrts/OBK/1c/ObkCertificateOfCompletion.mrt"));
foreach (var data in report.Dictionary.Databases.Items.OfType <StiSqlDatabase>())
{
data.ConnectionString = UserHelper.GetCnString();
}
report.Dictionary.Variables["AssessmentDeclarationId"].ValueObject = id;
var declaration = expRepo.GetAssessmentDeclaration(id);
report.Dictionary.Variables["ContractId"].ValueObject = declaration.ContractId;
report.Dictionary.Variables["ValueAddedTax"].ValueObject = expRepo.GetValueAddedTax();
var refType = db.OBK_Ref_Type.FirstOrDefault(o => o.Id == declaration.TypeId);
var expDocument = db.OBK_StageExpDocument.FirstOrDefault(o => o.AssessmentDeclarationId == id);
decimal totalCount = 0;
if (CodeConstManager.OBK_SA_PARTY.Equals(refType.Code) && expDocument.ExpResult == false)
{
totalCount = expRepo.GetContractPriceMotivationRefuse(expRepo.GetAssessmentDeclaration(id).ContractId);
}
else
{
totalCount = expRepo.GetContractPrice(expRepo.GetAssessmentDeclaration(id).ContractId);
}
report.Dictionary.Variables["TotalCount"].ValueObject = totalCount;
var priceText = RuDateAndMoneyConverter.CurrencyToTxtTenge(Convert.ToDouble(totalCount), false);
report.Dictionary.Variables["TotalCountText"].ValueObject = priceText;
report.Render(false);
}
catch (Exception ex)
{
LogHelper.Log.Error("ex: " + ex.Message + " \r\nstack: " + ex.StackTrace);
}
var stream = new MemoryStream();
report.ExportDocument(StiExportFormat.Pdf, stream);
stream.Position = 0;
return(new FileStreamResult(stream, "application/pdf"));
//return File(stream, "application/pdf", name);
}
public void AddItems()
{
for (var i = 0; i < armCardItem.Items.Count; i++)
{
var it = armCardItem.Items[i];
UpdateCell((i + 1).ToString(), (UInt32)(17 + 2 * i + 1), "A");
UpdateCell(it.Clothes.ParentName, (UInt32)(17 + 2 * i), "B");
UpdateCell(it.Clothes.Name, (UInt32)(17 + 2 * i + 1), "B");
UpdateCell(it.Clothes.SrokNoski, (UInt32)(17 + 2 * i), "C");
UpdateCell(it.Clothes.NormaVidachi, (UInt32)(17 + 2 * i), "D");
;
UpdateCell(RuDateAndMoneyConverter.NumeralsToTxt((long)Convert.ToInt32(it.Count), TextCase.Accusative, false, false), (UInt32)(17 + 2 * i + 1), "E");
}
}
public ActionResult CertOfComplectFilePdf(Guid zbkCopyId)
{
OBKExpDocumentRepository expRepo = new OBKExpDocumentRepository();
string name = "Акт выполненных работ.pdf";
var copy = db.OBK_ZBKCopy.FirstOrDefault(o => o.Id == zbkCopyId);
var expDocument = db.OBK_StageExpDocument.FirstOrDefault(o => o.Id == copy.OBK_StageExpDocumentId);
StiReport report = new StiReport();
try
{
if (copy.ExpApplication == false)
{
report.Load(Server.MapPath("~/Reports/Mrts/OBK/1c/ObkCertificateOfCompletionCopyZbkApplication.mrt"));
}
else
{
report.Load(Server.MapPath("~/Reports/Mrts/OBK/1c/ObkCertificateOfCompletionCopyZbk.mrt"));
}
foreach (var data in report.Dictionary.Databases.Items.OfType <StiSqlDatabase>())
{
data.ConnectionString = UserHelper.GetCnString();
}
report.Dictionary.Variables["AssessmentDeclarationId"].ValueObject = expDocument.AssessmentDeclarationId;
report.Dictionary.Variables["ContractId"].ValueObject = expRepo.GetAssessmentDeclaration((Guid)expDocument.AssessmentDeclarationId).ContractId;
var totalCount = payRepo.GetTotalPriceZbkCopy(zbkCopyId);
report.Dictionary.Variables["TotalCount"].ValueObject = totalCount;
var priceText = RuDateAndMoneyConverter.CurrencyToTxtTenge(Convert.ToDouble(totalCount), false);
report.Dictionary.Variables["TotalCountText"].ValueObject = priceText;
report.Dictionary.Variables["ZBKCopyId"].ValueObject = copy.Id;
report.Dictionary.Variables["PriceNds"].ValueObject = repository.GetZbkCopyNds(zbkCopyId);
report.Render(false);
}
catch (Exception ex)
{
LogHelper.Log.Error("ex: " + ex.Message + " \r\nstack: " + ex.StackTrace);
}
var stream = new MemoryStream();
report.ExportDocument(StiExportFormat.Pdf, stream);
stream.Position = 0;
return(new FileStreamResult(stream, "application/pdf"));
}
public void MakeWayBillInExcel(string idWaybill)
{
try
{
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(ConfigurationManager.AppSettings.Get("PathForOpenBill"));
xlSheet = xlWorkBook.Sheets[1];
SystemOwner systemOwner = new OwnerMapper().Get();
WayBill wayBill = new WayBillMapper().Get(idWaybill);
FileOperator fileOperator = new FileOperator();
xlSheet.Cells[22, "Y"] = "рейс";
xlSheet.Cells[5, "B"] = systemOwner.Bank.Name;
xlSheet.Cells[5, "X"] = systemOwner.Bank.BIK;
xlSheet.Cells[6, "X"] = systemOwner.Bank.KorBill;
xlSheet.Cells[9, "B"] = systemOwner.Name;
xlSheet.Cells[8, "D"] = systemOwner.INN;
xlSheet.Cells[8, "X"] = systemOwner.Bill;
xlSheet.Cells[17, "F"] = systemOwner.ToString();
xlSheet.Cells[30, "H"] = systemOwner.Director.GetFullName();
xlSheet.Cells[13, "K"] = wayBill.IdWayBill;
xlSheet.Cells[13, "Q"] = ((DateTime)wayBill.UnloadDate).ToString("dd/MM/yyyy");
xlSheet.Cells[19, "F"] = $"{wayBill.Client.Name}, ИНН {wayBill.Client.INN}, {wayBill.Client.Address}";
xlSheet.Cells[22, "D"] = $"Транспортные услуги по маршруту: {wayBill.Trip.Name} " +
$" Водитель: {wayBill.Driver.GetShortName()} Машина: {wayBill.Car.ToString()} По договор-заявке {wayBill.BaseDocument}";
xlSheet.Cells[22, "AB"] = wayBill.Cost;
xlSheet.Cells[28, "B"] = RuDateAndMoneyConverter.CurrencyToTxt(wayBill.Cost, true);
xlWorkBook.SaveAs(fileOperator.MakeBillPath(wayBill, mainPath));
xlWorkBook.Close();
xlApp.Quit();
while (System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp) > 0)
{
}
}
catch (Exception ex)
{
MessageBox.Show($"Не удалось сделать счет на оплату № {idWaybill}\n" +
$"{ex.Message}");
xlWorkBook.Close(false);
xlApp.Quit();
while (System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp) > 0)
{
}
}
}
public void MakeBillInExcel(string idRepair)
{
try
{
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(ConfigurationManager.AppSettings.Get("PathForOpenBill"));
xlSheet = xlWorkBook.Sheets[1];
SystemOwner systemOwner = new OwnerMapper().Get();
CardOfRepair card = new CardMapper().Get(idRepair.ToString());
FileOperator fileOperator = new FileOperator();
xlSheet.Cells[5, "B"] = systemOwner.Bank.Name;
xlSheet.Cells[5, "X"] = systemOwner.Bank.BIK;
xlSheet.Cells[6, "X"] = systemOwner.Bank.KorBill;
xlSheet.Cells[9, "B"] = systemOwner.Name;
xlSheet.Cells[8, "D"] = systemOwner.INN;
xlSheet.Cells[8, "X"] = systemOwner.Bill;
xlSheet.Cells[17, "F"] = systemOwner.ToString();
xlSheet.Cells[30, "H"] = systemOwner.Director.GetFullName();
xlSheet.Cells[13, "K"] = card.IdRepair;
xlSheet.Cells[13, "Q"] = ((DateTime)card.TimeOfFinish).ToString("dd/MM/yyyy");
xlSheet.Cells[19, "F"] = $"{card.Car.Owner.Name}, ИНН {card.Car.Owner.INN}, {card.Car.Owner.Address}";
xlSheet.Cells[22, "D"] = $"Ремонт автомобиля: {card.Car.ToString()} по заявке № {idRepair}" +
$" от {((DateTime)card.TimeOfFinish).ToString("dd/MM/yyyy")}";
xlSheet.Cells[22, "AB"] = card.TotalPrice;
xlSheet.Cells[28, "B"] = RuDateAndMoneyConverter.CurrencyToTxt(card.TotalPrice, true);
xlWorkBook.SaveAs(fileOperator.MakeBillPath(card, mainPath));
xlWorkBook.Close();
xlApp.Quit();
while (System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp) > 0)
{
}
}
catch (Exception ex)
{
MessageBox.Show($"Не удалось сделать счет на оплату № {idRepair}\n" +
$"{ex.Message}");
xlWorkBook.Close(false);
xlApp.Quit();
while (System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp) > 0)
{
}
}
}
