public void init(bool isShowStaffInfo, string year, string weekNo) { DataSet _ds; this.SuspendLayout(); int y=-1; foreach ( DataRow dr in dtRoster.Rows ) { int i = Convert.ToInt32( dr["week_day"].ToString() ); this.txtSunDate.Text = Convert.ToDateTime( dr["today"].ToString() ).AddDays(8-i).ToString("dd-MM-yyyy"); this.txtMonDate.Text = Convert.ToDateTime( dr["today"].ToString() ).AddDays(2-i).ToString("dd-MM-yyyy"); this.txtTueDate.Text = Convert.ToDateTime( dr["today"].ToString() ).AddDays(3-i).ToString("dd-MM-yyyy"); this.txtWedDate.Text = Convert.ToDateTime( dr["today"].ToString() ).AddDays(4-i).ToString("dd-MM-yyyy"); this.txtThuDate.Text = Convert.ToDateTime( dr["today"].ToString() ).AddDays(5-i).ToString("dd-MM-yyyy"); this.txtFriDate.Text = Convert.ToDateTime( dr["today"].ToString() ).AddDays(6-i).ToString("dd-MM-yyyy"); this.txtSatDate.Text = Convert.ToDateTime( dr["today"].ToString() ).AddDays(7-i).ToString("dd-MM-yyyy"); dateSun = Convert.ToDateTime(dr["today"]).AddDays(8-i); dateMon = Convert.ToDateTime(dr["today"]).AddDays(2-i); dateTue = Convert.ToDateTime(dr["today"]).AddDays(3-i); dateWed = Convert.ToDateTime(dr["today"]).AddDays(4-i); dateThu = Convert.ToDateTime(dr["today"]).AddDays(5-i); dateFri = Convert.ToDateTime(dr["today"]).AddDays(6-i); dateSat = Convert.ToDateTime(dr["today"]).AddDays(7-i); } panelRosterDetails.DataBindings.Clear(); panelRosterDetails.Controls.Remove(ACMSRosterDetails1); panelRosterDetails.Controls.Clear(); foreach ( DataRow dr1 in dtRosterDetail.Rows ) { this.ACMSRosterDetails1 = new ACMSRosterDetails(); this.ACMSRosterDetails1.Location = new System.Drawing.Point(0, y); this.ACMSRosterDetails1.Name = "ACMSRosterDetails1"; this.ACMSRosterDetails1.Size = new System.Drawing.Size(792, 54); this.ACMSRosterDetails1.TabIndex = 0; this.ACMSRosterDetails1.Click += new System.EventHandler(this._Click); y = y+55; this.ACMSRosterDetails1.year = dr1["rYear"].ToString(); this.ACMSRosterDetails1.WeekNo = dr1["Week_No"].ToString(); this.ACMSRosterDetails1.lblEmpID.Text = dr1["nEmployeeID"].ToString(); this.ACMSRosterDetails1.lblJob.Text = "(" + dr1["strJobPositionCode"].ToString() + ")"; this.ACMSRosterDetails1.lblEmpName.Text = dr1["strEmployeeName"].ToString(); this.ACMSRosterDetails1.lblEmpDept.Text = "DEPT :" + dr1["DepartmentName"].ToString().ToUpper(); this.ACMSRosterDetails1.SunTime.Text = ConvertToTime(dr1["sunStartTime"]) + " " + ConvertToTime(dr1["sunEndTime"]); this.ACMSRosterDetails1.MonTime.Text = ConvertToTime(dr1["monStartTime"]) + " " + ConvertToTime(dr1["monEndTime"]); this.ACMSRosterDetails1.TueTime.Text = ConvertToTime(dr1["tueStartTime"]) + " " + ConvertToTime(dr1["tueEndTime"]) ; this.ACMSRosterDetails1.WedTime.Text = ConvertToTime(dr1["wedStartTime"]) + " " + ConvertToTime(dr1["wedEndTime"]); this.ACMSRosterDetails1.ThuTime.Text = ConvertToTime(dr1["thuStartTime"]) + " " + ConvertToTime(dr1["thuEndTime"]); this.ACMSRosterDetails1.FriTime.Text = ConvertToTime(dr1["friStartTime"]) + " " + ConvertToTime(dr1["friEndTime"]); this.ACMSRosterDetails1.SatTime.Text = ConvertToTime(dr1["satStartTime"]) + " " + ConvertToTime(dr1["satEndTime"]); this.ACMSRosterDetails1.TotalHourWrk.Text = dr1["totalHour"].ToString(); this.ACMSRosterDetails1.panelStaffInfo.Visible = isShowStaffInfo; this.panelRosterDetails.Controls.Add(ACMSRosterDetails1); // To Set Grey Color for Multi Shift Roster // Monday _ds = new DataSet(); string strSQL="select nRosterID from tblRoster where dtDate='" + dateMon.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) ); if (_ds.Tables[0].Rows.Count>1) { ACMSRosterDetails1.panelMON.BackColor = Color.Gray; } // Tuesday _ds = new DataSet(); strSQL="select nRosterID from tblRoster where dtDate='" + dateTue.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) ); if (_ds.Tables[0].Rows.Count>1) { ACMSRosterDetails1.panelTUE.BackColor = Color.Gray; } // Wednersday _ds = new DataSet(); strSQL="select nRosterID from tblRoster where dtDate='" + dateWed.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) ); if (_ds.Tables[0].Rows.Count>1) { ACMSRosterDetails1.panelWED.BackColor = Color.Gray; } // Thursday _ds = new DataSet(); strSQL="select nRosterID from tblRoster where dtDate='" + dateThu.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) ); if (_ds.Tables[0].Rows.Count>1) { ACMSRosterDetails1.panelTHU.BackColor = Color.Gray; } // Friday _ds = new DataSet(); strSQL="select nRosterID from tblRoster where dtDate='" + dateFri.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) ); if (_ds.Tables[0].Rows.Count>1) { ACMSRosterDetails1.panelFRI.BackColor = Color.Gray; } // Saturday _ds = new DataSet(); strSQL="select nRosterID from tblRoster where dtDate='" + dateSat.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) ); if (_ds.Tables[0].Rows.Count>1) { ACMSRosterDetails1.panelSAT.BackColor = Color.Gray; } // Sunday _ds = new DataSet(); strSQL="select nRosterID from tblRoster where dtDate='" + dateSun.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) ); if (_ds.Tables[0].Rows.Count>1) { ACMSRosterDetails1.panelSUN.BackColor = Color.Gray; } // To Display Leave Color on Roster if ( IsShowLeave ) { DateTime startDate, endDate; startDate=dateMon; endDate = dateSun; _ds = new DataSet(); SqlHelper.FillDataset(SqlHelperUtils.connectionString,CommandType.StoredProcedure,"pr_SelectLeave",_ds,new string[] {"table"}, new SqlParameter("@ddtStartDate", startDate), new SqlParameter("@ddtEndDate", endDate), new SqlParameter("@inEmployeeID", Convert.ToInt32(dr1["nEmployeeID"])) ); dtLeaveDetails = _ds.Tables[0]; foreach(DataRow row in dtLeaveDetails.Rows) { SetLeaveColor(row); } } } if (dtRosterDetail.Rows.Count == 0) { this.ACMSRosterDetails1 = new ACMSRosterDetails(); this.ACMSRosterDetails1.Location = new System.Drawing.Point(0, y); this.ACMSRosterDetails1.Name = "ACMSRosterDetails1"; this.ACMSRosterDetails1.Size = new System.Drawing.Size(792, 54); this.ACMSRosterDetails1.TabIndex = 0; this.ACMSRosterDetails1.Click += new System.EventHandler(this._Click); y = y+55; this.ACMSRosterDetails1.year = year; this.ACMSRosterDetails1.WeekNo = weekNo; this.ACMSRosterDetails1.lblEmpID.Text = string.Empty; this.ACMSRosterDetails1.lblEmpName.Text = string.Empty; this.ACMSRosterDetails1.lblEmpDept.Text = string.Empty; this.ACMSRosterDetails1.SunTime.Text =string.Empty; this.ACMSRosterDetails1.MonTime.Text = string.Empty; this.ACMSRosterDetails1.TueTime.Text = string.Empty; this.ACMSRosterDetails1.WedTime.Text = string.Empty; this.ACMSRosterDetails1.ThuTime.Text = string.Empty; this.ACMSRosterDetails1.FriTime.Text = string.Empty; this.ACMSRosterDetails1.SatTime.Text = string.Empty; this.ACMSRosterDetails1.TotalHourWrk.Text = string.Empty; this.ACMSRosterDetails1.panelStaffInfo.Visible = false; this.panelRosterDetails.Controls.Add(this.ACMSRosterDetails1); } this.ResumeLayout(); }
public void init(bool isShowStaffInfo, string year, string weekNo) { DataSet _ds; this.SuspendLayout(); int y = -1; foreach (DataRow dr in dtRoster.Rows) { int i = Convert.ToInt32(dr["week_day"].ToString()); this.txtSunDate.Text = Convert.ToDateTime(dr["today"].ToString()).AddDays(8 - i).ToString("dd-MM-yyyy"); this.txtMonDate.Text = Convert.ToDateTime(dr["today"].ToString()).AddDays(2 - i).ToString("dd-MM-yyyy"); this.txtTueDate.Text = Convert.ToDateTime(dr["today"].ToString()).AddDays(3 - i).ToString("dd-MM-yyyy"); this.txtWedDate.Text = Convert.ToDateTime(dr["today"].ToString()).AddDays(4 - i).ToString("dd-MM-yyyy"); this.txtThuDate.Text = Convert.ToDateTime(dr["today"].ToString()).AddDays(5 - i).ToString("dd-MM-yyyy"); this.txtFriDate.Text = Convert.ToDateTime(dr["today"].ToString()).AddDays(6 - i).ToString("dd-MM-yyyy"); this.txtSatDate.Text = Convert.ToDateTime(dr["today"].ToString()).AddDays(7 - i).ToString("dd-MM-yyyy"); dateSun = Convert.ToDateTime(dr["today"]).AddDays(8 - i); dateMon = Convert.ToDateTime(dr["today"]).AddDays(2 - i); dateTue = Convert.ToDateTime(dr["today"]).AddDays(3 - i); dateWed = Convert.ToDateTime(dr["today"]).AddDays(4 - i); dateThu = Convert.ToDateTime(dr["today"]).AddDays(5 - i); dateFri = Convert.ToDateTime(dr["today"]).AddDays(6 - i); dateSat = Convert.ToDateTime(dr["today"]).AddDays(7 - i); } panelRosterDetails.DataBindings.Clear(); panelRosterDetails.Controls.Remove(ACMSRosterDetails1); panelRosterDetails.Controls.Clear(); foreach (DataRow dr1 in dtRosterDetail.Rows) { this.ACMSRosterDetails1 = new ACMSRosterDetails(); this.ACMSRosterDetails1.Location = new System.Drawing.Point(0, y); this.ACMSRosterDetails1.Name = "ACMSRosterDetails1"; this.ACMSRosterDetails1.Size = new System.Drawing.Size(792, 54); this.ACMSRosterDetails1.TabIndex = 0; this.ACMSRosterDetails1.Click += new System.EventHandler(this._Click); y = y + 55; this.ACMSRosterDetails1.year = dr1["rYear"].ToString(); this.ACMSRosterDetails1.WeekNo = dr1["Week_No"].ToString(); this.ACMSRosterDetails1.lblEmpID.Text = dr1["nEmployeeID"].ToString(); this.ACMSRosterDetails1.lblJob.Text = "(" + dr1["strJobPositionCode"].ToString() + ")"; this.ACMSRosterDetails1.lblEmpName.Text = dr1["strEmployeeName"].ToString(); this.ACMSRosterDetails1.lblEmpDept.Text = "DEPT :" + dr1["DepartmentName"].ToString().ToUpper(); this.ACMSRosterDetails1.SunTime.Text = ConvertToTime(dr1["sunStartTime"]) + " " + ConvertToTime(dr1["sunEndTime"]); this.ACMSRosterDetails1.MonTime.Text = ConvertToTime(dr1["monStartTime"]) + " " + ConvertToTime(dr1["monEndTime"]); this.ACMSRosterDetails1.TueTime.Text = ConvertToTime(dr1["tueStartTime"]) + " " + ConvertToTime(dr1["tueEndTime"]); this.ACMSRosterDetails1.WedTime.Text = ConvertToTime(dr1["wedStartTime"]) + " " + ConvertToTime(dr1["wedEndTime"]); this.ACMSRosterDetails1.ThuTime.Text = ConvertToTime(dr1["thuStartTime"]) + " " + ConvertToTime(dr1["thuEndTime"]); this.ACMSRosterDetails1.FriTime.Text = ConvertToTime(dr1["friStartTime"]) + " " + ConvertToTime(dr1["friEndTime"]); this.ACMSRosterDetails1.SatTime.Text = ConvertToTime(dr1["satStartTime"]) + " " + ConvertToTime(dr1["satEndTime"]); this.ACMSRosterDetails1.TotalHourWrk.Text = dr1["totalHour"].ToString(); this.ACMSRosterDetails1.panelStaffInfo.Visible = isShowStaffInfo; this.panelRosterDetails.Controls.Add(ACMSRosterDetails1); // To Set Grey Color for Multi Shift Roster // Monday _ds = new DataSet(); string strSQL = "select nRosterID from tblRoster where dtDate='" + dateMon.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL)); if (_ds.Tables[0].Rows.Count > 1) { ACMSRosterDetails1.panelMON.BackColor = Color.Gray; } // Tuesday _ds = new DataSet(); strSQL = "select nRosterID from tblRoster where dtDate='" + dateTue.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL)); if (_ds.Tables[0].Rows.Count > 1) { ACMSRosterDetails1.panelTUE.BackColor = Color.Gray; } // Wednersday _ds = new DataSet(); strSQL = "select nRosterID from tblRoster where dtDate='" + dateWed.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL)); if (_ds.Tables[0].Rows.Count > 1) { ACMSRosterDetails1.panelWED.BackColor = Color.Gray; } // Thursday _ds = new DataSet(); strSQL = "select nRosterID from tblRoster where dtDate='" + dateThu.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL)); if (_ds.Tables[0].Rows.Count > 1) { ACMSRosterDetails1.panelTHU.BackColor = Color.Gray; } // Friday _ds = new DataSet(); strSQL = "select nRosterID from tblRoster where dtDate='" + dateFri.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL)); if (_ds.Tables[0].Rows.Count > 1) { ACMSRosterDetails1.panelFRI.BackColor = Color.Gray; } // Saturday _ds = new DataSet(); strSQL = "select nRosterID from tblRoster where dtDate='" + dateSat.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL)); if (_ds.Tables[0].Rows.Count > 1) { ACMSRosterDetails1.panelSAT.BackColor = Color.Gray; } // Sunday _ds = new DataSet(); strSQL = "select nRosterID from tblRoster where dtDate='" + dateSun.ToString("yyyy-MM-dd") + "' and nEmployeeID=" + Convert.ToInt32(dr1["nEmployeeID"]); SqlHelper.FillDataset(SqlHelperUtils.connectionString, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL)); if (_ds.Tables[0].Rows.Count > 1) { ACMSRosterDetails1.panelSUN.BackColor = Color.Gray; } // To Display Leave Color on Roster if (IsShowLeave) { DateTime startDate, endDate; startDate = dateMon; endDate = dateSun; _ds = new DataSet(); SqlHelper.FillDataset(SqlHelperUtils.connectionString, CommandType.StoredProcedure, "pr_SelectLeave", _ds, new string[] { "table" }, new SqlParameter("@ddtStartDate", startDate), new SqlParameter("@ddtEndDate", endDate), new SqlParameter("@inEmployeeID", Convert.ToInt32(dr1["nEmployeeID"])) ); dtLeaveDetails = _ds.Tables[0]; foreach (DataRow row in dtLeaveDetails.Rows) { SetLeaveColor(row); } } } if (dtRosterDetail.Rows.Count == 0) { this.ACMSRosterDetails1 = new ACMSRosterDetails(); this.ACMSRosterDetails1.Location = new System.Drawing.Point(0, y); this.ACMSRosterDetails1.Name = "ACMSRosterDetails1"; this.ACMSRosterDetails1.Size = new System.Drawing.Size(792, 54); this.ACMSRosterDetails1.TabIndex = 0; this.ACMSRosterDetails1.Click += new System.EventHandler(this._Click); y = y + 55; this.ACMSRosterDetails1.year = year; this.ACMSRosterDetails1.WeekNo = weekNo; this.ACMSRosterDetails1.lblEmpID.Text = string.Empty; this.ACMSRosterDetails1.lblEmpName.Text = string.Empty; this.ACMSRosterDetails1.lblEmpDept.Text = string.Empty; this.ACMSRosterDetails1.SunTime.Text = string.Empty; this.ACMSRosterDetails1.MonTime.Text = string.Empty; this.ACMSRosterDetails1.TueTime.Text = string.Empty; this.ACMSRosterDetails1.WedTime.Text = string.Empty; this.ACMSRosterDetails1.ThuTime.Text = string.Empty; this.ACMSRosterDetails1.FriTime.Text = string.Empty; this.ACMSRosterDetails1.SatTime.Text = string.Empty; this.ACMSRosterDetails1.TotalHourWrk.Text = string.Empty; this.ACMSRosterDetails1.panelStaffInfo.Visible = false; this.panelRosterDetails.Controls.Add(this.ACMSRosterDetails1); } this.ResumeLayout(); }