protected void Page_Load(object sender, EventArgs e)
{
SessionBo.CheckSession();
uservo = (UserVo)Session["userVo"];
advisevo = (AdvisorVo)Session["advisorVo"];
AdvisorStaffBo adviserstaffbo = new AdvisorStaffBo();
advrm = adviserstaffbo.GetAdvisorStaff(uservo.UserId);
adviserstaffsmtpvo.RMId = advrm.RMId;
if (!IsPostBack)
{
//if (trInsertMessage.Visible == true)
// trInsertMessage.Visible = false;
AdviserStaffSMTPBo advstaffsmtpbo = new AdviserStaffSMTPBo();
adviserstaffsmtpvo = advstaffsmtpbo.GetSMTPCredentials(advrm.RMId);
txtEmail.Text = adviserstaffsmtpvo.Email;
if (!String.IsNullOrEmpty(adviserstaffsmtpvo.Password))
{
txtPassword.Attributes.Add("value", Encryption.Decrypt(adviserstaffsmtpvo.Password));
}
txtSMTPHost.Text = adviserstaffsmtpvo.HostServer;
txtSMTPPort.Text = adviserstaffsmtpvo.Port;
chkAthenticationRequired.Checked = Convert.ToBoolean(adviserstaffsmtpvo.IsAuthenticationRequired);
}
string a = txtPassword.Text;
}
public int CountAdvisorStaff()
{
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
List <RMVo> advisorStaffList = null;
int count;
try
{
advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId);
count = advisorStaffList.Count;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorDashBoard.ascx:CountAdvisorStaff()");
object[] objects = new object[2];
objects[0] = advisorStaffBo;
objects[1] = advisorStaffList;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
return(count);
}
protected void Page_Load(object sender, EventArgs e)
{
SessionBo.CheckSession();
UserVo userVo = new UserVo();
RMVo rmVo = new RMVo();
//userType = Session["UserType"].ToString().ToLower();
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
AdvisorBranchVo advisorBranchVo = new AdvisorBranchVo();
AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo();
int branchId;
userVo = (UserVo)Session["userVo"];
rmVo = advisorStaffBo.GetAdvisorStaff(userVo.UserId);
rmId = rmVo.RMId;
Session["rmVo"] = rmVo;
branchId = advisorBranchBo.GetBranchId(rmVo.RMId);
advisorBranchVo = advisorBranchBo.GetBranch(branchId);
Session["advisorBranchVo"] = advisorBranchVo;
if (!IsPostBack)
{
BindBranchDropDown();
bindGrid(0, int.Parse(ddlBMBranch.SelectedValue.ToString()), 1);
bindChart(0, int.Parse(ddlBMBranch.SelectedValue.ToString()), 1);
}
}
private void BindRMDropDown()
{
try
{
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
DataTable dt = advisorStaffBo.GetAdviserRM(advisorId);
if (dt.Rows.Count > 0)
{
ddlRM.DataSource = dt;
ddlRM.DataValueField = dt.Columns["AR_RMId"].ToString();
ddlRM.DataTextField = dt.Columns["RMName"].ToString();
ddlRM.DataBind();
}
ddlRM.Items.Insert(0, new System.Web.UI.WebControls.ListItem("All", "2"));
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RMAMCSchemewiseMIS.ascx:BindRMDropDown()");
object[] objects = new object[0];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void btnSaveChanges_Click(object sender, EventArgs e)
{
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
RMVo rmvo = new RMVo();
UserBo userBo = new UserBo();
try
{
if (Validation())
{
rmvo.RMId = rmVo.RMId;
userVo.Email = txtEmail.Text.ToString();
userVo.FirstName = txtFirstName.Text.ToString();
userVo.LastName = txtLastName.Text.ToString();
userVo.MiddleName = txtMiddleName.Text.ToString();
userBo.UpdateUser(userVo);
rmvo.Email = txtEmail.Text.ToString();
rmvo.Fax = int.Parse(txtPhDirectPhoneNumber2.Text.ToString());
rmvo.OfficePhoneDirectNumber = int.Parse(txtPhDirectPhoneNumber.Text.ToString());
rmvo.OfficePhoneExtNumber = int.Parse(txtPhDirectPhoneNumber0.Text.ToString());
rmvo.ResPhoneNumber = int.Parse(txtPhDirectPhoneNumber1.Text.ToString());
rmvo.FaxIsd = int.Parse(txtPhDirectISD2.Text.ToString());
rmvo.OfficePhoneDirectIsd = txtPhDirectISD.Text.ToString();
rmvo.OfficePhoneExtIsd = txtPhDirectISD0.Text.ToString();
rmvo.ResPhoneIsd = int.Parse(txtPhDirectISD1.Text.ToString());
rmvo.FaxStd = int.Parse(txtPhDirectSTD2.Text.ToString());
rmvo.OfficePhoneDirectStd = txtPhDirectSTD.Text.ToString();
rmvo.OfficePhoneExtStd = txtPhDirectSTD0.Text.ToString();
rmvo.ResPhoneStd = int.Parse(txtPhDirectSTD1.Text.ToString());
rmvo.FirstName = userVo.FirstName.ToString();
rmvo.LastName = userVo.MiddleName.ToString();
rmvo.MiddleName = userVo.LastName.ToString();
rmvo.Mobile = int.Parse(txtMobileNumber.Text.ToString());
advisorStaffBo.UpdateStaff(rmvo);
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RMEditProfile.ascx.cs:btnSaveChanges_Click()");
object[] objects = new object[2];
objects[0] = rmVo;
objects[1] = userVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public void setAdvisorStaff()
{
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
List <RMVo> advisorStaffList = null;
RMVo rmVo = null;
try
{
advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId);
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("Sl.No.");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("Email");
DataRow drAdvisorStaff;
for (int i = 0; i < advisorStaffList.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
rmVo = new RMVo();
rmVo = advisorStaffList[i];
drAdvisorStaff[0] = (i + 1).ToString();
drAdvisorStaff[1] = rmVo.FirstName.ToString() + rmVo.MiddleName.ToString() + rmVo.LastName.ToString();
drAdvisorStaff[2] = rmVo.Email.ToString();
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
dtAdvisorStaff.Columns[1].ColumnMapping = MappingType.Hidden;
gvAdvisorRm.DataSource = dtAdvisorStaff;
gvAdvisorRm.DataBind();
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AdvisorDashBoard.ascx:setAdvisorStaff()");
object[] objects = new object[4];
objects[0] = advisorStaffBo;
objects[1] = advisorStaffList;
objects[2] = advisorVo;
objects[3] = rmVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void sortGridViewRM(string sortExpression, string direction)
{
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
List <RMVo> advisorStaffList = null;
RMVo rmVo = null;
DataTable dtAdvisorStaff = new DataTable();
DataRow drAdvisorStaff;
try
{
advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId);
dtAdvisorStaff.Columns.Add("Sl.No.");
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("RM Name");
dtAdvisorStaff.Columns.Add("Email");
for (int i = 0; i < advisorStaffList.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
rmVo = new RMVo();
rmVo = advisorStaffList[i];
drAdvisorStaff[0] = (i + 1).ToString();
drAdvisorStaff[1] = rmVo.UserId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + rmVo.MiddleName.ToString() + rmVo.LastName.ToString();
drAdvisorStaff[3] = rmVo.Email.ToString();
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
DataView dv = new DataView(dtAdvisorStaff);
dv.Sort = sortExpression + direction;
//dv.Sort = (string)ViewState["sortExpression"];
gvRMList.DataSource = dv;
gvRMList.DataBind();
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewRM.ascx.cs:sortGridViewRM()");
object[] objects = new object[2];
objects[1] = rmVo;
objects[2] = advisorStaffList;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void Page_Load(object sender, EventArgs e)
{
SessionBo.CheckSession();
userVo = (UserVo)Session["userVo"];
adviserVo = (AdvisorVo)Session["advisorVo"];
AdvisorStaffBo adviserstaffbo = new AdvisorStaffBo();
advrm = adviserstaffbo.GetAdvisorStaff(userVo.UserId);
adviserstaffsmtpvo.RMId = advrm.RMId;
BindSMSProvider();
BindAPIProvider();
if (!IsPostBack)
{
//if (trInsertMessage.Visible == true)
// trInsertMessage.Visible = false;
adviserstaffsmtpvo = advstaffsmtpbo.GetSMTPCredentials(advrm.RMId);
txtEmail.Text = adviserstaffsmtpvo.Email;
if (!String.IsNullOrEmpty(adviserstaffsmtpvo.Password))
{
txtPassword.Attributes.Add("value", Encryption.Decrypt(adviserstaffsmtpvo.Password));
}
txtSMTPHost.Text = adviserstaffsmtpvo.HostServer;
txtSMTPPort.Text = adviserstaffsmtpvo.Port;
txtSenderEmailAlias.Text = adviserstaffsmtpvo.SenderEmailAlias;
chkAthenticationRequired.Checked = Convert.ToBoolean(adviserstaffsmtpvo.IsAuthenticationRequired);
ddlSMSProvider.SelectedValue = adviserstaffsmtpvo.SmsProviderId.ToString();
txtUserName.Text = adviserstaffsmtpvo.SmsUserName;
txtPassword1.Text = adviserstaffsmtpvo.Apipassword;
txtSenderID.Text = adviserstaffsmtpvo.SmsSenderId;
if (!String.IsNullOrEmpty(adviserstaffsmtpvo.Smspassword))
{
txtPwd.Attributes.Add("value", adviserstaffsmtpvo.Smspassword);
}
txtsmsCredit.Text = adviserstaffsmtpvo.SmsInitialcredit.ToString();
ddlAPIProvider.SelectedValue = adviserstaffsmtpvo.ApiProviderId.ToString();
txtUname.Text = adviserstaffsmtpvo.ApiUserName;
txtMemberId.Text = Convert.ToString(adviserstaffsmtpvo.ApiMemberId);
if (!String.IsNullOrEmpty(adviserstaffsmtpvo.Apipassword))
{
txtPassword1.Attributes.Add("value", adviserstaffsmtpvo.Apipassword);
}
SetAdviserPreference();
}
string a = txtPassword.Text;
}
// Created by Vinayak Patil
// TO GET ALL THE STAFFS WHO IS HAVING ONLY ADMIN AND RM ROLES UNDER THE PERTICULAR ADVISER
private void BindRMDropDown()
{
try
{
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
dsGetAllTheRMList = advisorStaffBo.GetAllAdviserRMsHavingOnlyAdminRMRole(advisorVo.advisorId, 0);
if (dsGetAllTheRMList != null)
{
dtGetAllTheRMList = dsGetAllTheRMList.Tables[0];
if (dtGetAllTheRMList.Rows.Count > 0)
{
ddlSelectRMs.DataSource = dtGetAllTheRMList;
ddlSelectRMs.DataValueField = dtGetAllTheRMList.Columns["RMId"].ToString();
ddlSelectRMs.DataTextField = dtGetAllTheRMList.Columns["RMName"].ToString();
ddlSelectRMs.DataBind();
}
}
ddlSelectRMs.Items.Insert(0, new System.Web.UI.WebControls.ListItem("All", advisorVo.advisorId.ToString()));
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewCustomerFamily.ascx.cs:BindRMDropDown()");
object[] objects = new object[0];
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private bool ValidateUserLogin(string userAccountId, string isWerp)
{
string strOnlineAdviser = "0";
bool isValidUser = false;
UserBo userBo = new UserBo();
AssociatesVO associatesVo = new AssociatesVO();
AdvisorBranchVo advisorBranchVo = new AdvisorBranchVo();
AssociatesUserHeirarchyVo associatesUserHeirarchyVo = new AssociatesUserHeirarchyVo();
AdvisorBo advisorBo = new AdvisorBo();
BoDematAccount boDematAccount = new BoDematAccount();
AssociatesBo associatesBo = new AssociatesBo();
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
CustomerBo customerBo = new CustomerBo();
AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo();
PortfolioBo portfolioBo = new PortfolioBo();
CustomerPortfolioVo customerPortfolioVo = new CustomerPortfolioVo();
strOnlineAdviser = ConfigurationSettings.AppSettings["ONLINE_ADVISER"].ToString();
if (string.IsNullOrEmpty(isWerp))
{
userVo = userBo.GetUserAccountDetails(userAccountId, Convert.ToInt32(strOnlineAdviser));
}
else
{
advisorVo = (AdvisorVo)Session["advisorVo"];
userVo = userBo.GetUserAccountDetails(userAccountId, advisorVo.advisorId);
}
if (!string.IsNullOrEmpty(isWerp))
{
if (userVo != null)
{
customerVo = customerBo.GetCustomerInfo(userVo.UserId);
isValidUser = true;
}
Session["CustomerVo"] = customerVo;
}
else if (userVo != null)
{
isValidUser = true;
List <string> roleList = new List <string>();
string branchLogoSourcePath;
string sourcePath;
string potentialHomePage = string.Empty;
roleList = userBo.GetUserRoles(userVo.UserId);
if (userVo.UserType == "Customer")
{
customerVo = customerBo.GetCustomerInfo(userVo.UserId);
advisorVo = advisorBo.GetAdvisor(advisorBranchBo.GetBranch(customerVo.BranchId).AdviserId);
if (customerVo.IsProspect == 0)
{
customerPortfolioVo = portfolioBo.GetCustomerDefaultPortfolio(customerVo.CustomerId);
Session[SessionContents.PortfolioId] = customerPortfolioVo.PortfolioId;
}
rmVo = advisorStaffBo.GetAdvisorStaffDetails(customerVo.RmId);
Session[SessionContents.LogoPath] = advisorVo.LogoPath;
Session[SessionContents.CurrentUserRole] = "Customer";
Session[SessionContents.UserTopRole] = "Customer";
branchLogoSourcePath = "Images/" + userBo.GetRMBranchLogo(rmVo.RMId);
sourcePath = "Images/" + userBo.GetRMLogo(rmVo.RMId);
Session[SessionContents.LogoPath] = sourcePath;
Session[SessionContents.BranchLogoPath] = branchLogoSourcePath;
Session["CustomerVo"] = customerVo;
Session["DematAccountVo"] = boDematAccount.GetCustomerActiveDematAccount(customerVo.CustomerId);
UserBo.AddLoginTrack(userVo.LoginId, string.Empty, true, HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"], HttpContext.Current.Request.UserAgent, userVo.UserId);
}
Session["UserVo"] = userVo;
Session["advisorVo"] = advisorVo;
Session["rmVo"] = rmVo;
SetAdviserPreference();
//Session["Theme"] = advisorVo.theme;
//Session["refreshTheme"] = true;
Session[SessionContents.LogoPath] = advisorVo.LogoPath;
}
return(isValidUser);
}
public void showRMList()
{
rmVo = new RMVo();
int Count = 0;
List <RMVo> rmList = new List <RMVo>();
List <string> roleList = new List <string>();
//roleList = userBo.GetUserRoles(userVo.UserId);
string role = "BM";
rmVo = advisorStaffBo.GetAdvisorStaff(userVo.UserId);
try
{
//if (roleList.Contains("BM") && Session["CurrentUserRole"] == "BM")
if (role == Session[SessionContents.CurrentUserRole].ToString())
{
trBMBranchs.Visible = true;
if (!Page.IsPostBack)
{
branchId = 0;
all = 1;
bmIdOrHeadID = rmVo.RMId;
BindBMDropDown(bmIdOrHeadID);
}
rmList = advisorStaffBo.GetBMRMList(branchId, bmIdOrHeadID, all);
if (rmList != null && rmList.Count != 0)
{
//lblTotalRows.Text = hdnCount.Value = Count.ToString();
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("StaffCode");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("BranchList");
dtAdvisorStaff.Columns.Add("Mobile Number");
dtAdvisorStaff.Columns.Add("AR_StaffCode");
DataRow drAdvisorStaff;
for (int i = 0; i < rmList.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
rmVo = new RMVo();
rmVo = rmList[i];
drAdvisorStaff[0] = rmVo.UserId.ToString();
drAdvisorStaff[1] = rmVo.RMId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
if (rmVo.IsExternal == 1)
{
drAdvisorStaff[4] = "External";
}
else
{
drAdvisorStaff[4] = "Internal";
}
if (!string.IsNullOrEmpty(rmVo.StaffCode))
{
drAdvisorStaff[3] = rmVo.StaffCode;
}
else
{
drAdvisorStaff[3] = "";
}
drAdvisorStaff[5] = rmVo.RMRole;
drAdvisorStaff[6] = rmVo.Email.ToString();
drAdvisorStaff[8] = rmVo.Mobile.ToString();
drAdvisorStaff[7] = rmVo.BranchList;
drAdvisorStaff[9] = rmVo.StaffCode;
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.DataBind();
if (Cache["RMList" + advisorVo.advisorId.ToString()] == null)
{
Cache.Insert("RMList" + advisorVo.advisorId.ToString(), dtAdvisorStaff);
}
else
{
Cache.Remove("RMList" + advisorVo.advisorId.ToString());
Cache.Insert("RMList" + advisorVo.advisorId.ToString(), dtAdvisorStaff);
}
//this.GetPageCount();
}
else
{
gvRMList.DataSource = null;
gvRMList.DataBind();
//DivPager.Visible = false;
//lblCurrentPage.Visible = false;
//lblTotalRows.Visible = false;
trMessage.Visible = true;
}
}
else
{
trBMBranchs.Visible = false;
trMessage.Visible = false;
advisorStaffBo = new AdvisorStaffBo();
List <RMVo> advisorStaffList = null;
//advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId, mypager.CurrentPage, hdnSort.Value, out Count, string.Empty);
advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId, hdnSort.Value, string.Empty);
if (advisorStaffList != null)
{
//lblTotalRows.Text = hdnCount.Value = Count.ToString();
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("StaffCode");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("Mobile Number");
dtAdvisorStaff.Columns.Add("BranchList");
dtAdvisorStaff.Columns.Add("AR_StaffCode");
dtAdvisorStaff.Columns.Add("RoleList");
dtAdvisorStaff.Columns.Add("ReportingTo");
dtAdvisorStaff.Columns.Add("ReportingTitle");
dtAdvisorStaff.Columns.Add("Title");
DataRow drAdvisorStaff;
for (int i = 0; i < advisorStaffList.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
rmVo = new RMVo();
rmVo = advisorStaffList[i];
drAdvisorStaff[0] = rmVo.UserId.ToString();
drAdvisorStaff[1] = rmVo.RMId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
//drAdvisorStaff[3] = rmVo.MainBranch.ToString();
if (!string.IsNullOrEmpty(rmVo.StaffCode))
{
drAdvisorStaff[3] = rmVo.StaffCode;
}
else
{
drAdvisorStaff[3] = "";
}
if (rmVo.IsExternal == 1)
{
drAdvisorStaff[4] = "External";
}
else
{
drAdvisorStaff[4] = "Internal";
}
drAdvisorStaff[5] = rmVo.RMRole.ToString();
drAdvisorStaff[6] = rmVo.Email.ToString();
drAdvisorStaff[7] = rmVo.Mobile.ToString();
drAdvisorStaff[8] = rmVo.BranchList.ToString();
drAdvisorStaff[9] = rmVo.StaffCode;
drAdvisorStaff[10] = rmVo.userRole;
drAdvisorStaff[11] = rmVo.ReportingTo;
drAdvisorStaff[12] = rmVo.ReportingTitle;
drAdvisorStaff[13] = rmVo.Title;
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
dtAdvisorStaff.DefaultView.Sort = "RMName ASC";
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.DataBind();
if (Cache["RMList" + advisorVo.advisorId.ToString()] == null)
{
Cache.Insert("RMList" + advisorVo.advisorId.ToString(), dtAdvisorStaff);
}
else
{
Cache.Remove("RMList" + advisorVo.advisorId.ToString());
Cache.Insert("RMList" + advisorVo.advisorId.ToString(), dtAdvisorStaff);
}
//this.GetPageCount();
}
else
{
gvRMList.DataSource = null;
gvRMList.DataBind();
//DivPager.Visible = false;
//lblCurrentPage.Visible = false;
//lblTotalRows.Visible = false;
trMessage.Visible = true;
}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewRM.ascx:showRMList()");
object[] objects = new object[4];
objects[0] = advisorVo;
objects[1] = rmVo;
objects[2] = rmId;
objects[3] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (Validation())
{
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
RMVo rmVo = new RMVo();
Random id = new Random();
AdvisorBo advisorBo = new AdvisorBo();
string password = id.Next(10000, 99999).ToString();
//rmUserVo.UserType = ddlRMRole.SelectedItem.Text.ToString().Trim();
rmUserVo.Password = password;
rmUserVo.MiddleName = txtMiddleName.Text.ToString();
rmUserVo.LoginId = txtEmail.Text.ToString();
rmUserVo.LastName = txtLastName.Text.ToString();
rmUserVo.FirstName = txtFirstName.Text.ToString();
rmUserVo.Email = txtEmail.Text.ToString();
rmVo.Email = txtEmail.Text.ToString();
if (txtFaxNumber.Text == "")
{
rmVo.Fax = 0;
}
else
{
rmVo.Fax = int.Parse(txtFaxNumber.Text.ToString());
}
if (txtFaxISD.Text == "")
{
rmVo.FaxIsd = 0;
}
else
{
rmVo.FaxIsd = int.Parse(txtFaxISD.Text.ToString());
}
if (txtFaxSTD.Text == "")
{
rmVo.FaxStd = 0;
}
else
{
rmVo.FaxStd = int.Parse(txtExtSTD.Text.ToString());
}
rmVo.FirstName = txtFirstName.Text.ToString();
rmVo.LastName = txtLastName.Text.ToString();
rmVo.MiddleName = txtMiddleName.Text.ToString();
rmVo.Mobile = Convert.ToInt64(txtMobileNumber.Text.ToString());
rmVo.OfficePhoneDirectIsd = int.Parse(txtPhDirectISD.Text.ToString());
rmVo.OfficePhoneDirectNumber = int.Parse(txtPhDirectPhoneNumber.Text.ToString());
if (txtPhExtISD.Text == "")
{
rmVo.OfficePhoneExtIsd = 0;
}
else
{
rmVo.OfficePhoneExtIsd = int.Parse(txtPhExtISD.Text.ToString());
}
if (txtPhExtPhoneNumber.Text == "")
{
rmVo.OfficePhoneExtNumber = 0;
}
else
{
rmVo.OfficePhoneExtNumber = int.Parse(txtPhExtPhoneNumber.Text.ToString());
}
if (txtExtSTD.Text == "")
{
rmVo.OfficePhoneExtStd = 0;
}
else
{
rmVo.OfficePhoneExtStd = int.Parse(txtExtSTD.Text.ToString());
}
if (txtPhResiISD.Text == "")
{
rmVo.ResPhoneIsd = 0;
}
else
{
rmVo.ResPhoneIsd = int.Parse(txtPhResiISD.Text.ToString());
}
if (txtPhResiPhoneNumber.Text == "")
{
rmVo.ResPhoneNumber = 0;
}
else
{
rmVo.ResPhoneNumber = int.Parse(txtPhResiPhoneNumber.Text.ToString());
}
if (txtResiSTD.Text == "")
{
rmVo.ResPhoneStd = 0;
}
else
{
rmVo.ResPhoneStd = int.Parse(txtResiSTD.Text.ToString());
}
if (txtPhDirectSTD.Text == "")
{
rmVo.OfficePhoneDirectStd = 0;
}
else
{
rmVo.OfficePhoneDirectStd = int.Parse(txtPhDirectSTD.Text.ToString());
}
//rmVo.RMRole = ddlRMRole.SelectedValue.ToString();
rmVo.AdviserId = advisorVo.advisorId;
if (chkExternalStaff.Checked)
{
rmVo.IsExternal = 1;
rmVo.CTC = Double.Parse(txtCTCMonthly.Text);
}
else
{
rmVo.IsExternal = 0;
}
rmIds = advisorStaffBo.CreateCompleteRM(rmUserVo, rmVo, userVo.UserId);
rmVo.UserId = rmIds[0];
Session["rmId"] = rmIds[1];
Session["rmUserVo"] = userBo.GetUserDetails(rmVo.UserId);
Session["userId"] = rmVo.UserId;
//if (rmVo.RMRole == "RM")
//{
// // Create Association for RM
// userBo.CreateRoleAssociation(rmVo.UserId, 1001);
// // 1001 - RM
// // 1000 - Adviser
// // 1003 - Customer
//}
//else
//{
// // Create Association if BM
// userBo.CreateRoleAssociation(rmVo.UserId, 1002);
// // 1002 - BM
// if (chkRM.Checked)
// {
// // Create Association for RM
// userBo.CreateRoleAssociation(rmVo.UserId, 1001);
// }
//}
//if (chkRM.Checked)
//{
// // Create Association for RM
// userBo.CreateRoleAssociation(rmVo.UserId, 1001);
//}
//if (chkBM.Checked)
//{
// // Create Association if BM
// userBo.CreateRoleAssociation(rmVo.UserId, 1002);
//}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AddRM.ascx:btnSave_Click()");
object[] objects = new object[5];
objects[0] = advisorVo;
objects[1] = userVo;
objects[2] = rmUserVo;
objects[3] = userId;
objects[4] = rmVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private void CreateRM()
{
if (Validation())
{
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
RMVo rmVo = new RMVo();
Random id = new Random();
AdvisorBo advisorBo = new AdvisorBo();
advisorVo = (AdvisorVo)Session["advisorVo"];
int branchId;
string password = id.Next(10000, 99999).ToString();
rmUserVo.UserType = "Advisor";
rmUserVo.Password = Encryption.Encrypt(password);
rmUserVo.MiddleName = txtMiddleName.Text.ToString();
//rmUserVo.LoginId = txtEmail.Text.ToString();
rmUserVo.LastName = txtLastName.Text.ToString();
rmUserVo.FirstName = txtFirstName.Text.ToString();
rmUserVo.Email = txtEmail.Text.ToString();
rmVo.Email = txtEmail.Text.ToString();
if (txtFaxNumber.Text == "")
{
rmVo.Fax = 0;
}
else
{
rmVo.Fax = int.Parse(txtFaxNumber.Text.ToString());
}
if (txtFaxISD.Text == "")
{
rmVo.FaxIsd = 0;
}
else
{
rmVo.FaxIsd = int.Parse(txtFaxISD.Text.ToString());
}
if (txtFaxSTD.Text == "")
{
rmVo.FaxStd = 0;
}
else
{
rmVo.FaxStd = int.Parse(txtExtSTD.Text.ToString());
}
rmVo.FirstName = txtFirstName.Text.ToString();
rmVo.LastName = txtLastName.Text.ToString();
rmVo.MiddleName = txtMiddleName.Text.ToString();
rmVo.StaffCode = txtStaffCode.Text.ToString();
if (txtMobileNumber.Text.ToString() != "")
{
rmVo.Mobile = Convert.ToInt64(txtMobileNumber.Text.ToString());
}
if (!string.IsNullOrEmpty(txtPhDirectISD.Text.ToString()))
{
rmVo.OfficePhoneDirectIsd = int.Parse(txtPhDirectISD.Text.ToString());
}
if (!string.IsNullOrEmpty(txtPhDirectPhoneNumber.Text.ToString()))
{
rmVo.OfficePhoneDirectNumber = int.Parse(txtPhDirectPhoneNumber.Text.ToString());
}
if (txtPhExtISD.Text == "")
{
rmVo.OfficePhoneExtIsd = 0;
}
else
{
rmVo.OfficePhoneExtIsd = int.Parse(txtPhExtISD.Text.ToString());
}
if (txtPhExtPhoneNumber.Text == "")
{
rmVo.OfficePhoneExtNumber = 0;
}
else
{
rmVo.OfficePhoneExtNumber = int.Parse(txtPhExtPhoneNumber.Text.ToString());
}
if (txtExtSTD.Text == "")
{
rmVo.OfficePhoneExtStd = 0;
}
else
{
rmVo.OfficePhoneExtStd = int.Parse(txtExtSTD.Text.ToString());
}
if (txtPhResiISD.Text == "")
{
rmVo.ResPhoneIsd = 0;
}
else
{
rmVo.ResPhoneIsd = int.Parse(txtPhResiISD.Text.ToString());
}
if (txtPhResiPhoneNumber.Text == "")
{
rmVo.ResPhoneNumber = 0;
}
else
{
rmVo.ResPhoneNumber = int.Parse(txtPhResiPhoneNumber.Text.ToString());
}
if (txtResiSTD.Text == "")
{
rmVo.ResPhoneStd = 0;
}
else
{
rmVo.ResPhoneStd = int.Parse(txtResiSTD.Text.ToString());
}
if (txtPhDirectSTD.Text == "")
{
rmVo.OfficePhoneDirectStd = 0;
}
else
{
rmVo.OfficePhoneDirectStd = int.Parse(txtPhDirectSTD.Text.ToString());
}
if (ChklistRMBM.Items[0].Selected == true)
{
rmVo.RMRole = "RM";
}
else
{
rmVo.RMRole = "BM";
}
//rmVo.RMRole = ddlRMRole.SelectedValue.ToString();
rmVo.AdviserId = advisorVo.advisorId;
if (txtCTCMonthly.Text != "")
{
rmVo.CTC = Double.Parse(txtCTCMonthly.Text);
}
if (chkExternalStaff.Checked)
{
rmVo.IsExternal = 1;
}
else
{
rmVo.IsExternal = 0;
}
rmIds = advisorStaffBo.CreateCompleteRM(rmUserVo, rmVo, userVo.UserId);
rmVo.UserId = rmIds[0];
Session["rmId"] = rmIds[1];
Session["rmUserVo"] = userBo.GetUserDetails(rmVo.UserId);
Session["userId"] = rmVo.UserId;
if (chkMailSend.Checked == true)
{
SendMail();
}
//if (rmVo.RMRole == "RM")
//{
// // Create Association for RM
// userBo.CreateRoleAssociation(rmVo.UserId, 1001);
// // 1001 - RM
// // 1000 - Adviser
// // 1003 - Customer
//}
//else
//{
// // Create Association if BM
// userBo.CreateRoleAssociation(rmVo.UserId, 1002);
// // 1002 - BM
// if (chkRM.Checked)
// {
// // Create Association for RM
// userBo.CreateRoleAssociation(rmVo.UserId, 1001);
// }
//}
foreach (ListItem Items in ChklistRMBM.Items)
{
if (Items.Selected)
{
if (Items.Text == "RM")
{
// Create Association for RM
userBo.CreateRoleAssociation(rmVo.UserId, Int16.Parse(Items.Value.ToString()));
}
else if (Items.Text == "BM")
{
// Create Association for RM
userBo.CreateRoleAssociation(rmVo.UserId, Int16.Parse(Items.Value.ToString()));
}
}
}
string hdnSelectedString = hdnSelectedBranches.Value.ToString();
if (!string.IsNullOrEmpty(hdnSelectedString))
{
string[] selectedBranchesList = hdnSelectedString.Split(',');
foreach (string str in selectedBranchesList)
{
if (str != "")
{
advisorBranchBo.CreateRMBranchAssociation(rmIds[1], int.Parse(str), advisorVo.advisorId, advisorVo.advisorId);
}
}
}
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "loadcontrol('ViewRM','none');", true);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
UserBo userBo = new UserBo();
AdvisorStaffBo adviserStaffBo = new AdvisorStaffBo();
RMVo rmVo = new RMVo();
CustomerVo customerVo = new CustomerVo();
CustomerBo customerBo = new CustomerBo();
if (userBo.ValidateUser(txtUserName.Text.ToString(), txtPassword.Text.ToString()))
{
userVo = userBo.GetUser(txtUserName.Text.ToString());
if (userVo.UserType == "Advisor")
{
rmVo = adviserStaffBo.GetAdvisorStaff(userVo.UserId);
if (rmVo.AdviserId == adviserId || isMainDomain == true)
{
lblLoginMessage.Visible = true;
lblLoginMessage.Text = "Logged In to " + appName.ToString() + " as " + userVo.FirstName + ' ' + userVo.MiddleName + ' ' + userVo.LastName;
lblLoginMessage.CssClass = "FieldName";
tblLoginBlock.Visible = false;
Session["CurrentUserVo"] = userVo;
lnklogout.Visible = true;
Response.Write("<script>window.open('" + refLink + "?UserId=" + Encryption.Encrypt(userVo.UserId.ToString()) + "','_blank');</script>");
}
else
{
lblLoginMessage.Visible = true;
tblLoginBlock.Visible = true;
lblLoginMessage.Text = "Authentication Failed";
lblLoginMessage.CssClass = "FieldError";
}
}
else if (userVo.UserType == "Customer")
{
customerVo = customerBo.GetCustomerInfo(userVo.UserId);
rmVo = adviserStaffBo.GetAdvisorStaffDetails(customerVo.RmId);
if (rmVo.AdviserId == adviserId || isMainDomain == true)
{
lblLoginMessage.Visible = true;
lblLoginMessage.Text = "Logged In to " + appName.ToString() + " as " + userVo.FirstName + ' ' + userVo.MiddleName + ' ' + userVo.LastName;
lblLoginMessage.CssClass = "FieldName";
Session["CurrentUserVo"] = userVo;
tblLoginBlock.Visible = false;
lnklogout.Visible = true;
Response.Write("<script>window.open('" + refLink + "?UserId=" + Encryption.Encrypt(userVo.UserId.ToString()) + "','_blank');</script>");
}
else
{
lblLoginMessage.Visible = true;
tblLoginBlock.Visible = false;
lblLoginMessage.Text = "Authentication Failed";
lblLoginMessage.CssClass = "FieldError";
}
}
}
else
{
lblLoginMessage.Text = "Invalid LoginId or Password";
lblLoginMessage.Visible = true;
lblLoginMessage.CssClass = "FieldError";
}
}
public void showRMUserDetails()
{
try
{
UserVo uservo = (UserVo)Session["userVo"];
AdvisorStaffBo adviserstaffbo = new AdvisorStaffBo();
RMVo advrm = new RMVo();
advrm = adviserstaffbo.GetAdvisorStaff(uservo.UserId);
ViewState["rmId"] = advrm.RMId;
//if (hdnCurrentPage.Value.ToString() != "")
//{
// mypager.CurrentPage = Int32.Parse(hdnCurrentPage.Value.ToString());
// hdnCurrentPage.Value = "";
//}
int count = 0;
rmUserList = advisorStaffBo.GetRMList(advisorVo.advisorId, hdnSort.Value.Trim(), hdnNameFilter.Value.Trim());
//lblTotalRows.Text = hdnRecordCount.Value = count.ToString();
if (rmUserList != null)
{
DataTable dtRMUsers = new DataTable();
dtRMUsers.Columns.Add("S.No");
dtRMUsers.Columns.Add("RMName");
dtRMUsers.Columns.Add("LoginId");
dtRMUsers.Columns.Add("EmailId");
dtRMUsers.Columns.Add("UserId");
DataRow drRMUsers;
for (int i = 0; i < rmUserList.Count; i++)
{
drRMUsers = dtRMUsers.NewRow();
rmVo = new RMVo();
rmVo = rmUserList[i];
userId = rmVo.UserId;
userVo = new UserVo();
userVo = userBo.GetUserDetails(userId);
drRMUsers[0] = (i + 1).ToString();
drRMUsers[1] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
if (userVo != null)
{
drRMUsers[2] = userVo.LoginId.ToString();
drRMUsers[3] = userVo.Email;
drRMUsers[4] = userVo.UserId;
}
dtRMUsers.Rows.Add(drRMUsers);
}
if (Cache["customerList" + advisorVo.advisorId] == null)
{
Cache.Insert("customerList" + advisorVo.advisorId, dtRMUsers);
}
else
{
Cache.Remove("customerList" + advisorVo.advisorId);
Cache.Insert("customerList" + advisorVo.advisorId, dtRMUsers);
}
gvUserMgt.DataSource = dtRMUsers;
gvUserMgt.DataBind();
//gvRMUsers.PageSize = PageSize;
//if (trPagger.Visible == false)
// trPagger.Visible = true;
//this.GetPageCount();
//if (btnGenerate.Visible == false)
// btnGenerate.Visible = true;
//if (mypager.Visible == false)
// mypager.Visible = true;
}
else
{
//lblCurrentPage.Visible = false;
//lblTotalRows.Visible = false;
tblPager.Visible = false;
//trNoRecords.Visible = true;
tblMessage.Visible = true;
ErrorMessage.Visible = true;
SuccessMsg.Visible = false;
ErrorMessage.InnerText = "No Records Found...!";
trPagger.Visible = false;
btnGenerate.Visible = false;
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RMUserDetails.ascx:showRMUserDetails()");
object[] objects = new object[5];
objects[0] = advisorVo;
objects[1] = rmVo;
objects[2] = userVo;
objects[3] = rmUserList;
objects[4] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
private bool SendMail(UserVo userVo, bool isNewLogin)
{
Emailer emailer = new Emailer();
EmailMessage email = new EmailMessage();
AdvisorPreferenceVo advisorPreferenceVo = new AdvisorPreferenceVo();
advisorVo = (AdvisorVo)Session["advisorVo"];
if (Session["AdvisorPreferenceVo"] != null)
{
advisorPreferenceVo = (AdvisorPreferenceVo)Session["AdvisorPreferenceVo"];
}
string logoPath = string.Empty;
bool isMailSent = false;
bool isEmailIdBlank = false;
try
{
UserVo uservo = (UserVo)Session["userVo"];
AdvisorStaffBo adviserstaffbo = new AdvisorStaffBo();
//Get SMTP settings of admin if configured.
RMVo advrm = new RMVo();
advrm = adviserstaffbo.GetAdvisorStaff(uservo.UserId);
AdviserStaffSMTPBo adviserStaffSMTPBo = new AdviserStaffSMTPBo();
AdviserStaffSMTPVo adviserStaffSMTPVo = adviserStaffSMTPBo.GetSMTPCredentials(advrm.RMId);
//Get the mail contents
if (userVo.Email.Trim() != string.Empty)
{
email.To.Add(userVo.Email);
string name = userVo.FirstName + " " + userVo.MiddleName + " " + userVo.LastName;
if (isNewLogin)
{
email.GetCustomerAccountMail(userVo.LoginId, userVo.OriginalPassword, name);
}
else
{
email.GetResetPasswordMail(userVo.LoginId, userVo.OriginalPassword, name);
}
email.Subject = email.Subject.Replace("WealthERP", advisorVo.OrganizationName);
email.Subject = email.Subject.Replace("MoneyTouch", advisorVo.OrganizationName);
email.Body = email.Body.Replace("[ORGANIZATION]", advisorVo.OrganizationName);
email.Body = email.Body.Replace("[CUSTOMER_NAME]", userVo.FirstName);
if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Wealtherp")
{
email.Body = email.Body.Replace("[WEBSITE]", advisorPreferenceVo.WebSiteDomainName);
}
else if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Citrus")
{
email.Body = email.Body.Replace("[WEBSITE]", advisorPreferenceVo.WebSiteDomainName);
}
email.Body = email.Body.Replace("[CONTACTPERSON]", advisorVo.ContactPersonFirstName + " " + advisorVo.ContactPersonMiddleName + " " + advisorVo.ContactPersonLastName);
if (!string.IsNullOrEmpty(advisorVo.Designation))
{
email.Body = email.Body.Replace("[DESIGNATION]", advisorVo.Designation);
}
else
{
email.Body = email.Body.Replace("[DESIGNATION]", string.Empty);
}
if (!string.IsNullOrEmpty(advisorVo.Phone1Number.ToString()))
{
email.Body = email.Body.Replace("[PHONE]", advisorVo.Phone1Std.ToString() + "-" + advisorVo.Phone1Number.ToString());
}
else
{
email.Body = email.Body.Replace("[PHONE]", string.Empty);
}
if (!string.IsNullOrEmpty(advisorVo.Email))
{
email.Body = email.Body.Replace("[EMAIL]", advisorVo.Email);
}
else
{
email.Body = email.Body.Replace("[EMAIL]", string.Empty);
}
email.Body = email.Body.Replace("[LOGO]", "<img src='cid:HDIImage' alt='Logo'>");
System.Net.Mail.AlternateView htmlView;
System.Net.Mail.AlternateView plainTextView = System.Net.Mail.AlternateView.CreateAlternateViewFromString("Text view", null, "text/plain");
//System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(hidBody.Value.Trim() + "<image src=cid:HDIImage>", null, "text/html");
htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString("<html><body " + "style='font-family:Tahoma, Arial; font-size: 10pt;'><p>" + email.Body + "</p></body></html>", null, "text/html");
//Add image to HTML version
if (advisorVo != null)
{
logoPath = "~/Images/" + advisorVo.LogoPath;
}
if (!File.Exists(Server.MapPath(logoPath)))
{
logoPath = "~/Images/spacer.png";
}
//System.Net.Mail.LinkedResource imageResource = new System.Net.Mail.LinkedResource(Server.MapPath("~/Images/") + @"\3DSYRW_4009.JPG", "image/jpeg");
System.Net.Mail.LinkedResource imageResource = new System.Net.Mail.LinkedResource(Server.MapPath(logoPath), "image/jpeg");
imageResource.ContentId = "HDIImage";
htmlView.LinkedResources.Add(imageResource);
//Add two views to message.
email.AlternateViews.Add(plainTextView);
email.AlternateViews.Add(htmlView);
//Send message
//System.Net.Mail.SmtpClient smtpClient = new System.Net.Mail.SmtpClient();
//Assign SMTP Credentials if configured.
if (adviserStaffSMTPVo.HostServer != null && adviserStaffSMTPVo.HostServer != string.Empty)
{
emailer.isDefaultCredentials = !Convert.ToBoolean(adviserStaffSMTPVo.IsAuthenticationRequired);
if (!String.IsNullOrEmpty(adviserStaffSMTPVo.Password))
{
emailer.smtpPassword = Encryption.Decrypt(adviserStaffSMTPVo.Password);
}
emailer.smtpPort = int.Parse(adviserStaffSMTPVo.Port);
emailer.smtpServer = adviserStaffSMTPVo.HostServer;
emailer.smtpUserName = adviserStaffSMTPVo.Email;
if (Convert.ToBoolean(adviserStaffSMTPVo.IsAuthenticationRequired))
{
if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Wealtherp")
{
email.From = new MailAddress(emailer.smtpUserName, advisorVo.OrganizationName);
}
else if (ConfigurationSettings.AppSettings["HostName"].ToString() == "MoneyTouch")
{
email.From = new MailAddress(emailer.smtpUserName, advisorVo.OrganizationName);
}
}
}
//Sending mail...
isMailSent = emailer.SendMail(email);
}
else
{
isEmailIdBlank = true;
}
if (isEmailIdBlank)
{
if (string.IsNullOrEmpty(statusMessage))
{
statusMessage = "No email Id specified for selected User";
tblMessage.Visible = true;
ErrorMessage.Visible = true;
ErrorMessage.InnerText = statusMessage;
SuccessMsg.Visible = false;
}
else
{
statusMessage = statusMessage + " and some selected User don't have E-mail id";
tblMessage.Visible = true;
ErrorMessage.Visible = true;
ErrorMessage.InnerText = statusMessage;
SuccessMsg.Visible = false;
}
}
else if (isMailSent)
{
if (string.IsNullOrEmpty(statusMessage))
{
statusMessage = "Credentials have been sent to selected User";
tblMessage.Visible = true;
ErrorMessage.Visible = false;
SuccessMsg.InnerText = statusMessage;
SuccessMsg.Visible = true;
}
else if (statusMessage == "No email Id specified for slected User")
{
statusMessage = "some selected User don't have E-mail id and Credentials have been sent sucessfully to rest of User";
statusMessage = "Credentials have been sent to selected User";
tblMessage.Visible = true;
ErrorMessage.Visible = false;
SuccessMsg.InnerText = statusMessage;
SuccessMsg.Visible = true;
}
else
{
tblMessage.Visible = true;
ErrorMessage.Visible = false;
SuccessMsg.InnerText = statusMessage;
SuccessMsg.Visible = true;
}
}
else
{
statusMessage = "An error occurred while sending mail .. ";
tblMessage.Visible = true;
ErrorMessage.Visible = true;
ErrorMessage.InnerText = statusMessage;
SuccessMsg.Visible = false;
}
}
catch (Exception ex)
{
}
return(isMailSent);
}
private void LoadBranchAssociation(int currentPage)
{
AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo();
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
UserVo userVo = null;
DataSet ds = null;
try
{
int Count;
ds = advisorBranchBo.GetBranchAssociation(advisorVo.advisorId, currentPage, out Count, hdnBranchFilter.Value, hdnRMFilter.Value, hdnSort.Value, out genDictBranch, out genDictRM);
if (Count > 0)
{
lblTotalRows.Text = hdnRecordCount.Value = Count.ToString();
tblPager.Visible = true;
}
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
lblMsg.Visible = false;
DataTable dt = new DataTable();
dt.Columns.Add("BranchId");
dt.Columns.Add("RMId");
dt.Columns.Add("Branch Name");
dt.Columns.Add("RM Name");
DataRow dr;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dr = dt.NewRow();
dr["BranchId"] = ds.Tables[0].Rows[i]["branchId"].ToString();
dr["RMId"] = ds.Tables[0].Rows[i]["RMId"].ToString();
dr["Branch Name"] = ds.Tables[0].Rows[i]["BranchName"].ToString();
dr["RM Name"] = ds.Tables[0].Rows[i]["RMName"].ToString();
dt.Rows.Add(dr);
}
gvBranchList.DataSource = dt;
gvBranchList.DataBind();
if (genDictBranch.Count > 0)
{
DropDownList ddlBranch = GetBranchDDL();
if (ddlBranch != null)
{
ddlBranch.DataSource = genDictBranch;
ddlBranch.DataTextField = "Value";
ddlBranch.DataValueField = "Key";
ddlBranch.DataBind();
ddlBranch.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "Select"));
}
if (hdnBranchFilter.Value != "")
{
ddlBranch.SelectedValue = hdnBranchFilter.Value.ToString();
}
}
if (genDictRM.Count > 0)
{
DropDownList ddlRM = GetRMDDL();
if (ddlRM != null)
{
ddlRM.DataSource = genDictRM;
ddlRM.DataTextField = "Value";
ddlRM.DataValueField = "Key";
ddlRM.DataBind();
ddlRM.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "Select"));
}
if (hdnRMFilter.Value != "")
{
ddlRM.SelectedValue = hdnRMFilter.Value.ToString();
}
}
gvBranchList.Visible = true;
this.GetPageCount();
}
}
else
{
gvBranchList.DataSource = null;
gvBranchList.DataBind();
lblMsg.Visible = true;
lblMsg.Text = "Branch Association is not done..! ";
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewBranchAssociation.ascx.cs:LoadBranchAssociation()");
object[] objects = new object[2];
objects[0] = ds;
objects[1] = userVo;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public void showRMList()
{
rmVo = new RMVo();
int Count = 0;
List <RMVo> rmList = new List <RMVo>();
List <string> roleList = new List <string>();
//roleList = userBo.GetUserRoles(userVo.UserId);
string role = "BM";
rmVo = advisorStaffBo.GetAdvisorStaff(userVo.UserId);
try
{
//if (roleList.Contains("BM") && Session["CurrentUserRole"] == "BM")
if (role == Session[SessionContents.CurrentUserRole].ToString())
{
trBMBranchs.Visible = true;
if (!Page.IsPostBack)
{
branchId = 0;
all = 1;
bmIdOrHeadID = rmVo.RMId;
BindBMDropDown(bmIdOrHeadID);
}
rmList = advisorStaffBo.GetBMRMList(branchId, bmIdOrHeadID, all, mypager.CurrentPage, out Count);
if (rmList.Count != 0)
{
lblTotalRows.Text = hdnCount.Value = Count.ToString();
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("BranchList");
dtAdvisorStaff.Columns.Add("Mobile Number");
DataRow drAdvisorStaff;
for (int i = 0; i < rmList.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
rmVo = new RMVo();
rmVo = rmList[i];
drAdvisorStaff[0] = rmVo.UserId.ToString();
drAdvisorStaff[1] = rmVo.RMId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
if (rmVo.IsExternal == 1)
{
drAdvisorStaff[3] = "External";
}
else
{
drAdvisorStaff[3] = "Internal";
}
drAdvisorStaff[4] = string.Empty;
drAdvisorStaff[5] = rmVo.Email.ToString();
drAdvisorStaff[6] = string.Empty;
drAdvisorStaff[7] = rmVo.Mobile.ToString();
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
//gvRMList.Style.Add("Width", "580px");
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.Columns[3].Visible = false;
gvRMList.Columns[4].Visible = false;
//dtAdvisorStaff.Columns.Remove("StaffRole");
//dtAdvisorStaff.Columns.Remove("BranchList");
gvRMList.DataBind();
this.GetPageCount();
}
else
{
gvRMList.DataSource = null;
gvRMList.DataBind();
DivPager.Visible = false;
lblCurrentPage.Visible = false;
lblTotalRows.Visible = false;
trMessage.Visible = true;
}
//branchId = advisorBranchBo.GetBranchId(rmVo.RMId);
//if (branchId != 0)
//{
// //lblMsg.Visible = true;
// //lblMsg.Text = "You dont have RM.. !";
// rmList = advisorStaffBo.GetBMRMList(branchId, mypager.CurrentPage, out Count);
// if (rmList.Count != 0)
// {
// lblTotalRows.Text = hdnCount.Value = Count.ToString();
// DataTable dtAdvisorStaff = new DataTable();
// dtAdvisorStaff.Columns.Add("UserId");
// dtAdvisorStaff.Columns.Add("WealthERP Id");
// dtAdvisorStaff.Columns.Add("RMName");
// dtAdvisorStaff.Columns.Add("StaffType");
// dtAdvisorStaff.Columns.Add("StaffRole");
// dtAdvisorStaff.Columns.Add("Email");
// dtAdvisorStaff.Columns.Add("Mobile Number");
// dtAdvisorStaff.Columns.Add("BranchList");
// DataRow drAdvisorStaff;
// for (int i = 0; i < rmList.Count; i++)
// {
// drAdvisorStaff = dtAdvisorStaff.NewRow();
// rmVo = new RMVo();
// rmVo = rmList[i];
// drAdvisorStaff[0] = rmVo.UserId.ToString();
// drAdvisorStaff[1] = rmVo.RMId.ToString();
// drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
// //drAdvisorStaff[3] = rmVo.MainBranch.ToString();
// if (rmVo.IsExternal == 1)
// drAdvisorStaff[3] = "External";
// else
// drAdvisorStaff[3] = "Internal";
// drAdvisorStaff[4] = rmVo.RMRole.ToString();
// drAdvisorStaff[5] = rmVo.Email.ToString();
// drAdvisorStaff[6] = rmVo.Mobile.ToString();
// drAdvisorStaff[7] = rmVo.BranchList.ToString();
// dtAdvisorStaff.Rows.Add(drAdvisorStaff);
// }
// gvRMList.DataSource = dtAdvisorStaff;
// gvRMList.DataBind();
// this.GetPageCount();
// }
// else
// {
// gvRMList.DataSource = null;
// gvRMList.DataBind();
// DivPager.Visible = false;
// lblCurrentPage.Visible = false;
// lblTotalRows.Visible = false;
// trMessage.Visible = true;
// }
//}
//else
//{
// trMessage.Visible = true;
//}
//Session[SessionContents.CurrentUserRole] = null;
}
else
{
trBMBranchs.Visible = false;
trMessage.Visible = false;
advisorStaffBo = new AdvisorStaffBo();
List <RMVo> advisorStaffList = null;
advisorStaffList = advisorStaffBo.GetRMList(advisorVo.advisorId, mypager.CurrentPage, hdnSort.Value, out Count, string.Empty);
if (advisorStaffList != null)
{
lblTotalRows.Text = hdnCount.Value = Count.ToString();
DataTable dtAdvisorStaff = new DataTable();
dtAdvisorStaff.Columns.Add("UserId");
dtAdvisorStaff.Columns.Add("WealthERP Id");
dtAdvisorStaff.Columns.Add("RMName");
dtAdvisorStaff.Columns.Add("StaffType");
dtAdvisorStaff.Columns.Add("StaffRole");
dtAdvisorStaff.Columns.Add("Email");
dtAdvisorStaff.Columns.Add("Mobile Number");
dtAdvisorStaff.Columns.Add("BranchList");
DataRow drAdvisorStaff;
for (int i = 0; i < advisorStaffList.Count; i++)
{
drAdvisorStaff = dtAdvisorStaff.NewRow();
rmVo = new RMVo();
rmVo = advisorStaffList[i];
drAdvisorStaff[0] = rmVo.UserId.ToString();
drAdvisorStaff[1] = rmVo.RMId.ToString();
drAdvisorStaff[2] = rmVo.FirstName.ToString() + " " + rmVo.MiddleName.ToString() + " " + rmVo.LastName.ToString();
//drAdvisorStaff[3] = rmVo.MainBranch.ToString();
if (rmVo.IsExternal == 1)
{
drAdvisorStaff[3] = "External";
}
else
{
drAdvisorStaff[3] = "Internal";
}
drAdvisorStaff[4] = rmVo.RMRole.ToString();
drAdvisorStaff[5] = rmVo.Email.ToString();
drAdvisorStaff[6] = rmVo.Mobile.ToString();
drAdvisorStaff[7] = rmVo.BranchList.ToString();
dtAdvisorStaff.Rows.Add(drAdvisorStaff);
}
gvRMList.DataSource = dtAdvisorStaff;
gvRMList.DataBind();
this.GetPageCount();
}
else
{
gvRMList.DataSource = null;
gvRMList.DataBind();
DivPager.Visible = false;
lblCurrentPage.Visible = false;
lblTotalRows.Visible = false;
trMessage.Visible = true;
}
}
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "ViewRM.ascx:showRMList()");
object[] objects = new object[4];
objects[0] = advisorVo;
objects[1] = rmVo;
objects[2] = rmId;
objects[3] = userId;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
protected void btnSignIn_Click(object sender, EventArgs e)
{
UserVo userVo = new UserVo();
UserBo userBo = new UserBo();
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo();
AdvisorBranchVo advisorBranchVo = new AdvisorBranchVo();
RMVo rmVo = new RMVo();
AdvisorBo advisorBo = new AdvisorBo();
AdvisorVo advisorVo = new AdvisorVo();
CustomerBo customerBo = new CustomerBo();
CustomerVo customerVo = new CustomerVo();
List <string> roleList = new List <string>();
string sourcePath = "";
string branchLogoSourcePath = "";
int count;
bool isGrpHead = false;
if (!CheckSuperAdmin())
{
if (txtLoginId.Text == "" || txtPassword.Text == "")
{
lblIllegal.Visible = true;
lblIllegal.Text = "Username and Password does not match";
}
else
{
if (userBo.ValidateUser(txtLoginId.Text, txtPassword.Text)) // Validating the User Using the Username and Password
{
Session["id"] = "";
lblIllegal.Visible = true;
userVo = userBo.GetUser(txtLoginId.Text);
Session["UserVo"] = userVo;
AddLoginTrack(txtLoginId.Text, txtPassword.Text, true, userVo.UserId);
if (userVo.theme != null)
{
Session["Theme"] = userVo.theme.ToString();
Session["refreshTheme"] = true;
}
else
{
Session["Theme"] = "Purple";
Session["refreshTheme"] = true;
}
if (userVo.IsTempPassword == 0)
{
string UserName = userVo.FirstName + " " + userVo.LastName;
if (userVo.UserType == "Advisor")
{
Session[SessionContents.CurrentUserRole] = "Admin";
Session["advisorVo"] = advisorBo.GetAdvisorUser(userVo.UserId);
Session["rmVo"] = advisorStaffBo.GetAdvisorStaff(userVo.UserId);
advisorVo = (AdvisorVo)Session["advisorVo"];
rmVo = (RMVo)Session["rmVo"];
Session["adviserId"] = advisorBo.GetRMAdviserId(rmVo.RMId);
if (advisorVo.LogoPath == null || advisorVo.LogoPath == "")
{
advisorVo.LogoPath = "spacer.png";
}
else
{
sourcePath = "Images/" + advisorVo.LogoPath.ToString();
if (!System.IO.File.Exists(Server.MapPath(sourcePath)))
{
sourcePath = "";
}
}
Session[SessionContents.LogoPath] = sourcePath;
roleList = userBo.GetUserRoles(userVo.UserId);
count = roleList.Count;
if (count == 3)
{
advisorBranchVo = advisorBranchBo.GetBranch(advisorBranchBo.GetBranchId(rmVo.RMId));
Session["advisorBranchVo"] = advisorBranchVo;
branchLogoSourcePath = "Images/" + userBo.GetRMBranchLogo(rmVo.RMId);
Session[SessionContents.BranchLogoPath] = branchLogoSourcePath;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('AdvisorRMBMDashBoard','login','" + UserName + "','" + sourcePath + "');", true);
//login user role Type
Session["S_CurrentUserRole"] = "Admin";
}
if (count == 2)
{
if (roleList.Contains("RM") && roleList.Contains("BM"))
{
advisorBranchVo = advisorBranchBo.GetBranch(advisorBranchBo.GetBranchId(rmVo.RMId));
Session["advisorBranchVo"] = advisorBranchVo;
//login user role Type
Session["S_CurrentUserRole"] = "RM";
branchLogoSourcePath = "Images/" + userBo.GetRMBranchLogo(rmVo.RMId);
Session[SessionContents.BranchLogoPath] = branchLogoSourcePath;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('BMRMDashBoard','login','" + UserName + "','" + sourcePath + "','" + branchLogoSourcePath + "');", true);
}
else if (roleList.Contains("RM") && roleList.Contains("Admin"))
{
advisorBranchVo = advisorBranchBo.GetBranch(advisorBranchBo.GetBranchId(rmVo.RMId));
Session["advisorBranchVo"] = advisorBranchVo;
//login user role Type
Session["S_CurrentUserRole"] = "Admin";
branchLogoSourcePath = "Images/" + userBo.GetRMBranchLogo(rmVo.RMId);
Session[SessionContents.BranchLogoPath] = branchLogoSourcePath;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('AdvisorRMDashBoard','login','" + UserName + "','" + sourcePath + "');", true);
}
else if (roleList.Contains("BM") && roleList.Contains("Admin"))
{
advisorBranchVo = advisorBranchBo.GetBranch(advisorBranchBo.GetBranchId(rmVo.RMId));
Session["advisorBranchVo"] = advisorBranchVo;
branchLogoSourcePath = "Images/" + userBo.GetRMBranchLogo(rmVo.RMId);
Session[SessionContents.BranchLogoPath] = branchLogoSourcePath;
//login user role Type
Session["S_CurrentUserRole"] = "Admin";
}
}
if (count == 1)
{
if (roleList.Contains("RM"))
{
Session["adviserId"] = advisorBo.GetRMAdviserId(rmVo.RMId);
//Session["advisorVo"]=advisorBo.GetAdvisor(
branchLogoSourcePath = "Images/" + userBo.GetRMBranchLogo(rmVo.RMId);
sourcePath = "Images/" + userBo.GetRMLogo(rmVo.RMId);
Session[SessionContents.LogoPath] = sourcePath;
Session[SessionContents.BranchLogoPath] = branchLogoSourcePath;
//login user role Type Issue Reported by Ajay on July 1 2010
Session["S_CurrentUserRole"] = "RM";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('RMDashBoard','login','" + UserName + "','" + sourcePath + "','" + branchLogoSourcePath + "');", true);
}
else if (roleList.Contains("BM"))
{
advisorBranchVo = advisorBranchBo.GetBranch(advisorBranchBo.GetBranchId(rmVo.RMId));
Session["advisorBranchVo"] = advisorBranchVo;
branchLogoSourcePath = "Images/" + userBo.GetRMBranchLogo(rmVo.RMId);
Session[SessionContents.BranchLogoPath] = branchLogoSourcePath;
//login user role Type Issue Reported by Ajay on July 1 2010
Session["S_CurrentUserRole"] = "BM";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('BMDashBoard','login','" + UserName + "','" + sourcePath + "','" + branchLogoSourcePath + "');", true);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('AdvisorDashBoard','login','" + UserName + "','" + sourcePath + "');", true);
}
}
GetLatestValuationDate();
}
else if (userVo.UserType == "Customer")
{
customerVo = customerBo.GetCustomerInfo(userVo.UserId);
//Session["advisorVo"] = advisorBo.GetAdvisorUser(userVo.UserId);
Session["CustomerVo"] = customerVo;
customerVo = (CustomerVo)Session["CustomerVo"];
advisorVo = advisorBo.GetAdvisor(advisorBranchBo.GetBranch(customerVo.BranchId).AdviserId);
rmVo = advisorStaffBo.GetAdvisorStaffDetails(customerVo.RmId);
Session["rmVo"] = rmVo;
Session["advisorVo"] = advisorVo;
//if(customerVo!=null){
sourcePath = "Images/" + userBo.GetCustomerLogo(customerVo.CustomerId);
Session[SessionContents.LogoPath] = sourcePath;
Session["S_CurrentUserRole"] = "Customer";
GetLatestValuationDate();
Session["IsDashboard"] = "true";
isGrpHead = customerBo.CheckCustomerGroupHead(customerVo.CustomerId);
if (isGrpHead == true)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('AdvisorRMCustGroupDashboard','login','" + UserName + "','" + sourcePath + "');", true);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('AdvisorRMCustIndiDashboard','login','" + UserName + "','" + sourcePath + "');", true);
}
}
else if (userVo.UserType == "Admin")
{
Session["refreshTheme"] = false;
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loginloadcontrol('AdminUpload','login','" + UserName + "','');", true);
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "pageloadscript", "loadcontrol('ChangeTempPassword','none');", true);
}
}
else
{
lblIllegal.Visible = true;
lblIllegal.Text = "Username and Password does not match";
AddLoginTrack(txtLoginId.Text, txtPassword.Text, false, 0);
}
}
}
}
public static void SendMail(string To, string Cc, string Bcc, string Subject, string Body, ArrayList Attachments, string from, string emailTypeCode, DataTable dtAdviserSMTP, out string fromSMTPEmail, DataSet dsEmailTemplateDetails, out string statusMessage)
{
statusMessage = "";
fromSMTPEmail = "";
string templateId = string.Empty;
string reportType = string.Empty;
AdvisorPreferenceVo advisorPreferenceVo = null;
AdvisorVo advisorVo = null;
CustomerVo customerVo = null;
RMVo rmVo = null;
AdvisorBo advisorBo = new AdvisorBo();
CustomerBo customerBo = new CustomerBo();
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
AdviserPreferenceBo adviserPreferenceBo = new AdviserPreferenceBo();
DataTable dtEmailOutgoingParameterValues = dsEmailTemplateDetails.Tables[0];
DataTable dtEmailTemplateParameters = dsEmailTemplateDetails.Tables[1];
DataTable dtAdviserEmailTemplate = dsEmailTemplateDetails.Tables[2];
DataTable dtAdviserTemplateParametersPre = dsEmailTemplateDetails.Tables[3];
_SMTPFrom = from;
SetAdviserSMTP(dtAdviserSMTP, _SMTPFrom);
SmtpClient smtpClient = new SmtpClient();
EmailMessage email = new EmailMessage();
//MailMessage email = new MailMessage(_SMTPFromDisplay, To);
_SMTPUsername = GetSMTPUserFromPool();
fromSMTPEmail = _SMTPUsername;
email.To.Add(To);
//string name = userVo.FirstName + " " + userVo.MiddleName + " " + userVo.LastName;
email.ReadSendMailTemplate(emailTypeCode);
foreach (DataRow dr in dtEmailOutgoingParameterValues.Rows)
{
switch (dr["WP_ParameterCode"].ToString())
{
case "AID":
advisorVo = advisorBo.GetAdvisor(Convert.ToInt32(dr["WRD_InputParameterValue"].ToString()));
advisorPreferenceVo = adviserPreferenceBo.GetAdviserPreference(advisorVo.advisorId);
break;
case "CID":
customerVo = customerBo.GetCustomer(Convert.ToInt32(dr["WRD_InputParameterValue"].ToString()));
rmVo = advisorStaffBo.GetAdvisorStaffDetails(customerVo.RmId);
break;
case "RT":
reportType = Convert.ToString(dr["WRD_InputParameterValue"]);
break;
}
}
foreach (DataRow dr in dtAdviserEmailTemplate.Rows)
{
if (dr["WERPTTM_TypeCode"].ToString() == emailTypeCode)
{
email.Body = email.Body.Replace("[EMAIL_BODY]", dr["AHTMLT_TemplateBody"].ToString());
templateId = dr["AHTMLT_Id"].ToString();
break;
}
}
foreach (DataRow dr in dtEmailTemplateParameters.Rows)
{
string templateCode = dr["WERPTPM_TemplateParameterCode"].ToString();
switch (templateCode)
{
case "[ADVISER_NAME]":
email.Body = email.Body.Replace(templateCode, advisorVo.FirstName + " " + advisorVo.MiddleName + " " + advisorVo.LastName);
break;
case "[ADVISER_PHONE]":
email.Body = email.Body.Replace(templateCode, advisorVo.Phone1Std + "-" + advisorVo.Phone1Number);
break;
case "[ADVISER_MOBILE]":
email.Body = email.Body.Replace(templateCode, advisorVo.MobileNumber.ToString());
break;
case "[ADVISER_EMAIL]":
email.Body = email.Body.Replace(templateCode, advisorVo.Email.ToString());
break;
case "[A_WEB_SITE]":
email.Body = email.Body.Replace(templateCode, advisorPreferenceVo.WebSiteDomainName.ToString());
break;
case "[RM_NAME]":
email.Body = email.Body.Replace(templateCode, rmVo.FirstName + " " + rmVo.MiddleName + " " + rmVo.LastName);
break;
case "[RM_MOBILE]":
email.Body = email.Body.Replace(templateCode, rmVo.Mobile.ToString());
break;
case "[RM_EMAIL]":
email.Body = email.Body.Replace(templateCode, rmVo.Email.ToString());
break;
case "[CUSTOMER_FIRST_NAME]":
email.Body = email.Body.Replace(templateCode, customerVo.FirstName);
break;
case "[CUSTOMER_MIDDLE_NAME]":
email.Body = email.Body.Replace(templateCode, customerVo.MiddleName);
break;
case "[CUSTOMER_LAST_NAME]":
email.Body = email.Body.Replace(templateCode, customerVo.LastName);
break;
case "[START_LINE]":
email.Body = email.Body.Replace(templateCode, "<font face=" + "\"" + "[TEXT_FONT_NAME]" + "\"" + " size=" + "\"" + "[TEXT_FONT_SIZE]" + "\"" + " color=" + "\"" + "[TEXT_COLOR]" + "\"" + ">");
break;
case "[END_LINE]":
email.Body = email.Body.Replace(templateCode, "</font>");
break;
case "[LINE_BREAK]":
email.Body = email.Body.Replace(templateCode, "<br />");
break;
case "[ONE_EMPTY_SPACE]":
email.Body = email.Body.Replace(templateCode, " ");
break;
case "[HYPERLINK_START]":
email.Body = email.Body.Replace(templateCode, "<a href=" + "\"" + "[A_WEB_SITE]" + "\"" + "target=" + "\"" + "_blank" + "\"" + ">");
break;
case "[HYPERLINK_END]":
email.Body = email.Body.Replace(templateCode, "</a>");
break;
case "[FONT_BOLD_START]":
email.Body = email.Body.Replace(templateCode, "<b>");
break;
case "[FONT_BOLD_END]":
email.Body = email.Body.Replace(templateCode, "</b>");
break;
case "[TEXT_FONT_NAME]":
email.Body = email.Body.Replace(templateCode, GetTemplateParamerValue(dtAdviserTemplateParametersPre, templateId, dr["WERPTPM_ParameterCode"].ToString()));
break;
case "[TEXT_FONT_SIZE]":
email.Body = email.Body.Replace(templateCode, GetTemplateParamerValue(dtAdviserTemplateParametersPre, templateId, dr["WERPTPM_ParameterCode"].ToString()));
break;
case "[TEXT_COLOR]":
email.Body = email.Body.Replace(templateCode, GetTemplateParamerValue(dtAdviserTemplateParametersPre, templateId, dr["WERPTPM_ParameterCode"].ToString()));
break;
case "[REPORT_TYPE]":
//string reportType = GetTemplateParamerValue(dtAdviserTemplateParametersPre, reportTypeCode, dr["WERPTPM_ParameterCode"].ToString());
email.Body = email.Body.Replace(templateCode, reportType);
email.Subject = email.Subject.Replace(templateCode, reportType);
break;
}
//email.Subject = email.Subject.Replace("MoneyTouch", advisorVo.OrganizationName);
//email.Body = email.Body.Replace("[ORGANIZATION]", advisorVo.OrganizationName);
//email.Body = email.Body.Replace("[CUSTOMER_NAME]", userVo.FirstName);
//if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Wealtherp")
//{
// email.Body = email.Body.Replace("[WEBSITE]", advisorPreferenceVo.WebSiteDomainName);
//}
//else if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Citrus")
//{
// email.Body = email.Body.Replace("[WEBSITE]", advisorPreferenceVo.WebSiteDomainName);
//}
//email.Body = email.Body.Replace("[CONTACTPERSON]", advisorVo.ContactPersonFirstName + " " + advisorVo.ContactPersonMiddleName + " " + advisorVo.ContactPersonLastName);
//if (!string.IsNullOrEmpty(advisorVo.Designation))
// email.Body = email.Body.Replace("[DESIGNATION]", advisorVo.Designation);
//else
// email.Body = email.Body.Replace("[DESIGNATION]", string.Empty);
//if (!string.IsNullOrEmpty(advisorVo.Phone1Number.ToString()))
// email.Body = email.Body.Replace("[PHONE]", advisorVo.Phone1Std.ToString() + "-" + advisorVo.Phone1Number.ToString());
//else
// email.Body = email.Body.Replace("[PHONE]", string.Empty);
//if (!string.IsNullOrEmpty(advisorVo.Email))
// email.Body = email.Body.Replace("[EMAIL]", advisorVo.Email);
//else
// email.Body = email.Body.Replace("[EMAIL]", string.Empty);
//if (_SMTPDefaultCredentials == true)
//{
// NetworkCredential basicCredential = new NetworkCredential(_SMTPUsername, _SMTPPassword);
// smtpClient.UseDefaultCredentials = false;
// smtpClient.Credentials = basicCredential;
//}
//else
//{
// smtpClient.UseDefaultCredentials = true;
//}
//smtpClient.Host = _SMTPServer;
//if (_SMTPPort > 0)
// smtpClient.Port = _SMTPPort;
////Hardcoding SSL settings for gmail SMTP
//if (_SMTPServer.Contains("smtp.gmail.com") || _SMTPServer.Contains("smtp.live.com"))
//{
// smtpClient.EnableSsl = true;
//}
//if (Cc != null && Cc.Trim().Length > 0)
// mail.CC.Add(Cc);
//if (Bcc != null && Bcc.Trim().Length > 0)
// mail.Bcc.Add(Bcc);
//if (!string.IsNullOrEmpty(_SMTPFromDisplay.Trim()))
//{
// if (_SMTPDefaultCredentials == true)
// {
// MailAddress md1 = new MailAddress(_SMTPUsername, _SMTPFromDisplay);
// mail.From = md1;
// }
// if (!string.IsNullOrEmpty(from.Trim()))
// {
// MailAddress md3 = new MailAddress(_SMTPFrom, _SMTPFromDisplay);
// mail.ReplyTo = md3;
// }
//}
//mail.Subject = Subject;
//mail.IsBodyHtml = true;
//mail.Body = Body;
//if (mail.AlternateViews.Count != 0)
//{
// foreach (AlternateView altrView in mail.AlternateViews)
// {
// mail.AlternateViews.Add(altrView);
// }
//}
//smtpClient.Send(mail);
}
foreach (object obj in Attachments)
{
Attachment attachment = attachment = new Attachment(obj.ToString());
email.Attachments.Add(attachment);
}
//SendMail(To, Cc, Bcc, email.Subject.ToString(), email.Body.ToString(), Attachments, from, dtAdviserSMTP,out fromSMTPEmail);
email.Body = email.Body.Replace("[A_WEB_SITE]", advisorPreferenceVo.WebSiteDomainName.ToString());
email.Body = email.Body.Replace("[A_LOGO]", "<img src='cid:HDIImage' alt='Logo'>");
string logoPath = string.Empty;
System.Net.Mail.AlternateView htmlView;
System.Net.Mail.AlternateView plainTextView = System.Net.Mail.AlternateView.CreateAlternateViewFromString("Text view", null, "text/plain");
//System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(hidBody.Value.Trim() + "<image src=cid:HDIImage>", null, "text/html");
htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(email.Body, null, "text/html");
//Add image to HTML version
if (advisorVo != null)
{
logoPath = _AdviserLogoDirectory + "\\" + advisorVo.LogoPath;
}
if (!File.Exists(logoPath))
{
logoPath = _AdviserLogoDirectory + "\\spacer.png";
}
//System.Net.Mail.LinkedResource imageResource = new System.Net.Mail.LinkedResource(Server.MapPath("~/Images/") + @"\3DSYRW_4009.JPG", "image/jpeg");
System.Net.Mail.LinkedResource imageResource = new System.Net.Mail.LinkedResource(logoPath, "image/jpeg");
imageResource.ContentId = "HDIImage";
htmlView.LinkedResources.Add(imageResource);
//Add two views to message.
email.AlternateViews.Add(plainTextView);
email.AlternateViews.Add(htmlView);
//SendMail(To, Cc, Bcc, email.Subject.ToString(), email.Body.ToString(), Attachments, from, dtAdviserSMTP, out fromSMTPEmail);
SendMail(email, out statusMessage);
}
protected void btnSendEmailToIFF_Click(object sender, EventArgs e)
{
int selectedRecords = 0;
string statusMessage = string.Empty;
advisorVo = (AdvisorVo)Session["advisorVo"];
AdvisorBo advisorBo = new AdvisorBo();
RMVo rmVo = new RMVo();
AdvisorStaffBo advisorStaffBo = new AdvisorStaffBo();
Random r = new Random();
string logoPath = string.Empty;
if (Page.IsValid)
{
try
{
foreach (GridViewRow gvr in gvIFFUsers.Rows)
{
if (((CheckBox)gvr.FindControl("chkBoxChild")).Checked == true)
{
selectedRecords++;
userId = int.Parse(gvIFFUsers.DataKeys[gvr.RowIndex].Value.ToString());
advisorVo = advisorBo.GetAdvisorUser(userId);
rmVo = advisorStaffBo.GetAdvisorStaff(userId);
Emailer emailer = new Emailer();
EmailMessage email = new EmailMessage();
string hassedPassword = string.Empty;
string saltValue = string.Empty;
string password = r.Next(20000, 100000).ToString();
userVo = userBo.GetUserDetails(userId);
string userName = userVo.FirstName + " " + userVo.MiddleName + " " + userVo.LastName;
encryption.GetHashAndSaltString(password, out hassedPassword, out saltValue);
userVo.Password = hassedPassword;
userVo.PasswordSaltValue = saltValue;
userVo.OriginalPassword = password;
userVo.IsTempPassword = 1;
email.GetResetPasswordMail(userVo.LoginId, password, userName);
//email.Subject = email.Subject.Replace("WealthERP", advisorVo.OrganizationName);
//email.Subject = email.Subject.Replace("MoneyTouch", advisorVo.OrganizationName);
//email.Body = email.Body.Replace("[ORGANIZATION]", advisorVo.OrganizationName);
email.To.Add(userVo.Email);
AdviserStaffSMTPBo adviserStaffSMTPBo = new AdviserStaffSMTPBo();
//int rmId = Convert.ToInt32(ViewState["rmId"]);
AdviserStaffSMTPVo adviserStaffSMTPVo = adviserStaffSMTPBo.GetSMTPCredentials(1000);
//adviserStaffSMTPVo.HostServer = "";
if (adviserStaffSMTPVo.HostServer != null && adviserStaffSMTPVo.HostServer != string.Empty)
{
emailer.isDefaultCredentials = !Convert.ToBoolean(adviserStaffSMTPVo.IsAuthenticationRequired);
if (!String.IsNullOrEmpty(adviserStaffSMTPVo.Password))
{
emailer.smtpPassword = Encryption.Decrypt(adviserStaffSMTPVo.Password);
}
emailer.smtpPort = int.Parse(adviserStaffSMTPVo.Port);
emailer.smtpServer = adviserStaffSMTPVo.HostServer;
emailer.smtpUserName = adviserStaffSMTPVo.Email;
//email.Subject = email.Subject.Replace("WealthERP", advisorVo.OrganizationName);
//email.Subject = email.Subject.Replace("MoneyTouch", advisorVo.OrganizationName);
email.Body = email.Body.Replace("[ORGANIZATION]", "WealthERP Team");
if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Wealtherp")
{
email.Body = email.Body.Replace("[WEBSITE]", "https://app.wealtherp.com/");
}
email.Body = email.Body.Replace("[CONTACTPERSON]", "Customer Care");
email.Body = email.Body.Replace("[DESIGNATION]", "Team WealthERP");
email.Body = email.Body.Replace("[PHONE]", "+91 9663305249 <br/>Skype: custcare.ampsys");
email.Body = email.Body.Replace("[EMAIL]", "*****@*****.**");
email.Body = email.Body.Replace("[LOGO]", "<img src='cid:HDIImage' alt='Logo'>");
System.Net.Mail.AlternateView htmlView;
System.Net.Mail.AlternateView plainTextView = System.Net.Mail.AlternateView.CreateAlternateViewFromString("Text view", null, "text/plain");
//System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(hidBody.Value.Trim() + "<image src=cid:HDIImage>", null, "text/html");
htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString("<html><body " + "style='font-family:Tahoma, Arial; font-size: 10pt;'><p>" + email.Body + "</p></body></html>", null, "text/html");
//Add image to HTML version
logoPath = "~/Images/WealthERP.jpf";
if (!File.Exists(Server.MapPath(logoPath)))
{
logoPath = "~/Images/spacer.png";
}
//System.Net.Mail.LinkedResource imageResource = new System.Net.Mail.LinkedResource(Server.MapPath("~/Images/") + @"\3DSYRW_4009.JPG", "image/jpeg");
System.Net.Mail.LinkedResource imageResource = new System.Net.Mail.LinkedResource(Server.MapPath(logoPath), "image/jpeg");
imageResource.ContentId = "HDIImage";
htmlView.LinkedResources.Add(imageResource);
//Add two views to message.
email.AlternateViews.Add(plainTextView);
email.AlternateViews.Add(htmlView);
//Send message
//System.Net.Mail.SmtpClient smtpClient = new System.Net.Mail.SmtpClient();
//Assign SMTP Credentials if configured.
if (adviserStaffSMTPVo.HostServer != null && adviserStaffSMTPVo.HostServer != string.Empty)
{
emailer.isDefaultCredentials = !Convert.ToBoolean(adviserStaffSMTPVo.IsAuthenticationRequired);
if (!String.IsNullOrEmpty(adviserStaffSMTPVo.Password))
{
emailer.smtpPassword = Encryption.Decrypt(adviserStaffSMTPVo.Password);
}
emailer.smtpPort = int.Parse(adviserStaffSMTPVo.Port);
emailer.smtpServer = adviserStaffSMTPVo.HostServer;
emailer.smtpUserName = adviserStaffSMTPVo.Email;
if (Convert.ToBoolean(adviserStaffSMTPVo.IsAuthenticationRequired))
{
if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Wealtherp")
{
email.From = new MailAddress(emailer.smtpUserName, "WealthERP Team");
}
}
}
//if (Convert.ToBoolean(adviserStaffSMTPVo.IsAuthenticationRequired))
//{
// if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Wealtherp")
// {
// email.From = new MailAddress(emailer.smtpUserName, advisorVo.OrganizationName);
// }
// else if (ConfigurationSettings.AppSettings["HostName"].ToString() == "MoneyTouch")
// {
// email.From = new MailAddress(emailer.smtpUserName, advisorVo.OrganizationName);
// }
//}
}
bool isMailSent = false;
if (userBo.UpdateUser(userVo))
{
isMailSent = emailer.SendMail(email);
}
if (isMailSent)
{
statusMessage = "Credentials have been reset & sent to selected Adviser";
tblMessage.Visible = true;
tblErrorMassage.Visible = false;
//ErrorMessage.Visible = false;
SuccessMsg.InnerText = statusMessage;
//SuccessMsg.Visible = true;
}
else
{
statusMessage = "An error occurred while sending mail to selected Adviser";
tblMessage.Visible = false;
tblErrorMassage.Visible = true;
//ErrorMessage.Visible = true;
ErrorMessage.InnerText = statusMessage;
//SuccessMsg.Visible = false;
}
}
}
tblErrorMassage.Visible = false;
//ErrorMessage.Visible = false;
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "RMCustomerUserDetails.ascx:btnGenerate_Click()");
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
}
private bool SendMail(UserVo userVo)
{
Emailer emailer = new Emailer();
EmailMessage email = new EmailMessage();
advisorVo = (AdvisorVo)Session["advisorVo"];
bool isMailSent = false;
bool isEmailIdBlank = false;
try
{
UserVo uservo = (UserVo)Session["userVo"];
AdvisorStaffBo adviserstaffbo = new AdvisorStaffBo();
//Get SMTP settings of admin if configured.
RMVo advrm = new RMVo();
advrm = adviserstaffbo.GetAdvisorStaff(uservo.UserId);
AdviserStaffSMTPBo adviserStaffSMTPBo = new AdviserStaffSMTPBo();
AdviserStaffSMTPVo adviserStaffSMTPVo = adviserStaffSMTPBo.GetSMTPCredentials(advrm.RMId);
//Get the mail contents
if (userVo.Email.Trim() != string.Empty)
{
email.To.Add(userVo.Email);
string name = userVo.FirstName + " " + userVo.MiddleName + " " + userVo.LastName;
email.GetCustomerAccountMail(userVo.LoginId, Encryption.Decrypt(userVo.Password), name);
email.Subject = email.Subject.Replace("WealthERP", advisorVo.OrganizationName);
email.Subject = email.Subject.Replace("MoneyTouch", advisorVo.OrganizationName);
email.Body = email.Body.Replace("[ORGANIZATION]", advisorVo.OrganizationName);
//Assign SMTP Credentials if configured.
if (adviserStaffSMTPVo.HostServer != null && adviserStaffSMTPVo.HostServer != string.Empty)
{
emailer.isDefaultCredentials = !Convert.ToBoolean(adviserStaffSMTPVo.IsAuthenticationRequired);
if (!String.IsNullOrEmpty(adviserStaffSMTPVo.Password))
{
emailer.smtpPassword = Encryption.Decrypt(adviserStaffSMTPVo.Password);
}
emailer.smtpPort = int.Parse(adviserStaffSMTPVo.Port);
emailer.smtpServer = adviserStaffSMTPVo.HostServer;
emailer.smtpUserName = adviserStaffSMTPVo.Email;
if (Convert.ToBoolean(adviserStaffSMTPVo.IsAuthenticationRequired))
{
if (ConfigurationSettings.AppSettings["HostName"].ToString() == "Wealtherp")
{
email.From = new MailAddress(emailer.smtpUserName, advisorVo.OrganizationName);
}
else if (ConfigurationSettings.AppSettings["HostName"].ToString() == "MoneyTouch")
{
email.From = new MailAddress(emailer.smtpUserName, advisorVo.OrganizationName);
}
}
}
//Sending mail...
isMailSent = emailer.SendMail(email);
}
else
{
isEmailIdBlank = true;
}
if (isEmailIdBlank)
{
if (string.IsNullOrEmpty(statusMessage))
{
statusMessage = "No email Id specified for slected User";
tblMessage.Visible = true;
ErrorMessage.Visible = true;
ErrorMessage.InnerText = statusMessage;
SuccessMsg.Visible = false;
}
else
{
statusMessage = statusMessage + " and some selected User don't have E-mail id";
tblMessage.Visible = true;
ErrorMessage.Visible = true;
ErrorMessage.InnerText = statusMessage;
SuccessMsg.Visible = false;
}
}
else if (isMailSent)
{
if (string.IsNullOrEmpty(statusMessage))
{
statusMessage = "Credentials have been sent to selected User";
tblMessage.Visible = true;
ErrorMessage.Visible = false;
SuccessMsg.InnerText = statusMessage;
SuccessMsg.Visible = true;
}
else if (statusMessage == "No email Id specified for slected User")
{
statusMessage = "some selected User don't have E-mail id and Credentials have been sent sucessfully to rest of User";
statusMessage = "Credentials have been sent to selected User";
tblMessage.Visible = true;
ErrorMessage.Visible = false;
SuccessMsg.InnerText = statusMessage;
SuccessMsg.Visible = true;
}
else
{
tblMessage.Visible = true;
ErrorMessage.Visible = false;
SuccessMsg.InnerText = statusMessage;
SuccessMsg.Visible = true;
}
}
else
{
statusMessage = "An error occurred while sending mail .. ";
tblMessage.Visible = true;
ErrorMessage.Visible = true;
ErrorMessage.InnerText = statusMessage;
SuccessMsg.Visible = false;
}
}
catch (Exception ex)
{
}
return(isMailSent);
}
