public void setByDefult(timepicker tp, DateTime date)
{
tp.start.Value = date.AddHours(8.5);
tp.end.Value = date.AddHours(18);
tp.otend.Value = date;
tp.otstart.Value = date;
tp.toiladded.Value = date;
tp.toiltaked.Value = date;
tp.isA.Checked = false;
tp.isN.Checked = false;
tp.isM.Checked = false;
tp.isECO.Checked = false;
tp.isDrive.Checked = false;
tp.isSPday.Checked = false;
tp.isStandby.Checked = false;
}
public void saveStatus(timepicker tp, int userId, double oldbalance)
{
LoadData database = new LoadData();
database.runsqlcmd("update comment set " +
"dutystart = CDate('" + tp.start.Value.ToString() +
"') , dutyend = CDate('" + tp.end.Value.ToString() +
"') , otstart = CDate('" + tp.otstart.Value.ToString() +
"') , otend = CDate('" + tp.otend.Value.ToString() +
"') , toiltaked = CDate('" + tp.toiltaked.Value.ToString() +
"') , toiladded = CDate('" + tp.toiladded.Value.ToString() +
"') , isA = " + tp.isA.Checked +
" , isN = " + tp.isN.Checked +
" , isM = " + tp.isM.Checked +
" , isECO = " + tp.isECO.Checked +
" , isDrive = " + tp.isDrive.Checked +
" , isSPday = " + tp.isSPday.Checked +
" , isStandby = " + tp.isStandby.Checked +
" where commentId = " + commentId.ToString());
database.runsqlcmd("update staffstatus set toil_balance = toil_balance +" + (Convert.ToDouble(((tp.toiladded.Value - tp.toiltaked.Value).Hours + "." + Math.Abs(((tp.toiladded.Value - tp.toiltaked.Value).Minutes) * 10 / 60)).ToString()) - oldbalance) + " where userId =" + userId);
}
public void updatestatus(timepicker tp, DateTime date)
{
try
{
LoadData database = new LoadData();
DataTable dt = database.getTable("select * from comment where commentId =" + commentId.ToString() + ";", "comment");
tp.start.Value = Convert.ToDateTime(dt.Rows[0][4]);
tp.end.Value = Convert.ToDateTime(dt.Rows[0][5]);
tp.otend.Value = Convert.ToDateTime(dt.Rows[0][7]);
tp.otstart.Value = Convert.ToDateTime(dt.Rows[0][6]);
tp.toiladded.Value = Convert.ToDateTime(dt.Rows[0][9]);
tp.toiltaked.Value = Convert.ToDateTime(dt.Rows[0][8]);
tp.isA.Checked = Convert.ToBoolean(dt.Rows[0][11]);
tp.isN.Checked = Convert.ToBoolean(dt.Rows[0][12]);
tp.isM.Checked = Convert.ToBoolean(dt.Rows[0][13]);
tp.isECO.Checked = Convert.ToBoolean(dt.Rows[0][14]);
tp.isDrive.Checked = Convert.ToBoolean(dt.Rows[0][15]);
tp.isSPday.Checked = Convert.ToBoolean(dt.Rows[0][16]);
tp.isStandby.Checked = Convert.ToBoolean(dt.Rows[0][17]);
}
catch (Exception ex)
{
tp.start.Value = date.AddHours(8.5);
tp.end.Value = date.AddHours(18);
tp.otend.Value = date;
tp.otstart.Value = date;
tp.toiladded.Value = date;
tp.toiltaked.Value = date;
tp.isA.Checked = false;
tp.isN.Checked = false;
tp.isM.Checked = false;
tp.isECO.Checked = false;
tp.isDrive.Checked = false;
tp.isSPday.Checked = false;
tp.isStandby.Checked = false;
}
}
public MainPage()
{
InitializeComponent();
timepicker tp = new timepicker();
tp.otend = OTenddateTimePicker;
tp.otstart = OTstartdateTimePicker;
tp.start = startdateTimePicker;
tp.end = enddateTimePicker;
tp.toiladded = toiladdeddateTimePicker;
tp.toiltaked = toiltakeddateTimePicker;
tp.isA = isAcheckBox;
tp.isN = isNcheckBox;
tp.isM = isMcheckBox;
tp.isECO = isECOcheckBox;
tp.isDrive = isDrivecheckBox;
tp.otTimes = otTimelabel;
tp.isSPday = isSPdaycheckBox;
tp.isStandby = isStandbycheckBox;
this.tp = tp;
database = new LoadData();
LoginPage lp = new LoginPage(database);
lp.ShowDialog();
if (lp.isclosed())
{
this.Close();
}
userId = lp.getUserId();
Calendar.Rows.Add(Calendar.Rows);
Calendar.Rows.Add(Calendar.Rows);
Calendar.Rows.Add(Calendar.Rows);
Calendar.Rows.Add(Calendar.Rows);
Calendar.Rows.Add(Calendar.Rows);
Calendar.Rows.Add(Calendar.Rows);
Calendar.Rows[0].Height = 40;
Calendar.Rows[1].Height = 40;
Calendar.Rows[2].Height = 40;
Calendar.Rows[3].Height = 40;
Calendar.Rows[4].Height = 40;
Calendar.Rows[5].Height = 40;
Calendar.Rows[0].Cells[0].Selected = false;
foreach (DataGridViewColumn dgvc in Calendar.Columns)
{
dgvc.SortMode = DataGridViewColumnSortMode.NotSortable;
}
foreach (DataGridViewColumn dgvc in historyList.Columns)
{
dgvc.SortMode = DataGridViewColumnSortMode.NotSortable;
}
MonthcomboBox.SelectedItem = MonthcomboBox.Items[DateTime.Now.Month - 1];
this.MonthcomboBox.SelectedIndexChanged += new System.EventHandler(this.MonthcomboBox_SelectedIndexChanged);
for (int i = 2000; i <= DateTime.Now.Year; i++)
{
yearcomboBox.Items.Add(i);
}
yearcomboBox.SelectedItem = DateTime.Now.Year;
initiCalendar calendar = new initiCalendar(Calendar);
calendar.createCalendar(DateTime.Now.Month, DateTime.Now.Year, userId.ToString());
HistoryList history = new HistoryList(userId, historyList);
history.createHistory();
Admin admin = new Admin(namelistView);
admin.createNameList();
this.admin = admin;
this.calendar = calendar;
this.tabControl1.Controls.Remove(this.tabPage2);
this.tabControl1.Controls.Remove(this.tabPage3);
this.tabControl1.Controls.Remove(this.Toilexport);
}
