public ActionResult DeleteConfirmed(int id) { Q21 q21 = db.Q21s.Find(id); db.Q21s.Remove(q21); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,Name")] Q21 q21) { if (ModelState.IsValid) { db.Entry(q21).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(q21)); }
public ActionResult Create([Bind(Include = "ID,Name")] Q21 q21) { if (ModelState.IsValid) { db.Q21s.Add(q21); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(q21)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Q21 q21 = db.Q21s.Find(id); if (q21 == null) { return(HttpNotFound()); } return(View(q21)); }
public void Test() { ListNode l1 = new ListNode(1); l1.next = new ListNode(2); l1.next.next = new ListNode(4); ListNode l2 = new ListNode(1); l2.next = new ListNode(3); l2.next.next = new ListNode(4); ListNode result = new Q21().MergeTwoLists(l1, l2); Assert.AreEqual(1, result.val); Assert.AreEqual(1, result.next.val); Assert.AreEqual(2, result.next.next.val); Assert.AreEqual(3, result.next.next.next.val); Assert.AreEqual(4, result.next.next.next.next.val); Assert.AreEqual(4, result.next.next.next.next.next.val); }
protected bool SaveData() { StringBuilder columnList = new StringBuilder(); SQLParamList sqlParams = new SQLParamList(); if (QueryPropertyShortCode == GCCPropertyShortCode.GCC || (QueryPropertyShortCode == GCCPropertyShortCode.GAG && QueryGAGLocation == GLocation.None)) { //User had to select location string propSel = fbkProperty.SelectedValue; if (propSel.Length > 3) { //GAG if (propSel.Substring(0, 2).Equals("13")) { columnList.AppendFormat(",[{0}]", fbkProperty.DBColumn); sqlParams.Add("@" + fbkProperty.DBColumn, 13); } } else { fbkProperty.PrepareQuestionForDB(columnList, sqlParams); } } ddlDepartment.PrepareQuestionForDB(columnList, sqlParams); Q1.PrepareQuestionForDB(columnList, sqlParams); Q2.PrepareQuestionForDB(columnList, sqlParams); Q3.PrepareQuestionForDB(columnList, sqlParams); Q4.PrepareQuestionForDB(columnList, sqlParams); Q5.PrepareQuestionForDB(columnList, sqlParams); Q6.PrepareQuestionForDB(columnList, sqlParams); Q7.PrepareQuestionForDB(columnList, sqlParams); Q8.PrepareQuestionForDB(columnList, sqlParams); Q9.PrepareQuestionForDB(columnList, sqlParams); Q10.PrepareQuestionForDB(columnList, sqlParams); Q11.PrepareQuestionForDB(columnList, sqlParams); Q12.PrepareQuestionForDB(columnList, sqlParams); Q13.PrepareQuestionForDB(columnList, sqlParams); Q14.PrepareQuestionForDB(columnList, sqlParams); Q15.PrepareQuestionForDB(columnList, sqlParams); Q16.PrepareQuestionForDB(columnList, sqlParams); Q17.PrepareQuestionForDB(columnList, sqlParams); Q18.PrepareQuestionForDB(columnList, sqlParams); Q19.PrepareQuestionForDB(columnList, sqlParams); Q20.PrepareQuestionForDB(columnList, sqlParams); Q21.PrepareQuestionForDB(columnList, sqlParams); Q22.PrepareQuestionForDB(columnList, sqlParams); Q23.PrepareQuestionForDB(columnList, sqlParams); Q24.PrepareQuestionForDB(columnList, sqlParams); Q25.PrepareQuestionForDB(columnList, sqlParams); Q26.PrepareQuestionForDB(columnList, sqlParams); Q27.PrepareQuestionForDB(columnList, sqlParams); Q28.PrepareQuestionForDB(columnList, sqlParams); Q29A.PrepareQuestionForDB(columnList, sqlParams); Q29B.PrepareQuestionForDB(columnList, sqlParams); Q29C.PrepareQuestionForDB(columnList, sqlParams); Q30.PrepareQuestionForDB(columnList, sqlParams); radQ31_Hourly.PrepareQuestionForDB(columnList, sqlParams); radQ31_Salary.PrepareQuestionForDB(columnList, sqlParams); radQ32_1.PrepareQuestionForDB(columnList, sqlParams); radQ32_2.PrepareQuestionForDB(columnList, sqlParams); radQ32_3.PrepareQuestionForDB(columnList, sqlParams); radQ32_4.PrepareQuestionForDB(columnList, sqlParams); radQ32_5.PrepareQuestionForDB(columnList, sqlParams); Q33.PrepareQuestionForDB(columnList, sqlParams); chkQ34_1.PrepareQuestionForDB(columnList, sqlParams); chkQ34_2.PrepareQuestionForDB(columnList, sqlParams); chkQ34_3.PrepareQuestionForDB(columnList, sqlParams); chkQ34_4.PrepareQuestionForDB(columnList, sqlParams); chkQ34_5.PrepareQuestionForDB(columnList, sqlParams); chkQ34_6.PrepareQuestionForDB(columnList, sqlParams); chkQ34_7.PrepareQuestionForDB(columnList, sqlParams); chkQ34_8.PrepareQuestionForDB(columnList, sqlParams); chkQ34_9.PrepareQuestionForDB(columnList, sqlParams); chkQ34_10.PrepareQuestionForDB(columnList, sqlParams); chkQ34_11.PrepareQuestionForDB(columnList, sqlParams); chkQ34_12.PrepareQuestionForDB(columnList, sqlParams); if (radFFContinue.Checked) { CSR_Q1.PrepareQuestionForDB(columnList, sqlParams); CSR_Q2.PrepareQuestionForDB(columnList, sqlParams); CSR_Q3.PrepareQuestionForDB(columnList, sqlParams); CSR_Q4.PrepareQuestionForDB(columnList, sqlParams); CSR_Q5_1.PrepareQuestionForDB(columnList, sqlParams); CSR_Q5_2.PrepareQuestionForDB(columnList, sqlParams); CSR_Q5_3.PrepareQuestionForDB(columnList, sqlParams); CSR_Q5_4.PrepareQuestionForDB(columnList, sqlParams); CSR_Q6.PrepareQuestionForDB(columnList, sqlParams); CSR_Q7.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_1.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_2.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_3.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_4.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_5.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_6.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_7.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_8.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_9.PrepareQuestionForDB(columnList, sqlParams); CSR_Q8_OtherExplanation.PrepareQuestionForDB(columnList, sqlParams); CSR_Q9A.PrepareQuestionForDB(columnList, sqlParams); CSR_Q9B.PrepareQuestionForDB(columnList, sqlParams); CSR_Q9C.PrepareQuestionForDB(columnList, sqlParams); CSR_Q9D.PrepareQuestionForDB(columnList, sqlParams); CSR_Q9E.PrepareQuestionForDB(columnList, sqlParams); CSR_Q9F.PrepareQuestionForDB(columnList, sqlParams); CSR_Q9G.PrepareQuestionForDB(columnList, sqlParams); CSR_Q9H.PrepareQuestionForDB(columnList, sqlParams); CSR_Q10A.PrepareQuestionForDB(columnList, sqlParams); CSR_Q10B.PrepareQuestionForDB(columnList, sqlParams); CSR_Q10C.PrepareQuestionForDB(columnList, sqlParams); CSR_Q10D.PrepareQuestionForDB(columnList, sqlParams); CSR_Q10E.PrepareQuestionForDB(columnList, sqlParams); radCSR_Q11_1.PrepareQuestionForDB(columnList, sqlParams); radCSR_Q11_2.PrepareQuestionForDB(columnList, sqlParams); radCSR_Q11_3.PrepareQuestionForDB(columnList, sqlParams); radCSR_Q11_4.PrepareQuestionForDB(columnList, sqlParams); CSR_Q12.PrepareQuestionForDB(columnList, sqlParams); CSR_Q13.PrepareQuestionForDB(columnList, sqlParams); } columnList.Append(",[PropertyID],[DateEntered],[SurveyType]"); sqlParams.Add("@PropertyID", Master.PropertyID) .Add("@DateEntered", DateTime.Now) .Add("@SurveyType", IsKioskSurvey ? "K" : "D"); if (GAGLocation != GLocation.None) { columnList.Append(",[GAGLocation]"); sqlParams.Add("@GAGLocation", GAGLocation.ToString()); } columnList.Remove(0, 1); SQLDatabase sql = new SQLDatabase(); sql.CommandTimeout = 120; int rowID = sql.QueryAndReturnIdentity(String.Format("INSERT INTO [tblSurveySnapshot2017] ({0}) VALUES ({1});", columnList, columnList.ToString().Replace("[", "@").Replace("]", String.Empty)), sqlParams); if (!sql.HasError && rowID != -1) { Dictionary <string, int> wordCounts = SurveyTools.GetWordCount(Q33.Text, CSR_Q8_OtherExplanation.Text, CSR_Q13.Text); SurveyTools.SaveWordCounts(SharedClasses.SurveyType.Employee, rowID, wordCounts); return(true); } else { return(false); } }