예제 #1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="employee"></param>
        /// <param name="operation"></param>
        /// <returns></returns>
        public MessageDTO SaveEmployee(EmployeeDTO employee, string operation)
        {
            DataTable           dataTable = new DataTable();
            IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
            MessageDTO          message   = new MessageDTO();

            try
            {
                connector.BeginTransaction();

                //Todos los registros
                object[] parameters = new object[] { employee.EmployeeId, employee.Company.CompanyId, employee.Department.DepartmentId,
                                                     employee.ContractType.ContractTypeId, employee.Charge.ChargeId,
                                                     employee.Schedule.ScheduleId, employee.User.UserId,
                                                     employee.IdentificationType.IdentificationTypeId,
                                                     employee.Sex.SexId, employee.SectorId, employee.IdentificationNumber,
                                                     employee.EmployeeName, employee.EmployeeLastName, employee.ScheduleType,
                                                     employee.EmployeeFingerPrint, employee.EmployeeCardNumber, employee.EmployeeBirthDate,
                                                     employee.EmployeeSalary, employee.EmployeeEntryDate, employee.EmployeeModificationDate,
                                                     employee.EmployeeValidityStartDate, employee.EmployeeValidityEndDate,
                                                     employee.EmployeeTruancy, employee.EmployeeUsedCard, employee.EmployeeStreetAddress,
                                                     employee.EmployeeStatus, operation };
                //connector.ExecuteNonQuery(CommandType.StoredProcedure, "SaveEmployee", parameters);
                dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SaveEmployee", parameters);

                foreach (DataRow row in dataTable.Rows)
                {
                    message.ErrorCode    = row["ERROR_NUMBER"].ToString();
                    message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString();
                }

                if (message.ErrorCode == "0")
                {
                    connector.Commit();
                }
                else
                {
                    connector.RollBack();
                }
            }
            catch (Exception exception)
            {
                message.ErrorCode    = "-1";
                message.ErrorMessage = exception.ToString();
                connector.RollBack();
            }
            finally
            {
                connector.Dispose();
            }
            return(message);
        }
예제 #2
0
        //string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString();

        #endregion

        #region Schedule

        /// <summary>
        ///
        /// </summary>
        /// <param name="schedule"></param>
        /// <param name="operation"></param>
        /// <returns></returns>
        public MessageDTO SaveSchedule(ScheduleDTO schedule, string operation)
        {
            DataTable           dataTable = new DataTable();
            IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
            MessageDTO          message   = new MessageDTO();

            try
            {
                connector.BeginTransaction();

                //Todos los registros
                object[] parameters = new object[] { schedule.ScheduleId, schedule.Company.CompanyId, schedule.User.UserId,
                                                     schedule.Workday.WorkdayId, schedule.ScheduleShortName,
                                                     schedule.ScheduleDescription, schedule.ScheduleStartHour, schedule.ScheduleEndHour,
                                                     schedule.ScheduleLunchHour, schedule.ScheduleIsNight, schedule.ScheduleAccess,
                                                     schedule.ScheduleOuterZone, schedule.ScheduleInnerZone, schedule.ScheduleLunchTime,
                                                     schedule.ScheduleOutputDelay, schedule.ScheduleEntryDelay,
                                                     schedule.ScheduleStatus, operation };
                //connector.ExecuteNonQuery(CommandType.StoredProcedure, "SaveSchedule", parameters);
                dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SaveSchedule", parameters);

                foreach (DataRow row in dataTable.Rows)
                {
                    message.ErrorCode    = row["ERROR_NUMBER"].ToString();
                    message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString();
                }

                if (message.ErrorCode == "0")
                {
                    connector.Commit();
                }
                else
                {
                    connector.RollBack();
                }
            }
            catch (Exception exception)
            {
                message.ErrorCode    = "-1";
                message.ErrorMessage = exception.ToString();
                connector.RollBack();
            }
            finally
            {
                connector.Dispose();
            }
            return(message);
        }
예제 #3
0
        //string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString();

        #endregion

        #region Department

        /// <summary>
        ///
        /// </summary>
        /// <param name="charge"></param>
        /// <param name="operation"></param>
        /// <returns></returns>
        public MessageDTO SaveDepartment(DepartmentDTO department, string operation)
        {
            DataTable           dataTable = new DataTable();
            IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
            MessageDTO          message   = new MessageDTO();

            try
            {
                connector.BeginTransaction();

                //Todos los registros
                object[] parameters = new object[] { department.DepartmentId, department.Company.CompanyId,
                                                     department.SpendingCenter.SpendingCenterId,
                                                     department.User.UserId, department.DepartmentDescription,
                                                     department.DepartmentStatus, operation };
                //connector.ExecuteNonQuery(CommandType.StoredProcedure, "SaveDepartment", parameters);
                dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SaveDepartment", parameters);

                foreach (DataRow row in dataTable.Rows)
                {
                    message.ErrorCode    = row["ERROR_NUMBER"].ToString();
                    message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString();
                }

                if (message.ErrorCode == "0")
                {
                    connector.Commit();
                }
                else
                {
                    connector.RollBack();
                }
            }
            catch (Exception exception)
            {
                message.ErrorCode    = "-1";
                message.ErrorMessage = exception.ToString();
                connector.RollBack();
            }
            finally
            {
                connector.Dispose();
            }
            return(message);
        }