private void EditToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lv.SelectedItems.Count > 0)
{
pnlops.Controls.Clear();
String dateoftheyear = lv.SelectedItems[0].SubItems[1].Text;
Day_Marker dm = new Day_Marker();
day_marker_update c = new day_marker_update();
// MessageBox.Show(dateoftheyear);
c.dm = dm.SELECT_BY_DATE(dateoftheyear);
c.Width = pnlops.Width;
pnlops.Height = c.Height;
pnlops.Controls.Add(c);
}
else {
MessageBox.Show("Nothing Selected");
}
}
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 btnSubmit_Click(object sender, EventArgs e)
{
if (txtdescription.Text != "" && cbotype.Text != "") {
Day_Marker dm = new Day_Marker();
dm.dateoftheyear = dtdateoftheyear.Value;
dm.type_ = cbotype.Text;
dm.name_of_holiday = txtdescription.Text;
if (dm.save())
{
MessageBox.Show("Successful", "Save");
}
else {
MessageBox.Show("There was a problem saving this holiday.");
}
}
}
public void LoadInListView(ListView lv)
{
Day_Marker a = new Day_Marker();
DataTable dt = new DataTable();
dt = a.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(Convert.ToDateTime(r["dateoftheyear"].ToString()).ToString("MMMM-d"));
li.SubItems.Add(r["name_of_holiday"].ToString());
li.SubItems.Add(r["type_"].ToString());
lv.Items.Add(li);
ctr++;
}
}
}
} //end select all
public void LoadInListView(ListView lv)
{
Day_Marker a = new Day_Marker();
DataTable dt = new DataTable();
dt = a.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(Convert.ToDateTime(r["dateoftheyear"].ToString()).ToString("MMMM-d"));
li.SubItems.Add(r["name_of_holiday"].ToString());
li.SubItems.Add(r["type_"].ToString());
lv.Items.Add(li);
ctr++;
}
}
} //end load in listview
private void DeleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lv.SelectedItems.Count > 0)
{
Day_Marker dm = new Day_Marker();
String dateoftheyear = lv.SelectedItems[0].SubItems[1].Text;
if(MessageBox.Show("Please confirm delete of this item. ","Delete?", MessageBoxButtons.YesNo)== DialogResult.Yes)
{
if(dm.delete(dateoftheyear)){
MessageBox.Show("Successful","Delete");
}else{
MessageBox.Show("There was a problem deleting this item.");
}
}
}
else
{
MessageBox.Show("Nothing Selected");
}
}
}//end select all
public Day_Marker SELECT_BY_DATE(string thisdate)
{
DataTable dt = new DataTable();
MySqlCommand cmd = new MySqlCommand();
db.SET_COMMAND_PARAMS(cmd, "DAY_MARKER_SELECT_BYDATE");
cmd.Parameters.AddWithValue("_dateoftheyear", thisdate);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
try
{
Day_Marker dm = new Day_Marker();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DataRow r = dt.Rows[0];
dm.dateoftheyear = Convert.ToDateTime(r["dateoftheyear"].ToString());
dm.name_of_holiday = r["name_of_holiday"].ToString();
dm.type_ = r["type_"].ToString();
return(dm);
}
else
{
return(null);
}
}
catch (Exception e)
{
Logger.WriteErrorLog("DAY MARKER SELECT_ALL MODULE :" + e.Message);
return(null);
}
} //end select all
public Day_Marker SELECT_BY_DATE(string thisdate)
{
DataTable dt = new DataTable();
MySqlCommand cmd = new MySqlCommand();
db.SET_COMMAND_PARAMS(cmd, "DAY_MARKER_SELECT_BYDATE");
cmd.Parameters.AddWithValue("_dateoftheyear", thisdate);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
try
{
Day_Marker dm = new Day_Marker();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
DataRow r = dt.Rows[0];
dm.dateoftheyear = Convert.ToDateTime(r["dateoftheyear"].ToString());
dm.name_of_holiday = r["name_of_holiday"].ToString();
dm.type_ = r["type_"].ToString();
return dm;
}
else {
return null;
}
}
catch (Exception e)
{
Logger.WriteErrorLog("DAY MARKER SELECT_ALL MODULE :" + e.Message);
return null;
}
}
private void day_marker_ctrl_Load(object sender, EventArgs e)
{
Day_Marker dm = new Day_Marker();
dm.LoadInListView(lv);
}