public int AddParentTask(ParentTask task) { int affectedRow = 0; using (SqlConnection con = new SqlConnection(TaskManagerDb.ConnectionString)) { using (SqlCommand cmd = new SqlCommand("INSERT INTO ParentTask (Parent_Task) VALUES(@Parent_Task)", con)) { cmd.Parameters.AddWithValue("@Parent_Task", task.Parent_Task); con.Open(); affectedRow = cmd.ExecuteNonQuery(); } } return(affectedRow); }
public int EditParentTask(ParentTask task) { int affectedRow = 0; using (SqlConnection con = new SqlConnection(TaskManagerDb.ConnectionString)) { using (SqlCommand cmd = new SqlCommand("UPDATE ParentTask SET Parent_Task = @Parent_Task WHERE Parent_ID = @Parent_ID", con)) { cmd.Parameters.AddWithValue("@Parent_ID", task.Parent_Id); cmd.Parameters.AddWithValue("@Parent_Task", task.Parent_Task); con.Open(); affectedRow = cmd.ExecuteNonQuery(); } } return(affectedRow); }
public IList <ParentTask> GetParentTaskById(string id) { IList <ParentTask> lstItem = new List <ParentTask>(); using (SqlConnection con = new SqlConnection(TaskManagerDb.ConnectionString)) { using (SqlCommand cmd = new SqlCommand("SELECT * FROM ParentTask WHERE Parent_ID = @Parent_ID", con)) { cmd.Parameters.AddWithValue("@Parent_ID", id); con.Open(); IDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ParentTask task = new ParentTask(); task.Parent_Id = reader.GetInt32(0); task.Parent_Task = Convert.ToString(reader.GetValue(1)); lstItem.Add(task); } } } return(lstItem); }