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