private bool IsKaseRow(PersonPayRow row)
{
string descr = row.ListDescription;
if (descr.IsNOE())
{
return(false);
}
string s = descr.ToLower();
return(s.Contains("kase") || s.Contains("kasē"));
}
public void DoFilter()
{
PersonPayRows = new List <PersonPayRow>();
DateTime dt1 = DataLoader.LoadedDT1;
DateTime dt2 = DataLoader.LoadedDT2;
if (!string.IsNullOrEmpty(tbDate1.Text))
{
dt1 = Utils.StringToDate(tbDate1.Text).Value;
}
if (!string.IsNullOrEmpty(tbDate2.Text))
{
dt2 = Utils.StringToDate(tbDate2.Text).Value;
}
int idp = -1;
if (cbPerson.SelectedIndex > -1 && cbPerson.SelectedValue != null)
{
idp = (int)cbPerson.SelectedValue;
}
if (dt1 < DataLoader.LoadedDT1)
{
dt1 = DataLoader.LoadedDT1;
}
if (dt2 > DataLoader.LoadedDT2)
{
dt2 = DataLoader.LoadedDT2;
}
string sdt1 = Utils.DateToString(dt1);
string sdt2 = Utils.DateToString(dt2);
if (sdt1 != tbDate1.Text)
{
tbDate1.Text = sdt1;
}
if (sdt2 != tbDate2.Text)
{
tbDate2.Text = sdt2;
}
/*
* if (idp == -1)
* {
* bsRows.DataSource = PersonPayRows;
* return;
* }
*/
var table_payrows = MyData.DataSetKlons.PAYLISTS_R;
var drs_pay = table_payrows
.WhereX(d =>
(idp == -1 || d.IDP == idp) &&
d.PAYLISTSRow.DT >= dt1 &&
d.PAYLISTSRow.DT <= dt2)
.OrderBy(d => d.PAYLISTSRow.DT)
.ThenBy(d => d.PAYLISTSRow.SNR)
.ThenBy(d => d.PAYLISTSRow.ID)
.ToList();
foreach (var dr_pay in drs_pay)
{
var pprow = new PersonPayRow()
{
RowId = dr_pay.ID,
PersonPayRowType = EPersonPayRowType.Pay,
Date = dr_pay.PAYLISTSRow.DT,
ListDescription = dr_pay.PAYLISTSRow.DESCR,
PositionTitle = dr_pay.POSITIONSRow.TITLE,
NotPaid = dr_pay.PAY0,
NotPaidAdvance = dr_pay.ADVANCE0,
NotPaidWithhold = dr_pay.WITHHOLDINGS0,
NotPaidT = dr_pay.TPAY0,
PayT = dr_pay.TPAY,
Diff = dr_pay.TPAY0 - dr_pay.TPAY,
CalcIIN = dr_pay.IIN0,
TakeIIN = dr_pay.IIN,
};
PersonPayRows.Add(pprow);
}
if (idp == -1)
{
bsRows.DataSource = PersonPayRows;
return;
}
var table_salary_r = MyData.DataSetKlons.SALARY_SHEETS_R;
var drs_salary_r = table_salary_r
.WhereX(d =>
d.IDP == idp &&
d.XType != ESalarySheetRowType.Total &&
d.SALARY_SHEETSRowByFK_SALARY_SHEETS_R_IDS.DT2.IsBetween(dt1, dt2))
.OrderBy(d => d.SALARY_SHEETSRowByFK_SALARY_SHEETS_R_IDS.DT2)
.ToList();
foreach (var dr_salary_r in drs_salary_r)
{
var pprow = new PersonPayRow()
{
RowId = dr_salary_r.ID,
PersonPayRowType = EPersonPayRowType.Calc,
Date = dr_salary_r.SALARY_SHEETSRowByFK_SALARY_SHEETS_R_IDS.DT2,
ListDescription = dr_salary_r.SALARY_SHEETSRowByFK_SALARY_SHEETS_R_IDS.DESCR,
PositionTitle = dr_salary_r.POSITIONSRow.TITLE,
Calc = dr_salary_r.PAY,
CalcAdvance = dr_salary_r.ADVANCE,
CalcWithhold = dr_salary_r.MINUS_AFTER_IIN,
CalcT = dr_salary_r.PAYT,
CalcIIN = dr_salary_r.IIN_AMOUNT
};
PersonPayRows.Add(pprow);
}
PersonPayRows = PersonPayRows
.OrderBy(d => d.Date)
.ThenBy(d => d.PersonPayRowType)
.ToList();
bsRows.DataSource = PersonPayRows;
}