/// <summary>
/// Remove item.
/// </summary>
/// <param name="item">Item to remove.</param>
/// <returns>True if the operation was successful.</returns>
public bool DeleteItem(PICA_B2C.Business.MainModule.Entities.Models.Item item)
{
using (AES_Pica_Items context = new AES_Pica_Items())
{
var currentItem = (from it in context.Items
where it.ItemId == item.ItemId
select it).FirstOrDefault();
context.Items.Attach(currentItem);
context.Entry(currentItem).State = System.Data.Entity.EntityState.Deleted;
context.SaveChanges();
return(true);
}
}
/// <summary>
/// Get the items of a customer.
/// </summary>
/// <param name="customerId">Customer Id.</param>
/// <returns>List items.</returns>
public List <PICA_B2C.Business.MainModule.Entities.Models.Item> GetItemsByCustomer(int customerId)
{
using (AES_Pica_Items context = new AES_Pica_Items())
{
var query = from itm in context.Items where itm.ClienteId == customerId select itm;
var lstItems = query.Select(itm => new PICA_B2C.Business.MainModule.Entities.Models.Item
{
ItemId = itm.ItemId,
Quantity = itm.Cantidad,
//= itm.ClienteId,
ProductId = itm.ProductoId
}).ToList();
return(lstItems.ToList());
}
}
/// <summary>
/// Add new item.
/// </summary>
/// <param name="item">Item to add.</param>
/// <param name="customerId">Customer Id.</param>
/// <returns>True if the operation was successful.</returns>
public bool AddItem(PICA_B2C.Business.MainModule.Entities.Models.Item item, int customerId)
{
Item newItem = new Item
{
ItemId = item.ItemId,
Cantidad = item.Quantity,
ClienteId = customerId,
ProductoId = item.ProductId
};
using (AES_Pica_Items context = new AES_Pica_Items())
{
context.Items.Add(newItem);
context.SaveChanges();
return(true);
}
}
/// <summary>
/// Modify item.
/// </summary>
/// <param name="item">Item to modify</param>
/// <returns>True if the operation was successful.</returns>
public bool ModifyQuantityToItem(PICA_B2C.Business.MainModule.Entities.Models.Item item)
{
using (AES_Pica_Items context = new AES_Pica_Items())
{
Item itemCurrent = (from itm in context.Items
where itm.ItemId == item.ItemId
select itm).FirstOrDefault();
if (itemCurrent != null)
{
itemCurrent.Cantidad = item.Quantity;
context.SaveChanges();
return(true);
}
else
{
throw new InvalidOperationException("Item inexistente");
}
}
}
/// <summary>
/// Remove items from a customer.
/// </summary>
/// <param name="customerId">Customer Id.</param>
/// <returns>True if the operation was successful.</returns>
public bool DeleteItemsByCustomerId(int customerId)
{
using (AES_Pica_Items context = new AES_Pica_Items())
{
var lstItems = (from it in context.Items
where it.ClienteId == customerId
select it);
if ((lstItems != null))
{
foreach (var itm in lstItems)
{
context.Items.Attach(itm);
context.Entry(itm).State = System.Data.Entity.EntityState.Deleted;
}
context.SaveChanges();
}
return(true);
}
}