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