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 Load(AviaCompany ac) { Clear(); if (ac == null) { return; } DBInterface.CommandText = "select " + "aviacompanyunion.idAviaCompanyUnion, " + "aviacompanyunion.UnionName, " + "aviacompanyunion.note " + "from joinaviacompanyunion " + "left join aviacompanyunion " + "on joinaviacompanyunion.idAviaCompanyUnion = aviacompanyunion.idAviaCompanyUnion " + "where joinaviacompanyunion.idAviaCompany = @idAviaCompany"; DBInterface.AddParameter("@idAviaCompany", MySql.Data.MySqlClient.MySqlDbType.Int32, ac.ID); DataTable tab = DBInterface.ExecuteSelection(); foreach (DataRow row in tab.Rows) { AviaCompanyUnion acu = new AviaCompanyUnion(); acu.ID = Convert.ToInt32(row["idAviaCompanyUnion"]); acu.Name = row["UnionName"].ToString(); acu.Note = row["note"].ToString(); this.Add(acu); } UpdateMirror(); }
public MileCardStatus() { ID = -1; Changed = false; aviacompany = new AviaCompany(); aviacompanyunion = new AviaCompanyUnion(); }
public MileCard(PersonGeneral personOwner) { ID = -1; Changed = false; Silent = false; this.personOwner = personOwner; personResponded = null; aviacompany = new AviaCompany(); aviacompanyunion = new AviaCompanyUnion(); mileCardStatus = new MileCardStatus(); }
public void RemoveElement(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(); foreach (DataRow row in tab.Rows) { DBInterface.StoredProcedure("join_avia_company_union_delete"); DBInterface.AddParameter("@inIdJoinAviaCompanyUnion", MySql.Data.MySqlClient.MySqlDbType.Int32, Convert.ToInt32(row["idJoinAviaCompanyUnion"])); DBInterface.ExecuteTransaction(); } }