internal int UpdateTimeSchedule(HRM_TIMESCHEDULE objTimeSchedule, int sheduleId) { HRM_TIMESCHEDULE objTime = _context.HRM_TIMESCHEDULE.First(x => x.ScheduleId == sheduleId); //objTime.RegionId = objTimeSchedule.RegionId; //objTime.OfficeId = objTimeSchedule.OfficeId; //objTime.DepartmentId = objTimeSchedule.DepartmentId; objTime.ShiftCode = objTimeSchedule.ShiftCode; objTime.ShiftName = objTimeSchedule.ShiftName; objTime.ShiftType = objTimeSchedule.ShiftType; objTime.Weekend1 = objTimeSchedule.Weekend1; objTime.Weekend2 = objTimeSchedule.Weekend2; objTime.StartTime = objTimeSchedule.StartTime; objTime.EndTime = objTimeSchedule.EndTime; objTime.LateAllowed = objTimeSchedule.LateAllowed; objTime.TotalHour = objTimeSchedule.TotalHour; objTime.Weekend1_Duty = objTimeSchedule.Weekend1_Duty; objTime.Weekend1Duty_Hour = objTimeSchedule.Weekend1Duty_Hour; objTime.Weekend2_Duty = objTimeSchedule.Weekend2_Duty; objTime.Weekend2Duty_Hour = objTimeSchedule.Weekend2Duty_Hour; objTime.Edit_Date = objTimeSchedule.Edit_Date; objTime.Edit_User = objTimeSchedule.Edit_User; objTime.OCode = objTimeSchedule.OCode; _context.SaveChanges(); return(1); }
//-------Insert------------------------------------ public int InsertTimeSchedule(HRM_TIMESCHEDULE objTimeSchedule) { try { _context.HRM_TIMESCHEDULE.AddObject(objTimeSchedule); _context.SaveChanges(); return(1); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { HRM_TIMESCHEDULE objtimeSchedule = new HRM_TIMESCHEDULE(); //objtimeSchedule.RegionId = Convert.ToInt32(ddlRegion.SelectedValue); //objtimeSchedule.OfficeId = Convert.ToInt32(ddlOffice.SelectedValue); //objtimeSchedule.DepartmentId = Convert.ToInt32(ddlDepartment.SelectedValue); objtimeSchedule.ShiftCode = txtShiftCode.Text; objtimeSchedule.ShiftName = txtShiftName.Text; objtimeSchedule.ShiftType = ddlShift.Text; objtimeSchedule.Weekend1 = ddlWeekend1.SelectedValue.ToString(); if (ddlWeekend1Duty.SelectedItem.Text == "------ Select One ------") { objtimeSchedule.Weekend1_Duty = false; } else { objtimeSchedule.Weekend1_Duty = Convert.ToBoolean(ddlWeekend1Duty.SelectedValue.ToString()); } if (ddlWeekend2Duty.SelectedItem.Text == "------ Select One ------") { objtimeSchedule.Weekend2_Duty = false; } else { objtimeSchedule.Weekend2_Duty = Convert.ToBoolean(ddlWeekend2Duty.SelectedValue.ToString()); } objtimeSchedule.Weekend2 = ddlWeekend2.SelectedValue.ToString(); objtimeSchedule.Weekend1Duty_Hour = txtWeekend1DutyHour.Text; objtimeSchedule.Weekend2Duty_Hour = txtWeekend2DutyHour.Text; TimeSpan start_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtStartTime.Hour, txtStartTime.Minute, txtStartTime.Second)); objtimeSchedule.StartTime = start_time; TimeSpan end_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtEndTime.Hour, txtEndTime.Minute, txtEndTime.Second)); objtimeSchedule.EndTime = end_time; //objtimeSchedule.StartTime = (txtStartTime.Hour + ":" + txtStartTime.Minute + ":" + txtStartTime.Second + " " + txtStartTime.AmPm); //objtimeSchedule.EndTime = (txtEndTime.Hour + ":" + txtEndTime.Minute + ":" + txtEndTime.Second + " " + txtEndTime.AmPm); TimeSpan lateAllowed = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtLateAllowed.Hour, txtLateAllowed.Minute, txtLateAllowed.Second)); objtimeSchedule.LateAllowed = lateAllowed; TimeSpan totalHour, hour1, hour2; if (ddlShift.SelectedItem.Text == "Night") { hour1 = TimeSpan.Parse("23:59:59"); hour2 = Calculations.timeDiff(start_time, hour1); totalHour = hour2 + end_time; objtimeSchedule.TotalHour = totalHour; } else { totalHour = Calculations.timeDiff(start_time, end_time); objtimeSchedule.TotalHour = totalHour; } objtimeSchedule.Edit_User = ((SessionUser)Session["SessionUser"]).UserId; objtimeSchedule.Edit_Date = DateTime.Now; objtimeSchedule.OCode = ((SessionUser)Session["SessionUser"]).OCode; //if (end_time < start_time) //{ // lblMessage.Text = "<font color='red'>Out Time can't be less than In Time</font>"; // return; //} int ShiftCount = (from shift in _context.HRM_TIMESCHEDULE where shift.ShiftCode == objtimeSchedule.ShiftCode && shift.ShiftName == objtimeSchedule.ShiftName select shift.ScheduleId).Count(); if (BtnSave.Text == "Save") { if (ShiftCount != 0) { // lblMessage.Text = ""; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exists!')", true); return; } int result = objtimeScheduleBLL.InsertTimeSchedule(objtimeSchedule); if (result == 1) { // lblMessage.Text = "Record Added successfully!"; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Save Successfully')", true); } else { // lblMessage.Text = ""; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Date Adding failure!')", true); } } else { int scheduleId = Convert.ToInt32(hiddenId.Value); int result = objtimeScheduleBLL.UpdateTimeSchedule(objtimeSchedule, scheduleId); if (result == 1) { // lblMessage.Text = "Data Update successfully!"; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true); } else { // lblMessage.Text = ""; // lblMessage.ForeColor = System.Drawing.Color.Green; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Date Updating failure!')", true); } } reset(); BindGridTimeSchedule(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }
internal int UpdateTimeSchedule(HRM_TIMESCHEDULE objTimeSchedule, int scheduleId) { return(objCtx_DAL.UpdateTimeSchedule(objTimeSchedule, scheduleId)); }
//-------Insert------------------------------------ public int InsertTimeSchedule(HRM_TIMESCHEDULE objtimeSchedule) { return(objCtx_DAL.InsertTimeSchedule(objtimeSchedule)); }