public void updateUrl(string fullUrl, int engageid) { var engagementUrl = db.TB_Url.Where(x => x.engagepersonal_ID == engageid).FirstOrDefault(); if (engagementUrl != null) { engagementUrl.url = fullUrl; db.Entry(engagementUrl).State = EntityState.Modified; db.SaveChanges(); } }
public ActionResult SaveAllDataText(string[] values) { EngagementContext db = new EngagementContext(); try { TB_Answer ans = new TB_Answer(); TB_Answer_Text ansText = new TB_Answer_Text(); int latestRecord = 0; int latestRecordText = 0; int questionId = Convert.ToInt32(values[5]); int SaveSection = Convert.ToInt32(values[6]); latestRecord = GetLastRecord(1); latestRecordText = GetLastRecord(2); var userDt = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss"); // return 08/05/2016 12:56 PM DateTime oDate = DateTime.ParseExact(userDt, "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); if (Convert.ToInt32(values[7]) != 0) { var UID = int.Parse((values[0])); var SecID = int.Parse((values[6])); for (int i = 0; i < 3; i++, questionId++) { var ds = (from c in db.TB_Answer where c.engagepersonal_ID == UID && c.Section == SecID && c.Question_ID == questionId select c).ToList(); if (ds.Count > 0) { foreach (var item in ds) { item.AnswerResult = Convert.ToInt32(values[i + 2]); item.dtStamp = oDate; } } db.SaveChanges(); } //ไปอัพเดทข้อมูลในตาราง text comment var qtest = int.Parse((values[5])); var dtext = (from c in db.TB_Answer_Text where c.engagepersonal_ID == UID && c.Section == SecID && c.Question_ID == qtest select c).ToList(); if (dtext.Count > 0) { foreach (var item in dtext) { item.AnswerResult = (values[1]); item.Section = SaveSection; item.dtStamp = oDate; } } db.SaveChanges(); if (questionId == 51) { Int32 engagementid = Convert.ToInt32(values[0]); var engagementData = db.TB_Email.Where(x => x.engagepersonal_ID == engagementid).FirstOrDefault(); if (engagementData != null) { engagementData.StatusAccept = 1; engagementData.Survey_Commit = oDate; db.Entry(engagementData).State = EntityState.Modified; db.SaveChanges(); } } } else { for (int i = 0; i < 3; i++, questionId++)//วนใส่ทีละ 3 ข้อ { if (latestRecord == 0) { latestRecord = 1; } else { latestRecord = latestRecord + 1; } ans.Question_ID = questionId; //คำถามข้อที่ ans.engagepersonal_ID = Convert.ToInt32(values[0]); ans.AnswerEngage_ID = latestRecord; //ตัวเลขที่มันรันไปเรื่อยๆๆด้วยมือเรา ans.AnswerResult = Convert.ToInt32(values[i + 2]); ans.Section = SaveSection; ans.dtStamp = oDate; db.TB_Answer.Add(ans); db.SaveChanges(); } var qtest = int.Parse((values[5])); DateTime oDateT = DateTime.ParseExact(userDt, "MM/dd/yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); ansText.Question_ID = qtest; //คำถามข้อที่ ansText.engagepersonal_ID = Convert.ToInt32(values[0]); ansText.AnswerEngage_ID = latestRecordText; //ตัวเลขที่มันรันไปเรื่อยๆๆด้วยมือเรา ansText.AnswerResult = values[1]; ansText.Section = SaveSection; ansText.dtStamp = oDateT; db.TB_Answer_Text.Add(ansText); db.SaveChanges(); if (questionId == 51) { Int32 engagementid = Convert.ToInt32(values[0]); var engagementData = db.TB_Email.Where(x => x.engagepersonal_ID == engagementid).FirstOrDefault(); if (engagementData != null) { engagementData.StatusAccept = 1; engagementData.Survey_Commit = oDateT; db.Entry(engagementData).State = EntityState.Modified; db.SaveChanges(); } } } return(Redirect(Request.UrlReferrer.ToString())); } catch (Exception ex) { throw ex; } }