public PaySheetForm(PaySheetFilter filter) : this()
{
this.filter = filter;
for (int i = 0; i < departCbx.Items.Count; i++)
{
if (((Department)departCbx.Items[i]).id == filter.department_id)
{
departCbx.SelectedItem = departCbx.Items[i];
break;
}
}
datePck.Value = filter.date;
List <PaySheet> list = paySheetSet.getListSheetsFiltered(filter);
for (int i = 0; i < list.Count; i++)
{
dataGridSheet.Rows.Add();
for (int j = 0; j < ((DataGridViewComboBoxCell)(dataGridSheet.Rows[i].Cells["employee"])).Items.Count; j++)
{
if (((Employee)((DataGridViewComboBoxCell)(dataGridSheet.Rows[i].Cells["employee"])).Items[j]).id == list[i].employee_id)
{
((DataGridViewComboBoxCell)(dataGridSheet.Rows[i].Cells["employee"])).Value = ((DataGridViewComboBoxCell)(dataGridSheet.Rows[i].Cells["employee"])).Items[j];
break;
}
}
dataGridSheet["sum", i].Value = list[i].sum;
}
}
public List <PaySheet> getListSheetsFiltered(PaySheetFilter filter)
{
DataTable dt = ConnectionClass.getResult("SELECT id,date,department_id,employee_id,sum " +
"from pay_sheet where department_id = " + filter.department_id + " and date = '" + filter.date.ToString("yyyy-MM-dd") + "'");
List <PaySheet> list = new List <PaySheet>();
for (int i = 0; i < dt.Rows.Count; i++)
{
list.Add(new PaySheet(dt.Rows[i]));
}
return(list);
}
public void deleteSheetsFiltered(PaySheetFilter filter)
{
ConnectionClass.executeQuery("delete from pay_sheet where department_id = " + filter.department_id + " and "
+ "strftime('%Y %m', date) = strftime('%Y %m', '" + filter.date.ToString("yyyy-MM-dd") + "') ");
}
