public List <Dictionary <string, string> > GetAndDeleteRecords(string tableName, string[] targetColumns, List <string> filters) { string sqlquery = "DELETE dbo." + tableName + " OUTPUT DELETED.* "; string conditions = ""; if (filters != null && filters.Count > 0) { conditions = " Where "; for (int i = 0; i < filters.Count; i++) { if (i > 0) { conditions += " AND "; } conditions += filters[i]; } } sqlquery += conditions; SQLServerAccessor dbAccessor = new SQLServerAccessor(); List <Dictionary <string, string> > output = dbAccessor.TableSearch(targetColumns, sqlquery); return(output); }
private List <ExamItem> GenerateProcessItems(string sqlquery) { SQLServerAccessor dbAccessor = new SQLServerAccessor(); List <Dictionary <string, string> > output = dbAccessor.TableSearch(targetColumns, sqlquery); List <ExamItem> list = new List <ExamItem>(); int index = 0; foreach (Dictionary <string, string> rec in output) { ExamItem item = new ExamItem(); item.index = index++; item.question = rec["Question"]; item.answerRegex = rec["AnswerRegex"]; item.answer = rec["Answer"]; item.answerType = rec["AnswerType"]; item.interpret = rec["Interpret"]; item.askbackMessage = rec["AskbackMessage"]; if (!string.IsNullOrWhiteSpace(rec["Score"])) { item.score = int.Parse(rec["Score"]); } list.Add(item); } return(list); }
public List <TestItem> GenerateTestItems(int count, string courseInTest) { string tableName = "calculator3"; string sqlquery = "select top " + count.ToString() + " * from dbo." + tableName + " Where CourseName = N'" + courseInTest + "' order by newid()"; string[] targetColumns = { "Formula", "Result", "ResultMatchRule" }; SQLServerAccessor dbAccessor = new SQLServerAccessor(); List <Dictionary <string, string> > output = dbAccessor.TableSearch(targetColumns, sqlquery); List <TestItem> list = new List <TestItem>(); int index = 0; foreach (Dictionary <string, string> rec in output) { TestItem item = new TestItem(); item.index = index++; item.question = rec["Formula"]; item.correctResult = rec["Result"]; item.answerMatchRule = rec["ResultMatchRule"]; list.Add(item); } return(list); }
private Dictionary <int, IRItem> GenerateProcessItems(string sqlquery) { SQLServerAccessor dbAccessor = new SQLServerAccessor(); List <Dictionary <string, string> > output = dbAccessor.TableSearch(targetColumns, sqlquery); Dictionary <int, IRItem> dict = new Dictionary <int, IRItem>(); int index = 0; foreach (Dictionary <string, string> rec in output) { IRItem item = new IRItem(); item.index = index++; item.stepNo = int.Parse(rec["StepNo"]); item.content = rec["Content"]; item.options = rec["Options"]; item.optionRegex = rec["OptionRegex"]; item.nextStep = rec["NextStep"]; item.askbackMessage = rec["AskbackMessage"]; dict.Add(item.stepNo, item); } return(dict); }
public List <TestItem> GenerateTestItems(int count) { string tableName = "scorescripts"; string sqlquery = "select top " + count.ToString() + " * from dbo." + tableName + " order by newid()"; string[] targetColumns = { "script" }; SQLServerAccessor dbAccessor = new SQLServerAccessor(); List <Dictionary <string, string> > output = dbAccessor.TableSearch(targetColumns, sqlquery); List <TestItem> list = new List <TestItem>(); foreach (Dictionary <string, string> rec in output) { TestItem item = new TestItem(); item.question = rec["script"]; list.Add(item); } return(list); }