public void BindData()
{
LPWeb.BLL.PointFolders bllPF = new LPWeb.BLL.PointFolders();
var list = bllPF.GetList(" BranchId= " + BranchID.ToString() + " AND Enabled=1 AND LoanStatus=6 ");
ddlFolder.DataSource = list;
ddlFolder.DataTextField = "Name";
ddlFolder.DataValueField = "FolderId";
ddlFolder.DataBind();
if (FileId != 0)
{
LPWeb.BLL.PointFiles bllPointfiles = new LPWeb.BLL.PointFiles();
LPWeb.Model.PointFiles model = bllPointfiles.GetModel(FileId);
if (model != null)
{
txbFilename.Text = model.Name;
ddlFolder.SelectedValue = model.FolderId.ToString();
}
else
{
PageCommon.RegisterJsMsg(this.Page, "Missing required query string.", "Cancel();");
}
}
}
private void BindPoint(int FileID)
{
try
{
//btnExport.Enabled = false;
PointFiles file = new PointFiles();
LPWeb.Model.PointFiles fileModel = new LPWeb.Model.PointFiles();
fileModel = file.GetModel(iFileID);
if (fileModel == null)
{
return;
}
txbPointFileName.Text = fileModel.Name;
PointFolders folder = new PointFolders();
LPWeb.Model.PointFolders folderModel = new LPWeb.Model.PointFolders();
folderModel = folder.GetModel(fileModel.FolderId);
if (folderModel != null && folderModel.Name.Length > 0)
{
ddlPointFolder.Text = folderModel.Name;
}
if (txbPointFileName.Text.Length > 0 && ddlPointFolder.Text.Length > 0)
{
//btnExport.Enabled = true;
}
}
catch
{ }
}
private LPWeb.Model.PointFiles GetPointFileInfo(int iFileId)
{
PointFiles PointFilesMgr = new PointFiles();
LPWeb.Model.PointFiles PointFileInfo = PointFilesMgr.GetModel(this.iLoanID);
return(PointFileInfo);
}
private void BindPoint(int FileID)
{
try
{
//btnExport.Enabled = false;
PointFiles file = new PointFiles();
LPWeb.Model.PointFiles fileModel = new LPWeb.Model.PointFiles();
fileModel = file.GetModel(iFileID);
if (fileModel == null)
{
return;
}
txbPointFileName.Text = fileModel.Name;
PointFolders folder = new PointFolders();
if (fileModel.FolderId > 0)
{
LPWeb.Model.PointFolders folderModel = new LPWeb.Model.PointFolders();
folderModel = folder.GetModel(fileModel.FolderId);
if (folderModel != null && folderModel.Name.Length > 0)
{
ListItem item = new ListItem(folderModel.Name, folderModel.FolderId.ToString());
ddlPointFolder.Items.Insert(0, item);
}
ddlPointFolder.Enabled = false;
}
else
if (ddlPointFolder.Items.Count > 1)
{
ddlPointFolder.Enabled = true;
}
if (txbPointFileName.Text.Length > 0 && ddlPointFolder.Text.Length > 0)
{
if (!txbPointFileName.Text.ToUpper().EndsWith(".PRS") &&
!txbPointFileName.Text.ToUpper().EndsWith(".BRW"))
{
//btnExport.Enabled = false;
return;
}
string filename = System.IO.Path.GetFileName(txbPointFileName.Text);
if (txbPointFileName.Text.ToUpper().EndsWith(".PRS"))
{
txbPointFileName.Text = @"\PROSPECT\" + filename;
}
else
{
txbPointFileName.Text = @"\BORROWER\" + filename;
}
///btnExport.Enabled = true;
}
}
catch (Exception ex)
{
LPLog.LogMessage(ex.Message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
var filename = txbFilename.Text.Trim();
if (string.IsNullOrEmpty(filename) ||
(!filename.ToUpper().EndsWith(".PRS") && !filename.ToUpper().EndsWith(".BRW")))
{
PageCommon.AlertMsg(this.Page, "You have to specify a valid Point filename that ends with \".PRS\" or \".BRW\".");
return;
}
if (string.IsNullOrEmpty(filename) ||
filename.ToUpper().Replace(".PRS", "").Trim().Length == 0 || filename.ToUpper().Replace(".BRW", "").Trim().Length == 0)
{
PageCommon.AlertMsg(this.Page, "You have to specify a valid Point filename.");
return;
}
if (filename.ToUpper().EndsWith(".PRS"))
{
filename = "PROSPECT\\" + filename;
}
else if (filename.ToUpper().EndsWith(".BRW"))
{
filename = "BORROWER\\" + filename;
}
else
{
return;
}
LPWeb.BLL.PointFiles bllPointfiles = new LPWeb.BLL.PointFiles();
LPWeb.Model.PointFiles modelPointfile = new LPWeb.Model.PointFiles();
if (FileId == 0)
{
modelPointfile.FolderId = Convert.ToInt32(ddlFolder.SelectedValue);
modelPointfile.Name = filename;
bllPointfiles.Add(modelPointfile);
}
else
{
modelPointfile = bllPointfiles.GetModel(FileId);
if (modelPointfile == null)
{
return;
}
modelPointfile.FolderId = Convert.ToInt32(ddlFolder.SelectedValue);
modelPointfile.Name = filename;
bllPointfiles.UpdateBase(modelPointfile);
}
PageCommon.RegisterJsMsg(this.Page, "", " Cancel();");
}
protected void lnkImport_Click(object sender, EventArgs e)
{
// 加载PointFiles信息
LPWeb.Model.PointFiles PointFileInfo = this.GetPointFileInfo(this.iLoanID);
if (PointFileInfo == null || string.IsNullOrEmpty(PointFileInfo.Name) || PointFileInfo.FolderId <= 0)
{
PageCommon.WriteJsEnd(this, "Unable to sync with Point, missing Point filename or Point Folder.", PageCommon.Js_RefreshSelf);
return;
}
string sName = PointFileInfo.Name;
string sFolderId = PointFileInfo.FolderId.ToString();
ServiceManager sm = new ServiceManager();
using (LP2ServiceClient service = sm.StartServiceClient())
{
ImportLoansRequest req = new ImportLoansRequest();
req.hdr = new ReqHdr();
req.hdr.SecurityToken = "SecurityToken"; //todo:check dummy data
req.hdr.UserId = this.CurrUser.iUserID;
req.FileIds = new int[1] {
this.iLoanID
};
ImportLoansResponse respone = null;
try
{
respone = service.ImportLoans(req);
if (respone.hdr.Successful)
{
PageCommon.WriteJsEnd(this, "Synched with Point successfully.", PageCommon.Js_RefreshSelf);
}
else
{
PageCommon.WriteJsEnd(this, "Failed to sync with Point, reason:" + respone.hdr.StatusInfo, PageCommon.Js_RefreshSelf);
}
}
catch (System.ServiceModel.EndpointNotFoundException)
{
string sExMsg = string.Format("Failed to sync with Point, reason: Point Manager is not running.");
LPLog.LogMessage(LogType.Logerror, sExMsg);
PageCommon.WriteJsEnd(this, sExMsg, PageCommon.Js_RefreshSelf);
}
catch (Exception ex)
{
string sExMsg = string.Format("Failed to sync with Point, error: {0}", ex.Message);
LPLog.LogMessage(LogType.Logerror, sExMsg);
PageCommon.WriteJsEnd(this, sExMsg, PageCommon.Js_RefreshSelf);
}
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <LPWeb.Model.PointFiles> DataTableToList(DataTable dt)
{
List <LPWeb.Model.PointFiles> modelList = new List <LPWeb.Model.PointFiles>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LPWeb.Model.PointFiles model;
for (int n = 0; n < rowsCount; n++)
{
model = new LPWeb.Model.PointFiles();
if (dt.Rows[n]["FileId"].ToString() != "")
{
model.FileId = int.Parse(dt.Rows[n]["FileId"].ToString());
}
if (dt.Rows[n]["FolderId"].ToString() != "")
{
model.FolderId = int.Parse(dt.Rows[n]["FolderId"].ToString());
}
model.Name = dt.Rows[n]["Name"].ToString();
if (dt.Rows[n]["FirstImported"].ToString() != "")
{
model.FirstImported = DateTime.Parse(dt.Rows[n]["FirstImported"].ToString());
}
if (dt.Rows[n]["LastImported"].ToString() != "")
{
model.LastImported = DateTime.Parse(dt.Rows[n]["LastImported"].ToString());
}
if (dt.Rows[n]["Success"].ToString() != "")
{
if ((dt.Rows[n]["Success"].ToString() == "1") || (dt.Rows[n]["Success"].ToString().ToLower() == "true"))
{
model.Success = true;
}
else
{
model.Success = false;
}
}
model.CurrentImage = dt.Rows[n]["CurrentImage"].ToString();
model.PreviousImage = dt.Rows[n]["PreviousImage"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
protected void Page_Load(object sender, EventArgs e)
{
#region 校验页面参数
string sReturnUrl = "../Pipeline/ProspectPipelineSummaryLoan.aspx";
string sErrorMsg = "Failed to load this page: missing required query string.";
// FileID
bool bIsValid = PageCommon.ValidateQueryString(this, "FileID", QueryStringType.ID);
if (bIsValid == false)
{
PageCommon.WriteJsEnd(this, sErrorMsg, "window.parent.location.href='" + sReturnUrl + "'");
}
string sFileID = this.Request.QueryString["FileID"];
this.hfFileID.Value = sFileID;
try
{
this.iFileID = Convert.ToInt32(sFileID);
}
catch { }
#endregion
#region LoadbaseInfo
loanInfo = bllLoans.GetModel(iFileID);
if (loanInfo != null)
{
iBranchId = (loanInfo.BranchID == null) ? 0 : loanInfo.BranchID.Value;
}
pointFileInfo = bllPointFile.GetModel(iFileID);
iPointFolderId = (pointFileInfo == null || pointFileInfo.FolderId <= 0) ? 0 : pointFileInfo.FolderId;
if (iPointFolderId > 0)
{
pointFolderInfo = bllPointFolders.GetModel(pointFileInfo.FolderId);
}
#endregion
if (!IsPostBack)
{
BindData();
}
}
private bool UpdatePointNote(int fileId, DateTime dtNow, string senderName, out string err)
{
bool exported = false;
err = string.Empty;
try
{
LPWeb.BLL.PointFiles pfMgr = new PointFiles();
LPWeb.Model.PointFiles pfModel = pfMgr.GetModel(fileId);
if (pfModel == null || pfModel.FolderId <= 0 || string.IsNullOrEmpty(pfModel.Name) || string.IsNullOrEmpty(pfModel.CurrentImage))
{
exported = true;
return(exported);
}
var req = new AddNoteRequest
{
FileId = fileId,
Created = dtNow,//DateTime.Now,
NoteTime = dtNow,
Note = this.txtNote.Text.Trim(),
Sender = senderName,
hdr = new ReqHdr
{
UserId = this.CurrUser.iUserID
}
};
ServiceManager sm = new ServiceManager();
using (LP2ServiceClient client = sm.StartServiceClient())
{
AddNoteResponse res = client.AddNote(req);
exported = !res.hdr.Successful ? false : true;
err = res.hdr.StatusInfo;
}
}
catch (Exception ex)
{
return(exported);
}
return(exported);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateBase(LPWeb.Model.PointFiles model)
{
dal.UpdateBase(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LPWeb.Model.PointFiles model)
{
return(dal.Add(model));
}
private bool SaveLocal(ref string errMsg)
{
if (!string.IsNullOrEmpty(FileName) && FileName.Length > 0 && !FileName.ToUpper().EndsWith(".PRS") && !FileName.ToUpper().EndsWith(".BRW"))
{
errMsg = "The filename must end with “.PRS” or “.BRW”. ";
return(false);
}
try
{
#region Save BranchId
Loans bllLoans = new Loans();
LPWeb.Model.Loans loanInfo = new LPWeb.Model.Loans();
loanInfo = bllLoans.GetModel(iFileID);
if (loanInfo != null)
{
loanInfo.BranchID = BranchId;
bllLoans.Update(loanInfo);
}
#endregion
//Save Loan Officer
#region Loan Officer
LoanTeam bllLoanTeam = new LoanTeam();
Users bllUsers = new Users();
var loanOfficer = bllLoanTeam.GetLoanOfficer(iFileID);
var loanOfficerId = bllLoanTeam.GetLoanOfficerID(iFileID);
#region Loan Officer RolesID =loanOfficerRolesId
Roles bllRoles = new Roles();
int loanOfficerRolesId = 3;//default;
try
{
loanOfficerRolesId = bllRoles.GetModelList(" Name = 'Loan Officer' ").FirstOrDefault().RoleId;
}
catch { }
#endregion
if (LoanOfficerId != loanOfficerId)
{
var loanTeamInfo = bllLoanTeam.GetModel(iFileID, loanOfficerRolesId, loanOfficerId);
if (loanTeamInfo == null)
{
loanTeamInfo = new LPWeb.Model.LoanTeam();
}
else
{
bllLoanTeam.Delete(iFileID, loanOfficerRolesId, loanOfficerId);
}
loanTeamInfo.FileId = iFileID;
loanTeamInfo.RoleId = loanOfficerRolesId;
loanTeamInfo.UserId = LoanOfficerId;
bllLoanTeam.Add(loanTeamInfo);
}
#endregion
#region Local PointFile ----pointFileInfo and pointFolderInfo
PointFiles bllPointFile = new PointFiles();
PointFolders bllPointFolders = new PointFolders();
LPWeb.Model.PointFiles pointFileInfo = bllPointFile.GetModel(iFileID);
var IsAddPointFile = false;
if (pointFileInfo == null)
{
IsAddPointFile = true;
pointFileInfo = new LPWeb.Model.PointFiles();
}
else
{
IsAddPointFile = false;
}
pointFileInfo.FileId = iFileID;
if (FolderId > 0)
{
pointFileInfo.FolderId = FolderId;
}
if (FileName.Length > 0)
{
pointFileInfo.Name = FileName;
}
if (IsAddPointFile)
{
bllPointFile.Add(pointFileInfo);
}
else
{
bllPointFile.UpdateBase(pointFileInfo);
}
#endregion
}
catch (Exception ex)
{
errMsg = ex.Message;
return(false);
}
return(true);
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region get user input
string sFirstName = this.txtFirstName.Text.Trim();
string sLastName = this.txtLastName.Text.Trim();
string sEmail = this.txtEmail.Text.Trim();
string sCellPhone = this.txtCellPhone.Text.Trim();
string sHomePhone = this.txtHomePhone.Text.Trim();
string sWorkPhone = this.txtWorkPhone.Text.Trim();
string sDOB = this.txtBirthday.Text.Trim();
DateTime DOB;
DateTime DT = DateTime.Today;
DT = DateTime.Today.AddYears(-18);
if (sDOB != string.Empty)
{
if (DateTime.TryParse(sDOB, out DOB) == false)
{
PageCommon.AlertMsg(this, "Date of Birth is not a valid date format.");
return;
}
if (DOB > DT)
{
PageCommon.AlertMsg(this, "Date of Birth should be 18 years old.");
return;
}
}
string sLeadSource = string.Empty;
if (this.ddlLeadSource.SelectedIndex != 0)
{
sLeadSource = this.ddlLeadSource.SelectedValue;
}
string sReferralID = this.hdnReferralID.Value;
string sPurpose = this.ddlPurpose.SelectedValue;
string sLoanType = this.ddlType.SelectedValue;
string sProgram = string.Empty;
if (this.ddlProgram.SelectedIndex != 0)
{
sProgram = this.ddlProgram.SelectedValue;
}
string sAmount = this.txtAmount.Text.Trim();
decimal dAmount = 0;
if (sAmount != string.Empty)
{
Decimal da = 0;
if (Decimal.TryParse(sAmount, out da) == false)
{
PageCommon.AlertMsg(this, "Amount is not a valid value.");
return;
}
if (da > 9999999999999)
{
PageCommon.AlertMsg(this, "Amount is not a valid value.");
return;
}
dAmount = da;
}
string sRate = this.txtRate.Text.Trim();
decimal dRate = 0;
if (sRate != string.Empty)
{
dRate = Convert.ToDecimal(sRate);
}
#endregion
#region update Loans
Loans LoansMgr = new Loans();
LoansMgr.UpldateLoanInfo(this.iLoanID, sPurpose, sLoanType, sProgram, sAmount, sRate);
#endregion
#region update Contacts and Prospect
// get borrower info
DataTable BorrowerInfo = this.GetBorrowerInfo(this.iLoanID);
if (BorrowerInfo.Rows.Count > 0)
{
int iBorrowerID = Convert.ToInt32(BorrowerInfo.Rows[0]["ContactId"]);
Contacts ContactsMgr = new Contacts();
ContactsMgr.UpdateContactProspectInfo(iBorrowerID, sFirstName, sLastName, sEmail, sCellPhone, sHomePhone, sWorkPhone, sDOB, sLeadSource, sReferralID);
}
#endregion
#region WCF API UploadLoanInfo
// 加载PointFiles信息
LPWeb.Model.PointFiles PointFileInfo = this.GetPointFileInfo(this.iLoanID);
if (PointFileInfo != null && !string.IsNullOrEmpty(PointFileInfo.Name))
{
string sName = PointFileInfo.Name;
string sFolderId = PointFileInfo.FolderId.ToString();
if (sName != string.Empty && sFolderId != string.Empty)
{
string sError = string.Empty;
bool bResult = this.UploadLoanInfo(this.iLoanID, true, this.CurrUser.iUserID, out sError);
if (bResult == false)
{
PageCommon.WriteJsEnd(this, "Saved successfully, but failed to invoke API UploadLoanInfo: " + sError, PageCommon.Js_RefreshSelf);
return;
}
}
}
#endregion
// success
PageCommon.WriteJsEnd(this, "Saved successfully.", PageCommon.Js_RefreshSelf);
}
