private async void EvtEliminarPrestatario(object sender, EventArgs e)
        {
            try
            {
                Borrower borro = await deleteBorrower(borrower.id);

                if (borro != null)
                {
                    await this.DisplayAlert("Exitoso", "Usuario eliminado de manera satisfactoria", "Ok");

                    await Navigation.PushAsync(new UsersTable());
                }
                else
                {
                    await DisplayAlert("Fallido", "Datos invalidos", "Ok");
                }
            }
            catch
            {
                await DisplayAlert("Fallido", "Ingrese los campos", "Ok");
            }
        }
        private async void EvtEditarPrestatario(object sender, EventArgs e)
        {
            try
            {
                Borrower borro = await editBorrower(EntryNombre.Text, EntryCC.Text, EntryTelefono.Text, Convert.ToSingle(EntryCantidad.Text), Convert.ToSingle(EntryPorcentaje.Text), Int32.Parse(EntryMeses.Text));

                if (borro != null)
                {
                    await this.DisplayAlert("Exitoso", "Usuario actualizado de manera satisfactoria", "Ok");

                    await Navigation.PushAsync(new UsersTable());
                }
                else
                {
                    await DisplayAlert("Fallido", "Datos invalidos", "Ok");
                }
            }
            catch
            {
                await DisplayAlert("Fallido", "Ingrese los campos", "Ok");
            }
        }
Exemple #3
0
        // GET: Return book:
        public ActionResult Return(int?id)
        {
            if (id == null)
            {
                // TODO: ERROR/EXCEPTION HANDLING
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            // check this is a valid book record
            Book book = db.Books.Find(id);

            if (book == null)
            {
                // TODO: ERROR/EXCEPTION HANDLING
                return(HttpNotFound());
            }

            // Make book available
            book.isAvailable     = true;
            db.Entry(book).State = EntityState.Modified;
            db.SaveChanges();

            // check borrower record against the book
            Borrower borrower = dbBorrower.Borrowers.Find(book.ID);

            if (borrower == null)
            {
                // TODO: ERROR/EXCEPTION HANDLING
                return(HttpNotFound());
            }

            // update the borrower record with return date
            borrower.ReturnDate = DateTime.Now;
            dbBorrower.Entry(borrower).State = EntityState.Modified;
            dbBorrower.SaveChanges();

            return(RedirectToAction("Index"));
        }
        public ActionResult Borrow(int id /* bookid */)
        {
            try
            {
                using (Context ctx = new Context())
                {
                    string   BorrowerName = User.Identity.Name;
                    Borrower thisUser     = ctx.BorrowerSecuredFindByName(BorrowerName);
                    if (null == thisUser)
                    {
                        throw new Exception($"Borrower Not Found: '{BorrowerName}'");
                    }
                    Book thisBook = ctx.BookFindByID(id);
                    if (null == thisBook)
                    {
                        throw new Exception($"Book Not Found, id:'{id}'");
                    }
                    // see if the book is checked out already
                    var history    = ctx.RatedBorrowingGetBorrowersRelatedToBook(id);
                    var checkedout = (history.Where(b => b.isCheckedOut == true)).ToList();
                    if (checkedout.Count > 0)
                    {
                        return(View("CheckedOut", checkedout));
                    }

                    // this is the Junction to a Many-Many.
                    // This is duplicatable, and has extra data.
                    VMBorrowing Borrowing = new VMBorrowing(thisBook, thisUser);
                    Borrowing.DueDate = DateTime.Now.AddDays(21);

                    return(View(Borrowing));
                }
            }
            catch (Exception ex)
            {
                return(View("Exception", ex));
            }
        }
Exemple #5
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            if (btnAdd.Text.Equals("Add"))
            {
                txtAdr.Text   = "";
                txtEmail.Text = "";
                txtName.Text  = "";
                txtPhone.Text = "";
                txtSex.Text   = "";
                btnAdd.Text   = "Save";
                txtborrowerNumber.ReadOnly = true;
                txtborrowerNumber.Text     = "" + (m.GetBorrowerNumberMax() + 1);
                setBtn(1);
            }
            else
            {
                b = new Borrower(int.Parse(txtborrowerNumber.Text), txtName.Text, Char.Parse(txtSex.Text), txtAdr.Text, txtPhone.Text, txtEmail.Text);
                //b.Name = txtName.Text;
                //b.Address = txtAdr.Text;
                //b.Email = txtEmail.Text;
                //b.Sex = Char.Parse(txtSex.Text);
                //b.Telephone = txtPhone.Text;

                if (m.Insert(b))
                {
                    MessageBox.Show("Add success!!!");
                }
                else
                {
                    MessageBox.Show("Can't add borrower!!!");
                }
                showData();
                btnAdd.Text = "Add";
                txtborrowerNumber.ReadOnly = false;

                setBtn(2);
            }
        }
Exemple #6
0
 public IActionResult Edit(Borrower borrower)
 {
     if (ModelState.IsValid)
     {
         if (borrower.BorrowerId == 0)
         {
             //context.Borrowers.Add(borrower);
             context.Database.ExecuteSqlRaw("execute sp_ins_borrower @p0, @p1, @p2, @p3",
                                            parameters: new[]
             {
                 borrower.FName,
                 borrower.LName,
                 borrower.Phone.ToString(),
                 borrower.Email
             });
         }
         else
         {
             //context.Borrowers.Update(borrower);
             context.Database.ExecuteSqlRaw("execute sp_upd_borrower @p0, @p1, @p2, @p3, @p4",
                                            parameters: new[]
             {
                 borrower.BorrowerId.ToString(),
                 borrower.FName,
                 borrower.LName,
                 borrower.Phone.ToString(),
                 borrower.Email.ToString()
             });
         }
         context.SaveChanges();
         return(RedirectToAction("Index", "Borrower"));
     }
     else
     {
         ViewBag.Action = (borrower.BorrowerId == 0) ? "Add" : "Edit";
         return(View(borrower));
     }
 }
Exemple #7
0
        private void btnEdit_Click(object sender, EventArgs e)
        {
            if (dataGridView1.SelectedRows.Count == 0)
            {
                MessageBox.Show("Please chose a row");
                return;
            }
            else
            {
                if (btnEdit.Text.Equals("Edit"))
                {
                    setBtn(3);
                }

                else
                {
                    int borrowerNumber = int.Parse(dataGridView1.SelectedRows[0].Cells["borrowerNumber"].Value.ToString());

                    b = new Borrower(borrowerNumber, txtName.Text, Char.Parse(txtSex.Text), txtAdr.Text, txtPhone.Text, txtEmail.Text);
                    //b.BorrowerNumber = borrowerNumber;
                    // b.Name = txtName.Text;
                    //b.Address = txtAdr.Text;
                    //b.Email = txtEmail.Text;
                    //b.Sex = txtSex.Text;
                    //b.Telephone = txtPhone.Text;
                    if (m.Edit(b))
                    {
                        MessageBox.Show("Edit success");
                        showData();
                    }
                    else
                    {
                        MessageBox.Show("You can Edit this borrower!!!");
                    }
                    setBtn(4);
                }
            }
        }
        public static Borrower GetBorrower(int borrowerNumber)
        {
            SqlConnection conn = new SqlConnection(strConn);

            conn.Open();
            SqlCommand cmd = new SqlCommand("select * from Borrower where borrowerNumber = @bn", conn);

            cmd.Parameters.AddWithValue("@bn", borrowerNumber);
            Borrower b = new Borrower();

            using (SqlDataReader reader = cmd.ExecuteReader()) {
                while (reader.Read())
                {
                    b.Name = (string)reader["name"];
                    //b.Sex = (char)reader["sex"];
                    b.Address   = (string)reader["address"];
                    b.Telephone = (string)reader["telephone"];
                    b.Email     = (string)reader["email"];
                }
                conn.Close();
            }
            return(b);
        }
        /// <summary>
        /// The object factory for a particular data collection instance.
        /// </summary>
        public virtual void CreateObjectsFromData(Borrowers borrowers, System.Data.SqlClient.SqlDataReader data)
        {
            // Do nothing if we have nothing
            if (data == null)
            {
                return;
            }


            // Create a local variable for the new instance.
            Borrower newobj = null;

            // Iterate through the data reader
            while (data.Read())
            {
                // Create a new object instance
                newobj = System.Activator.CreateInstance(borrowers.ContainsType[0]) as Borrower;
                // Let the instance set its own members
                newobj.SetMembers(ref data);
                // Add the new object to the collection instance
                borrowers.Add(newobj);
            }
        }
Exemple #10
0
        public IHttpActionResult UpdateBorrowe(int id, Borrower borrower)
        {
            if (!ModelState.IsValid)
            {
                throw new HttpResponseException(HttpStatusCode.BadRequest);
            }

            var borrowerInDb = _db.Borrowers.SingleOrDefault(b => b.Id == id);

            if (borrowerInDb == null)
            {
                throw new HttpResponseException(HttpStatusCode.NotFound);
            }

            borrowerInDb.Name       = borrower.Name;
            borrowerInDb.Surname    = borrower.Surname;
            borrowerInDb.NationalId = borrower.NationalId;
            borrowerInDb.BirthDate  = borrower.BirthDate;
            borrowerInDb.Address    = borrower.Address;
            borrowerInDb.Phone      = borrower.Phone;
            _db.SaveChanges();
            return(Ok(borrowerInDb));
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        _borrowerId = Request.QueryString["borrowerId"];
        var account = new Borrower();

        account.Find(_borrowerId);
        if (!Page.IsPostBack)
        {
            lblId.Text          = account.BorrowerId;
            lblFirstName.Text   = account.FirstName;
            lblLastName.Text    = account.LastName;
            lblTelephone.Text   = account.TelNumber;
            lblEmail.Text       = account.Email;
            lblAccountType.Text = account.GetBorrowerTypeDescription(account.BorrowerType);
            rdLive.Checked      = account.Status.Trim() == "Live";
            rdSuspended.Checked = account.Status.Trim() == "Suspended";
            rptLoans.DataSource = account.Loans;
            rptLoans.DataBind();

            rptFines.DataSource = account.Fines;
            rptFines.DataBind();
        }
    }
Exemple #12
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            int      add            = (int)Session["add"];
            int      borrowerNumber = (int)Session["borrowerNumber"];
            Borrower c = new Borrower();

            c.BorrowerNumber = borrowerNumber;
            c.Name           = txtName.Text;
            c.Sex            = txtSex.Text.ToCharArray()[0];
            c.Address        = txtAdd.Text;
            c.Telephone      = txtPhone.Text;
            c.Email          = txtEmail.Text;
            if (add == 1)
            {
                BorrowerDAO.Insert(c);
            }
            else
            {
                BorrowerDAO.Edit(c);
            }
            ObjectDataSource1.Select();
            GridView1.DataBind();
        }
        public async Task <ActionResult <Result> > Create(Borrower borrower)
        {
            var result = await _borrowerService.Add(new Borrower
            {
                Id              = Guid.NewGuid().ToString(),
                Name            = borrower.FirstName + borrower.MiddleName + borrower.LastName,
                FirstName       = borrower.FirstName,
                MiddleName      = borrower.MiddleName,
                LastName        = borrower.LastName,
                Email           = borrower.Email,
                gender          = borrower.gender,
                MailingAddress  = borrower.MailingAddress,
                StreetAddress   = borrower.StreetAddress,
                Phone           = borrower.Phone,
                CreatedUsername = borrower.CreatedUsername,
                CreatedOn       = DateTime.Now,
                UpdatedUsername = null,
                UpdatedOn       = default(DateTime),
                Comments        = "Borrower Entity Creation"
            });

            return(Ok(result));
        }
