public void UpdateShippingCategory(int id, string name)
{
using (var db = new Entities())
{
var category = db.ShippingCategories.Single(c => c.Id == id);
category.Name = name;
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Update product.
/// </summary>
/// <param name="request"></param>
public void UpdateProduct(int id, UpdateProductRequest request)
{
if (request == null) throw new ArgumentNullException("request");
using(var db = new Llprk.DataAccess.Models.Entities()) {
var product = _GetProduct(db, id);
Mapper.Map(request, product);
db.Entry(product).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Update page with given infos.
/// </summary>
/// <param name="info"></param>
public void UpdatePage(EditPageResponse info)
{
if (info == null) throw new ArgumentNullException("info");
using (var db = new Llprk.DataAccess.Models.Entities())
{
var page = _GetPage(db, info.Id);
Mapper.Map(info, page);
db.Entry(page).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Update product.
/// </summary>
/// <param name="request"></param>
public void UpdateProduct(int id, UpdateProductRequest request)
{
if (request == null)
{
throw new ArgumentNullException("request");
}
using (var db = new Llprk.DataAccess.Models.Entities()) {
var product = _GetProduct(db, id);
Mapper.Map(request, product);
db.Entry(product).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
/// <summary>
/// Update page with given infos.
/// </summary>
/// <param name="info"></param>
public void UpdatePage(EditPageResponse info)
{
if (info == null)
{
throw new ArgumentNullException("info");
}
using (var db = new Llprk.DataAccess.Models.Entities())
{
var page = _GetPage(db, info.Id);
Mapper.Map(info, page);
db.Entry(page).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
public void UpdateLineItemQty(int cartId, UpdateLineItemQtyRequest[] updates)
{
using (var db = new Entities())
{
foreach (var update in updates)
{
var lineItem = db.LineItems.Single(l => l.Id == update.Id);
if (update.Qty == 0)
{
db.LineItems.Remove(lineItem);
}
else
{
lineItem.Qty = update.Qty;
db.Entry(lineItem).State = System.Data.Entity.EntityState.Modified;
}
}
db.SaveChanges();
}
}
public void UpdateShippingCosts(UpdateShippingCostsRequest data)
{
using (var db = new Entities())
{
foreach (var country in data.Countries)
{
foreach (var cost in country.ShippingCosts)
{
var shippingCost = db.ShippingCosts.SingleOrDefault(sc => sc.CountryId == country.Id && sc.ShippingCategoryId == cost.ShippingCategoryId);
if (shippingCost != null)
{
shippingCost.Amount = cost.Amount;
shippingCost.AdditionalAmount = cost.AdditionalAmount;
db.Entry(shippingCost).State = EntityState.Modified;
}
else
{
shippingCost = new ShippingCost
{
CountryId = country.Id,
ShippingCategoryId = cost.ShippingCategoryId,
Amount = cost.Amount,
AdditionalAmount = cost.AdditionalAmount
};
db.ShippingCosts.Add(shippingCost);
}
}
}
db.SaveChanges();
}
}