public void AddElement(Country country, CountryUnion countryUnion)
{
DBInterface.CommandText = "select * " +
"from joincountryunion " +
"where joincountryunion.idCountry = @idCountry " +
"and joincountryunion.idCountryUnion = @idCountryUnion;";
DBInterface.AddParameter("@idCountry", MySql.Data.MySqlClient.MySqlDbType.Int32, country.ID);
DBInterface.AddParameter("@idCountryUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, countryUnion.ID);
DataTable tab = DBInterface.ExecuteSelection();
if (tab.Rows.Count == 0)
{
DBInterface.StoredProcedure("join_Country_union_insert");
DBInterface.AddParameter("@inIdCountryUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, countryUnion.ID);
DBInterface.AddParameter("@inIdCountry", MySql.Data.MySqlClient.MySqlDbType.Int32, country.ID);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, "");
DBInterface.AddOutParameter("@outIdJoinCountryUnion", MySql.Data.MySqlClient.MySqlDbType.Int32);
DBInterface.ExecuteTransaction();
}
}
public void AddElement(AviaCompany ac, AviaCompanyUnion acu)
{
DBInterface.CommandText = "select * " +
"from joinaviacompanyunion " +
"where joinaviacompanyunion.idAviaCompany = @idAviaCompany " +
"and joinaviacompanyunion.idAviaCompanyUnion = @idAviaCompanyUnion;";
DBInterface.AddParameter("@idAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, ac.ID);
DBInterface.AddParameter("@idAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, acu.ID);
DataTable tab = DBInterface.ExecuteSelection();
if (tab.Rows.Count == 0)
{
DBInterface.StoredProcedure("join_avia_company_union_insert");
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, acu.ID);
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, ac.ID);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, "");
DBInterface.AddOutParameter("@outIdJoinAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32);
DBInterface.ExecuteTransaction();
}
}
public void Save()
{
if (Changed)
{
if (ID >= 0)
{
DBInterface.StoredProcedure("country_union_update");
DBInterface.AddParameter("@inIdCountryUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
DBInterface.AddParameter("@inUnionName", MySql.Data.MySqlClient.MySqlDbType.String, Name);
DBInterface.AddParameter("@inShortUnionName", MySql.Data.MySqlClient.MySqlDbType.String, ShortName);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Note);
DBInterface.ExecuteTransaction();
if (Updated != null)
{
Updated(this, new DBEventArgs()
{
ForceUpdate = false
});
}
}
else
{
DBInterface.StoredProcedure("country_union_insert");
DBInterface.AddParameter("@inUnionName", MySql.Data.MySqlClient.MySqlDbType.String, Name);
DBInterface.AddParameter("@inShortUnionName", MySql.Data.MySqlClient.MySqlDbType.String, ShortName);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Note);
DBInterface.AddOutParameter("@outIdCountryUnion", MySql.Data.MySqlClient.MySqlDbType.Int32);
DBInterface.ExecuteTransaction();
ID = Convert.ToInt32(DBInterface.GetOutParameter("@outIdCountryUnion"));
if (Updated != null)
{
Updated(this, new DBEventArgs()
{
ForceUpdate = true
});
}
}
Changed = false;
}
}
public void Load()
{
DBInterface.StoredProcedure("avia_company_union_select_by_id");
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
DBInterface.AddOutParameter("@outUnionName", MySql.Data.MySqlClient.MySqlDbType.String);
DBInterface.AddOutParameter("@outUnionShortName", MySql.Data.MySqlClient.MySqlDbType.String);
DBInterface.AddOutParameter("@outNote", MySql.Data.MySqlClient.MySqlDbType.String);
DBInterface.ExecuteTransaction();
Name = Convert.ToString(DBInterface.GetOutParameter("@outUnionName"));
Note = Convert.ToString(DBInterface.GetOutParameter("@outNote"));
Changed = false;
}
public override void Load()
{
DBInterface.StoredProcedure("avia_company_select_by_id");
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
DBInterface.AddOutParameter("@outName", MySql.Data.MySqlClient.MySqlDbType.String);
DBInterface.AddOutParameter("@outShortName", MySql.Data.MySqlClient.MySqlDbType.String);
DBInterface.AddOutParameter("@outNote", MySql.Data.MySqlClient.MySqlDbType.String);
DBInterface.ExecuteTransaction();
FullName = Convert.ToString(DBInterface.GetOutParameter("@outName"));
ICAO = Convert.ToString(DBInterface.GetOutParameter("@outShortName"));
Description = Convert.ToString(DBInterface.GetOutParameter("@outNote"));
aviaCompanyUnionList.Load(this);
mirror = aviaCompanyUnionList.mirror;
Changed = false;
}
public override void Save()
{
if (Changed)
{
if (ID >= 0)
{
DBInterface.StoredProcedure("avia_company_update");
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
DBInterface.AddParameter("@inName", MySql.Data.MySqlClient.MySqlDbType.String, FullName);
DBInterface.AddParameter("@inShortName", MySql.Data.MySqlClient.MySqlDbType.String, ICAO);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Description);
DBInterface.ExecuteTransaction();
RaiseUpdated(false);
}
else
{
DBInterface.StoredProcedure("avia_company_insert");
DBInterface.AddParameter("@inName", MySql.Data.MySqlClient.MySqlDbType.String, FullName);
DBInterface.AddParameter("@inShortName", MySql.Data.MySqlClient.MySqlDbType.String, ICAO);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Description);
DBInterface.AddOutParameter("@outIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32);
DBInterface.ExecuteTransaction();
ID = Convert.ToInt32(DBInterface.GetOutParameter("@outIdAviaCompany"));
RaiseUpdated(true);
}
Changed = false;
}
}
public void Save()
{
if (Changed)
{
int countryID;
int unionID;
GetTargetCountryOrUnion(out countryID, out unionID);
if (ID >= 0)
{
DBInterface.StoredProcedure("visa_update");
DBInterface.AddParameter("@inVisa", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
DBInterface.AddParameter("@inIdPassport", MySql.Data.MySqlClient.MySqlDbType.Int32, PassportID);
DBInterface.AddParameter("@inName", MySql.Data.MySqlClient.MySqlDbType.String, OwnerName);
DBInterface.AddParameter("@inVisaNumber", MySql.Data.MySqlClient.MySqlDbType.String, Number);
DBInterface.AddParameter("@inDateOn", MySql.Data.MySqlClient.MySqlDbType.DateTime, DateApproved);
DBInterface.AddParameter("@indateFrom", MySql.Data.MySqlClient.MySqlDbType.DateTime, ValidFrom);
DBInterface.AddParameter("@inDateUntil", MySql.Data.MySqlClient.MySqlDbType.DateTime, ValidTill);
DBInterface.AddIdParameter("@inIdCountry", countryID);
DBInterface.AddIdParameter("@inIdCountryUnion", unionID);
DBInterface.AddIdParameter("@inIdCountryEsquire", CountryOfEmmitationID);
DBInterface.AddParameter("@inTypeVisa", MySql.Data.MySqlClient.MySqlDbType.String, VizaType);
DBInterface.AddParameter("@inEntriesNumber", MySql.Data.MySqlClient.MySqlDbType.Int32, EntriesNumber);
DBInterface.AddParameter("@inDaysCount", MySql.Data.MySqlClient.MySqlDbType.Int32, DaysCount);
DBInterface.AddParameter("@inUsedDays", MySql.Data.MySqlClient.MySqlDbType.Int32, DaysUsed);
DBInterface.AddParameter("@inIssuedIn", MySql.Data.MySqlClient.MySqlDbType.String, Issued);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Description);
DBInterface.AddParameter("@inIdDocument", MySql.Data.MySqlClient.MySqlDbType.Int32, DBNull.Value);
DBInterface.ExecuteTransaction();
if (Updated != null)
{
Updated(this, new DBEventArgs()
{
ForceUpdate = false
});
}
}
else
{
DBInterface.StoredProcedure("visa_insert");
DBInterface.AddOutParameter("@outIdVisa", MySql.Data.MySqlClient.MySqlDbType.Int32);
DBInterface.AddParameter("@inIdPassport", MySql.Data.MySqlClient.MySqlDbType.Int32, PassportID);
DBInterface.AddParameter("@inName", MySql.Data.MySqlClient.MySqlDbType.String, OwnerName);
DBInterface.AddParameter("@inVisaNumber", MySql.Data.MySqlClient.MySqlDbType.String, Number);
DBInterface.AddParameter("@inDateOn", MySql.Data.MySqlClient.MySqlDbType.DateTime, DateApproved);
DBInterface.AddParameter("@indateFrom", MySql.Data.MySqlClient.MySqlDbType.DateTime, ValidFrom);
DBInterface.AddParameter("@inDateUntil", MySql.Data.MySqlClient.MySqlDbType.DateTime, ValidTill);
DBInterface.AddIdParameter("@inIdCountry", countryID);
DBInterface.AddIdParameter("@inIdCountryUnion", unionID);
DBInterface.AddIdParameter("@inIdCountryEsquire", CountryOfEmmitationID);
DBInterface.AddParameter("@inTypeVisa", MySql.Data.MySqlClient.MySqlDbType.String, VizaType);
DBInterface.AddParameter("@inEntriesNumber", MySql.Data.MySqlClient.MySqlDbType.Int32, EntriesNumber);
DBInterface.AddParameter("@inDaysCount", MySql.Data.MySqlClient.MySqlDbType.Int32, DaysCount);
DBInterface.AddParameter("@inUsedDays", MySql.Data.MySqlClient.MySqlDbType.Int32, DaysUsed);
DBInterface.AddParameter("@inIssuedIn", MySql.Data.MySqlClient.MySqlDbType.String, Issued);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Description);
DBInterface.AddParameter("@inIdDocument", MySql.Data.MySqlClient.MySqlDbType.Int32, DBNull.Value);
DBInterface.ExecuteTransaction();
ID = DBInterface.GetOutParameterInt("@outIdVisa");
if (Updated != null)
{
Updated(this, new DBEventArgs()
{
ForceUpdate = true
});
}
}
Changed = false;
}
}
public void Save()
{
if (Changed)
{
if (ID >= 0)
{
DBInterface.StoredProcedure("mile_card_status_update");
DBInterface.AddParameter("@inIdMileCardStatus", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
DBInterface.AddParameter("@inStatus", MySql.Data.MySqlClient.MySqlDbType.String, Name);
DBInterface.AddParameter("@inMinMiles", MySql.Data.MySqlClient.MySqlDbType.Int32, MinVal);
DBInterface.AddParameter("@inMaxMiles", MySql.Data.MySqlClient.MySqlDbType.Int32, MaxVal);
if (AviaCompanyID < 0)
{
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, AviaCompanyID);
}
if (AviaCompanyUnionID < 0)
{
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, AviaCompanyUnionID);
}
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Note);
DBInterface.ExecuteTransaction();
if (Updated != null)
{
Updated(this, new DBEventArgs()
{
ForceUpdate = false
});
}
}
else
{
DBInterface.StoredProcedure("mile_card_status_insert");
DBInterface.AddParameter("@inStatus", MySql.Data.MySqlClient.MySqlDbType.String, Name);
DBInterface.AddParameter("@inMinMiles", MySql.Data.MySqlClient.MySqlDbType.Int32, MinVal);
DBInterface.AddParameter("@inMaxMiles", MySql.Data.MySqlClient.MySqlDbType.Int32, MaxVal);
if (AviaCompanyID < 0)
{
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, AviaCompanyID);
}
if (AviaCompanyUnionID < 0)
{
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, AviaCompanyUnionID);
}
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Note);
DBInterface.AddOutParameter("@outIdMileCardStatus", MySql.Data.MySqlClient.MySqlDbType.Int32);
DBInterface.ExecuteTransaction();
ID = Convert.ToInt32(DBInterface.GetOutParameter("@outIdMileCardStatus"));
if (Updated != null)
{
Updated(this, new DBEventArgs()
{
ForceUpdate = true
});
}
}
Changed = false;
}
}
public void Save()
{
if (Changed)
{
if (ID >= 0)
{
DBInterface.StoredProcedure("mile_card_update");
DBInterface.AddParameter("@inIdMileCard", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
if (mileCardStatus.ID >= 0)
{
DBInterface.AddParameter("@inIdMileCardStatus", MySql.Data.MySqlClient.MySqlDbType.Int32, mileCardStatus.ID);
}
else
{
DBInterface.AddParameter("@inIdMileCardStatus", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
DBInterface.AddParameter("@inNumber", MySql.Data.MySqlClient.MySqlDbType.String, Number);
DBInterface.AddParameter("@inPassword", MySql.Data.MySqlClient.MySqlDbType.String, Password);
DBInterface.AddParameter("@inMilesCount", MySql.Data.MySqlClient.MySqlDbType.Int32, MilesCount);
if (AviaCompanyID < 0)
{
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, AviaCompanyID);
}
if (AviaCompanyUnionID < 0)
{
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, AviaCompanyUnionID);
}
if (PersonRespondedID < 0)
{
DBInterface.AddParameter("@inIdRespondedPerson", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdRespondedPerson", MySql.Data.MySqlClient.MySqlDbType.Int32, PersonRespondedID);
}
DBInterface.AddParameter("@inIdOwnerPerson", MySql.Data.MySqlClient.MySqlDbType.Int32, personOwner.ID);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Note);
DBInterface.ExecuteTransaction();
if (Updated != null)
{
Updated(this, new DBEventArgs()
{
ForceUpdate = false
});
}
}
else
{
DBInterface.StoredProcedure("mile_card_insert");
if (mileCardStatus.ID >= 0)
{
DBInterface.AddParameter("@inIdMileCardStatus", MySql.Data.MySqlClient.MySqlDbType.Int32, ID);
}
else
{
DBInterface.AddParameter("@inIdMileCardStatus", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
DBInterface.AddParameter("@inNumber", MySql.Data.MySqlClient.MySqlDbType.String, Number);
DBInterface.AddParameter("@inPassword", MySql.Data.MySqlClient.MySqlDbType.String, Password);
DBInterface.AddParameter("@inMilesCount", MySql.Data.MySqlClient.MySqlDbType.Int32, MilesCount);
if (AviaCompanyID < 0)
{
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, AviaCompanyID);
}
if (AviaCompanyUnionID < 0)
{
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, AviaCompanyUnionID);
}
if (PersonRespondedID < 0)
{
DBInterface.AddParameter("@inIdRespondedPerson", MySql.Data.MySqlClient.MySqlDbType.Int32, null);
}
else
{
DBInterface.AddParameter("@inIdRespondedPerson", MySql.Data.MySqlClient.MySqlDbType.Int32, PersonRespondedID);
}
DBInterface.AddParameter("@inIdOwnerPerson", MySql.Data.MySqlClient.MySqlDbType.Int32, personOwner.ID);
DBInterface.AddParameter("@inNote", MySql.Data.MySqlClient.MySqlDbType.String, Note);
DBInterface.AddOutParameter("@outIdMileCard", MySql.Data.MySqlClient.MySqlDbType.Int32);
DBInterface.ExecuteTransaction();
ID = DBInterface.GetOutParameterInt("@outIdMileCard");
if (Updated != null)
{
Updated(this, new DBEventArgs()
{
ForceUpdate = true
});
}
}
Changed = false;
}
}