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