public static bool AddLableTask(LableTask relation)
{
bool succ = false;
using (var connection = DBconnect.Instance.Connection)
{
SqlCommand command = new SqlCommand($"{ADD_TASKLABLE} {relation.ToInsert()}", connection);
connection.Open();
var id = command.ExecuteNonQuery();
succ = true;
connection.Close();
}
return(succ);
}
public static bool DeleteLableTask(LableTask relation)
{
bool succ = false;
using (var connection = DBconnect.Instance.Connection)
{
string DELETE_RELATION = $"DELETE FROM TaskLableRelation" +
$" WHERE lable_id={relation.lable_id}" + $" AND task_id={relation.task_id}";
SqlCommand command = new SqlCommand(DELETE_RELATION, connection);
connection.Open();
var n = command.ExecuteNonQuery();
if (n == 1)
{
succ = true;
}
connection.Close();
}
return(succ);
}
public LableTask(LableTask persontask)
{
lable_id = persontask.lable_id;
task_id = persontask.task_id;
}