//-------Insert------------------------------------ public int InsertLeaveType(HRM_LEAVE_TYPE objLev) { try { _context.HRM_LEAVE_TYPE.AddObject(objLev); _context.SaveChanges(); return(1); } catch (Exception ex) { throw new Exception(ex.Message.ToString()); } }
//-------Update------------------------------------ public int UpdateLeaveType(HRM_LEAVE_TYPE objLev, int leaveID) { try { HRM_LEAVE_TYPE obj = _context.HRM_LEAVE_TYPE.First(x => x.LEV_ID == leaveID); obj.LEV_TYPE = objLev.LEV_TYPE; obj.LEV_DAYS = objLev.LEV_DAYS; obj.EDIT_USER = objLev.EDIT_USER; obj.EDIT_DATE = DateTime.Now; obj.OCODE = objLev.OCODE; _context.SaveChanges(); return(1); } catch (Exception ex) { throw ex; } }
private bool IsExist(HRM_LEAVE_TYPE _LeaveType) { try { ERPSSLHBEntities _context = new ERPSSLHBEntities(); bool status = false; int count = (from rgn in _context.HRM_LEAVE_TYPE where rgn.LEV_TYPE == _LeaveType.LEV_TYPE && rgn.LEV_DAYS == _LeaveType.LEV_DAYS select rgn.LEV_TYPE).Count(); if (count == 0) { status = true; } return(status); } catch (Exception) { throw; } }
//-------Update------------------------------------ public int UpdateLeaveType(HRM_LEAVE_TYPE objLev, int gradeId) { return(objCtx_DAL.UpdateLeaveType(objLev, gradeId)); }
//-------Insert------------------------------------ public int InsertLeaveType(HRM_LEAVE_TYPE objLev) { return(objCtx_DAL.InsertLeaveType(objLev)); }
protected void btnLeaveTypeSubmit_Click(object sender, EventArgs e) { try { if (txtbxLeaveType.Text == "") { // lblMessage.Text = ""; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func(Please Select Leave Type!'')", true); } else if (txtbxLeaveDays.Text == "") { // lblMessage.Text = ""; // lblMessage.ForeColor = System.Drawing.Color.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Please Input Leave Days!')", true); } else { HRM_LEAVE_TYPE objLev = new HRM_LEAVE_TYPE(); objLev.LEV_TYPE = txtbxLeaveType.Text; objLev.LEV_DAYS = Convert.ToInt32(txtbxLeaveDays.Text); objLev.EDIT_USER = ((SessionUser)Session["SessionUser"]).UserId; objLev.EDIT_DATE = DateTime.Now; objLev.OCODE = ((SessionUser)Session["SessionUser"]).OCode; if (btnLeaveTypeSubmit.Text == "Submit") { if (IsExist(objLev)) { int result = objLeave_BLL.InsertLeaveType(objLev); if (result == 1) { // lblMessage.Text = "Data Save 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.Red; ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Already Exists!')", true); } } else { int leaveTypeId = Convert.ToInt32(hidLeaveId.Value); int result = objLeave_BLL.UpdateLeaveType(objLev, leaveTypeId); 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); } } getLeaveTypes(); ClearAllTextbox(); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true); } }