public SearchModel(string sTitle) { string query = "select top 10 Editorial.EditorialID, Editorial.UpVote, Editorial.DownVote, Editorial.solution, Problem.Title from Editorial, Problem, [User] where Editorial.approve='Yes' and Editorial.ProblemID=Problem.ProblemID AND Editorial.UserID=[User].UserID and problem.title like '%" + sTitle + "%'"; DataTable searchTable = new DBHelper().getTable(query); // Adding all rows in list for (int i = 0; i < searchTable.Rows.Count; i++) { editorialModel = new EditorialModel(); editorialModel.EditorialID = Convert.ToInt32(searchTable.Rows[i][0].ToString()); editorialModel.Solution = searchTable.Rows[i][3].ToString(); editorialModel.ProblemTitle = searchTable.Rows[i][4].ToString(); searchList.Add(editorialModel); } }
public AdminModel(int userID) { string sql = "select Point from [User] where UserID=" + userID; DataTable dtbl = new DBHelper().getTable(sql); Point = Convert.ToInt32(dtbl.Rows[0][0].ToString()); dtbl.Clear(); sql = "select Editorial.EditorialID, Editorial.Solution, Problem.Title from Editorial, Problem where Editorial.ProblemID=Problem.ProblemID and Approve='No'"; dtbl = new DBHelper().getTable(sql); EditorialModel editorialModel; for (int i = 0; i < dtbl.Rows.Count; i++) { editorialModel = new EditorialModel(); editorialModel.EditorialID = Convert.ToInt32(dtbl.Rows[i][0].ToString()); editorialModel.ProblemTitle = dtbl.Rows[i][2].ToString(); editorialModel.Solution = dtbl.Rows[i][1].ToString(); approvalList.Add(editorialModel); } }
public ProfileModel(int userID) { string sql = "select Point from [User] where UserID=" + userID; DataTable dtbl = new DBHelper().getTable(sql); Point = Convert.ToInt32(dtbl.Rows[0][0].ToString()); dtbl.Clear(); sql = "select Editorial.EditorialID, Editorial.Solution, Problem.Title from Editorial, Problem where editorial.approve='Yes' and Editorial.UserID=" + userID + " and Editorial.ProblemID=Problem.ProblemID"; dtbl = new DBHelper().getTable(sql); EditorialModel editorialModel; for (int i = 0; i < dtbl.Rows.Count; i++) { editorialModel = new EditorialModel(); editorialModel.EditorialID = Convert.ToInt32(dtbl.Rows[i][0].ToString()); editorialModel.ProblemTitle = dtbl.Rows[i][2].ToString(); editorialModel.Solution = dtbl.Rows[i][1].ToString(); myEditorialList.Add(editorialModel); } sql = "select bookmark.bookmarkid, Bookmark.EditorialID, Editorial.Solution, Problem.Title from Editorial, Problem, Bookmark where Bookmark.UserID=" + userID + " and Editorial.EditorialID=Bookmark.EditorialID and Editorial.ProblemID=Problem.ProblemID"; dtbl.Clear(); dtbl = new DBHelper().getTable(sql); for (int i = 0; i < dtbl.Rows.Count; i++) { editorialModel = new EditorialModel(); editorialModel.EditorialID = Convert.ToInt32(dtbl.Rows[i][1].ToString()); editorialModel.ProblemTitle = dtbl.Rows[i][3].ToString(); editorialModel.Solution = dtbl.Rows[i][2].ToString(); editorialModel.BookMarkID = Convert.ToInt32(dtbl.Rows[i][0].ToString()); bookmarkList.Add(editorialModel); } sql = "select Editorial.EditorialID, Editorial.Solution, Problem.Title from Editorial, Problem where Editorial.EditorialID in (select distinct EditorialID from Comment where UserID=" + userID + ") and Editorial.ProblemID=Problem.ProblemID"; dtbl.Clear(); dtbl = new DBHelper().getTable(sql); for (int i = 0; i < dtbl.Rows.Count; i++) { editorialModel = new EditorialModel(); editorialModel.EditorialID = Convert.ToInt32(dtbl.Rows[i][0].ToString()); editorialModel.ProblemTitle = dtbl.Rows[i][2].ToString(); editorialModel.Solution = dtbl.Rows[i][1].ToString(); InvolvmentEditorialList.Add(editorialModel); } sql = "select Editorial.EditorialID, Editorial.Solution, Problem.Title from Editorial, Problem where editorial.approve='No' and Editorial.UserID=" + userID + " and Editorial.ProblemID=Problem.ProblemID"; dtbl.Clear(); dtbl = new DBHelper().getTable(sql); for (int i = 0; i < dtbl.Rows.Count; i++) { editorialModel = new EditorialModel(); editorialModel.EditorialID = Convert.ToInt32(dtbl.Rows[i][0].ToString()); editorialModel.ProblemTitle = dtbl.Rows[i][2].ToString(); editorialModel.Solution = dtbl.Rows[i][1].ToString(); pendingEditorialList.Add(editorialModel); } }