Exemple #14
0
        protected void btCheckMember_Click(object sender, EventArgs e)
        {
            lbError.Visible = false;
            int borrowerNumber;

            try
            {
                borrowerNumber = int.Parse(txtMemberCode.Text);
            }
            catch
            {
                lbError.Visible = true;
                lbError.Text    = "Borrower number must be a integer!";
                txtMemberCode.Focus();
                return;
            }
            Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);

            if (b == null)
            {
                lbError.Visible = true;
                lbError.Text    = String.Format("Borrower number {0} does't exist!", borrowerNumber);
                txtMemberCode.Focus();
                return;
            }
            txtName.Text = b.Name;

            View();
            if (GridView1.Rows.Count >= 1)
            {
                lbError.Visible = true;
                lbError.Text    = "You has already reserved !!!";
                txtMemberCode.Focus();
                return;
            }
            displayButtons(2);
        }
Exemple #15
0
        public ActionResult Login()
        {
            if (Session["Borrower"] != null)
            {
                return(RedirectToAction("Index"));
            }

            if (Request.HttpMethod == "POST")
            {
                string login    = Request.Form["username"];
                string password = Settings.SecureString(Request.Form["password"]);

                Borrower borrower = null;

                // Let's try to obtain the requested borrower by its login and password
                try
                {
                    borrower = Borrower.getByLoginAndPasswd(login, password);
                }
                catch
                {
                    return(View("Error500"));
                }

                if (borrower == null)
                {
                    ViewBag.error = "Please verify your login information.";
                }
                else
                {
                    Session["Borrower"] = borrower;
                    return(RedirectToAction("Index"));
                }
            }

            return(View());
        }
        private void View(Borrower borrower)
        {
            DataTable dt = new DataTable();

            dt = ReserveDAO.GetDataTableReserve(borrower.BorrowerNumber);

/*            foreach (DataRow dr in dt.Rows)
 *          {
 *              dr[3] = DateTime.Parse((dr[3].ToString())).ToString("dd/MM/yyyy");
 *          }*/
            DataView dv = new DataView(dt);

            GridView1.DataSource = dv;
            GridView1.DataBind();

            try
            {
                GridViewRow row = GridView1.Rows[0];
                row.Cells[3].Text = DateTime.Parse((row.Cells[3].Text.ToString())).ToString("dd/MM/yyyy");
            }
            catch
            {
            }
        }
    protected void HandlerFindUser(object sender, EventArgs e)
    {
        var account = new Borrower();

        if (account.Find(txtStudentNumber.Text.Trim()))
        {
            pnUserInfo.Visible = true;
            _borrowerId        = account.BorrowerId;

            lblUser.Text = $"{account.FirstName} {account.LastName}";

            lblLoans.Text      = $"{account.Loans.FindAll(loan => loan.LoanReturnDate == null).Count.ToString()} / {account.GetBorrowerMaxLoans()}";
            lblFines.Text      = account.Fines.FindAll(fine => fine.FineStatus.Trim() == "DUE").Sum(fine => fine.FineAmount).ToString("C");
            lblResrvation.Text = account.Reservations.FindAll(reservation => reservation.ClearedDate == null).Count
                                 .ToString();

            rptCurrentLoans.DataSource = account.Loans.FindAll(loan => loan.LoanReturnDate == null);
            rptCurrentLoans.DataBind();

            rptHistoryLoans.DataSource = account.Loans.FindAll(loan => loan.LoanReturnDate != null);
            rptHistoryLoans.DataBind();

            rptCurrentReservations.DataSource = account.Reservations.FindAll(reservation => reservation.ClearedDate == null);
            rptCurrentReservations.DataBind();

            rptHistoryReservations.DataSource = account.Reservations.FindAll(reservation => reservation.ClearedDate != null);
            rptHistoryReservations.DataBind();

            rptCurrentFines.DataSource = account.Fines.FindAll(fine => fine.FineStatus.Trim() == "DUE");
            rptCurrentFines.DataBind();

            var finesWithPayments = new FineCollection(account.BorrowerId);
            rptHistoryFines.DataSource = finesWithPayments.FinesWithPayments();
            rptHistoryFines.DataBind();
        }
    }
Exemple #18
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            int      add = (int)Session["add"];
            Borrower b   = new Borrower();

            b.Name      = txtName.Text;
            b.Sex       = char.Parse(txtSex.Text);
            b.Address   = txtAddress.Text;
            b.Telephone = txtTelephone.Text;
            b.Email     = txtEmail.Text;
            if (add == 1)
            {
                b.BorrowerNumber = BorrowerDAO.GetBorrowerNumberMax() + 1;
                BorrowerDAO.Insert(b);
            }
            else if (add == 2)
            {
                b.BorrowerNumber = Int32.Parse(GridView1.SelectedRow.Cells[1].Text);
                BorrowerDAO.Update(b);
            }
            displayButtons(1);
            ObjectDataSource1.Select();
            GridView1.DataBind();
        }
Exemple #19
0
        private void CheckExpiration()
        {
            if (_checking)
            {
                return;
            }
            _checking = true;

            var expired = Takeout.Cache.Where(x => !x.IsReturned && IsExpired(x.TakeoutDate)).ToList();

            foreach (var takeout in expired)
            {
                var notification = Notification.Cache.FirstOrDefault(x =>
                                                                     x.NotificationType == Notification.NotificationTypes.TakeoutExpired &&
                                                                     x.RecordId == takeout.Id);
                if (notification != null)
                {
                    continue;
                }
                var borrower = Borrower.GetById(takeout.BorrowerId);
                var book     = Book.GetById(takeout.BookId);
                notification = new Notification()
                {
                    Thumbnail        = book.Thumbnail,
                    RecordId         = takeout.Id,
                    NotificationType = Notification.NotificationTypes.TakeoutExpired,
                    Title            = "BOOK NOT RETURNED",
                    Message          = $"{borrower.Fullname} did not return the book {book.Title} borrowed last {takeout.TakeoutDate.ToShortDateString()}."
                };
                App.Current.Dispatcher.Invoke(() => notification.Save());
                Messages.Enqueue(notification);
                Resources.chime_glass_note_hi.Play();
            }

            _checking = false;
        }
Exemple #20
0
        private void btnMember_Click(object sender, EventArgs e)
        {
            int borrowerNumber;

            try {
                borrowerNumber = int.Parse(txtBorrowerNumber.Text);
            }
            catch {
                MessageBox.Show("Borrower number must be a integer!");
                txtBorrowerNumber.Focus();
                return;
            }
            Borrower b = BorrowerDAO.GetBorrower(borrowerNumber);

            if (b == null)
            {
                MessageBox.Show(String.Format("Borrower number {0} does't exist!", borrowerNumber));
                txtBorrowerNumber.Focus();
                return;
            }
            txtName.Text = b.Name;
            View();
            displayButtons(2);
        }
Exemple #21
0
        public static Borrower GetBorrower(int borrowerNumber)
        {
            SqlConnection conn    = DAO.getConnections();
            string        sql     = "SELECT * FROM Borrower WHERE borrowerNumber = @borrowerNumber";
            SqlCommand    command = new SqlCommand(sql, conn);

            command.Parameters.Add(new SqlParameter("@borrowerNumber", borrowerNumber));
            conn.Open();
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                Borrower s = new Borrower();
                s.BorrowerNumber = Int32.Parse(reader["borrowerNumber"].ToString());
                s.Name           = reader["name"].ToString();
                s.Sex            = Char.Parse(reader["sex"].ToString());
                s.Address        = reader["address"].ToString();
                s.Telephone      = reader["telephone"].ToString();
                s.Email          = reader["email"].ToString();
                conn.Close();
                return(s);
            }
            return(null);
        }
        public bool CreateBorrower(Borrower borrower)
        {
            connection();
            SqlCommand check = new SqlCommand("Select count(*) from borrower where ssn ='" + borrower.SSN + "';", con);

            con.Open();
            SqlDataReader rdr = check.ExecuteReader();
            int           num = 0;

            while (rdr.Read())
            {
                num = Convert.ToInt32(rdr[0]);
            }
            con.Close();

            if (num == 0)
            {
                connection();
                SqlCommand command = new SqlCommand("CreateBorrower", con);
                command.CommandType = System.Data.CommandType.StoredProcedure;
                command.Parameters.AddWithValue("@ssn", borrower.SSN);
                command.Parameters.AddWithValue("@bname", borrower.Name);
                command.Parameters.AddWithValue("@address", borrower.Address);
                command.Parameters.AddWithValue("@phone", borrower.Phone);

                con.Open();
                command.ExecuteNonQuery();
                con.Close();

                return(true);
            }
            else
            {
                return(false);
            }
        }
        public static Borrower GetBorrower(int borrowerNum)
        {
            SqlConnection conn = new SqlConnection(strConn);
            SqlCommand    cmd  = new SqlCommand("Select * from Borrower where borrowerNumber = @b", conn);

            cmd.Parameters.AddWithValue("@b", borrowerNum);
            Borrower b = null;

            conn.Open();
            SqlDataReader rd = cmd.ExecuteReader();

            while (rd.Read())
            {
                b = new Borrower();
                b.BorrowerNumber = int.Parse(rd["borrowerNumber"].ToString());
                b.Name           = rd["name"].ToString();
                b.Sex            = char.Parse(rd["sex"].ToString());
                b.Address        = rd["address"].ToString();
                b.Telephone      = rd["telephone"].ToString();
                b.Email          = rd["email"].ToString();
            }
            conn.Close();
            return(b);
        }
        public ActionResult Details(int id)
        {
            Borrower borrower = borrowerRepository.GetByID(id);

            return(View(borrower));
        }
Exemple #25
0
 public Assets(Borrower borrower)
     : base()
 {
     _borrower = borrower;
 }
 public void SetBorrower(Borrower borrower)
 {
     borrowers.Remove(borrower);
     borrowers.Add(borrower);
     WriteData();
 }
 private bool CheckBorrowerExist(Borrower borrower) {
     try {
         string query = "SELECT Count(*) FROM borrowers WHERE id = @id";
         using (MySqlCommand cmd = new MySqlCommand(query, db.ConnectionManager.Connection)) {
             cmd.Prepare();
             cmd.Parameters.AddWithValue("@id", borrower.Id);
             long result = (long)cmd.ExecuteScalar();
             return result > 0;
         }
     }
     catch (MySqlException ex) {
         MessageBox.Show(ex.Message);
         return false;
     }
 }
