public void SaveCurrentUrl(string fullUrl, int engageid) { TB_Url addUrl = new TB_Url(); addUrl.engagepersonal_ID = engageid; addUrl.url = fullUrl; db.TB_Url.Add(addUrl); db.SaveChanges(); }
public ActionResult SaveAllData(string[] values) { EngagementContext db = new EngagementContext(); try { if (ModelState.IsValid) { var pageCase = Convert.ToInt32(values[9]); if (Convert.ToInt32(values[9]) != 0) //2 คือ section ที่ 2 ตัวเลขนี้ได้มาจากดึงข้อมูลมาจาก DB ว่ามีแล้วหรือไม่ { 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); int questionId = Convert.ToInt32(values[7]); for (int i = 0; i < 6; i++, questionId++) { var UID = int.Parse((values[0])); var SecID = int.Parse((values[8])); 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 + 1]); item.dtStamp = oDate; } } db.SaveChanges(); } } else // ถ้าไม่มีข้อมูลให้ insert ใหม่เข้าไป { TB_Answer ans = new TB_Answer(); int latestRecord = 0; int questionId = Convert.ToInt32(values[7]); int SaveSection = Convert.ToInt32(values[8]); latestRecord = GetLastRecord(1); //chkeck การเคยเข้าทำแบบทดสอบหรือตอบหน้านี้ไปแล้ว // chkSection = chkInputData(engageid, 3); for (int i = 0; i < 6; i++, questionId++)//วนใส่ทีละ 6 ข้อ { if (latestRecord == 0) { latestRecord = 1; } else { latestRecord = latestRecord + 1; } 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); ans.Question_ID = questionId; //คำถามข้อที่ ans.engagepersonal_ID = Convert.ToInt32(values[0]); ans.AnswerEngage_ID = latestRecord; //ตัวเลขที่มันรันไปเรื่อยๆๆด้วยมือเรา ans.AnswerResult = Convert.ToInt32(values[i + 1]); ans.Section = SaveSection; ans.dtStamp = oDate; db.TB_Answer.Add(ans); db.SaveChanges(); } } return(Redirect(Request.UrlReferrer.ToString())); } return(Json(new { msg = String.Format("Data: {0}", "Save Complete") })); } catch (Exception ex) { throw ex; } }
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; } }
public ActionResult Add_Information(string[] values) { EngagementContext db = new EngagementContext(); try { if (ModelState.IsValid) { if (Convert.ToInt32(values[11]) == 1) { 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); for (int i = 0; i < 8; i++) { var UID = int.Parse((values[0])); var SecID = 1; var ds = (from c in db.TB_Answer where c.engagepersonal_ID == UID && c.Section == SecID && c.Question_ID == i + 1 select c).ToList(); if (ds.Count > 0) { foreach (var item in ds) { item.AnswerResult = Convert.ToInt32(values[i + 1]); item.dtStamp = oDate; } } db.SaveChanges(); } } else { TB_Answer ans = new TB_Answer(); int latestRecord = 0; latestRecord = GetLastRecord(1); 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); for (int i = 0; i < 8; i++) { if (latestRecord == 0) { latestRecord = 1; } else { latestRecord = latestRecord + 1; } var engagementData = db.TB_Answer.Where(x => x.Question_ID == i + 1).FirstOrDefault(); ans.Question_ID = i + 1; //i ans.engagepersonal_ID = Convert.ToInt32(values[0]); ans.AnswerEngage_ID = latestRecord; //ตัวเลขที่มันรันไปเรื่อยๆๆด้วยมือเรา ans.AnswerResult = Convert.ToInt32(values[i + 1]); ans.Section = 1; ans.dtStamp = oDate; db.TB_Answer.Add(ans); db.SaveChanges(); } } } return(Json(new { msg = String.Format("Data: {0}", "Save Complete") })); } catch (Exception ex) { throw ex; } }