public void approveOrderByPurchaseOrder(int purchaseorder, int userNo) { try { StoreSupplierDAO.approveOrderByPurchaseOrder(purchaseorder, userNo, findThreeworkingday(DateTime.Now)); } catch (Exception e) { throw new SSexception("approve order failed because order not found :" + e.Message); } }
public List <Supplier> findSupplierByCategory(string cate) { List <Supplier> slist = StoreSupplierDAO.findSupplierByCategory(cate); if (slist == null) { throw new SSexception("supplier not found for this category"); } else { return(slist); } }
public Supplier findSupplierByCode(string suppliercode) { Supplier that = StoreSupplierDAO.findSupplierByCode(suppliercode); if (that == null) { throw new SSexception("supplier not found"); } else { return(that); } }
public void deleteOrderByPurchaseOrder(int purchaseorder, int userNo, string message) { string fromemail = StoreSupplierDAO.findEmployeeByCode(userNo).employeeemail; SOrder po = StoreSupplierDAO.findUnapprovedOrderByPurchaseOrder(purchaseorder); string toemail = po.Employee.employeeemail; try { StoreSupplierDAO.deleteOrderByPurchaseOrder(purchaseorder); } catch (Exception e) { throw new SSexception("delete order failed because order not found :" + e.Message); } sendMailToEmployee(String.Format("Order no. {0} has been rejected. Reason given: {1}", purchaseorder, message), fromemail, toemail); }
public void deleteAdjustmentByVoucherNumber(int vouchernumber, int userNo, string message) { string fromemail = StoreSupplierDAO.findEmployeeByCode(userNo).employeeemail; AdjustmentVoucher av = StoreSupplierDAO.findUnapprovedAdjByVoucherNumber(vouchernumber); string toemail = av.Employee.employeeemail; try { StoreSupplierDAO.deleteAdjustmentByVoucherNumber(vouchernumber); } catch (Exception e) { throw new SSexception("delete adjustment voucher failed because adjustment voucher not found :" + e.Message); } sendMailToEmployee(String.Format("Order no. {0} has been rejected. Reason given: {1}", vouchernumber, message), fromemail, toemail); }
public static void addItemOrder(Item item, int userNo, string suppliercode) { string itemSupplier = item.supplier1; SOrder lastUnconfirmedAuto = StoreSupplierDAO.findLastUnapprovedOrder(userNo, suppliercode); if (lastUnconfirmedAuto.OrderItems.Where(x => x.itemcode == item.itemcode && x.purchaseordernumber == lastUnconfirmedAuto.purchaseordernumber).Count() == 0) { OrderItem oi = new OrderItem(); oi.purchaseordernumber = lastUnconfirmedAuto.purchaseordernumber; oi.itemcode = item.itemcode; oi.orderquantity = item.reorderquantity; oi.cost = StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * item.reorderquantity; ds.OrderItems.Attach(oi); ds.OrderItems.Add(oi); lastUnconfirmedAuto.OrderItems.Add(oi); if (lastUnconfirmedAuto.totalcost == null) { lastUnconfirmedAuto.totalcost = StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * oi.orderquantity; } else { lastUnconfirmedAuto.totalcost = lastUnconfirmedAuto.totalcost + StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * item.reorderquantity; } ds.SaveChanges(); } else { OrderItem oi = lastUnconfirmedAuto.OrderItems.Where(x => x.itemcode == item.itemcode && x.purchaseordernumber == lastUnconfirmedAuto.purchaseordernumber).First(); oi.orderquantity = oi.orderquantity + item.reorderquantity; oi.cost = StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * oi.orderquantity; if (lastUnconfirmedAuto.totalcost == null) { lastUnconfirmedAuto.totalcost = StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * oi.orderquantity; } else { lastUnconfirmedAuto.totalcost = lastUnconfirmedAuto.totalcost + StoreSupplierDAO.findTenderQuotation(itemSupplier, item.itemcode) * item.reorderquantity; } ds.SaveChanges(); } }
public void approveAdjustmentByVoucherNumber(int vouchernumber, int userNo) { try { AdjustmentVoucher av = StoreSupplierDAO.findUnapprovedAdjByVoucherNumber(vouchernumber); foreach (AdjustmentItem i in av.AdjustmentItems) { i.Item.quantityonhand = i.Item.quantityonhand + i.quantity; if (i.Item.quantityonhand < i.Item.reorderlevel && !StoreSupplierDAO.hasUndeliveredOrders(i.itemcode)) { raiseReorder(i.Item, 1031); } } StoreSupplierDAO.approveAdjVoucher(vouchernumber, userNo); } catch (Exception e) { throw new SSexception("approve adjustment voucher failed because adjustment voucher not found :" + e.Message); } }
public void raiseReorder(Item item, int userNo) { StoreSupplierDAO.addItemOrder(item, userNo, item.supplier1); }
public SS.CryDataSet setRequisitionDataSet(string que) { return(StoreSupplierDAO.setRequisitionDataSet(que)); }
public SS.CryDataSet setReorderDataSet(string que) { return(StoreSupplierDAO.setReorderDataSet(que)); }
public static void raiseReorder(Item item, int userNo) { string itemSupplier = item.supplier1; StoreSupplierDAO.addItemOrder(item, userNo, itemSupplier); }
public List <AdjustmentVoucher> findUnapprovedVouchers() { List <AdjustmentVoucher> alist = StoreSupplierDAO.findUnapprovedVouchers(); return(alist); }
public List <SOrder> findUnapprovedOrders() { List <SOrder> olist = StoreSupplierDAO.findUnapprovedOrders(); return(olist); }
protected void refreshGV2() { adjs = StoreSupplierDAO.findUnapprovedVouchers(); GridView2.DataSource = adjs; GridView2.DataBind(); }