protected void Page_Load(object sender, EventArgs e)
{
string host = "smtp.office365.com";
string emailfrom = "*****@*****.**"; // "*****@*****.**";
//emailfrom = "*****@*****.**";
string password = "******"; // "Whanganui1998";
//password = "******";
int port = 587;
Boolean enableSsl = true;
string emailfromname = "Test Email";
string emailBCC = "";
string emailRecipient = "*****@*****.**";
string emailsubject = "Test Email";
string emailhtml = "<html><head></head><body>Greg was here</body></html>";
string[] attachments = new string[0];
Dictionary <string, string> emailoptions = new Dictionary <string, string>();
Generic.Functions gFunctions = new Generic.Functions();
gFunctions.sendemailV5(host, port, enableSsl, emailfrom, emailfromname, password, emailsubject, emailhtml, emailRecipient, emailBCC, "", attachments, emailoptions);
}
protected void Page_Load(object sender, EventArgs e)
{
string strConnString = "Data Source=toh-app;Initial Catalog=DataInnovations;Integrated Security=False;user id=OnlineServices;password=Whanganui497";
Generic.Functions gFunctions = new Generic.Functions();
int c1 = 0;
html += "<tr><td colspan=\"11\"><input id=\"cb_toggleall\" type=\"checkbox\" /></td></tr>";
html += "<tr><td>Draw</td><td>Ticket</td><td>Purchaser</td><td>Greeting</td><td>Mobile</td><td>Email Address</td><td>Voucher</td><td>Iti.Ninja</td><td>Winner Status</td><td>Winner Response</td><td>Winner Note</td></tr>";
string sql = @"select W.rafflewinner_id, R.identifier, T.RaffleTicket_ID, T.purchaser, t.greeting, t.mobile, t.TicketNumber, t.EmailAddress, t.Greeting, W.guid, W.status, W.Draw, W.Notes, W.Response, W.itininjaid, W.drawndate
from RaffleWinner W
inner join raffleticket T on T.RaffleTicket_ID = W.RaffleTicket_ID
inner join Raffle R on R.Raffle_ID = T.Raffle_ID
where isnull(w.status,'') <> ''
and [code] = 'UBC2019B'
order by isnull(W.status,'') desc, R.identifier, w.Draw";
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand(sql, con)
{
CommandType = CommandType.Text,
Connection = con
};
cmd.CommandType = System.Data.CommandType.Text;
cmd.Connection = con;
//try
//{
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
string link = "voucher.aspx?id=";
while (dr.Read())
{
string rafflewinner_id = dr["rafflewinner_id"].ToString();
string identifier = dr["identifier"].ToString();
string id = dr["RaffleTicket_ID"].ToString();
string purchaser = dr["Purchaser"].ToString();
string mobile = dr["mobile"].ToString();
string ticketnumber = dr["ticketnumber"].ToString();
string emailaddress = dr["emailaddress"].ToString();
string itininjaid = dr["itininjaid"].ToString();
string greeting = dr["greeting"].ToString();
string guid = dr["guid"].ToString();
string winnerstatus = dr["status"].ToString();
string winnerresponse = dr["response"].ToString();
string winnernote = dr["notes"].ToString();
string draw = dr["draw"].ToString();
string drawndate = "";
if (dr["drawndate"] != DBNull.Value)
{
drawndate = Convert.ToDateTime(dr["drawndate"]).ToString("dd MMM yy");
}
string itininjahtml = "";
string url = "http://iti.ninja/data.aspx?mode=Track_link&link=" + itininjaid + "&format=simple";
HttpWebRequest httprequest = WebRequest.Create(url) as HttpWebRequest;
HttpWebResponse httpresponse = (HttpWebResponse)httprequest.GetResponse();
WebHeaderCollection header = httpresponse.Headers;
var httpencoding = System.Text.ASCIIEncoding.ASCII;
using (var reader = new System.IO.StreamReader(httpresponse.GetResponseStream(), httpencoding))
{
itininjahtml = reader.ReadToEnd();
}
html += "<tr><td><input class=\"checkbox\" id=\"cb_" + id + "\" name=\"cb_" + id + "\" value=\"x\" type=\"checkbox\" /><a href=\"" + link + guid + "\" target=\"order\">" + identifier + " " + draw + "</a><br />" + drawndate + "</td><td>" + ticketnumber + "</td><td>" + purchaser + "</td><td>" + greeting + "</td><td>" + mobile + "</td><td>" + emailaddress + "</td><td><a target=\"voucher\" href=\"../images/vouchers/" + guid + ".jpg\">View</a></td><td class=\"itininja\">" + itininjahtml + "</td><td>" + winnerstatus + "</td><td>" + winnerresponse + "</td><td>" + winnernote + "</td></tr>";
if (IsPostBack)
{
string val = Request.Form["cb_" + id];
if (val == "x")
{
string textmessage = tb_message.Text;
if (textmessage.Contains("||voucher||"))
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://iti.ninja/posts.asmx/Create_Link");
request.Method = "POST";
string jsonContent = @"{
""link"": """",
""datetimefrom"": """",
""datetimeto"": """",
""url"": ""http://office.datainn.co.nz/raffles/images/vouchers/" + guid + @".jpg"",
""description"": ""Raffle - Winner: " + purchaser + @""",
""recordlog"": ""Yes""}";
System.Text.UTF8Encoding encoding = new System.Text.UTF8Encoding();
Byte[] byteArray = encoding.GetBytes(jsonContent);
request.ContentLength = byteArray.Length;
request.ContentType = @"application/json";
using (Stream dataStream = request.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream receiveStream = response.GetResponseStream();
StreamReader readStream = new StreamReader(receiveStream, Encoding.UTF8);
string ans = readStream.ReadToEnd();
dynamic result = JsonConvert.DeserializeObject(ans);
string itininja = result.d.value;
response.Close();
readStream.Close();
textmessage = textmessage.Replace("||voucher||", "http://iti.ninja/" + itininja);
sql = "update rafflewinner set itininjaID = '" + itininja + "' where raffleWinner_id = " + rafflewinner_id;
SqlConnection con2 = new SqlConnection(strConnString);
SqlCommand cmd2 = new SqlCommand(sql, con2);
cmd2.CommandType = CommandType.Text;
cmd2.Connection = con2;
con2.Open();
//SqlDataReader dr = cmd.ExecuteReader();
cmd2.ExecuteNonQuery();
cmd2.Dispose();
con2.Close();
con2.Dispose();
}
textmessage = textmessage.Replace("||greeting||", greeting);
textmessage = textmessage.Replace("||ticketnumber||", ticketnumber);
textmessage = textmessage.Replace("||guid||", guid);
textmessage = textmessage.Replace("||identifier||", identifier);
foreach (string mobilex in mobile.Split(';'))
{
Response.Write(gFunctions.SendRemoteMessage(mobilex, textmessage, "Raffle Communication") + "<br />");
c1++;
}
}
}
}
}
dr.Close();
con.Close();
con.Dispose();
if (IsPostBack)
{
Response.Write(c1.ToString() + " messages sent");
}
}