public PurchaseOrderControl()
{
currentEmployee = Util.ValidateUser(Constants.EMPLOYEE_ROLE.STORE_CLERK);
InventoryEntities inventory = new InventoryEntities();
supplierBroker = new SupplierBroker(inventory);
itemBroker = new ItemBroker(inventory);
purchaseOrderBroker = new PurchaseOrderBroker(inventory);
itemPriceBroker = new ItemPriceBroker(inventory);
employeeBroker = new EmployeeBroker(inventory);
//reorderList = GetReorderItemList();
purchaseOrder = new PurchaseOrder();
purchaseOrder.Id = purchaseOrderBroker.GetPurchaseOrderId();
purchaseOrder.CreatedBy = Util.GetEmployee(employeeBroker);
purchaseOrder.CreatedDate = DateTime.Now;
purchaseOrder.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
poDetailList = new List<PurchaseOrderDetail>();
addedItemList = new Dictionary<Item, List<double>>();
//purchaseOrderDetailList = new System.Data.Objects.DataClasses.EntityCollection<PurchaseOrderDetail>();
// need to load reorder quantity
// need to load unfulfilled quantity
supplierColumn = new DataColumn[] { new DataColumn(supplierColumnName[0]), new DataColumn(supplierColumnName[1])};
dataColumn = new DataColumn[] { new DataColumn(columnName[0]),
new DataColumn(columnName[1]),
new DataColumn(columnName[2]),
new DataColumn(columnName[3]),
new DataColumn(columnName[4])};
}
public PurchaseOrderDetail(int id, PurchaseOrder purchaseid, Item itemId, decimal price, int qty, int acceptedQty)
{
this.Id = id;
this.PurchaseOrder = purchaseid;
// this.ItemId = itemId;
this.Item = itemId;
this.Price = price;
this.Qty = qty;
this.AcceptedQty = acceptedQty;
}
/// <summary>
/// Retrieve the PurchaseOrder information from PurchaseOrder Table according to the purchaseOrder Parameter
/// Return purchaseorder
/// </summary>
/// <param name="purchaseOrder"></param>
/// <returns></returns>
public PurchaseOrder GetPurchaseOrder(PurchaseOrder purchaseOrder)
{
//int showStatus = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
try
{
purchaseorder = inventory.PurchaseOrders.Where(purchaseOrderObj => purchaseOrderObj.Id == purchaseOrder.Id).First();
if (!purchaseorder.Equals(null))
{
var purchaseOrderDetailsResult = from rd in inventory.PurchaseOrderDetails
where rd.PurchaseOrder.Id == purchaseorder.Id
select rd;
foreach (PurchaseOrderDetail rd in purchaseOrderDetailsResult)
{
purchaseorder.PurchaseOrderDetails.Add(rd);
}
}
return purchaseorder;
}
catch (Exception e)
{
return null;
}
}
/// <summary>
/// Deprecated Method for adding a new object to the PurchaseOrders EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPurchaseOrders(PurchaseOrder purchaseOrder)
{
base.AddObject("PurchaseOrders", purchaseOrder);
}
/// <summary>
/// Create a new PurchaseOrder object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="deliverAddress">Initial value of the DeliverAddress property.</param>
/// <param name="attn">Initial value of the Attn property.</param>
/// <param name="expectedDate">Initial value of the ExpectedDate property.</param>
/// <param name="createdDate">Initial value of the CreatedDate property.</param>
/// <param name="status">Initial value of the Status property.</param>
public static PurchaseOrder CreatePurchaseOrder(global::System.Int32 id, global::System.String deliverAddress, global::System.String attn, global::System.DateTime expectedDate, global::System.DateTime createdDate, global::System.Int32 status)
{
PurchaseOrder purchaseOrder = new PurchaseOrder();
purchaseOrder.Id = id;
purchaseOrder.DeliverAddress = deliverAddress;
purchaseOrder.Attn = attn;
purchaseOrder.ExpectedDate = expectedDate;
purchaseOrder.CreatedDate = createdDate;
purchaseOrder.Status = status;
return purchaseOrder;
}
/// <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>
/// Logically delete the PurchaseOrder table by setting the status to 2 in the PurchaseOrder table
/// Return Constants.DB_STATUS
/// </summary>
/// <param name="purchaseOrder"></param>i
/// <returns></returns>
public Constants.DB_STATUS Delete(PurchaseOrder purchaseOrder)
{
// throw new NotImplementedException();
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
purchaseorder = inventory.PurchaseOrders.Where(p => p.Id == purchaseorder.Id).First();
purchaseorder.Status = 2;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
/// <summary>
/// Update PurchaseOrder data to the PurchaseOrder Table according to the purchaseOrder Parameter
/// Return Constans.DB_STATUS
/// </summary>
/// <param name="purchaseOrder"></param>
/// <returns></returns>
public Constants.DB_STATUS Update(PurchaseOrder purchaseOrder)
{
// throw new NotImplementedException();
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
//foreach (PurchaseOrderDetail purchaseOrderDetail in purchaseOrder.PurchaseOrderDetails)
//{
// this.Update(purchaseOrderDetail);
//}
//inventory.SaveChanges();
//status = Constants.DB_STATUS.SUCCESSFULL;
purchaseorder = inventory.PurchaseOrders.Where(iObj => iObj.Id == purchaseOrder.Id).First();
Supplier supplierId = inventory.Suppliers.Where(s => s.Id == purchaseorder.Supplier.Id).First();
// purchaseorder.Supplier.Id = purchaseOrder.Supplier.Id;
purchaseorder.Supplier = supplierId;
purchaseorder.DeliverAddress = purchaseOrder.DeliverAddress;
purchaseorder.Attn = purchaseOrder.Attn;
purchaseorder.ExpectedDate = purchaseOrder.ExpectedDate;
purchaseorder.CreatedDate = purchaseOrder.CreatedDate;
purchaseorder.ApprovedDate = purchaseOrder.ApprovedDate;
purchaseorder.Status = purchaseOrder.Status;
// supplierObj.CreatedDate = supplier.CreatedDate;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
/// <summary>
/// Insert PurchaseOrder data to the PurchaseOrder Table according to the newPurchaseOrder Parameter
/// Return Constants.DB_STATUS
/// </summary>
/// <param name="newPurchaseOrder"></param>
/// <returns></returns>
public Constants.DB_STATUS Insert(PurchaseOrder newPurchaseOrder)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
inventory.AddToPurchaseOrders(newPurchaseOrder);
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
public Constants.ACTION_STATUS SelectAllPurchaseOrderDetails(int index)
{
Constants.ACTION_STATUS selectStatus = Constants.ACTION_STATUS.UNKNOWN;
if (purchaseOrderList.Count >= index)
{
purchaseOrder = purchaseOrderList.ElementAt(index - 1);
selectStatus = Constants.ACTION_STATUS.SUCCESS;
}
else
{
selectStatus = Constants.ACTION_STATUS.FAIL;
}
return selectStatus;
}
public DataTable GetPurchaseOrderDetail(int purchaseOrderNumber)
{
PurchaseOrder purchaseOrder = new PurchaseOrder();
purchaseOrder.Id = purchaseOrderNumber;
purchaseOrder = purchaseOrderBroker.GetPurchaseOrder(purchaseOrder);
List<PurchaseOrderDetail> list = purchaseOrder.PurchaseOrderDetails.ToList();
if (dtt == null)
{
dtt = new DataTable();
dtt.Columns.AddRange(detailColumn);
}
else
{
dtt.Rows.Clear();
}
DataRow drr;
foreach (PurchaseOrderDetail temp in list)
{
drr = dtt.NewRow();
drr[detail[0]] = temp.Item.Id;
drr[detail[1]] = temp.Item.Description;
drr[detail[2]] = temp.Qty;
//drr[detail[3]] = "remark";
dtt.Rows.Add(drr);
}
return dtt;
}
public string[] GetLabelData(int purchaseOrderId)
{
string[] labels = new string[2];
PurchaseOrder po = new PurchaseOrder();
po.Id = purchaseOrderId;
po = purchaseOrderBroker.GetPurchaseOrder(po);
labels[0] = po.Supplier.Name;
labels[1] = SystemStoreInventorySystemUtil.Converter.dateTimeToString(Converter.DATE_CONVERTER.DATE, po.ExpectedDate);
return labels;
}
public Constants.ACTION_STATUS ClickReceived(DataTable dt, string deliveryNo, string poNumber)
{
Constants.ACTION_STATUS status = Constants.ACTION_STATUS.UNKNOWN;
string itemNo, itemDesc, quantity, remark;
PurchaseOrder po = new PurchaseOrder();
po.Id = Converter.objToInt(poNumber);
po = purchaseOrderBroker.GetPurchaseOrder(po);
po.DeliveryOrderNumber = deliveryNo;
po.DeliveryDate = DateTime.Now;
po.AcceptedBy = Util.GetEmployee(employeeBroker);
List<PurchaseOrderDetail> poDetailList = po.PurchaseOrderDetails.ToList();
foreach (DataRow dr in dt.Rows)
{
itemNo = dr[detail[0]].ToString();
itemDesc = dr[detail[1]].ToString();
quantity = dr[detail[2]].ToString();
remark = dr[detail[3]].ToString();
foreach (PurchaseOrderDetail poDetail in poDetailList)
{
if(poDetail.Item.Id.Equals(itemNo)){
poDetail.AcceptedQty = Converter.objToInt(quantity);
Item item = poDetail.Item;
item.Cost = poDetail.Price;
itemBroker.Update(item);
StockCardDetail stockCardDetail = new StockCardDetail();
stockCardDetail.Item = item;
stockCardDetail.Description = "Supplier-" + po.Supplier.Id;
stockCardDetail.Qty = Converter.objToInt(quantity);
stockCardDetail.CreatedDate = DateTime.Now;
stockCardDetail.CreatedBy = Util.GetEmployee(employeeBroker);
stockCardDetail.Status = Converter.objToInt(Constants.VISIBILITY_STATUS.SHOW);
//List<StockCardDetail> stockCardDetailList = itemBroker.GetAllStockCardDetail().ToList();
//List<StockCardDetail> newList = new List<StockCardDetail>();
//foreach(StockCardDetail scd in stockCardDetailList){
// if(scd.Item.Id.Equals(item.Id)){
// newList.Add(scd);
// }
//}
//StockCardDetail scDetail = newList.Last<StockCardDetail>();
stockCardDetail.Balance = itemBroker.GetCurrentBalance(item) + Converter.objToInt(quantity);
stockCardDetail.Id = itemBroker.GetStockCardDetailId();
itemBroker.Insert(stockCardDetail);
// add remark later
}
}
}
Constants.DB_STATUS dbStatus = purchaseOrderBroker.Update(po);
if(dbStatus == Constants.DB_STATUS.SUCCESSFULL)
status = Constants.ACTION_STATUS.SUCCESS;
else
status = Constants.ACTION_STATUS.FAIL;
return status;
}
public void GetReorderItem(ref PurchaseOrder purchaseOrder)
{
//dataset.ReorderLevelDataSet ds = new dataset.ReorderLevelDataSet();
//dataset.ReorderLevelDataSetTableAdapters.DataTable1TableAdapter da = new dataset.ReorderLevelDataSetTableAdapters.DataTable1TableAdapter();
// dataset.ReorderLevelDataSetTableAdapters.TableAdapterManager tam = new dataset.ReorderLevelDataSetTableAdapters.TableAdapterManager();
//reorderLevelDataAdapter.Fill(ds);
//return da.GetData();
}
