public static DataSet GetHR_WorkingDaysShiftingEmployeeID(string EmployeeID) { DataSet hR_WorkingDaysShiftings = new DataSet(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDaysShiftings = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingByEmployeeID(EmployeeID); return hR_WorkingDaysShiftings; }
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; }
public static DataSet GetDropDownListAllHR_WorkingDaysShifting() { DataSet hR_WorkingDaysShiftings = new DataSet(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDaysShiftings = sqlHR_WorkingDaysShiftingProvider.GetDropDownLisAllHR_WorkingDaysShifting(); return hR_WorkingDaysShiftings; }
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; }
public static DataSet GetAllHR_WorkingDaysShiftingsWithRelation() { DataSet hR_WorkingDaysShiftings = new DataSet(); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); hR_WorkingDaysShiftings = sqlHR_WorkingDaysShiftingProvider.GetAllHR_WorkingDaysShiftings(); return hR_WorkingDaysShiftings; }
/// <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 void LoadHR_WorkingDaysShiftingPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize) { int recordCount=0; int PageSize = int.Parse(ddlPageSize.SelectedValue); SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); DataSet ds = sqlHR_WorkingDaysShiftingProvider.GetHR_WorkingDaysShiftingPageWise(pageIndex, PageSize, out recordCount); gv.DataSource = ds; gv.DataBind(); hR_WorkingDaysShiftingsPaggination(rptPager,recordCount, pageIndex, PageSize); }
public static int InsertHR_WorkingDaysShifting(HR_WorkingDaysShifting hR_WorkingDaysShifting) { SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); return sqlHR_WorkingDaysShiftingProvider.InsertHR_WorkingDaysShifting(hR_WorkingDaysShifting); }
public static bool DeleteHR_WorkingDaysShifting(int hR_WorkingDaysShiftingID) { SqlHR_WorkingDaysShiftingProvider sqlHR_WorkingDaysShiftingProvider = new SqlHR_WorkingDaysShiftingProvider(); return sqlHR_WorkingDaysShiftingProvider.DeleteHR_WorkingDaysShifting(hR_WorkingDaysShiftingID); }