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