public IList <TaskMaster> GetAllFilterTask(string task, string parentTask, string priorityFrom, string priorityTo, string dateFrom, string dateTo)
{
IList <TaskMaster> lstItem = new List <TaskMaster>();
using (SqlConnection con = new SqlConnection(TaskManagerDb.ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("SP_FILTER_ALL_TASK_MASTER", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TASK", task);
cmd.Parameters.AddWithValue("@PARENTTASK", parentTask);
cmd.Parameters.AddWithValue("@PRIORITYFROM", priorityFrom);
cmd.Parameters.AddWithValue("@PRIORITYTO", priorityTo);
cmd.Parameters.AddWithValue("@DATEFROM", Convert.ToDateTime(dateFrom));
cmd.Parameters.AddWithValue("@DATELTO", Convert.ToDateTime(dateTo));
con.Open();
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TaskMaster taskMaster = new TaskMaster();
taskMaster.Task_Id = reader.GetInt32(0);
taskMaster.Task_Name = Convert.ToString(reader.GetValue(1));
taskMaster.ParentTask_Name = Convert.ToString(reader.GetValue(2));
taskMaster.Priority = reader.GetInt32(3);
taskMaster.Start_Date = Convert.ToString(reader.GetValue(4));
taskMaster.End_Date = Convert.ToString(reader.GetValue(5));
lstItem.Add(taskMaster);
}
}
}
return(lstItem);
}
public IList <TaskMaster> GetAllTask()
{
IList <TaskMaster> lstItem = new List <TaskMaster>();
using (SqlConnection con = new SqlConnection(TaskManagerDb.ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("SP_GET_ALL_TASK_MASTER", con))
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TaskMaster taskMaster = new TaskMaster();
taskMaster.Task_Id = reader.GetInt32(0);
taskMaster.Task_Name = Convert.ToString(reader.GetValue(1));
taskMaster.ParentTask_Name = Convert.ToString(reader.GetValue(2));
taskMaster.Priority = reader.GetInt32(3);
taskMaster.Start_Date = Convert.ToString(reader.GetValue(4));
taskMaster.End_Date = Convert.ToString(reader.GetValue(5));
lstItem.Add(taskMaster);
}
}
}
return(lstItem);
}
