public IActionResult CreateFromJson([FromBody] Customer customer)
{
if (ModelState.IsValid)
{
Customer customerToSave = null;
bool isNewCustomer = true;
if (customer.CustomerId == Guid.Empty)
{
customer.CustomerId = Guid.NewGuid();
_context.Customer.Add(customer);
customerToSave = new Customer();
customerToSave.Name = customer.Name;
}
else
{
isNewCustomer = false;
customerToSave = _context.Customer.Where(c => c.CustomerId == customer.CustomerId).Include(c => c.Contacts).Single();
//customerToSave.Name = customer.Name;
_context.Entry(customerToSave).CurrentValues.SetValues(customer);
}
foreach (var contact in customer.Contacts)
{
if (contact.ContactId == Guid.Empty)
{
contact.ContactId = Guid.NewGuid();
customerToSave.Contacts.Add(contact);
_context.Contact.Add(contact);
}
else
{
var existingContact = _context.Contact.Where(c => c.ContactId == contact.ContactId).Single();
//existingContact.Name = contact.Name;
_context.Entry(existingContact).CurrentValues.SetValues(contact);
}
}
if (!isNewCustomer)
{
var contactIds = customer.Contacts.Select(c => c.ContactId);
var contactsToRemove = customerToSave.Contacts.Where(c => !contactIds.Contains(c.ContactId));
foreach (var contactToRemove in contactsToRemove)
{
_context.Contact.Remove(contactToRemove);
}
}
_context.SaveChanges();
}
return(Ok(_context.Customer.ToList()));
}
public IHttpActionResult PutCustomer(int id, Customer customer)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != customer.Id)
{
return(BadRequest());
}
db.Entry(customer).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> PutCustomer([FromRoute] long id, [FromBody] Customer customer)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != customer.CustomerId)
{
return(BadRequest());
}
_context.Entry(customer).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult Edit([Bind(Include = "CustomerID,name,surname,email,password,dob,phone_number")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "ID,LastName,FirstName,Address,Age")] Customers customers)
{
if (ModelState.IsValid)
{
db.Entry(customers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customers));
}
public ActionResult Edit([Bind(Include = "ID,Name,Email,Phone,BirthDate")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "CategoryId,CategoryName,CategoryDescription")] Category category)
{
if (ModelState.IsValid)
{
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Edit(CustomerModel customermodel)
{
if (ModelState.IsValid)
{
db.Entry(customermodel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customermodel));
}
public ActionResult Edit([Bind(Include = "CustomerID,Name,phonenumber,Email,DeliveryAddress")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "CustomerID,FirstName,LastName,CustomerAge,Phone,DrinkID,DrinkType")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "Guid,FullName,DateCreated,Amount,Ref")] Customer customer)
{
if (ModelState.IsValid)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Edit([Bind(Include = "Id,ProductName,Price,Description,CategoryId")] Product product)
{
if (ModelState.IsValid)
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "CategoryName", product.CategoryId);
return(View(product));
}
public async Task <IActionResult> PutCustomer(long id, Customer customer)
{
if (id != customer.Id)
{
return(BadRequest());
}
if (ModelState.IsValid)
{
_context.Entry(customer).State = EntityState.Modified;
await _context.SaveChangesAsync();
}
return(NoContent());
}
public JsonResult UpdateProduct(Product product)
{
var result = false;
try
{
db.Entry(product).State = EntityState.Modified;
db.SaveChanges();
result = true;
}
catch (Exception)
{
throw;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task <bool> Update(int id, Customer customer)
{
_context.Entry(customer).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CustomerExists(id))
{
return(false);
}
else
{
throw;
}
}
return(true);
}
public bool Update(Customer customer)
{
int isExecuted = 0;
//Method 1
//Student aStudent = db.Students.FirstOrDefault(c => c.ID == student.ID);
//if (aStudent != null)
//{
// aStudent.Name = student.Name;
// isExecuted = db.SaveChanges();
//}
//Method 2
db.Entry(customer).State = EntityState.Modified;
isExecuted = db.SaveChanges();
if (isExecuted > 0)
{
return(true);
}
return(false);
}
public ActionResult Edit(Customer customer)
{
db.Entry(customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("index"));
}
/// <summary> /// //In every Test Case the DBContext is a new Instance, /// due to this in order to get a successfull delete we detach the Entity to Update /// </summary> private void DetachEntity(int keyId) => _inMemoryDB.Entry(_inMemoryDB.Customers.Find(keyId)).State = EntityState.Detached;
