private void detach_TEST_RESULTs(TEST_RESULT entity)
{
this.SendPropertyChanging();
entity.TEST = null;
}
private void attach_TEST_RESULTs(TEST_RESULT entity)
{
this.SendPropertyChanging();
entity.TEST = this;
}
partial void DeleteTEST_RESULT(TEST_RESULT instance);
partial void UpdateTEST_RESULT(TEST_RESULT instance);
partial void InsertTEST_RESULT(TEST_RESULT instance);
public void SaveResult(Guid testid, int statuscode)
{
using (var dc = new WeHeMoDataContext())
{
var test = dc.TESTs.Where(c => c.Id == testid).First();
// var firstError = test.StatusCode != null && test.StatusCode == 200;
var sendMail = statuscode != 200 && test.StatusCode != statuscode; //Hata olma durumu test.statuscode!=statuscode
var successMail = statuscode == 200 && test.StatusCode != 200 && test.StatusCode != null; //Hata sonunda erişim durumu
var time1 = dc.TEST_RESULTs.Where(c => c.TestId == testid && c.StatusCode == 200).OrderByDescending(c => c.CreateDate).Select(c => c.CreateDate).FirstOrDefault();
test.StatusCode = statuscode;
test.TestDate = DateTime.Now;
var test_result = new TEST_RESULT();
test_result.Id = Guid.NewGuid();
test_result.TestId = testid;
test_result.StatusCode = statuscode;
test_result.CreateDate = DateTime.Now;
dc.TEST_RESULTs.InsertOnSubmit(test_result);
dc.SubmitChanges();
if (sendMail)
{
var email = dc.TESTs.Where(c => c.Id == testid).Select(c => new { c.Url, c.CUSTOMER.Email }).First();
var error = dc.STATUS_CODEs.Where(c => c.Code == statuscode).Select(c => c.Description).First();
var client = new SmtpClient();
client.Host = "xxxxxxxx";
client.Port = 587;
client.EnableSsl = false;
client.Credentials = new NetworkCredential("xxxxxxxxxxxxx", "xxxxxxxxxxx"); //sunucuda username:password
var message = new MailMessage();
message.Body = "Sayın Yetkili,<br>" + email.Url + " adresine sahip sayfada sorun tespit edilmiştir.<br>" + "Alınan Hata: <span style:color:red>" + error + "</span><br>WEHEME Team";
message.IsBodyHtml = true;
message.Subject = "WEHEMO Notification";
message.From = new MailAddress("xxxxxxxxxx");
message.To.Add("xxxxxxxxxxxxxx");
client.Send(message);
}
if (successMail)
{
var fark = DateTime.Now.Subtract(time1).TotalHours;
var email = dc.TESTs.Where(c => c.Id == testid).Select(c => new { c.Url, c.CUSTOMER.Email }).First();
var client = new SmtpClient();
client.Host = "xxxxxxxxxxxx.com";
client.Port = "xxxxxxx";
client.EnableSsl = false;
client.Credentials = new NetworkCredential("xxxxxxx", "xxxxxxxxxx");
var message = new MailMessage();
message.Body = "Sayın Yetkili,<br>" + fark + "saattir erişilemeyen " + email.Url + " adresinize erişim sağlanmıştır.<br>WEHEME Team";
message.IsBodyHtml = true;
message.Subject = "WEHEMO Notification";
message.From = new MailAddress("xxxxxxxxxxx"); //Kimden
message.To.Add("xxxxxxxxxxxxxx"); //Kime "email.email"
client.Send(message);
}
}
}
