public static void UpdateStatus(int status, int id) { var data = new Dictionary <string, string>(); data.Add("status", status.ToString()); WankoDB.Update(table, data, "todo_id", id.ToString()); }
public static void Update(string title, int tag, int id) { var data = new Dictionary <string, string>(); data.Add("title", $"'{title}'"); data.Add("tag", tag.ToString()); WankoDB.Update(table, data, "todo_id", id.ToString()); }
public static void Insert(string title, int tag, int status) { var data = new Dictionary <string, string>(); data.Add("title", $"'{title}'"); data.Add("tag", tag.ToString()); data.Add("status", status.ToString()); WankoDB.Insert(table, data); }
public static void Insert(int id, int type, string desc, int price) { var data = new Dictionary <string, string>(); data.Add("costume_id", id.ToString()); data.Add("type", type.ToString()); data.Add("description", $"'{desc}'"); data.Add("price", price.ToString()); data.Add("status", "0"); WankoDB.Insert(table, data); }
public static void Insert(string date, string title, string detail, int icon, int remind, string time) { var data = new Dictionary <string, string>(); data.Add("date", $"'{date}'"); data.Add("title", $"'{title}'"); data.Add("detail", $"'{detail}'"); data.Add("icon", icon.ToString()); data.Add("remind", remind.ToString()); data.Add("time", $"'{time}'"); WankoDB.Insert(table, data); }
public static void Update(int id, string date, string title, string detail, int icon, int remind, string time) { var data = new Dictionary <string, string>(); data.Add("date", $"'{date}'"); data.Add("title", $"'{title}'"); data.Add("detail", $"'{detail}'"); data.Add("icon", icon.ToString()); data.Add("remind", remind.ToString()); data.Add("time", $"'{time}'"); WankoDB.Update(table, data, "schedule_id", id.ToString()); }
public static void Insert(string time, int snooze, int sun, int mon, int tue, int wed, int thu, int fri, int sat) { var data = new Dictionary <string, string>(); data.Add("time", $"'{time}'"); data.Add("status", "1"); data.Add("snooze", snooze.ToString()); data.Add("repeat_sun", sun.ToString()); data.Add("repeat_mon", mon.ToString()); data.Add("repeat_tue", tue.ToString()); data.Add("repeat_wed", wed.ToString()); data.Add("repeat_thu", thu.ToString()); data.Add("repeat_fri", fri.ToString()); data.Add("repeat_sat", sat.ToString()); WankoDB.Insert(table, data); }
public static void DeleteById(int id) { WankoDB.DeleteBy(table, "todo_id", id.ToString()); }
public static DataTable FindById(int id) { return(WankoDB.FindBy(table, "todo_id", id.ToString())); }
public static DataTable FindAll() { return(WankoDB.FindAll(table)); }
public static DataTable FindByType(int type) { return(WankoDB.FindBy(table, "type", type.ToString())); }
public static DataTable FindById(int id) { return(WankoDB.FindBy(table, "costume_id", $"'{id}'")); }
public static DataTable FindByTime(string time) { return(WankoDB.FindBy(table, "time", $"'{time}'")); }
public static DataTable FindByDate(string date) { return(WankoDB.FindBy(table, "date", $"'{date}'")); }