public string Get(int Flight_Number) { try { var data = db.sp_GetSeatsByFlightNo(Flight_Number).FirstOrDefault(); //db.sp_GetSeatsByFlightNo.Flight_Number if (data == null) //When all seats are empty { //throw new Exception("Invalid Flight Number"); return(data); } else { return(data); } } catch (Exception ex) { throw ex; } }