/// <summary>
/// Binding Customer List at diffrent user role
/// </summary>
protected void BindCustomerGrid()
{
AdvisorBo adviserBo = new AdvisorBo();
DataSet dsCustList;
RMVo customerRMVo = new RMVo();
try {
dsCustList = adviserBo.GetAssociateCustomerList(adviserId, UserRole, agentCode);
gvAssocCustList.DataSource = dsCustList.Tables[0];
gvAssocCustList.DataBind();
Cache.Insert(userVo.UserId.ToString() + "assocCustList", dsCustList.Tables[0]);
}
catch (BaseApplicationException Ex)
{
throw Ex;
}
catch (Exception Ex)
{
BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex);
NameValueCollection FunctionInfo = new NameValueCollection();
FunctionInfo.Add("Method", "AssociateCustomerList.ascx.cs:BindCustomerGrid()");
object[] objects = new object[4];
objects[0] = user;
objects[1] = rmId;
objects[2] = objects;
//customerVo[3] = dsCustList;
FunctionInfo = exBase.AddObject(FunctionInfo, objects);
exBase.AdditionalInformation = FunctionInfo;
ExceptionManager.Publish(exBase);
throw exBase;
}
}
public void GetAdviserCustomerForSMS()
{
int adviserId = 0;
string namesearch = "";
List <CustomerVo> customerList = new List <CustomerVo>();
AdvisorBo adviserBo = new AdvisorBo();
DataTable dtAdviserCustomerAlerts = new DataTable();
dtAdviserCustomerAlerts.Columns.Add("CustomerId");
dtAdviserCustomerAlerts.Columns.Add("CustomerName");
dtAdviserCustomerAlerts.Columns.Add("Mobile");
if (gvCustomerSMSAlerts.HeaderRow != null)
{
namesearch = ((TextBox)gvCustomerSMSAlerts.HeaderRow.FindControl("txtCustomerSearch")).Text;
}
DataRow dr;
if (Session["advisorVo"] != null)
{
adviserId = ((AdvisorVo)Session["advisorVo"]).advisorId;
}
customerList = adviserBo.GetAdviserCustomersForSMS(adviserId, namesearch);
if (customerList != null)
{
for (int i = 0; i < customerList.Count; i++)
{
dr = dtAdviserCustomerAlerts.NewRow();
dr[0] = customerList[i].CustomerId;
dr[1] = customerList[i].FirstName;
dr[2] = customerList[i].Mobile1;
dtAdviserCustomerAlerts.Rows.Add(dr);
}
if (dtAdviserCustomerAlerts.Rows.Count == 0)
{
dr = dtAdviserCustomerAlerts.NewRow();
dr[0] = "";
dr[1] = "";
dr[2] = "";
dtAdviserCustomerAlerts.Rows.Add(dr);
}
gvCustomerSMSAlerts.DataSource = dtAdviserCustomerAlerts;
gvCustomerSMSAlerts.DataBind();
gvCustomerSMSAlerts.Visible = true;
pnlCustomerSMSAlerts.Visible = true;
lblNoRecords.Visible = false;
}
else
{
lblNoRecords.Visible = true;
gvCustomerSMSAlerts.Visible = false;
}
BindGridSearchBoxes(namesearch);
}
protected void gvCustomerCategory_ItemCommand(object source, GridCommandEventArgs e)
{
int CategoryCode = 0;
string strExternalCode = string.Empty;
string CategoryName = string.Empty;
DateTime createdDate = new DateTime();
DateTime editedDate = new DateTime();
DateTime deletedDate = new DateTime();
if (e.CommandName == RadGrid.UpdateCommandName)
{
//strExternalCodeToBeEdited = Session["extCodeTobeEdited"].ToString();
AdvisorBo advisorBo = new AdvisorBo();
bool isUpdated = false;
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
TextBox txtCategorycode = (TextBox)e.Item.FindControl("txtCategoryCode");
TextBox txtCusCategoryName = (TextBox)e.Item.FindControl("txtCategoryName");
txtCategorycode.Enabled = false;
CategoryCode = int.Parse(txtCategorycode.Text);
CategoryName = txtCusCategoryName.Text;
isUpdated = advisorBo.EditAdviserCustomerCategory(CategoryCode, CategoryName, advisorVo.advisorId);
}
if (e.CommandName == RadGrid.DeleteCommandName)
{
bool isDeleted = false;
advisorBo = new AdvisorBo();
GridDataItem dataItem = (GridDataItem)e.Item;
TableCell strCategoryCodeForDelete = dataItem["ACC_CustomerCategoryCode"];
CategoryCode = int.Parse(strCategoryCodeForDelete.Text);
deletedDate = DateTime.Now;
isDeleted = advisorBo.DeleteAdviserCustomerCategory(CategoryCode);
if (!isDeleted)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Pageloadscript", "alert('Already Assigned to Customer. Please remove association first');", true);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Pageloadscript", "alert('Record has been deleted successfully !!');", true);
}
}
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
bool isInserted = false;
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
//TextBox txtCategorycode = (TextBox)e.Item.FindControl("txtCategoryCode");
TextBox txtCusCategoryName = (TextBox)e.Item.FindControl("txtCategoryName");
//CategoryCode = int.Parse(txtCategorycode.Text);
CategoryName = txtCusCategoryName.Text;
isInserted = advisorBo.InsertAdviserCustomerCategory(CategoryName, advisorVo.advisorId);
}
BindCustomerCategory();
}
private DataSet gvAdvisorCategoryBind(int advisorId, int ACM_ID)
{
AdvisorBo advisorbo = new AdvisorBo();
try
{
DataSet categorylist = advisorbo.gvAdvisorCategoryBind(advisorId, ACM_ID);
return(categorylist);
}
catch (Exception ex)
{
throw ex;
}
}
protected void gvCustomerCategory_ItemDataBound(object sender, GridItemEventArgs e)
{
advisorBo = new AdvisorBo();
if (e.Item is GridEditFormInsertItem && e.Item.OwnerTableView.IsItemInserted)
{
GridEditFormInsertItem item = (GridEditFormInsertItem)e.Item;
//TextBox txtBox = (TextBox)item.FindControl("txtCategoryCode");
TextBox txtBoxScName = (TextBox)item.FindControl("txtCategoryName");
//txtBox.Text = txtSchemePlanCode.Value;
//txtBoxScName.Text = txtSchemeName.Text;
//txtBox.Enabled = false;
//txtBoxScName.Enabled = false;
}
if (e.Item is GridDataItem)
{
GridDataItem dataItem = e.Item as GridDataItem;
//string schemeName = dataItem["PASC_AMC_ExternalType"].Text;
LinkButton buttonEdit = dataItem["editColumn"].Controls[0] as LinkButton;
LinkButton buttonDelete = dataItem["deleteColumn"].Controls[0] as LinkButton;
//Label lbl = new Label();
//lbl = (Label)e.Item.FindControl("lblFiletypeId");
//if (schemeName == "AMFI" || schemeName == "ValueResearch" || schemeName == "AF")
//{
// buttonEdit.Enabled = false;
// buttonDelete.Enabled = false;
// buttonDelete.Attributes["onclick"] = "return alert('You cannot delete this scheme')";
// buttonEdit.Attributes["onclick"] = "return alert('You cannot Edit this scheme')";
//}
}
if (e.Item is GridEditFormItem && e.Item.IsInEditMode && e.Item.ItemIndex != -1)
{
string strExtType = gvCustomerCategory.MasterTableView.DataKeyValues[e.Item.ItemIndex]["ACC_CustomerCategoryCode"].ToString();
//strExternalCodeToBeEdited = gvCustomerCategory.MasterTableView.DataKeyValues[e.Item.ItemIndex]["gvCustomerCategory"].ToString();
//if (Session["extCodeTobeEdited"] != null)
// Session["extCodeTobeEdited"] = null;
//Session["extCodeTobeEdited"] = strExternalCodeToBeEdited;
GridEditFormItem editedItem = (GridEditFormItem)e.Item;
//DropDownList dropDownList = (DropDownList)editedItem.FindControl("ddlExternalType");
//dropDownList.SelectedValue = strExtType;
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
int smsCount = 0;
int smsLicence = 0;
SMSVo smsVo = new SMSVo();
EmailSMSBo emailSMSBo = new EmailSMSBo();
List <SMSVo> smsVoList = new List <SMSVo>();
AdvisorBo advisorBo = new AdvisorBo();
int adviserId = 0;
if (Session["advisorVo"] != null)
{
adviserId = ((AdvisorVo)Session["advisorVo"]).advisorId;
}
if (lblLincenceValue.Text != "No SMS Credit Left!!")
{
smsLicence = int.Parse(lblLincenceValue.Text.ToString());
}
foreach (GridViewRow gvRow in gvCustomerSMSAlerts.Rows)
{
if (gvRow.RowType == DataControlRowType.DataRow)
{
if (((CheckBox)gvRow.FindControl("chkCustomerSMSAlert")).Checked)
{
smsVo = new SMSVo();
if (gvRow.Cells[2].Text.Trim().Length <= 10)
{
smsVo.Mobile = Int64.Parse("91" + gvRow.Cells[2].Text.Trim());
}
else
{
smsVo.Mobile = int.Parse(gvRow.Cells[2].Text.Trim());
}
smsVo.Message = txtMessage.Text.ToString();
smsVo.CustomerId = int.Parse(gvCustomerSMSAlerts.DataKeys[gvRow.RowIndex].Values["CustomerId"].ToString());
smsVo.IsSent = 0;
smsVo.AdviserId = adviserId;
smsVoList.Add(smsVo);
smsCount++;
}
}
}
if (smsCount <= smsLicence && smsCount != 0)
{
smsVoList = emailSMSBo.AddToSMSQueue(smsVoList);
//smsLicence = smsLicence - smsCount;
//advisorBo.UpdateAdviserSMSLicence(adviserId, smsCount);
advisorBo.AddToAdviserSMSLog(smsVoList, adviserId, "Manual Message");
if (smsLicence == 0)
{
lblLincenceValue.Text = "No SMS Licence Left!!";
}
else
{
lblLincenceValue.Text = smsLicence.ToString();
}
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('SMS has been Sent to the Selected Customers!!');", true);
}
else if (smsCount == 0)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('Please select a Customer!!');", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "pageloadscript", "alert('You dont have enough SMS Credits to process this request');", true);
}
}
public void GetAdviserCustomerForSMS()
{
//int adviserId = 0;
//int rmId = 0;
string namesearch = "";
List <CustomerVo> customerList = new List <CustomerVo>();
AdvisorBo adviserBo = new AdvisorBo();
DataTable dtAdviserCustomerAlerts = new DataTable();
dtAdviserCustomerAlerts.Columns.Add("CustomerId");
dtAdviserCustomerAlerts.Columns.Add("CustomerName");
dtAdviserCustomerAlerts.Columns.Add("Mobile");
if (gvCustomerSMSAlerts.HeaderRow != null)
{
namesearch = ((TextBox)gvCustomerSMSAlerts.HeaderRow.FindControl("txtCustomerSearch")).Text;
}
DataRow dr;
//if (Session["advisorVo"] != null)
// adviserId = ((AdvisorVo)Session["advisorVo"]).advisorId;
ErrorMessage.Visible = false;
btnSend.Visible = true;
if (hdnCheckDPselection.Value != "")
{
namesearch = "";
}
customerList = adviserBo.GetAdviserCustomersForSMS(int.Parse(hdnAdviserId.Value), int.Parse(hdnRmId.Value), namesearch);
if (customerList.Count != 0)
{
for (int i = 0; i < customerList.Count; i++)
{
dr = dtAdviserCustomerAlerts.NewRow();
dr[0] = customerList[i].CustomerId;
dr[1] = customerList[i].FirstName;
dr[2] = customerList[i].Mobile1;
dtAdviserCustomerAlerts.Rows.Add(dr);
}
if (dtAdviserCustomerAlerts.Rows.Count == 0)
{
dr = dtAdviserCustomerAlerts.NewRow();
dr[0] = "";
dr[1] = "";
dr[2] = "";
dtAdviserCustomerAlerts.Rows.Add(dr);
}
trmsgTxtBox.Visible = true;
gvCustomerSMSAlerts.DataSource = dtAdviserCustomerAlerts;
gvCustomerSMSAlerts.DataBind();
gvCustomerSMSAlerts.Visible = true;
pnlCustomerSMSAlerts.Visible = true;
//lblNoRecords.Visible = false;
BindGridSearchBoxes(namesearch);
}
else
{
if (hdnCheckDPselection.Value != "")
{
btnSend.Visible = false;
gvCustomerSMSAlerts.Visible = false;
trmsgTxtBox.Visible = false;
}
else
{
if (!IsPostBack)
{
btnSend.Visible = false;
trmsgTxtBox.Visible = false;
}
else
{
btnSend.Visible = true;
trmsgTxtBox.Visible = true;
}
gvCustomerSMSAlerts.Visible = true;
}
ErrorMessage.Visible = true;
}
}
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 gvAdvisorCategory_ItemCommand(object source, GridCommandEventArgs e)
{
AdvisorBo advisorbo = new AdvisorBo();
if (e.CommandName == RadGrid.PerformInsertCommandName)
{
string categoryname;
int acm_id;
gvAdvisorCategory.Visible = true;
bool isInserted = false;
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
TextBox txtCategoryName = (TextBox)e.Item.FindControl("txtCategoryName");
categoryname = txtCategoryName.Text;
acm_id = Convert.ToInt32(ddlCategory.SelectedValue);
int AC_CategoryId = 0;
isInserted = advisorbo.InsertEditDeleteCategory(categoryname, advisorVo.advisorId, acm_id, AC_CategoryId, "Insert");
if (isInserted == false)
{
Response.Write(@"<script language='javascript'>alert('Cannot be Inserted');</script>");
}
else
{
Response.Write(@"<script language='javascript'>alert('Inserted successfully.');</script>");
}
}
if (e.CommandName == RadGrid.UpdateCommandName)
{
string categoryname;
int acm_id;
gvAdvisorCategory.Visible = true;
bool isUpdated = false;
GridEditableItem gridEditableItem = (GridEditableItem)e.Item;
TextBox txtCategoryName = (TextBox)e.Item.FindControl("txtCategoryName");
acm_id = Convert.ToInt32(ddlCategory.SelectedValue);
categoryname = txtCategoryName.Text;
int AC_CategoryId = Convert.ToInt32(gvAdvisorCategory.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AC_CategoryId"].ToString());
isUpdated = advisorbo.InsertEditDeleteCategory(categoryname, advisorVo.advisorId, acm_id, AC_CategoryId, "Update");
if (isUpdated == false)
{
Response.Write(@"<script language='javascript'>alert('Cannot be Updated');</script>");
}
else
{
Response.Write(@"<script language='javascript'>alert('Updated successfully.');</script>");
}
}
if (e.CommandName == RadGrid.DeleteCommandName)
{
int ACM_ID;
bool isDeleted;
string categoryname;
ACM_ID = Convert.ToInt32(gvAdvisorCategory.MasterTableView.DataKeyValues[e.Item.ItemIndex]["ACM_ID"]);
categoryname = gvAdvisorCategory.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AC_CategoryName"].ToString();
int AC_CategoryId = Convert.ToInt32(gvAdvisorCategory.MasterTableView.DataKeyValues[e.Item.ItemIndex]["AC_CategoryId"].ToString());
//check if deleted then show message
isDeleted = advisorbo.InsertEditDeleteCategory(categoryname, advisorVo.advisorId, ACM_ID, AC_CategoryId, "Delete");
if (isDeleted == false)
{
Response.Write(@"<script language='javascript'>alert('Cannot be Deleted');</script>");
}
else
{
Response.Write(@"<script language='javascript'>alert('Deleted successfully.');</script>");
}
}
bindgrid();
}
