public void SendOfflineChatEmail(int LoginUserID, int UserID, string LoginUserInstallID,
string Message, int ChatSource, string BaseUrl, string chatGroupId)
{
// Get Html Template
string messageUrl = string.Empty, toEmail = string.Empty, body = string.Empty;
//string BaseUrl = System.Web.HttpContext.Current.Request.Url.Scheme + "://" + System.Web.HttpContext.Current.Request.Url.Authority + System.Web.HttpContext.Current.Request.ApplicationPath.TrimEnd('/') + "/";
HTMLTemplatesMaster html = HTMLTemplateBLL.Instance.GetHTMLTemplateMasterById(HTMLTemplates.HR_EditSales_TouchpointLog_Email);
// sender details
var sender = InstallUserBLL.Instance.getuserdetails(LoginUserID).Tables[0].Rows[0];
string pic = string.IsNullOrEmpty(sender["Picture"].ToString()) ? "default.jpg"
: sender["Picture"].ToString().Replace("~/UploadeProfile/", "");
pic = BaseUrl + "Employee/ProfilePictures/" + pic;
html.Body = html.Body.Replace("{ImageUrl}", pic);
html.Body = html.Body.Replace("{Name}", sender["FristName"].ToString() + " " + sender["LastName"].ToString());
html.Body = html.Body.Replace("{Designation}", sender["Designation"].ToString());
html.Body = html.Body.Replace("{UserInstallID}", sender["UserInstallID"].ToString());
html.Body = html.Body.Replace("{ProfileUrl}", BaseUrl + "Sr_App/ViewSalesUser.aspx?id=" + sender["Id"].ToString());
html.Body = html.Body.Replace("{MessageContent}", Message.Replace("Note :", "").Trim());
// Generate auto login code
string loginCode = InstallUserDAL.Instance.GenerateLoginCode(UserID).Object;
var receiver = InstallUserBLL.Instance.getuserdetails(UserID).Tables[0].Rows[0];
toEmail = receiver["Email"].ToString();
messageUrl = BaseUrl + "Sr_App/TouchPointLog.aspx?TUID=" + UserID + "&CGID=" + chatGroupId +
"&auth=" + loginCode + "&RcvrID=" + LoginUserID + "&Src=" + ChatSource;
body = (html.Header + html.Body + html.Footer).Replace("{MessageUrl}", messageUrl);
EmailManager.SendEmail("New Message", toEmail, html.Subject, body, null);
}
protected void Page_Load(object sender, EventArgs e)
{
CommonFunction.AuthenticateUser();
if (!IsPostBack)
{
if (this.HTMLTemplate.HasValue)
{
ddlDesignation.DataSource = DesignationBLL.Instance.GetAllDesignation();
ddlDesignation.DataTextField = "DesignationName";
ddlDesignation.DataValueField = "ID";
ddlDesignation.DataBind();
ddlDesignation.Items.Insert(0, new ListItem("--Select--", "0"));
HTMLTemplatesMaster objHTMLTemplatesMaster = HTMLTemplateBLL.Instance.GetHTMLTemplateMasterById(this.HTMLTemplate.Value);
txtName.Text = objHTMLTemplatesMaster.Name;
txtSubject.Text = objHTMLTemplatesMaster.Subject;
txtHeader.Text = objHTMLTemplatesMaster.Header;
txtBody.Text = objHTMLTemplatesMaster.Body;
txtFooter.Text = objHTMLTemplatesMaster.Footer;
trMasterCopy.Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
CommonFunction.AuthenticateUser();
if (!IsPostBack)
{
if (this.HTMLTemplate.HasValue)
{
ddlCategory.DataSource = CommonFunction.GetHTMLTemplateCategoryList();
ddlCategory.DataTextField = "Text";
ddlCategory.DataValueField = "Value";
ddlCategory.DataBind();
ddlCategory.Items.Insert(0, new ListItem("--Select--", "0"));
//if (this.HTMLTemplateCategory.HasValue)
//{
// ddlCategory.SelectedValue = Convert.ToByte(this.HTMLTemplateCategory.Value).ToString();
//}
ddlDesignation.DataSource = DesignationBLL.Instance.GetAllDesignation();
ddlDesignation.DataTextField = "DesignationName";
ddlDesignation.DataValueField = "ID";
ddlDesignation.DataBind();
ddlDesignation.Items.Insert(0, new ListItem("--Select--", "0"));
HTMLTemplatesMaster objHTMLTemplatesMaster = HTMLTemplateBLL.Instance.GetHTMLTemplateMasterById(this.HTMLTemplate.Value);
txtName.Text = objHTMLTemplatesMaster.Name;
txtSubject.Text = objHTMLTemplatesMaster.Subject;
txtHeader.Content = objHTMLTemplatesMaster.Header;
txtBody.Content = objHTMLTemplatesMaster.Body;
txtFooter.Content = objHTMLTemplatesMaster.Footer;
if (objHTMLTemplatesMaster.Category.HasValue)
{
ddlCategory.SelectedValue = objHTMLTemplatesMaster.Category.Value.ToString();
}
trMasterCopy.Visible = true;
if (this.HTMLTemplate == HTMLTemplates.Offer_Made_Attachment_Template)
{
tblPayRates.Visible = true;
}
}
}
if (this.HTMLTemplateType.HasValue && this.HTMLTemplateType.Value == HTMLTemplateTypes.Template)
{
trCategory.Visible =
trSubject.Visible = false;
}
}
public HTMLTemplatesMaster GetHTMLTemplateMasterById(HTMLTemplates objHTMLTemplates)
{
try
{
SqlDatabase database = MSSQLDataBase.Instance.GetDefaultDatabase();
{
DbCommand command = database.GetStoredProcCommand("GetHTMLTemplateMasterById");
command.CommandType = CommandType.StoredProcedure;
database.AddInParameter(command, "@Id", DbType.Int16, (byte)objHTMLTemplates);
DataSet dsHTMLTemplate = database.ExecuteDataSet(command);
HTMLTemplatesMaster objHTMLTemplate = null;
if (
dsHTMLTemplate != null &&
dsHTMLTemplate.Tables.Count > 0 &&
dsHTMLTemplate.Tables[0].Rows.Count > 0
)
{
DataRow dr = dsHTMLTemplate.Tables[0].Rows[0];
objHTMLTemplate = new HTMLTemplatesMaster();
objHTMLTemplate.Id = Convert.ToInt32(dr["Id"]);
objHTMLTemplate.Type = Convert.ToByte(dr["Type"]);
if (!string.IsNullOrEmpty(Convert.ToString(dr["Category"])))
{
objHTMLTemplate.Category = Convert.ToByte(dr["Category"]);
}
else
{
objHTMLTemplate.Category = null;
}
objHTMLTemplate.Name = Convert.ToString(dr["Name"]);
objHTMLTemplate.Subject = Convert.ToString(dr["Subject"]);
objHTMLTemplate.Header = Convert.ToString(dr["Header"]);
objHTMLTemplate.Body = Convert.ToString(dr["Body"]);
objHTMLTemplate.Footer = Convert.ToString(dr["Footer"]);
objHTMLTemplate.DateUpdated = Convert.ToDateTime(dr["DateUpdated"]);
}
return(objHTMLTemplate);
}
}
catch (Exception ex)
{
return(null);
}
}
public int AddTouchPointLogRecord(int LoginUserID, int UserID, string LoginUserInstallID, DateTime now, string ChangeLog, string strGUID, int touchPointSource)
{
var LastUserTouchPoint = InstallUserDAL.Instance.GetUserTouchPointLogs(0, 1, UserID).Data;
int UserTouchPointLogID = InstallUserDAL.Instance.AddTouchPointLogRecord(LoginUserID, UserID, LoginUserInstallID, now, ChangeLog, strGUID, touchPointSource);
// Send email to User / Recruiter
// Get Html Template
string messageUrl = string.Empty, toEmail = string.Empty, body = string.Empty;
string baseUrl = System.Web.HttpContext.Current.Request.Url.Scheme + "://" + System.Web.HttpContext.Current.Request.Url.Authority + System.Web.HttpContext.Current.Request.ApplicationPath.TrimEnd('/') + "/";
HTMLTemplatesMaster html = HTMLTemplateBLL.Instance.GetHTMLTemplateMasterById(HTMLTemplates.HR_EditSales_TouchpointLog_Email);
// sender details
var sender = getuserdetails(LoginUserID).Tables[0].Rows[0];
string pic = string.IsNullOrEmpty(sender["Picture"].ToString()) ? "default.jpg"
: sender["Picture"].ToString().Replace("~/UploadeProfile/", "");
pic = baseUrl + "Employee/ProfilePictures/" + pic;
html.Body = html.Body.Replace("{ImageUrl}", pic);
html.Body = html.Body.Replace("{Name}", sender["FristName"].ToString() + " " + sender["LastName"].ToString());
html.Body = html.Body.Replace("{Designation}", sender["Designation"].ToString());
html.Body = html.Body.Replace("{UserInstallID}", sender["UserInstallID"].ToString());
html.Body = html.Body.Replace("{ProfileUrl}", baseUrl + "Sr_App/ViewSalesUser.aspx?id=" + sender["Id"].ToString());
html.Body = html.Body.Replace("{MessageContent}", ChangeLog.Replace("Note :", "").Trim());
//
// Generate auto login code
string loginCode = InstallUserDAL.Instance.GenerateLoginCode(UserID).Object;
if (LastUserTouchPoint == null && LoginUserID == UserID) // first entry
{
// send email to recruiter
toEmail = "*****@*****.**";
messageUrl = baseUrl + "Sr_App/edituser.aspx?TUID=" + UserID + "&NID=" + UserTouchPointLogID + "&auth=" + loginCode;
}
else if (LastUserTouchPoint != null && LastUserTouchPoint.Count() > 0 && LoginUserID == UserID) // send email to receiver
{
// send email to user
var lastSender = getuserdetails(LastUserTouchPoint.First().UpdatedByUserID).Tables[0].Rows[0];
if (Convert.ToInt32(lastSender["Id"]) == UserID)
{
toEmail = lastSender["Email"].ToString();
messageUrl = baseUrl + "Sr_App/TouchPointLog.aspx?TUID=" + UserID + "&NID=" + UserTouchPointLogID + "&auth=" + loginCode;
}
else
{
toEmail = lastSender["Email"].ToString();
messageUrl = baseUrl + "Sr_App/edituser.aspx?TUID=" + UserID + "&NID=" + UserTouchPointLogID + "&auth=" + loginCode;
}
}
else
{
var receiver = getuserdetails(UserID).Tables[0].Rows[0];
// send email to user
toEmail = receiver["Email"].ToString();
messageUrl = baseUrl + "Sr_App/TouchPointLog.aspx?TUID=" + UserID + "&NID=" + UserTouchPointLogID + "&auth=" + loginCode;
}
body = (html.Header + html.Body + html.Footer).Replace("{MessageUrl}", messageUrl);
EmailManager.SendEmail("Touch Point Log", toEmail, html.Subject, body, null);
// find all emails
List <string> emails = new List <string>();
// emails.Add(toEmail);
string[] allWords = ChangeLog.Split(new char[] { '@' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var item in allWords)
{
switch (item.Trim().ToLower().Substring(0, item.IndexOf(' ')))
{
case "justin":
if (toEmail != "*****@*****.**")
{
emails.Add("*****@*****.**"); //321
}
// add touch point note entry
break;
case "yogesh":
if (toEmail != "*****@*****.**")
{
emails.Add("*****@*****.**"); //901
}
break;
default:
break;
}
}
if (emails.Count > 1)
{
foreach (var item in emails.Distinct())
{
switch (item)
{
case "*****@*****.**":
UserTouchPointLogID = InstallUserDAL.Instance.AddTouchPointLogRecord(LoginUserID, 321, LoginUserInstallID, now, ChangeLog, strGUID, touchPointSource);
messageUrl = baseUrl + "Sr_App/TouchPointLog.aspx?TUID=" + UserID + "&NID=" + UserTouchPointLogID + "&auth=" + loginCode;
body = (html.Header + html.Body + html.Footer).Replace("{MessageUrl}", messageUrl);
EmailManager.SendEmail("Touch Point Log", item, html.Subject, body, null);
break;
case "*****@*****.**":
UserTouchPointLogID = InstallUserDAL.Instance.AddTouchPointLogRecord(LoginUserID, 901, LoginUserInstallID, now, ChangeLog, strGUID, touchPointSource);
messageUrl = baseUrl + "Sr_App/TouchPointLog.aspx?TUID=" + UserID + "&NID=" + UserTouchPointLogID + "&auth=" + loginCode;
body = (html.Header + html.Body + html.Footer).Replace("{MessageUrl}", messageUrl);
EmailManager.SendEmail("Touch Point Log", item, html.Subject, body, null);
break;
default:
break;
}
}
}
return(UserTouchPointLogID);
}
