public void Delete(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AircraftID", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_AircraftDatum", parameters);
}
//public void LoadByCustClientID(int custClientId)
//{
// List<SqlParameter> parameters = new List<SqlParameter>();
// parameters.Add(new SqlParameter("@CustClientID", custClientId));
// using (
// SqlDataReader reader =
// ExecutionHelper.ExecuteReader("up_Select_ClientNotesByAndCustClientID", parameters))
// {
// if (reader == null)
// return;
// while (reader.Read())
// {
// CustomerNotes note = new CustomerNotes();
// note.SetProperties(reader);
// Add(note);
// }
// }
//}
//public void LoadByClient(Clients client)
//{
// if (client.ClientType == Clients.ClientTypes.Admin)
// {
// LoadByAdminClientID(client.Id);
// }
// else
// {
// LoadByCustClientID(client.Id);
// }
//}
public void Delete(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Id", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_CustomerNote", parameters);
}
public void Delete(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Id", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_SupplierFuelsPrice", parameters);
}
public void DeleteFBODetailCustomField(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Id", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_FBODetailCustomField", parameters);
}
public void Delete(int eventId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@EventID", eventId));
ExecutionHelper.ExecuteNonQuery("up_Delete_CalendarEvents", parameters);
}
public void DeleteCustomerDetail(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@CustClientID", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_CustomerDetail", parameters);
}
public void DeleteInvoice(int Id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Id", Id));
ExecutionHelper.ExecuteNonQuery("up_Delete_FuelOrderInvoice", parameters);
}
public void DeleteInvoicesByFuelOrder(int fuelOrderID)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@FuelOrderID", fuelOrderID));
ExecutionHelper.ExecuteNonQuery("up_Delete_FuelOrderInvoicesByFuelOrderID", parameters);
}
public void Delete(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Id", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_FBODetailVendorExclusion", parameters);
}
public void DeleteAirportPriceMargin(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_AirportPriceMargin", parameters);
}
public void DeletePriceMargin(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Id", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_PriceMargin", parameters);
}
public void DeleteAircraftExclusion(int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@Id", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_AircraftExclusion", parameters);
}
public void DeleteFromDatabase()
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@FuelOrderID", FuelOrderID));
parameters.Add(new SqlParameter("@InvoiceName", InvoiceName));
ExecutionHelper.ExecuteNonQuery("up_Invoices_Delete", parameters);
}
public static void Delete(int clientID, string taxDesc)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ClientID", clientID));
parameters.Add(new SqlParameter("@FeeDesc", taxDesc));
ExecutionHelper.ExecuteNonQuery("up_Delete_ClientFee", parameters);
}
public void Delete(int adminId, int supplierId)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@AdminClientID", adminId));
parameters.Add(new SqlParameter("@SupplierID", supplierId));
ExecutionHelper.ExecuteNonQuery("up_Delete_SupplierFuelsPricesByAndAdminClientIDAndSupplierID", parameters);
}
private static void StoreInDatabase(ArrayList listOfFees, int clientID)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ClientID", clientID));
parameters.Add(new SqlParameter("@CommaDelimtedListOfFees", Degatech.Utilities.Data.Utilities.ArrayListToCommaDelimited(listOfFees)));
ExecutionHelper.ExecuteNonQuery("up_ClientFees_Update", parameters);
}
public static void DeleteAll(int FuelOrderID)
{
List <SqlParameter> Params = new List <SqlParameter>();
SqlParameter Param = new SqlParameter("@FuelOrderID", SqlDbType.Int);
Param.Value = FuelOrderID;
Params.Add(Param);
ExecutionHelper.ExecuteNonQuery("up_Delete_FuelOrderFees", Params);
}
public void DeleteFBOPriceMargin(string icao, string fbo, int clientId, int id)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@ICAO", icao));
parameters.Add(new SqlParameter("@FBO", fbo));
parameters.Add(new SqlParameter("@AdminClientID", clientId));
parameters.Add(new SqlParameter("@Id", id));
ExecutionHelper.ExecuteNonQuery("up_Delete_FBOPriceMargin", parameters);
}
