/// <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; }