Exemple #28
0
        public string PerformAction(int activityId)
        {
            AvailableActivities selectedActivity = _descriptionOfActivities.Keys.ElementAt(activityId);

            switch (selectedActivity)
            {
            case AvailableActivities.AddBookToCatalog:
                Console.Write("Title: ");
                string title = Console.ReadLine().Trim();
                Console.Write("Author: ");
                string author = Console.ReadLine().Trim();
                Console.Write("ISBN: ");
                string isbn = Console.ReadLine().Trim();

                if (string.IsNullOrWhiteSpace(title) || string.IsNullOrWhiteSpace(author) || string.IsNullOrWhiteSpace(isbn))
                {
                    return("Incorrect data provided. Try again.");
                }

                try
                {
                    if (_bookRepository.AddBookToCatalog(title, author, isbn))
                    {
                        return($"Book \"{title}\" has been added to the catalog.");
                    }
                    else
                    {
                        throw new Exception();
                    }
                }
                catch (Exception)
                {
                    return($"[Warning] Book \"{title}\" has not been added to the catalog. Try again.");
                }

            case AvailableActivities.RemoveBookFromCatalog:
                try
                {
                    BookRecord bookToRemove = GetBookRecord();
                    if (bookToRemove != null)
                    {
                        if (_bookRepository.RemoveBookFromCatalog(bookToRemove))
                        {
                            return("Book has been removed from catalog correctly.");
                        }
                        else
                        {
                            throw new Exception();
                        }
                    }
                    else
                    {
                        return("[Warning] The book was not found. Try again.");
                    }
                }
                catch (Exception)
                {
                    return($"[Warning] Book has not been removed from catalog. Try again.");
                }

            case AvailableActivities.SearchBookByParameter:
                try
                {
                    BookRecord bookRecord = GetBookRecord();
                    if (bookRecord != null)
                    {
                        string response = $"The book was found. Title: \"{bookRecord.Book.Title}\", author: {bookRecord.Book.Author}, ISBN: {bookRecord.Book.ISBN}.";
                        if (bookRecord.LastBorrowDate == DateTime.MinValue || bookRecord.LastBorrowDate == null)
                        {
                            response += "\n(not borrowed yet)";
                        }
                        else
                        {
                            response += $"\nBorrowed by {bookRecord.LastBorrower.Name} {bookRecord.LastBorrower.LastName} (Date: {bookRecord.LastBorrowDate.ToShortDateString()})";
                        }
                        return(response);
                    }
                }
                catch (Exception)
                { }
                return("[Warning] The book was not found. Try again.");

            case AvailableActivities.SearchBooksNotBorrowedForWeeks:
                try
                {
                    Console.Write("Number of weeks: ");
                    int weeks = int.Parse(Console.ReadLine().Trim());

                    try
                    {
                        List <BookRecord> booksNotBorrowed = _bookRepository.GetBooksNotBorrowedForWeeks(weeks);
                        foreach (BookRecord bookNotBorrowed in booksNotBorrowed)
                        {
                            Console.WriteLine($"\nBook: \"{bookNotBorrowed.Book.Title}\" {bookNotBorrowed.Book.Author} ISBN: {bookNotBorrowed.Book.ISBN}.");
                            if (bookNotBorrowed.LastBorrowDate == DateTime.MinValue || bookNotBorrowed.LastBorrowDate == null)
                            {
                                Console.WriteLine("(not borrowed yet)");
                            }
                            else
                            {
                                Console.WriteLine($"Borrowed by {bookNotBorrowed.LastBorrower.Name} {bookNotBorrowed.LastBorrower.LastName} (Date: {bookNotBorrowed.LastBorrowDate.ToShortDateString()})");
                            }
                        }
                        return($"{booksNotBorrowed.Count} records were found correctly.");
                    }
                    catch (Exception)
                    {
                        return("[Warning] There was a problem downloading the data. Try again.");
                    }
                }
                catch (Exception)
                {
                    return("[Warning] Incorrect data provided. Try again.");
                }

            case AvailableActivities.BorrowBook:
                try
                {
                    Console.Write("Borrower name: ");
                    string borrowerName = Console.ReadLine().Trim();
                    Console.Write("Borrower last name: ");
                    string borrowerLastName = Console.ReadLine().Trim();

                    if (string.IsNullOrWhiteSpace(borrowerName) || string.IsNullOrWhiteSpace(borrowerLastName))
                    {
                        return("Incorrect data provided. Try again.");
                    }

                    Borrower borrower = new Borrower()
                    {
                        Name     = borrowerName,
                        LastName = borrowerLastName
                    };

                    BookRecord bookToBorrow = GetBookRecord();
                    if (bookToBorrow != null)
                    {
                        bookToBorrow.LastBorrower   = borrower;
                        bookToBorrow.LastBorrowDate = DateTime.Now;

                        if (_bookRepository.BorrowBook(bookToBorrow))
                        {
                            return("Book has been borrowed correctly.");
                        }
                        else
                        {
                            return("[Warning] Book has not been borrowed. Try again.");
                        }
                    }
                    else
                    {
                        return("[Warning] The book was not found. Try again.");
                    }
                }
                catch (Exception)
                {
                    return($"[Warning] Book has not been borrowed. Try again.");
                }

            case AvailableActivities.GetCurrentBorrowers:
                try
                {
                    List <BorrowerRecord> borrowers = _bookRepository.GetCurrentBorrowers();
                    foreach (BorrowerRecord borrower in borrowers)
                    {
                        Console.WriteLine($"{borrower.LastBorrower.Name} {borrower.LastBorrower.LastName}: {borrower.NumberOfBooksBorrowed} books");
                    }
                    return($"{borrowers.Count} records were found correctly.");
                }
                catch (Exception)
                {
                    return("[Warning] There was a problem downloading the data. Try again.");
                }
            }
            return("[Error] Action for selected activity is not defined.");
        }
 private void BookItem(Inventory item, Borrower borrower, DateTime? tanggal_mulai, DateTime? tanggal_selesai) {
     if (!CheckBorrowerExist(borrower)) {
         try {
             string query = "INSERT INTO borrowers(id, nama, jenis, no_telp) VALUES(@id, @nama, @jenis, @no_telp)";
             using (MySqlCommand cmd = new MySqlCommand(query, db.ConnectionManager.Connection)) {
                 cmd.Prepare();
                 cmd.Parameters.AddWithValue("@id", borrower.Id);
                 cmd.Parameters.AddWithValue("@nama", borrower.Nama);
                 cmd.Parameters.AddWithValue("@jenis", borrower.Jenis);
                 cmd.Parameters.AddWithValue("@no_telp", borrower.NomorTelp);
                 cmd.ExecuteNonQuery();
             }
         }
         catch (MySqlException ex) {
             MessageBox.Show(ex.Message);
             return;
         }
     }
     try {
         string query = "UPDATE inventory SET id_peminjam = @id_peminjam, tanggal_mulai = @tanggal_mulai, tanggal_selesai = @tanggal_selesai WHERE id = @item_id";
         using (MySqlCommand cmd = new MySqlCommand(query, db.ConnectionManager.Connection)) {
             cmd.Prepare();
             cmd.Parameters.AddWithValue("@id_peminjam", borrower.Id);
             cmd.Parameters.AddWithValue("@tanggal_mulai", tanggal_mulai);
             cmd.Parameters.AddWithValue("@tanggal_selesai", tanggal_selesai);
             cmd.Parameters.AddWithValue("@item_id", item.Id);
             cmd.ExecuteNonQuery();
         }
     }
     catch (MySqlException ex) {
         MessageBox.Show(ex.Message);
         return;
     }
 }
        private void Button_Selesai_Click(object sender, RoutedEventArgs e) {
            string id_jenis = comboBox_Jenis_Barang.SelectedValue.ToString();
            int jumlah = int.Parse(textbox_Jumlah.Text);
            
            List<Inventory> inventory = GetInventory(id_jenis);
            if (inventory.Count < jumlah) {
                MessageBox.Show("Jumlah barang yang tersedia tidak mencukupi");
            }
            else {
                /* Informasi Peminjaman */
                string id_peminjam = textbox_Id.Text;
                string nama_peminjam = textbox_Nama.Text;
                string no_hp = textbox_Nomor_HP.Text;

                string jenis_peminjam = null;
                if (radioButton_Dosen.IsChecked != null && radioButton_Dosen.IsChecked == true)
                    jenis_peminjam = (string)Application.Current.FindResource("jenisPeminjamDosen");
                if (radioButton_Mahasiswa.IsChecked != null && radioButton_Mahasiswa.IsChecked == true)
                    jenis_peminjam = (string)Application.Current.FindResource("jenisPeminjamMahasiswa");
                if (radioButton_Pegawai.IsChecked != null && radioButton_Pegawai.IsChecked == true)
                    jenis_peminjam = (string)Application.Current.FindResource("jenisPeminjamPegawai");

                DateTime? tanggal_mulai = Date_Peminjaman.SelectedDate;
                DateTime? tanggal_selesai = Date_Pengembalian.SelectedDate;

                Borrower borrower = new Borrower(id_peminjam, nama_peminjam, jenis_peminjam, no_hp);
                for (var index = 0; index < jumlah; ++index) {
                    Inventory item = inventory[index];
                    BookItem(item, borrower, tanggal_mulai, tanggal_selesai);
                }
            }
        }
    public void LoadBorrowerList(Borrower borrower)
    {
        ArrayList list = database.LoadBorrowerItems (borrower, table);

        items.Clear();

        foreach (Item item in list) {
            this.Insert (item);
        }
        Changed();
    }
    public void OnOkButtonClicked(object o, EventArgs args)
    {
        int id = Int32.MaxValue;

        Entry entry = (Entry) borrowerComboBox.Child;
        if (entry.Text != null && !entry.Text.Equals ("")) {
            foreach (Borrower borrower in borrowers) {
                if (borrower.Name.Equals (entry.Text)) {
                    id = borrower.Id;
                    break;
                }
            }

            if (id == Int32.MaxValue) {
                id = database.AddBorrower (entry.Text);
            }

            Borrower newBorrower = new Borrower (id, entry.Text, null);
            database.LendItem (item, newBorrower);

            this.Destroy();
        }
        else {
            Gtk.Dialog dialog = new MessageDialog (this,
                    DialogFlags.DestroyWithParent,
                    MessageType.Error,
                    ButtonsType.Close,
                    Mono.Posix.Catalog.GetString ("You must write the borrower name"));
            dialog.Run ();
            dialog.Destroy();
        }
    }
Exemple #33
0
    public int LendItem(Item item, Borrower borrower)
    {
        if (debug)
            Console.WriteLine ("DB:LendItem");
        StringBuilder sql = new StringBuilder (200);
        sql = sql.Append ("INSERT INTO lends VALUES (NULL, ");
        sql = sql.Append (borrower.Id);
        sql = sql.Append (", '");
        sql = sql.Append (item.Table);
        sql = sql.Append ("', ");
        sql = sql.Append (item.Id);
        sql = sql.Append (")");

        command.CommandText = sql.ToString();
        command.ExecuteNonQuery();

        return ((SqliteCommand)command).LastInsertRowID();
    }
Exemple #34
0
    public ArrayList LoadBorrowerItems(Borrower borrower, string tableName)
    {
        if (debug)
            Console.WriteLine ("DB:LoadBorrowerItems");

        ArrayList list = new ArrayList ();
        //		string sql = "SELECT * from lends WHERE table_name='"+tableName+"' AND borrower="+borrower.Id;
        string sql = "SELECT * from lends WHERE borrower="+borrower.Id;
        command.CommandText = sql;
        SqliteDataReader reader = command.ExecuteReader ();
        while (reader.Read ()) {
            if (reader["item_id"] != null && !reader["item_id"].ToString().Equals("")) {
                string table = (string)reader["table_name"];
                int itemId = Int32.Parse(reader["item_id"].ToString());
                list.Add (this.GetItem (table, itemId));
            }
        }
        reader.Close();
        return list;
    }
 public CreditScore(Borrower borrower)
     : base()
 {
     _borrower = borrower;
 }
 public Liabilities(Borrower borrower)
     : base()
 {
     _borrower = borrower;
 }
 public IActionResult Delete(Borrower borrower)
 {
     context.Borrower.Remove(borrower);
     context.SaveChanges();
     return(RedirectToAction("List", "Borrower"));
 }
 public VMBorrower()
 {
     TheEmbeddedItem = new Borrower();
 }
