/*public Task<List<LocationItem>> GetItemDay(System.Collections.Generic.List<System.DateTime> day)
* {
* var DayList = day;
* DateTime Daykd = day[0];
* return database.QueryAsync<LocationItem>("SELECT * FROM [LocationItem] WHERE Day = " + Daykd);
* }
*
* public Task<List<LocationItem>> GetItemNameAsync(String Name, DateTime dates)
* {
* return database.QueryAsync<LocationItem>("SELECT * FROM [LocationItem] WHERE Name = " + Name + "Day = " + dates);
* }*/
public Task <int> SaveItemAsync(LocationItem item)
{
if (item.ID != 0)
{
return(database.UpdateAsync(item));
}
else
{
return(database.InsertAsync(item));
}
}
private void b5Clicked(object sender, EventArgs e)
{
DateTime dt1 = DateTime.Parse(dd);
LocationItem item = new LocationItem()
{
Name = In[4],
Spay = Tm[4],
Day = dt1
};
Save(item);
}
private void tourokuClicked(object sender, EventArgs e)
{
int kin = int.Parse(money.Text);
//DateTime dt1 = DateTime.Parse(dd);
DateTime dt1 = DateTime.Parse(dd);
LocationItem item = new LocationItem()
{
Name = koumoku.Text,
Spay = kin,
Day = dt1
};
Save(item);
}
private void b7Clicked(object sender, EventArgs e)
{
try {
DateTime dt1 = DateTime.Parse(dd);
LocationItem item = new LocationItem()
{
Name = In[6],
Spay = Tm[6],
Day = dt1
};
Save(item);
}
catch (Exception)
{
DisplayAlert("Alert", "データがあるボタンを選択してください。", "OK");
}
}
private void tourokuClicked(object sender, EventArgs e)
{
try
{
int kin = int.Parse(money.Text);
//DateTime dt1 = DateTime.Parse(dd);
//DateTime dt1 = DateTime.Parse(dd);
LocationItem item = new LocationItem()
{
Name = koumoku.Text,
Spay = kin,
Day = this.dd
};
Save(item);
}
catch (Exception)
{
DisplayAlert("Alert", "正しい値を入力してください。", "OK");
}
}
/* private void lay5Clicked(object sender, EventArgs e)
* {
*
* DateTime dt1 = DateTime.Parse(dd);
* LocationItem item = new LocationItem()
* {
* Name = In[x],
* Spay = Tm[x],
* Day = dt1
* };
* Save(item);
* }*/
public async void Save(LocationItem item1)
{
await App.Database.SaveItemAsync(item1);
await DisplayAlert("DATA", "登録しました", "OK");
}
public Task <int> DeleteItemAsync(LocationItem item)
{
return(database.DeleteAsync(item));
}
public async void Delete(LocationItem item1)
{
await App.Database.DeleteItemAsync(item1);
await DisplayAlert("削除", "", "OK");
}
