private bool _Load(int loanID, string path) { this.iLoanID = loanID; clsCSVTable tbl = new clsCSVTable(path); if (loanID < tbl.Length()) { this.iPropertyID = Int32.Parse(tbl.Value(loanID, clsLoan.PropertyColumn)); this.iTitleHolderEntityID = Int32.Parse(tbl.Value(loanID, clsLoan.TitleHolderColumn)); this.iCoBorrowerEntityID = Int32.Parse(tbl.Value(loanID, clsLoan.CoBorrowerColumn)); this.iAcquisitionTitleCompanyEntityID = Int32.Parse(tbl.Value(loanID, clsLoan.TitleCompanyColumn)); this.iLenderEntityID = Int32.Parse(tbl.Value(loanID, clsLoan.LenderColumn)); this.dtMaturity = DateTime.Parse(tbl.Value(loanID, clsLoan.MaturityDateCoumn)); this.dtOrigination = DateTime.Parse(tbl.Value(loanID, clsLoan.OGDateColumn)); this.dRate = Double.Parse(tbl.Value(loanID, clsLoan.RateColumn)); this.dPenaltyRate = Double.Parse(tbl.Value(loanID, clsLoan.PenaltyRateColumn)); this.pProperty = new clsProperty(this.iPropertyID); this._LoadCashflows(); return(true); } else { return(false); } }
private bool _Load(int id, clsCSVTable tbl) { if (id < tbl.Length()) { this.iDocumentID = id; this.strName = tbl.Value(id, clsDocument.NameColumn); this.iPropertyID = Int32.Parse(tbl.Value(id, clsDocument.PropertyColumn)); this.tType = (clsDocument.Type)Int32.Parse(tbl.Value(id, clsDocument.TypeColumn)); return true; } else { return false; } }
public static List <string> AddressList() { List <string> returnValue = new List <string>(); clsCSVTable tbl = new clsCSVTable(clsProperty.strPropertyPath); int streetNumber; string streetName; // compile list as [street name] [8 digit street number] for (int i = 0; i < tbl.Length(); i++) { string s = tbl.Value(i, clsProperty.AddressColumn); streetNumber = Int32.Parse(System.Text.RegularExpressions.Regex.Match(s, @"\d+").Value); streetName = System.Text.RegularExpressions.Regex.Replace(s, streetNumber.ToString(), "").Trim(); returnValue.Add(streetName + " " + streetNumber.ToString("00000000")); } // sort list, so it's alphabetical by street name and then street number returnValue.Sort(); // put list back to [street number] [street name] for (int i = 0; i < returnValue.Count; i++) { streetNumber = Int32.Parse(returnValue[i].Substring(returnValue[i].Length - 8)); streetName = returnValue[i].Substring(0, returnValue[i].Length - 9); returnValue[i] = streetNumber.ToString() + " " + streetName; } return(returnValue); }
private bool _Load(int id) { clsCSVTable tbl = new clsCSVTable(clsDocument.strDocumentPath); if (id < tbl.Length()) { this.iDocumentID = id; this.strName = tbl.Value(id, clsDocument.NameColumn); this.iPropertyID = Int32.Parse(tbl.Value(id, clsDocument.PropertyColumn)); this.tType = (clsDocument.Type)Int32.Parse(tbl.Value(id, clsDocument.TypeColumn)); return(true); } else { return(false); } }
public static int IDFromAddress(string address) { clsCSVTable tbl = new clsCSVTable(clsProperty.strPropertyPath); int id = -1; for (int i = 0; i < tbl.Length(); i++) { if (tbl.Value(i, clsProperty.AddressColumn) == address) { id = i; } } return(id); }
private bool _Load(int id) { clsCSVTable tbl = new clsCSVTable(clsEntity.strEntityPath); if (id < tbl.Length()) { this.iEntityID = id; this.strName = tbl.Value(id, clsEntity.NameColumn); this.strAddress = tbl.Value(id, clsEntity.AddressColumn); this.strTown = tbl.Value(id, clsEntity.TownColumn); this.strState = tbl.Value(id, clsEntity.StateColumn); Console.WriteLine(tbl.Value(id, clsEntity.ZipCodeColumn)); this.iZipCode = Int32.Parse(tbl.Value(id, clsEntity.ZipCodeColumn)); this.strPhone = tbl.Value(id, clsEntity.PhoneNumberColumn); this.strContactName = tbl.Value(id, clsEntity.ContactNameColumn); this.strEmail = tbl.Value(id, clsEntity.ContactEmailColumn); return(true); } else { return(false); } }
private void _LoadCashflows(string path) { clsCSVTable tbl = new clsCSVTable(path); this.cfCashflows = new List <clsCashflow>(); int iCFLoanID; for (int i = 0; i < tbl.Length(); i++) { if (Int32.TryParse(tbl.Value(i, clsCashflow.LoanColumn), out iCFLoanID)) { if (iCFLoanID == this.iLoanID) { this.cfCashflows.Add(new clsCashflow(i, tbl)); } } } }
private bool _Load(int id, clsCSVTable tbl) { if (id < tbl.Length()) { this.iDocumentRecordID = id; this.dtAction = DateTime.Parse(tbl.Value(id, clsDocumentRecord.ActionDateColumn)); this.dtRecord = DateTime.Parse(tbl.Value(id, clsDocumentRecord.RecordDateColumn)); this.eStatus = (clsDocumentRecord.Status)Int32.Parse(tbl.Value(id, clsDocumentRecord.StatusColumn)); this.eTransmission = (clsDocumentRecord.Transmission)Int32.Parse(tbl.Value(id, clsDocumentRecord.TransmissionColumn)); this.iDocumentID = Int32.Parse(tbl.Value(id, clsDocumentRecord.DocumentColumn)); this.iSenderEntityID = Int32.Parse(tbl.Value(id, clsDocumentRecord.SenderColumn)); this.iReceiverEntityID = Int32.Parse(tbl.Value(id, clsDocumentRecord.ReceiverColumn)); return(true); } else { return(false); } }
private bool _Load(int transactionID, clsCSVTable tbl) { if (transactionID < tbl.Length()) { this.iTransactionID = transactionID; this.dtPayDate = DateTime.Parse(tbl.Value(transactionID, clsCashflow.TransactionDateColumn)); this.dtRecordDate = DateTime.Parse(tbl.Value(transactionID, clsCashflow.RecordDateColumn)); this.dtDeleteDate = DateTime.Parse(tbl.Value(transactionID, clsCashflow.DeleteDateColumn)); if (this.dtDeleteDate > new DateTime(2999, 12, 31)) { this.dtDeleteDate = DateTime.MaxValue; } this.dAmount = Double.Parse(tbl.Value(transactionID, clsCashflow.AmountColumn)); this.iLoanID = Int32.Parse(tbl.Value(transactionID, clsCashflow.LoanColumn)); this.eTypeID = (clsCashflow.Type)Int32.Parse(tbl.Value(transactionID, clsCashflow.TransactionTypeColumn)); this.bActual = Boolean.Parse(tbl.Value(transactionID, clsCashflow.ActualColumn)); this.strComment = tbl.Value(transactionID, clsCashflow.CommentColumn); return(true); } else { return(false); } }
public static int LoanID(string address) { clsCSVTable tblLoans = new clsCSVTable(clsLoan.strLoanPath); int loanID = -1; // Find PropertyID from Address First int propertyID = clsProperty.IDFromAddress(address); if (propertyID == -1) { return(-1); } // Now match propertyID to the loan for (int i = 0; i < tblLoans.Length(); i++) { if (tblLoans.Value(i, clsLoan.PropertyColumn) == propertyID.ToString()) { loanID = i; } } return(loanID); }
private bool _Load(int loanRecordingID, clsCSVTable tbl) { this.iRecordingID = loanRecordingID; if (loanRecordingID < tbl.Length()) { this.iRecordingID = Int32.Parse(tbl.Value(loanRecordingID, clsLoanRecording.IndexColumn)); this.iBook = Int32.Parse(tbl.Value(loanRecordingID, clsLoanRecording.BookColumn)); this.iPage = Int32.Parse(tbl.Value(loanRecordingID, clsLoanRecording.PageColumn)); this.iInstrument = Int32.Parse(tbl.Value(loanRecordingID, clsLoanRecording.InstrumentColumn)); this.iParcel = Int32.Parse(tbl.Value(loanRecordingID, clsLoanRecording.ParcelColumn)); this.dtRecording = DateTime.Parse(tbl.Value(loanRecordingID, clsLoanRecording.RecordingDateColumn)); return(true); } else { return(false); } }
private bool _Load(int propertyID, clsCSVTable tbl) { if (propertyID < tbl.Length()) { this.iPropertyID = propertyID; this.strAddress = tbl.Value(propertyID, clsProperty.AddressColumn); this.strTown = tbl.Value(propertyID, clsProperty.TownColumn); this.strCounty = tbl.Value(propertyID, clsProperty.CountyColumn); this.strState = tbl.Value(propertyID, clsProperty.StateColumn); if (!double.TryParse(tbl.Value(propertyID, clsProperty.BPOColumn), out this.dBPO)) { this.dBPO = 0; } // this.dBPO = Double.Parse(tbl.Value(propertyID, clsProperty.BPOColumn)); this.strNickname = tbl.Value(propertyID, clsProperty.NickNameColumn); return(true); } else { return(false); } }