Thank you Terry for your response. LINQ code is as following:
#pragma warning disable 1591
//------------------------------------------------------------------------------
//
// This code was generated by a tool.
// Runtime Version:4.0.30319.18052
//
// Changes to this file may cause incorrect behavior and will be lost if
// the code is regenerated.
//
//------------------------------------------------------------------------------
namespace PIMS
{
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="PIMS")]
public partial class FastnFuriousDataContext : System.Data.Linq.DataContext
{
private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();
#region Extensibility Method Definitions
partial void OnCreated();
partial void InsertDocument(Document instance);
partial void UpdateDocument(Document instance);
partial void DeleteDocument(Document instance);
partial void InsertDwg_Register(Dwg_Register instance);
partial void UpdateDwg_Register(Dwg_Register instance);
partial void DeleteDwg_Register(Dwg_Register instance);
partial void InsertDiary(Diary instance);
partial void UpdateDiary(Diary instance);
partial void DeleteDiary(Diary instance);
partial void InsertIssue(Issue instance);
partial void UpdateIssue(Issue instance);
partial void DeleteIssue(Issue instance);
partial void InsertPayment(Payment instance);
partial void UpdatePayment(Payment instance);
partial void DeletePayment(Payment instance);
partial void InsertRisk_Register(Risk_Register instance);
partial void UpdateRisk_Register(Risk_Register instance);
partial void DeleteRisk_Register(Risk_Register instance);
partial void InsertTask(Task instance);
partial void UpdateTask(Task instance);
partial void DeleteTask(Task instance);
partial void InsertUnit_Rate(Unit_Rate instance);
partial void UpdateUnit_Rate(Unit_Rate instance);
partial void DeleteUnit_Rate(Unit_Rate instance);
partial void InsertCost(Cost instance);
partial void UpdateCost(Cost instance);
partial void DeleteCost(Cost instance);
#endregion
public FastnFuriousDataContext() :
base(global::System.Configuration.ConfigurationManager.ConnectionStrings["PIMSConnectionString"].ConnectionString, mappingSource)
{
OnCreated();
}
public FastnFuriousDataContext(string connection) :
base(connection, mappingSource)
{
OnCreated();
}
public FastnFuriousDataContext(System.Data.IDbConnection connection) :
base(connection, mappingSource)
{
OnCreated();
}
public FastnFuriousDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public FastnFuriousDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) :
base(connection, mappingSource)
{
OnCreated();
}
public System.Data.Linq.Table Documents
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Dwg_Registers
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Diaries
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Issues
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Payments
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Risk_Registers
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Tasks
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Unit_Rates
{
get
{
return this.GetTable();
}
}
public System.Data.Linq.Table Costs
{
get
{
return this.GetTable();
}
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.spGetUser")]
public ISingleResult spGetUser()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.DwgRegisterGetUser")]
public ISingleResult DwgRegisterGetUser()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.DiaryGetUser")]
public ISingleResult DiaryGetUser()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.IssuesGetUser")]
public ISingleResult IssuesGetUser()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.PaymentsGetUser")]
public ISingleResult PaymentsGetUser()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.RiskRegisterGetUser")]
public ISingleResult RiskRegisterGetUser()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.TasksGetUsers")]
public ISingleResult TasksGetUsers()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.UnitRatesGetUsers")]
public ISingleResult UnitRatesGetUsers()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
[global::System.Data.Linq.Mapping.FunctionAttribute(Name="dbo.CostGetUser")]
public ISingleResult CostGetUser()
{
IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())));
return ((ISingleResult)(result.ReturnValue));
}
}
[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.Documents")]
public partial class Document : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _DocumentsID;
private string _Ref;
private string _Subject;
private string _Src;
private string _Dst;
private string _Medium;
private System.Nullable _Date_Printed;
private System.Nullable _Date_Received;
private string _Document_Type;
private bool _Action_Required;
private System.Nullable _Due_Date;
private System.Nullable _Actual_Date;
private string _Content;
private string _Tag;
private System.Nullable _Issue_No;
private string _Attachment;
private string _Notes;
private string _Assigned_To;
private string _Reply_Ref;
private string _Priority;
private string _Status;
private string _Response;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnDocumentsIDChanging(int value);
partial void OnDocumentsIDChanged();
partial void OnRefChanging(string value);
partial void OnRefChanged();
partial void OnSubjectChanging(string value);
partial void OnSubjectChanged();
partial void OnSrcChanging(string value);
partial void OnSrcChanged();
partial void OnDstChanging(string value);
partial void OnDstChanged();
partial void OnMediumChanging(string value);
partial void OnMediumChanged();
partial void OnDate_PrintedChanging(System.Nullable value);
partial void OnDate_PrintedChanged();
partial void OnDate_ReceivedChanging(System.Nullable value);
partial void OnDate_ReceivedChanged();
partial void OnDocument_TypeChanging(string value);
partial void OnDocument_TypeChanged();
partial void OnAction_RequiredChanging(bool value);
partial void OnAction_RequiredChanged();
partial void OnDue_DateChanging(System.Nullable value);
partial void OnDue_DateChanged();
partial void OnActual_DateChanging(System.Nullable value);
partial void OnActual_DateChanged();
partial void OnContentChanging(string value);
partial void OnContentChanged();
partial void OnTagChanging(string value);
partial void OnTagChanged();
partial void OnIssue_NoChanging(System.Nullable value);
partial void OnIssue_NoChanged();
partial void OnAttachmentChanging(string value);
partial void OnAttachmentChanged();
partial void OnNotesChanging(string value);
partial void OnNotesChanged();
partial void OnAssigned_ToChanging(string value);
partial void OnAssigned_ToChanged();
partial void OnReply_RefChanging(string value);
partial void OnReply_RefChanged();
partial void OnPriorityChanging(string value);
partial void OnPriorityChanged();
partial void OnStatusChanging(string value);
partial void OnStatusChanged();
partial void OnResponseChanging(string value);
partial void OnResponseChanged();
#endregion
public Document()
{
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_DocumentsID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int DocumentsID
{
get
{
return this._DocumentsID;
}
set
{
if ((this._DocumentsID != value))
{
this.OnDocumentsIDChanging(value);
this.SendPropertyChanging();
this._DocumentsID = value;
this.SendPropertyChanged("DocumentsID");
this.OnDocumentsIDChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Ref", DbType="NVarChar(25)")]
public string Ref
{
get
{
return this._Ref;
}
set
{
if ((this._Ref != value))
{
this.OnRefChanging(value);
this.SendPropertyChanging();
this._Ref = value;
this.SendPropertyChanged("Ref");
this.OnRefChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Subject", DbType="NVarChar(255)")]
public string Subject
{
get
{
return this._Subject;
}
set
{
if ((this._Subject != value))
{
this.OnSubjectChanging(value);
this.SendPropertyChanging();
this._Subject = value;
this.SendPropertyChanged("Subject");
this.OnSubjectChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Src", DbType="NVarChar(255)")]
public string Src
{
get
{
return this._Src;
}
set
{
if ((this._Src != value))
{
this.OnSrcChanging(value);
this.SendPropertyChanging();
this._Src = value;
this.SendPropertyChanged("Src");
this.OnSrcChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Dst", DbType="NVarChar(255)")]
public string Dst
{
get
{
return this._Dst;
}
set
{
if ((this._Dst != value))
{
this.OnDstChanging(value);
this.SendPropertyChanging();
this._Dst = value;
this.SendPropertyChanged("Dst");
this.OnDstChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Medium", DbType="NVarChar(255)")]
public string Medium
{
get
{
return this._Medium;
}
set
{
if ((this._Medium != value))
{
this.OnMediumChanging(value);
this.SendPropertyChanging();
this._Medium = value;
this.SendPropertyChanged("Medium");
this.OnMediumChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Printed", DbType="DateTime")]
public System.Nullable Date_Printed
{
get
{
return this._Date_Printed;
}
set
{
if ((this._Date_Printed != value))
{
this.OnDate_PrintedChanging(value);
this.SendPropertyChanging();
this._Date_Printed = value;
this.SendPropertyChanged("Date_Printed");
this.OnDate_PrintedChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Received", DbType="DateTime")]
public System.Nullable Date_Received
{
get
{
return this._Date_Received;
}
set
{
if ((this._Date_Received != value))
{
this.OnDate_ReceivedChanging(value);
this.SendPropertyChanging();
this._Date_Received = value;
this.SendPropertyChanged("Date_Received");
this.OnDate_ReceivedChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Document_Type", DbType="NVarChar(255)")]
public string Document_Type
{
get
{
return this._Document_Type;
}
set
{
if ((this._Document_Type != value))
{
this.OnDocument_TypeChanging(value);
this.SendPropertyChanging();
this._Document_Type = value;
this.SendPropertyChanged("Document_Type");
this.OnDocument_TypeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Action_Required", DbType="Bit NOT NULL")]
public bool Action_Required
{
get
{
return this._Action_Required;
}
set
{
if ((this._Action_Required != value))
{
this.OnAction_RequiredChanging(value);
this.SendPropertyChanging();
this._Action_Required = value;
this.SendPropertyChanged("Action_Required");
this.OnAction_RequiredChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Due_Date", DbType="DateTime")]
public System.Nullable Due_Date
{
get
{
return this._Due_Date;
}
set
{
if ((this._Due_Date != value))
{
this.OnDue_DateChanging(value);
this.SendPropertyChanging();
this._Due_Date = value;
this.SendPropertyChanged("Due_Date");
this.OnDue_DateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Actual_Date", DbType="DateTime")]
public System.Nullable Actual_Date
{
get
{
return this._Actual_Date;
}
set
{
if ((this._Actual_Date != value))
{
this.OnActual_DateChanging(value);
this.SendPropertyChanging();
this._Actual_Date = value;
this.SendPropertyChanged("Actual_Date");
this.OnActual_DateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Content", DbType="NVarChar(MAX)")]
public string Content
{
get
{
return this._Content;
}
set
{
if ((this._Content != value))
{
this.OnContentChanging(value);
this.SendPropertyChanging();
this._Content = value;
this.SendPropertyChanged("Content");
this.OnContentChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Tag", DbType="NVarChar(255)")]
public string Tag
{
get
{
return this._Tag;
}
set
{
if ((this._Tag != value))
{
this.OnTagChanging(value);
this.SendPropertyChanging();
this._Tag = value;
this.SendPropertyChanged("Tag");
this.OnTagChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Issue_No", DbType="Int")]
public System.Nullable Issue_No
{
get
{
return this._Issue_No;
}
set
{
if ((this._Issue_No != value))
{
this.OnIssue_NoChanging(value);
this.SendPropertyChanging();
this._Issue_No = value;
this.SendPropertyChanged("Issue_No");
this.OnIssue_NoChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Attachment", DbType="NVarChar(MAX)")]
public string Attachment
{
get
{
return this._Attachment;
}
set
{
if ((this._Attachment != value))
{
this.OnAttachmentChanging(value);
this.SendPropertyChanging();
this._Attachment = value;
this.SendPropertyChanged("Attachment");
this.OnAttachmentChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Notes", DbType="NVarChar(MAX)")]
public string Notes
{
get
{
return this._Notes;
}
set
{
if ((this._Notes != value))
{
this.OnNotesChanging(value);
this.SendPropertyChanging();
this._Notes = value;
this.SendPropertyChanged("Notes");
this.OnNotesChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Assigned_To", DbType="NVarChar(255)")]
public string Assigned_To
{
get
{
return this._Assigned_To;
}
set
{
if ((this._Assigned_To != value))
{
this.OnAssigned_ToChanging(value);
this.SendPropertyChanging();
this._Assigned_To = value;
this.SendPropertyChanged("Assigned_To");
this.OnAssigned_ToChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Reply_Ref", DbType="NVarChar(255)")]
public string Reply_Ref
{
get
{
return this._Reply_Ref;
}
set
{
if ((this._Reply_Ref != value))
{
this.OnReply_RefChanging(value);
this.SendPropertyChanging();
this._Reply_Ref = value;
this.SendPropertyChanged("Reply_Ref");
this.OnReply_RefChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Priority", DbType="NVarChar(255)")]
public string Priority
{
get
{
return this._Priority;
}
set
{
if ((this._Priority != value))
{
this.OnPriorityChanging(value);
this.SendPropertyChanging();
this._Priority = value;
this.SendPropertyChanged("Priority");
this.OnPriorityChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Status", DbType="NVarChar(255)")]
public string Status
{
get
{
return this._Status;
}
set
{
if ((this._Status != value))
{
this.OnStatusChanging(value);
this.SendPropertyChanging();
this._Status = value;
this.SendPropertyChanged("Status");
this.OnStatusChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Response", DbType="NVarChar(255)")]
public string Response
{
get
{
return this._Response;
}
set
{
if ((this._Response != value))
{
this.OnResponseChanging(value);
this.SendPropertyChanging();
this._Response = value;
this.SendPropertyChanged("Response");
this.OnResponseChanged();
}
}
}
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.Dwg_Register")]
public partial class Dwg_Register : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _DwgRegisterID;
private string _Ref;
private string _Dwg_Ref;
private string _Title;
private System.Nullable _Dwg_Received_Date;
private string _Rev;
private string _Trade;
private string _Type;
private System.Nullable _Produced_Date;
private string _Produced_By;
private string _Submittal_Ref;
private string _Issued_To;
private System.Nullable _Date_Issued;
private string _Purpose;
private string _Status;
private System.Nullable _Action_Date;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnDwgRegisterIDChanging(int value);
partial void OnDwgRegisterIDChanged();
partial void OnRefChanging(string value);
partial void OnRefChanged();
partial void OnDwg_RefChanging(string value);
partial void OnDwg_RefChanged();
partial void OnTitleChanging(string value);
partial void OnTitleChanged();
partial void OnDwg_Received_DateChanging(System.Nullable value);
partial void OnDwg_Received_DateChanged();
partial void OnRevChanging(string value);
partial void OnRevChanged();
partial void OnTradeChanging(string value);
partial void OnTradeChanged();
partial void OnTypeChanging(string value);
partial void OnTypeChanged();
partial void OnProduced_DateChanging(System.Nullable value);
partial void OnProduced_DateChanged();
partial void OnProduced_ByChanging(string value);
partial void OnProduced_ByChanged();
partial void OnSubmittal_RefChanging(string value);
partial void OnSubmittal_RefChanged();
partial void OnIssued_ToChanging(string value);
partial void OnIssued_ToChanged();
partial void OnDate_IssuedChanging(System.Nullable value);
partial void OnDate_IssuedChanged();
partial void OnPurposeChanging(string value);
partial void OnPurposeChanged();
partial void OnStatusChanging(string value);
partial void OnStatusChanged();
partial void OnAction_DateChanging(System.Nullable value);
partial void OnAction_DateChanged();
#endregion
public Dwg_Register()
{
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_DwgRegisterID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int DwgRegisterID
{
get
{
return this._DwgRegisterID;
}
set
{
if ((this._DwgRegisterID != value))
{
this.OnDwgRegisterIDChanging(value);
this.SendPropertyChanging();
this._DwgRegisterID = value;
this.SendPropertyChanged("DwgRegisterID");
this.OnDwgRegisterIDChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Ref", DbType="NVarChar(255)")]
public string Ref
{
get
{
return this._Ref;
}
set
{
if ((this._Ref != value))
{
this.OnRefChanging(value);
this.SendPropertyChanging();
this._Ref = value;
this.SendPropertyChanged("Ref");
this.OnRefChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Dwg_Ref", DbType="NVarChar(50)")]
public string Dwg_Ref
{
get
{
return this._Dwg_Ref;
}
set
{
if ((this._Dwg_Ref != value))
{
this.OnDwg_RefChanging(value);
this.SendPropertyChanging();
this._Dwg_Ref = value;
this.SendPropertyChanged("Dwg_Ref");
this.OnDwg_RefChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Title", DbType="NVarChar(255)")]
public string Title
{
get
{
return this._Title;
}
set
{
if ((this._Title != value))
{
this.OnTitleChanging(value);
this.SendPropertyChanging();
this._Title = value;
this.SendPropertyChanged("Title");
this.OnTitleChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Dwg_Received_Date", DbType="DateTime")]
public System.Nullable Dwg_Received_Date
{
get
{
return this._Dwg_Received_Date;
}
set
{
if ((this._Dwg_Received_Date != value))
{
this.OnDwg_Received_DateChanging(value);
this.SendPropertyChanging();
this._Dwg_Received_Date = value;
this.SendPropertyChanged("Dwg_Received_Date");
this.OnDwg_Received_DateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Rev", DbType="NVarChar(5)")]
public string Rev
{
get
{
return this._Rev;
}
set
{
if ((this._Rev != value))
{
this.OnRevChanging(value);
this.SendPropertyChanging();
this._Rev = value;
this.SendPropertyChanged("Rev");
this.OnRevChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Trade", DbType="NVarChar(255)")]
public string Trade
{
get
{
return this._Trade;
}
set
{
if ((this._Trade != value))
{
this.OnTradeChanging(value);
this.SendPropertyChanging();
this._Trade = value;
this.SendPropertyChanged("Trade");
this.OnTradeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Type", DbType="NVarChar(255)")]
public string Type
{
get
{
return this._Type;
}
set
{
if ((this._Type != value))
{
this.OnTypeChanging(value);
this.SendPropertyChanging();
this._Type = value;
this.SendPropertyChanged("Type");
this.OnTypeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Produced_Date", DbType="DateTime")]
public System.Nullable Produced_Date
{
get
{
return this._Produced_Date;
}
set
{
if ((this._Produced_Date != value))
{
this.OnProduced_DateChanging(value);
this.SendPropertyChanging();
this._Produced_Date = value;
this.SendPropertyChanged("Produced_Date");
this.OnProduced_DateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Produced_By", DbType="NVarChar(255)")]
public string Produced_By
{
get
{
return this._Produced_By;
}
set
{
if ((this._Produced_By != value))
{
this.OnProduced_ByChanging(value);
this.SendPropertyChanging();
this._Produced_By = value;
this.SendPropertyChanged("Produced_By");
this.OnProduced_ByChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Submittal_Ref", DbType="NVarChar(255)")]
public string Submittal_Ref
{
get
{
return this._Submittal_Ref;
}
set
{
if ((this._Submittal_Ref != value))
{
this.OnSubmittal_RefChanging(value);
this.SendPropertyChanging();
this._Submittal_Ref = value;
this.SendPropertyChanged("Submittal_Ref");
this.OnSubmittal_RefChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Issued_To", DbType="NVarChar(255)")]
public string Issued_To
{
get
{
return this._Issued_To;
}
set
{
if ((this._Issued_To != value))
{
this.OnIssued_ToChanging(value);
this.SendPropertyChanging();
this._Issued_To = value;
this.SendPropertyChanged("Issued_To");
this.OnIssued_ToChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Issued", DbType="DateTime")]
public System.Nullable Date_Issued
{
get
{
return this._Date_Issued;
}
set
{
if ((this._Date_Issued != value))
{
this.OnDate_IssuedChanging(value);
this.SendPropertyChanging();
this._Date_Issued = value;
this.SendPropertyChanged("Date_Issued");
this.OnDate_IssuedChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Purpose", DbType="NVarChar(255)")]
public string Purpose
{
get
{
return this._Purpose;
}
set
{
if ((this._Purpose != value))
{
this.OnPurposeChanging(value);
this.SendPropertyChanging();
this._Purpose = value;
this.SendPropertyChanged("Purpose");
this.OnPurposeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Status", DbType="NVarChar(255)")]
public string Status
{
get
{
return this._Status;
}
set
{
if ((this._Status != value))
{
this.OnStatusChanging(value);
this.SendPropertyChanging();
this._Status = value;
this.SendPropertyChanged("Status");
this.OnStatusChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Action_Date", DbType="DateTime")]
public System.Nullable Action_Date
{
get
{
return this._Action_Date;
}
set
{
if ((this._Action_Date != value))
{
this.OnAction_DateChanging(value);
this.SendPropertyChanging();
this._Action_Date = value;
this.SendPropertyChanged("Action_Date");
this.OnAction_DateChanged();
}
}
}
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.Diary")]
public partial class Diary : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID;
private System.Nullable _Data_Date;
private string _Time;
private string _Cost;
private string _Quality;
private string _Risks;
private string _Communication;
private string _Procurement;
private string _Resources;
private string _Other;
private string _Comments;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIDChanging(int value);
partial void OnIDChanged();
partial void OnData_DateChanging(System.Nullable value);
partial void OnData_DateChanged();
partial void OnTimeChanging(string value);
partial void OnTimeChanged();
partial void OnCostChanging(string value);
partial void OnCostChanged();
partial void OnQualityChanging(string value);
partial void OnQualityChanged();
partial void OnRisksChanging(string value);
partial void OnRisksChanged();
partial void OnCommunicationChanging(string value);
partial void OnCommunicationChanged();
partial void OnProcurementChanging(string value);
partial void OnProcurementChanged();
partial void OnResourcesChanging(string value);
partial void OnResourcesChanged();
partial void OnOtherChanging(string value);
partial void OnOtherChanged();
partial void OnCommentsChanging(string value);
partial void OnCommentsChanged();
#endregion
public Diary()
{
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="_Data_Date", DbType="DateTime")]
public System.Nullable Data_Date
{
get
{
return this._Data_Date;
}
set
{
if ((this._Data_Date != value))
{
this.OnData_DateChanging(value);
this.SendPropertyChanging();
this._Data_Date = value;
this.SendPropertyChanged("Data_Date");
this.OnData_DateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Time", DbType="NVarChar(MAX)")]
public string Time
{
get
{
return this._Time;
}
set
{
if ((this._Time != value))
{
this.OnTimeChanging(value);
this.SendPropertyChanging();
this._Time = value;
this.SendPropertyChanged("Time");
this.OnTimeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Cost", DbType="NVarChar(MAX)")]
public string Cost
{
get
{
return this._Cost;
}
set
{
if ((this._Cost != value))
{
this.OnCostChanging(value);
this.SendPropertyChanging();
this._Cost = value;
this.SendPropertyChanged("Cost");
this.OnCostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Quality", DbType="NVarChar(MAX)")]
public string Quality
{
get
{
return this._Quality;
}
set
{
if ((this._Quality != value))
{
this.OnQualityChanging(value);
this.SendPropertyChanging();
this._Quality = value;
this.SendPropertyChanged("Quality");
this.OnQualityChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Risks", DbType="NVarChar(MAX)")]
public string Risks
{
get
{
return this._Risks;
}
set
{
if ((this._Risks != value))
{
this.OnRisksChanging(value);
this.SendPropertyChanging();
this._Risks = value;
this.SendPropertyChanged("Risks");
this.OnRisksChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Communication", DbType="NVarChar(MAX)")]
public string Communication
{
get
{
return this._Communication;
}
set
{
if ((this._Communication != value))
{
this.OnCommunicationChanging(value);
this.SendPropertyChanging();
this._Communication = value;
this.SendPropertyChanged("Communication");
this.OnCommunicationChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Procurement", DbType="NVarChar(MAX)")]
public string Procurement
{
get
{
return this._Procurement;
}
set
{
if ((this._Procurement != value))
{
this.OnProcurementChanging(value);
this.SendPropertyChanging();
this._Procurement = value;
this.SendPropertyChanged("Procurement");
this.OnProcurementChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Resources", DbType="NVarChar(MAX)")]
public string Resources
{
get
{
return this._Resources;
}
set
{
if ((this._Resources != value))
{
this.OnResourcesChanging(value);
this.SendPropertyChanging();
this._Resources = value;
this.SendPropertyChanged("Resources");
this.OnResourcesChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Other", DbType="NVarChar(MAX)")]
public string Other
{
get
{
return this._Other;
}
set
{
if ((this._Other != value))
{
this.OnOtherChanging(value);
this.SendPropertyChanging();
this._Other = value;
this.SendPropertyChanged("Other");
this.OnOtherChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Comments", DbType="NVarChar(MAX)")]
public string Comments
{
get
{
return this._Comments;
}
set
{
if ((this._Comments != value))
{
this.OnCommentsChanging(value);
this.SendPropertyChanging();
this._Comments = value;
this.SendPropertyChanged("Comments");
this.OnCommentsChanged();
}
}
}
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.Issues")]
public partial class Issue : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID;
private System.Nullable _Issue_No;
private System.Nullable _Initial_Date;
private System.Nullable _RPF_No;
private System.Nullable _SWI_No;
private System.Nullable _VO_No;
private string _Initiated_By;
private string _Description;
private System.Nullable _Budgeted_Cost;
private System.Nullable _Anticipated_Cost;
private System.Nullable _Committed_Cost;
private System.Nullable _Budgeted_Time;
private System.Nullable _Anticipated_Time;
private System.Nullable _Committed_Time;
private string _Category;
private string _Root_Cause;
private string _Impact_Type;
private string _Notes;
private string _Responsibility;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIDChanging(int value);
partial void OnIDChanged();
partial void OnIssue_NoChanging(System.Nullable value);
partial void OnIssue_NoChanged();
partial void OnInitial_DateChanging(System.Nullable value);
partial void OnInitial_DateChanged();
partial void OnRPF_NoChanging(System.Nullable value);
partial void OnRPF_NoChanged();
partial void OnSWI_NoChanging(System.Nullable value);
partial void OnSWI_NoChanged();
partial void OnVO_NoChanging(System.Nullable value);
partial void OnVO_NoChanged();
partial void OnInitiated_ByChanging(string value);
partial void OnInitiated_ByChanged();
partial void OnDescriptionChanging(string value);
partial void OnDescriptionChanged();
partial void OnBudgeted_CostChanging(System.Nullable value);
partial void OnBudgeted_CostChanged();
partial void OnAnticipated_CostChanging(System.Nullable value);
partial void OnAnticipated_CostChanged();
partial void OnCommitted_CostChanging(System.Nullable value);
partial void OnCommitted_CostChanged();
partial void OnBudgeted_TimeChanging(System.Nullable value);
partial void OnBudgeted_TimeChanged();
partial void OnAnticipated_TimeChanging(System.Nullable value);
partial void OnAnticipated_TimeChanged();
partial void OnCommitted_TimeChanging(System.Nullable value);
partial void OnCommitted_TimeChanged();
partial void OnCategoryChanging(string value);
partial void OnCategoryChanged();
partial void OnRoot_CauseChanging(string value);
partial void OnRoot_CauseChanged();
partial void OnImpact_TypeChanging(string value);
partial void OnImpact_TypeChanged();
partial void OnNotesChanging(string value);
partial void OnNotesChanged();
partial void OnResponsibilityChanging(string value);
partial void OnResponsibilityChanged();
#endregion
public Issue()
{
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="_Issue_No", DbType="BigInt")]
public System.Nullable Issue_No
{
get
{
return this._Issue_No;
}
set
{
if ((this._Issue_No != value))
{
this.OnIssue_NoChanging(value);
this.SendPropertyChanging();
this._Issue_No = value;
this.SendPropertyChanged("Issue_No");
this.OnIssue_NoChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Initial_Date", DbType="DateTime")]
public System.Nullable Initial_Date
{
get
{
return this._Initial_Date;
}
set
{
if ((this._Initial_Date != value))
{
this.OnInitial_DateChanging(value);
this.SendPropertyChanging();
this._Initial_Date = value;
this.SendPropertyChanged("Initial_Date");
this.OnInitial_DateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_RPF_No", DbType="BigInt")]
public System.Nullable RPF_No
{
get
{
return this._RPF_No;
}
set
{
if ((this._RPF_No != value))
{
this.OnRPF_NoChanging(value);
this.SendPropertyChanging();
this._RPF_No = value;
this.SendPropertyChanged("RPF_No");
this.OnRPF_NoChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_SWI_No", DbType="BigInt")]
public System.Nullable SWI_No
{
get
{
return this._SWI_No;
}
set
{
if ((this._SWI_No != value))
{
this.OnSWI_NoChanging(value);
this.SendPropertyChanging();
this._SWI_No = value;
this.SendPropertyChanged("SWI_No");
this.OnSWI_NoChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_VO_No", DbType="BigInt")]
public System.Nullable VO_No
{
get
{
return this._VO_No;
}
set
{
if ((this._VO_No != value))
{
this.OnVO_NoChanging(value);
this.SendPropertyChanging();
this._VO_No = value;
this.SendPropertyChanged("VO_No");
this.OnVO_NoChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Initiated_By", DbType="NVarChar(255)")]
public string Initiated_By
{
get
{
return this._Initiated_By;
}
set
{
if ((this._Initiated_By != value))
{
this.OnInitiated_ByChanging(value);
this.SendPropertyChanging();
this._Initiated_By = value;
this.SendPropertyChanged("Initiated_By");
this.OnInitiated_ByChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Description", DbType="NVarChar(255)")]
public string Description
{
get
{
return this._Description;
}
set
{
if ((this._Description != value))
{
this.OnDescriptionChanging(value);
this.SendPropertyChanging();
this._Description = value;
this.SendPropertyChanged("Description");
this.OnDescriptionChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Budgeted_Cost", DbType="Real")]
public System.Nullable Budgeted_Cost
{
get
{
return this._Budgeted_Cost;
}
set
{
if ((this._Budgeted_Cost != value))
{
this.OnBudgeted_CostChanging(value);
this.SendPropertyChanging();
this._Budgeted_Cost = value;
this.SendPropertyChanged("Budgeted_Cost");
this.OnBudgeted_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Anticipated_Cost", DbType="Real")]
public System.Nullable Anticipated_Cost
{
get
{
return this._Anticipated_Cost;
}
set
{
if ((this._Anticipated_Cost != value))
{
this.OnAnticipated_CostChanging(value);
this.SendPropertyChanging();
this._Anticipated_Cost = value;
this.SendPropertyChanged("Anticipated_Cost");
this.OnAnticipated_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Committed_Cost", DbType="Real")]
public System.Nullable Committed_Cost
{
get
{
return this._Committed_Cost;
}
set
{
if ((this._Committed_Cost != value))
{
this.OnCommitted_CostChanging(value);
this.SendPropertyChanging();
this._Committed_Cost = value;
this.SendPropertyChanged("Committed_Cost");
this.OnCommitted_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Budgeted_Time", DbType="BigInt")]
public System.Nullable Budgeted_Time
{
get
{
return this._Budgeted_Time;
}
set
{
if ((this._Budgeted_Time != value))
{
this.OnBudgeted_TimeChanging(value);
this.SendPropertyChanging();
this._Budgeted_Time = value;
this.SendPropertyChanged("Budgeted_Time");
this.OnBudgeted_TimeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Anticipated_Time", DbType="BigInt")]
public System.Nullable Anticipated_Time
{
get
{
return this._Anticipated_Time;
}
set
{
if ((this._Anticipated_Time != value))
{
this.OnAnticipated_TimeChanging(value);
this.SendPropertyChanging();
this._Anticipated_Time = value;
this.SendPropertyChanged("Anticipated_Time");
this.OnAnticipated_TimeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Committed_Time", DbType="BigInt")]
public System.Nullable Committed_Time
{
get
{
return this._Committed_Time;
}
set
{
if ((this._Committed_Time != value))
{
this.OnCommitted_TimeChanging(value);
this.SendPropertyChanging();
this._Committed_Time = value;
this.SendPropertyChanged("Committed_Time");
this.OnCommitted_TimeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Category", DbType="NVarChar(255)")]
public string Category
{
get
{
return this._Category;
}
set
{
if ((this._Category != value))
{
this.OnCategoryChanging(value);
this.SendPropertyChanging();
this._Category = value;
this.SendPropertyChanged("Category");
this.OnCategoryChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Root_Cause", DbType="NVarChar(255)")]
public string Root_Cause
{
get
{
return this._Root_Cause;
}
set
{
if ((this._Root_Cause != value))
{
this.OnRoot_CauseChanging(value);
this.SendPropertyChanging();
this._Root_Cause = value;
this.SendPropertyChanged("Root_Cause");
this.OnRoot_CauseChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Impact_Type", DbType="NVarChar(255)")]
public string Impact_Type
{
get
{
return this._Impact_Type;
}
set
{
if ((this._Impact_Type != value))
{
this.OnImpact_TypeChanging(value);
this.SendPropertyChanging();
this._Impact_Type = value;
this.SendPropertyChanged("Impact_Type");
this.OnImpact_TypeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Notes", DbType="NVarChar(MAX)")]
public string Notes
{
get
{
return this._Notes;
}
set
{
if ((this._Notes != value))
{
this.OnNotesChanging(value);
this.SendPropertyChanging();
this._Notes = value;
this.SendPropertyChanged("Notes");
this.OnNotesChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Responsibility", DbType="NVarChar(255)")]
public string Responsibility
{
get
{
return this._Responsibility;
}
set
{
if ((this._Responsibility != value))
{
this.OnResponsibilityChanging(value);
this.SendPropertyChanging();
this._Responsibility = value;
this.SendPropertyChanged("Responsibility");
this.OnResponsibilityChanged();
}
}
}
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.Payments")]
public partial class Payment : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _PaymentsID;
private string _Ref;
private string _No;
private string _Source;
private string _Period_or_Milestone;
private System.Nullable _Estimated_Amount;
private System.Nullable _Application_Amount;
private System.Nullable _Certification_Amount;
private System.Nullable _Date_Received;
private System.Nullable _Date_Certified;
private System.Nullable _Date_Paid;
private string _Notes;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnPaymentsIDChanging(int value);
partial void OnPaymentsIDChanged();
partial void OnRefChanging(string value);
partial void OnRefChanged();
partial void OnNoChanging(string value);
partial void OnNoChanged();
partial void OnSourceChanging(string value);
partial void OnSourceChanged();
partial void OnPeriod_or_MilestoneChanging(string value);
partial void OnPeriod_or_MilestoneChanged();
partial void OnEstimated_AmountChanging(System.Nullable value);
partial void OnEstimated_AmountChanged();
partial void OnApplication_AmountChanging(System.Nullable value);
partial void OnApplication_AmountChanged();
partial void OnCertification_AmountChanging(System.Nullable value);
partial void OnCertification_AmountChanged();
partial void OnDate_ReceivedChanging(System.Nullable value);
partial void OnDate_ReceivedChanged();
partial void OnDate_CertifiedChanging(System.Nullable value);
partial void OnDate_CertifiedChanged();
partial void OnDate_PaidChanging(System.Nullable value);
partial void OnDate_PaidChanged();
partial void OnNotesChanging(string value);
partial void OnNotesChanged();
#endregion
public Payment()
{
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_PaymentsID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public int PaymentsID
{
get
{
return this._PaymentsID;
}
set
{
if ((this._PaymentsID != value))
{
this.OnPaymentsIDChanging(value);
this.SendPropertyChanging();
this._PaymentsID = value;
this.SendPropertyChanged("PaymentsID");
this.OnPaymentsIDChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Ref", DbType="NVarChar(255)")]
public string Ref
{
get
{
return this._Ref;
}
set
{
if ((this._Ref != value))
{
this.OnRefChanging(value);
this.SendPropertyChanging();
this._Ref = value;
this.SendPropertyChanged("Ref");
this.OnRefChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_No", DbType="NVarChar(255)")]
public string No
{
get
{
return this._No;
}
set
{
if ((this._No != value))
{
this.OnNoChanging(value);
this.SendPropertyChanging();
this._No = value;
this.SendPropertyChanged("No");
this.OnNoChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Source", DbType="NVarChar(255)")]
public string Source
{
get
{
return this._Source;
}
set
{
if ((this._Source != value))
{
this.OnSourceChanging(value);
this.SendPropertyChanging();
this._Source = value;
this.SendPropertyChanged("Source");
this.OnSourceChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Period_or_Milestone", DbType="NVarChar(255)")]
public string Period_or_Milestone
{
get
{
return this._Period_or_Milestone;
}
set
{
if ((this._Period_or_Milestone != value))
{
this.OnPeriod_or_MilestoneChanging(value);
this.SendPropertyChanging();
this._Period_or_Milestone = value;
this.SendPropertyChanged("Period_or_Milestone");
this.OnPeriod_or_MilestoneChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Estimated_Amount", DbType="Real")]
public System.Nullable Estimated_Amount
{
get
{
return this._Estimated_Amount;
}
set
{
if ((this._Estimated_Amount != value))
{
this.OnEstimated_AmountChanging(value);
this.SendPropertyChanging();
this._Estimated_Amount = value;
this.SendPropertyChanged("Estimated_Amount");
this.OnEstimated_AmountChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Application_Amount", DbType="Real")]
public System.Nullable Application_Amount
{
get
{
return this._Application_Amount;
}
set
{
if ((this._Application_Amount != value))
{
this.OnApplication_AmountChanging(value);
this.SendPropertyChanging();
this._Application_Amount = value;
this.SendPropertyChanged("Application_Amount");
this.OnApplication_AmountChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Certification_Amount", DbType="Real")]
public System.Nullable Certification_Amount
{
get
{
return this._Certification_Amount;
}
set
{
if ((this._Certification_Amount != value))
{
this.OnCertification_AmountChanging(value);
this.SendPropertyChanging();
this._Certification_Amount = value;
this.SendPropertyChanged("Certification_Amount");
this.OnCertification_AmountChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Received", DbType="DateTime")]
public System.Nullable Date_Received
{
get
{
return this._Date_Received;
}
set
{
if ((this._Date_Received != value))
{
this.OnDate_ReceivedChanging(value);
this.SendPropertyChanging();
this._Date_Received = value;
this.SendPropertyChanged("Date_Received");
this.OnDate_ReceivedChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Certified", DbType="DateTime")]
public System.Nullable Date_Certified
{
get
{
return this._Date_Certified;
}
set
{
if ((this._Date_Certified != value))
{
this.OnDate_CertifiedChanging(value);
this.SendPropertyChanging();
this._Date_Certified = value;
this.SendPropertyChanged("Date_Certified");
this.OnDate_CertifiedChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Paid", DbType="DateTime")]
public System.Nullable Date_Paid
{
get
{
return this._Date_Paid;
}
set
{
if ((this._Date_Paid != value))
{
this.OnDate_PaidChanging(value);
this.SendPropertyChanging();
this._Date_Paid = value;
this.SendPropertyChanged("Date_Paid");
this.OnDate_PaidChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Notes", DbType="NVarChar(MAX)")]
public string Notes
{
get
{
return this._Notes;
}
set
{
if ((this._Notes != value))
{
this.OnNotesChanging(value);
this.SendPropertyChanging();
this._Notes = value;
this.SendPropertyChanged("Notes");
this.OnNotesChanged();
}
}
}
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.Risk_Register")]
public partial class Risk_Register : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID;
private string _Risk_Description;
private string _Risk_Group;
private System.Nullable _Risk_Severity;
private System.Nullable _Risk_Probability;
private string _Risk_Response;
private System.Nullable _Residual_Severity;
private System.Nullable _Residual_Probability;
private System.Nullable _Contigency_Cost;
private System.Nullable _Contingency_Time;
private System.Nullable _Contingency_Probability;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIDChanging(int value);
partial void OnIDChanged();
partial void OnRisk_DescriptionChanging(string value);
partial void OnRisk_DescriptionChanged();
partial void OnRisk_GroupChanging(string value);
partial void OnRisk_GroupChanged();
partial void OnRisk_SeverityChanging(System.Nullable value);
partial void OnRisk_SeverityChanged();
partial void OnRisk_ProbabilityChanging(System.Nullable value);
partial void OnRisk_ProbabilityChanged();
partial void OnRisk_ResponseChanging(string value);
partial void OnRisk_ResponseChanged();
partial void OnResidual_SeverityChanging(System.Nullable value);
partial void OnResidual_SeverityChanged();
partial void OnResidual_ProbabilityChanging(System.Nullable value);
partial void OnResidual_ProbabilityChanged();
partial void OnContigency_CostChanging(System.Nullable value);
partial void OnContigency_CostChanged();
partial void OnContingency_TimeChanging(System.Nullable value);
partial void OnContingency_TimeChanged();
partial void OnContingency_ProbabilityChanging(System.Nullable value);
partial void OnContingency_ProbabilityChanged();
#endregion
public Risk_Register()
{
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public new 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="_Risk_Description", DbType="NVarChar(MAX)")]
public string Risk_Description
{
get
{
return this._Risk_Description;
}
set
{
if ((this._Risk_Description != value))
{
this.OnRisk_DescriptionChanging(value);
this.SendPropertyChanging();
this._Risk_Description = value;
this.SendPropertyChanged("Risk_Description");
this.OnRisk_DescriptionChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Risk_Group", DbType="NVarChar(MAX)")]
public string Risk_Group
{
get
{
return this._Risk_Group;
}
set
{
if ((this._Risk_Group != value))
{
this.OnRisk_GroupChanging(value);
this.SendPropertyChanging();
this._Risk_Group = value;
this.SendPropertyChanged("Risk_Group");
this.OnRisk_GroupChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Risk_Severity", DbType="SmallInt")]
public System.Nullable Risk_Severity
{
get
{
return this._Risk_Severity;
}
set
{
if ((this._Risk_Severity != value))
{
this.OnRisk_SeverityChanging(value);
this.SendPropertyChanging();
this._Risk_Severity = value;
this.SendPropertyChanged("Risk_Severity");
this.OnRisk_SeverityChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Risk_Probability", DbType="SmallInt")]
public System.Nullable Risk_Probability
{
get
{
return this._Risk_Probability;
}
set
{
if ((this._Risk_Probability != value))
{
this.OnRisk_ProbabilityChanging(value);
this.SendPropertyChanging();
this._Risk_Probability = value;
this.SendPropertyChanged("Risk_Probability");
this.OnRisk_ProbabilityChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Risk_Response", DbType="NVarChar(MAX)")]
public string Risk_Response
{
get
{
return this._Risk_Response;
}
set
{
if ((this._Risk_Response != value))
{
this.OnRisk_ResponseChanging(value);
this.SendPropertyChanging();
this._Risk_Response = value;
this.SendPropertyChanged("Risk_Response");
this.OnRisk_ResponseChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Residual_Severity", DbType="SmallInt")]
public System.Nullable Residual_Severity
{
get
{
return this._Residual_Severity;
}
set
{
if ((this._Residual_Severity != value))
{
this.OnResidual_SeverityChanging(value);
this.SendPropertyChanging();
this._Residual_Severity = value;
this.SendPropertyChanged("Residual_Severity");
this.OnResidual_SeverityChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Residual_Probability", DbType="SmallInt")]
public System.Nullable Residual_Probability
{
get
{
return this._Residual_Probability;
}
set
{
if ((this._Residual_Probability != value))
{
this.OnResidual_ProbabilityChanging(value);
this.SendPropertyChanging();
this._Residual_Probability = value;
this.SendPropertyChanged("Residual_Probability");
this.OnResidual_ProbabilityChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Contigency_Cost", DbType="Int")]
public System.Nullable Contigency_Cost
{
get
{
return this._Contigency_Cost;
}
set
{
if ((this._Contigency_Cost != value))
{
this.OnContigency_CostChanging(value);
this.SendPropertyChanging();
this._Contigency_Cost = value;
this.SendPropertyChanged("Contigency_Cost");
this.OnContigency_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Contingency_Time", DbType="Int")]
public System.Nullable Contingency_Time
{
get
{
return this._Contingency_Time;
}
set
{
if ((this._Contingency_Time != value))
{
this.OnContingency_TimeChanging(value);
this.SendPropertyChanging();
this._Contingency_Time = value;
this.SendPropertyChanged("Contingency_Time");
this.OnContingency_TimeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Contingency_Probability", DbType="Int")]
public System.Nullable Contingency_Probability
{
get
{
return this._Contingency_Probability;
}
set
{
if ((this._Contingency_Probability != value))
{
this.OnContingency_ProbabilityChanging(value);
this.SendPropertyChanging();
this._Contingency_Probability = value;
this.SendPropertyChanged("Contingency_Probability");
this.OnContingency_ProbabilityChanged();
}
}
}
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.Tasks")]
public partial class Task : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID;
private string _Ref;
private System.Nullable _Date;
private string _Task1;
private string _Assigned_To;
private System.Nullable _Due_Date;
private System.Nullable _Actual_Date;
private string _Status;
private string _Notes;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIDChanging(int value);
partial void OnIDChanged();
partial void OnRefChanging(string value);
partial void OnRefChanged();
partial void OnDateChanging(System.Nullable value);
partial void OnDateChanged();
partial void OnTask1Changing(string value);
partial void OnTask1Changed();
partial void OnAssigned_ToChanging(string value);
partial void OnAssigned_ToChanged();
partial void OnDue_DateChanging(System.Nullable value);
partial void OnDue_DateChanged();
partial void OnActual_DateChanging(System.Nullable value);
partial void OnActual_DateChanged();
partial void OnStatusChanging(string value);
partial void OnStatusChanged();
partial void OnNotesChanging(string value);
partial void OnNotesChanged();
#endregion
public Task()
{
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="_Ref", DbType="NVarChar(255)")]
public string Ref
{
get
{
return this._Ref;
}
set
{
if ((this._Ref != value))
{
this.OnRefChanging(value);
this.SendPropertyChanging();
this._Ref = value;
this.SendPropertyChanged("Ref");
this.OnRefChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date", DbType="DateTime")]
public System.Nullable 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(Name="Task", Storage="_Task1", DbType="NVarChar(255)")]
public string Task1
{
get
{
return this._Task1;
}
set
{
if ((this._Task1 != value))
{
this.OnTask1Changing(value);
this.SendPropertyChanging();
this._Task1 = value;
this.SendPropertyChanged("Task1");
this.OnTask1Changed();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Assigned_To", DbType="NVarChar(255)")]
public string Assigned_To
{
get
{
return this._Assigned_To;
}
set
{
if ((this._Assigned_To != value))
{
this.OnAssigned_ToChanging(value);
this.SendPropertyChanging();
this._Assigned_To = value;
this.SendPropertyChanged("Assigned_To");
this.OnAssigned_ToChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Due_Date", DbType="DateTime")]
public System.Nullable Due_Date
{
get
{
return this._Due_Date;
}
set
{
if ((this._Due_Date != value))
{
this.OnDue_DateChanging(value);
this.SendPropertyChanging();
this._Due_Date = value;
this.SendPropertyChanged("Due_Date");
this.OnDue_DateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Actual_Date", DbType="DateTime")]
public System.Nullable Actual_Date
{
get
{
return this._Actual_Date;
}
set
{
if ((this._Actual_Date != value))
{
this.OnActual_DateChanging(value);
this.SendPropertyChanging();
this._Actual_Date = value;
this.SendPropertyChanged("Actual_Date");
this.OnActual_DateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Status", DbType="NVarChar(255)")]
public string Status
{
get
{
return this._Status;
}
set
{
if ((this._Status != value))
{
this.OnStatusChanging(value);
this.SendPropertyChanging();
this._Status = value;
this.SendPropertyChanged("Status");
this.OnStatusChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Notes", DbType="NVarChar(255)")]
public string Notes
{
get
{
return this._Notes;
}
set
{
if ((this._Notes != value))
{
this.OnNotesChanging(value);
this.SendPropertyChanging();
this._Notes = value;
this.SendPropertyChanged("Notes");
this.OnNotesChanged();
}
}
}
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.Unit_Rates")]
public partial class Unit_Rate : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID;
private string _Cost_Code;
private string _Description;
private System.Nullable _Materials;
private System.Nullable _Labour;
private System.Nullable _Plant;
private System.Nullable _Sub_Contract_Rate;
private System.Nullable _Overheads;
private System.Nullable _Profit;
private System.Nullable _Lump_Sum;
private string _Source;
private string _Origin;
private string _Specifications;
private string _Notes;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIDChanging(int value);
partial void OnIDChanged();
partial void OnCost_CodeChanging(string value);
partial void OnCost_CodeChanged();
partial void OnDescriptionChanging(string value);
partial void OnDescriptionChanged();
partial void OnMaterialsChanging(System.Nullable value);
partial void OnMaterialsChanged();
partial void OnLabourChanging(System.Nullable value);
partial void OnLabourChanged();
partial void OnPlantChanging(System.Nullable value);
partial void OnPlantChanged();
partial void OnSub_Contract_RateChanging(System.Nullable value);
partial void OnSub_Contract_RateChanged();
partial void OnOverheadsChanging(System.Nullable value);
partial void OnOverheadsChanged();
partial void OnProfitChanging(System.Nullable value);
partial void OnProfitChanged();
partial void OnLump_SumChanging(System.Nullable value);
partial void OnLump_SumChanged();
partial void OnSourceChanging(string value);
partial void OnSourceChanged();
partial void OnOriginChanging(string value);
partial void OnOriginChanged();
partial void OnSpecificationsChanging(string value);
partial void OnSpecificationsChanged();
partial void OnNotesChanging(string value);
partial void OnNotesChanged();
#endregion
public Unit_Rate()
{
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="_Cost_Code", DbType="NVarChar(255)")]
public string Cost_Code
{
get
{
return this._Cost_Code;
}
set
{
if ((this._Cost_Code != value))
{
this.OnCost_CodeChanging(value);
this.SendPropertyChanging();
this._Cost_Code = value;
this.SendPropertyChanged("Cost_Code");
this.OnCost_CodeChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Description", DbType="NVarChar(255)")]
public string Description
{
get
{
return this._Description;
}
set
{
if ((this._Description != value))
{
this.OnDescriptionChanging(value);
this.SendPropertyChanging();
this._Description = value;
this.SendPropertyChanged("Description");
this.OnDescriptionChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Materials", DbType="Float")]
public System.Nullable Materials
{
get
{
return this._Materials;
}
set
{
if ((this._Materials != value))
{
this.OnMaterialsChanging(value);
this.SendPropertyChanging();
this._Materials = value;
this.SendPropertyChanged("Materials");
this.OnMaterialsChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Labour", DbType="Float")]
public System.Nullable Labour
{
get
{
return this._Labour;
}
set
{
if ((this._Labour != value))
{
this.OnLabourChanging(value);
this.SendPropertyChanging();
this._Labour = value;
this.SendPropertyChanged("Labour");
this.OnLabourChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Plant", DbType="Float")]
public System.Nullable Plant
{
get
{
return this._Plant;
}
set
{
if ((this._Plant != value))
{
this.OnPlantChanging(value);
this.SendPropertyChanging();
this._Plant = value;
this.SendPropertyChanged("Plant");
this.OnPlantChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Sub_Contract_Rate", DbType="Float")]
public System.Nullable Sub_Contract_Rate
{
get
{
return this._Sub_Contract_Rate;
}
set
{
if ((this._Sub_Contract_Rate != value))
{
this.OnSub_Contract_RateChanging(value);
this.SendPropertyChanging();
this._Sub_Contract_Rate = value;
this.SendPropertyChanged("Sub_Contract_Rate");
this.OnSub_Contract_RateChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Overheads", DbType="Float")]
public System.Nullable Overheads
{
get
{
return this._Overheads;
}
set
{
if ((this._Overheads != value))
{
this.OnOverheadsChanging(value);
this.SendPropertyChanging();
this._Overheads = value;
this.SendPropertyChanged("Overheads");
this.OnOverheadsChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Profit", DbType="Float")]
public System.Nullable Profit
{
get
{
return this._Profit;
}
set
{
if ((this._Profit != value))
{
this.OnProfitChanging(value);
this.SendPropertyChanging();
this._Profit = value;
this.SendPropertyChanged("Profit");
this.OnProfitChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Lump_Sum", DbType="Float")]
public System.Nullable Lump_Sum
{
get
{
return this._Lump_Sum;
}
set
{
if ((this._Lump_Sum != value))
{
this.OnLump_SumChanging(value);
this.SendPropertyChanging();
this._Lump_Sum = value;
this.SendPropertyChanged("Lump_Sum");
this.OnLump_SumChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Source", DbType="NVarChar(255)")]
public string Source
{
get
{
return this._Source;
}
set
{
if ((this._Source != value))
{
this.OnSourceChanging(value);
this.SendPropertyChanging();
this._Source = value;
this.SendPropertyChanged("Source");
this.OnSourceChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Origin", DbType="NVarChar(255)")]
public string Origin
{
get
{
return this._Origin;
}
set
{
if ((this._Origin != value))
{
this.OnOriginChanging(value);
this.SendPropertyChanging();
this._Origin = value;
this.SendPropertyChanged("Origin");
this.OnOriginChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Specifications", DbType="NVarChar(255)")]
public string Specifications
{
get
{
return this._Specifications;
}
set
{
if ((this._Specifications != value))
{
this.OnSpecificationsChanging(value);
this.SendPropertyChanging();
this._Specifications = value;
this.SendPropertyChanged("Specifications");
this.OnSpecificationsChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Notes", DbType="NVarChar(255)")]
public string Notes
{
get
{
return this._Notes;
}
set
{
if ((this._Notes != value))
{
this.OnNotesChanging(value);
this.SendPropertyChanging();
this._Notes = value;
this.SendPropertyChanged("Notes");
this.OnNotesChanged();
}
}
}
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.Cost")]
public partial class Cost : INotifyPropertyChanging, INotifyPropertyChanged
{
private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
private int _ID;
private string _Cost_ID;
private string _Cost_Item;
private string _Activity_ID;
private System.Nullable _Date;
private System.Nullable _Prelims_Cost;
private System.Nullable _Materials_Cost;
private System.Nullable _Labour_Cost;
private System.Nullable _Sub_Contract_Cost;
private System.Nullable _Overheads_Cost;
private System.Nullable _Profit_Cost;
private System.Nullable _Contingencies;
private System.Nullable _Lump_Sum_Cost;
private string _Supplier;
private string _Notes;
#region Extensibility Method Definitions
partial void OnLoaded();
partial void OnValidate(System.Data.Linq.ChangeAction action);
partial void OnCreated();
partial void OnIDChanging(int value);
partial void OnIDChanged();
partial void OnCost_IDChanging(string value);
partial void OnCost_IDChanged();
partial void OnCost_ItemChanging(string value);
partial void OnCost_ItemChanged();
partial void OnActivity_IDChanging(string value);
partial void OnActivity_IDChanged();
partial void OnDateChanging(System.Nullable value);
partial void OnDateChanged();
partial void OnPrelims_CostChanging(System.Nullable value);
partial void OnPrelims_CostChanged();
partial void OnMaterials_CostChanging(System.Nullable value);
partial void OnMaterials_CostChanged();
partial void OnLabour_CostChanging(System.Nullable value);
partial void OnLabour_CostChanged();
partial void OnSub_Contract_CostChanging(System.Nullable value);
partial void OnSub_Contract_CostChanged();
partial void OnOverheads_CostChanging(System.Nullable value);
partial void OnOverheads_CostChanged();
partial void OnProfit_CostChanging(System.Nullable value);
partial void OnProfit_CostChanged();
partial void OnContingenciesChanging(System.Nullable value);
partial void OnContingenciesChanged();
partial void OnLump_Sum_CostChanging(System.Nullable value);
partial void OnLump_Sum_CostChanged();
partial void OnSupplierChanging(string value);
partial void OnSupplierChanged();
partial void OnNotesChanging(string value);
partial void OnNotesChanged();
#endregion
public Cost()
{
OnCreated();
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID", AutoSync=AutoSync.OnInsert, DbType="Int NOT NULL IDENTITY", IsPrimaryKey=true, IsDbGenerated=true)]
public new 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="_Cost_ID", DbType="NVarChar(255)")]
public string Cost_ID
{
get
{
return this._Cost_ID;
}
set
{
if ((this._Cost_ID != value))
{
this.OnCost_IDChanging(value);
this.SendPropertyChanging();
this._Cost_ID = value;
this.SendPropertyChanged("Cost_ID");
this.OnCost_IDChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Cost_Item", DbType="NVarChar(255)")]
public string Cost_Item
{
get
{
return this._Cost_Item;
}
set
{
if ((this._Cost_Item != value))
{
this.OnCost_ItemChanging(value);
this.SendPropertyChanging();
this._Cost_Item = value;
this.SendPropertyChanged("Cost_Item");
this.OnCost_ItemChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Activity_ID", DbType="NVarChar(255)")]
public string Activity_ID
{
get
{
return this._Activity_ID;
}
set
{
if ((this._Activity_ID != value))
{
this.OnActivity_IDChanging(value);
this.SendPropertyChanging();
this._Activity_ID = value;
this.SendPropertyChanged("Activity_ID");
this.OnActivity_IDChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date", DbType="DateTime")]
public System.Nullable 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="_Prelims_Cost", DbType="Float")]
public System.Nullable Prelims_Cost
{
get
{
return this._Prelims_Cost;
}
set
{
if ((this._Prelims_Cost != value))
{
this.OnPrelims_CostChanging(value);
this.SendPropertyChanging();
this._Prelims_Cost = value;
this.SendPropertyChanged("Prelims_Cost");
this.OnPrelims_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Materials_Cost", DbType="Float")]
public System.Nullable Materials_Cost
{
get
{
return this._Materials_Cost;
}
set
{
if ((this._Materials_Cost != value))
{
this.OnMaterials_CostChanging(value);
this.SendPropertyChanging();
this._Materials_Cost = value;
this.SendPropertyChanged("Materials_Cost");
this.OnMaterials_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Labour_Cost", DbType="Float")]
public System.Nullable Labour_Cost
{
get
{
return this._Labour_Cost;
}
set
{
if ((this._Labour_Cost != value))
{
this.OnLabour_CostChanging(value);
this.SendPropertyChanging();
this._Labour_Cost = value;
this.SendPropertyChanged("Labour_Cost");
this.OnLabour_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Sub_Contract_Cost", DbType="Float")]
public System.Nullable Sub_Contract_Cost
{
get
{
return this._Sub_Contract_Cost;
}
set
{
if ((this._Sub_Contract_Cost != value))
{
this.OnSub_Contract_CostChanging(value);
this.SendPropertyChanging();
this._Sub_Contract_Cost = value;
this.SendPropertyChanged("Sub_Contract_Cost");
this.OnSub_Contract_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Overheads_Cost", DbType="Float")]
public System.Nullable Overheads_Cost
{
get
{
return this._Overheads_Cost;
}
set
{
if ((this._Overheads_Cost != value))
{
this.OnOverheads_CostChanging(value);
this.SendPropertyChanging();
this._Overheads_Cost = value;
this.SendPropertyChanged("Overheads_Cost");
this.OnOverheads_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Profit_Cost", DbType="Float")]
public System.Nullable Profit_Cost
{
get
{
return this._Profit_Cost;
}
set
{
if ((this._Profit_Cost != value))
{
this.OnProfit_CostChanging(value);
this.SendPropertyChanging();
this._Profit_Cost = value;
this.SendPropertyChanged("Profit_Cost");
this.OnProfit_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Contingencies", DbType="Float")]
public System.Nullable Contingencies
{
get
{
return this._Contingencies;
}
set
{
if ((this._Contingencies != value))
{
this.OnContingenciesChanging(value);
this.SendPropertyChanging();
this._Contingencies = value;
this.SendPropertyChanged("Contingencies");
this.OnContingenciesChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Lump_Sum_Cost", DbType="Float")]
public System.Nullable Lump_Sum_Cost
{
get
{
return this._Lump_Sum_Cost;
}
set
{
if ((this._Lump_Sum_Cost != value))
{
this.OnLump_Sum_CostChanging(value);
this.SendPropertyChanging();
this._Lump_Sum_Cost = value;
this.SendPropertyChanged("Lump_Sum_Cost");
this.OnLump_Sum_CostChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Supplier", DbType="NVarChar(510)")]
public string Supplier
{
get
{
return this._Supplier;
}
set
{
if ((this._Supplier != value))
{
this.OnSupplierChanging(value);
this.SendPropertyChanging();
this._Supplier = value;
this.SendPropertyChanged("Supplier");
this.OnSupplierChanged();
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Notes", DbType="NVarChar(MAX)")]
public string Notes
{
get
{
return this._Notes;
}
set
{
if ((this._Notes != value))
{
this.OnNotesChanging(value);
this.SendPropertyChanging();
this._Notes = value;
this.SendPropertyChanged("Notes");
this.OnNotesChanged();
}
}
}
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));
}
}
}
public partial class spGetUserResult
{
private int _DocumentsID;
private string _Ref;
private string _Subject;
private string _Src;
private string _Dst;
private string _Medium;
private System.Nullable _Date_Printed;
private System.Nullable _Date_Received;
private string _Document_Type;
private bool _Action_Required;
private System.Nullable _Due_Date;
private System.Nullable _Actual_Date;
private string _Content;
private string _Tag;
private System.Nullable _Issue_No;
private string _Attachment;
private string _Notes;
private string _Assigned_To;
private string _Reply_Ref;
private string _Priority;
private string _Status;
private string _Response;
public spGetUserResult()
{
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_DocumentsID", DbType="Int NOT NULL")]
public int DocumentsID
{
get
{
return this._DocumentsID;
}
set
{
if ((this._DocumentsID != value))
{
this._DocumentsID = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Ref", DbType="NVarChar(25)")]
public string Ref
{
get
{
return this._Ref;
}
set
{
if ((this._Ref != value))
{
this._Ref = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Subject", DbType="NVarChar(255)")]
public string Subject
{
get
{
return this._Subject;
}
set
{
if ((this._Subject != value))
{
this._Subject = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Src", DbType="NVarChar(255)")]
public string Src
{
get
{
return this._Src;
}
set
{
if ((this._Src != value))
{
this._Src = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Dst", DbType="NVarChar(255)")]
public string Dst
{
get
{
return this._Dst;
}
set
{
if ((this._Dst != value))
{
this._Dst = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Medium", DbType="NVarChar(255)")]
public string Medium
{
get
{
return this._Medium;
}
set
{
if ((this._Medium != value))
{
this._Medium = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Printed", DbType="DateTime")]
public System.Nullable Date_Printed
{
get
{
return this._Date_Printed;
}
set
{
if ((this._Date_Printed != value))
{
this._Date_Printed = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Received", DbType="DateTime")]
public System.Nullable Date_Received
{
get
{
return this._Date_Received;
}
set
{
if ((this._Date_Received != value))
{
this._Date_Received = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Document_Type", DbType="NVarChar(255)")]
public string Document_Type
{
get
{
return this._Document_Type;
}
set
{
if ((this._Document_Type != value))
{
this._Document_Type = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Action_Required", DbType="Bit NOT NULL")]
public bool Action_Required
{
get
{
return this._Action_Required;
}
set
{
if ((this._Action_Required != value))
{
this._Action_Required = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Due_Date", DbType="DateTime")]
public System.Nullable Due_Date
{
get
{
return this._Due_Date;
}
set
{
if ((this._Due_Date != value))
{
this._Due_Date = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Actual_Date", DbType="DateTime")]
public System.Nullable Actual_Date
{
get
{
return this._Actual_Date;
}
set
{
if ((this._Actual_Date != value))
{
this._Actual_Date = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Content", DbType="NVarChar(MAX)")]
public string Content
{
get
{
return this._Content;
}
set
{
if ((this._Content != value))
{
this._Content = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Tag", DbType="NVarChar(255)")]
public string Tag
{
get
{
return this._Tag;
}
set
{
if ((this._Tag != value))
{
this._Tag = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Issue_No", DbType="Int")]
public System.Nullable Issue_No
{
get
{
return this._Issue_No;
}
set
{
if ((this._Issue_No != value))
{
this._Issue_No = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Attachment", DbType="NVarChar(MAX)")]
public string Attachment
{
get
{
return this._Attachment;
}
set
{
if ((this._Attachment != value))
{
this._Attachment = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Notes", DbType="NVarChar(MAX)")]
public string Notes
{
get
{
return this._Notes;
}
set
{
if ((this._Notes != value))
{
this._Notes = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Assigned_To", DbType="NVarChar(255)")]
public string Assigned_To
{
get
{
return this._Assigned_To;
}
set
{
if ((this._Assigned_To != value))
{
this._Assigned_To = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Reply_Ref", DbType="NVarChar(255)")]
public string Reply_Ref
{
get
{
return this._Reply_Ref;
}
set
{
if ((this._Reply_Ref != value))
{
this._Reply_Ref = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Priority", DbType="NVarChar(255)")]
public string Priority
{
get
{
return this._Priority;
}
set
{
if ((this._Priority != value))
{
this._Priority = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Status", DbType="NVarChar(255)")]
public string Status
{
get
{
return this._Status;
}
set
{
if ((this._Status != value))
{
this._Status = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Response", DbType="NVarChar(255)")]
public string Response
{
get
{
return this._Response;
}
set
{
if ((this._Response != value))
{
this._Response = value;
}
}
}
}
public partial class DwgRegisterGetUserResult
{
private int _DwgRegisterID;
private string _Ref;
private string _Dwg_Ref;
private string _Title;
private System.Nullable _Dwg_Received_Date;
private string _Rev;
private string _Trade;
private string _Type;
private System.Nullable _Produced_Date;
private string _Produced_By;
private string _Submittal_Ref;
private string _Issued_To;
private System.Nullable _Date_Issued;
private string _Purpose;
private string _Status;
private System.Nullable _Action_Date;
public DwgRegisterGetUserResult()
{
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_DwgRegisterID", DbType="Int NOT NULL")]
public int DwgRegisterID
{
get
{
return this._DwgRegisterID;
}
set
{
if ((this._DwgRegisterID != value))
{
this._DwgRegisterID = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Ref", DbType="NVarChar(255)")]
public string Ref
{
get
{
return this._Ref;
}
set
{
if ((this._Ref != value))
{
this._Ref = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Dwg_Ref", DbType="NVarChar(50)")]
public string Dwg_Ref
{
get
{
return this._Dwg_Ref;
}
set
{
if ((this._Dwg_Ref != value))
{
this._Dwg_Ref = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Title", DbType="NVarChar(255)")]
public string Title
{
get
{
return this._Title;
}
set
{
if ((this._Title != value))
{
this._Title = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Dwg_Received_Date", DbType="DateTime")]
public System.Nullable Dwg_Received_Date
{
get
{
return this._Dwg_Received_Date;
}
set
{
if ((this._Dwg_Received_Date != value))
{
this._Dwg_Received_Date = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Rev", DbType="NVarChar(5)")]
public string Rev
{
get
{
return this._Rev;
}
set
{
if ((this._Rev != value))
{
this._Rev = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Trade", DbType="NVarChar(255)")]
public string Trade
{
get
{
return this._Trade;
}
set
{
if ((this._Trade != value))
{
this._Trade = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Type", DbType="NVarChar(255)")]
public string Type
{
get
{
return this._Type;
}
set
{
if ((this._Type != value))
{
this._Type = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Produced_Date", DbType="DateTime")]
public System.Nullable Produced_Date
{
get
{
return this._Produced_Date;
}
set
{
if ((this._Produced_Date != value))
{
this._Produced_Date = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Produced_By", DbType="NVarChar(255)")]
public string Produced_By
{
get
{
return this._Produced_By;
}
set
{
if ((this._Produced_By != value))
{
this._Produced_By = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Submittal_Ref", DbType="NVarChar(255)")]
public string Submittal_Ref
{
get
{
return this._Submittal_Ref;
}
set
{
if ((this._Submittal_Ref != value))
{
this._Submittal_Ref = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Issued_To", DbType="NVarChar(255)")]
public string Issued_To
{
get
{
return this._Issued_To;
}
set
{
if ((this._Issued_To != value))
{
this._Issued_To = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Date_Issued", DbType="DateTime")]
public System.Nullable Date_Issued
{
get
{
return this._Date_Issued;
}
set
{
if ((this._Date_Issued != value))
{
this._Date_Issued = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Purpose", DbType="NVarChar(255)")]
public string Purpose
{
get
{
return this._Purpose;
}
set
{
if ((this._Purpose != value))
{
this._Purpose = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Status", DbType="NVarChar(255)")]
public string Status
{
get
{
return this._Status;
}
set
{
if ((this._Status != value))
{
this._Status = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Action_Date", DbType="DateTime")]
public System.Nullable Action_Date
{
get
{
return this._Action_Date;
}
set
{
if ((this._Action_Date != value))
{
this._Action_Date = value;
}
}
}
}
public partial class DiaryGetUserResult
{
private int _ID;
private System.Nullable _Data_Date;
private string _Time;
private string _Cost;
private string _Quality;
private string _Risks;
private string _Communication;
private string _Procurement;
private string _Resources;
private string _Other;
private string _Comments;
public DiaryGetUserResult()
{
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID", DbType="Int NOT NULL")]
public int ID
{
get
{
return this._ID;
}
set
{
if ((this._ID != value))
{
this._ID = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Data_Date", DbType="DateTime")]
public System.Nullable Data_Date
{
get
{
return this._Data_Date;
}
set
{
if ((this._Data_Date != value))
{
this._Data_Date = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Time", DbType="NVarChar(MAX)")]
public string Time
{
get
{
return this._Time;
}
set
{
if ((this._Time != value))
{
this._Time = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Cost", DbType="NVarChar(MAX)")]
public string Cost
{
get
{
return this._Cost;
}
set
{
if ((this._Cost != value))
{
this._Cost = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Quality", DbType="NVarChar(MAX)")]
public string Quality
{
get
{
return this._Quality;
}
set
{
if ((this._Quality != value))
{
this._Quality = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Risks", DbType="NVarChar(MAX)")]
public string Risks
{
get
{
return this._Risks;
}
set
{
if ((this._Risks != value))
{
this._Risks = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Communication", DbType="NVarChar(MAX)")]
public string Communication
{
get
{
return this._Communication;
}
set
{
if ((this._Communication != value))
{
this._Communication = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Procurement", DbType="NVarChar(MAX)")]
public string Procurement
{
get
{
return this._Procurement;
}
set
{
if ((this._Procurement != value))
{
this._Procurement = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Resources", DbType="NVarChar(MAX)")]
public string Resources
{
get
{
return this._Resources;
}
set
{
if ((this._Resources != value))
{
this._Resources = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Other", DbType="NVarChar(MAX)")]
public string Other
{
get
{
return this._Other;
}
set
{
if ((this._Other != value))
{
this._Other = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Comments", DbType="NVarChar(MAX)")]
public string Comments
{
get
{
return this._Comments;
}
set
{
if ((this._Comments != value))
{
this._Comments = value;
}
}
}
}
public partial class IssuesGetUserResult
{
private int _ID;
private System.Nullable _Issue_No;
private System.Nullable _Initial_Date;
private System.Nullable _RPF_No;
private System.Nullable _SWI_No;
private System.Nullable _VO_No;
private string _Initiated_By;
private string _Description;
private System.Nullable _Budgeted_Cost;
private System.Nullable _Anticipated_Cost;
private System.Nullable _Committed_Cost;
private System.Nullable _Budgeted_Time;
private System.Nullable _Anticipated_Time;
private System.Nullable _Committed_Time;
private string _Category;
private string _Root_Cause;
private string _Impact_Type;
private string _Notes;
private string _Responsibility;
public IssuesGetUserResult()
{
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID", DbType="Int NOT NULL")]
public int ID
{
get
{
return this._ID;
}
set
{
if ((this._ID != value))
{
this._ID = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Issue_No", DbType="BigInt")]
public System.Nullable Issue_No
{
get
{
return this._Issue_No;
}
set
{
if ((this._Issue_No != value))
{
this._Issue_No = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Initial_Date", DbType="DateTime")]
public System.Nullable Initial_Date
{
get
{
return this._Initial_Date;
}
set
{
if ((this._Initial_Date != value))
{
this._Initial_Date = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_RPF_No", DbType="BigInt")]
public System.Nullable RPF_No
{
get
{
return this._RPF_No;
}
set
{
if ((this._RPF_No != value))
{
this._RPF_No = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_SWI_No", DbType="BigInt")]
public System.Nullable SWI_No
{
get
{
return this._SWI_No;
}
set
{
if ((this._SWI_No != value))
{
this._SWI_No = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_VO_No", DbType="BigInt")]
public System.Nullable VO_No
{
get
{
return this._VO_No;
}
set
{
if ((this._VO_No != value))
{
this._VO_No = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Initiated_By", DbType="NVarChar(255)")]
public string Initiated_By
{
get
{
return this._Initiated_By;
}
set
{
if ((this._Initiated_By != value))
{
this._Initiated_By = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Description", DbType="NVarChar(255)")]
public string Description
{
get
{
return this._Description;
}
set
{
if ((this._Description != value))
{
this._Description = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Budgeted_Cost", DbType="Real")]
public System.Nullable Budgeted_Cost
{
get
{
return this._Budgeted_Cost;
}
set
{
if ((this._Budgeted_Cost != value))
{
this._Budgeted_Cost = value;
}
}
}
[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Anticipated_Cost", DbType="Real")]
public System.Nullable Anticipated_Cost
