public bool Delete(EL.Transactions.PurchaseOrders purchaseOrderEL)
{
return(purchaseOrderDL.Delete(purchaseOrderEL));
}
public bool Received(EL.Transactions.PurchaseOrders purchaseOrderEL)
{
return(purchaseOrderDL.Received(purchaseOrderEL));
}
public bool Canceled(EL.Transactions.PurchaseOrders purchaseOrderEL)
{
return(purchaseOrderDL.Canceled(purchaseOrderEL));
}
public long Insert(EL.Transactions.PurchaseOrders purchaseOrderEL)
{
return(purchaseOrderDL.Insert(purchaseOrderEL));
}
public bool Update(EL.Transactions.PurchaseOrders purchaseOrderEL)
{
return(purchaseOrderDL.Update(purchaseOrderEL));
}
public bool Delete(EL.Transactions.PurchaseOrders purchaseOrder)
{
return(Helper.executeNonQueryBool("delete from purchaseorders where purchaseorderid = " + purchaseOrder.Purchaseorderid + ""));
}
public frmReportPurchaseOrder(BL.Transactions.PurchaseOrderDetails PurchaseOrderDetailBL, EL.Transactions.PurchaseOrders PurchaseOrderInfo)
{
InitializeComponent();
purchaseOrderDetailBL = PurchaseOrderDetailBL;
purchaseOrderInfo = PurchaseOrderInfo;
}
public frmViewPurchaseOrder(frmManagePurchaseOrders _frmManagePurchaseOrders, EL.Transactions.PurchaseOrders _purchaseOrderEL)
{
InitializeComponent();
frmManagePurchaseOrders = _frmManagePurchaseOrders;
purchaseOrderEL = _purchaseOrderEL;
}
public long Insert(EL.Transactions.PurchaseOrders purchaseOrder)
{
return(Helper.executeNonQueryLong("insert into purchaseorders (supplierid, accountid, purchaseordername, purchaseorderrequestdate, purchaseorderdeliverydate, purchaseorderstatus, purchaseordertotalamount) values ('" + purchaseOrder.Supplierid + "', '" + purchaseOrder.Accountid + "', '" + purchaseOrder.Purchaseordername + "', '" + purchaseOrder.Purchaseorderrequestdate + "', '" + purchaseOrder.Purchaseorderdeliverydate + "', '" + purchaseOrder.Purchaseorderstatus + "', '" + purchaseOrder.Purchaseordertotalamount + "')"));
}
public bool Canceled(EL.Transactions.PurchaseOrders purchaseOrderEL)
{
return(Helper.executeNonQueryBool("update purchaseorders set purchaseorderstatus = '" + purchaseOrderEL.Purchaseorderstatus + "' where purchaseorderid = " + purchaseOrderEL.Purchaseorderid + ""));
}
public bool Update(EL.Transactions.PurchaseOrders purchaseOrderEL)
{
return(Helper.executeNonQueryBool("update purchaseorders set purchaseorderamountpaid = '" + purchaseOrderEL.Purchaseorderamountpaid + "' where purchaseorderid = " + purchaseOrderEL.Purchaseorderid + ""));
}
public long Insert(EL.Transactions.PurchaseOrders purchaseOrderEL)
{
return(Helper.executeNonQueryLong("insert into purchaseorders (staffid, purchaseordername, supplierid, paymentmethodid, shippingmethodid, purchaseorderstatus, purchaseorderamountpaid, purchasetotalorderamount, purchaseorderdatereceived, purchaseorderdaterequested, purchaseordercomment) values ('" + purchaseOrderEL.Staffid + "', '" + purchaseOrderEL.Purchaseordername + "', '" + purchaseOrderEL.Supplierid + "', '" + purchaseOrderEL.Paymentmethodid + "', '" + purchaseOrderEL.Shippingmethodid + "', '" + purchaseOrderEL.Purchaseorderstatus + "', '" + purchaseOrderEL.Purchaseorderamountpaid + "', '" + purchaseOrderEL.Purchasetotalorderamount + "', '" + purchaseOrderEL.Purchaseorderdatereceived + "', '" + purchaseOrderEL.Purchaseorderdaterequested + "', '" + purchaseOrderEL.Purchaseordercomment + "')"));
}
public frmViewPurchaseOrder(EL.Transactions.PurchaseOrders PurchaseOrderInfo, frmPurchaseOrders FrmPurchaseOrders)
{
InitializeComponent();
purchaseOrderInfo = PurchaseOrderInfo;
frmPurchaseOrders = FrmPurchaseOrders;
}
public frmCrystalReportViewerPurchaseOrder(EL.Transactions.PurchaseOrders _purchaseOrderEL)
{
InitializeComponent();
purchaseOrderEL = _purchaseOrderEL;
}
