public static void PrintDistributionDocument(DistributionDocument dd) { string brokerName = BrokerHouseInformation.GetBrokerHouseName(); PDFCreators creator = new PDFCreators(true, 25, 25, 15, 15); creator.SetDocumentHeaderFooter(); creator.OpenPDF(); creator.GetContentByte(); creator.AddJDBLogoForFactures(10, 775); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); if (dd.DistributionDocType.Code == DistributionDocType.ISPRATNICA) { creator.SetTitleCenterForFactureNumber("ИСПРАТНИЦА " + dd.DocumentNumber); creator.SetTitleLeftWithFontSize10("за филијала " + dd.Branch.Code + " " + dd.Branch.Name); } else if (dd.DistributionDocType.Code == DistributionDocType.POVRATNICA) { creator.SetTitleCenterForFactureNumber("ПОВРАТНИЦА " + dd.DocumentNumber); creator.SetTitleLeftWithFontSize10("од филијала " + dd.Branch.Code + " " + dd.Branch.Name); } else if (dd.DistributionDocType.Code == DistributionDocType.PRIEM) { creator.SetTitleCenterForFactureNumber("ПРИЕМ " + dd.DocumentNumber); } creator.SetTitleLeft10("Датум: " + dd.DocumentDate.ToShortDateString()); List <DistributionDocumentItem> lstDDI = DistributionDocumentItem.GetByDistributionDocument(dd.ID); string[] headers = { "Ред. бр.", "Број на полиса", "Осиг. компанија", "Тип на осигурување", "Под на осигурување" }; float[] widthPercentages = { 8, 17, 25, 25, 25 }; TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String }; creator.CreateTable_Facture(headers.Length, headers, widthPercentages); int counter = 1; foreach (DistributionDocumentItem ddi in lstDDI) { object[] values; values = new object[headers.Length]; values[0] = counter; values[1] = ddi.Distribution.PolicyNumber; values[2] = ddi.Distribution.InsuranceCompany.ShortName; values[3] = ddi.Distribution.InsuranceSubType.InsuranceType.ShortName; values[4] = ddi.Distribution.InsuranceSubType.ShortDescription; creator.AddDataRowForFacturesExtend(values, headers.Length, typeCodes, headers, widthPercentages); counter++; } creator.AddTable(); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" Издал Примил"); creator.SetTitleLeft8(" "); creator.SetTitleLeft8("_________________________ ____________________"); creator.FinishPDF_FileName("IspratnicaPovratnica" + dd.DocumentNumber); }
public static void PrintFacture(Broker.DataAccess.Facture f) { string brokerName = BrokerHouseInformation.GetBrokerHouseName(); if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_PROVIZIJA || f.DocumentSubType.Code == DocumentSubType.IZLEZNA_FAKTURA_ZA_PROVZIJA_ZA_ZIVOTNO_OSUGURUVANjE) { PDFCreators creator = new PDFCreators(true, 25, 25, 15, 15); creator.SetDocumentHeaderFooter(); creator.OpenPDF(); creator.GetContentByte(); creator.AddJDBLogoForFactures(10, 775); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_PROVIZIJA) { creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA_ZA_OSIG_KOMPANII).Value); } else if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_KLIENT) { creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA).Value); } creator.SetTitleLeft8(" Депонент : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.DEPONENT).Value); creator.SetTitleLeft8(" ЕДБ : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.EDB).Value + " " + "Матичен број : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.MATICEN_BROJ).Value); creator.SetTitleLeft8(" "); if (f.Discard) { creator.SetTitleCenterForFactureNumber("СТОРНИРАНА Ф-ра бр. " + f.FactureNumber); } else { creator.SetTitleCenterForFactureNumber("Фактура бр. " + f.FactureNumber); } string internalCode = ""; try { FinansovoDataClassesDataContext fdc = new FinansovoDataClassesDataContext(); List <Client> listCLients = fdc.Clients.Where(c => c.EMBG == f.Client.EMBG).ToList(); if (listCLients.Count > 0) { internalCode = listCLients[0].Code; } } catch { } if (internalCode != string.Empty) { creator.SetTitleLeftWithFontSize10(internalCode); } creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Name).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Address).ToUpper()); //creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Place.Municipality.Name).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Place.Name).ToUpper()); creator.SetTitleLeft10("Датум на фактура: " + f.DateOfCreation.ToShortDateString()); creator.SetTitleLeft10("Рок на плаќање: " + f.DateOfPayment.ToShortDateString()); //creator.SetTitleLeft8("Период: " + f.FromDate.ToShortDateString() + " - " + f.ToDate.ToShortDateString()); string[] headers = { "Ред. бр.", "Опис", "Количина", "Премија", "Брокеража" }; float[] widthPercentages = { 8, 45, 15, 17, 15 }; TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.Int32, TypeCode.Decimal, TypeCode.Decimal }; creator.CreateTable_Facture(headers.Length, headers, widthPercentages); object[] values; foreach (FactureItem fi in f.FactureItems) { values = new object[headers.Length]; values[0] = fi.Number.ToString(); values[1] = fi.Description; values[2] = fi.Count.ToString(); values[3] = String.Format("{0:#,0.00}", fi.PremiumValue); values[4] = String.Format("{0:#,0.00}", fi.BrokerageValue); creator.AddDataRowForFactures(values, headers.Length, typeCodes); } values = new object[headers.Length]; values[0] = ""; values[1] = ""; values[2] = ""; values[3] = "Вкупно"; values[4] = String.Format("{0:#,0.00}", f.BrokerageValue); creator.AddDataRowForFactures(values, headers.Length, typeCodes); creator.AddTable(); creator.SetTitleLeftBold14(" "); creator.SetTitleLeftItalic10("Со букви: " + NumberToTextController.Konvertiranje(f.BrokerageValue)); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Ве молиме фактурираниот износ да го платите до назначениот рок на плаќање."); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Доколку износот за фактурата не биде платен до наведениот датум, се пресметува затезна камата од денот на стасаност до денот на плаќањето."); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Согласно со член 23, точка 6 од Законот за ДДВ дејноста осигурување е ослободена од плаќање данок без право на одбиток на претходниот данок."); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft10(" Фактурирал Примил Одобрил"); creator.SetTitleLeft10(" _________________ __________________ ____________________"); creator.AddPage(); creator.SetTitleCenterForFactureNumber("Спецификација за фактура бр. " + f.FactureNumber); string[] headersSpecifications = { "Ред. бр.", "Број на полиса", "Почеток", "Истек", "Дата на издавање", "Премија" }; float[] widthPercentagesSpecifications = { 10, 20, 19, 19, 19, 13 }; TypeCode[] typeCodesSpecifications = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal }; object[] valuesSpecifications; foreach (FactureItem fi in f.FactureItems) { creator.SetTitleLeft10Bold(fi.InsuranceSubType.Description); creator.CreateTable_Facture(headersSpecifications.Length, headersSpecifications, widthPercentagesSpecifications); if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_PROVIZIJA) { List <PolicyItemFactureItem> pifiList = PolicyItemFactureItem.GetByFactureItemID(fi.ID); int ordinalNumber = 1; foreach (PolicyItemFactureItem pifi in pifiList) { valuesSpecifications = new object[6]; valuesSpecifications[0] = ordinalNumber; valuesSpecifications[1] = pifi.PolicyItem.PolicyNumber; valuesSpecifications[2] = pifi.PolicyItem.Policy.StartDate.ToShortDateString(); valuesSpecifications[3] = pifi.PolicyItem.Policy.EndDate.ToShortDateString(); valuesSpecifications[4] = pifi.PolicyItem.Policy.ApplicationDate.ToShortDateString(); valuesSpecifications[5] = pifi.PolicyItem.PremiumValue; creator.AddDataRowForFacturesExtend(valuesSpecifications, headersSpecifications.Length, typeCodesSpecifications, headersSpecifications, widthPercentagesSpecifications); ordinalNumber++; } } if (f.DocumentSubType.Code == DocumentSubType.IZLEZNA_FAKTURA_ZA_PROVZIJA_ZA_ZIVOTNO_OSUGURUVANjE) { List <LifePolicyFactureItem> pifiList = LifePolicyFactureItem.GetByFactureItemID(fi.ID); int ordinalNumber = 1; foreach (LifePolicyFactureItem pifi in pifiList) { valuesSpecifications = new object[6]; valuesSpecifications[0] = ordinalNumber; valuesSpecifications[1] = pifi.LifePolicy.PolicyNumber; valuesSpecifications[2] = pifi.LifePolicy.StartDate.ToShortDateString(); valuesSpecifications[3] = pifi.LifePolicy.EndDate.ToShortDateString(); valuesSpecifications[4] = pifi.LifePolicy.ApplicationDate.ToShortDateString(); valuesSpecifications[5] = pifi.LifePolicy.TotalPremumValue; creator.AddDataRowForFacturesExtend(valuesSpecifications, headersSpecifications.Length, typeCodesSpecifications, headersSpecifications, widthPercentagesSpecifications); ordinalNumber++; } } creator.AddTable(); creator.SetTitleCenterForFactureNumber(" "); } creator.FinishPDF_FileName("Factura" + f.FactureNumber); } if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_KLIENT) { PDFCreators creator = new PDFCreators(true, 25, 25, 15, 15); creator.SetDocumentHeaderFooter(); creator.OpenPDF(); creator.GetContentByte(); creator.AddJDBLogoForFactures(10, 775); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA).Value); creator.SetTitleLeft8(" Депонент : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.DEPONENT).Value); creator.SetTitleLeft8(" ЕДБ : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.EDB).Value + " " + "Матичен број : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.MATICEN_BROJ).Value); creator.SetTitleLeft8(" "); if (f.Discard) { creator.SetTitleCenterForFactureNumber("СТОРНИРАНА Ф-ра бр. " + f.FactureNumber); } else { creator.SetTitleCenterForFactureNumber("Фактура бр. " + f.FactureNumber); } string internalCode = ""; try { FinansovoDataClassesDataContext fdc = new FinansovoDataClassesDataContext(); List <Client> listCLients = fdc.Clients.Where(c => c.EMBG == f.Client.EMBG).ToList(); if (listCLients.Count > 0) { internalCode = listCLients[0].Code; } } catch { } if (internalCode != string.Empty) { creator.SetTitleLeftWithFontSize10(internalCode); } creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Name).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Address).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Place.Municipality.Name).ToUpper()); creator.SetTitleLeft10("Датум на фактура: " + f.DateOfCreation.ToShortDateString()); creator.SetTitleLeft10("Рок на плаќање: " + f.DateOfPayment.ToShortDateString()); //creator.SetTitleLeft8("Период: " + f.FromDate.ToShortDateString() + " - " + f.ToDate.ToShortDateString()); string[] headers = { "Ред. бр.", "Број на полиса", "Осиг. комапнија", "Тип на осигурување", "Премија" }; float[] widthPercentages = { 8, 17, 30, 30, 15 }; TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal }; creator.CreateTable_Facture(headers.Length, headers, widthPercentages); object[] values; foreach (FactureItem fi in f.FactureItems) { List <PolicyItemFactureItem> pifi = PolicyItemFactureItem.GetByFactureItemID(fi.ID); values = new object[headers.Length]; values[0] = fi.Number.ToString(); values[1] = pifi[0].PolicyItem.PolicyNumber; values[2] = pifi[0].PolicyItem.Policy.InsuranceCompany.ShortName; values[3] = pifi[0].PolicyItem.InsuranceSubType.ShortDescription; values[4] = String.Format("{0:#,0.00}", fi.PremiumValue) + " ДЕН."; creator.AddDataRowForFactures(values, headers.Length, typeCodes); } values = new object[headers.Length]; values[0] = ""; values[1] = ""; values[2] = ""; values[3] = "Вкупно"; values[4] = String.Format("{0:#,0.00}", f.TotalCost) + " ДЕН."; creator.AddDataRowForFactures(values, headers.Length, typeCodes); creator.AddTable(); creator.SetTitleLeftBold14(" "); creator.SetTitleLeftItalic10("Со букви: " + NumberToTextController.Konvertiranje(f.TotalCost)); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Ве молиме фактурираниот износ да го платите до назначениот рок на плаќање."); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Доколку износот за фактурата не биде платен до наведениот датум, се пресметува затезна камата од денот на стасаност до денот на плаќањето."); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Согласно со член 23, точка 6 од Законот за ДДВ дејноста осигурување е ослободена од плаќање данок без право на одбиток на претходниот данок."); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft10(" Фактурирал Примил Одобрил"); creator.SetTitleLeft10(" _________________ __________________ ____________________"); Broker.DataAccess.Parameter pSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT = Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.SE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT); bool fpSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT = true; if (pSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT != null) { if (Convert.ToBoolean(pSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT.Value) == false) { fpSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT = false; } } if (fpSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT) { string facItemDescriptionStart = "Полиса - "; creator.AddPage(); foreach (FactureItem fi in f.FactureItems) { string polNumber = fi.Description.Substring(facItemDescriptionStart.Length); creator.SetTitleLeft10(facItemDescriptionStart + polNumber); string[] headersRates = { "Рата бр.", "Дата за плаќање", "Износ" }; float[] widthPercentagesRates = { 15, 50, 35 }; TypeCode[] typeCodesRates = { TypeCode.Int32, TypeCode.String, TypeCode.Decimal }; creator.CreateTable_Facture(headersRates.Length, headersRates, widthPercentagesRates); PolicyItem pi = PolicyItem.GetByNumberAndInsuranceSubType(polNumber, fi.InsuranceSubTypeID, (int)fi.Facture.InsuranceCompanyID); List <Rate> rates = Rate.GetByPolicyItemID(pi.ID); rates = rates.OrderBy(c => c.Number).ToList(); foreach (Rate r in rates) { object[] valuesRates = new object[headersRates.Length]; valuesRates[0] = r.Number; valuesRates[1] = r.Date.ToShortDateString(); valuesRates[2] = String.Format("{0:#,0.00}", r.Value); creator.AddDataRowForFactures(valuesRates, headersRates.Length, typeCodes); } creator.AddTable(); } } creator.FinishPDF_FileName("Factura" + f.FactureNumber); } if (f.DocumentSubType.Code == DocumentSubType.GRUPNA_FAKTURA) { PDFCreators creator = new PDFCreators(true, 25, 25, 15, 15); creator.SetDocumentHeaderFooter(); creator.OpenPDF(); creator.GetContentByte(); creator.AddJDBLogoForFactures(10, 775); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA).Value); creator.SetTitleLeft8(" Депонент : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.DEPONENT).Value); creator.SetTitleLeft8(" ЕДБ : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.EDB).Value + " " + "Матичен број : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.MATICEN_BROJ).Value); creator.SetTitleLeft8(" "); if (f.Discard) { creator.SetTitleCenterForFactureNumber("СТОРНИРАНА Фактура бр. " + f.FactureNumber); } else { creator.SetTitleCenterForFactureNumber("Фактура бр. " + f.FactureNumber); } string internalCode = ""; try { FinansovoDataClassesDataContext fdc = new FinansovoDataClassesDataContext(); List <Client> listCLients = fdc.Clients.Where(c => c.EMBG == f.Client.EMBG).ToList(); if (listCLients.Count > 0) { internalCode = listCLients[0].Code; } } catch { } if (internalCode != string.Empty) { creator.SetTitleLeftWithFontSize10(internalCode); } creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Name).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Address).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Place.Municipality.Name).ToUpper()); creator.SetTitleLeft10("Датум на фактура: " + f.DateOfCreation.ToShortDateString()); creator.SetTitleLeft10("Рок на плаќање: " + f.DateOfPayment.ToShortDateString()); string[] headers = { "Ред. бр.", "Број на полиса", "Осиг. компанија", "Тип на осигурување", "Премија" }; float[] widthPercentages = { 8, 17, 30, 30, 15 }; TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal }; creator.CreateTable_Facture(headers.Length, headers, widthPercentages); object[] values; foreach (FactureItem fi in f.FactureItems) { List <PolicyItemFactureItem> pifi = PolicyItemFactureItem.GetByFactureItemID(fi.ID); values = new object[headers.Length]; values[0] = fi.Number.ToString(); values[1] = pifi[0].PolicyItem.PolicyNumber; values[2] = pifi[0].PolicyItem.Policy.InsuranceCompany.ShortName; values[3] = pifi[0].PolicyItem.InsuranceSubType.ShortDescription; values[4] = String.Format("{0:#,0.00}", fi.PremiumValue) + " ДЕН."; creator.AddDataRowForFactures(values, headers.Length, typeCodes); } values = new object[headers.Length]; values[0] = ""; values[1] = ""; values[2] = ""; values[3] = "Вкупно"; values[4] = String.Format("{0:#,0.00}", f.TotalCost) + " ДЕН."; creator.AddDataRowForFactures(values, headers.Length, typeCodes); creator.AddTable(); creator.SetTitleLeftBold14(" "); creator.SetTitleLeftItalic10("Со букви: " + NumberToTextController.Konvertiranje(f.TotalCost)); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Ве молиме фактурираниот износ да го платите до назначениот рок на плаќање."); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Доколку износот за фактурата не биде платен до наведениот датум, се пресметува затезна камата од денот на стасаност до денот на плаќањето."); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Согласно со член 23, точка 6 од Законот за ДДВ дејноста осигурување е ослободена од плаќање данок без право на одбиток на претходниот данок."); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft10(" Фактурирал Примил Одобрил"); creator.SetTitleLeft10(" _________________ __________________ ____________________"); bool fpSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT = true; if (Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.SE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT) != null) { fpSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT = Boolean.Parse(Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.SE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT).Value); } if (fpSE_PECATI_SPECIFIKACIJA_NA_F_RA_ZA_KLIENT) { string facItemDescriptionStart = "Полиса бр. "; creator.AddPage(); foreach (FactureItem fi in f.FactureItems) { string polNumber = fi.Description.Substring(facItemDescriptionStart.Length); creator.SetTitleLeft10(facItemDescriptionStart + polNumber); string[] headersRates = { "Рата бр.", "Дата за плаќање", "Износ" }; float[] widthPercentagesRates = { 15, 50, 35 }; TypeCode[] typeCodesRates = { TypeCode.Int32, TypeCode.String, TypeCode.Decimal }; creator.CreateTable_Facture(headersRates.Length, headersRates, widthPercentagesRates); PolicyItem pi = PolicyItem.GetByNumberAndInsuranceSubType(polNumber, fi.InsuranceSubTypeID, (int)fi.Facture.InsuranceCompanyID); List <Rate> rates = Rate.GetByPolicyItemID(pi.ID); rates = rates.OrderBy(c => c.Number).ToList(); foreach (Rate r in rates) { object[] valuesRates = new object[headersRates.Length]; valuesRates[0] = r.Number; valuesRates[1] = r.Date.ToShortDateString(); valuesRates[2] = String.Format("{0:#,0.00}", r.Value); creator.AddDataRowForFactures(valuesRates, headersRates.Length, typeCodes); } creator.AddTable(); } } creator.FinishPDF_FileName("Factura" + f.FactureNumber); } }
public static void PrintAccountFacture(AccountFacture f) { if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_PROVIZIJA) { PDFCreators creator = new PDFCreators(true, 15, 15, 15, 15); creator.OpenPDF(); creator.GetContentByte(); creator.AddJDBLogoForFactures(10, 760); creator.SetTitleLeft8(" "); creator.SetTitleLeftBold14(" " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.IME).Value); creator.SetTitle(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" Адреса : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ADRESA).Value); creator.SetTitleLeft8(" Место : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.MESTO).Value); creator.SetTitleLeft8(" Телефон : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.TELEFON).Value + " " + "Факс : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.FAKS).Value); if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_PROVIZIJA) { creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA_ZA_OSIG_KOMPANII).Value); } else if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_KLIENT) { creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA).Value); } creator.SetTitleLeft8(" Депонент : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.DEPONENT).Value); creator.SetTitleLeft8(" ЕДБ : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.EDB).Value + " " + "Матичен број : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.MATICEN_BROJ).Value); creator.SetTitleLeft8(" Web-страна : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.WEB_STRANA).Value + " " + "E-Mail : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.EMAIL).Value); creator.SetTitleLeft8(" "); if (f.Discard) { creator.SetTitleCenterForFactureNumber("СТОРНИРАНА Ф-ра бр. " + f.FactureNumber); } else { creator.SetTitleCenterForFactureNumber("Фактура бр. " + f.FactureNumber); } creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Name).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Address).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Place.Municipality.Name).ToUpper()); creator.SetTitleLeft10("Датум на фактура: " + f.DateOfCreation.ToShortDateString()); creator.SetTitleLeft10("Рок на плаќање: " + f.DateOfPayment.ToShortDateString()); //creator.SetTitleLeft8("Период: " + f.FromDate.ToShortDateString() + " - " + f.ToDate.ToShortDateString()); string[] headers = { "Ред. бр.", "Опис", "Количина", "Премија", "Брокеража" }; float[] widthPercentages = { 8, 45, 15, 17, 15 }; TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.Int32, TypeCode.Decimal, TypeCode.Decimal }; creator.CreateTable_Facture(headers.Length, headers, widthPercentages); object[] values; foreach (AccountFactureItem fi in f.AccountFactureItems) { values = new object[headers.Length]; values[0] = fi.Number.ToString(); values[1] = fi.Description; values[2] = fi.Count.ToString(); values[3] = String.Format("{0:#,0.00}", fi.PremiumValue); values[4] = String.Format("{0:#,0.00}", fi.BrokerageValue); creator.AddDataRowForFactures(values, headers.Length, typeCodes); } values = new object[headers.Length]; values[0] = ""; values[1] = ""; values[2] = ""; values[3] = "Вкупно"; values[4] = String.Format("{0:#,0.00}", f.BrokerageValue); creator.AddDataRowForFactures(values, headers.Length, typeCodes); creator.AddTable(); creator.SetTitleLeftBold14(" "); creator.SetTitleLeftItalic10("Со букви: " + NumberToTextController.Konvertiranje(f.BrokerageValue)); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Ве молиме фактурираниот износ да го платите до назначениот рок на плаќање."); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Доколку износот за фактурата не биде платен до наведениот датум, се пресметува затезна камата од денот на стасаност до денот на плаќањето."); creator.SetTitleLeft8(" "); creator.SetTitleLeft10("Согласно со член 23, точка 6 од Законот за ДДВ дејноста осигурување е ослободена од плаќање данок без право на одбиток на претходниот данок."); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft10(" Фактурирал Примил Одобрил"); creator.SetTitleLeft10(" _________________ __________________ ____________________"); creator.AddPage(); creator.SetTitleCenterForFactureNumber("Спецификација за фактура бр. " + f.FactureNumber); string[] headersSpecifications = { "Ред. бр.", "Број на полиса", "Почеток", "Истек", "Дата на издавање", "Премија" }; float[] widthPercentagesSpecifications = { 10, 20, 19, 19, 19, 13 }; TypeCode[] typeCodesSpecifications = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal }; object[] valuesSpecifications; foreach (AccountFactureItem fi in f.AccountFactureItems) { creator.SetTitleLeft10Bold(fi.InsuranceSubType.Description); creator.CreateTable_Facture(headersSpecifications.Length, headersSpecifications, widthPercentagesSpecifications); List <AccountFactureItemPolicyItem> pifiList = AccountFactureItemPolicyItem.GetByAccountFactureItem(fi.ID); int ordinalNumber = 1; foreach (AccountFactureItemPolicyItem pifi in pifiList) { valuesSpecifications = new object[6]; valuesSpecifications[0] = ordinalNumber; valuesSpecifications[1] = pifi.PolicyItem.PolicyNumber; valuesSpecifications[2] = pifi.PolicyItem.Policy.StartDate.ToShortDateString(); valuesSpecifications[3] = pifi.PolicyItem.Policy.EndDate.ToShortDateString(); valuesSpecifications[4] = pifi.PolicyItem.Policy.ApplicationDate.ToShortDateString(); valuesSpecifications[5] = pifi.PolicyItem.PremiumValue; creator.AddDataRowForFacturesExtend(valuesSpecifications, headersSpecifications.Length, typeCodesSpecifications, headersSpecifications, widthPercentagesSpecifications); ordinalNumber++; } creator.AddTable(); creator.SetTitleCenterForFactureNumber(" "); } creator.FinishPDF_FileName("Factura" + f.FactureNumber); } //if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_KLIENT) //{ // PDFCreators creator = new PDFCreators(true, 15, 15, 15, 15); // creator.OpenPDF(); // creator.GetContentByte(); // creator.AddJDBLogoForFactures(10, 760); // creator.SetTitleLeft8(" "); // creator.SetTitleLeftBold14(" " + Parameter.GetByCode(Parameter.IME).Value); // creator.SetTitle(" "); // creator.SetTitleLeft8(" "); // creator.SetTitleLeft8(" Адреса : " + Parameter.GetByCode(Parameter.ADRESA).Value); // creator.SetTitleLeft8(" Место : " + Parameter.GetByCode(Parameter.MESTO).Value); // creator.SetTitleLeft8(" Телефон : " + Parameter.GetByCode(Parameter.TELEFON).Value + " " + "Факс : " + Parameter.GetByCode(Parameter.FAKS).Value); // creator.SetTitleLeft8(" Жиро-сметка : " + Parameter.GetByCode(Parameter.ZIRO_SMETKA).Value); // creator.SetTitleLeft8(" Депонент : " + Parameter.GetByCode(Parameter.DEPONENT).Value); // creator.SetTitleLeft8(" ЕДБ : " + Parameter.GetByCode(Parameter.EDB).Value + " " + "Матичен број : " + Parameter.GetByCode(Parameter.MATICEN_BROJ).Value); // creator.SetTitleLeft8(" Web-страна : " + Parameter.GetByCode(Parameter.WEB_STRANA).Value + " " + "E-Mail : " + Parameter.GetByCode(Parameter.EMAIL).Value); // creator.SetTitleLeft8(" "); // creator.SetTitleCenterForFactureNumber("Фактура бр. " + f.FactureNumber); // creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Name).ToUpper()); // creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Address).ToUpper()); // creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Place.Municipality.Name).ToUpper()); // creator.SetTitleLeft10("Датум на фактура: " + f.DateOfCreation.ToShortDateString()); // creator.SetTitleLeft10("Рок на плаќање: " + f.DateOfPayment.ToShortDateString()); // //creator.SetTitleLeft8("Период: " + f.FromDate.ToShortDateString() + " - " + f.ToDate.ToShortDateString()); // string[] headers = { "Ред. бр.", "Опис", "Количина", "Премија" }; // float[] widthPercentages = { 10, 50, 15, 25 }; // TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.Int32, TypeCode.Decimal }; // creator.CreateTable_Facture(headers.Length, headers, widthPercentages); // object[] values; // foreach (FactureItem fi in f.FactureItems) // { // values = new object[headers.Length]; // values[0] = fi.Number.ToString(); // values[1] = fi.Description; // values[2] = fi.Count.ToString(); // values[3] = String.Format("{0:#,0.00}", fi.PremiumValue); // creator.AddDataRowForFactures(values, headers.Length, typeCodes); // } // values = new object[headers.Length]; // values[0] = ""; // values[1] = ""; // values[2] = "Вкупно"; // values[3] = String.Format("{0:#,0.00}", f.TotalCost); // creator.AddDataRowForFactures(values, headers.Length, typeCodes); // creator.AddTable(); // creator.SetTitleLeftBold14(" "); // creator.SetTitleLeftItalic10("Со букви: " + NumberToTextController.Konvertiranje(f.TotalCost)); // creator.SetTitleLeft8(" "); // creator.SetTitleLeft10("Ве молиме фактурираниот износ да го платите до назначениот рок на плаќање."); // creator.SetTitleLeft8(" "); // creator.SetTitleLeft10("Доколку износот за фактурата не биде платен до наведениот датум, се пресметува затезна камата од денот на стасаност до денот на плаќањето."); // creator.SetTitleLeft8(" "); // creator.SetTitleLeft10("Согласно со член 23, точка 6 од Законот за ДДВ дејноста осигурување е ослободена од плаќање данок без право на одбиток на претходниот данок."); // creator.SetTitleLeft8(" "); // creator.SetTitleLeft8(" "); // creator.SetTitleLeft8(" "); // creator.SetTitleLeft8(" "); // creator.SetTitleLeft10(" Фактурирал Примил Одобрил"); // creator.SetTitleLeft10(" _________________ __________________ ____________________"); // string facItemDescriptionStart = "Полиса - "; // creator.AddPage(); // foreach (FactureItem fi in f.FactureItems) { // string polNumber = fi.Description.Substring(facItemDescriptionStart.Length); // creator.SetTitleLeft10(facItemDescriptionStart + polNumber); // string[] headersRates = { "Рата бр.", "Дата за плаќање", "Износ" }; // float[] widthPercentagesRates = { 15, 50, 35 }; // TypeCode[] typeCodesRates = { TypeCode.Int32, TypeCode.String, TypeCode.Decimal }; // creator.CreateTable_Facture(headersRates.Length, headersRates, widthPercentagesRates); // PolicyItem pi = PolicyItem.GetByNumberAndInsuranceSubType(polNumber, fi.InsuranceSubTypeID, fi.Facture.InsuranceCompanyID); // List<Rate> rates = Rate.GetByPolicyItemID(pi.ID); // rates = rates.OrderBy(c => c.Number).ToList(); // foreach (Rate r in rates) { // object[] valuesRates = new object[headersRates.Length]; // valuesRates[0] = r.Number; // valuesRates[1] = r.Date.ToShortDateString(); // valuesRates[2] = String.Format("{0:#,0.00}", r.Value); // creator.AddDataRowForFactures(valuesRates, headersRates.Length, typeCodes); // } // creator.AddTable(); // } //creator.FinishPDF_FileName("Factura" + f.FactureNumber); }
public static void PrintCashReport(CashReport cr) { PDFCreators creator = new PDFCreators(true, 15, 15, 15, 15); creator.OpenPDF(); creator.GetContentByte(); creator.AddJDBLogoForFactures(10, 775); creator.SetTitleLeft10(" "); creator.SetTitleLeft10(" "); creator.SetTitleLeft10(" "); if (cr.Discard) { creator.SetTitleCenterForFactureNumber("СТОРНИРАН КАСОВ ИЗВЕШТАЈ бр. " + cr.Number); } else { creator.SetTitleCenterForFactureNumber("КАСОВ ИЗВЕШТАЈ бр. " + cr.Number); } creator.SetTitleLeft10("Статус: " + cr.CashReportStatuse.Name); creator.SetTitleLeft10("Датум: " + cr.CashReportDate.ToShortDateString()); creator.SetTitleLeft10("Филијала: " + cr.Branch.Code + " " + cr.Branch.Name); List <CashReportItem> lstCRI = CashReportItem.GetByCashReport(cr.ID); creator.SetTitleLeft10(" "); creator.SetTitleLeft10("Кеш уплата"); Broker.DataAccess.PaymentType ptCash = Broker.DataAccess.PaymentType.GetByCode(Broker.DataAccess.PaymentType.CASH); List <CashReportItem> cashList = lstCRI.Where(c => c.Payment.PaymentTypeID == ptCash.ID).ToList(); string[] headers = { "Ред. бр.", "Број на полиса", "Компанија", "Подкласа", "Договорувач", "Уплата" }; float[] widthPercentages = { 8, 10, 17, 18, 32, 15 }; TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal }; creator.CreateTable_Facture(headers.Length, headers, widthPercentages); object[] values; int ordinalNumber = 1; decimal totCash = 0; foreach (CashReportItem cri in cashList) { values = new object[headers.Length]; values[0] = ordinalNumber.ToString(); values[1] = cri.Payment.Rate.PolicyItem.PolicyNumber; values[2] = cri.Payment.Rate.PolicyItem.Policy.InsuranceCompany.ShortName; values[3] = cri.Payment.Rate.PolicyItem.InsuranceSubType.ShortDescription; values[4] = cri.Payment.Rate.PolicyItem.Policy.Client.Name; values[5] = String.Format("{0:#,0.00}", cri.Payment.Value); creator.AddDataRowForFactures(values, headers.Length, typeCodes); ordinalNumber++; totCash += cri.Payment.Value; } values = new object[headers.Length]; values[0] = ""; values[1] = ""; values[2] = ""; values[3] = ""; values[4] = "Вкупно"; values[5] = String.Format("{0:#,0.00}", totCash); creator.AddDataRowForFactures(values, headers.Length, typeCodes); creator.AddTable(); creator.SetTitleLeft10(" "); creator.SetTitleLeft10("Кредитни картички"); Broker.DataAccess.PaymentType ptCreditCard = Broker.DataAccess.PaymentType.GetByCode(Broker.DataAccess.PaymentType.CREDITCARD); List <CashReportItem> creditCardList = lstCRI.Where(c => c.Payment.PaymentTypeID == ptCreditCard.ID).ToList(); string[] headersCC = { "Ред. бр.", "Број на полиса", "Компанија", "Подкласа", "Договорувач", "Банка", "Уплата" }; float[] widthPercentagesCC = { 7, 9, 16, 17, 27, 10, 14 }; TypeCode[] typeCodesCC = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal }; creator.CreateTable_Facture(headersCC.Length, headersCC, widthPercentagesCC); object[] valuesCC; int ordinalNumberCC = 1; decimal totCreditCard = 0; foreach (CashReportItem cri in creditCardList) { valuesCC = new object[headersCC.Length]; valuesCC[0] = ordinalNumberCC.ToString(); valuesCC[1] = cri.Payment.Rate.PolicyItem.PolicyNumber; valuesCC[2] = cri.Payment.Rate.PolicyItem.Policy.InsuranceCompany.ShortName; valuesCC[3] = cri.Payment.Rate.PolicyItem.InsuranceSubType.ShortDescription; valuesCC[4] = cri.Payment.Rate.PolicyItem.Policy.Client.Name; if (cri.Payment.BankCreditCardID != null) { valuesCC[5] = cri.Payment.BankCreditCard.Bank.Name; } else { valuesCC[5] = ""; } valuesCC[6] = String.Format("{0:#,0.00}", cri.Payment.Value); creator.AddDataRowForFactures(valuesCC, headersCC.Length, typeCodesCC); ordinalNumberCC++; totCreditCard += cri.Payment.Value; } valuesCC = new object[headersCC.Length]; valuesCC[0] = ""; valuesCC[1] = ""; valuesCC[2] = ""; valuesCC[3] = ""; valuesCC[4] = ""; valuesCC[5] = "Вкупно"; valuesCC[6] = String.Format("{0:#,0.00}", totCreditCard); creator.AddDataRowForFactures(valuesCC, headersCC.Length, typeCodesCC); creator.AddTable(); creator.SetTitleLeft10(" "); creator.SetTitleRightBold14("Вкупно: " + String.Format("{0:#,0.00}", (totCreditCard + totCash))); creator.FinishPDF_FileName("KasovIzvestaj" + cr.ID); }
public static void PrintFinCard(Policy p, Broker.DataAccess.Client c, string itemsType) { string brokerName = BrokerHouseInformation.GetBrokerHouseName(); PDFCreators creator = new PDFCreators(true, 25, 25, 15, 15); creator.SetDocumentHeaderFooter(); creator.OpenPDF(); creator.GetContentByte(); creator.AddJDBLogoForFactures(10, 775); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" "); creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA).Value); creator.SetTitleLeft8(" Депонент : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.DEPONENT).Value); creator.SetTitleLeft8(" ЕДБ : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.EDB).Value + " " + "Матичен број : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.MATICEN_BROJ).Value); creator.SetTitleLeft8(" "); creator.SetTitleCenterForFactureNumber("ФИНАНСОВА КАРТИЦА"); List <FinanceCardInfo> lst = new List <FinanceCardInfo>(); if (p != null) { creator.SetTitleLeftWithFontSize10("за полиса " + p.PolicyItems[0].PolicyNumber); lst = FinanceControllers.FinanceCardController.GetByPolicy(p, 0); } else if (c != null) { creator.SetTitleLeftWithFontSize10("за договорувач: "); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(c.Name).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(c.Address).ToUpper()); creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(c.Place.Municipality.Name).ToUpper()); if (itemsType == "AllItems") { lst = FinanceControllers.FinanceCardController.GetByClient(c); } else if (itemsType == "OpenItems") { lst = FinanceControllers.FinanceCardController.GetByClientOpenItems(c); } } creator.SetTitleLeft10("Датум на печатење: " + DateTime.Today.ToShortDateString()); //decimal totalSaldo = 0; decimal totalDebtValue = 0; decimal totalDemandValue = 0; string[] headers = { "Дата", "Доспева", "Опис", "Должи", "Побарува", "Салдо" }; float[] widthPercentages = { 10, 10, 35, 15, 15, 15 }; TypeCode[] typeCodes = { TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal, TypeCode.Decimal, TypeCode.Decimal }; creator.CreateTable_Facture(headers.Length, headers, widthPercentages); foreach (FinanceCardInfo fci in lst) { object[] values; values = new object[headers.Length]; values[0] = fci.DocumentDate.ToShortDateString(); values[1] = fci.PaidDate.ToShortDateString(); values[2] = fci.Description; values[3] = String.Format("{0:#,0.00}", fci.DebtValue); values[4] = String.Format("{0:#,0.00}", fci.DemandValue); values[5] = String.Format("{0:#,0.00}", fci.SaldoValue); totalDebtValue += fci.DebtValue; totalDemandValue += fci.DemandValue; //totalSaldo += fci.SaldoValue; creator.AddDataRowForFactures(values, headers.Length, typeCodes); } object[] valuesTot; valuesTot = new object[headers.Length]; valuesTot[0] = ""; valuesTot[1] = ""; valuesTot[2] = ""; valuesTot[3] = String.Format("{0:#,0.00}", totalDebtValue); valuesTot[4] = String.Format("{0:#,0.00}", totalDemandValue); valuesTot[5] = String.Format("{0:#,0.00}", totalDebtValue - totalDemandValue); creator.AddDataRowForFactures(valuesTot, headers.Length, typeCodes); creator.AddTable(); creator.FinishPDF_FileName("FinCard"); }