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