public void Add()
{
DalC.query($"INSERT INTO columns (name,collimit,email,ordinal) VALUES ('{name}',{limit},'{email}',{ordinal})");
List <object[]> rows = DalC.select($"SELECT id FROM columns WHERE email = '{email}' AND ordinal = {ordinal} ORDER BY id", 1);
id = (long)rows[rows.Count - 1][0];
}
public void Add()
{
DalC.query($"INSERT INTO users (email,password,nickname,board) VALUES ('{email}','{password}','{nickname}','{board}')");
}
public void UpdateTaskID(int taskid)
{
this.taskid = taskid;
DalC.query($"UPDATE boards SET taskId={taskid} WHERE email='{email}'");
}
public void Add()
{
DalC.query($"INSERT INTO boards (taskId,email) VALUES ({taskid},'{email}')");
}
public void Delete()
{
DalC.query($"DELETE FROM tasks WHERE id={id} AND email='{email}'");
}
public void UpdateDescription(string desctiption)
{
this.description = desctiption;
DalC.query($"UPDATE tasks SET description='{description}' WHERE id={id} AND email='{email}'");
}
public void UpdateTitle(string title)
{
this.title = title;
DalC.query($"UPDATE tasks SET title='{title}' WHERE id={id} AND email='{email}'");
}
public void UpdateDueDate(DateTime dueDate)
{
this.dueDate = dueDate.ToString(DS);
DalC.query($"UPDATE tasks SET dueDate='{dueDate}' WHERE id={id} AND email='{email}'");
}
public void UpdateAssigned(string assigned)
{
this.assigned = assigned;
DalC.query($"UPDATE tasks SET assigned='{assigned}' WHERE id={id} AND email='{email}'");
}
public void Add()
{
DalC.query($"INSERT INTO tasks (id,email,assigned,creationTime,dueDate,title,description,column) VALUES ({id},'{email}','{assigned}','{creationTime}','{dueDate}','{title}','{description}',{column})");
}
public void Delete()
{
DalC.query($"DELETE FROM columns WHERE id={id}");
DalC.query($"DELETE FROM tasks WHERE column={id}");
}
public void UpdateOrdinal(int ordinal)
{
this.ordinal = ordinal;
DalC.query($"UPDATE columns SET ordinal={ordinal} WHERE id={id}");
}
public void UpdateLimit(int limit)
{
this.limit = limit;
DalC.query($"UPDATE columns SET limit={limit} WHERE id={id}");
}
public void UpdateName(string name)
{
this.name = name;
DalC.query($"UPDATE columns SET name='{name}' WHERE id={id}");
}
