//-------Insert HRM_TimeScheduleByReligion------------------------------------
public int InsertTimeScheduleByReligion(HRM_TimeScheduleByReligion objTimeScheduleByReligion)
{
try
{
_context.HRM_TimeScheduleByReligion.AddObject(objTimeScheduleByReligion);
_context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
}
protected void btnSaveByDepartment_Click(object sender, EventArgs e)
{
try
{
HRM_TimeScheduleByReligion objattendanceReason = new HRM_TimeScheduleByReligion();
objattendanceReason.RegionId = Convert.ToInt32(ddlRegion.SelectedValue);
objattendanceReason.OfficeId = Convert.ToInt32(ddlOffice.SelectedValue);
objattendanceReason.DepartmentId = Convert.ToInt32(ddlDepartment.SelectedValue);
//objattendanceReason.Religion = ddlReligion.Text;
objattendanceReason.Date = Convert.ToDateTime(txtDate.Text);
objattendanceReason.ReasonType = ddlReasonType.Text;
objattendanceReason.Remarks = ddlReasonType.SelectedItem.Text + " : " + txtRemarks.Text;
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;
objattendanceReason.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
objattendanceReason.Edit_Date = DateTime.Now;
objattendanceReason.OCode = ((SessionUser)Session["SessionUser"]).OCode;
if (in_time > out_time)
{
//lblMessage.Text = "<font color='red'>Out Time can't be less than In Time</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Out Time can't be less than In Time')", true);
return;
}
int Count = (from shift in _context.HRM_TimeScheduleByReligion
where shift.RegionId == objattendanceReason.RegionId && shift.OfficeId == objattendanceReason.OfficeId && shift.DepartmentId == objattendanceReason.DepartmentId && shift.Date == objattendanceReason.Date
select shift.ReligionSechedule_Id).Count();
if (Count != 0)
{
// lblMessage.Text = "Data Already Exists!";
//lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exists!')", true);
return;
}
objAttendanceReasonBll.InsertTimeScheduleByReligion(objattendanceReason);
HRM_AttendanceReason_Individual attendanceReasonInd = new HRM_AttendanceReason_Individual();
attendanceReasonInd.RegionId = Convert.ToInt32(ddlRegion.SelectedValue);
attendanceReasonInd.OfficeId = Convert.ToInt32(ddlOffice.SelectedValue);
attendanceReasonInd.DepartmentId = Convert.ToInt32(ddlDepartment.SelectedValue);
attendanceReasonInd.ReasonDate = Convert.ToDateTime(txtDate.Text);
attendanceReasonInd.ReasonTypeId = Convert.ToInt32(ddlReasonType.SelectedValue);
attendanceReasonInd.ReasonType = ddlReasonType.SelectedItem.Text;
attendanceReasonInd.Remarks = ddlReasonType.SelectedItem.Text + " : " + txtRemarks.Text;
attendanceReasonInd.InTime = in_time;
attendanceReasonInd.OutTime = out_time;
attendanceReasonInd.Edit_User = ((SessionUser)Session["SessionUser"]).UserId;
attendanceReasonInd.Edit_Date = DateTime.Now;
attendanceReasonInd.OCode = ((SessionUser)Session["SessionUser"]).OCode;
if (in_time > out_time)
{
//lblMessage.Text = "<font color='red'>Out Time can't be less than In Time</font>";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Out Time can't be less than In Time')", true);
return;
}
var result = objAttendanceReasonBll.InsertAtt_ReasonIndByDepartment(Convert.ToInt32(ddlRegion.SelectedValue), Convert.ToInt32(ddlOffice.SelectedValue), Convert.ToInt32(ddlDepartment.SelectedValue), Convert.ToDateTime(txtDate.Text), in_time, out_time, Convert.ToInt32(ddlReasonType.SelectedValue), ddlReasonType.SelectedItem.Text, ddlReasonType.SelectedItem.Text + " : " + txtRemarks.Text, ((SessionUser)Session["SessionUser"]).UserId, DateTime.Now, ((SessionUser)Session["SessionUser"]).OCode);
if (result == 1)
{
// lblMessage.Text = "Data Added successfully!";
//lblMessage.ForeColor = System.Drawing.Color.Green;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Added successfully!')", true);
reset();
BindGridAttendance();
}
else
{
//lblMessage.Text = "Data Adding failure!";
//lblMessage.ForeColor = System.Drawing.Color.Red;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Adding failure!')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
}
}
//-------Insert HRM_TimeScheduleByReligion------------------------------------
public int InsertTimeScheduleByReligion(HRM_TimeScheduleByReligion objTimeScheduleByReligion)
{
return(objCtx_DAL.InsertTimeScheduleByReligion(objTimeScheduleByReligion));
}
