/// <summary>
/// Returns the list of requisitions with the status specified.
/// </summary>
/// <param name="status">The status.</param>
/// <param name="userID">The user ID.</param>
/// <returns></returns>
public static DataTable GetRequisitions(string statuscode, int userID)
{
string orderStatuses = statuscode == "DRFT" ? "'DRFT'" : " 'DRFT','ORFI','APRD','PIKL','PLCN' ";
var query = HCMIS.Repository.Queries.Order.SelectGetRequisitions(userID, orderStatuses);
Order ord = new Order();
ord.LoadFromRawSql(query);
while (!ord.EOF)
{
EthiopianDate.EthiopianDate eth;
ord.SetColumn("DateRequested",
EthiopianDate.EthiopianDate.GregorianToEthiopian(Convert.ToDateTime(ord.GetColumn("EurDate"))));
ord.MoveNext();
}
return ord.DataTable;
}
