public static Result SaveInventoryProduct(OETLib.BusinessObjects.Model.Product Product, int productid)
{
Result webRes = new Result(false);
try
{
//new inventory entry
var inventoryToSave = new OETLib.BusinessObjects.Model.Inventory();
inventoryToSave.ProductID = productid;
inventoryToSave.InventoryQuantity = Product.InventoryQuantity;
inventoryToSave.CurrentInventoryQuantity = Product.CurrentInventoryQuantity + Product.InventoryQuantity;
inventoryToSave.InventoryItemCost = Product.ItemCost;
inventoryToSave.InventoryTypeID = 1;
var SavedInventory = inventoryToSave.TrySave(typeof(OETLib.BusinessObjects.Model.InventoryList));
//Get the newly created inventory ID
var newInventoryItem = new OETLib.BusinessObjects.Model.Inventory();
newInventoryItem = OETLib.BusinessObjects.Model.InventoryList.GetInventoryList().LastOrDefault(d => d.ProductID == productid);
//webRes.Data = newInventoryItem;//.InventoryID ;
OETLib.BusinessObjects.Model.InventoryList inventoryList = OETLib.BusinessObjects.Model.InventoryList.GetInventoryList();
inventoryList.Add(newInventoryItem);
OETLib.BusinessObjects.Model.EditInventoryList editInventoryList = OETLib.BusinessObjects.Model.EditInventoryList.GetEditInventoryList();
webRes.Data = editInventoryList;
webRes.Success = true;
}
catch (Exception e)
{
webRes.ErrorText = e.Message;
}
return(webRes);
}
public Result CreateTheOrder(OETLib.BusinessObjects.Model.ProductList productlist)
{
Result webRes = new Result(false);
try
{
foreach (OETLib.BusinessObjects.Model.Product product in productlist)
{
if (product.ProductQuantity != 0)
{
var order = new OETLib.BusinessObjects.Model.Order();
order.UserID = Singular.Settings.CurrentUserID;
order.OrderDate = DateTime.Now;
order.ProcessStatusID = 1;
order.RequiredDate = order.OrderDate = DateTime.Now;
//Save the order
var savedToOrder = order.TrySave(typeof(OETLib.BusinessObjects.Model.OrderList));
//Return the just saved OrderID
var newOrder = new OETLib.BusinessObjects.Model.Order();
newOrder = GetOrder(Singular.Settings.CurrentUserID);
//Create orderDetail
var orderDetail = new OETLib.BusinessObjects.Model.OrderDetail();
orderDetail.OrderID = newOrder.OrderID;
orderDetail.ProductID = product.ProductID;
orderDetail.ProductQuantity = product.ProductQuantity;
orderDetail.UnitPrice = (decimal)product.LinePrice;
//Save newly created OrderDetail
var saveToOrderDetail = orderDetail.TrySave(typeof(OETLib.BusinessObjects.Model.OrderDetailList));
// Get the productId to be able to update the correct inventory
var Inventory_product = OETLib.BusinessObjects.Model.InventoryList.GetInventoryList().LastOrDefault(d => d.ProductID == product.ProductID);
var Inventory_record = new OETLib.BusinessObjects.Model.Inventory();
//Set inventory elements
Inventory_record.ProductID = product.ProductID;
Inventory_record.InventoryQuantity = -product.ProductQuantity;
Inventory_record.CurrentInventoryQuantity = Inventory_product.CurrentInventoryQuantity - product.ProductQuantity;
Inventory_record.InventoryItemCost = Inventory_product.InventoryItemCost;
Inventory_record.InventoryTypeID = 2;
Inventory_record.OrderID = newOrder.OrderID;
//Try and safe the new inventory record
Inventory_record.TrySave(typeof(OETLib.BusinessObjects.Model.InventoryList));
OETLib.BusinessObjects.Model.myCartList mycartlist = OETLib.BusinessObjects.Model.myCartList.GetmyCartList(Singular.Settings.CurrentUserID);
}
}
webRes.Success = true;
OETLib.BusinessObjects.Model.EditInventoryList inventorylist = OETLib.BusinessObjects.Model.EditInventoryList.GetEditInventoryList();
webRes.Data = inventorylist;
}
catch
{
webRes.ErrorText = "There was an error adding your orderr";
}
return(webRes);
}
public Result UpdateInventoryItem(OETLib.BusinessObjects.Model.Product Product)
{
Result webRes = new Result(false);
try
{
OETLib.BusinessObjects.Model.EditInventoryList editInventoryList = OETLib.BusinessObjects.Model.EditInventoryList.GetEditInventoryList();
webRes.Success = true;
webRes.Data = editInventoryList;
}
catch (Exception e)
{
webRes.ErrorText = e.Message;
}
return(webRes);
}
public Result UpdateInventoryList()
{
Result webRes = new Result(false);
try
{
OETLib.BusinessObjects.Model.EditInventoryList inventorylist = OETLib.BusinessObjects.Model.EditInventoryList.GetEditInventoryList();
webRes.Data = inventorylist;
webRes.Success = true;
}
catch
{
webRes.ErrorText = "There was an error updating the productlist";
}
return(webRes);
}
public static Result DeleteProduct(int productId)
{
Result webres = new Result(false);
try
{
OETLib.BusinessObjects.Model.ProductList productList = OETLib.BusinessObjects.Model.ProductList.GetProductList();
var product = productList.FirstOrDefault(d => d.ProductID == productId);
product.DeleteStatus = true;
productList.Add(product);
productList.Save();
OETLib.BusinessObjects.Model.EditInventoryList editInventoryList = OETLib.BusinessObjects.Model.EditInventoryList.GetEditInventoryList();
webres.Data = editInventoryList;
webres.Success = true;
}
catch (Exception ex)
{
webres.ErrorText = ex.Message;
}
return(webres);
}
public Result SaveInventoryItem(OETLib.BusinessObjects.Model.EditInventory item)
{
Result webRes = new Result(false);
try
{
var inventoryToSave = new OETLib.BusinessObjects.Model.Inventory();
inventoryToSave.ProductID = item.ProductID;
if (item.AddStatus == true)
{
inventoryToSave.InventoryQuantity = item.InventoryAmount;
inventoryToSave.CurrentInventoryQuantity = item.CurrentInventoryQuantity + item.InventoryAmount;
inventoryToSave.InventoryTypeID = 1;
}
else
{
inventoryToSave.InventoryQuantity = -item.InventoryAmount;
inventoryToSave.CurrentInventoryQuantity = item.CurrentInventoryQuantity - item.InventoryAmount;
inventoryToSave.InventoryTypeID = 3;
}
inventoryToSave.InventoryItemCost = item.InventoryItemCost;
inventoryToSave.OrderID = null;
var SavedInventory = inventoryToSave.TrySave(typeof(OETLib.BusinessObjects.Model.InventoryList));
var newInventoryRecord = new OETLib.BusinessObjects.Model.Inventory();
OETLib.BusinessObjects.Model.InventoryList InventoryList = OETLib.BusinessObjects.Model.InventoryList.GetInventoryList();
InventoryList.Add(inventoryToSave);
OETLib.BusinessObjects.Model.EditInventoryList editInventoryList = OETLib.BusinessObjects.Model.EditInventoryList.GetEditInventoryList();
webRes.Success = true;
webRes.Data = editInventoryList;
}
catch (Exception ex)
{
return(new Result {
Success = false, ErrorText = ex.Message
});
}
return(webRes);
}
