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") + "') "); }