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");
}
}
}//end select all
public Cutoff SELECT_BY_ID()
{
DataTable dt = new DataTable();
MySqlCommand cmd = new MySqlCommand();
db.SET_COMMAND_PARAMS(cmd, "CUTOFF_SELECT_BYID");
cmd.Parameters.AddWithValue("_cutoff_id", cutoff_id);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
try
{
da.Fill(dt);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
Cutoff c = new Cutoff();
c.from_date = Convert.ToDateTime(dr["from_date"].ToString());
c.to_date = Convert.ToDateTime(dr["to_date"].ToString());
c.cutoff_id = dr["cutoff_id"].ToString();
return(c);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
catch (Exception e)
{
Logger.WriteErrorLog("CUTOFF_SELECT ALL MODULE : " + e.Message);
return(null);
}
}//end select all
public void LoadOnListView(ListView lv)
{
Cutoff s = new Cutoff();
DataTable dt = new DataTable();
dt = s.SELECT_ALL();
if (dt != null)
{
int ctr = 1;
foreach (DataRow r in dt.Rows)
{
ListViewItem li = new ListViewItem();
li.Text = ctr.ToString();
li.SubItems.Add(r["cutoff_id"].ToString());
li.SubItems.Add(Convert.ToDateTime(r["from_date"].ToString()).ToShortDateString());
li.SubItems.Add(Convert.ToDateTime(r["to_date"].ToString()).ToShortDateString());
lv.Items.Add(li);
ctr++;
}
}
}
private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lv.SelectedItems.Count > 0)
{
string cutoff_id = lv.SelectedItems[0].SubItems[1].Text;
Cutoff cd1 = new Cutoff();
cd1.cutoff_id = cutoff_id;
if (MessageBox.Show("Are you sure you want to delete this cutoff?.", "Confirm Delete", MessageBoxButtons.YesNo) == DialogResult.Yes) {
if (cd1.delete())
{
MessageBox.Show("Successful","Delete");
}
else {
MessageBox.Show("Tehere was a problem deleting this cutoff.\n\n Message :" + db.err.Message);
}
}
}
}
}//end select all
public void LoadOnListView(ListView lv)
{
Cutoff s = new Cutoff();
DataTable dt = new DataTable();
dt = s.SELECT_ALL();
if (dt != null)
{
int ctr = 1;
foreach (DataRow r in dt.Rows)
{
ListViewItem li = new ListViewItem();
li.Text = ctr.ToString();
li.SubItems.Add(r["cutoff_id"].ToString());
li.SubItems.Add(Convert.ToDateTime(r["from_date"].ToString()).ToShortDateString());
li.SubItems.Add(Convert.ToDateTime(r["to_date"].ToString()).ToShortDateString());
lv.Items.Add(li);
ctr++;
}
}
}//end load cutoff
public Cutoff SELECT_BY_ID()
{
DataTable dt = new DataTable();
MySqlCommand cmd = new MySqlCommand();
db.SET_COMMAND_PARAMS(cmd, "CUTOFF_SELECT_BYID");
cmd.Parameters.AddWithValue("_cutoff_id", cutoff_id);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
try
{
da.Fill(dt);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
Cutoff c = new Cutoff();
c.from_date = Convert.ToDateTime(dr["from_date"].ToString());
c.to_date = Convert.ToDateTime(dr["to_date"].ToString());
c.cutoff_id = dr["cutoff_id"].ToString();
return c;
}
else {
return null;
}
}
else {
return null;
}
}
catch (Exception e)
{
Logger.WriteErrorLog("CUTOFF_SELECT ALL MODULE : " + e.Message);
return null;
}
}
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);
}
}
private void cutoff_ctrl_Load(object sender, EventArgs e)
{
Cutoff c = new Cutoff();
c.LoadOnListView(lv);
}
