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