public List <IINReportRow> MakeReport2(EReportType reporttype, DateTime dt1, DateTime dt2)
{
var rows2 = new List <IINReportRow>();
KlonsARepDataSet.SP_REP_IINK_21DataTable table = null;
var ad = new KlonsA.DataSets.KlonsARepDataSetTableAdapters.SP_REP_IINK_21TableAdapter();
if (reporttype == EReportType.ForMonth)
{
table = ad.GetDataBy_SP_REP_IINK_21(dt1.Year, dt1.Month, dt1, dt2);
}
else if (reporttype == EReportType.ForYear)
{
table = ad.GetDataBy_SP_REP_IINK_22(dt1.Year, dt1, dt2);
}
for (int i = 0; i < table.Rows.Count; i++)
{
var dr = table.Rows[i] as KlonsARepDataSet.SP_REP_IINK_21Row;
var rr = new IINReportRow();
rr.nr = i + 1;
rr.idp = dr.IDP;
var drp = MyData.DataSetKlons.PERSONS_FIZ.FindByID(rr.idp);
rr.PK = PKForRep(drp.PK);
rr.Name = drp.FNAME + " " + drp.LNAME;
rr.Date1 = dr.DATE1;
rr.Date2 = dr.DATE2;
rr.Month = dr.PAYMONTH;
rr.MonthS = Utils.MonthNames[rr.Month - 1];
rr.IncomeType = dr.INCOME_ID;
rr.IncomeTypeS = MyData.DataSetKlons.INCOME_CODES
.FindByID(rr.IncomeType)?.DESCR;
rr.income = dr.TAXED + dr.NOSAI;
rr.income_nottaxed = dr.NOTTAXED;
rr.authors_fee = dr.AUTHORS_FEE;
rr.dnsn_amount = dr.SIDN;
rr.iin_exempt_expenses = dr.IINEX;
rr.before_iin = dr.IIN_FROM;
rr.iin_amount = dr.IIN;
rows2.Add(rr);
}
return(rows2);
}
public List <IINReportRow> MakeReport1(EReportType reporttype, DateTime dt1, DateTime dt2, DateTime dtx, bool simple)
{
var rows1 = new List <IINReportRow>();
KlonsARepDataSet.SP_REP_IINK_01DataTable table = null;
var ad = new KlonsA.DataSets.KlonsARepDataSetTableAdapters.SP_REP_IINK_01TableAdapter();
if (MyData.Params.IINSimple)
{
if (reporttype == EReportType.ForMonth)
{
table = ad.GetDataBy_SP_REP_IINK_02(dt1, dt2, new DateTime(dt1.Year, 1, 1));
}
else if (reporttype == EReportType.ForYear)
{
table = ad.GetDataBy_SP_REP_IINK_03(dt1, dt2);
}
}
else
{
if (reporttype == EReportType.ForMonth)
{
table = ad.GetDataBy_SP_REP_IINK_32(dt1, dt2, dtx);
}
else if (reporttype == EReportType.ForYear)
{
table = ad.GetDataBy_SP_REP_IINK_33(dt1, dt2, dtx);
}
}
for (int i = 0; i < table.Rows.Count; i++)
{
var dr = table.Rows[i] as KlonsARepDataSet.SP_REP_IINK_01Row;
var rr = new IINReportRow();
rr.nr = i + 1;
rr.idp = dr.IDP;
var drp = MyData.DataSetKlons.PERSONS.FindByID(rr.idp);
rr.PK = PKForRep(drp.PK);
rr.Name = drp.FNAME + " " + drp.LNAME;
rr.Date1 = dr.DT1;
rr.Date2 = dr.DT2;
rr.IncomeType = "1001";
rr.IncomeTypeS = "Darba alga";
rr.dnsn_amount = dr.DNSN_AMOUNT;
rr.untaxed_minimum0 = dr.UNTAXED_MINIMUM0;
rr.iin_exempt_dependants0 = dr.IIN_EXEMPT_DEPENDANTS0;
rr.iin_exempt_x0 = dr.IIN_EXEMPT_20;
rr.untaxed_minimum = dr.UNTAXED_MINIMUM;
rr.iin_exempt_dependants = dr.IIN_EXEMPT_DEPENDANTS;
rr.iin_exempt_x = dr.IIN_EXEMPT_2;
rr.iin_exempt_xtp = dr.IIN_EXEMPT_2TP;
rr.iin_exempt_expenses = dr.IIN_EXEMPT_EXPENSES;
rr.plus_pf_nottaxed = dr.PLUS_PF_NOTTAXED;
rr.plus_li_nottaxed = dr.PLUS_LI_NOTTAXED;
rr.plus_hi_nottaxed = dr.PLUS_HI_NOTTAXED;
rr.income_nottaxed = dr.PLUS_NOTTAXED;
rr.income = dr.INCOME -
rr.income_nottaxed +
rr.plus_pf_nottaxed +
rr.plus_li_nottaxed +
rr.plus_hi_nottaxed;
rr.before_iin = rr.income -
rr.income_nottaxed -
rr.untaxed_minimum -
rr.dnsn_amount -
rr.iin_exempt_dependants -
rr.iin_exempt_x -
rr.iin_exempt_expenses -
rr.plus_pf_nottaxed -
rr.plus_li_nottaxed -
rr.plus_hi_nottaxed;
rr.iin_amount = dr.IIN_AMOUNT;
rows1.Add(rr);
}
return(rows1);
}
