public bool Reload(EllieMae.Encompass.Client.Session session) => throw new NotImplementedException();
public Session login()
{
s = new Session();
s.Start(server, loginName, password);
return(s);
}
private void BatchUpdater()
{
Loan loan = EncompassApplication.CurrentLoan;
//EncompassApplication.Session.Start()
//EncompassApplication.CurrentLoan.Session.StartInstance()
//var sessionStart = new EncompassApplication.CurrentLoan.Session;
Session sessionStart = new Session();
sessionStart.Start("https://TEBE11147866.ea.elliemae.net$TEBE11147866", "admin", "Y0uT@lk!ngT0M3?");
String currentUser = EncompassApplication.Session.UserID;
string repAddress = loan.Fields["CX.PC.BATCH.NAME"].Value.ToString() + ".csv";
//Excel prep and call
Microsoft.Office.Interop.Excel.Application userApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook userWorkbook = userApp.Workbooks.Open(@"\\ftwfs02\Groups\LLS-Scanned\Bulk Updating\Encompass Bulk Update Templates\" + repAddress);
Microsoft.Office.Interop.Excel._Worksheet userWorksheet = userWorkbook.Sheets[1];
Microsoft.Office.Interop.Excel.Range userRange = userWorksheet.UsedRange;
//userWorksheet.Cells.NumberFormat = "General";
try
{
//set shortcut for loan call
//Loan loan = EncompassApplication.CurrentLoan;
//row/column setup
int rCnt = 1;
int cCnt = 1;
int rowCount = userRange.Rows.Count;
int colCount = userRange.Columns.Count;
List <BatchUpdatePC> bUpdate = CDO.BatchUpdatePC.ToList();
string r1c2string = "";
string r1c3string = "";
string r1c4string = "";
string r1c5string = "";
string r1c6string = "";
//var batchT = loan.Fields["CX.PC.BATCH.TYPE"].Value;
//string batchType = batchT.ToString();
DateTime dateRan = new DateTime();
dateRan = DateTime.Now;
double colData1 = 0;
string colDatSt = colData1.ToString();
cCnt++;
var r1c2 = userWorksheet.Cells[rCnt, cCnt].Value2;
r1c2string = r1c2.ToString();
cCnt++;
var r1c3 = userWorksheet.Cells[rCnt, cCnt].Value2;
if (r1c3 != null)
{
r1c3string = r1c3.ToString();
cCnt++;
}
else
{
r1c3string = "null";
cCnt++;
}
var r1c4 = userWorksheet.Cells[rCnt, cCnt].Value2;
if (r1c4 != null)
{
r1c4string = r1c4.ToString();
cCnt++;
}
else
{
r1c4string = "null";
cCnt++;
}
var r1c5 = userWorksheet.Cells[rCnt, cCnt].Value2;
if (r1c5 != null)
{
r1c5string = r1c5.ToString();
cCnt++;
}
else
{
r1c5string = "";
cCnt++;
}
var r1c6 = userWorksheet.Cells[rCnt, cCnt].Value2;
if (r1c6 != null)
{
r1c6string = r1c6.ToString();
cCnt++;
}
else
{
r1c6string = "";
cCnt++;
}
cCnt = 1;
foreach (BatchUpdatePC item in bUpdate)
{
if (item.RepName.ToLower() == loan.Fields["CX.PC.BATCH.NAME"].Value.ToString().ToLower())
{
if (r1c2string.ToLower() != item.Col2.ToLower() | r1c3string.ToLower() != item.Col3.ToLower() | r1c4string.ToLower() != item.Col4.ToLower() | r1c5string.ToLower() != item.Col5.ToLower())
{
MessageBox.Show("This does not appear to be the correct format for this report. Please review each column in the Excel spreadsheet for accuracy.");
loan.Fields["CX.PC.BATCH.IRON.MOUNTAIN"].Value = "Fail";
}
else
{
rCnt = 2;
cCnt = 2;
var colData2 = userWorksheet.Cells[rCnt, cCnt].Text;
string colData2string = "";
cCnt++;
var colData3 = userWorksheet.Cells[rCnt, cCnt].Text;
string colData3string = "";
cCnt++;
var colData4 = userWorksheet.Cells[rCnt, cCnt].Text;
string colData4string = "";
cCnt++;
var colData5 = userWorksheet.Cells[rCnt, cCnt].Text;
string colData5string = "";
cCnt++;
var colData6 = userWorksheet.Cells[rCnt, cCnt].Text;
string colData6string = "";
cCnt = 1;
for (rCnt = 2; rCnt <= rowCount; rCnt++)
{
if (userWorksheet.Cells[rCnt, cCnt].Value2 is null)
{
break;
}
colData1 = (double)userWorksheet.Cells[rCnt, cCnt].Value2;
colDatSt = colData1.ToString();
if (colData1.ToString().Substring(0, 1) == "6")
{
colDatSt = "00" + colDatSt;
colData1 = Convert.ToDouble(colDatSt);
}
cCnt++;
colData2 = userWorksheet.Cells[rCnt, cCnt].Text;
colData2string = colData2.ToString();
//Additional columns as needed
cCnt++;
colData3 = userWorksheet.Cells[rCnt, cCnt].Text;
if (colData3 != "")
{
colData3string = colData3.ToString();
cCnt++;
}
colData4 = userWorksheet.Cells[rCnt, cCnt].Text;
if (colData4 != "")
{
colData4string = colData4.ToString();
cCnt++;
}
colData5 = userWorksheet.Cells[rCnt, cCnt].Text;
if (colData5 != "")
{
colData5string = colData5.ToString();
cCnt++;
}
colData6 = userWorksheet.Cells[rCnt, cCnt].Text;
if (colData6 != "")
{
colData6string = colData6.ToString();
cCnt++;
}
cCnt = 1;
StringFieldCriterion cri = new StringFieldCriterion();
cri.FieldName = "Loan.LoanNumber";
cri.Value = colDatSt;
BatchUpdate batch = new BatchUpdate(cri);
batch.Fields.Add(r1c2string, colData2string);
if (colData3string != "")
{
batch.Fields.Add(r1c3string, colData3string);
}
if (colData4string != "")
{
batch.Fields.Add(r1c4string, colData4string);
}
if (colData5string != "")
{
batch.Fields.Add(r1c5string, colData5string);
}
if (colData6string != "")
{
batch.Fields.Add(r1c6string, colData6string);
}
batch.Fields.Add("CX.PC.BATCH.COLL.TRACK", currentUser);
batch.Fields.Add("CX.PC.BATCH.COL.DATE", dateRan);
loan.Fields["CX.PC.BATCH.IRON.MOUNTAIN"].Value = "Fail";
EllieMae.Encompass.Automation.EncompassApplication.Session.Loans.SubmitBatchUpdate(batch);
loan.Fields["CX.PC.BATCH.IRON.MOUNTAIN"].Value = "Success";
}
}
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong. Please click YES to save on the next popup, rebuild the spreadsheet and run the Batch Update again.");
}
finally
{
string fileName = @"\\ftwfs02\Groups\LLS-Scanned\Bulk Updating\Encompass Bulk Update Templates\" + repAddress;
//string folder = System.IO.Path.GetDirectoryName(fileName);
//if (System.IO.Directory.Exists(folder))
//{
//MessageBox.Show(loan.Fields["CX.PC.BATCH.IRON.MOUNTAIN"].Value.ToString());
userWorkbook.Close(true, fileName, null);
//}
userApp.Quit();
Marshal.ReleaseComObject(userWorksheet);
Marshal.ReleaseComObject(userWorkbook);
Marshal.ReleaseComObject(userApp);
sessionStart.End();
}
//userRange.Delete(XlDeleteShiftDirection.xlShiftUp);
//string fileName = @"H:\Encompass Support\Batch_Updater2.csv";
//string folder = System.IO.Path.GetDirectoryName(fileName);
//if (System.IO.Directory.Exists(folder))
//{
// userWorkbook.Close(true, fileName, null);
//}
//userApp.Quit();
//Marshal.ReleaseComObject(userWorksheet);
//Marshal.ReleaseComObject(userWorkbook);
//Marshal.ReleaseComObject(userApp);
//newSession.End();
}
