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();
}
