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