public static void PrintSkadencar(DateTime fromDate, DateTime toDate, List <int> lstBranches, List <int> lstInsuranceCompanies, List <int> lstInsuranceSubTypes)
{
DataClassesDataContext dcdc = new DataClassesDataContext();
DateTime dt1 = fromDate;
DateTime dt2 = toDate;
int d1 = dt1.Day;
int m1 = dt1.Month;
int y1 = dt1.Year;
int d2 = dt2.Day;
int m2 = dt2.Month;
int y2 = dt2.Year;
PDFCreators pdf = new PDFCreators(false, 10, 10, 10, 10);
pdf.OpenPDF();
pdf.SetTitle("Скаденцар");
pdf.SetTitle("Истек на полиса од " + fromDate.ToShortDateString() + " до " + toDate.ToShortDateString());
pdf.SetTitleLeft10("Датум и време на печатење: " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString());
string query = @"select p.id, pi.id as policyItemID, pi.policynumber, p.applicationdate, ist.shortdescription as insurancesubtypename, ic.shortname as insurancecompanyname,
c.name as clientname, o.name as ownername, it.shortname as insurancetypename, p.startdate, p.enddate, ist.id as insuranceSubTypeID
from policies p
inner join policyitems pi on pi.policyid = p.id
inner join clients c on p.clientid = c.id
inner join clients o on p.ownerid = o.id
inner join insurancecompanies ic on p.insurancecompanyid=ic.id
inner join insurancesubtypes ist on pi.insurancesubtypeid=ist.id
inner join insurancetypes it on ist.insurancetypeid=it.id
where p.branchid in (" + ReportFinPolicies.GetFromIDs(lstBranches) + ") " +
@" and p.insurancecompanyid in (" + ReportFinPolicies.GetFromIDs(lstInsuranceCompanies) + ") " +
@" and pi.insurancesubtypeid in (" + ReportFinPolicies.GetFromIDs(lstInsuranceSubTypes) + ") " +
@" and p.enddate>='" + y1 + - +m1 + - +d1 + "'" +
@" and p.enddate<='" + y2 + - +m2 + - +d2 + "'" +
@" and p.discard = 0 " +
@" order by p.enddate";
//@" --query so marketing agent";
List <SummaryForSkadencar> lst = dcdc.ExecuteQuery <SummaryForSkadencar>(query).ToList();
int counter = 1;
foreach (SummaryForSkadencar ss in lst)
{
string[] headers = new string[5];
headers[0] = "Р.бр.: " + counter.ToString();
headers[1] = "Полиса: " + ss.policynumber;
headers[2] = "Класа: " + ss.insurancetypename;
headers[3] = "Подкласа: " + ss.insurancesubtypename;
headers[4] = "О.компанија: " + ss.insurancecompanyname;
TypeCode[] codes = new TypeCode[headers.Length];
codes[0] = TypeCode.String;
codes[1] = TypeCode.String;
codes[2] = TypeCode.String;
codes[3] = TypeCode.String;
codes[4] = TypeCode.String;
float[] policyColumnsWidths = new float[headers.Length];
policyColumnsWidths[0] = 16;
policyColumnsWidths[1] = 20;
policyColumnsWidths[2] = 24;
policyColumnsWidths[3] = 24;
policyColumnsWidths[4] = 16;
pdf.CreateTableForSkadencar(headers.Count(), false, headers, "", policyColumnsWidths);
object[] vals = new object[headers.Count()];
vals[0] = "Издадена на: " + ss.applicationdate.ToShortDateString();
vals[1] = "Скаденца: " + ss.startdate.ToShortDateString() + " - " + ss.enddate.ToShortDateString();
vals[2] = "Договорувач: " + ss.clientname;
vals[3] = "Осигуреник: " + ss.ownername;
string regNumber = "";
Broker.DataAccess.Control con = Broker.DataAccess.Control.GetByInsuranceSubTypeAndTexbBoxID(ss.insuranceSubTypeID, Broker.DataAccess.Control.REGISTRATION_NUMBER);
if (con != null)
{
PolicyExtendInformation regNumberPEI = PolicyExtendInformation.GetByPolicyItemAndControl(ss.policyItemID, con.ID);
if (regNumberPEI != null)
{
regNumber = regNumberPEI.Value;
}
}
vals[4] = "Регистрација: " + regNumber;
pdf.AddDataRowWithBorder(vals, headers.Count(), codes);
pdf.AddTable();
counter++;
}
pdf.FinishPDF_FileName("Skadencar");
}