#pragma warning disable 1591
//------------------------------------------------------------------------------
//
// Этот код создан программой.
// Исполняемая версия:4.0.30319.42000
//
// Изменения в этом файле могут привести к неправильной работе и будут потеряны в случае
// повторной генерации кода.
//
//------------------------------------------------------------------------------
namespace WindowsFormsApp1
{
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Data;
using System.Collections.Generic;
using System.Reflection;
using System.Linq;
using System.Linq.Expressions;
using System.ComponentModel;
using System;
[global::System.Data.Linq.Mapping.DatabaseAttribute(Name="aero")]
public partial class DataClasses1DataContext : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
#region Определения метода расширяемости
partial void OnCreated();
partial void InsertCompany(Company instance);
partial void UpdateCompany(Company instance);
partial void DeleteCompany(Company instance);
partial void InsertPass_in_trip(Pass_in_trip instance);
partial void UpdatePass_in_trip(Pass_in_trip instance);
partial void DeletePass_in_trip(Pass_in_trip instance);
partial void InsertTrip(Trip instance);
partial void UpdateTrip(Trip instance);
partial void DeleteTrip(Trip instance);
partial void InsertPassenger(Passenger instance);
partial void UpdatePassenger(Passenger instance);
partial void DeletePassenger(Passenger instance);
partial void InsertUsers(Users instance);
partial void UpdateUsers(Users instance);
partial void DeleteUsers(Users instance);
#endregion
public DataClasses1DataContext() :
base(global::WindowsFormsApp1.Properties.Settings.Default.aeroConnectionString, mappingSource)
{
OnCreated();
}
public DataClasses1DataContext(string connection) :
base(connection, mappingSource)
{
OnCreated();
}
public DataClasses1DataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}
public DataClasses1DataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public DataClasses1DataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public System.Data.Linq.Table Company
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Pass_in_trip
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Trip
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Passenger
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Users
{
get
{
return this.GetTable();
}
}
}
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Company")]
public partial class Company : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID_comp;
private string _name;
private EntitySet _Trip;
#region Определения метода расширяемости
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnID_compChanging(int value);
partial void OnID_compChanged();
partial void OnnameChanging(string value);
partial void OnnameChanged();
#endregion
public Company()
{
this._Trip = new EntitySet(new Action(this.attach_Trip), new Action(this.detach_Trip));
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID_comp", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int ID_comp
{
get
{
return this._ID_comp;
}
set
{
if ((this._ID_comp != value))
{
this.OnID_compChanging(value);
this.SendPropertyChanging();
this._ID_comp = value;
this.SendPropertyChanged("ID_comp");
this.OnID_compChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_name", DbType="Char(10) NOT NULL", CanBeNull=false)]
public string name
{
get
{
return this._name;
}
set
{
if ((this._name != value))
{
this.OnnameChanging(value);
this.SendPropertyChanging();
this._name = value;
this.SendPropertyChanged("name");
this.OnnameChanged();
}
}
}
[global::System.Data.Linq.Mapping.AssociationAttribute(Name="Company_Trip", Storage="_Trip", ThisKey="ID_comp", OtherKey="ID_comp")]
public EntitySet Trip
{
get
{
return this._Trip;
}
set
{
this._Trip.Assign(value);
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
private void attach_Trip(Trip entity)
{
this.SendPropertyChanging();
entity.Company = this;
}
private void detach_Trip(Trip entity)
{
this.SendPropertyChanging();
entity.Company = null;
}
}
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Pass_in_trip")]
public partial class Pass_in_trip : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _trip_no;
private System.DateTime _date;
private int _ID_psg;
private string _place;
private EntityRef _Trip;
private EntityRef _Passenger;
#region Определения метода расширяемости
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void Ontrip_noChanging(int value);
partial void Ontrip_noChanged();
partial void OndateChanging(System.DateTime value);
partial void OndateChanged();
partial void OnID_psgChanging(int value);
partial void OnID_psgChanged();
partial void OnplaceChanging(string value);
partial void OnplaceChanged();
#endregion
public Pass_in_trip()
{
this._Trip = default(EntityRef);
this._Passenger = default(EntityRef);
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_trip_no", DbType="Int NOT NULL", IsPrimaryKey=true)]
public int trip_no
{
get
{
return this._trip_no;
}
set
{
if ((this._trip_no != value))
{
if (this._Trip.HasLoadedOrAssignedValue)
{
throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
}
this.Ontrip_noChanging(value);
this.SendPropertyChanging();
this._trip_no = value;
this.SendPropertyChanged("trip_no");
this.Ontrip_noChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_date", DbType="DateTime NOT NULL", IsPrimaryKey=true)]
public System.DateTime date
{
get
{
return this._date;
}
set
{
if ((this._date != value))
{
this.OndateChanging(value);
this.SendPropertyChanging();
this._date = value;
this.SendPropertyChanged("date");
this.OndateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID_psg", DbType="Int NOT NULL", IsPrimaryKey=true)]
public int ID_psg
{
get
{
return this._ID_psg;
}
set
{
if ((this._ID_psg != value))
{
if (this._Passenger.HasLoadedOrAssignedValue)
{
throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
}
this.OnID_psgChanging(value);
this.SendPropertyChanging();
this._ID_psg = value;
this.SendPropertyChanged("ID_psg");
this.OnID_psgChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_place", DbType="Char(10) NOT NULL", CanBeNull=false)]
public string place
{
get
{
return this._place;
}
set
{
if ((this._place != value))
{
this.OnplaceChanging(value);
this.SendPropertyChanging();
this._place = value;
this.SendPropertyChanged("place");
this.OnplaceChanged();
}
}
}
[global::System.Data.Linq.Mapping.AssociationAttribute(Name="Trip_Pass_in_trip", Storage="_Trip", ThisKey="trip_no", OtherKey="trip_no", IsForeignKey=true)]
public Trip Trip
{
get
{
return this._Trip.Entity;
}
set
{
Trip previousValue = this._Trip.Entity;
if (((previousValue != value)
|| (this._Trip.HasLoadedOrAssignedValue == false)))
{
this.SendPropertyChanging();
if ((previousValue != null))
{
this._Trip.Entity = null;
previousValue.Pass_in_trip.Remove(this);
}
this._Trip.Entity = value;
if ((value != null))
{
value.Pass_in_trip.Add(this);
this._trip_no = value.trip_no;
}
else
{
this._trip_no = default(int);
}
this.SendPropertyChanged("Trip");
}
}
}
[global::System.Data.Linq.Mapping.AssociationAttribute(Name="Passenger_Pass_in_trip", Storage="_Passenger", ThisKey="ID_psg", OtherKey="ID_psg", IsForeignKey=true)]
public Passenger Passenger
{
get
{
return this._Passenger.Entity;
}
set
{
Passenger previousValue = this._Passenger.Entity;
if (((previousValue != value)
|| (this._Passenger.HasLoadedOrAssignedValue == false)))
{
this.SendPropertyChanging();
if ((previousValue != null))
{
this._Passenger.Entity = null;
previousValue.Pass_in_trip.Remove(this);
}
this._Passenger.Entity = value;
if ((value != null))
{
value.Pass_in_trip.Add(this);
this._ID_psg = value.ID_psg;
}
else
{
this._ID_psg = default(int);
}
this.SendPropertyChanged("Passenger");
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Trip")]
public partial class Trip : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _trip_no;
private int _ID_comp;
private string _plane;
private string _town_from;
private string _town_to;
private System.DateTime _time_out;
private System.DateTime _time_in;
private EntitySet _Pass_in_trip;
private EntityRef _Company;
#region Определения метода расширяемости
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void Ontrip_noChanging(int value);
partial void Ontrip_noChanged();
partial void OnID_compChanging(int value);
partial void OnID_compChanged();
partial void OnplaneChanging(string value);
partial void OnplaneChanged();
partial void Ontown_fromChanging(string value);
partial void Ontown_fromChanged();
partial void Ontown_toChanging(string value);
partial void Ontown_toChanged();
partial void Ontime_outChanging(System.DateTime value);
partial void Ontime_outChanged();
partial void Ontime_inChanging(System.DateTime value);
partial void Ontime_inChanged();
#endregion
public Trip()
{
this._Pass_in_trip = new EntitySet(new Action(this.attach_Pass_in_trip), new Action(this.detach_Pass_in_trip));
this._Company = default(EntityRef);
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_trip_no", DbType="Int NOT NULL", IsPrimaryKey=true)]
public int trip_no
{
get
{
return this._trip_no;
}
set
{
if ((this._trip_no != value))
{
this.Ontrip_noChanging(value);
this.SendPropertyChanging();
this._trip_no = value;
this.SendPropertyChanged("trip_no");
this.Ontrip_noChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID_comp", DbType="Int NOT NULL")]
public int ID_comp
{
get
{
return this._ID_comp;
}
set
{
if ((this._ID_comp != value))
{
if (this._Company.HasLoadedOrAssignedValue)
{
throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
}
this.OnID_compChanging(value);
this.SendPropertyChanging();
this._ID_comp = value;
this.SendPropertyChanged("ID_comp");
this.OnID_compChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_plane", DbType="Char(10) NOT NULL", CanBeNull=false)]
public string plane
{
get
{
return this._plane;
}
set
{
if ((this._plane != value))
{
this.OnplaneChanging(value);
this.SendPropertyChanging();
this._plane = value;
this.SendPropertyChanged("plane");
this.OnplaneChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_town_from", DbType="Char(25) NOT NULL", CanBeNull=false)]
public string town_from
{
get
{
return this._town_from;
}
set
{
if ((this._town_from != value))
{
this.Ontown_fromChanging(value);
this.SendPropertyChanging();
this._town_from = value;
this.SendPropertyChanged("town_from");
this.Ontown_fromChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_town_to", DbType="Char(25) NOT NULL", CanBeNull=false)]
public string town_to
{
get
{
return this._town_to;
}
set
{
if ((this._town_to != value))
{
this.Ontown_toChanging(value);
this.SendPropertyChanging();
this._town_to = value;
this.SendPropertyChanged("town_to");
this.Ontown_toChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_time_out", DbType="DateTime NOT NULL")]
public System.DateTime time_out
{
get
{
return this._time_out;
}
set
{
if ((this._time_out != value))
{
this.Ontime_outChanging(value);
this.SendPropertyChanging();
this._time_out = value;
this.SendPropertyChanged("time_out");
this.Ontime_outChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_time_in", DbType="DateTime NOT NULL")]
public System.DateTime time_in
{
get
{
return this._time_in;
}
set
{
if ((this._time_in != value))
{
this.Ontime_inChanging(value);
this.SendPropertyChanging();
this._time_in = value;
this.SendPropertyChanged("time_in");
this.Ontime_inChanged();
}
}
}
[global::System.Data.Linq.Mapping.AssociationAttribute(Name="Trip_Pass_in_trip", Storage="_Pass_in_trip", ThisKey="trip_no", OtherKey="trip_no")]
public EntitySet Pass_in_trip
{
get
{
return this._Pass_in_trip;
}
set
{
this._Pass_in_trip.Assign(value);
}
}
[global::System.Data.Linq.Mapping.AssociationAttribute(Name="Company_Trip", Storage="_Company", ThisKey="ID_comp", OtherKey="ID_comp", IsForeignKey=true)]
public Company Company
{
get
{
return this._Company.Entity;
}
set
{
Company previousValue = this._Company.Entity;
if (((previousValue != value)
|| (this._Company.HasLoadedOrAssignedValue == false)))
{
this.SendPropertyChanging();
if ((previousValue != null))
{
this._Company.Entity = null;
previousValue.Trip.Remove(this);
}
this._Company.Entity = value;
if ((value != null))
{
value.Trip.Add(this);
this._ID_comp = value.ID_comp;
}
else
{
this._ID_comp = default(int);
}
this.SendPropertyChanged("Company");
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
private void attach_Pass_in_trip(Pass_in_trip entity)
{
this.SendPropertyChanging();
entity.Trip = this;
}
private void detach_Pass_in_trip(Pass_in_trip entity)
{
this.SendPropertyChanging();
entity.Trip = null;
}
}
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Passenger")]
public partial class Passenger : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID_psg;
private string _name;
private EntitySet _Pass_in_trip;
#region Определения метода расширяемости
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnID_psgChanging(int value);
partial void OnID_psgChanged();
partial void OnnameChanging(string value);
partial void OnnameChanged();
#endregion
public Passenger()
{
this._Pass_in_trip = new EntitySet(new Action(this.attach_Pass_in_trip), new Action(this.detach_Pass_in_trip));
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID_psg", DbType="Int NOT NULL", IsPrimaryKey=true)]
public int ID_psg
{
get
{
return this._ID_psg;
}
set
{
if ((this._ID_psg != value))
{
this.OnID_psgChanging(value);
this.SendPropertyChanging();
this._ID_psg = value;
this.SendPropertyChanged("ID_psg");
this.OnID_psgChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_name", DbType="Char(20) NOT NULL", CanBeNull=false)]
public string name
{
get
{
return this._name;
}
set
{
if ((this._name != value))
{
this.OnnameChanging(value);
this.SendPropertyChanging();
this._name = value;
this.SendPropertyChanged("name");
this.OnnameChanged();
}
}
}
[global::System.Data.Linq.Mapping.AssociationAttribute(Name="Passenger_Pass_in_trip", Storage="_Pass_in_trip", ThisKey="ID_psg", OtherKey="ID_psg")]
public EntitySet Pass_in_trip
{
get
{
return this._Pass_in_trip;
}
set
{
this._Pass_in_trip.Assign(value);
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
private void attach_Pass_in_trip(Pass_in_trip entity)
{
this.SendPropertyChanging();
entity.Passenger = this;
}
private void detach_Pass_in_trip(Pass_in_trip entity)
{
this.SendPropertyChanging();
entity.Passenger = null;
}
}
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Users")]
public partial class Users : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _id;
private string _Login;
private string _Password;
#region Определения метода расширяемости
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnidChanging(int value);
partial void OnidChanged();
partial void OnLoginChanging(string value);
partial void OnLoginChanged();
partial void OnPasswordChanging(string value);
partial void OnPasswordChanged();
#endregion
public Users()
{
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_id", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int id
{
get
{
return this._id;
}
set
{
if ((this._id != value))
{
this.OnidChanging(value);
this.SendPropertyChanging();
this._id = value;
this.SendPropertyChanged("id");
this.OnidChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Login", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string Login
{
get
{
return this._Login;
}
set
{
if ((this._Login != value))
{
this.OnLoginChanging(value);
this.SendPropertyChanging();
this._Login = value;
this.SendPropertyChanged("Login");
this.OnLoginChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Password", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string Password
{
get
{
return this._Password;
}
set
{
if ((this._Password != value))
{
this.OnPasswordChanging(value);
this.SendPropertyChanging();
this._Password = value;
this.SendPropertyChanged("Password");
this.OnPasswordChanged();
}
}
}
public event PropertyChangingEventHandler PropertyChanging;
public event PropertyChangedEventHandler PropertyChanged;
protected virtual void SendPropertyChanging()
{
if ((this.PropertyChanging != null))
{
this.PropertyChanging(this, emptyChangingEventArgs);
}
}
protected virtual void SendPropertyChanged(String propertyName)
{
if ((this.PropertyChanged != null))
{
this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
}
}
}
}
#pragma warning restore 1591