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