Exemple #39
0
        public IActionResult Delete(int?ID)
        {
            Borrower model = _Borrower.GetBorrower(ID);

            return(View(model));
        }
        /// <summary>
        /// Creates a new instance of an existing (persisted) loan application.
        /// </summary>
        /// <param name="appId">The identity of the loan application.</param>
        public LoanApplication(long appId)
            : base(appId)
        {
            // TODO: add additional fill methods for the rest of the loan object

            // load up the data information
            MISMO.BusinessObjects.DataInformationCollection dats = this.GetDataInformationCollection();
            if (dats != null && dats.Count > 0)
            {
                _datainformation = new DataInformation();
                MISMO.Entities.DataInformationBase datbase = dats[0];
                _datainformation.SetMembers(ref datbase);
            }

            // load up the additional case data.
            MISMO.BusinessObjects.AdditionalCaseDataCollection addcasecol = this.GetAdditionalCaseDataCollection();
            if (addcasecol != null && addcasecol.Count > 0)
            {
                MISMO.Entities.AdditionalCaseDataBase addcasebase = addcasecol[0] as MISMO.Entities.AdditionalCaseDataBase;
                _additionalcasedata = new AdditionalCaseData();
                _additionalcasedata.SetMembers(ref addcasebase);
            }

            // load up the down payment information
            _downpayments = this.GetDownPayments();

            // load up the interviewer information
            MISMO.BusinessObjects.InterviewerInformationCollection intvcol = this.GetInterviewerInformationCollection();
            if (intvcol != null && intvcol.Count > 0)
                _interviewer = intvcol[0];

            // load up the loan product data
            MISMO.BusinessObjects.LoanProductDataCollection loanproducts = this.GetLoanProductDataCollection();
            if (loanproducts != null && loanproducts.Count > 0)
            {
                MISMO.Entities.LoanProductDataBase lpbase = loanproducts[0];
                _loanproductdata = new LoanProductData();
                _loanproductdata.SetMembers(ref lpbase);
            }

            // load up the loan purpose
            MISMO.BusinessObjects.LoanPurposes purps = this.GetLoanPurposes();
            if (purps != null && purps.Count > 0)
            {
                MISMO.Entities.LoanPurposeBase purpbase = purps[0];
                _purpose = new LoanPurpose();
                _purpose.SetMembers(ref purpbase);
            }

            // load up the loan qualification information
            MISMO.BusinessObjects.LoanQualifications lqcol = this.GetLoanQualifications();
            if (lqcol != null && lqcol.Count > 0)
            {
                MISMO.Entities.LoanQualificationBase lqbase = lqcol[0] as MISMO.Entities.LoanQualificationBase;
                _loanqualification.SetMembers(ref lqbase);
            }

            // load up the mortgage terms.
            MISMO.BusinessObjects.MortgageTermsCollection mtgterms = this.GetMortgageTermsCollection();
            if (mtgterms != null && mtgterms.Count > 0)
                _mortgageterms = mtgterms[0];

            // loan up the property information
            MISMO.BusinessObjects.Properties props = this.GetProperties();
            if (props != null && props.Count > 0)
            {
                _prop = new AUS.Property();
                MISMO.Entities.PropertyBase propbase = props[0];
                _prop.SetMembers(ref propbase);
            }

            // load up the proposed housing expenses
            _proposedHousingExpenses = this.GetProposedHousingExpenses();

            // load up the REO properties
            _reoProperties = this.GetREOProperties();

            // load up the title holder objects
            _titleholders = this.GetTitleHolders();

            // load up the transaction details
            MISMO.BusinessObjects.TransactionDetails trandets = this.GetTransactionDetails();
            if (trandets != null && trandets.Count > 0)
            {
                MISMO.Entities.TransactionDetailBase trandbase = trandets[0];
                _transdetail = new AUS.TransactionDetail();
                _transdetail.SetMembers(ref trandbase);
            }

            // load up the borrower information
            MISMO.BusinessObjects.Borrowers bws = this.GetBorrowers();
            MISMO.Entities.BorrowerBase bwsbase = null;
            for(int i = 0, j = bws.Count; i<j; i++)
            {
                MISMO.BusinessObjects.AUS.Borrower ausbw = new Borrower();
                bwsbase = bws[i] as MISMO.Entities.BorrowerBase;
                ausbw.SetMembers(ref bwsbase);
                _borrowers.Add(ausbw);
            }

            // finally update the checksum if this constructor wasn't called from a descendant.
            if (this.GetType() == typeof(MISMO.BusinessObjects.AUS.LoanApplication))
            {
                RecalculateChecksum();
            }
        }
 public VMBorrower(Borrower b)
 {
     TheEmbeddedItem = b;
 }
        /// <summary>
        /// Loads the loan object with information from a Fannie Mae set of data.
        /// </summary>
        /// <param name="fileBytes">The fannie data bytes.</param>
        protected virtual void LoadDU(byte[] fileBytes)
        {
            DUHelper du = new DUHelper(fileBytes);
            Exception invalidfiledata = new Exception("The file data is not a recognized Fannie Mae DU format.");

            #region DATA_INFORMATION

            // capture the versioning information
            int vercount = du.BeginCapture("000");
            if (vercount < 1) throw invalidfiledata;
            else
            {
                this._datainformation = new DataInformation();
                for(int i = 0; i<vercount; i++)
                {
                    MISMO.BusinessObjects.DataVersion dv = new DataVersion();
                    dv.Name = du.ExtractCaptureData(i, 4, 3);
                    if (dv.Name == "1") dv.Name = "1003";
                    dv.Number = du.ExtractCaptureData(i, 7, 5);
                    this._datainformation.DataVersions.Add(dv);
                }
            }
            du.EndCapture();

            if (vercount > 0 &&
                !(this.DataInformation.DataVersions[0].Number == "3.20" ||
                this.DataInformation.DataVersions[0].Number == "3.2")
                ) throw new NotImplementedException("Fannie Mae loader only supports 3.20 DU file formats.");

            #endregion DATA_INFORMATION

            #region MORTGAGE_TERMS

            string tempval = null;

            // extract information for the mortgage terms
            tempval = du.ExtractData("01A", 86, 30);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.AgencyCaseIdentifier = tempval;
            }

            tempval = du.ExtractData("01A", 238, 80);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.ARMTypeDescription = tempval;
            }

            tempval = du.ExtractData("01A", 131, 15);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.BaseLoanAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("01A", 131, 15);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.BorrowerRequestedLoanAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("01A", 116, 15);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.LenderCaseIdentifier = tempval;
            }

            tempval = du.ExtractData("01A", 153, 3);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.LoanAmortizationTermMonths = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("01A", 156, 2);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();

                switch(tempval)
                {
                    case "01":
                    {
                        this.MortgageTerms.LoanAmortizationType = (short) MISMO.Enums.LoanAmortizationType.AdjustableRate;
                        break;
                    }
                    case "04":
                    {
                        this.MortgageTerms.LoanAmortizationType = (short) MISMO.Enums.LoanAmortizationType.GrowingEquityMortgage;
                        break;
                    }
                    case "05":
                    {
                        this.MortgageTerms.LoanAmortizationType = (short) MISMO.Enums.LoanAmortizationType.Fixed;
                        break;
                    }
                    case "06":
                    {
                        this.MortgageTerms.LoanAmortizationType = (short) MISMO.Enums.LoanAmortizationType.GraduatedPaymentMortgage;
                        break;
                    }
                    case "13":
                    {
                        this.MortgageTerms.LoanAmortizationType = (short) MISMO.Enums.LoanAmortizationType.OtherAmortizationType;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("01A", 4, 2);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();

                switch(tempval)
                {
                    case "01":
                    {
                        this.MortgageTerms.MortgageType = (short) MISMO.Enums.MortgageType.Conventional;
                        break;
                    }
                    case "02":
                    {
                        this.MortgageTerms.MortgageType = (short) MISMO.Enums.MortgageType.VA;
                        break;
                    }
                    case "03":
                    {
                        this.MortgageTerms.MortgageType = (short) MISMO.Enums.MortgageType.FHA;
                        break;
                    }
                    case "04":
                    {
                        this.MortgageTerms.MortgageType = (short) MISMO.Enums.MortgageType.FarmersHomeAdministration;
                        break;
                    }
                    case "07":
                    {
                        this.MortgageTerms.MortgageType = (short) MISMO.Enums.MortgageType.Other;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("01A", 6, 80);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.OtherMortgageTypeDescription= tempval;
            }

            tempval = du.ExtractData("01A", 158, 80);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.OtherAmortizationTypeDescription = tempval;
            }

            tempval = du.ExtractData("01A", 146, 7);
            if (tempval != string.Empty)
            {
                if (_mortgageterms == null) _mortgageterms = new MISMO.BusinessObjects.MortgageTerms();
                this.MortgageTerms.RequestedInterestRatePercent = Convert.ToDecimal(tempval);
            }

            #endregion MORTGAGE_TERMS

            #region PROPERTY
            // now let us get PROPERTY information

            tempval = du.ExtractData("02A", 4, 50);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                this.Property.StreetAddress = tempval;
            }

            tempval = du.ExtractData("02A", 54, 35);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                this.Property.City = tempval;
            }

            tempval = du.ExtractData("02A", 89, 2);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                this.Property.State = tempval;
            }

            tempval = du.ExtractData("GOA", 102, 35);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                this.Property.County = tempval;
            }

            tempval = du.ExtractData("02A", 91, 5);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                this.Property.PostalCode = tempval;
            }

            tempval = du.ExtractData("02A", 96, 4);
            if (tempval != string.Empty && _prop != null && !this.Property.PostalCodeIsNull) this.Property.PostalCode += string.Format("-{0}", tempval);

            tempval = du.ExtractData("02A", 100, 3);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                this.Property.FinancedNumberOfUnits = Convert.ToInt32(tempval);
            }

            tempval = du.ExtractData("02A", 185, 4);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                this.Property.StructureBuiltYear = DateTime.Parse(string.Format("12/31/{0}", tempval));
            }

            MISMO.BusinessObjects.LegalDescription legdesc = null;

            tempval = du.ExtractData("02A", 105, 80);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                if (legdesc == null)
                {
                    legdesc = new MISMO.BusinessObjects.LegalDescription();
                    this.Property.LegalDescriptions.Add(legdesc);
                }
                legdesc.TextDescription = tempval;
            }

            tempval = du.ExtractData("02A", 103, 2);
            if (tempval != string.Empty)
            {
                if (_prop == null) _prop = new AUS.Property();
                if (legdesc == null)
                {
                    legdesc = new MISMO.BusinessObjects.LegalDescription();
                    this.Property.LegalDescriptions.Add(legdesc);
                }

                switch(tempval)
                {
                    case "F1":
                    {
                        legdesc.Type = (short) MISMO.Enums.LegalDescriptionType.Other;
                        break;
                    }
                    case "02":
                    {
                        legdesc.Type = (short) MISMO.Enums.LegalDescriptionType.MetesAndBounds;
                        break;
                    }
                }
            }

            #endregion PROPERTY

            #region BORROWER

            // get the borrower information
            System.Collections.Specialized.StringCollection brwssncol = new System.Collections.Specialized.StringCollection();
            int borrowercount = du.BeginCapture("03A");
            Borrower brw = null;

            if (borrowercount > 0)
            {
                for(int i = 0; i<borrowercount; i++)
                {
                    brw = new Borrower();

                    tempval = du.ExtractCaptureData(i, 15, 35);
                    if (tempval != string.Empty) brw.FirstName = tempval;

                    tempval = du.ExtractCaptureData(i, 50, 35);
                    if (tempval != string.Empty) brw.MiddleName = tempval;

                    tempval = du.ExtractCaptureData(i, 85, 35);
                    if (tempval != string.Empty) brw.LastName = tempval;

                    tempval = du.ExtractCaptureData(i, 120, 4);
                    if (tempval != string.Empty) brw.NameSuffix = tempval;

                    tempval = du.ExtractCaptureData(i, 134, 3);
                    if (tempval != string.Empty) brw.AgeAtApplicationYears = Convert.ToDecimal(tempval);

                    // TODO: revisit extracting borrower data in different captures zones
            //					tempval = du.ExtractCaptureData(i, 13, 8);
            //					if (tempval != string.Empty) brw.ApplicationSignedDate = DateTime.Parse(string.Format("{0}/{1}/{2}", tempval.Substring(4, 2), tempval.Substring(6, 2), tempval.Substring(0, 4)));

                    tempval = du.ExtractCaptureData(i, 124, 10);
                    if (tempval != string.Empty)
                    {
                        MISMO.BusinessObjects.ContactPoint cp = new ContactPoint();
                        cp.Type = (short) MISMO.Enums.ContactPointType.Phone;
                        cp.Value = tempval;
                        brw.ContactPoints.Add(cp);
                    }

                    tempval = du.ExtractCaptureData(i, 4, 2);
                    switch(tempval)
                    {
                        case "BW":
                        {
                            brw.PrintPositionType = (short) MISMO.Enums.PrintPositionType.Borrower;
                            break;
                        }
                        case "QZ":
                        {
                            brw.PrintPositionType = (short) MISMO.Enums.PrintPositionType.CoBorrower;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(i, 6, 9);
                    if (tempval != string.Empty) brw.SSN = tempval;

                    tempval = du.ExtractCaptureData(i, 140, 2);
                    if (tempval != string.Empty) brw.DependentCount = Convert.ToByte(tempval);

                    tempval = du.ExtractCaptureData(i, 142, 1);
                    switch(tempval)
                    {
                        case "Y":
                        {
                            brw.JointAssetLiabilityReportingType = (short) MISMO.Enums.JointAssetLiabilityReportingType.Jointly;
                            break;
                        }
                        case "N":
                        {
                            brw.JointAssetLiabilityReportingType = (short) MISMO.Enums.JointAssetLiabilityReportingType.NotJointly;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(i, 139, 1);
                    switch(tempval)
                    {
                        case "M":
                        {
                            brw.MaritalStatusType = (short) MISMO.Enums.MaritalStatusType.Married;
                            break;
                        }
                        case "S":
                        {
                            brw.MaritalStatusType = (short) MISMO.Enums.MaritalStatusType.Separated;
                            break;
                        }
                        case "U":
                        {
                            brw.MaritalStatusType = (short) MISMO.Enums.MaritalStatusType.Unmarried;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(i, 137, 2);
                    if (tempval != string.Empty) brw.SchoolingYears = Convert.ToDecimal(tempval);

                    this.Borrowers.Add(brw);
                }
            } // end of borrowers section

            #endregion BORROWER

            #region DOWN_PAYMENTS

            // extract the down payments
            int downpaymentcount = du.BeginCapture("02E");
            if (downpaymentcount > 0)
            {
                MISMO.BusinessObjects.DownPayment dp = null;
                for(int i = 0; i<downpaymentcount; i++)
                {
                    dp = new MISMO.BusinessObjects.DownPayment();
                    tempval = du.ExtractCaptureData(i, 6, 15);
                    if (tempval != string.Empty) dp.Amount = Convert.ToDecimal(tempval);

                    tempval = du.ExtractCaptureData(i, 21, 80);
                    if (tempval != string.Empty) dp.SourceDescription = tempval;

                    tempval = du.ExtractCaptureData(i, 4, 2);
                    switch(tempval)
                    {
                        case "F1":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.CheckingSavings;
                            break;
                        }
                        case "F2":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.DepositOnSalesContract;
                            break;
                        }
                        case "F3":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.EquityOnSoldProperty;
                            break;
                        }
                        case "03":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.EquityOnPendingSale;
                            break;
                        }
                        case "04":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.GiftFunds;
                            break;
                        }
                        case "F5":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.StocksAndBonds;
                            break;
                        }
                        case "10":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.LotEquity;
                            break;
                        }
                        case "09":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.BridgeLoan;
                            break;
                        }
                        case "01":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.UnsecuredBorrowedFunds;
                            break;
                        }
                        case "F6":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.TrustFunds;
                            break;
                        }
                        case "F7":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.RetirementFunds;
                            break;
                        }
                        case "11":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.RentWithOptionToPurchase;
                            break;
                        }
                        case "F8":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.LifeInsuranceCashValue;
                            break;
                        }
                        case "14":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.SaleOfChattel;
                            break;
                        }
                        case "07":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.TradeEquity;
                            break;
                        }
                        case "06":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.SweatEquity;
                            break;
                        }
                        case "02":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.CashOnHand;
                            break;
                        }
                        case "13":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.OtherTypeOfDownPayment;
                            break;
                        }
                        case "28":
                        {
                            dp.Type = (short) MISMO.Enums.DownPaymentType.SecuredBorrowedFunds;
                            break;
                        }
                    }

                    this.DownPayments.Add(dp);
                }
            } // end of downpaymentcount

            #endregion DOWN_PAYMENTS

            #region ADDITIONAL_CASE_DATA.MORTGAGE_SCORE

            int mortgagescores = du.BeginCapture("SCA");
            if (mortgagescores > 0)
            {
                if (_additionalcasedata == null)
                    _additionalcasedata = new AdditionalCaseData();

                MISMO.BusinessObjects.MortgageScore mtgscore = null;

                for(int i = 0; i<mortgagescores; i++)
                {
                    mtgscore = new MISMO.BusinessObjects.MortgageScore();

                    tempval = du.ExtractCaptureData(i, 10, 8);
                    if (tempval != string.Empty) mtgscore.Date = du.ToDate(tempval);

                    tempval = du.ExtractCaptureData(i, 4, 3);
                    switch(tempval)
                    {
                        case "001":
                        {
                            mtgscore.Type = (short) MISMO.Enums.MortgageScoreType.PMIAuraAQIScore;
                            break;
                        }
                        case "002":
                        {
                            mtgscore.Type = (short) MISMO.Enums.MortgageScoreType.GE_IQScore;
                            break;
                        }
                        case "003":
                        {
                            mtgscore.Type = (short) MISMO.Enums.MortgageScoreType.UGIAccuscore;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(i, 7, 3);
                    if (tempval != string.Empty) mtgscore.Value = tempval;

                    _additionalcasedata.MortgageScores.Add(mtgscore);
                }
            } // end of mortgagescores

            #endregion ADDITIONAL_CASE_DATA.MORTGAGE_SCORE

            #region ADDITIONAL_CASE_DATA.TRANSMITTAL_DATA

            tempval = du.ExtractData("99B", 22, 7);
            if (tempval != string.Empty)
            {
                if (_additionalcasedata == null) _additionalcasedata = new AUS.AdditionalCaseData();
                if (_additionalcasedata._transmitdata == null) _additionalcasedata._transmitdata = new BusinessObjects.TransmittalData();
                this.AdditionalCaseData.TransmittalData.BuydownRatePercent = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("99B", 5, 2);
            if (tempval != string.Empty)
            {
                if (_additionalcasedata == null) _additionalcasedata = new AUS.AdditionalCaseData();
                if (_additionalcasedata._transmitdata == null) _additionalcasedata._transmitdata = new BusinessObjects.TransmittalData();
                switch(tempval)
                {
                    case "01":
                    {
                        this.AdditionalCaseData.TransmittalData.CurrentFirstMortgageHolderType = (short) MISMO.Enums.MortgageHolderType.FNM;
                        break;
                    }
                    case "02":
                    {
                        this.AdditionalCaseData.TransmittalData.CurrentFirstMortgageHolderType = (short) MISMO.Enums.MortgageHolderType.FRE;
                        break;
                    }
                    case "03":
                    {
                        this.AdditionalCaseData.TransmittalData.CurrentFirstMortgageHolderType = (short) MISMO.Enums.MortgageHolderType.Other;
                        break;
                    }
                    case "F1":
                    {
                        this.AdditionalCaseData.TransmittalData.CurrentFirstMortgageHolderType = (short) MISMO.Enums.MortgageHolderType.Unknown;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("99B", 7, 15);
            if (tempval != string.Empty)
            {
                if (_additionalcasedata == null) _additionalcasedata = new AUS.AdditionalCaseData();
                if (_additionalcasedata._transmitdata == null) _additionalcasedata._transmitdata = new BusinessObjects.TransmittalData();
                this.AdditionalCaseData.TransmittalData.PropertyAppraisedValueAmount = Convert.ToDecimal(tempval);
            }

            #endregion ADDITIONAL_CASE_DATA.TRANSMITTAL_DATA

            #region LOAN_PURPOSE

            tempval = du.ExtractData("02B", 89, 60);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                this.Purpose.GSETitleMannerHeldDescription = tempval;
            }

            tempval = du.ExtractData("02B", 6, 2);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                switch(tempval)
                {
                    case "04":
                    {
                        this.Purpose.Type = (short) MISMO.Enums.LoanPurposeType.ConstructionOnly;
                        break;
                    }
                    case "05":
                    {
                        this.Purpose.Type = (short) MISMO.Enums.LoanPurposeType.Refinance;
                        break;
                    }
                    case "13":
                    {
                        this.Purpose.Type = (short) MISMO.Enums.LoanPurposeType.ConstructionToPermanent;
                        break;
                    }
                    case "15":
                    {
                        this.Purpose.Type = (short) MISMO.Enums.LoanPurposeType.Other;
                        break;
                    }
                    case "16":
                    {
                        this.Purpose.Type = (short) MISMO.Enums.LoanPurposeType.Purchase;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("02B", 8, 80);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                this.Purpose.OtherLoanPurposeDescription = tempval;
            }

            tempval = du.ExtractData("02B", 150, 8);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                this.Purpose.PropertyLeaseholdExpirationDate = du.ToDate(tempval);
            }

            tempval = du.ExtractData("02B", 149, 1);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                switch(tempval)
                {
                    case "1":
                    {
                        this.Purpose.PropertyRightsType = (short) MISMO.Enums.PropertyRightsType.FeeSimple;
                        break;
                    }
                    case "2":
                    {
                        this.Purpose.PropertyRightsType = (short) MISMO.Enums.PropertyRightsType.Leasehold;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("02B", 88, 1);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                switch(tempval)
                {
                    case "1":
                    {
                        this.Purpose.PropertyUsageType = (short) MISMO.Enums.PropertyUsageType.PrimaryResidence;
                        break;
                    }
                    case "2":
                    {
                        this.Purpose.PropertyUsageType = (short) MISMO.Enums.PropertyUsageType.SecondHome;
                        break;
                    }
                    case "D":
                    {
                        this.Purpose.PropertyUsageType = (short) MISMO.Enums.PropertyUsageType.Investor;
                        break;
                    }
                }
            }

            #endregion LOAN_PURPOSE

            #region LOAN_PURPOSE.CONSTRUCTION_REFINANCE_DATA

            // load up the construction refi data
            tempval = du.ExtractData("02D", 53, 15);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                this.Purpose.ConstructionRefinanceData.ConstructionImprovementCostsAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("02D", 68, 2);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                switch(tempval)
                {
                    case "F1":
                    {
                        this.Purpose.ConstructionRefinanceData.GSERefinancePurposeType = (short) MISMO.Enums.GSERefinancePurposeType.NoCashOutOther;
                        break;
                    }
                    case "01":
                    {
                        this.Purpose.ConstructionRefinanceData.GSERefinancePurposeType = (short) MISMO.Enums.GSERefinancePurposeType.CashOutOther;
                        break;
                    }
                    case "04":
                    {
                        this.Purpose.ConstructionRefinanceData.GSERefinancePurposeType = (short) MISMO.Enums.GSERefinancePurposeType.CashOutHomeImprovement;
                        break;
                    }
                    case "11":
                    {
                        this.Purpose.ConstructionRefinanceData.GSERefinancePurposeType = (short) MISMO.Enums.GSERefinancePurposeType.CashOutDebtConsolidation;
                        break;
                    }
                    case "13":
                    {
                        this.Purpose.ConstructionRefinanceData.GSERefinancePurposeType = (short) MISMO.Enums.GSERefinancePurposeType.CashOutLimited;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("02D", 38, 15);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                this.Purpose.ConstructionRefinanceData.LandEstimatedValueAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("02D", 8, 15);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                this.Purpose.ConstructionRefinanceData.LandOriginalCostAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("02D", 4, 4);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                this.Purpose.ConstructionRefinanceData.PropertyAcquiredYear = du.ToDate(tempval);
            }

            tempval = du.ExtractData("02D", 23, 15);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                this.Purpose.ConstructionRefinanceData.PropertyExistingLienAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("02D", 8, 15);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                this.Purpose.ConstructionRefinanceData.PropertyOriginalCostAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("02D", 151, 15);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                this.Purpose.ConstructionRefinanceData.RefinanceImprovementCostsAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("02D", 151, 15);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                switch(tempval)
                {
                    case "Y":
                    {
                        this.Purpose.ConstructionRefinanceData.RefinanceImprovementsType = (short) MISMO.Enums.RefinanceImprovementsType.Made;
                        break;
                    }
                    case "N":
                    {
                        this.Purpose.ConstructionRefinanceData.RefinanceImprovementsType = (short) MISMO.Enums.RefinanceImprovementsType.ToBeMade;
                        break;
                    }
                    case "U":
                    {
                        this.Purpose.ConstructionRefinanceData.RefinanceImprovementsType = (short) MISMO.Enums.RefinanceImprovementsType.Unknown;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("02D", 70, 80);
            if (tempval != string.Empty)
            {
                if (_purpose == null) _purpose = new AUS.LoanPurpose();
                if (_purpose._consrefidata == null) _purpose._consrefidata = new BusinessObjects.ConstructionRefinanceData();
                this.Purpose.ConstructionRefinanceData.RefinanceProposedImprovementsDescription = tempval;
            }

            #endregion LOAN_PURPOSE.CONSTRUCTION_REFINANCE_DATA

            #region LOAN_PRODUCT_DATA.LOAN_FEATURES
            // load the product data

            tempval = du.ExtractData("PCH", 7, 1);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.AssumabilityIndicator = (tempval == "Y");
            }

            tempval = du.ExtractData("LNC", 25, 1);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.BalloonIndicator = (tempval == "Y");
            }

            tempval = du.ExtractData("PCH", 4, 3);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.BalloonLoanMaturityTermMonths = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("LNC", 28, 1);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.CounselingConfirmationIndicator = (tempval == "Y");
            }

            // TODO: DownPaymentOptionType??
            //			tempval = du.ExtractData("LNC", 28, 1);
            //			if (tempval != string.Empty)
            //			{
            //				if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
            //				if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeature();
            //				switch(tempval)
            //				{
            //					case "":
            //					{
            //						this.ProductData.LoanFeatures.d = (tempval == "Y");
            //						break;
            //					}
            //				}
            //			}

            tempval = du.ExtractData("LNC", 58, 1);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.EscrowWaiverIndicator = (tempval == "Y");
            }

            tempval = du.ExtractData("LNC", 6, 2);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                switch(tempval)
                {
                    case "01":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.Detached;
                        break;
                    }
                    case "02":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.Attached;
                        break;
                    }
                    case "03":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.Condominium;
                        break;
                    }
                    case "04":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.PUD;
                        break;
                    }
                    case "05":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.Cooperative;
                        break;
                    }
                    case "07":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.HighRiseCondominium;
                        break;
                    }
                    case "08":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.ManufacturedHousing;
                        break;
                    }
                    case "09":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.DetachedCondominium;
                        break;
                    }
                    case "10":
                    {
                        this.ProductData.LoanFeatures.GSEPropertyType = (short) MISMO.Enums.GSEPropertyType.ManufacturedHomeCondominiumOrPUDOrCooperative;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("LNC", 4, 1);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                switch(tempval)
                {
                    case "1":
                    {
                        this.ProductData.LoanFeatures.LienPriorityType = (short) MISMO.Enums.LienPriorityType.FirstLien;
                        break;
                    }
                    case "2":
                    {
                        this.ProductData.LoanFeatures.LienPriorityType = (short) MISMO.Enums.LienPriorityType.SecondLien;
                        break;
                    }
                    case "F":
                    {
                        this.ProductData.LoanFeatures.LienPriorityType = (short) MISMO.Enums.LienPriorityType.Other;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("LNC", 5, 1);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                switch(tempval)
                {
                    case "A":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.Alternative;
                        break;
                    }
                    case "F":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.FullDocumentation;
                        break;
                    }
                    case "R":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.Reduced;
                        break;
                    }
                    case "B":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.StreamlineRefinance;
                        break;
                    }
                    case "C":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoDocumentation;
                        break;
                    }
                    case "D":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoRatio;
                        break;
                    }
                    // TODO try to verify mapping???
            //					case "E":
            //					{
            //						this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.;
            //						break;
            //					}
                    case "U":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoIncomeNoEmploymentNoAssetsOn1003;
                        break;
                    }
            //					case "G":
            //					{
            //						this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.no;
            //						break;
            //					}
                    case "J":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoIncomeOn1003;
                        break;
                    }
                    case "K":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoVerificationOfStatedIncomeEmploymentOrAssets;
                        break;
                    }
                    case "L":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoVerificationOfStatedIncomeOrAssests;
                        break;
                    }
                    case "M":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoVerificationOfStatedAssets;
                        break;
                    }
                    case "N":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoVerificationOfStatedIncomeOrEmployment;
                        break;
                    }
                    case "O":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.NoVerificationOfStatedIncome;
                        break;
                    }
                    case "P":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.VerbalVerificationOfEmployment;
                        break;
                    }
                    case "Q":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.OnePaystub;
                        break;
                    }
                    case "S":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.OnePaystubAndVerbalVerificationOfEmployment;
                        break;
                    }
                    case "T":
                    {
                        this.ProductData.LoanFeatures.LoanDocumentationType = (short) MISMO.Enums.LoanDocumentationType.OnePaystubAndOneW2AndVerbalVerificationOfEmploymentOrOneYear1040;
                        break;
                    }
                }
            } // end of loan documentation type

            tempval = du.ExtractData("PCH", 12, 2);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                switch(tempval)
                {
                    case "N":
                    {
                        this.ProductData.LoanFeatures.LoanRepaymentType = (short) MISMO.Enums.LoanRepaymentType.NoNegativeAmortization;
                        break;
                    }
                    case "F1":
                    {
                        this.ProductData.LoanFeatures.LoanRepaymentType = (short) MISMO.Enums.LoanRepaymentType.ScheduledAmortization;
                        break;
                    }
                    case "F2":
                    {
                        this.ProductData.LoanFeatures.LoanRepaymentType = (short) MISMO.Enums.LoanRepaymentType.InterestOnly;
                        break;
                    }
                    case "P":
                    {
                        this.ProductData.LoanFeatures.LoanRepaymentType = (short) MISMO.Enums.LoanRepaymentType.PotentialNegativeAmortization;
                        break;
                    }
                    case "S":
                    {
                        this.ProductData.LoanFeatures.LoanRepaymentType = (short) MISMO.Enums.LoanRepaymentType.ScheduledNegativeAmortization;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("LNC", 59, 8);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.LoanScheduledClosingDate = du.ToDate(tempval);
            }

            tempval = du.ExtractData("LNC", 75, 7);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.MICoveragePercent = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("LNC", 82, 3);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                switch(tempval)
                {
                    case "001":
                    {
                        this.ProductData.LoanFeatures.MICompanyNameType = (short) MISMO.Enums.MICompanyNameType.GECapitalMICorporation;
                        break;
                    }
                    case "006":
                    {
                        this.ProductData.LoanFeatures.MICompanyNameType = (short) MISMO.Enums.MICompanyNameType.MortgageGuarantyInsuranceCorporation;
                        break;
                    }
                    case "011":
                    {
                        this.ProductData.LoanFeatures.MICompanyNameType = (short) MISMO.Enums.MICompanyNameType.PMI_MICorporation;
                        break;
                    }
                    case "012":
                    {
                        this.ProductData.LoanFeatures.MICompanyNameType = (short) MISMO.Enums.MICompanyNameType.UnitedGuarantyCorporation;
                        break;
                    }
                    case "013":
                    {
                        this.ProductData.LoanFeatures.MICompanyNameType = (short) MISMO.Enums.MICompanyNameType.RepublicMICompany;
                        break;
                    }
                    case "017":
                    {
                        this.ProductData.LoanFeatures.MICompanyNameType = (short) MISMO.Enums.MICompanyNameType.RadianGuarantyIncorporated;
                        break;
                    }
                    case "024":
                    {
                        this.ProductData.LoanFeatures.MICompanyNameType = (short) MISMO.Enums.MICompanyNameType.TriadGuarantyInsuranceCorporation;
                        break;
                    }
                    case "038":
                    {
                        this.ProductData.LoanFeatures.MICompanyNameType = (short) MISMO.Enums.MICompanyNameType.CMG_MICompany;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("LNC", 18, 7);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.NegativeAmortizationLimitPercent = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("PCH", 8, 2);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                switch(tempval)
                {
                    case "01":
                    {
                        this.ProductData.LoanFeatures.PaymentFrequencyType = (short) MISMO.Enums.PaymentFrequencyType.Monthly;
                        break;
                    }
                    case "02":
                    {
                        this.ProductData.LoanFeatures.PaymentFrequencyType = (short) MISMO.Enums.PaymentFrequencyType.Biweekly;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("PCH", 10, 1);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.PrepaymentPenaltyIndicator = (tempval == "Y");
            }

            tempval = du.ExtractData("PCH", 11, 1);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.PrepaymentRestrictionIndicator = (tempval == "Y");
            }

            tempval = du.ExtractData("PID", 4, 30);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.ProductDescription = tempval;
            }

            tempval = du.ExtractData("PID", 34, 15);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.ProductName = tempval;
            }

            tempval = du.ExtractData("LNC", 67, 8);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._loanfeatures == null) _loanproductdata._loanfeatures = new BusinessObjects.LoanFeatures();
                this.ProductData.LoanFeatures.ScheduledFirstPaymentDate = du.ToDate(tempval);
            }

            #endregion LOAN_PRODUCT_DATA.LOAN_FEATURES

            #region TRANSACTION_DETAIL

            tempval = du.ExtractData("07A", 19, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.AlterationsImprovementsAndRepairsAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 109, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.BorrowerPaidDiscountPointsTotalAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 79, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.EstimatedClosingCostsAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 154, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.MIAndFundingFeeFinancedAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 94, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.MIAndFundingFeeTotalAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 64, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.PrepaidItemsEstimatedAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 4, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.PurchasePriceAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 49, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.RefinanceIncludingDebtsToBePaidOffAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("GOA", 20, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.SalesConcessionAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 139, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.SellerPaidClosingCostsAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("07A", 124, 15);
            if (tempval != string.Empty)
            {
                if (_transdetail == null) _transdetail = new AUS.TransactionDetail();
                this.TransactionDetail.SubordinateLienAmount = Convert.ToDecimal(tempval);
            }

            #endregion TRANSACTION_DETAIL

            #region LOAN_PRODUCT_DATA.ARM

            tempval = du.ExtractData("ARM", 4, 7);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._arm == null) _loanproductdata._arm = new BusinessObjects.ARM();
                this.ProductData.ARM.IndexCurrentValuePercent = Convert.ToDecimal(tempval) / 100;
            }

            tempval = du.ExtractData("ARM", 13, 7);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._arm == null) _loanproductdata._arm = new BusinessObjects.ARM();
                this.ProductData.ARM.IndexMarginPercent = Convert.ToDecimal(tempval) / 100;
            }

            tempval = du.ExtractData("ARM", 11, 2);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._arm == null) _loanproductdata._arm = new BusinessObjects.ARM();
                switch(tempval)
                {
                    case "0":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.WeeklyAverageConstantMaturingTreasury;
                        break;
                    }
                    case "1":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.MonthlyAverageConstantMaturingTreasury;
                        break;
                    }
                    case "2":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.WeeklyAverageTreasuryAuctionAverageInvestmentYield;
                        break;
                    }
                    case "3":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.WeeklyAverageTreasuryAuctionAverageBondDiscountYield;
                        break;
                    }
                    case "4":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.WeeklyAverageSecondaryMarketTreasuryBillInvestmentYield;
                        break;
                    }
                    case "5":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.DailyCertificateOfDepositRate;
                        break;
                    }
                    case "6":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.WeeklyAverageCertificateOfDepositRate;
                        break;
                    }
                    case "7":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.WeeklyAveragePrimeRate;
                        break;
                    }
                    case "8":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.TreasuryBillDailyValue;
                        break;
                    }
                    case "9":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.EleventhDistrictCostOfFunds;
                        break;
                    }
                    case "10":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.NationalMonthlyMedianCostOfFunds;
                        break;
                    }
                    case "11":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.WallStreetJournalLIBOR;
                        break;
                    }
                    case "12":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.FNM_LIBOR;
                        break;
                    }
                    case "13":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.FRE_LIBOR;
                        break;
                    }
                    case "14":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.NationalAverageContractRateFHLBB;
                        break;
                    }
                    case "15":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.FederalCostOfFunds;
                        break;
                    }
                    case "16":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.FNM60DayRequiredNetYield;
                        break;
                    }
                    case "17":
                    {
                        _loanproductdata._arm.IndexType = (short) MISMO.Enums.ARMIndexType.FRE60DayRequiredNetYield;
                        break;
                    }
                }
            }

            tempval = du.ExtractData("ARM", 20, 7);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._arm == null) _loanproductdata._arm = new BusinessObjects.ARM();
                this.ProductData.ARM.QualifyingRatePercent = Convert.ToDecimal(tempval) / 100;
            }

            tempval = du.ExtractData("LNC", 43, 15);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._arm == null) _loanproductdata._arm = new BusinessObjects.ARM();
                this.ProductData.ARM.PaymentAdjustmentLifetimeCapAmount = Convert.ToDecimal(tempval);
            }

            tempval = du.ExtractData("LNC", 36, 7);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._arm == null) _loanproductdata._arm = new BusinessObjects.ARM();
                this.ProductData.ARM.PaymentAdjustmentLifetimeCapPercent = Convert.ToDecimal(tempval) / 100;
            }

            tempval = du.ExtractData("LNC", 29, 7);
            if (tempval != string.Empty)
            {
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                if (_loanproductdata._arm == null) _loanproductdata._arm = new BusinessObjects.ARM();
                this.ProductData.ARM.RateAdjustmentLifetimeCapPercent = Convert.ToDecimal(tempval) / 100;
            }

            #endregion LOAN_PRODUCT_DATA.ARM

            #region LOAN_PRODUCT_DATA.RATE_ADJUSTMENT

            int rateadjustmentcount = du.BeginCapture("RAJ");
            if (rateadjustmentcount > 0)
            {
                MISMO.BusinessObjects.RateAdjustment raj = null;
                if (_loanproductdata == null) _loanproductdata = new AUS.LoanProductData();
                for(int i = 0; i<rateadjustmentcount; i++)
                {
                    raj = new BusinessObjects.RateAdjustment();

                    tempval = du.ExtractCaptureData(i, 29, 3);
                    if (tempval != string.Empty)
                        raj.FirstRateAdjustmentMonths = Convert.ToDecimal(tempval);

                    tempval = du.ExtractCaptureData(i, 14, 1);
                    switch(tempval)
                    {
                        case "0":
                        {
                            raj.CalculationType = (short) MISMO.Enums.RateAdjustmentCalculationType.AddPercentToCurrentRate;
                            break;
                        }
                        case "1":
                        {
                            raj.CalculationType = (short) MISMO.Enums.RateAdjustmentCalculationType.AddPercentToOriginalRate;
                            break;
                        }
                        case "2":
                        {
                            raj.CalculationType = (short) MISMO.Enums.RateAdjustmentCalculationType.IndexPlusMargin;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(i, 8, 3);
                    if (tempval != string.Empty)
                        raj.DurationMonths = Convert.ToDecimal(tempval);

                    tempval = du.ExtractCaptureData(i, 15, 7);
                    if (tempval != string.Empty)
                        raj.Percent = Convert.ToDecimal(tempval) / 100;

                    tempval = du.ExtractCaptureData(i, 4, 4);
                    if (tempval != string.Empty)
                        raj.PeriodNumber = Convert.ToDecimal(tempval);

                    tempval = du.ExtractCaptureData(i, 22, 7);
                    if (tempval != string.Empty)
                        raj.SubsequentCapPercent = Convert.ToDecimal(tempval) / 100;

                    tempval = du.ExtractCaptureData(i, 11, 3);
                    if (tempval != string.Empty)
                        raj.SubsequentRateAdjustmentMonths = Convert.ToDecimal(tempval);

                    if (raj.CalculationType != (short) Enums.RateAdjustmentCalculationType.Undefined)
                        _loanproductdata._rateadjustments.Add(raj);
                }
            }
            du.EndCapture();

            #endregion LOAN_PRODUCT_DATA.RATE_ADJUSTMENT

            #region PROPOSED_HOUSING_EXPENSE

            int propsedexpcount = du.BeginCapture("05H");
            if (propsedexpcount > 0)
            {
                MISMO.BusinessObjects.ProposedHousingExpense propexp = null;
                for(int i = 0; i<propsedexpcount; i++)
                {
                    propexp = new BusinessObjects.ProposedHousingExpense();

                    tempval = du.ExtractCaptureData(i, 14, 2);
                    switch(tempval)
                    {
                        case "25":
                        {
                            propexp.HousingExpenseType = (short) MISMO.Enums.HousingExpenseType.GroundRent;
                            break;
                        }
                        case "26":
                        {
                            propexp.HousingExpenseType = (short) MISMO.Enums.HousingExpenseType.FirstMortgagePrincipalAndInterest;
                            break;
                        }
                        case "22":
                        {
                            propexp.HousingExpenseType = (short) MISMO.Enums.HousingExpenseType.OtherMortgageLoanPrincipalAndInterest;
                            break;
                        }
                        case "01":
                        {
                            propexp.HousingExpenseType = (short) MISMO.Enums.HousingExpenseType.HazardInsurance;
                            break;
                        }
                        case "14":
                        {
                            propexp.HousingExpenseType = (short) MISMO.Enums.HousingExpenseType.RealEstateTax;
                            break;
                        }
                        case "02":
                        {
                            propexp.HousingExpenseType = (short) MISMO.Enums.HousingExpenseType.MI;
                            break;
                        }
                        case "06":
                        {
                            propexp.HousingExpenseType = (short) MISMO.Enums.HousingExpenseType.HomeownersAssociationDuesAndCondominiumFees;
                            break;
                        }
                        case "23":
                        {
                            propexp.HousingExpenseType = (short) MISMO.Enums.HousingExpenseType.OtherHousingExpense;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(i, 16, 15);
                    if (tempval != string.Empty)
                        propexp.PaymentAmount = Convert.ToDecimal(tempval);

                    this.ProposedHousingExpenses.Add(propexp);
                }
            }

            #endregion PROPOSED_HOUSING_EXPENSE

            #region BORROWER (nested elements)

            // iterate through all the borrowers and extract their respective data
            for(int i = 0, j= _borrowers.Count; i<j; i++)
            {
                MISMO.BusinessObjects.AUS.Borrower cborrower = _borrowers[i] as AUS.Borrower;

                #region BORROWER.CURRENT_INCOME

                int cincomecount = du.BeginCapture("05I", 4, 9, cborrower.SSN);
                MISMO.BusinessObjects.CurrentIncome cincome = null;

                if (cincomecount > 0)
                {
                    for(int k = 0; k<cincomecount; k++)
                    {
                        cincome = new BusinessObjects.CurrentIncome();

                        tempval = du.ExtractCaptureData(k, 13, 2);
                        switch(tempval)
                        {
                            case "F1":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryBasePay;
                                break;
                            }
                            case "07":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryRationsAllowance;
                                break;
                            }
                            case "F2":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryFlightPay;
                                break;
                            }
                            case "F3":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryHazardPay;
                                break;
                            }
                            case "02":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryClothesAllowance;
                                break;
                            }
                            case "04":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryQuartersAllowance;
                                break;
                            }
                            case "03":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryPropPay;
                                break;
                            }
                            case "F4":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryOverseasPay;
                                break;
                            }
                            case "F5":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryCombatPay;
                                break;
                            }
                            case "F6":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MilitaryVariableHousingAllowance;
                                break;
                            }
                            case "F7":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.AlimonyChildSupport;
                                break;
                            }
                            case "F8":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.NotesReceivableInstallment;
                                break;
                            }
                            case "41":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.Pension;
                                break;
                            }
                            case "42":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.SocialSecurity;
                                break;
                            }
                            case "30":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.MortgageDifferential;
                                break;
                            }
                            case "F9":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.Trust;
                                break;
                            }
                            case "M1":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.Unemployment;
                                break;
                            }
                            case "M2":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.AutomobileExpenseAccount;
                                break;
                            }
                            case "M3":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.FosterCare;
                                break;
                            }
                            case "M4":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.VABenefitsNonEducational;
                                break;
                            }
                            case "45":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.OtherTypesOfIncome;
                                break;
                            }
                            case "20":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.Base;
                                break;
                            }
                            case "09":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.Overtime;
                                break;
                            }
                            case "08":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.Bonus;
                                break;
                            }
                            case "10":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.Commissions;
                                break;
                            }
                            case "17":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.DividendsInterest;
                                break;
                            }
                            case "SI":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.SubjectPropertyNetCashFlow;
                                break;
                            }
                            case "33":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.NetRentalIncome;
                                break;
                            }
                            case "BI":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.OtherTypesOfIncome;
                                break;
                            }
                            case "MC":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.OtherTypesOfIncome;
                                break;
                            }
                            case "TC":
                            {
                                cincome.IncomeType = (short) MISMO.Enums.IncomeType.OtherTypesOfIncome;
                                break;
                            }
                        }

                        tempval = du.ExtractCaptureData(k, 15, 15);
                        if (tempval != string.Empty)
                            cincome.MonthlyTotalAmount = Convert.ToDecimal(tempval);

                        cborrower.CurrentIncomes.Add(cincome);
                    }
                }

                #endregion BORROWER.CURRENT_INCOME

                #region BORROWER.DECLARATION

                int brwdeclcount = du.BeginCapture("08A", 4, 9, cborrower.SSN);
                if (brwdeclcount > 0)
                {
                    // first create an instance of the declaration.
                    if (cborrower.Declaration == null) cborrower.Declaration = new AUS.Declaration();

                    tempval = du.ExtractCaptureData(0, 19, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.AlimonyChildSupportObligationIndicator = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 14, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.BankruptcyIndicator = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 20, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.BorrowedDownPaymentIndicator = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 22, 2);
                    switch(tempval)
                    {
                        case "01":
                        {
                            cborrower.Declaration.CitizenshipResidencyType = (short) MISMO.Enums.CitizenshipResidencyType.USCitizen;
                            break;
                        }
                        case "03":
                        {
                            cborrower.Declaration.CitizenshipResidencyType = (short) MISMO.Enums.CitizenshipResidencyType.PermanentResidentAlien;
                            break;
                        }
                        case "05":
                        {
                            cborrower.Declaration.CitizenshipResidencyType = (short) MISMO.Enums.CitizenshipResidencyType.NonPermanentResidentAlien;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(0, 21, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.CoMakerEndorserOfNoteIndicator = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 25, 1);
                    if (tempval != string.Empty && (tempval == "Y" || tempval == "N"))
                        cborrower.Declaration.HomeownerPastThreeYearsType = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 24, 1);
                    if (tempval != string.Empty && (tempval == "Y" || tempval == "N"))
                        cborrower.Declaration.IntentToOccupyType = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 17, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.LoanForeclosureOrJudgementIndicator = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 13, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.OutstandingJudgementsIndicator = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 16, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.PartyToLawsuitIndicator = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 18, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.PresentlyDelinquentIndicator = (tempval == "Y");

                    tempval = du.ExtractCaptureData(0, 27, 2);
                    switch(tempval)
                    {
                        case "01":
                        {
                            cborrower.Declaration.PriorPropertyTitleType = (short) MISMO.Enums.PriorPropertyTitleType.Sole;
                            break;
                        }
                        case "25":
                        {
                            cborrower.Declaration.PriorPropertyTitleType = (short) MISMO.Enums.PriorPropertyTitleType.JointWithSpouse;
                            break;
                        }
                        case "26":
                        {
                            cborrower.Declaration.PriorPropertyTitleType = (short) MISMO.Enums.PriorPropertyTitleType.JointWithOtherThanSpouse;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(0, 26, 1);
                    switch(tempval)
                    {
                        case "1":
                        {
                            cborrower.Declaration.PriorPropertyUsageType = (short) MISMO.Enums.PriorPropertyUsageType.PrimaryResidence;
                            break;
                        }
                        case "2":
                        {
                            cborrower.Declaration.PriorPropertyUsageType = (short) MISMO.Enums.PriorPropertyUsageType.SecondaryResidence;
                            break;
                        }
                        case "D":
                        {
                            cborrower.Declaration.PriorPropertyUsageType = (short) MISMO.Enums.PriorPropertyUsageType.Investment;
                            break;
                        }
                    }

                    tempval = du.ExtractCaptureData(0, 15, 1);
                    if (tempval != string.Empty)
                        cborrower.Declaration.PropertyForeclosedPastSevenYearsIndicator = (tempval == "Y");

                    du.EndCapture();

                    #region BORROWER.DECLARATION._EXPLANATION

                    int explanationcount = du.BeginCapture("08B", 4, 9, cborrower.SSN);
                    if (explanationcount > 0)
                    {
                        MISMO.BusinessObjects.Explanation expl = null;
                        for(int l = 0; l<explanationcount; l++)
                        {
                            expl = new MISMO.BusinessObjects.Explanation();

                            tempval = du.ExtractCaptureData(l, 15, 255);
                            if (tempval != string.Empty)
                            {
                                expl.Description = tempval;
                            }

                            tempval = du.ExtractCaptureData(l, 13, 2);
                            switch(tempval)
                            {
                                case "91":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.OutstandingJudgments;
                                    break;
                                }
                                case "92":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.DeclaredBankruptcyPastSevenYears;
                                    break;
                                }
                                case "93":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.DirectIndirectForeclosedPropertyPastSevenYears;
                                    break;
                                }
                                case "94":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.PartyToLawsuit;
                                    break;
                                }
                                case "95":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.ObligatedOnLoanForeclosedOrDeedInLieuOfJudgement;
                                    break;
                                }
                                case "96":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.DelinquencyOrDefault;
                                    break;
                                }
                                case "97":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.AlimonyChildSupport;
                                    break;
                                }
                                case "98":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.BorrowedDownPayment;
                                    break;
                                }
                                case "99":
                                {
                                    expl.Type = (short) MISMO.Enums.ExplanationType.CoMakerEndorserOnNote;
                                    break;
                                }
                            }

                            cborrower.Declaration.Explanations.Add(expl);
                        }
                    }

                    #endregion BORROWER.DECLARATION._EXPLANATION
                }

                #endregion BORROWER.DECLARATION

                #region ASSETS

                AUS.Asset assobj = null;

                // load standard assets
                int asscount = du.BeginCapture("06C", 4, 9, cborrower.SSN);
                if (asscount > 0)
                {
                    for(int n = 0; n<asscount; n++)
                    {
                        assobj = new AUS.Asset();

                        // first extract or try to determine the asset type
                        tempval = du.ExtractCaptureData(n, 13, 3);
                        switch(tempval)
                        {
                            case "03":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.CheckingAccount;
                                break;
                            }
                            case "F1":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.SaleOtherAssets;
                                break;
                            }
                            case "SG":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.SavingsAccount;
                                break;
                            }
                            case "F2":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.GiftsTotal;
                                break;
                            }
                            case "01":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.CertificateOfDepositTimeDeposit;
                                break;
                            }
                            case "F3":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.MoneyMarketFund;
                                break;
                            }
                            case "F4":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.MutualFund;
                                break;
                            }
                            case "05":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.Stock;
                                break;
                            }
                            case "06":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.Bond;
                                break;
                            }
                            case "F5":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.SecuredBorrowedFundsNotDeposited;
                                break;
                            }
                            case "F7":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.BridgeLoanNotDeposited;
                                break;
                            }
                            case "08":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.RetirementFund;
                                break;
                            }
                            case "F8":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.NetWorthOfBusinessOwned;
                                break;
                            }
                            case "11":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.TrustAccount;
                                break;
                            }
                            case "M1":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.OtherNonLiquidAssets;
                                break;
                            }
                            case "OL":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.OtherLiquidAssets;
                                break;
                            }
                            case "NE":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.PendingNetSaleProceedsFromRealEstateAssets;
                                break;
                            }
                            case "COH":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.CashOnHand;
                                break;
                            }
                            case "GE":
                            {
                                assobj.Type = (short) MISMO.Enums.AssetType.GiftsNotDeposited;
                                break;
                            }
                        }

                        tempval = du.ExtractCaptureData(n, 132, 30);
                        if (tempval != string.Empty)
                        {
                            assobj.AccountIdentifier = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 162, 15);
                        if (tempval != string.Empty)
                        {
                            assobj.CashOrMarketValueAmount = Convert.ToDecimal(tempval);
                        }

                        tempval = du.ExtractCaptureData(n, 16, 35);
                        if (tempval != string.Empty)
                        {
                            assobj.HolderName = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 51, 35);
                        if (tempval != string.Empty)
                        {
                            assobj.HolderStreetAddress = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 86, 35);
                        if (tempval != string.Empty)
                        {
                            assobj.HolderCity = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 121, 2);
                        if (tempval != string.Empty)
                        {
                            assobj.HolderState = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 123, 5);
                        if (tempval != string.Empty)
                        {
                            assobj.HolderPostalCode = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 128, 4);
                        if (tempval != string.Empty)
                        {
                            assobj.HolderPostalCode += "-" + tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 184, 80);
                        if (tempval != string.Empty)
                        {
                            assobj.OtherAssetTypeDescription = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 177, 7);
                        if (tempval != string.Empty)
                        {
                            assobj.StockBondMutualFundShareCount = Convert.ToDecimal(tempval);
                        }

                        // add the asset to the borrower
                        cborrower.Assets.Add(assobj);
                    }
                }

                // load life insurance assets
                asscount = du.BeginCapture("06B", 4, 9, cborrower.SSN);
                if (asscount > 0)
                {
                    for(int n = 0; n<asscount; n++)
                    {
                        assobj = new AUS.Asset();
                        assobj.Type = (short) MISMO.Enums.AssetType.LifeInsurance;

                        tempval = du.ExtractCaptureData(n, 13, 30);
                        if (tempval != string.Empty)
                        {
                            assobj.AccountIdentifier = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 43, 15);
                        if (tempval != string.Empty)
                        {
                            assobj.CashOrMarketValueAmount = Convert.ToDecimal(tempval);
                        }

                        tempval = du.ExtractCaptureData(n, 58, 15);
                        if (tempval != string.Empty)
                        {
                            assobj.LifeInsuranceFaceValueAmount = Convert.ToDecimal(tempval);
                        }
                    }
                }

                // load cash deposits assets
                asscount = du.BeginCapture("06A", 4, 9, cborrower.SSN);
                if (asscount > 0)
                {
                    for(int n = 0; n<asscount; n++)
                    {
                        assobj = new AUS.Asset();
                        assobj.Type = (short) MISMO.Enums.AssetType.EarnestMoneyCashDepositTowardPurchase;

                        tempval = du.ExtractCaptureData(n, 48, 15);
                        if (tempval != string.Empty)
                        {
                            assobj.CashOrMarketValueAmount = Convert.ToDecimal(tempval);
                        }

                        tempval = du.ExtractCaptureData(n, 13, 35);
                        if (tempval != string.Empty)
                        {
                            assobj.HolderName = tempval;
                        }
                    }
                }

                // load automobile assets
                asscount = du.BeginCapture("06D", 4, 9, cborrower.SSN);
                if (asscount > 0)
                {
                    for(int n = 0; n<asscount; n++)
                    {
                        assobj = new AUS.Asset();
                        assobj.Type = (short) MISMO.Enums.AssetType.Automobile;

                        tempval = du.ExtractCaptureData(n, 47, 15);
                        if (tempval != string.Empty)
                        {
                            assobj.CashOrMarketValueAmount = Convert.ToDecimal(tempval);
                        }

                        tempval = du.ExtractCaptureData(n, 13, 30);
                        if (tempval != string.Empty)
                        {
                            assobj.AutomobileMakeDescription = tempval;
                        }

                        tempval = du.ExtractCaptureData(n, 43, 4);
                        if (tempval != string.Empty)
                        {
                            assobj.AutomobileModelYear = du.ToDate(tempval);
                        }
                    }
                }

                #endregion ASSETS
            }

            #endregion BORROWER (nested elements)
        }