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); } }
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(); }