/*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(fixed_costmoney item) { if (item.ID != 0) { return(database.UpdateAsync(item)); } else { return(database.InsertAsync(item)); } }
private async void tourokuClicked(object sender, EventArgs e) { base.OnAppearing(); var result = await App.Database4.GetItemsAsync(); /*foreach (var loc in result) * { * await App.Database1.DeleteItemAsync(loc); * }*/ int num; string str; num = int.Parse(kingaku.Text); str = (string)koumoku.SelectedItem; var fix = new fixed_costmoney() { Spay = num, cate = str }; Save(fix); //await DisplayAlert("登録しました","OK",""); }
public Task <int> DeleteItemAsync(fixed_costmoney item) { return(database.DeleteAsync(item)); }
public async void Save(fixed_costmoney item1) { await App.Database4.SaveItemAsync(item1); await DisplayAlert("DATA", "登録しました", "OK"); }