protected override async Task Add(CashQRCodeViewModel item)
{
var cashQRCodeVM = item.PartialClone();
List.Add(cashQRCodeVM);
await AsyncDatabase.AddItemAsync(cashQRCodeVM.CashQRCode);
}
protected override async Task Remove(CashQRCodeViewModel item)
{
List.Remove(item);
await AsyncDatabase.GetItemsAsync <CashQRCode>();
await AsyncDatabase.RemoveItemAsync <CashQRCode>(item.CashQRCode.Id);
}
protected override async Task Add(CheckViewModel item)
{
item.Check.Type = CheckType;
List.Add(item);
item.Check.Serialize();
await AsyncDatabase.AddItemAsync(item.Check);
}
protected override async Task InitializeListFromDatabase()
{
await AsyncDatabase.CreateTableAsync <CashQRCode>();
var cashQRCodes = await AsyncDatabase.GetItemsAsync <CashQRCode>();
List = new ObservableCollection <CashQRCodeViewModel>(
cashQRCodes.Select(c => GetCashQRCodeVM(c)));
}
protected override async Task InitializeListFromDatabase()
{
await AsyncDatabase.CreateTableAsync <Check>();
var checks = await AsyncDatabase.Db.Table <Check>().Where(c => c.Type == CheckType).ToListAsync();
checks.ForEach(c => c.Deserialize());
List = new ObservableCollection <CheckViewModel>(checks.Select(c => new CheckViewModel(c)));
}
private void databaseClick()
{
var db = new AsyncDatabase();
//var result = db.CreateTable(ModelHelper.GetProperties(testmodel[0]), ModelHelper.GetModelName(testmodel[0]));
var result = db.CreateTable(testmodel[0]);
Console.WriteLine("ovo sam dobio od clicka: " + result);
var resultdb = db.ExecuteSQL(result);
Console.WriteLine("ovo sam dobio od reszultata: " + resultdb.ToString());
}
public async Task Update(Sign sign)
{
Name = sign.Name;
Email = sign.Email;
Phone = sign.Phone;
Password = sign.Password;
IsAuthorization = sign.IsAuthorization;
await AsyncDatabase.AddOrReplaceItemAsync(Sign);
}
private void addDataClick()
{
try
{
var db = new AsyncDatabase();
//var result = db.CreateTable(ModelHelper.GetProperties(testmodel[0]), ModelHelper.GetModelName(testmodel[0]));
var result = db.Insert(testmodel);
Console.WriteLine("ovo sam dobio od clicka: " + result.ToString());
var resultdb = db.ExecuteSQL(result);
Console.WriteLine("ovo sam dobio od reszultata: " + resultdb.ToString());
}
catch (Exception ex)
{
Console.WriteLine("[DatabasePage][addDataClick] Error {0}", ex.Message);
}
}
private void deleteData()
{
var db = new AsyncDatabase();
/*
var testmodeldelete = new ObservableCollection<TestModel>();
testmodeldelete.Add(testmodel[0]);
testmodeldelete.Add(testmodel[1]);
var results = db.DeleteData(testmodeldelete);
*/
var cachemodeldelete = new ObservableCollection<CacheModel>();
cachemodeldelete.Add(new CacheModel("url_1", "thumbnail_1", "file_1"));
cachemodeldelete.Add(new CacheModel("url_2", "thumbnail_2", "file_2"));
var results = db.DeleteData(cachemodeldelete);
Console.WriteLine("ovo je statement: " + results.ToString());
}
protected override async Task Remove(CheckViewModel item)
{
List.Remove(item);
await AsyncDatabase.RemoveItemAsync <Check>(item.Check.Id);
}
private void getData()
{
var db = new AsyncDatabase();
var results = db.GetData(testmodel[0]);
Console.WriteLine("ovo je statement: " + results.ToString());
var resultExecute = db.ExecuteSQL<TestModel>(results);
Console.WriteLine("ovo je jedan od rezultata: " + resultExecute[0].url + " " + resultExecute[0].title + " " + resultExecute[0].description + "\r Ovo je broj unosa: " + resultExecute.Count);
}
private void updateData()
{
var db = new AsyncDatabase();
var testmodeldelete = new ObservableCollection<TestModel>();
testmodeldelete.Add(testmodel[0]);
testmodeldelete.Add(testmodel[1]);
var result = db.UpdateData(testmodeldelete);
Console.WriteLine("ovo je statement: " + result.ToString());
}
private void getDataSpecific()
{
var db = new AsyncDatabase();
List<string> constraints = new List<string>();
constraints.Add("url");
var results = db.GetData(testmodel[0], 10, SQLHelper.SetConstraint(testmodel, "AND", constraints));
Console.WriteLine("ovo je statement: " + results.ToString());
}
