//get all tasks according task id public Tasks GetTasksByTaskID(Int32?taskID) { Tasks alltasks = new Tasks(); DBObject taskDB = new DBObject(); List <IDataParameter> pars = new List <IDataParameter>(); IDataParameter par = taskDB.CreateParameter; Task task = null; par.ParameterName = "@taskid"; par.Value = taskID; pars.Add(par); using (IDataReader dr = taskDB.ExecuteQuery("select * from task where taskid=@taskID order by taskid desc", pars, CommandType.Text, true)) { while (dr.Read()) { task = new Task(); task.TaskID = dr.GetInt32(dr.GetOrdinal("taskid")); task.TaskName = dr.GetString(dr.GetOrdinal("taskname")); task.Description = dr.GetString(dr.GetOrdinal("description")); task.StartDate = dr.GetDateTime(dr.GetOrdinal("startdate")); task.DueDate = this.GetNullableDatetime(dr, "duedate"); task.CompleteDate = this.GetNullableDatetime(dr, "completedate"); task.AssignTo = dr.GetString(dr.GetOrdinal("assignto")); task.Status = dr.GetString(dr.GetOrdinal("status")); task.CreateBy = dr.GetString(dr.GetOrdinal("createby")); task.CreateDatetime = dr.GetDateTime(dr.GetOrdinal("createdatetime")); task.UpdateBy = this.GetNullableString(dr, "updateby"); task.UpdateDatetime = this.GetNullableDatetime(dr, "updatedatetime"); alltasks.Add(task); } } return(alltasks); }
//get all tasks by parameter query public Tasks GetTasksByStatus(List <String> lstStatus, Boolean currentOrNot) { Tasks alltasks = new Tasks(); DBObject taskDB = new DBObject(); String condition = ""; for (int i = 0; i < lstStatus.Count; i++) { if (i != lstStatus.Count - 1) { condition = condition + " status='" + lstStatus[i] + "' or "; } else { condition = condition + " status='" + lstStatus[i] + "'"; } } if (currentOrNot) { condition = condition + " and startdate<GETDATE() and duedate>GETDATE()"; } String sqlStaus; if (condition == "") { sqlStaus = "select * from task"; } else { sqlStaus = "select * from task where " + condition; } Task task = null; using (IDataReader dr = taskDB.ExecuteQuery(sqlStaus, null, CommandType.Text, true)) { while (dr.Read()) { task = new Task(); task.TaskID = dr.GetInt32(dr.GetOrdinal("taskid")); task.TaskName = dr.GetString(dr.GetOrdinal("taskname")); task.Description = dr.GetString(dr.GetOrdinal("description")); task.StartDate = dr.GetDateTime(dr.GetOrdinal("startdate")); task.DueDate = this.GetNullableDatetime(dr, "duedate"); task.CompleteDate = this.GetNullableDatetime(dr, "completedate"); task.AssignTo = dr.GetString(dr.GetOrdinal("assignto")); task.Status = dr.GetString(dr.GetOrdinal("status")); task.CreateBy = dr.GetString(dr.GetOrdinal("createby")); task.CreateDatetime = dr.GetDateTime(dr.GetOrdinal("createdatetime")); task.UpdateBy = this.GetNullableString(dr, "updateby"); task.UpdateDatetime = this.GetNullableDatetime(dr, "updatedatetime"); alltasks.Add(task); } } return(alltasks); }