public static async void ReadBouquetConsist() { var bouquetConsist = await ProductAPI_Logic.GetBouquetConsist(); int count = bouquetConsist.Count; for (int i = 0; i < count; i++) { BouquetConsistPost post = new BouquetConsistPost() { Id = bouquetConsist[i].id, Flower_type_id = bouquetConsist[i].flower_type_id, Bouquet_id = bouquetConsist[i].bouquet_id }; using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation)) { conn.CreateTable <BouquetConsistPost>(); int rows = conn.InsertOrReplace(post); if (rows > 0) { //success++; } else { //fail++; } } } //Tikrinimas ar yra pašalintų įrašų duombazėje using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation)) { conn.CreateTable <BouquetConsistPost>(); var apiLast = bouquetConsist.Last().id; var apiCount = bouquetConsist.Count; var posts = conn.Table <BouquetConsistPost>().ToList(); var dbLast = posts.Last().Id; int dbCount = posts.Count; if (apiLast != dbLast && dbCount != apiCount) { foreach (var a in posts) { if (!bouquetConsist.Any(n => n.id == a.Id)) { conn.Delete <BouquetConsistPost>(a.Id); } } } conn.Close(); } }
public static async void ReadOccasionTypes() { var occasionTypes = await ProductAPI_Logic.GetOccasionTypes(); int count = occasionTypes.Count; for (int i = 0; i < count; i++) { Occasion_TypePost post = new Occasion_TypePost() { Id = occasionTypes[i].id, Name = occasionTypes[i].name }; using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation)) { conn.CreateTable <Occasion_TypePost>(); int rows = conn.InsertOrReplace(post); if (rows > 0) { //success++; } else { //fail++; } } } //Tikrinimas ar yra pašalintų įrašų duombazėje using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation)) { conn.CreateTable <Occasion_TypePost>(); var apiLast = occasionTypes.Last().id; var apiCount = occasionTypes.Count; var posts = conn.Table <Occasion_TypePost>().ToList(); var dbLast = posts.Last().Id; int dbCount = posts.Count; if (apiLast != dbLast && dbCount != apiCount) { foreach (var a in posts) { if (!occasionTypes.Any(n => n.id == a.Id)) { conn.Delete <Occasion_TypePost>(a.Id); } } } conn.Close(); } }
//--- public static async void ReadFlowers() { var flowers = await ProductAPI_Logic.GetFlowers("flowers"); int count = flowers.Count; using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation)) { for (int i = 0; i < count; i++) { conn.CreateTable <FlowerPost>(); FlowerPost post = new FlowerPost() { Id = flowers[i].id, Name = flowers[i].flower_name, Quantity = flowers[i].quantity, Price = flowers[i].price, Description = flowers[i].description, Discount = flowers[i].discount, Gender = flowers[i].gender, Flower_type_id = flowers[i].flower_type_id }; try { var imageFromDatabase = conn.Find <FlowerPost>(post.Id); //Nuskaitoma puokste is sqlite post.Favorite = imageFromDatabase.Favorite; if (imageFromDatabase.Image_sh != flowers[i].flower_image_sh || imageFromDatabase.Image_sh == null) // tikrinamas gautas sh is api su turimu db { //nuskaitomas ir priskiriamas naujas paveikslelis bei sh kodas string newImage = await ProductAPI_Logic.GetProductImage(flowers[i].id, "flowers"); post.Image_sh = flowers[i].flower_image_sh; post.Image = newImage; } else { //Paliekamas senas paveikslelis ir sh kodas post.Image_sh = imageFromDatabase.Image_sh; post.Image = imageFromDatabase.Image; } } catch (NullReferenceException ex) { string newImage = await ProductAPI_Logic.GetProductImage(flowers[i].id, "flowers"); post.Image_sh = flowers[i].flower_image_sh; post.Image = newImage; post.Favorite = false; } conn.CreateTable <FlowerPost>(); int rows = conn.InsertOrReplace(post); if (rows > 0) { //success++; } else { //fail++; } } conn.CreateTable <FlowerPost>(); var apiLast = flowers.Last().id; var apiCount = flowers.Count; var posts = conn.Table <FlowerPost>().ToList(); var dbLast = posts.Last().Id; int dbCount = posts.Count; if (apiLast != dbLast && dbCount != apiCount) { foreach (var a in posts) { if (!flowers.Any(n => n.id == a.Id)) { conn.Delete <FlowerPost>(a.Id); } } } conn.Close(); } }
public static async void ReadAssignedOccasion() { var assignedOccasions = await ProductAPI_Logic.GetAssignedOccasions(); int count = assignedOccasions.Count; for (int i = 0; i < count; i++) { int gelyte = 0; int puokstyte = 0; if (assignedOccasions[i].flower_id != null) { gelyte = Convert.ToInt32(assignedOccasions[i].flower_id); } if (assignedOccasions[i].bouquet_id != null) { puokstyte = Convert.ToInt32(assignedOccasions[i].bouquet_id); } AssignedOccasionsPost post = new AssignedOccasionsPost() { Id = assignedOccasions[i].id, Bouquet_id = puokstyte, Flower_id = gelyte, Occasion_id = assignedOccasions[i].occasion_id }; using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation)) { conn.CreateTable <AssignedOccasionsPost>(); int rows = conn.InsertOrReplace(post); if (rows > 0) { //success++; } else { //fail++; } } } //Tikrinimas ar yra pašalintų įrašų duombazėje using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation)) { conn.CreateTable <AssignedOccasionsPost>(); var apiLast = assignedOccasions.Last().id; var apiCount = assignedOccasions.Count; var posts = conn.Table <AssignedOccasionsPost>().ToList(); var dbLast = posts.Last().Id; int dbCount = posts.Count; if (apiLast != dbLast && dbCount != apiCount) { foreach (var a in posts) { if (!assignedOccasions.Any(n => n.id == a.Id)) { conn.Delete <AssignedOccasionsPost>(a.Id); } } } conn.Close(); } }