public DataTable GetDataTable(DO_WallMessage ObjScrl_UserHonorsTbl, WallMessage Flag) { DataTable dt = new DataTable(); SqlConnection conn = new SqlConnection(); SQLManager co = new SQLManager(); conn = co.GetConnection(); SqlDataAdapter da = new SqlDataAdapter("Scrl_AddEditDelWallMessage", conn); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@FlagNo", SqlDbType.Int).Value = Flag; da.SelectCommand.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intInvitedUserId; da.SelectCommand.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intRegistrationId; da.SelectCommand.Parameters.Add("@intMessageId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intMessageId; da.SelectCommand.Parameters.Add("@StrRecommendation", SqlDbType.VarChar, 1000).Value = ObjScrl_UserHonorsTbl.StrRecommendation; da.SelectCommand.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intAddedBy; da.SelectCommand.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 50).Value = ObjScrl_UserHonorsTbl.strIpAddress; da.SelectCommand.Parameters.Add("@intSkillId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intSkillId; da.SelectCommand.Parameters.Add("@intGroupId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intGroupId; da.Fill(dt); co.CloseConnection(conn); return(dt); }
/// <summary> /// Message SEND /// </summary> /// <param name="ObjScrl_UserHonorsTbl"></param> /// <param name="Flag"></param> public void Scrl_AddEditDelWallMessage(DO_WallMessage ObjScrl_UserHonorsTbl, WallMessage Flag) { SqlConnection conn = new SqlConnection(); SQLManager co = new SQLManager(); conn = co.GetConnection(); cmd = new SqlCommand("Scrl_AddEditDelWallMessage", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@FlagNo", SqlDbType.Int).Value = Flag; cmd.Parameters.Add("@intInvitedUserId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intInvitedUserId; cmd.Parameters.Add("@intRegistrationId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intRegistrationId; cmd.Parameters.Add("@intMessageId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intMessageId; cmd.Parameters.Add("@StrRecommendation", SqlDbType.VarChar, 20000).Value = ObjScrl_UserHonorsTbl.StrRecommendation; cmd.Parameters.Add("@intGroupId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intGroupId; cmd.Parameters.Add("@strSubject", SqlDbType.VarChar, 500).Value = ObjScrl_UserHonorsTbl.strSubject; cmd.Parameters.Add("@intAddedBy", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intAddedBy; cmd.Parameters.Add("@strIpAddress", SqlDbType.VarChar, 50).Value = ObjScrl_UserHonorsTbl.strIpAddress; cmd.Parameters.Add("@intSkillId", SqlDbType.Int).Value = ObjScrl_UserHonorsTbl.intSkillId; cmd.Parameters.Add("@strTotalGrpMemberID", SqlDbType.VarChar, 5000).Value = ObjScrl_UserHonorsTbl.strTotalGrpMemberID; cmd.Parameters.Add("@striInvitedUserId", SqlDbType.VarChar, 100).Value = ObjScrl_UserHonorsTbl.striInvitedUserId; ObjScrl_UserHonorsTbl.intOutWallMessageId = Convert.ToInt32(cmd.ExecuteScalar()); co.CloseConnection(conn); }
private void SendMail(DO_WallMessage WallMessageDO, string RecieverID) { try { string body = null; DataTable dtUserDetails1 = new DataTable(); DataTable dtUserDetails2 = new DataTable(); objLogin.intRegistartionID = Convert.ToInt32(RecieverID); dtUserDetails1.Clear(); dtUserDetails1 = objLoginDB.GetDataTable(objLogin, DA_SKORKEL.DA_Login.Login_1.UserDetails); objLogin.intRegistartionID = Convert.ToInt32(ViewState["UserID"]); dtUserDetails2.Clear(); dtUserDetails2 = objLoginDB.GetDataTable(objLogin, DA_SKORKEL.DA_Login.Login_1.UserDetails); SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); string mailfrom = ConfigurationManager.AppSettings["mailfrom"]; string mailServer = ConfigurationManager.AppSettings["mailServer"]; string username = ConfigurationManager.AppSettings["UserName"]; string Password = ConfigurationManager.AppSettings["Password"]; string Port = ConfigurationManager.AppSettings["Port"]; string MailURL = ConfigurationManager.AppSettings["MailURL"]; string MailSSL = ConfigurationManager.AppSettings["MailSSL"]; string MailTo = Convert.ToString(dtUserDetails1.Rows[0]["vchrUserName"]); string MailURLFinal = MailURL + "/Inbox.aspx"; string Mailbody = ""; SmtpClient clientip = new SmtpClient(mailServer); clientip.Port = Convert.ToInt32(Port); clientip.UseDefaultCredentials = false; if (MailSSL != "0") { clientip.EnableSsl = true; } clientip.Credentials = new System.Net.NetworkCredential(username, Password); string DisplayName = ConfigurationManager.AppSettings["DisplayName"]; try { MailMessage Rmm2 = new MailMessage(); Rmm2.IsBodyHtml = true; Rmm2.From = new System.Net.Mail.MailAddress(mailfrom, DisplayName); Rmm2.Body = Mailbody.ToString(); using (StreamReader reader = new StreamReader(Server.MapPath("~/EmailTemplate.htm"))) { body = reader.ReadToEnd(); } body = body.Replace("{UserName}", Convert.ToString(dtUserDetails1.Rows[0]["LoginName"])); body = body.Replace("{Content}", "<b>" + Convert.ToString(dtUserDetails2.Rows[0]["LoginName"]) + "</b> has sent you a private " + "<a style='color:#01b7bd;text-decoration:none' href='" + MailURLFinal + "'>message</a>"); body = body.Replace("{RedirectURL}", MailURL); System.Net.Mail.AlternateView htmlView = System.Net.Mail.AlternateView.CreateAlternateViewFromString(body, null, MediaTypeNames.Text.Html); Rmm2.To.Clear(); Rmm2.To.Add(MailTo); Rmm2.Subject = "Private Message from " + Convert.ToString(dtUserDetails2.Rows[0]["LoginName"]); Rmm2.AlternateViews.Add(htmlView); Rmm2.IsBodyHtml = true; clientip.Send(Rmm2); FCMNotification.Send("Private Message from " + Convert.ToString(dtUserDetails2.Rows[0]["LoginName"]), Convert.ToString(dtUserDetails2.Rows[0]["LoginName"]) + " has sent you a private message.", Convert.ToString(dtUserDetails1.Rows[0]["intRegistrationID"]), MailURLFinal); Rmm2.To.Clear(); } catch (FormatException ex) { ex.Message.ToString(); return; } catch (SmtpException ex) { ex.Message.ToString(); return; } finally { conn.Close(); } } catch (Exception ex) { ex.Message.ToString(); } }