public void UpdateItem(int OrderID, int updateProductID, int qtyShipped, int qtyCancelled, string comment)
{
using (var _db = new FrontierAg.Models.ProductContext())
{
try
{
var myDBOrderDetail = (from c in _db.OrderDetails where c.OrderId == OrderID && c.ProductId == updateProductID select c).FirstOrDefault();
if (myDBOrderDetail != null)
{
//do the work.............
if (qtyCancelled + qtyShipped <= myDBOrderDetail.Quantity)
{
myDBOrderDetail.QtyShipped = qtyShipped;
myDBOrderDetail.QtyCancelled = qtyCancelled;
myDBOrderDetail.Comment = comment;
}
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp);
}
}
}
// The return type can be changed to IEnumerable, however to support
// paging and sorting, the following parameters must be added:
// int maximumRows
// int startRowIndex
// out int totalRowCount
// string sortByExpression
public IQueryable <FrontierAg.Models.OrderDetail> AllDetailsGrid_GetData()
{
IList <string> segments = Request.GetFriendlyUrlSegments();
ContactId = int.Parse(segments[0]);
if (ContactId != null)
{
FrontierAg.Models.ProductContext _db = new FrontierAg.Models.ProductContext();
//var my = from r in _db.OrderDetails
return(_db.OrderDetails.Where(mn => mn.Order.ContactId == ContactId));
}
return(null);
}
public void RemoveItem(string removeCartID, int removeProductID)
{
using (var _db = new FrontierAg.Models.ProductContext())
{
try
{
var myItem = (from c in _db.ShoppingCartItems where c.CartId == removeCartID && c.Product.ProductId == removeProductID select c).FirstOrDefault();
if (myItem != null)
{
// Remove Item.
_db.ShoppingCartItems.Remove(myItem);
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Remove Cart Item - " + exp.Message.ToString(), exp);
}
}
}
public void UpdateItem(string updateCartID, int updateProductID, int quantity, Decimal PriceOverride) // execute when changing price box or qty
{
using (var _db = new FrontierAg.Models.ProductContext())
{
//try
//{
//get item from CartItem Table in DB
var myItem = (from c in _db.ShoppingCartItems where c.CartId == updateCartID && c.Product.ProductId == updateProductID select c).FirstOrDefault();
if (myItem != null)
{
//if QTY changed, get price from table
if (myItem.Quantity != quantity)
{
myItem.Quantity = quantity;
myItem.ItemPrice = GetPriceFromPrices(updateProductID, quantity);
myItem.Charge = GetChargeFromPackCharges(updateProductID, quantity);
myItem.OriginalPrice = myItem.ItemPrice;
}
else
{
//if Price changed, then use new price
myItem.ItemPrice = PriceOverride;
}
CartSessionFlag = 0;
_db.SaveChanges();
}
else
{
CartSessionFlag = updateProductID;
}
//}
//catch (Exception exp)
//{
// throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp);
//}
}
}
