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