public static HR_WorkingDaysShifting GetHR_WorkingDaysShiftingObjectByEmployeeID(string EmployeeID) { HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDaysShifting = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingObjectByEmployeeID(EmployeeID); return hR_WorkingDaysShifting; }
protected void btnUpdate_Click(object sender, EventArgs e) { string txtStartHour = this.ddltime_hoursStart.SelectedValue.ToString(); string txtStartMin = this.ddltime_minstart.SelectedValue.ToString(); string txtStartTime = DateTime.Now.ToShortDateString() + " " + txtStartHour + " : " + txtStartMin + ": 00"; DateTime dtStartTime = Convert.ToDateTime(txtStartTime); string txtEndHour = this.ddltime_hoursEnd.SelectedValue.ToString(); string txtEndMin = this.ddltime_minEnd.SelectedValue.ToString(); string txtEndTime = DateTime.Now.ToShortDateString() + " " + txtEndHour + " : " + txtEndMin + ": 00"; DateTime dtEndTime = Convert.ToDateTime(txtEndTime); HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting(); hR_WorkingDaysShifting.WorkingDaysID = int.Parse(Request.QueryString["ID"].ToString()); hR_WorkingDaysShifting.EmployeeID = Profile.card_id; hR_WorkingDaysShifting.Saturday = chkSaturday.Checked == true ? true : false; hR_WorkingDaysShifting.Sunday = chkSunday.Checked == true ? true : false; hR_WorkingDaysShifting.Monday = chkMonday.Checked == true ? true : false; hR_WorkingDaysShifting.Tuesday = chkTuesday.Checked == true ? true : false; hR_WorkingDaysShifting.Wednesday = chkWednesday.Checked == true ? true : false; hR_WorkingDaysShifting.Thrusday = chkThrusday.Checked == true ? true : false; //hR_WorkingDaysShifting.ShiftStartTime= DateTime.Parse(txtShiftStartTime.Text); //hR_WorkingDaysShifting.ShiftEndTime= DateTime.Parse(txtShiftEndTime.Text); hR_WorkingDaysShifting.ShiftStartTime = dtStartTime; hR_WorkingDaysShifting.ShiftEndTime = dtEndTime; hR_WorkingDaysShifting.Description = txtDescription.Text; hR_WorkingDaysShifting.AddedBy = Profile.card_id; hR_WorkingDaysShifting.AddedDate = DateTime.Now; hR_WorkingDaysShifting.ModifiedBy = Profile.card_id; hR_WorkingDaysShifting.ModifiedDate = DateTime.Now; bool resutl = HR_WorkingDaysShiftingManager.UpdateHR_WorkingDaysShifting(hR_WorkingDaysShifting); Response.Redirect("AdminDisplayHR_WorkingDaysShifting.aspx"); }
public static HR_WorkingDaysShifting GetHR_WorkingDaysShiftingByWorkingDaysID(int WorkingDaysID) { HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDaysShifting = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingByWorkingDaysID(WorkingDaysID); return hR_WorkingDaysShifting; }
/// <summary> /// //////////////// /// </summary> /// <param name="EmployeeID"></param> /// <returns></returns> public static DataTable GetHR_WorkingDaysShiftingTableByEmployeeID(string EmployeeID) { HR_WorkingDaysShifting hR_WorkingDayShift = new HR_WorkingDaysShifting(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDayShift = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingObjectByEmployeeID(EmployeeID); //HR_WorkingDaysShifting hR_WorkingDayShift = HR_WorkingDaysShiftingManager.GetHR_WorkingDaysShiftingObjectByEmployeeID("96b72550-3649-45c6-a1f5-0474a77f4fa6"); DataTable workDayShift = new DataTable(); workDayShift.Columns.Add("Days", Type.GetType("System.String")); workDayShift.Columns.Add("StartTime", Type.GetType("System.String")); workDayShift.Columns.Add("EndTime", Type.GetType("System.String")); string startTimeHour = hR_WorkingDayShift.ShiftStartTime.Hour.ToString(); string startAMPM = "AM"; if (int.Parse(startTimeHour) > 12) { startTimeHour = (int.Parse(startTimeHour) - 12).ToString(); startAMPM = "PM"; } else if (int.Parse(startTimeHour) == 12) { startAMPM = "PM"; } string startTimeMinute = hR_WorkingDayShift.ShiftStartTime.Minute.ToString(); string startHourMinute = startTimeHour.Length == 1 ? "0" + startTimeHour : startTimeHour; startHourMinute += " : "; startHourMinute += startTimeMinute.Length == 1 ? "0" + startTimeMinute : startTimeMinute; startHourMinute += " "+startAMPM; string endTimeHour = hR_WorkingDayShift.ShiftEndTime.Hour.ToString(); string endAMPM = "AM"; if (int.Parse(endTimeHour) > 12) { endTimeHour = (int.Parse(endTimeHour) - 12).ToString(); endAMPM = "PM"; } else if (int.Parse(endTimeHour) == 12) { endAMPM = "PM"; } string endTimeMinute = hR_WorkingDayShift.ShiftEndTime.Minute.ToString(); string endHourMinute = endTimeHour.Length == 1 ? "0" + endTimeHour : endTimeHour; endHourMinute += " : "; endHourMinute += endTimeMinute.Length == 1 ? "0" + endTimeMinute : endTimeMinute; endHourMinute += " " + endAMPM; if (hR_WorkingDayShift.Saturday) { DataRow row = workDayShift.NewRow(); row["Days"] = "Saturday"; row["StartTime"] = startHourMinute; row["EndTime"] = endHourMinute; workDayShift.Rows.Add(row); } if (hR_WorkingDayShift.Sunday) { DataRow row = workDayShift.NewRow(); row["Days"] = "Sunday"; row["StartTime"] = startHourMinute; row["EndTime"] = endHourMinute; workDayShift.Rows.Add(row); } if (hR_WorkingDayShift.Monday) { DataRow row = workDayShift.NewRow(); row["Days"] = "Monday"; row["StartTime"] = startHourMinute; row["EndTime"] = endHourMinute; workDayShift.Rows.Add(row); } if (hR_WorkingDayShift.Tuesday) { DataRow row = workDayShift.NewRow(); row["Days"] = "Tuesday"; row["StartTime"] = startHourMinute; row["EndTime"] = endHourMinute; workDayShift.Rows.Add(row); } if (hR_WorkingDayShift.Wednesday) { DataRow row = workDayShift.NewRow(); row["Days"] = "Wednesday"; row["StartTime"] = startHourMinute; row["EndTime"] = endHourMinute; workDayShift.Rows.Add(row); } if (hR_WorkingDayShift.Thrusday) { DataRow row = workDayShift.NewRow(); row["Days"] = "Thrusday"; row["StartTime"] = startHourMinute; row["EndTime"] = endHourMinute; workDayShift.Rows.Add(row); } if (hR_WorkingDayShift.Friday) { DataRow row = workDayShift.NewRow(); row["Days"] = "Friday"; row["StartTime"] = startHourMinute; row["EndTime"] = endHourMinute; workDayShift.Rows.Add(row); } return workDayShift; }
public static bool UpdateHR_WorkingDaysShifting(HR_WorkingDaysShifting hR_WorkingDaysShifting) { SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); return sqlHR_WorkingDaysShiftingProvider.UpdateHR_WorkingDaysShifting(hR_WorkingDaysShifting); }
public static int InsertHR_WorkingDaysShifting(HR_WorkingDaysShifting hR_WorkingDaysShifting) { SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); return sqlHR_WorkingDaysShiftingProvider.InsertHR_WorkingDaysShifting(hR_WorkingDaysShifting); }
protected void btnAddWorkingDaysShifting_Click(object sender, EventArgs e) { if (hfEmployeeID.Value != null) { string txtStartHour = this.ddltime_hoursStart.SelectedValue.ToString(); string txtStartMin = this.ddltime_minstart.SelectedValue.ToString(); string txtStartTime = DateTime.Now.ToShortDateString() + " " + txtStartHour + " : " + txtStartMin + ": 00"; DateTime dtStartTime = Convert.ToDateTime(txtStartTime); string txtEndHour = this.ddltime_hoursEnd.SelectedValue.ToString(); string txtEndMin = this.ddltime_minEnd.SelectedValue.ToString(); string txtEndTime = DateTime.Now.ToShortDateString() + " " + txtEndHour + " : " + txtEndMin + ": 00"; DateTime dtEndTime = Convert.ToDateTime(txtEndTime); HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting(); hR_WorkingDaysShifting.EmployeeID = hfEmployeeID.Value.ToString(); hR_WorkingDaysShifting.Saturday = chkSaturday.Checked == true ? true : false; hR_WorkingDaysShifting.Sunday = chkSunday.Checked == true ? true : false; hR_WorkingDaysShifting.Monday = chkMonday.Checked == true ? true : false; hR_WorkingDaysShifting.Tuesday = chkTuesday.Checked == true ? true : false; hR_WorkingDaysShifting.Wednesday = chkWednesday.Checked == true ? true : false; hR_WorkingDaysShifting.Thrusday = chkThrusday.Checked == true ? true : false; hR_WorkingDaysShifting.Friday = chkFriday.Checked == true ? true : false; hR_WorkingDaysShifting.ShiftStartTime = dtStartTime; hR_WorkingDaysShifting.ShiftEndTime = dtEndTime; hR_WorkingDaysShifting.Description = txtDescription.Text; string userID = Profile.card_id; hR_WorkingDaysShifting.AddedBy = userID; hR_WorkingDaysShifting.AddedDate = DateTime.Now; hR_WorkingDaysShifting.ModifiedBy = userID; hR_WorkingDaysShifting.ModifiedDate = DateTime.Now; int resutl = HR_WorkingDaysShiftingManager.InsertHR_WorkingDaysShifting(hR_WorkingDaysShifting); hdnWorkingDaysShiftingID.Value = resutl.ToString(); lblDaysShiftingMessage.Text = "Working Shift Information is saved"; lblDaysShiftingMessage.ForeColor = System.Drawing.Color.Green; } else { lblDaysShiftingMessage.Text = "Employee is not specified."; lblDaysShiftingMessage.ForeColor = System.Drawing.Color.Red; } }
private void RefreshWorkingDaysShifting() { HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting(); hR_WorkingDaysShifting = HR_WorkingDaysShiftingManager.GetHR_WorkingDaysShiftingObjectByEmployeeID(hfEmployeeID.Value.ToString()); if (hR_WorkingDaysShifting != null) { hdnWorkingDaysShiftingID.Value = hR_WorkingDaysShifting.WorkingDaysID.ToString(); chkSaturday.Checked = hR_WorkingDaysShifting.Saturday; chkSunday.Checked = hR_WorkingDaysShifting.Sunday; chkMonday.Checked = hR_WorkingDaysShifting.Monday; chkTuesday.Checked = hR_WorkingDaysShifting.Tuesday; chkWednesday.Checked = hR_WorkingDaysShifting.Wednesday; chkThrusday.Checked = hR_WorkingDaysShifting.Thrusday; chkFriday.Checked = hR_WorkingDaysShifting.Friday; string startingHour = hR_WorkingDaysShifting.ShiftStartTime.Hour.ToString(); ddltime_hoursStart.SelectedValue = startingHour.Length == 1 ? "0" + startingHour : startingHour; string startingMinute = hR_WorkingDaysShifting.ShiftStartTime.Minute.ToString(); ddltime_minstart.SelectedValue = startingMinute.Length == 1 ? "0" + startingMinute : startingMinute; string endingHour = hR_WorkingDaysShifting.ShiftEndTime.Hour.ToString(); ddltime_hoursEnd.SelectedValue = endingHour.Length == 1 ? "0" + endingHour : endingHour; string endingMinute = hR_WorkingDaysShifting.ShiftEndTime.Minute.ToString(); ddltime_minEnd.SelectedValue = endingMinute.Length == 1 ? "0" + endingMinute : endingMinute; txtDescription.Text = hR_WorkingDaysShifting.Description; } }
private void showHR_WorkingDaysShiftingData() { string txtStartHour = this.ddltime_hoursStart.SelectedValue.ToString(); string txtStartMin = this.ddltime_minstart.SelectedValue.ToString(); string txtStartTime = DateTime.Now.ToShortDateString() + " " + txtStartHour + " : " + txtStartMin + ": 00"; DateTime dtStartTime = Convert.ToDateTime(txtStartTime); string txtEndHour = this.ddltime_hoursEnd.SelectedValue.ToString(); string txtEndMin = this.ddltime_minEnd.SelectedValue.ToString(); string txtEndTime = DateTime.Now.ToShortDateString() + " " + txtEndHour + " : " + txtEndMin + ": 00"; DateTime dtEndTime = Convert.ToDateTime(txtEndTime); HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting(); hR_WorkingDaysShifting = HR_WorkingDaysShiftingManager.GetHR_WorkingDaysShiftingByWorkingDaysID(Int32.Parse(Request.QueryString["ID"])); chkSaturday.Checked = hR_WorkingDaysShifting.Saturday; chkSunday.Checked = hR_WorkingDaysShifting.Sunday; chkMonday.Checked = hR_WorkingDaysShifting.Monday; chkTuesday.Checked = hR_WorkingDaysShifting.Tuesday; chkWednesday.Checked = hR_WorkingDaysShifting.Wednesday; chkThrusday.Checked = hR_WorkingDaysShifting.Thrusday; //txtShiftStartTime.Text =hR_WorkingDaysShifting.ShiftStartTime.ToString(); //txtShiftEndTime.Text =hR_WorkingDaysShifting.ShiftEndTime.ToString(); hR_WorkingDaysShifting.ShiftStartTime = dtStartTime; hR_WorkingDaysShifting.ShiftEndTime = dtEndTime; txtDescription.Text = hR_WorkingDaysShifting.Description.ToString(); }
public bool UpdateHR_WorkingDaysShifting(HR_WorkingDaysShifting hR_WorkingDaysShifting) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("UpdateHR_WorkingDaysShifting", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@WorkingDaysID", SqlDbType.Int).Value = hR_WorkingDaysShifting.WorkingDaysID; cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = hR_WorkingDaysShifting.EmployeeID; cmd.Parameters.Add("@Saturday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Saturday; cmd.Parameters.Add("@Sunday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Sunday; cmd.Parameters.Add("@Monday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Monday; cmd.Parameters.Add("@Tuesday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Tuesday; cmd.Parameters.Add("@Wednesday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Wednesday; cmd.Parameters.Add("@Thrusday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Thrusday; cmd.Parameters.Add("@Friday", SqlDbType.Bit).Value = hR_WorkingDaysShifting.Thrusday; cmd.Parameters.Add("@ShiftStartTime", SqlDbType.DateTime).Value = hR_WorkingDaysShifting.ShiftStartTime; cmd.Parameters.Add("@ShiftEndTime", SqlDbType.DateTime).Value = hR_WorkingDaysShifting.ShiftEndTime; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = hR_WorkingDaysShifting.Description; cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar).Value = hR_WorkingDaysShifting.ModifiedBy; cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = hR_WorkingDaysShifting.ModifiedDate; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public HR_WorkingDaysShifting GetHR_WorkingDaysShiftingFromReader(IDataReader reader) { try { HR_WorkingDaysShifting hR_WorkingDaysShifting = new HR_WorkingDaysShifting ( DataAccessObject.IsNULL<int>(reader["WorkingDaysID"]), DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()), DataAccessObject.IsNULL<bool>(reader["Saturday"]), DataAccessObject.IsNULL<bool>(reader["Sunday"]), DataAccessObject.IsNULL<bool>(reader["Monday"]), DataAccessObject.IsNULL<bool>(reader["Tuesday"]), DataAccessObject.IsNULL<bool>(reader["Wednesday"]), DataAccessObject.IsNULL<bool>(reader["Thrusday"]), DataAccessObject.IsNULL<bool>(reader["Friday"]), DataAccessObject.IsNULL<DateTime>(reader["ShiftStartTime"]), DataAccessObject.IsNULL<DateTime>(reader["ShiftEndTime"]), DataAccessObject.IsNULL<string>(reader["Description"]), DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]), DataAccessObject.IsNULL<string>(reader["ModifiedBy"].ToString()), DataAccessObject.IsNULL<DateTime>(reader["ModifiedDate"]) ); return hR_WorkingDaysShifting; } catch(Exception ex) { return null; } }