/// <summary>
/// Bind Grid
/// </summary>
private void BindUserGrid()
{
int pageSize = AspNetPager1.PageSize;
int pageIndex = PageIndex;
string queryCondition = GenerateQueryCondition();
int recordCount = 0;
DataSet dsUserLists = null;
try
{
LPWeb.BLL.Users userMgr = new LPWeb.BLL.Users();
dsUserLists = userMgr.GetContactUserByContactID(pageSize, pageIndex, queryCondition, out recordCount, "FullName", 0);
AspNetPager1.PageSize = pageSize;
AspNetPager1.RecordCount = recordCount;
this.gvUserList.DataSource = null;
gvUserList.DataBind();
gvUserList.DataSource = dsUserLists;
gvUserList.DataBind();
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
sHasCreate = CurrUser.userRole.ContactMgmt.ToString().IndexOf('1') > -1 ? "1" : "0";
sHasModify = CurrUser.userRole.ContactMgmt.ToString().IndexOf('2') > -1 ? "1" : "0";
sHasDelete = CurrUser.userRole.ContactMgmt.ToString().IndexOf('3') > -1 ? "1" : "0";
sHasAssign = CurrUser.userRole.ContactMgmt.ToString().IndexOf('4') > -1 ? "1" : "0";
sHasView = CurrUser.userRole.ContactMgmt.ToString().IndexOf('5') > -1 ? "1" : "0";
sHasMerge = CurrUser.userRole.ContactMgmt.ToString().IndexOf('6') > -1 ? "1" : "0";
sHasAccessAllContacts = CurrUser.userRole.AccessAllContacts == false ? "0" : "1";
if (sHasDelete == "0")
{
//btnRemove.Enabled = false;
}
if (Request.Url != null)
{
FromURL = Request.Url.ToString();
}
if (!IsPostBack)
{
var bllUser = new LPWeb.BLL.Users();
AssignContactUser();
BindPageDefaultValues();
BindContactsGrid(GenerateQueryCondition());
}
}
private string GetUserName(int UserID)
{
LPWeb.BLL.Users user = new LPWeb.BLL.Users();
try
{
LPWeb.Model.Users model = user.GetModel(UserID);
return(model.LastName + ", " + model.FirstName);
}
catch
{
return(string.Empty);
}
}
protected void lbtnSendWeekly_Click(object sender, EventArgs e)
{
try
{
string ContactIDs = this.hfContactIDs.Value;
string[] Ids = ContactIDs.Split(",".ToCharArray());
string ReturnMessage = string.Empty;
foreach (string cid in Ids)
{
string ContactID = string.Empty;
if (cid.Contains("User"))
{
ContactID = cid.Replace("User", "");
LPWeb.BLL.Users blluser = new LPWeb.BLL.Users();
var userMod = blluser.GetModel(int.Parse(ContactID));
if (string.IsNullOrEmpty(userMod.EmailAddress))
{
PageCommon.AlertMsg(this, "The selected recipient " + userMod.LastName + "," + userMod.FirstName + " does not have an email address.");
return;
}
UpdateEmailSettings(0, int.Parse(ContactID), 2, true, 1);
}
else if (cid.Contains("Contract"))
{
ContactID = cid.Replace("Contract", "");
LPWeb.BLL.Contacts bllcontacts = new LPWeb.BLL.Contacts();
var contactMod = bllcontacts.GetModel(int.Parse(ContactID));
if (string.IsNullOrEmpty(contactMod.Email))
{
PageCommon.AlertMsg(this, "The selected recipient " + contactMod.LastName + "," + contactMod.FirstName + " does not have an email address.");
return;
}
UpdateEmailSettings(int.Parse(ContactID), 0, 2, true, 1);
}
}
PageCommon.WriteJsEnd(this, "The report has been scheduled successfully!", PageCommon.Js_RefreshSelf);
}
catch (Exception ex)
{
PageCommon.AlertMsg(this, "The operation is Failed .");
LPLog.LogMessage(LogType.Logerror, "Failed to schedule the report , exception: " + ex.Message);
PageCommon.WriteJsEnd(this, "Failed to schedule the report, error:" + ex.Message, PageCommon.Js_RefreshSelf);
}
}
private decimal GetRegionMgrCompRate(int UserID)
{
LPWeb.BLL.Users bllUsers = new LPWeb.BLL.Users();
LPWeb.Model.Users userInfo = bllUsers.GetModel(UserID);
if (userInfo != null && userInfo.RegionMgrComp != null)
{
return(userInfo.RegionMgrComp);
}
else
{
return(0.000M);
}
}
private void BindGrid()
{
//int pageSize = AspNetPager1.PageSize;
try
{
if (CurrUser != null)
{
LPWeb.BLL.Users users = new LPWeb.BLL.Users();
LPWeb.Model.Users u = users.GetModel(CurrUser.iUserID);
if (u != null)
{
//pageSize = u.LoansPerPage;
AspNetPager1.PageSize = u.LoansPerPage;
}
}
}
catch (Exception exception)
{
LPLog.LogMessage(exception.Message);
}
string sWhere = GetCondition();
this.MarketingActivitySqlDataSource.ConnectionString = LPWeb.DAL.DbHelperSQL.connectionString;
string sDbTable = "(select a.*,i.CategoryId, b.CampaignName, f.LastName +', '+ f.FirstName + case when ISNULL(f.MiddleName, '') != '' then ' '+ f.MiddleName else '' end as ClientName, "
+ " c.Status+'-'+Substring(d.Name,Charindex('\',d.Name,2)+1,len(d.Name)-Charindex('\',d.Name,2)) as LoanName, "
+ " g.LastName +', '+g.FirstName as StartedByName, h.Success, h.Error "
+ " from LoanMarketing as a inner join MarketingCampaigns as b on a.CampaignId=b.CampaignId "
+ " inner join MarketingCategory as i on b.CategoryId=i.CategoryId "
+ " inner join Loans as c on a.FileId=c.FileId "
+ " inner join PointFiles as d on c.FileId=d.FileId "
+ " inner join LoanContacts as e on d.FileId=e.FileId "
+ " inner join Contacts as f on e.ContactId=f.ContactId "
+ " left outer join Users as g on a.StartedBy=g.UserId "
+ " left outer join MarketingLog h on a.LoanMarketingId=h.LoanMarketingId) as t ";
this.MarketingActivitySqlDataSource.SelectParameters["DbTable"].DefaultValue = sDbTable;
int iRowCount1 = LPWeb.DAL.DbHelperSQL.Count(this.MarketingActivitySqlDataSource.SelectParameters["DbTable"].DefaultValue, sWhere);
this.AspNetPager1.RecordCount = iRowCount1;
this.MarketingActivitySqlDataSource.SelectParameters["Where"].DefaultValue = sWhere;
this.gridMarketingActivityList.DataBind();
}
protected void lbtnSendNow_Click(object sender, EventArgs e)
{
try
{
string ContactIDs = this.hfContactIDs.Value;
string[] Ids = ContactIDs.Split(",".ToCharArray());
string ReturnMessage = string.Empty;
foreach (string cid in Ids)
{
int ContactID = 0;
bool External = true;
if (cid.Contains("User"))
{
ContactID = int.Parse(cid.Replace("User", ""));
LPWeb.BLL.Users blluser = new LPWeb.BLL.Users();
var userMod = blluser.GetModel(ContactID);
if (string.IsNullOrEmpty(userMod.EmailAddress))
{
PageCommon.AlertMsg(this, "The selected recipient " + userMod.LastName + "," + userMod.FirstName + " does not have an email address.");
return;
}
External = true;
ReturnMessage += SendLSREmail(0, string.Empty, string.Empty, ContactID, userMod.EmailAddress, userMod.FirstName + " " + userMod.LastName, External, null);
//ReturnMessage = SendExternalReport(0,ContactID, External);
}
else if (cid.Contains("Contract"))
{
ContactID = int.Parse(cid.Replace("Contract", ""));
LPWeb.BLL.Contacts bllcontacts = new LPWeb.BLL.Contacts();
var contactMod = bllcontacts.GetModel(ContactID);
if (string.IsNullOrEmpty(contactMod.Email))
{
PageCommon.AlertMsg(this, "The selected recipient " + contactMod.LastName + "," + contactMod.FirstName + " does not have an email address.");
return;
}
External = true;
ReturnMessage += SendLSREmail(ContactID, contactMod.Email, contactMod.FirstName + ' ' + contactMod.LastName, 0, string.Empty, string.Empty, External, null);
//ReturnMessage = SendExternalReport(ContactID,0, External);
}
if (string.IsNullOrEmpty(ReturnMessage))
{
PageCommon.AlertMsg(this, "The report has been sent successfully!");
}
else
{
PageCommon.AlertMsg(this, "Failed to send the report, error:" + ReturnMessage);
return;
}
}
}
catch (Exception ex)
{
PageCommon.AlertMsg(this, "Failed to disable the selected contact role(s).");
LPLog.LogMessage(LogType.Logerror, "Failed to disable the selected contact role(s), exception: " + ex.Message);
PageCommon.AlertMsg(this, "Failed to send the report, error:" + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region 校验页面参数
if (this.Request.QueryString["CloseDialogCodes"] == null)
{
PageCommon.WriteJsEnd(this, "Missing required query string.", "try{window.parent.location.href=window.parent.location.href}catch{}");
}
string sCloseDialogCodes = this.Request.QueryString["CloseDialogCodes"].ToString() + ";";
bool bIsValid = PageCommon.ValidateQueryString(this, "FileID", QueryStringType.ID);
if (bIsValid == false)
{
PageCommon.WriteJsEnd(this, "Missing required query string.", sCloseDialogCodes);
}
string sFileID = this.Request.QueryString["FileID"].ToString();
this.iFileID = Convert.ToInt32(sFileID);
#endregion
#region 获取Borrower和Property信息
#region Property
LPWeb.BLL.Loans LoanManager = new LPWeb.BLL.Loans();
DataTable LoanInfo = LoanManager.GetLoanInfo(this.iFileID);
if (LoanInfo.Rows.Count == 0)
{
PageCommon.WriteJsEnd(this, "Invalid query string.", sCloseDialogCodes);
}
string sPropertyAddress = LoanInfo.Rows[0]["PropertyAddr"].ToString();
string sPropertyCity = LoanInfo.Rows[0]["PropertyCity"].ToString();
string sPropertyState = LoanInfo.Rows[0]["PropertyState"].ToString();
string sPropertyZip = LoanInfo.Rows[0]["PropertyZip"].ToString();
string sProperty = sPropertyAddress + ", " + sPropertyCity + ", " + sPropertyState + " " + sPropertyZip;
#endregion
#region Borrower
DataTable BorrowerInfo = LoanManager.GetBorrowerInfo(this.iFileID);
if (BorrowerInfo.Rows.Count == 0)
{
PageCommon.WriteJsEnd(this, "There is no Borrower in this loan.", sCloseDialogCodes);
}
string sFirstName = BorrowerInfo.Rows[0]["FirstName"].ToString();
string sMiddleName = BorrowerInfo.Rows[0]["MiddleName"].ToString();
string sLastName1 = BorrowerInfo.Rows[0]["LastName"].ToString();
string sBorrower = sLastName1 + ", " + sFirstName;
if (sMiddleName != string.Empty)
{
sBorrower += " " + sMiddleName;
}
this.lbBorrower.Text = sBorrower;
this.lbProperty.Text = sProperty;
#endregion
#endregion
#region 查询条件
string sWhere = string.Empty;
if (this.Request.QueryString["search"] == null) // 未设置查询条件
{
sWhere = " and (1=0)";
}
else
{
sWhere = "";
// Branch
if (this.Request.QueryString["Branch"] != null)
{
string sBranch = this.Request.QueryString["Branch"];
//gdc 20120621 #1794
sWhere += " And UserId IN ( SELECT u.UserId from Users as u ";
sWhere += " left outer join GroupUsers as c on u.UserId=c.UserID ";
sWhere += " left outer join Groups as d on c.GroupID=d.GroupId ";
sWhere += " left outer join Branches as e on d.BranchID=e.BranchId ";
sWhere += " where e.BranchId = " + sBranch;
sWhere += " ) ";
}
// Company
if (this.Request.QueryString["UserRole"] != null)
{
string sUserRole = this.Request.QueryString["UserRole"];
sWhere += " and RoleId=" + sUserRole;
}
// Last Name
if (this.Request.QueryString["LastName"] != null)
{
string sLastName = this.Request.QueryString["LastName"];
sWhere += " and LastName like '" + sLastName + "%'";
}
}
#endregion
#region 排序
string sOrderByField = "FullName";
if (this.Request.QueryString["OrderByField"] != null)
{
sOrderByField = this.Request.QueryString["OrderByField"];
}
string sOrderByType = "asc"; // default asc
if (this.Request.QueryString["OrderByType"] != null)
{
sOrderByType = this.Request.QueryString["OrderByType"];
if (sOrderByType != "asc" && sOrderByType != "desc")
{
sOrderByType = "asc";
}
}
#endregion
if (this.IsPostBack == false)
{
#region 加载Branch Filter
string sSql2 = string.Empty;
if (CurrUser.bIsCompanyExecutive)
{
sSql2 = "Select BranchId, [Name] from Branches where [Enabled]=1 order by [Name]";
}
else if (CurrUser.bIsRegionExecutive || CurrUser.bIsDivisionExecutive)
{
sSql2 = string.Format("select a.BranchID, b.Name from dbo.lpfn_GetUserBranches_Executive({0}) as a inner join Branches as b on a.BranchID=b.BranchId where b.Enabled=1 order by b.Name", CurrUser.iUserID);
}
else if (CurrUser.bIsBranchManager)
{
sSql2 = string.Format("select a.BranchID, b.Name from dbo.lpfn_GetUserBranches_Branch_Manager({0}) as a inner join Branches as b on a.BranchID=b.BranchId where b.Enabled=1 order by b.Name", CurrUser.iUserID);
}
else
{
sSql2 = string.Format("select a.BranchID, b.Name from dbo.lpfn_GetUserBranches({0}) as a inner join Branches as b on a.BranchID=b.BranchId where b.Enabled=1 order by b.Name", CurrUser.iUserID);
}
DataTable BranchList = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql2);
DataRow AllRow = BranchList.NewRow();
AllRow["BranchId"] = 0;
AllRow["Name"] = "All";
BranchList.Rows.InsertAt(AllRow, 0);
this.ddlBranch.DataSource = BranchList;
this.ddlBranch.DataBind();
#endregion
#region 加载User Role Filter
string sSql3 = "select RoleId, Name from Roles where Name in ('Branch Manager','Closer','Doc Prep', 'Jr Processor','Loan Officer','Loan Officer Assistant','Processor','Shipper','Underwriter') order by Name";
DataTable UserRoleList = LPWeb.DAL.DbHelperSQL.ExecuteDataTable(sSql3);
DataTable LoanRoleList = UserRoleList.Copy();
DataRow AllUserRoleRow = UserRoleList.NewRow();
AllUserRoleRow["RoleId"] = 0;
AllUserRoleRow["Name"] = "All";
UserRoleList.Rows.InsertAt(AllUserRoleRow, 0);
this.ddlUserRole.DataSource = UserRoleList;
this.ddlUserRole.DataBind();
#endregion
#region 加载Loan Role Filter
DataRow AllLoanRoleRow = LoanRoleList.NewRow();
AllLoanRoleRow["RoleId"] = 0;
AllLoanRoleRow["Name"] = "-- select --";
LoanRoleList.Rows.InsertAt(AllLoanRoleRow, 0);
this.ddlLoanRole.DataSource = LoanRoleList;
this.ddlLoanRole.DataBind();
#endregion
#region 加载Contact List
string sSql = "select * from ( "
+ "select a.UserId,a.LastName,dbo.lpfn_GetUserName(a.UserId) as FullName,' ' as BranchId, ' ' as BranchName,a.RoleId,b.Name as UserRole " //gdc 20120621 #1794
+ "from Users as a "
+ "left outer join Roles as b on a.RoleId=b.RoleId "
//+ "left outer join GroupUsers as c on a.UserId=c.UserID " //gdc 20120621 #1794
//+ "left outer join Groups as d on c.GroupID=d.GroupId " //gdc 20120621 #1794
//+ "left outer join Branches as e on d.BranchID=e.BranchId " //gdc 20120621 #1794
+ " where a.UserEnabled=1 and a.UserId not in (select UserID from LoanTeam where FileId=" + iFileID + ")) as m "
+ "where 1=1 " + sWhere;
#region get row count
int iRowCount = this.GetLoanTeamListRowCount(sSql, sWhere);
this.AspNetPager1.RecordCount = iRowCount;
#endregion
int iPageSize = this.AspNetPager1.PageSize;
int iPageIndex = 1;
if (this.Request.QueryString["PageIndex"] != null)
{
iPageIndex = Convert.ToInt32(this.Request.QueryString["PageIndex"]);
}
DataTable LoanTeamList = this.GetLoanTeamList(sSql, iRowCount, iPageSize, iPageIndex, sOrderByField, sOrderByType);
#region UserBranchInfo gdc 20120621 #1794
// Get user branch info
LPWeb.BLL.Users UsersManager = new LPWeb.BLL.Users();
DataTable dtUserBranch = new DataTable();
dtUserBranch = UsersManager.GetUserBranchInfo();
if (null != dtUserBranch)
{
foreach (DataRow item in LoanTeamList.Rows)
{
var nUserID = item["UserId"].ToString();
var sUserBranch = item["BranchName"].ToString();
// concatenates all user branch names, using "," between each name
StringBuilder sbBName = new StringBuilder();
DataRow[] drs = dtUserBranch.Select(string.Format("UserId={0}", nUserID));
if (null != drs)
{
foreach (DataRow row in drs)
{
if (sbBName.Length > 0)
{
sbBName.Append(", ");
}
sbBName.Append(row["Name"]);
}
}
//int nDisLen = 30;
//if (sbBName.Length > nDisLen)
//{
// lblBranch.ToolTip = sbBName.ToString();
// lblBranch.Text = sbBName.ToString().Substring(0, nDisLen) + "...";
//}
//else
// lblBranch.Text = sbBName.ToString();
item["BranchName"] = sbBName.ToString();
}
}
#endregion
#region set EmptyDataText
if (this.Request.QueryString["search"] == null)
{
this.gridLoanTeamList.EmptyDataText = "Please enter conditions and click Display.";
}
else
{
if (iRowCount == 0)
{
this.gridLoanTeamList.EmptyDataText = "There is no loan team by the conditions.";
}
}
#endregion
this.gridLoanTeamList.DataSource = LoanTeamList;
this.gridLoanTeamList.DataBind();
#endregion
}
}
public void BindData()
{
LPWeb.BLL.Loans bllLoans = new LPWeb.BLL.Loans();
LPWeb.BLL.LoanTeam bllLoanTeam = new LPWeb.BLL.LoanTeam();
LPWeb.BLL.Users bllUsers = new LPWeb.BLL.Users();
LPWeb.Model.Loans loanInfo = bllLoans.GetModel(LoanID);
DataTable LoanInfo_datatable = bllLoans.GetLoanInfo(LoanID);
decimal loanAmount = 0;
LoanPointFields LoanPointFieldsMgr = new LoanPointFields();
//LPWeb.Model.LoanPointFields PointFieldInfo = LoanPointFieldsMgr.GetPointFieldInfo(LoanID, 21017);
LPWeb.Model.LoanPointFields PointFieldInfo = LoanPointFieldsMgr.GetModel(LoanID, 21017);
if (PointFieldInfo != null && !string.IsNullOrEmpty(PointFieldInfo.CurrentValue))
{
decimal.TryParse(PointFieldInfo.CurrentValue, out loanAmount);
}
if (loanAmount <= 0 && LoanInfo_datatable != null && LoanInfo_datatable.Rows.Count > 0)
{
loanAmount = LoanInfo_datatable.Rows[0]["LoanAmount"] == DBNull.Value ? 0 : (decimal)LoanInfo_datatable.Rows[0]["LoanAmount"];
}
this.labLoanamount.Text = loanAmount.ToString("n2");
var list = new List <ViewCompDetail>();
var Lo = new ViewCompDetail();
Lo.Type = "Loan Officer";
var LOUserId = bllLoanTeam.GetLoanOfficerID(LoanID);
Lo.Name = bllLoanTeam.GetLoanOfficer(LoanID);
Lo.Rate = GetUserCompRate(LOUserId);
Lo.Amount = Lo.Rate * loanAmount / 100.00M;
list.Add(Lo);
loanInfo.BranchID = loanInfo.BranchID != null ? loanInfo.BranchID : 0;
var branchM = new ViewCompDetail();
branchM.Type = "Branch Manager";
LPWeb.BLL.BranchManagers bllbranM = new LPWeb.BLL.BranchManagers();
var branchUserId = 0;
var branchObj = bllbranM.GetModelList("BranchId =" + loanInfo.BranchID).FirstOrDefault();
if (branchObj != null)
{
branchUserId = branchObj.BranchMgrId;
}
LPWeb.Model.Users userBrM = bllUsers.GetModel(branchUserId);
if (userBrM != null && userBrM.UserId == branchUserId)
{
branchM.Name = userBrM.LastName + "," + userBrM.FirstName;
branchM.Rate = GetBranchMgrCompRate(LOUserId);
branchM.Amount = branchM.Rate * loanAmount / 100.00M;
}
list.Add(branchM);
loanInfo.DivisionID = loanInfo.DivisionID != null ? loanInfo.DivisionID : 0;
var divisionM = new ViewCompDetail();
divisionM.Type = "Division Manager";
LPWeb.BLL.DivisionExecutives bllDivM = new LPWeb.BLL.DivisionExecutives();
var DivMUserId = 0;
var divobj = bllDivM.GetModelList("DivisionId =" + loanInfo.DivisionID).FirstOrDefault();
if (divobj != null)
{
DivMUserId = divobj.ExecutiveId;
}
LPWeb.Model.Users userDivM = bllUsers.GetModel(DivMUserId);
if (userDivM != null && userDivM.UserId == DivMUserId)
{
divisionM.Name = userDivM.LastName + "," + userDivM.FirstName;
divisionM.Rate = GetDivisionMgrCompRate(LOUserId);
divisionM.Amount = divisionM.Rate * loanAmount / 100.00M;
}
list.Add(divisionM);
loanInfo.RegionID = loanInfo.RegionID != null ? loanInfo.RegionID : 0;
var RegionM = new ViewCompDetail();
RegionM.Type = "Region Manager";
LPWeb.BLL.RegionExecutives bllRegionM = new LPWeb.BLL.RegionExecutives();
var RegionMUserId = 0;
var regionObj = bllRegionM.GetModelList("RegionId =" + loanInfo.RegionID).FirstOrDefault();
if (regionObj != null)
{
RegionMUserId = regionObj.ExecutiveId;
}
LPWeb.Model.Users userRegionM = bllUsers.GetModel(RegionMUserId);
if (userRegionM != null && userRegionM.UserId == RegionMUserId)
{
RegionM.Name = userRegionM.LastName + "," + userRegionM.FirstName;
RegionM.Rate = GetRegionMgrCompRate(LOUserId);
RegionM.Amount = RegionM.Rate * loanAmount / 100.00M;
}
list.Add(RegionM);
gvCompDetail.DataSource = list;
gvCompDetail.DataBind();
}