예제 #1
0
        /// <summary>
        /// Initializes a DataAccessFacade for accessing a MS SQL database
        /// </summary>
        /// <param name="test">For integration tests, set test = true to use test database</param>
        public DataAccessFacade(bool test = false)
        {
            if (!test)
            {
                //take the database information from a textfile.
                connectionString = File.ReadAllText("C:\\ConnectString.txt");
            }
            else
            {
                connectionString =
                    @"Data Source=localhost\SQLEXPRESS;Initial Catalog=LTTEST;Integrated Security=True";
            }

            //Creates a new instance of the mappers with the connection information
            paymentMapper = new PaymentMapper(connectionString);
            customerMapper = new CustomerMapper(connectionString);
            supplierMapper = new SupplierMapper(connectionString);
            bookingMapper = new BookingMapper(connectionString);
            paymentRuleMapper = new PaymentRuleMapper(connectionString);

            PartyMapper partyMapper = new PartyMapper();

            partyMapper.CustomerMapper = customerMapper;
            partyMapper.SupplierMapper = supplierMapper;

            paymentMapper.PartyMapper = partyMapper;
            bookingMapper.CustomerMapper = customerMapper;
            bookingMapper.SupplierMapper = supplierMapper;
            paymentRuleMapper.CustomerMapper = customerMapper;
            paymentRuleMapper.SupplierMapper = supplierMapper;

            customerMapper.ReadAll();
            supplierMapper.ReadAll();
        }
예제 #2
0
        protected override PaymentEntity entityFromReader(SqlDataReader reader)
        {
            //Reads the different columns from the database and set them to corresponding data type in the program.
            DateTime dueDate     = (DateTime)reader["DueDate"];
            decimal  dueAmount   = (decimal)reader["DueAmount"];
            DateTime paidDate    = (DateTime)reader["PaidDate"];
            decimal  paidAmount  = (decimal)reader["PaidAmount"];
            bool     paid        = (bool)reader["Paid"];
            bool     archived    = (bool)reader["Archived"];
            string   attachments = (string)reader["Attachments"];

            int         payerId = (int)reader["Payer"];
            int         payeeId = (int)reader["Payee"];
            string      note    = (string)reader["Note"];
            PaymentType type    = (PaymentType)Enum.Parse(typeof(PaymentType), reader["Type"].ToString());
            string      sale    = (string)reader["Sale"];
            int         booking = (int)reader["Booking"];
            string      invoice = (string)reader["Invoice"];

            int      id           = (int)reader["PaymentId"];
            DateTime lastModified = (DateTime)reader["LastModified"];
            bool     deleted      = (bool)reader["Deleted"];

            APartyEntity payer = PartyMapper.Read(payerId);
            APartyEntity payee = PartyMapper.Read(payeeId);

            PaymentEntity paymentEntity = new PaymentEntity(dueDate, dueAmount, payer,
                                                            payee, type, sale, booking);

            paymentEntity.PaidDate   = paidDate;
            paymentEntity.PaidAmount = paidAmount;
            paymentEntity.Paid       = paid;
            paymentEntity.Archived   = archived;
            if (attachments != "")
            {
                foreach (string attachment in attachments.Split(';'))
                {
                    paymentEntity.AddAttachment(attachment);
                }
            }

            paymentEntity.Note    = note;
            paymentEntity.Invoice = invoice;

            paymentEntity.Id           = id;
            paymentEntity.LastModified = lastModified;
            paymentEntity.Deleted      = deleted;

            return(paymentEntity);
        }