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