public classPilot GetPilot(int pilotNum) { classPilot cPilot = null; DataTable dt = new DataTable(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@pilotNum", pilotNum) }; using (DataTable table = SqlDbHelper.ExecuteParamerizedSelectCommand("uspGetPilot", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; cPilot = new classPilot(); cPilot.TotalHours = Convert.ToDouble(row["TotalHours"]); //cPilot.PLicense = row["PIL_LICENSE"].ToString(); //cPilot.Ratings = row["PIL_RATINGS"].ToString(); //cPilot.MedType = Convert.ToChar(row["PIL_MED_TYPE"].ToString()); //cPilot.MedDate = DateTime.Parse(row["PIL_PT135_DATE"].ToString()); } } return(cPilot); }
public List <classPilot> GetPilotDates(DateTime myDate) { List <classPilot> aDate = null; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@currentDate", myDate) }; using (DataTable table = SqlDbHelper.ExecuteParamerizedSelectCommand("uspPilotFlights", CommandType.StoredProcedure, parameters)) { if (table.Rows.Count > 0) { aDate = new List <classPilot>(); foreach (DataRow row in table.Rows) { classPilot cPilot = new classPilot(); cPilot.FullName = row["FullName"].ToString(); aDate.Add(cPilot); } } } return(aDate); }