public PurchaseOrder(int id, Supplier supplier, string deliverAdd, string attn, DateTime expectedDate, DateTime createdDate, Employee createdBy, DateTime approvedDate, Employee approvedBy, int status, string deliveryOrderNo, DateTime deliveryDate, Employee acceptedBy)
{
this.Id = id;
this.Supplier = supplier;
this.DeliverAddress = deliverAdd;
this.Attn = attn;
this.ExpectedDate = expectedDate;
this.CreatedDate = createdDate;
this.CreatedBy = createdBy;
this.ApprovedDate = approvedDate;
this.ApprovedBy = approvedBy;
this.Status = status;
this.DeliveryOrderNumber = deliveryOrderNo;
this.DeliveryDate = deliveryDate;
this.AcceptedBy = acceptedBy;
}
/// <summary>
/// Logically delete the Supplier by setting the status to 2 in the Supplier table
/// Return Constants.DB_STATUS
/// </summary>
/// <param name="supplier"></param>
/// <returns></returns>
public Constants.DB_STATUS Delete(Supplier supplier)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
supplierObj = inventory.Suppliers.Where(iObj => iObj.Id == supplier.Id).First();
supplierObj.Status = 2;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
/// <summary>
/// Create a new Supplier object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="name">Initial value of the Name property.</param>
/// <param name="priority">Initial value of the Priority property.</param>
/// <param name="contactName">Initial value of the ContactName property.</param>
/// <param name="phoneNumber">Initial value of the PhoneNumber property.</param>
/// <param name="faxNumber">Initial value of the FaxNumber property.</param>
/// <param name="address">Initial value of the Address property.</param>
/// <param name="createdDate">Initial value of the CreatedDate property.</param>
/// <param name="status">Initial value of the Status property.</param>
public static Supplier CreateSupplier(global::System.String id, global::System.String name, global::System.Int32 priority, global::System.String contactName, global::System.String phoneNumber, global::System.String faxNumber, global::System.String address, global::System.DateTime createdDate, global::System.Int32 status)
{
Supplier supplier = new Supplier();
supplier.Id = id;
supplier.Name = name;
supplier.Priority = priority;
supplier.ContactName = contactName;
supplier.PhoneNumber = phoneNumber;
supplier.FaxNumber = faxNumber;
supplier.Address = address;
supplier.CreatedDate = createdDate;
supplier.Status = status;
return supplier;
}
/// <summary>
/// Deprecated Method for adding a new object to the Suppliers EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToSuppliers(Supplier supplier)
{
base.AddObject("Suppliers", supplier);
}
/// <summary>
/// Retrieve the Supplier information according to the Supplier Parameter
/// </summary>
/// <param name="supplier"></param>
/// <returns></returns>
public Supplier GetSupplier(Supplier supplier)
{
supplierObj = inventory.Suppliers.Where(iObj => iObj.Id == supplier.Id).First();
if (!supplierObj.Equals(null))
return supplierObj;
return null;
}
/// <summary>
/// Update Supplier data to the Supplier Table according to the Supplier Parameter
/// Return Constants.DB_STATUS
/// </summary>
/// <param name="supplier"></param>
/// <returns></returns>
public Constants.DB_STATUS Update(Supplier supplier)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
supplierObj = inventory.Suppliers.Where(iObj => iObj.Id == supplier.Id).First();
if (!supplierObj.Equals(null))
{
Employee createdBy = inventory.Employees.Where(e => e.Id == supplier.CreatedBy.Id).First();
supplierObj.Id = supplier.Id;
supplierObj.Name = supplier.Name;
supplierObj.Priority = supplier.Priority;
supplierObj.ContactName = supplier.ContactName;
supplierObj.PhoneNumber = supplier.PhoneNumber;
supplierObj.FaxNumber = supplier.FaxNumber;
supplierObj.Address = supplier.Address;
supplierObj.GstRegistrationNumber = supplier.GstRegistrationNumber;
supplierObj.CreatedDate = supplier.CreatedDate;
supplierObj.CreatedBy = createdBy;
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
/// <summary>
/// Insert Supplier data to the Supplier Table according to the Supplier Parameter
/// Return Constants.DB_STATUS
/// </summary>
/// <param name="newSupplier"></param>
/// <returns></returns>
public Constants.DB_STATUS Insert(Supplier newSupplier)
{
Constants.DB_STATUS status = Constants.DB_STATUS.UNKNOWN;
try
{
Employee employee = inventory.Employees.Where(eObj => eObj.Id == 1).First();
newSupplier.CreatedBy = employee;
inventory.AddToSuppliers(newSupplier);
inventory.SaveChanges();
status = Constants.DB_STATUS.SUCCESSFULL;
}
catch (Exception e)
{
status = Constants.DB_STATUS.FAILED;
}
return status;
}
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;
}
/// <summary>
/// Get the Suppliert List according to the Item
/// </summary>
/// <param name="item"></param>
/// <returns>
/// List of supplier list
/// </returns>
public List<Supplier> GetPrioritySupplier(Item item)
{
try
{
supplierList = new List<Supplier>();
SupplierBroker supplierBroker = new SupplierBroker(this.inventory);
itemPriceList = inventory.ItemPrices.Where(itemPrice => itemPrice.ItemId == item.Id).ToList<ItemPrice>();
Supplier supplier;
foreach (ItemPrice itemPrice in itemPriceList)
{
supplier = new Supplier();
supplier.Id = itemPrice.SupplierId;
supplier = supplierBroker.GetSupplier(supplier);
supplierList.Add(supplier);
}
supplierList.Sort();
}
catch (Exception e)
{
supplierList = null;
}
return supplierList;
}