private void GetPrices(CustomerIsPay value)
{
if (STTModel != null)
{
var pricesContext = new PricesContext(STTModel);
pricesContext.GetPrices().ContinueWith(GetPricesAsyncHandler);
}
}
private void PriceUpdateAction(object obj)
{
try
{
this.PriceIsSync = true;
// var data = GetPriceObject();
var context = new PricesContext(STTModel);
context.UpdatePrice(STTModel.Price);
}
catch (Exception ex)
{
ModernDialog.ShowMessage(ex.Message, "Error", System.Windows.MessageBoxButton.OK);
}
this.PriceIsSync = false;
}
public static T AddOrUpdate <T>(this DbSet <T> dbset, T obj, PricesContext db) where T : class
{
var entity_obj = obj as IEntity;
db.Entry(obj).State = entity_obj.Id == 0 ?
EntityState.Added :
EntityState.Modified;
//if the entity already exist in db
if (db.Entry(obj).State == EntityState.Modified)
{
//TODO: update by the latest date
return(obj);
}
var newEntity = db.Set <T>().Add(obj);
return(newEntity);
}
/*---------------------------------*/
public void InsertOrUpdate(ICollection <Store> entity)
{
using (var db = new PricesContext())
{
foreach (var en in entity)
{
try
{
var chain = db.Set <Chain>().AddOrUpdate((en.Chain), db);
en.Chain = chain;
var store = db.Set <Store>().Add(en);
db.SaveChanges();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException e)
{
Console.WriteLine(e.InnerException.InnerException.Message);
}
}
}
Console.WriteLine("Stores added");
}
public PricesController(PricesContext _context)
{
context = _context;
}
