private void btnsave_Click(object sender, EventArgs e) { Cutoff c = new Cutoff(); txtcutoff_id.Text = dtfrom_date.Value.ToString("MMddyyyy") + dtto_date.Value.ToString("MMddyyyy"); c.cutoff_id = txtcutoff_id.Text; c.from_date = dtfrom_date.Value; c.to_date = dtto_date.Value; TimeSpan numofdays = c.to_date.Subtract(c.from_date); if (c.save()) { for (int x = 0; x <= numofdays.Days; x++) { Cutoff_Details cd = new Cutoff_Details(); Day_Marker dm, dm1 = new Day_Marker(); DateTime thisdate = c.from_date.AddDays(x); //MessageBox.Show(thisdate.ToString("MMMM-d")); //CHECK FOR HOLIDAYS IN THE DAY MARKER TABLE dm= dm1.SELECT_BY_DATE(thisdate.ToString("MMMM-d")); String day_type=""; String holiday_name=""; if (thisdate.ToString("dddd") == "Sunday") { day_type = "REST_DAY"; } else { day_type = (dm != null) ? dm.type_ : "REGULAR_DAY"; holiday_name = (dm != null) ? dm.name_of_holiday : ""; } cd.cutoff_id = c.cutoff_id; cd.date_ = thisdate; cd.day_type = day_type; cd.holiday_name = holiday_name; cd.save(); //MessageBox.Show(day_type + "-" + holiday_name); } MessageBox.Show("Successful.", "Saving Cutoff"); } else { MessageBox.Show("There was a problem saving this cutoff.\n\n Message :" + db.err.Message, "Saving Cutoff"); } }
private void CutoffDetailsToolStripMenuItem_Click(object sender, EventArgs e) { if (lv.SelectedItems.Count > 0) { string cutoff_id = lv.SelectedItems[0].SubItems[1].Text; Cutoff_Details cd1 = new Cutoff_Details(); cd1.cutoff_id = cutoff_id; frmCutoffDetails frm = new frmCutoffDetails(); frm.WindowState = FormWindowState.Normal; frm.cd = cd1; frm.ShowDialog(); } }
private void generatePayrollToolStripMenuItem_Click(object sender, EventArgs e) { if (lv.SelectedItems.Count > 0) { string cutoff_id = lv.SelectedItems[0].SubItems[1].Text; Cutoff c, c1 = new Cutoff(); c1.cutoff_id = cutoff_id; c= c1.SELECT_BY_ID(); //PAYROLL GENERATOR USER INTERFACE payroll_generator_ctrl pgctrl = new payroll_generator_ctrl(); //PASS A DATATABLE TO PAYROLL GENERATOR Cutoff_Details cd1 = new Cutoff_Details(); cd1.cutoff_id = c1.cutoff_id; DataTable cutoffdetailsdt = cd1.SELECT_BYID(); pgctrl.cutoffdetailsdt = cutoffdetailsdt; pnlops.Controls.Clear(); pgctrl.cutoff = c; pgctrl.Width = pnlops.Width; pnlops.Height = pgctrl.Height; pnlops.Controls.Add(pgctrl); } }