using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;[System.Data.Linq.Mapping.DatabaseAttribute(Name="SchedulerDB")]
public partial class DataClassesDataContext : System.Data.Linq.DataContext
{private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();#region Extensibility Method Definitions
partial void OnCreated();
partial void InsertSchedulazioni(Schedulazioni instance);
partial void UpdateSchedulazioni(Schedulazioni instance);
partial void DeleteSchedulazioni(Schedulazioni instance);
partial void InsertUser(User instance);
partial void UpdateUser(User instance);
partial void DeleteUser(User instance);
#endregionpublic DataClassesDataContext() :
base(global::System.Configuration.ConfigurationManager.ConnectionStrings["SchedulerDBConnectionString"].ConnectionString, mappingSource)
{
OnCreated();
}public DataClassesDataContext(string connection) :
base(connection, mappingSource)
{
OnCreated();
}public DataClassesDataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}public DataClassesDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}public DataClassesDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}public System.Data.Linq.Table Schedulazionis
{
get
{
return this.GetTable();
}
}public System.Data.Linq.Table Users
{
get
{
return this.GetTable();
}
}
}[Table(Name="dbo.Schedulazioni")]
public partial class Schedulazioni : INotifyPropertyChanging, INotifyPropertyChanged
{private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);private int _IdSchedulazione;private int _IdOwner;private string _NomeSchedulazione;private System.DateTime _StartDate;
private System.DateTime _EndDate;private System.DateTime _NextDate;private int _PatternGiorni;private int _PatternSettimane;private int _PatternMesi;private int _PatternFrequenza;private string _IntestazioneMessaggio;private string _CorpoMessaggio;private System.Xml.Linq.XElement _DestinatarioMessaggio;private System.Data.Linq.Binary _AllegatoMessaggio;private EntityRef _User;#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIdSchedulazioneChanging(int value);
partial void OnIdSchedulazioneChanged();
partial void OnIdOwnerChanging(int value);
partial void OnIdOwnerChanged();
partial void OnNomeSchedulazioneChanging(string value);
partial void OnNomeSchedulazioneChanged();
partial void OnStartDateChanging(System.DateTime value);
partial void OnStartDateChanged();
partial void OnEndDateChanging(System.DateTime value);
partial void OnEndDateChanged();
partial void OnNextDateChanging(System.DateTime value);
partial void OnNextDateChanged();
partial void OnPatternGiorniChanging(int value);
partial void OnPatternGiorniChanged();
partial void OnPatternSettimaneChanging(int value);
partial void OnPatternSettimaneChanged();
partial void OnPatternMesiChanging(int value);
partial void OnPatternMesiChanged();
partial void OnPatternFrequenzaChanging(int value);
partial void OnPatternFrequenzaChanged();
partial void OnIntestazioneMessaggioChanging(string value);
partial void OnIntestazioneMessaggioChanged();
partial void OnCorpoMessaggioChanging(string value);
partial void OnCorpoMessaggioChanged();
partial void OnDestinatarioMessaggioChanging(System.Xml.Linq.XElement value);
partial void OnDestinatarioMessaggioChanged();
partial void OnAllegatoMessaggioChanging(System.Data.Linq.Binary value);
partial void OnAllegatoMessaggioChanged();
#endregionpublic Schedulazioni()
{
this._User = default(EntityRef);
OnCreated();
}
[Column(Storage="_IdSchedulazione", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int IdSchedulazione
{
get
{
return this._IdSchedulazione;
}
set
{
if ((this._IdSchedulazione != value))
{
this.OnIdSchedulazioneChanging(value);
this.SendPropertyChanging();
this._IdSchedulazione = value;
this.SendPropertyChanged(”IdSchedulazione”);
this.OnIdSchedulazioneChanged();
}
}
}
[Column(Storage="_IdOwner", DbType="Int NOT NULL")]
public int IdOwner
{
get
{
return this._IdOwner;
}
set
{
if ((this._IdOwner != value))
{
if (this._User.HasLoadedOrAssignedValue)
{
throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
}
this.OnIdOwnerChanging(value);
this.SendPropertyChanging();
this._IdOwner = value;
this.SendPropertyChanged(”IdOwner”);
this.OnIdOwnerChanged();
}
}
}
[Column(Storage="_NomeSchedulazione", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string NomeSchedulazione
{
get
{
return this._NomeSchedulazione;
}
set
{
if ((this._NomeSchedulazione != value))
{
this.OnNomeSchedulazioneChanging(value);
this.SendPropertyChanging();
this._NomeSchedulazione = value;
this.SendPropertyChanged(”NomeSchedulazione”);
this.OnNomeSchedulazioneChanged();
}
}
}
[Column(Storage="_StartDate", DbType="DateTime NOT NULL")]
public System.DateTime StartDate
{
get
{
return this._StartDate;
}
set
{
if ((this._StartDate != value))
{
this.OnStartDateChanging(value);
this.SendPropertyChanging();
this._StartDate = value;
this.SendPropertyChanged(”StartDate”);
this.OnStartDateChanged();
}
}
}
[Column(Storage="_EndDate", DbType="DateTime NOT NULL")]
public System.DateTime EndDate
{
get
{
return this._EndDate;
}
set
{
if ((this._EndDate != value))
{
this.OnEndDateChanging(value);
this.SendPropertyChanging();
this._EndDate = value;
this.SendPropertyChanged(”EndDate”);
this.OnEndDateChanged();
}
}
}
[Column(Storage="_NextDate", DbType="DateTime NOT NULL")]
public System.DateTime NextDate
{
get
{
return this._NextDate;
}
set
{
if ((this._NextDate != value))
{
this.OnNextDateChanging(value);
this.SendPropertyChanging();
this._NextDate = value;
this.SendPropertyChanged(”NextDate”);
this.OnNextDateChanged();
}
}
}
[Column(Storage="_PatternGiorni", DbType="Int NOT NULL")]
public int PatternGiorni
{
get
{
return this._PatternGiorni;
}
set
{
if ((this._PatternGiorni != value))
{
this.OnPatternGiorniChanging(value);
this.SendPropertyChanging();
this._PatternGiorni = value;
this.SendPropertyChanged(”PatternGiorni”);
this.OnPatternGiorniChanged();
}
}
}
[Column(Storage="_PatternSettimane", DbType="Int NOT NULL")]
public int PatternSettimane
{
get
{
return this._PatternSettimane;
}
set
{
if ((this._PatternSettimane != value))
{
this.OnPatternSettimaneChanging(value);
this.SendPropertyChanging();
this._PatternSettimane = value;
this.SendPropertyChanged(”PatternSettimane”);
this.OnPatternSettimaneChanged();
}
}
}
[Column(Storage="_PatternMesi", DbType="Int NOT NULL")]
public int PatternMesi
{
get
{
return this._PatternMesi;
}
set
{
if ((this._PatternMesi != value))
{
this.OnPatternMesiChanging(value);
this.SendPropertyChanging();
this._PatternMesi = value;
this.SendPropertyChanged(”PatternMesi”);
this.OnPatternMesiChanged();
}
}
}
[Column(Storage="_PatternFrequenza", DbType="Int NOT NULL")]
public int PatternFrequenza
{
get
{
return this._PatternFrequenza;
}
set
{
if ((this._PatternFrequenza != value))
{
this.OnPatternFrequenzaChanging(value);
this.SendPropertyChanging();
this._PatternFrequenza = value;
this.SendPropertyChanged(”PatternFrequenza”);
this.OnPatternFrequenzaChanged();
}
}
}
[Column(Storage="_IntestazioneMessaggio", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string IntestazioneMessaggio
{
get
{
return this._IntestazioneMessaggio;
}
set
{
if ((this._IntestazioneMessaggio != value))
{
this.OnIntestazioneMessaggioChanging(value);
this.SendPropertyChanging();
this._IntestazioneMessaggio = value;
this.SendPropertyChanged(”IntestazioneMessaggio”);
this.OnIntestazioneMessaggioChanged();
}
}
}
[Column(Storage="_CorpoMessaggio", DbType="NVarChar(MAX)")]
public string CorpoMessaggio
{
get
{
return this._CorpoMessaggio;
}
set
{
if ((this._CorpoMessaggio != value))
{
this.OnCorpoMessaggioChanging(value);
this.SendPropertyChanging();
this._CorpoMessaggio = value;
this.SendPropertyChanged(”CorpoMessaggio”);
this.OnCorpoMessaggioChanged();
}
}
}
[Column(Storage="_DestinatarioMessaggio", DbType="Xml NOT NULL", CanBeNull=false, UpdateCheck=UpdateCheck.Never)]
public System.Xml.Linq.XElement DestinatarioMessaggio
{
get
{
return this._DestinatarioMessaggio;
}
set
{
if ((this._DestinatarioMessaggio != value))
{
this.OnDestinatarioMessaggioChanging(value);
this.SendPropertyChanging();
this._DestinatarioMessaggio = value;
this.SendPropertyChanged(”DestinatarioMessaggio”);
this.OnDestinatarioMessaggioChanged();
}
}
}
[Column(Storage="_AllegatoMessaggio", DbType="VarBinary(MAX)", CanBeNull=true, UpdateCheck=UpdateCheck.Never)]
public System.Data.Linq.Binary AllegatoMessaggio
{
get
{
return this._AllegatoMessaggio;
}
set
{
if ((this._AllegatoMessaggio != value))
{
this.OnAllegatoMessaggioChanging(value);
this.SendPropertyChanging();
this._AllegatoMessaggio = value;
this.SendPropertyChanged(”AllegatoMessaggio”);
this.OnAllegatoMessaggioChanged();
}
}
}
[Association(Name="User_Schedulazioni", Storage="_User", ThisKey="IdOwner", IsForeignKey=true)]
public User User
{
get
{
return this._User.Entity;
}
set
{
User previousValue = this._User.Entity;
if (((previousValue != value)
|| (this._User.HasLoadedOrAssignedValue == false)))
{
this.SendPropertyChanging();
if ((previousValue != null))
{
this._User.Entity = null;
previousValue.Schedulazionis.Remove(this);
}
this._User.Entity = value;
if ((value != null))
{
value.Schedulazionis.Add(this);
this._IdOwner = value.IdUser;
}
else
{
this._IdOwner = default(int);
}
this.SendPropertyChanged(”User”);
}
}
}
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));
}
}
}
[Table(Name="dbo.Users")]
public partial class User : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _IdUser;
private string _UserName;
private string _UserPassword;
private EntitySet _Schedulazionis;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIdUserChanging(int value);
partial void OnIdUserChanged();
partial void OnUserNameChanging(string value);
partial void OnUserNameChanged();
partial void OnUserPasswordChanging(string value);
partial void OnUserPasswordChanged();
#endregion
public User()
{
this._Schedulazionis = new EntitySet(new Action(this.attach_Schedulazionis), new Action(this.detach_Schedulazionis));
OnCreated();
}
[Column(Storage="_IdUser", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int IdUser
{
get
{
return this._IdUser;
}
set
{
if ((this._IdUser != value))
{
this.OnIdUserChanging(value);
this.SendPropertyChanging();
this._IdUser = value;
this.SendPropertyChanged(”IdUser”);
this.OnIdUserChanged();
}
}
}
[Column(Storage="_UserName", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string UserName
{
get
{
return this._UserName;
}
set
{
if ((this._UserName != value))
{
this.OnUserNameChanging(value);
this.SendPropertyChanging();
this._UserName = value;
this.SendPropertyChanged(”UserName”);
this.OnUserNameChanged();
}
}
}
[Column(Storage="_UserPassword", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]
public string UserPassword
{
get
{
return this._UserPassword;
}
set
{
if ((this._UserPassword != value))
{
this.OnUserPasswordChanging(value);
this.SendPropertyChanging();
this._UserPassword = value;
this.SendPropertyChanged(”UserPassword”);
this.OnUserPasswordChanged();
}
}
}
[Association(Name="User_Schedulazioni", Storage="_Schedulazionis", OtherKey="IdOwner")]
public EntitySet Schedulazionis
{
get
{
return this._Schedulazionis;
}
set
{
this._Schedulazionis.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_Schedulazionis(Schedulazioni entity)
{
this.SendPropertyChanging();
entity.User = this;
}
private void detach_Schedulazionis(Schedulazioni entity)
{
this.SendPropertyChanging();
entity.User = null;
}
}