public List <FlightDetailsModel> getAllDetails(int fid)
{
cmdFetchDetails = new SqlCommand("proc_flightDetails", conn);
cmdFetchDetails.Parameters.Add("@fd_id", SqlDbType.Int);
cmdFetchDetails.CommandType = CommandType.StoredProcedure;
List <FlightDetailsModel> details = new List <FlightDetailsModel>();
conn.Open();
cmdFetchDetails.Parameters[0].Value = fid;
SqlDataReader drUsers = cmdFetchDetails.ExecuteReader();
FlightDetailsModel detail = null;
while (drUsers.Read())
{
detail = new FlightDetailsModel();
detail.Fd_id = drUsers[0].ToString();
detail.Ft_id = drUsers[1].ToString();
detail.Source_id = drUsers[2].ToString();
detail.Destination_id = drUsers[3].ToString();
detail.Departure = drUsers[4].ToString();
detail.Arrival = drUsers[5].ToString();
detail.Dateid = drUsers[6].ToString();
detail.Duration = drUsers[7].ToString();
detail.Fare = drUsers[8].ToString();
details.Add(detail);
}
conn.Close();
return(details);
}
public async Task <FlightDetailsModel> GetFlightDetails(GetFlightDetailsRequest request)
{
var flightTime = new Random().Next(2, 10);
var arrivalDate = request.DepartueDate.AddHours(12 + flightTime);
var deepLink = $@"https://bookerproxy.lot.com/service.php?COUNTRY_CODE=PL&LANGUAGE_CODE=PL&ORIGIN={request.OriginCode}&DESTINATION={request.DestinationCode}&DEPARTURE_DATE={request.DepartueDate.ToLotFormat()}&ARRIVAL_DATE={arrivalDate.ToLotFormat()}&ADULT_COUNT={request.NumberOfAdults}&CHILD_COUNT=0&INFANT_COUNT=0&PARTNER=TFFNZEZK88W4&CLASS=E&utm_source=github&utm_medium=api";
var data = await GetMockData <IEnumerable <FlightModel> >("flights");
var flight = data.FirstOrDefault(a => a.DestinationCode == request.DestinationCode && a.OriginCode == request.OriginCode);
if (flight == null)
{
throw new Exception("Invalid flight data!");
}
var result = new FlightDetailsModel()
{
DepartueDate = request.DepartueDate.AddHours(12),
DeepLink = deepLink,
LocalArrivalDate = arrivalDate,
DepartuePlaneSeats = GeneratePlaneSeats(),
ReturnPlaneSeats = request.ReturnDate.HasValue ? GeneratePlaneSeats() : null,
ReturnDate = request.ReturnDate,
ArrivalReturnDate = request.ReturnDate.HasValue ? request.ReturnDate.Value.AddHours(flightTime) : (DateTime?)null,
PlaneName = "Dreamliner",
TotalPrice = flight.MinPrice * request.NumberOfAdults
};
return(result);
}
// GET: api/Admin/5
//public IEnumerable<FlightDetailsModel> Get()
//{
// // return "value";
//}
// POST: api/Admin
public void Post([FromBody] FlightDetailsModel value)
{
string s = "";
string s2 = "D0";
int n = value.Dateid.Length;
s = value.Dateid.Substring(8, 2);
s = s2 + s;
bl.Insert(value.Ft_id, value.Source_id, value.Destination_id, value.Departure, value.Arrival, s, value.Duration, value.Fare);
}
public bool updatedetails(string id, [FromBody] FlightDetailsModel flight)
{
bool s = false;
var user = (from u in details
where u.Fd_id == id
select u).First();
if (bl.UpdateDetail(id, flight))
{
s = true;
}
else
{
s = false;
}
return(s);
}
public bool Post([FromBody] FlightDetailsModel value)
{
string s = "";
string s2 = "D0";
int n = value.Dateid.Length;
s = value.Dateid.Substring(8, 2);
s = s2 + s;
try {
return(bl.Insert(value.Ft_id, value.Source_id, value.Destination_id, value.Departure, value.Arrival, s, value.Duration, value.Fare));
}
catch (Exception e)
{
return(false);
}
}
public bool update_detail(string id, FlightDetailsModel fl)
{
bool updatestatus = false;
cmdUpdatePass = new SqlCommand("proc_updateflightdetails", conn);
cmdUpdatePass.CommandType = CommandType.StoredProcedure;
cmdUpdatePass.Parameters.AddWithValue("@fd_id", id);
cmdUpdatePass.Parameters.AddWithValue("@dep_time", fl.Departure);
cmdUpdatePass.Parameters.AddWithValue("@arr_time", fl.Arrival);
cmdUpdatePass.Parameters.AddWithValue("@date_id", fl.Dateid);
cmdUpdatePass.Parameters.AddWithValue("@duration", fl.Duration);
cmdUpdatePass.Parameters.AddWithValue("@fare", fl.Fare);
conn.Open();
if ((cmdUpdatePass.ExecuteNonQuery() > 0))
{
updatestatus = true;
}
return(updatestatus);
}
public bool UpdateDetail(string id, FlightDetailsModel flight)
{
return(dal.update_detail(id, flight));
}
