/// <summary>
/// Create a new PurchaseOrderDetail object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="price">Initial value of the Price property.</param>
/// <param name="qty">Initial value of the Qty property.</param>
public static PurchaseOrderDetail CreatePurchaseOrderDetail(global::System.Int32 id, global::System.Decimal price, global::System.Int32 qty)
{
PurchaseOrderDetail purchaseOrderDetail = new PurchaseOrderDetail();
purchaseOrderDetail.Id = id;
purchaseOrderDetail.Price = price;
purchaseOrderDetail.Qty = qty;
return purchaseOrderDetail;
}
/// <summary>
/// Deprecated Method for adding a new object to the PurchaseOrderDetails EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPurchaseOrderDetails(PurchaseOrderDetail purchaseOrderDetail)
{
base.AddObject("PurchaseOrderDetails", purchaseOrderDetail);
}
/// <summary>
/// Logically delete the PurchaseOrderDetail table by setting the status to 2 in the PurchaseOrderDetail table
/// Return Constants.DB_STATUS
/// </summary>
/// <param name="purchaseOrderDetail"></param>
/// <returns></returns>
public Constants.DB_STATUS Delete(PurchaseOrderDetail purchaseOrderDetail)
{
throw new NotImplementedException();
//Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
//try
//{
// inventory.SaveChanges();
// status = Constants.DB_STATUS.SUCCESSFULL;
//}
//catch (Exception e)
//{
// status = Constants.DB_STATUS.FAILED;
//}
//return status;
}
/// <summary>
/// Update PurchaseOrderDetail data to the PurchaseOrderDetail Table according to the purchaseOrderDetail Parameter
/// Return Constans.DB_STATUS
/// </summary>
/// <param name="purchaseOrderDetail"></param>
/// <returns></returns>
public Constants.DB_STATUS Update(PurchaseOrderDetail purchaseOrderDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
PurchaseOrderDetail purchasedetail = inventory.PurchaseOrderDetails.Where(p => p.Id == purchaseOrderDetail.Id).First();
if(!purchaseorderdetail.Equals(null))
{
purchaseorder = inventory.PurchaseOrders.Where(p => p.Id == purchaseOrderDetail.PurchaseOrder.Id).First();
Item item = inventory.Items.Where(i => i.Id == purchaseOrderDetail.Item.Id).First();
purchasedetail.Id = purchaseOrderDetail.Id;
purchasedetail.PurchaseOrder = purchaseorder;
purchasedetail.Price = purchaseOrderDetail.Price;
purchasedetail.Qty = purchaseOrderDetail.Qty;
purchasedetail.AcceptedQty = purchaseOrderDetail.AcceptedQty;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
/// <summary>
/// Insert PurchaseOrderDetail data to the PurchaseOrderDetail Table according to the newPurchaseOrderDetail Parameter
/// Return Constants.DB_STATUS
/// </summary>
/// <param name="newPurchaseOrderDetail"></param>
/// <returns></returns>
public Constants.DB_STATUS Insert(PurchaseOrderDetail newPurchaseOrderDetail)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
inventory.AddToPurchaseOrderDetails(newPurchaseOrderDetail);
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
/// <summary>
/// Retrieve the PurchaseOrderdetail information from PurchaseOrderDetail Table according to the purchaseOrderDetail Parameter
/// Return PurchaseOrderDetail
/// </summary>
/// <param name="purchaseOrderDetail"></param>
/// <returns></returns>
public PurchaseOrderDetail GetPurchaseOrderDetail(entity.PurchaseOrderDetail purchaseOrderDetail)
{
purchaseorderdetail = inventory.PurchaseOrderDetails.Where(reqObj => reqObj.Id == purchaseorderdetail.Id).First();
if (!purchaseorderdetail.Equals(null))
return purchaseorderdetail;
return null;
}
public Constants.ACTION_STATUS SelectSave(string supplierCode, string deliveryAddress, string attn, DateTime expectedDate)
{
Constants.ACTION_STATUS saveStatus = Constants.ACTION_STATUS.UNKNOWN;
Supplier supplier = new Supplier();
supplier.Id = supplierCode;
supplier = supplierBroker.GetSupplier(supplier);
purchaseOrder.Supplier = supplier;
purchaseOrder.DeliverAddress = deliveryAddress;
purchaseOrder.Attn = attn;
purchaseOrder.ExpectedDate = expectedDate;
PurchaseOrderDetail purchaseOrderDetail;
int addedDetail = 0;
// reorder item
foreach (Item temp in reorderList)
{
item = new Item();
item.Id = temp.Id;
item = itemBroker.GetItem(item);
purchaseOrderDetail = new PurchaseOrderDetail(purchaseOrderBroker.GetPurchaseOrderDetailId() + (addedDetail++), purchaseOrder, item, temp.Cost, temp.ReorderQty, 0);
purchaseOrder.PurchaseOrderDetails.Add(purchaseOrderDetail);
}
// manually added item
foreach (Item item in addedItemList.Keys)
{
purchaseOrderDetail = new PurchaseOrderDetail(purchaseOrderBroker.GetPurchaseOrderDetailId() + (addedDetail++), purchaseOrder, item, (decimal)Converter.objToDouble(addedItemList[item][1]), Converter.objToInt(addedItemList[item][0]), 0);
purchaseOrder.PurchaseOrderDetails.Add(purchaseOrderDetail);
}
if (purchaseOrderBroker.Insert(purchaseOrder) == Constants.DB_STATUS.SUCCESSFULL)
{
saveStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
saveStatus = Constants.ACTION_STATUS.FAIL;
}
return saveStatus;
}