public bool InsertFlight(int FID, DateTime schDTFlight, string DTFlight, int Load, int FuelVolume, bool isScheduled, bool isLocal, bool isCharter, string Airplane, string Beneficiary, int Route, string username, string password, bool Telescope, int infants, int childs, int adults)
{
if (authenticate(username, password, 0) == false)
{
return(false);
}
DateTime dtflight;
GetIDTableAdapter u = new GetIDTableAdapter();
int userID = (int)u.GetData(username, password).Rows[0].ItemArray[0];
FlightTableAdapter f = new FlightTableAdapter();
if (DTFlight == null || DTFlight.Length == 0)
{
f.InsertQuery(Load, FuelVolume, FID, schDTFlight, null, isScheduled, isCharter, isLocal, Airplane, Beneficiary, Route, userID, Telescope, infants, childs, adults);
}
else
{
f.InsertQuery(Load, FuelVolume, FID, schDTFlight, Convert.ToDateTime(DTFlight), isScheduled, isCharter, isLocal, Airplane, Beneficiary, Route, userID, Telescope, infants, childs, adults);
}
return(true);
}
public bool DeleteFlight(int Original_ID, string usr, string pass)
{
if (authenticate(usr, pass, 1) == false)
{
return(false);
}
try
{
FlightTableAdapter u = new FlightTableAdapter();
u.DeleteQuery(Original_ID);
}
catch (Exception e) { return(false); }
return(true);
}
public bool UpdateFlight(int FID, DateTime schDTFlight, string DTFlight, int Load, int FuelVolume, bool isScheduled, bool isLocal, bool isCharter, string Airplane, string Beneficiary, int Route, bool Telescope, int infants, int childs, int adults, int Original_ID, string usr, string pass)
{
if (authenticate(usr, pass, 2) == false)
{
return(false);
}
try
{
FlightTableAdapter u = new FlightTableAdapter();
if (DTFlight == null || DTFlight.Length == 0)
{
u.UpdateQuery(Load, FuelVolume, FID, schDTFlight, null, isScheduled, isCharter, isLocal, Airplane, Beneficiary, Route, infants, childs, adults, Telescope, Original_ID);
}
else
{
u.UpdateQuery(Load, FuelVolume, FID, schDTFlight, Convert.ToDateTime(DTFlight), isScheduled, isCharter, isLocal, Airplane, Beneficiary, Route, infants, childs, adults, Telescope, Original_ID);
}
}
catch (Exception e) { return(false); }
return(true);
}
