public void Create(Customer customer)
{
var options = _context.options;
using (var context = new DeezNutsContext(options))
{
if (customer.Id > 0)
{
var existingCustomer = context.Customers.SingleOrDefault(c => c.Id == customer.Id);
//do the update to the database
context.Entry(existingCustomer).CurrentValues.SetValues(customer);
context.Entry(existingCustomer).State = EntityState.Modified;
//then update the parent this way
//first get the particular parent for this student
var session = context.CustomerSessions.SingleOrDefault(s => s.CustomerId == existingCustomer.Id);
context.Entry(session).CurrentValues.SetValues(customer.Session);
context.Entry(session).State = EntityState.Modified;
}
else
{
context.Customers.Add(customer);
}
context.SaveChanges();
}
}
private void CreateOrUpdate(MessageLog obj)
{
var options = _context.options;
var messageLog = _context.MessageLogs
.SingleOrDefault(m => m.TwilioMessageSid == obj.TwilioMessageSid);
using (var context = new DeezNutsContext(options))
{
if (messageLog != null)
{
context.MessageLogs.Attach(new MessageLog
{
Id = messageLog.Id,
Status = obj.Status
});
}
else
{
context.MessageLogs.Add(obj);
}
context.SaveChanges();
}
}
public void Update(Order order)
{
var options = _context.options;
using (var context = new DeezNutsContext(options))
{
if (order.Id > 0)
{
var existingOrder = GetOrderById(order.Id);
context.Entry(existingOrder).CurrentValues.SetValues(order);
context.Entry(existingOrder).State = EntityState.Modified;
}
else
{
context.Orders.Add(order);
}
context.SaveChanges();
}
}
public SettingRepository(DeezNutsContext context)
{
_context = context;
}
public ListeningActionRepository(DeezNutsContext context)
{
this._context = context;
}
public CustomerRepository(DeezNutsContext context)
{
this._context = context;
}
public MessageRepository(DeezNutsContext context)
{
this._context = context;
}
public ProductRepository(DeezNutsContext context)
{
this._context = context;
}
public MessageLogRepository(DeezNutsContext context)
{
_context = context;
}
public OrderRepository(DeezNutsContext context)
{
this._context = context;
}
