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