public int InsertEmployeeLeave(HRM_LEAVE_EMPLOYEE obj) { int result = 0; using (var _context = new ERPSSLHBEntities()) { var PRM_EMP_ID = new SqlParameter("EMP_ID", obj.EMP_ID); var PRM_EID = new SqlParameter("EID", obj.EID); var PRM_LEV_TYPE_ID = new SqlParameter("LEV_TYPE_ID", obj.LEV_TYPE_ID); var PRM_TOTAL_LEV_DAYS = new SqlParameter("TOTAL_LEV_DAYS", obj.TOTAL_LEV_DAYS); var PRM_REMARKS = new SqlParameter("REMARKS", obj.REMARKS); var PRM_EDIT_USER = new SqlParameter("EDIT_USER", obj.EDIT_USER); var PRM_EDIT_DATE = new SqlParameter("EDIT_DATE", obj.EDIT_DATE); var PRM_OCODE = new SqlParameter("OCODE", obj.OCODE); string SP_SQL = "ENTER_EMPLOYEE_LEAVE @EMP_ID,@EID,@LEV_TYPE_ID,@TOTAL_LEV_DAYS,@REMARKS,@EDIT_USER,@EDIT_DATE,@OCODE"; //int return_value = _context.ExecuteStoreQuery<int>(SP_SQL, PRM_EMP_ID, PRM_EID, PRM_LEV_TYPE_ID, PRM_TOTAL_LEV_DAYS, PRM_REMARKS, PRM_EDIT_USER, PRM_EDIT_DATE, PRM_OCODE); int return_value = _context.ExecuteStoreQuery <int>(SP_SQL, PRM_EMP_ID, PRM_EID, PRM_LEV_TYPE_ID, PRM_TOTAL_LEV_DAYS, PRM_REMARKS, PRM_EDIT_USER, PRM_EDIT_DATE, PRM_OCODE).FirstOrDefault(); if (return_value == 1) { result = 1; } else if (return_value == 2) { result = 2; } else { result = 0; } return(result); } }
public int InsertEmployeeLeave(HRM_LEAVE_EMPLOYEE obj) { return(objCtx_DAL.InsertEmployeeLeave(obj)); }