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);
}
}
