/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
private void frmSched_Load(object sender, EventArgs e)
{
//load_data();
tlpCrew.AutoScroll = true;
tlpCrew.RowStyles.Clear();
tlpCrew.ColumnStyles.Clear();
tlpCrew.RowCount = 0;
tlpCrew.ColumnCount = 0;
//load_crew_from_row(RefWeek, row);
//load_crew_from_file(RefWeek);
//load_shift();
//load_totals();
DataTable dtToff = dacToff.GetDS().Tables[0];
cbxLegend.DataSource = dtToff;
cbxLegend.ValueMember = "ToffKey";
cbxLegend.DisplayMember = "ToffDesc";
// Kludge : have to fix the auto select problem
cbxLegend.SelectedIndex = -1;
cbxLegend.SelectedIndexChanged += new EventHandler(cbxLegend_SelectedIndexChanged);
//update_timebook();
this.Text = string.Format("Schedule for Weeks [{0} to {1}]",
RefWeek.ToShortDateString(), RefWeek.AddDays(7).ToShortDateString());
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
public frmBoats(DateTime user_day)
{
InitializeComponent();
_nboats = new Boats();
btnPlus.Show();
btnMinus.Show();
flpVessels.Hide();
tlpNote.Name = "tlpNote";
tlpNote.Size = new Size(300, 200);
tlpNote.Location = new Point(200, 200);
tlpNote.BackColor = Color.Yellow;
tlpNote.AutoSize = true;
this.Controls.Add(tlpNote);
this.Tag = tbxBoat;
RefWeek = set_date(user_day);
draw_head(RefWeek.AddDays(7), DateTime.Now, SetAsCurrent, lblWeek2,
tbxMon2, tbxTue2, tbxWed2, tbxThu2, tbxFri2, tbxSat2, tbxSun2);
draw_head(RefWeek, DateTime.Now, SetAsCurrent, lblWeek,
tbxMon, tbxTue, tbxWed, tbxThu, tbxFri, tbxSat, tbxSun);
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
private void frmStaff_Load(object sender, EventArgs e)
{
//load_data();
//tlpCrew.AutoScroll = true;
//tlpCrew.RowStyles.Clear();
//tlpCrew.ColumnStyles.Clear();
//tlpCrew.RowCount = 0;
//tlpCrew.ColumnCount = 0;
//load_crew_from_row(RefWeek, row);
//load_crew_from_file(RefWeek);
//load_shift();
//load_totals();
//update_timebook();
InitLoadReady();
tlpStaff.Show();
// GS180907 - Modify Version using GapLib
//this.Text = string.Format("PayCodes for [{0} to {1}] V1.18.2.0",
this.Text = string.Format("PayCodes for [{0} to {1}] V{2}",
RefWeek.ToShortDateString(), RefWeek.AddDays(7).ToShortDateString(), GAPP.GapLib.AssemblyVersion);
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
private void update_timebook() // shift_version
{
if (RefWeek == null)
{
return;
}
DataSet ds = dacTimebook.GetDS(RefWeek, 14);
foreach (DataRow row in ds.Tables[0].Rows)
{
var bookdate_ = row["Bookdate"];
if (bookdate_ == DBNull.Value)
{
continue;
}
DateTime bookdate = (DateTime)bookdate_;
if (bookdate.Date < RefWeek.Date)
{
continue;
}
if (bookdate.Date >= RefWeek.AddDays(14).Date)
{
continue;
}
//ucStat uc = (ucStat)tlpCrew.GetControlFromPosition(0, 0);
ucStat uc = _crew[row["EmpID"].ToString()];
uc.RefreshDay(bookdate, row["ToffCode"].ToString(),
Convert.ToSingle(row["LogHours"]), Convert.ToSingle(row["LogOver"]),
row["LogVessel"].ToString(), Convert.ToInt32(row["LogShift"]), row["LogNote"].ToString());
}
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
private void frmStaff_Load(object sender, EventArgs e)
{
//load_data();
//tlpCrew.AutoScroll = true;
//tlpCrew.RowStyles.Clear();
//tlpCrew.ColumnStyles.Clear();
//tlpCrew.RowCount = 0;
//tlpCrew.ColumnCount = 0;
//load_crew_from_row(RefWeek, row);
//load_crew_from_file(RefWeek);
//load_shift();
//load_totals();
//update_timebook();
this.Text = string.Format("Salary Hours for [{0} to {1}]",
RefWeek.ToShortDateString(), RefWeek.AddDays(7).ToShortDateString());
}
private void tbxMon_Click(object sender, EventArgs e)
{
DateTime day = RefWeek.AddDays(0);
TableLayoutPanel pnl = (TableLayoutPanel)(this.Parent);
ucAlley uc = (ucAlley)(pnl.Parent);
uc.LogDay = day.Date;
uc.cmdHead_Click();
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
private void frmBoats_Load(object sender, EventArgs e)
{
//load_data();
//load_crew_from_row(RefWeek, row);
//load_crew_from_file(RefWeek);
//load_shift();
//load_totals();
//update_timebook();
this.Text = string.Format("Boats for Weeks [{0} to {1}]",
RefWeek.ToShortDateString(), RefWeek.AddDays(7).ToShortDateString());
}
private void dtpLogDate_ValueChanged(object sender, EventArgs e)
{
DateTime user_day = ((DateTimePicker)sender).Value;
RefWeek = set_date(user_day);
draw_head(RefWeek.AddDays(7), DateTime.Now, SetAsCurrent, lblWeek2,
tbxMon2, tbxTue2, tbxWed2, tbxThu2, tbxFri2, tbxSat2, tbxSun2);
draw_head(RefWeek, DateTime.Now, SetAsCurrent, lblWeek,
tbxMon, tbxTue, tbxWed, tbxThu, tbxFri, tbxSat, tbxSun);
//update_timebook();
this.Text = string.Format("Schedule for Weeks [{0} to {1}]",
RefWeek.ToShortDateString(), RefWeek.AddDays(7).ToShortDateString());
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
public void WeekRefresh(int week_offset, DataTable dt)
{
string emp_id;
emp_id = _emp_id;
RefWeek = RefWeek.AddDays(week_offset * 7);
//_ds = dacTimebook.GetDS(RefWeek, 7);
//dacCache.RefreshTimebook(RefWeek, false);
//_dt = dacCache.GetTimebook();
//_dt = qrySummary.GetView("TimeBook", RefWeek, 7, null, qryGang.GetDT());
_dt = dt;
load_dates(RefWeek, emp_id, dt);
draw_week(RefWeek, DateTime.Now, SetAsCurrent);
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
public frmSched(DateTime user_day)
{
InitializeComponent();
screen_adjustment();
this.chkShow.Checked = true;
this.cmdSave.Visible = false;
_nboats = new Boats();
_crew = new Dictionary <string, ucStat>();
tlpNote.Name = "tlpNote";
tlpNote.Size = new Size(300, 200);
tlpNote.Location = new Point(200, 200);
tlpNote.BackColor = Color.Yellow;
tlpNote.AutoSize = true;
this.Controls.Add(tlpNote);
tlpCrew.AutoScroll = true;
tlpCrew.RowStyles.Clear();
tlpCrew.ColumnStyles.Clear();
tlpCrew.RowCount = 0;
tlpCrew.ColumnCount = 0;
//this.Tag = flpVessels;
this.Tag = tbxBoatH;
RefWeek = set_date(user_day);
//RefWeek = set_date(new DateTime(2014, 01, 01));
draw_head(RefWeek.AddDays(7), DateTime.Now, SetAsCurrent, lblWeek2,
tbxMon2, tbxTue2, tbxWed2, tbxThu2, tbxFri2, tbxSat2, tbxSun2);
draw_head(RefWeek, DateTime.Now, SetAsCurrent, lblWeek,
tbxMon, tbxTue, tbxWed, tbxThu, tbxFri, tbxSat, tbxSun);
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
//public frmStaff(DateTime user_day)
public frmStaff()
{
DateTime user_day = DateTime.Now;
InitializeComponent();
_employee = new Dictionary <string, ucSalary>();
_uc_paycode = new ucPaycodes();
//tlpStaff.Hide();
this.chkShow.Checked = false;
this.cmdSave.Visible = false; // don't use this save button any more
tlpNote.Name = "tlpNote";
tlpNote.Size = new Size(300, 200);
tlpNote.Location = new Point(200, 200);
tlpNote.BackColor = Color.Yellow;
tlpNote.AutoSize = true;
this.Controls.Add(tlpNote);
tlpStaff.AutoScroll = true;
tlpStaff.RowStyles.Clear();
tlpStaff.ColumnStyles.Clear();
tlpStaff.RowCount = 0;
tlpStaff.ColumnCount = 0;
RefWeek = set_date(user_day);
draw_head(RefWeek.AddDays(7), DateTime.Now, SetAsCurrent, lblWeek2,
tbxMon2, tbxTue2, tbxWed2, tbxThu2, tbxFri2, tbxSat2, tbxSun2);
draw_head(RefWeek, DateTime.Now, SetAsCurrent, lblWeek,
tbxMon, tbxTue, tbxWed, tbxThu, tbxFri, tbxSat, tbxSun);
//Application.DoEvents();
}
private void dtpLogDate_CloseUp(object sender, EventArgs e)
{
DateTime user_day = ((DateTimePicker)sender).Value;
RefWeek = set_date(user_day);
DataSet ds = dacTimebook.GetDS(RefWeek, 14);
_dt_crew = ds.Tables[0];
reset_week(RefWeek);
refresh_data(RefWeek, _show_all);
draw_head(RefWeek.AddDays(7), DateTime.Now, SetAsCurrent, lblWeek2,
tbxMon2, tbxTue2, tbxWed2, tbxThu2, tbxFri2, tbxSat2, tbxSun2);
draw_head(RefWeek, DateTime.Now, SetAsCurrent, lblWeek,
tbxMon, tbxTue, tbxWed, tbxThu, tbxFri, tbxSat, tbxSun);
update_timebook(_show_all); // after date change on form
this.Text = string.Format("Schedule for Weeks [{0} to {1}]",
RefWeek.ToShortDateString(), RefWeek.AddDays(7).ToShortDateString());
}
public void WeekRefresh(int week_offset)
{
RefWeek = RefWeek.AddDays(week_offset * 7);
draw_week(RefWeek, DateTime.Now, SetAsCurrent);
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
private void update_timebook(bool show_all)
{
if (RefWeek == null)
{
return;
}
//DataSet ds = dacTimebook.GetDS(RefWeek, 14);
//foreach (DataRow row in ds.Tables[0].Rows)
foreach (DataRow row in _dt_crew.Rows)
{
var bookdate_ = row["Bookdate"];
if (bookdate_ == DBNull.Value)
{
continue;
}
DateTime bookdate = (DateTime)bookdate_;
//if (bookdate.Date < RefWeek.Date) continue;
//if (bookdate.Date >= RefWeek.AddDays(14).Date) continue;
if (bookdate.Date.CompareTo(RefWeek.Date) == -1)
{
continue;
}
if (bookdate.Date.CompareTo(RefWeek.AddDays(14).Date) == 1)
{
continue;
}
//ucStat uc = (ucStat)tlpCrew.GetControlFromPosition(0, 0);
//if (!_crew.ContainsKey(row["EmpId"].ToString()))
// load_crew_from_row(RefWeek, row);
try
{
if (!show_all && !_crew.ContainsKey(row["EmpID"].ToString()))
{
continue;
}
ucSalary uc = _crew[row["EmpID"].ToString()];
string notebug = null; // can't use row["LogNote"].ToString()
if (!DBNull.Value.Equals(row["LogNote"]))
{
notebug = row["LogNote"].ToString();
}
uc.RefWeek = RefWeek;
uc.RefreshDay(bookdate, row["ToffCode"].ToString(),
Convert.ToSingle(row["LogHours"]),
Convert.ToSingle(row["LogOver"]),
row["LogVessel"].ToString(),
Convert.ToInt32(row["LogShift"]), notebug);
}
catch (Exception ex)
{
string msg = string.Format("Error ({0}) : Employee : [{1}:{2}] {3} => TOFF Code [{4}]",
ex.Message,
bookdate,
row["EmpID"].ToString(),
row["EmpName"].ToString(),
row["ToffCode"].ToString());
MessageBox.Show(msg);
}
}
}
/*******************************************************************************************************************\
* *
\*******************************************************************************************************************/
private void update_timebook(bool show_all)
{
if (RefWeek == null)
{
return;
}
//DataSet ds = dacTimebook.GetDS(RefWeek, 14);
//foreach (DataRow row in ds.Tables[0].Rows)
foreach (DataRow row in _dt_tb.Rows)
{
var bookdate_ = row["Bookdate"];
if (bookdate_ == DBNull.Value)
{
continue;
}
DateTime bookdate = (DateTime)bookdate_;
//if (bookdate.Date < RefWeek.Date) continue;
//if (bookdate.Date >= RefWeek.AddDays(14).Date) continue;
if (bookdate.Date.CompareTo(RefWeek.Date) == -1)
{
continue;
}
if (bookdate.Date.CompareTo(RefWeek.AddDays(14).Date) == 1)
{
continue;
}
//ucStat uc = (ucStat)tlpCrew.GetControlFromPosition(0, 0);
//if (!_crew.ContainsKey(row["EmpId"].ToString()))
// load_crew_from_row(RefWeek, row);
try
{
//if (row["EmpID"].Equals("FS0623")) MessageBox.Show("A");
if (!show_all && !_employee.ContainsKey(row["EmpID"].ToString()))
{
continue;
}
// GS180907 - Debug Stop
//string eid = row["EmpID"].ToString();
//if (eid.Equals("K1")) MessageBox.Show("Here");
ucSalary uc = _employee[row["EmpID"].ToString()];
string notebug = null; // can't use row["LogNote"].ToString()
if (!row["LogNote"].Equals(DBNull.Value))
{
notebug = row["LogNote"].ToString();
}
Decimal over1 = 0.0M;
if (!row["LogOver1"].Equals(DBNull.Value))
{
over1 = (Decimal)row["LogOver1"];
}
// GS180907 - Handle Incomplete Employee Data
if (row["DefPayCode"].Equals(DBNull.Value))
{
string msg = string.Format("{0} : Employee : [{1}:{2}] {3}",
"WARNING - This employee is not properly setup. The DefPayCode is not valid",
row["EmpID"].ToString(),
row["EmpName"].ToString(),
bookdate
);
MessageBox.Show(msg, System.Reflection.MethodBase.GetCurrentMethod().ToString());
continue;
}
string paycode = (string)row["DefPayCode"];
if (!row["PayCode"].Equals(DBNull.Value))
{
paycode = (string)row["PayCode"];
}
string toff = string.Empty;
if (!row["ToffCode"].Equals(DBNull.Value))
{
toff = (string)row["ToffCode"];
}
string boat = string.Empty;
if (!row["LogVessel"].Equals(DBNull.Value))
{
boat = (string)row["LogVessel"];
}
uc.RefWeek = RefWeek;
uc.RefreshDay(bookdate, toff,
Convert.ToDecimal(row["LogHours"]),
Convert.ToDecimal(row["LogOver"]),
over1,
boat,
Convert.ToInt32(row["LogShift"]), notebug, paycode);
}
catch (Exception ex)
{
string msg = string.Format("Error ({0}) : Employee : [{1}:{2}] {3} => TOFF Code [{4}]",
ex.Message,
row["EmpID"].ToString(),
row["EmpName"].ToString(),
bookdate,
row["ToffCode"].ToString());
MessageBox.Show(msg, System.Reflection.MethodBase.GetCurrentMethod().ToString());
}
}
}
