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