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