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