public async Task <IActionResult> ItemCategory([FromBody] GetChangesModel model) { if (model == null) { return(null); } var Inserted = await _Context.Set <ItemCategory>().Where(x => x.CreationDate >= model.LastUpdate).Select(x => new ItemCategoryModel { Description = x.Description, ImagePath = x.ImagePath, Name = x.Name }).ToListAsync(); var Updated = await _Context.Set <ItemCategory>().Where(x => x.UpdatedDate >= model.LastUpdate && x.CreationDate <= model.LastUpdate).Select(x => new ItemCategoryModel { Description = x.Description, ImagePath = x.ImagePath, Name = x.Name }).ToListAsync(); var IDs = await _Context.Set <ItemCategory>().Select(x => x.ID).ToListAsync(); var Deleted = model.RecoredIDs.Where(x => !IDs.Contains(x)).ToList(); return(Json(new { Inserted, Updated, Deleted })); }
public async Task <IActionResult> OfferItem([FromBody] GetChangesModel model) { if (model == null) { return(null); } var Inserted = await _Context.Set <OfferItem>().Where(x => x.CreationDate >= model.LastUpdate).Select(x => new OfferItemModel { ItemID = x.ItemID, Quantity = x.Quantity, OfferID = x.OfferID }).ToListAsync(); var Updated = await _Context.Set <OfferItem>().Where(x => x.UpdatedDate >= model.LastUpdate && x.CreationDate <= model.LastUpdate).Select(x => new OfferItemModel { ItemID = x.ItemID, Quantity = x.Quantity, OfferID = x.OfferID }).ToListAsync(); var IDs = await _Context.Set <OfferItem>().Select(x => x.ID).ToListAsync(); var Deleted = model.RecoredIDs.Where(x => !IDs.Contains(x)).ToList(); return(Json(new { Inserted, Updated, Deleted })); }
public async Task <IActionResult> Offer([FromBody] GetChangesModel model) { if (model == null) { return(null); } var Inserted = await _Context.Set <Offer>().Include(x => x.Item).Where(x => x.CreationDate >= model.LastUpdate).Select(x => new OfferModel { Description = x.Description, Discount = x.Discount, IsActive = x.IsActive, OfferType = x.OfferType, ItemID = x.ItemID, ItemName = x.Item.Name, Price = x.Price, ShortDescription = x.Description, ThumbnailImagePath = x.ThumbnailImagePath, Title = x.Title }).ToListAsync(); var Updated = await _Context.Set <Offer>().Where(x => x.UpdatedDate >= model.LastUpdate && x.CreationDate <= model.LastUpdate).Select(x => new OfferModel { Description = x.Description, Discount = x.Discount, IsActive = x.IsActive, OfferType = x.OfferType, ItemID = x.ItemID, ItemName = x.Item.Name, Price = x.Price, ShortDescription = x.Description, ThumbnailImagePath = x.ThumbnailImagePath, Title = x.Title }).ToListAsync(); var IDs = await _Context.Set <Offer>().Select(x => x.ID).ToListAsync(); var Deleted = model.RecoredIDs.Where(x => !IDs.Contains(x)).ToList(); return(Json(new { Inserted, Updated, Deleted })); }
public async Task <IActionResult> Item([FromBody] GetChangesModel model) { if (model == null) { return(null); } var Inserted = await _Context.Set <Item>().Where(x => x.CreationDate >= model.LastUpdate).Select(x => new ItemModel { Description = x.Description, Quantity = x.Quantity, IsEnable = x.IsEnable, ItemCategoryID = x.ItemCategoryID, Name = x.Name, Price = x.Price, ShortDescription = x.ShortDescription, ThumbnailImagePath = x.ThumbnailImagePath }).ToListAsync(); var Updated = await _Context.Set <Item>().Where(x => x.UpdatedDate >= model.LastUpdate && x.CreationDate <= model.LastUpdate).Select(x => new ItemModel { Description = x.Description, Quantity = x.Quantity, IsEnable = x.IsEnable, ItemCategoryID = x.ItemCategoryID, Name = x.Name, Price = x.Price, ShortDescription = x.ShortDescription, ThumbnailImagePath = x.ThumbnailImagePath }).ToListAsync(); var IDs = await _Context.Set <Item>().Select(x => x.ID).ToListAsync(); var Deleted = model.RecoredIDs.Where(x => !IDs.Contains(x)).ToList(); return(Json(new { Inserted, Updated, Deleted })); }
private async Task <IActionResult> GetChanges <table>(GetChangesModel model) where table : DatabaseObject { if (model == null) { return(null); } var Inserted = await _Context.Set <table>().Where(x => x.CreationDate >= model.LastUpdate).ToListAsync(); var Updated = await _Context.Set <table>().Where(x => x.UpdatedDate >= model.LastUpdate && x.CreationDate <= model.LastUpdate).ToListAsync(); var IDs = await _Context.Set <table>().Select(x => x.ID).ToListAsync(); var Deleted = model.RecoredIDs.Where(x => !IDs.Contains(x)).ToList(); return(Json(new { Inserted, Updated, Deleted })); }