public List <Requisition> ListReqID(int idEmployee)
{
List <Requisition> reqs = _requisitionDAO.RetrieveRequisitionByEmpId(idEmployee);
/* using (SqlConnection conn = new SqlConnection(connectionString))
* {
*
* conn.Open();
*
* string ch = @"SELECT * From Requisitions Where IdEmployee = " + idEmployee;
*
*
* SqlCommand chh = new SqlCommand(ch, conn);
*
* SqlDataReader readerr = chh.ExecuteReader();
* while (readerr.Read())
* {
* Requisition req = new Requisition()
* {
* IdRequisition = (int)readerr["IdRequisition"],
* IdStatusCurrent = (int)readerr["IdStatusCurrent"],
* RaiseDate = (DateTime)readerr["RaiseDate"],
*
* HeadRemark = (readerr["HeadRemark"] == DBNull.Value) ? string.Empty : (string)readerr["HeadRemark"],
* ApprovedDate = (readerr["ApprovedDate"] == DBNull.Value) ? DateTime.MinValue : (DateTime)readerr["ApprovedDate"],
*
* WithdrawlDate = (readerr["WithdrawlDate"] == DBNull.Value) ? DateTime.MinValue : (DateTime)readerr["WithdrawlDate"],
*
* };
*
*
* reqs.Add(req);
* };
* }*/
return(reqs);
}
