//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);
}
