internal int UpdateAttReason(int Id, HRM_AttendanceReason objAttendanceReason)
{
try
{
HRM_AttendanceReason objAttReason = _context.HRM_AttendanceReason.First(x => x.ReasonId == Id);
objAttReason.RegionId = objAttendanceReason.RegionId;
objAttReason.OfficeId = objAttendanceReason.OfficeId;
objAttReason.ShiftCode = objAttendanceReason.ShiftCode;
objAttReason.ShiftName = objAttendanceReason.ShiftName;
objAttReason.ReasonDate = objAttendanceReason.ReasonDate;
objAttReason.InTime = objAttendanceReason.InTime;
objAttReason.OutTime = objAttendanceReason.OutTime;
objAttReason.LateAllowed = objAttendanceReason.LateAllowed;
objAttReason.ReasonTypeId = objAttendanceReason.ReasonTypeId;
objAttReason.ReasonType = objAttendanceReason.ReasonType;
objAttReason.Remarks = objAttendanceReason.Remarks;
objAttReason.Edit_User = objAttendanceReason.Edit_User;
objAttReason.Edit_Date = objAttendanceReason.Edit_Date;
objAttReason.OCode = objAttendanceReason.OCode;
objAttReason.TotalHour = objAttendanceReason.TotalHour;
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
//-------Insert HRM_AttendanceReason------------------------------------
public int InsertAttendanceReason(HRM_AttendanceReason objAttendanceReason)
{
try
{
_context.HRM_AttendanceReason.AddObject(objAttendanceReason);
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
DateTime DateFrom = Convert.ToDateTime(txtfromDate.Text);
List <HRM_AttendanceReason> lstHRM_AttendanceReason = new List <HRM_AttendanceReason>();
for (int i = 0; i < Convert.ToInt16(hdfTotalDay.Value); i++)
{
HRM_AttendanceReason objattendanceReason = new HRM_AttendanceReason();
//objattendanceReason.RegionId = Convert.ToInt32(lblRegionId.Text);
//objattendanceReason.OfficeId = Convert.ToInt32(lblOfficeId.Text);
objattendanceReason.ShiftCode = ddlShiftCode.SelectedValue;
objattendanceReason.ShiftName = ddlShiftCode.SelectedItem.Text;
objattendanceReason.ReasonDate = DateFrom.AddDays(i);
objattendanceReason.ReasonTypeId = Convert.ToInt32(ddlReasonType.SelectedValue);
objattendanceReason.ReasonType = ddlReasonType.SelectedItem.Text;
objattendanceReason.Remarks = txtRemarks.Text;
//objattendanceReason.InTime = (txtStartTime.Hour + ":" + txtStartTime.Minute + ":" + txtStartTime.Second + " " + txtStartTime.AmPm);
//objattendanceReason.OutTime = (txtEndTime.Hour + ":" + txtEndTime.Minute + ":" + txtEndTime.Second + " " + txtEndTime.AmPm);
TimeSpan in_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtStartTime.Hour, txtStartTime.Minute, txtStartTime.Second));
objattendanceReason.InTime = in_time;
TimeSpan out_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtEndTime.Hour, txtEndTime.Minute, txtEndTime.Second));
objattendanceReason.OutTime = out_time;
TimeSpan lateAllowed = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtLateAllowed.Hour, txtLateAllowed.Minute, txtLateAllowed.Second));
objattendanceReason.LateAllowed = lateAllowed;
objattendanceReason.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
objattendanceReason.Edit_Date = DateTime.Now;
objattendanceReason.OCode = ((SessionUser)Session["SessionUser"]).OCode;
lstHRM_AttendanceReason.Add(objattendanceReason);
}
//if (in_time > out_time)
//{
// lblMessage.Text = "<font color='red'>Out Time can't be less than In Time</font>";
// return;
//}
if (BtnSave.Text == "Save")
{
int result = objAttendanceReasonBll.InsertAttendanceReason(lstHRM_AttendanceReason);
if (result == 1)
{
//lblMessage.Text = "Record Added successfully!";
//lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Record Added successfully!')", true);
reset();
BindGridAttendance();
}
else
{
//lblMessage.Text = "Record Adding Error!";
// lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Record Adding Error!')", true);
}
}
else
{
HRM_AttendanceReason objattendanceReason = new HRM_AttendanceReason();
//objattendanceReason.RegionId = Convert.ToInt32(lblRegionId.Text);
//objattendanceReason.OfficeId = Convert.ToInt32(lblOfficeId.Text);
objattendanceReason.ShiftCode = ddlShiftCode.SelectedValue;
objattendanceReason.ShiftName = ddlShiftCode.SelectedItem.Text;
objattendanceReason.ReasonDate = Convert.ToDateTime(txtfromDate.Text);
objattendanceReason.ReasonTypeId = Convert.ToInt32(ddlReasonType.SelectedValue);
objattendanceReason.ReasonType = ddlReasonType.SelectedItem.Text;
objattendanceReason.Remarks = txtRemarks.Text;
//objattendanceReason.InTime = (txtStartTime.Hour + ":" + txtStartTime.Minute + ":" + txtStartTime.Second + " " + txtStartTime.AmPm);
//objattendanceReason.OutTime = (txtEndTime.Hour + ":" + txtEndTime.Minute + ":" + txtEndTime.Second + " " + txtEndTime.AmPm);
TimeSpan in_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtStartTime.Hour, txtStartTime.Minute, txtStartTime.Second));
objattendanceReason.InTime = in_time;
TimeSpan out_time = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtEndTime.Hour, txtEndTime.Minute, txtEndTime.Second));
objattendanceReason.OutTime = out_time;
TimeSpan lateAllowed = TimeSpan.Parse(string.Format("{0}:{1}:{2}", txtLateAllowed.Hour, txtLateAllowed.Minute, txtLateAllowed.Second));
objattendanceReason.LateAllowed = lateAllowed;
objattendanceReason.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
objattendanceReason.Edit_Date = DateTime.Now;
objattendanceReason.OCode = ((SessionUser)Session["SessionUser"]).OCode;
int attReasonId = Convert.ToInt16(hiddenId.Value);
int result = objAttendanceReasonBll.UpdateAttReason(objattendanceReason, attReasonId);
if (result == 1)
{
//lblMessage.Text = "Record Updated Successfully";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Record Updated Successfully')", true);
reset();
BindGridAttendance();
}
else
{
//lblMessage.Text = "Record Updating Error!";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Record Updating Error!')", true);
//lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
public int UpdateAttReason(HRM_AttendanceReason objAttendanceReason, int id)
{
return(objCtx_DAL.UpdateAttReason(id, objAttendanceReason));
}
//-------Insert HRM_AttendanceReason------------------------------------
public int InsertAttendanceReason(HRM_AttendanceReason objAttendanceReason)
{
return(objCtx_DAL.InsertAttendanceReason(objAttendanceReason));
}
