public static DataView GetOrderAll(int userID)
{
PO purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetOrderAll(userID);
purchaseOrder.LoadFromRawSql(query);
return(purchaseOrder.DefaultView);
}
/// <summary>
/// Get Receiving Order Information
/// </summary>
/// <param name="userID">The user ID.</param>
/// <param name="purchaseOrderTypeID">Type of the purchase.</param>
/// <returns>
/// DataView: ID OrderNumber CompanyName
/// </returns>
public static DataView GetOrderForSelection(int userID, int?purchaseOrderTypeID)
{
var purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetOrderForSelection(userID, purchaseOrderTypeID);
purchaseOrder.LoadFromRawSql(query);
return(purchaseOrder.DefaultView);
}
/// <summary>
/// Alls the order for report.
/// </summary>
/// <returns></returns>
public DataTable AllOrderForReport()
{
PO purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectAllOrderForReport();
purchaseOrder.LoadFromRawSql(query);
return(purchaseOrder.DataTable);
}
///// <summary>
///// Gets PO details for PO.
///// </summary>
///// <param name="ID">The ID.</param>
///// <returns></returns>
//public static DataView GetPurchaseOrderDetailForPO(int ID)
//{
// PO purchaseOrder = new PO();
// var query = HCMIS.Repository.Queries.PurchaseOrderDetail.SelectPurchaseOrderDetailForPO(ID);
// purchaseOrder.LoadFromRawSql(query);
// return purchaseOrder.DefaultView;
//}
/// <summary>
/// Gets the uncomplete invoice ID.
/// </summary>
/// <returns></returns>
public static DataView GetUncompleteInvoiceID()
{
PO purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetUncompleteInvoiceID();
purchaseOrder.LoadFromRawSql(query);
return(purchaseOrder.DefaultView);
}
public bool DoesPOHasDuplicateInvoiceNumbers(int poid, string invoiceNo)
{
var po = new PO();
var query = HCMIS.Repository.Queries.PO.DoesPOHasDuplicateInvoiceNumbers(poid, invoiceNo);
po.LoadFromRawSql(query);
return(po.RowCount != 0);
}
public static bool IsPOEditable(int ID)
{
PO PurchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectIsPOEditable(ID, Settings.DisableInvoiceEditAfterStepNo);
PurchaseOrder.LoadFromRawSql(query);
return(PurchaseOrder.RowCount == 0);
}
public static DataTable GetOrderSummary(int invoiceId)
{
var purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetOrderSummary(invoiceId);
purchaseOrder.LoadFromRawSql(query);
return(purchaseOrder.DataTable);
}
public bool DoesPONumberExists(string poNumber)
{
var po = new PO();
var query = HCMIS.Repository.Queries.PO.DoesPONumberExists(poNumber);
po.LoadFromRawSql(query);
return(po.RowCount != 0);
}
/// <summary>
/// Gets the data table.
/// </summary>
/// <returns></returns>
public System.Data.DataTable GetDataTable()
{
PO purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetDataTable();
purchaseOrder.LoadFromRawSql(query);
return(purchaseOrder.DataTable);
}
public static bool IsPOElectronic(int ID)
{
var purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectIsPOElectronic(ID);
purchaseOrder.LoadFromRawSql(query);
if (purchaseOrder.RowCount == 0)
{
return(false);
}
return((bool)purchaseOrder.GetColumn("IsElectronic"));
}
public static DataView GetOrderAll(int userID)
{
PO purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetOrderAll(userID);
purchaseOrder.LoadFromRawSql(query);
return purchaseOrder.DefaultView;
}
public static DataTable GetOrderSummary(int invoiceId)
{
var purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetOrderSummary(invoiceId);
purchaseOrder.LoadFromRawSql(query);
return purchaseOrder.DataTable;
}
/// <summary>
/// Gets the uncomplete purchase order.
/// </summary>
/// <returns></returns>
public static DataView GetUncompletePurchaseOrder()
{
PO purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetUncompletePurchaseOrder();
purchaseOrder.LoadFromRawSql(query);
return purchaseOrder.DefaultView;
}
/// <summary>
/// Get Receiving Order Information
/// </summary>
/// <param name="userID">The user ID.</param>
/// <param name="purchaseOrderTypeID">Type of the purchase.</param>
/// <returns>
/// DataView: ID OrderNumber CompanyName
/// </returns>
public static DataView GetOrderForSelection(int userID,int? purchaseOrderTypeID)
{
var purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetOrderForSelection(userID,purchaseOrderTypeID);
purchaseOrder.LoadFromRawSql(query);
return purchaseOrder.DefaultView;
}
public static bool IsPOEditable(int ID)
{
PO PurchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectIsPOEditable(ID, Settings.DisableInvoiceEditAfterStepNo);
PurchaseOrder.LoadFromRawSql(query);
return PurchaseOrder.RowCount == 0;
}
/// <summary>
/// Gets the data table.
/// </summary>
/// <returns></returns>
public System.Data.DataTable GetDataTable()
{
PO purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectGetDataTable();
purchaseOrder.LoadFromRawSql(query);
return purchaseOrder.DataTable;
}
public bool DoesPONumberExists(string poNumber)
{
var po = new PO();
var query = HCMIS.Repository.Queries.PO.DoesPONumberExists(poNumber);
po.LoadFromRawSql(query);
return po.RowCount != 0;
}
public bool DoesPOHasDuplicateInvoiceNumbers(int poid,string invoiceNo)
{
var po = new PO();
var query = HCMIS.Repository.Queries.PO.DoesPOHasDuplicateInvoiceNumbers(poid,invoiceNo);
po.LoadFromRawSql(query);
return po.RowCount != 0;
}
/// <summary>
/// Alls the order for report.
/// </summary>
/// <returns></returns>
public DataTable AllOrderForReport()
{
PO purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectAllOrderForReport();
purchaseOrder.LoadFromRawSql(query);
return purchaseOrder.DataTable;
}
public static bool IsPOElectronic(int ID)
{
var purchaseOrder = new PO();
var query = HCMIS.Repository.Queries.PO.SelectIsPOElectronic(ID);
purchaseOrder.LoadFromRawSql(query);
if (purchaseOrder.RowCount == 0) return false;
return (bool)purchaseOrder.GetColumn("IsElectronic");
}
