This is the error I get when I build my project and click View in Browser. Any ideas please?
Thanks
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS1519: Invalid token '1' in class, struct, or interface member declaration
Source Error:
Line 690:
Line 691: [XmlAttribute("1stPayment")]
Line 692: public string 1stPayment
Line 693: {
Line 694: get { return GetColumnValue<string>("1st_Payment"); }
Source File: c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs Line: 692
Show Detailed Compiler Output:
c:\windows\system32\inetsrv> "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" /t:library /utf8output /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0
b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\assembly\dl3\f5fcf004\00e18468_1520c801\MySql.Data.DLL" /R:"C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0b77a5c561934e089\System.Data.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0b77a5c561934e089\System.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0
b03f5f7f11d50a3a\System.Web.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\assembly\dl3\32729655\008a80ed_59d9c801\SubSonic.DLL" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.dll" /D:DEBUG /debug+ /optimize- /w:4 /nowarn:1659;1699 "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.8.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.9.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.4.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.5.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.6.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.7.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.0.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.1.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.2.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.3.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.10.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.11.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.12.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.13.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.14.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\project14\4df760c1\c30c3054\App_Code.vl8eegqr.15.cs"
Microsoft ® Visual C# 2005 Compiler version 8.00.50727.42
for Microsoft ® Windows ® 2005 Framework version 2.0.50727
Copyright © Microsoft Corporation 2001-2005. All rights reserved.
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(692,17): error CS1519: Invalid token '1' in class, struct, or interface member declaration
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(693,3): error CS1519: Invalid token '{' in class, struct, or interface member declaration
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(694,8): error CS1519: Invalid token '{' in class, struct, or interface member declaration
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(694,39): error CS1519: Invalid token '(' in class, struct, or interface member declaration
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(696,4): error CS0116: A namespace does not directly contain members such as fields or methods
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(702,10): error CS1518: Expected class, delegate, enum, interface, or struct
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(712,10): error CS1518: Expected class, delegate, enum, interface, or struct
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(722,10): error CS1518: Expected class, delegate, enum, interface, or struct
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(732,10): error CS1518: Expected class, delegate, enum, interface, or struct
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(742,10): error CS1518: Expected class, delegate, enum, interface, or struct
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(752,10): error CS1518: Expected class, delegate, enum, interface, or struct
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(778,17): error CS1518: Expected class, delegate, enum, interface, or struct
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(780,19): error CS1518: Expected class, delegate, enum, interface, or struct
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(841,3): error CS1022: Type or namespace definition, or end-of-file expected
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(711,30): error CS0101: The namespace '<global namespace>' already contains a definition for '?'
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(701,30): (Location of symbol related to previous error)
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(721,34): error CS0101: The namespace '<global namespace>' already contains a definition for '?'
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(701,30): (Location of symbol related to previous error)
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(731,34): error CS0101: The namespace '<global namespace>' already contains a definition for '?'
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(701,30): (Location of symbol related to previous error)
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(741,34): error CS0101: The namespace '<global namespace>' already contains a definition for '?'
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(701,30): (Location of symbol related to previous error)
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(751,23): error CS0101: The namespace '<global namespace>' already contains a definition for '?'
c:\Program Files\ASPRunner.NET4.0\projects\Project1\output\App_Code\Job.cs(701,30): (Location of symbol related to previous error)
Show Complete Compilation Source:
Line 1: using System;
Line 2: using System.Text;
Line 3: using System.Data;
Line 4: using System.Data.SqlClient;
Line 5: using System.Data.Common;
Line 6: using System.Collections;
Line 7: using System.Collections.Generic;
Line 8: using System.ComponentModel;
Line 9: using System.Configuration;
Line 10: using System.Xml;
Line 11: using System.Xml.Serialization;
Line 12: using SubSonic;
Line 13: using SubSonic.Utilities;
Line 14: using System.Web;
Line 15: using System.Threading;
Line 16:
Line 17: namespace Data
Line 18: {
Line 19: /// <summary>
Line 20: /// Strongly-typed collection for the Job class.
Line 21: /// </summary>
Line 22: [Serializable]
Line 23: public partial class JobCollection : ActiveList<Job, JobCollection>
Line 24: {
Line 25: public JobCollection() {}
Line 26:
Line 27: }
Line 28:
Line 29: /// <summary>
Line 30: /// This is an ActiveRecord class which wraps the job table.
Line 31: /// </summary>
Line 32: [Serializable]
Line 33: public partial class Job : ActiveRecord<Job>
Line 34: {
Line 35: #region .ctors and Default Settings
Line 36:
Line 37: public Job()
Line 38: {
Line 39: SetSQLProps();
Line 40: InitSetDefaults();
Line 41: MarkNew();
Line 42: }
Line 43:
Line 44:
Line 45: private void InitSetDefaults() { SetDefaults(); }
Line 46:
Line 47:
Line 48: public Job(bool useDatabaseDefaults)
Line 49: {
Line 50: SetSQLProps();
Line 51: if(useDatabaseDefaults)
Line 52: ForceDefaults();
Line 53: MarkNew();
Line 54: }
Line 55:
Line 56: public Job(object keyID)
Line 57: {
Line 58: SetSQLProps();
Line 59: InitSetDefaults();
Line 60: LoadByKey(keyID);
Line 61: }
Line 62:
Line 63:
Line 64: public Job(string columnName, object columnValue)
Line 65: {
Line 66: SetSQLProps();
Line 67: InitSetDefaults();
Line 68: LoadByParam(columnName,columnValue);
Line 69: }
Line 70:
Line 71:
Line 72: protected static void SetSQLProps() { GetTableSchema(); }
Line 73:
Line 74:
Line 75: #endregion
Line 76:
Line 77: #region Schema and Query Accessor
Line 78: public static Query CreateQuery() { return new Query(Schema); }
Line 79:
Line 80:
Line 81: public static TableSchema.Table Schema
Line 82: {
Line 83: get
Line 84: {
Line 85: if (BaseSchema == null)
Line 86: SetSQLProps();
Line 87: return BaseSchema;
Line 88: }
Line 89:
Line 90: }
Line 91:
Line 92:
Line 93: private static void GetTableSchema()
Line 94: {
Line 95: if(!IsSchemaInitialized)
Line 96: {
Line 97: //Schema declaration
Line 98: TableSchema.Table schema = new TableSchema.Table("job", TableType.Table, DataService.GetInstance("MyProvider"));
Line 99: schema.Columns = new TableSchema.TableColumnCollection();
Line 100: schema.SchemaName = @"";
Line 101: //columns
Line 102:
Line 103: TableSchema.TableColumn colvarOrderDate = new TableSchema.TableColumn(schema);
Line 104: colvarOrderDate.ColumnName = "Order_Date";
Line 105: colvarOrderDate.DataType = DbType.DateTime;
Line 106: colvarOrderDate.MaxLength = 0;
Line 107: colvarOrderDate.AutoIncrement = false;
Line 108: colvarOrderDate.IsNullable = true;
Line 109: colvarOrderDate.IsPrimaryKey = false;
Line 110: colvarOrderDate.IsForeignKey = false;
Line 111: colvarOrderDate.IsReadOnly = false;
Line 112: colvarOrderDate.DefaultSetting = @"";
Line 113: colvarOrderDate.ForeignKeyTableName = "";
Line 114: schema.Columns.Add(colvarOrderDate);
Line 115:
Line 116: TableSchema.TableColumn colvarFileNo = new TableSchema.TableColumn(schema);
Line 117: colvarFileNo.ColumnName = "File_No";
Line 118: colvarFileNo.DataType = DbType.String;
Line 119: colvarFileNo.MaxLength = 50;
Line 120: colvarFileNo.AutoIncrement = false;
Line 121: colvarFileNo.IsNullable = true;
Line 122: colvarFileNo.IsPrimaryKey = false;
Line 123: colvarFileNo.IsForeignKey = false;
Line 124: colvarFileNo.IsReadOnly = false;
Line 125: colvarFileNo.DefaultSetting = @"";
Line 126: colvarFileNo.ForeignKeyTableName = "";
Line 127: schema.Columns.Add(colvarFileNo);
Line 128:
Line 129: TableSchema.TableColumn colvarJobNo = new TableSchema.TableColumn(schema);
Line 130: colvarJobNo.ColumnName = "Job_No";
Line 131: colvarJobNo.DataType = DbType.Int32;
Line 132: colvarJobNo.MaxLength = 50;
Line 133: colvarJobNo.AutoIncrement = true;
Line 134: colvarJobNo.IsNullable = false;
Line 135: colvarJobNo.IsPrimaryKey = true;
Line 136: colvarJobNo.IsForeignKey = false;
Line 137: colvarJobNo.IsReadOnly = false;
Line 138: colvarJobNo.DefaultSetting = @"";
Line 139: colvarJobNo.ForeignKeyTableName = "";
Line 140: schema.Columns.Add(colvarJobNo);
Line 141:
Line 142: TableSchema.TableColumn colvarCustomerId = new TableSchema.TableColumn(schema);
Line 143: colvarCustomerId.ColumnName = "Customer_ID";
Line 144: colvarCustomerId.DataType = DbType.Int32;
Line 145: colvarCustomerId.MaxLength = 10;
Line 146: colvarCustomerId.AutoIncrement = false;
Line 147: colvarCustomerId.IsNullable = true;
Line 148: colvarCustomerId.IsPrimaryKey = false;
Line 149: colvarCustomerId.IsForeignKey = true;
Line 150: colvarCustomerId.IsReadOnly = false;
Line 151: colvarCustomerId.DefaultSetting = @"";
Line 152:
Line 153: colvarCustomerId.ForeignKeyTableName = "";
Line 154: schema.Columns.Add(colvarCustomerId);
Line 155:
Line 156: TableSchema.TableColumn colvarOrderTime = new TableSchema.TableColumn(schema);
Line 157: colvarOrderTime.ColumnName = "Order_Time";
Line 158: colvarOrderTime.DataType = DbType.String;
Line 159: colvarOrderTime.MaxLength = 50;
Line 160: colvarOrderTime.AutoIncrement = false;
Line 161: colvarOrderTime.IsNullable = true;
Line 162: colvarOrderTime.IsPrimaryKey = false;
Line 163: colvarOrderTime.IsForeignKey = false;
Line 164: colvarOrderTime.IsReadOnly = false;
Line 165: colvarOrderTime.DefaultSetting = @"";
Line 166: colvarOrderTime.ForeignKeyTableName = "";
Line 167: schema.Columns.Add(colvarOrderTime);
Line 168:
Line 169: TableSchema.TableColumn colvarContract = new TableSchema.TableColumn(schema);
Line 170: colvarContract.ColumnName = "Contract";
Line 171: colvarContract.DataType = DbType.String;
Line 172: colvarContract.MaxLength = 0;
Line 173: colvarContract.AutoIncrement = false;
Line 174: colvarContract.IsNullable = true;
Line 175: colvarContract.IsPrimaryKey = false;
Line 176: colvarContract.IsForeignKey = false;
Line 177: colvarContract.IsReadOnly = false;
Line 178: colvarContract.DefaultSetting = @"";
Line 179: colvarContract.ForeignKeyTableName = "";
Line 180: schema.Columns.Add(colvarContract);
Line 181:
Line 182: TableSchema.TableColumn colvarOrderSiteAddress = new TableSchema.TableColumn(schema);
Line 183: colvarOrderSiteAddress.ColumnName = "Order_Site_Address";
Line 184: colvarOrderSiteAddress.DataType = DbType.String;
Line 185: colvarOrderSiteAddress.MaxLength = 0;
Line 186: colvarOrderSiteAddress.AutoIncrement = false;
Line 187: colvarOrderSiteAddress.IsNullable = true;
Line 188: colvarOrderSiteAddress.IsPrimaryKey = false;
Line 189: colvarOrderSiteAddress.IsForeignKey = false;
Line 190: colvarOrderSiteAddress.IsReadOnly = false;
Line 191: colvarOrderSiteAddress.DefaultSetting = @"";
Line 192: colvarOrderSiteAddress.ForeignKeyTableName = "";
Line 193: schema.Columns.Add(colvarOrderSiteAddress);
Line 194:
Line 195: TableSchema.TableColumn colvarJobDescription = new TableSchema.TableColumn(schema);
Line 196: colvarJobDescription.ColumnName = "Job_Description";
Line 197: colvarJobDescription.DataType = DbType.String;
Line 198: colvarJobDescription.MaxLength = 0;
Line 199: colvarJobDescription.AutoIncrement = false;
Line 200: colvarJobDescription.IsNullable = true;
Line 201: colvarJobDescription.IsPrimaryKey = false;
Line 202: colvarJobDescription.IsForeignKey = false;
Line 203: colvarJobDescription.IsReadOnly = false;
Line 204: colvarJobDescription.DefaultSetting = @"";
Line 205: colvarJobDescription.ForeignKeyTableName = "";
Line 206: schema.Columns.Add(colvarJobDescription);
Line 207:
Line 208: TableSchema.TableColumn colvarVat = new TableSchema.TableColumn(schema);
Line 209: colvarVat.ColumnName = "VAT";
Line 210: colvarVat.DataType = DbType.String;
Line 211: colvarVat.MaxLength = 0;
Line 212: colvarVat.AutoIncrement = false;
Line 213: colvarVat.IsNullable = true;
Line 214: colvarVat.IsPrimaryKey = false;
Line 215: colvarVat.IsForeignKey = false;
Line 216: colvarVat.IsReadOnly = false;
Line 217: colvarVat.DefaultSetting = @"";
Line 218: colvarVat.ForeignKeyTableName = "";
Line 219: schema.Columns.Add(colvarVat);
Line 220:
Line 221: TableSchema.TableColumn colvarInvoicePrinted = new TableSchema.TableColumn(schema);
Line 222: colvarInvoicePrinted.ColumnName = "Invoice_Printed";
Line 223: colvarInvoicePrinted.DataType = DbType.Boolean;
Line 224: colvarInvoicePrinted.MaxLength = 1;
Line 225: colvarInvoicePrinted.AutoIncrement = false;
Line 226: colvarInvoicePrinted.IsNullable = true;
Line 227: colvarInvoicePrinted.IsPrimaryKey = false;
Line 228: colvarInvoicePrinted.IsForeignKey = false;
Line 229: colvarInvoicePrinted.IsReadOnly = false;
Line 230: colvarInvoicePrinted.DefaultSetting = @"";
Line 231: colvarInvoicePrinted.ForeignKeyTableName = "";
Line 232: schema.Columns.Add(colvarInvoicePrinted);
Line 233:
Line 234: TableSchema.TableColumn colvarInvoicePrintingDate = new TableSchema.TableColumn(schema);
Line 235: colvarInvoicePrintingDate.ColumnName = "Invoice_Printing_Date";
Line 236: colvarInvoicePrintingDate.DataType = DbType.DateTime;
Line 237: colvarInvoicePrintingDate.MaxLength = 0;
Line 238: colvarInvoicePrintingDate.AutoIncrement = false;
Line 239: colvarInvoicePrintingDate.IsNullable = true;
Line 240: colvarInvoicePrintingDate.IsPrimaryKey = false;
Line 241: colvarInvoicePrintingDate.IsForeignKey = false;
Line 242: colvarInvoicePrintingDate.IsReadOnly = false;
Line 243: colvarInvoicePrintingDate.DefaultSetting = @"";
Line 244: colvarInvoicePrintingDate.ForeignKeyTableName = "";
Line 245: schema.Columns.Add(colvarInvoicePrintingDate);
Line 246:
Line 247: TableSchema.TableColumn colvarInvoiceTaxDate = new TableSchema.TableColumn(schema);
Line 248: colvarInvoiceTaxDate.ColumnName = "Invoice_Tax_Date";
Line 249: colvarInvoiceTaxDate.DataType = DbType.DateTime;
Line 250: colvarInvoiceTaxDate.MaxLength = 0;
Line 251: colvarInvoiceTaxDate.AutoIncrement = false;
Line 252: colvarInvoiceTaxDate.IsNullable = true;
Line 253: colvarInvoiceTaxDate.IsPrimaryKey = false;
Line 254: colvarInvoiceTaxDate.IsForeignKey = false;
Line 255: colvarInvoiceTaxDate.IsReadOnly = false;
Line 256: colvarInvoiceTaxDate.DefaultSetting = @"";
Line 257: colvarInvoiceTaxDate.ForeignKeyTableName = "";
Line 258: schema.Columns.Add(colvarInvoiceTaxDate);
Line 259:
Line 260: TableSchema.TableColumn colvarPaymentReceived = new TableSchema.TableColumn(schema);
Line 261: colvarPaymentReceived.ColumnName = "Payment_Received";
Line 262: colvarPaymentReceived.DataType = DbType.Boolean;
Line 263: colvarPaymentReceived.MaxLength = 1;
Line 264: colvarPaymentReceived.AutoIncrement = false;
Line 265: colvarPaymentReceived.IsNullable = true;
Line 266: colvarPaymentReceived.IsPrimaryKey = false;
Line 267: colvarPaymentReceived.IsForeignKey = false;
Line 268: colvarPaymentReceived.IsReadOnly = false;
Line 269: colvarPaymentReceived.DefaultSetting = @"";
Line 270: colvarPaymentReceived.ForeignKeyTableName = "";
Line 271: schema.Columns.Add(colvarPaymentReceived);
Line 272:
Line 273: TableSchema.TableColumn colvarJobFinished = new TableSchema.TableColumn(schema);
Line 274: colvarJobFinished.ColumnName = "Job_Finished";
Line 275: colvarJobFinished.DataType = DbType.Boolean;
Line 276: colvarJobFinished.MaxLength = 1;
Line 277: colvarJobFinished.AutoIncrement = false;
Line 278: colvarJobFinished.IsNullable = true;
Line 279: colvarJobFinished.IsPrimaryKey = false;
Line 280: colvarJobFinished.IsForeignKey = false;
Line 281: colvarJobFinished.IsReadOnly = false;
Line 282: colvarJobFinished.DefaultSetting = @"";
Line 283: colvarJobFinished.ForeignKeyTableName = "";
Line 284: schema.Columns.Add(colvarJobFinished);
Line 285:
Line 286: TableSchema.TableColumn colvarCustomerRef = new TableSchema.TableColumn(schema);
Line 287: colvarCustomerRef.ColumnName = "CustomerRef";
Line 288: colvarCustomerRef.DataType = DbType.String;
Line 289: colvarCustomerRef.MaxLength = 50;
Line 290: colvarCustomerRef.AutoIncrement = false;
Line 291: colvarCustomerRef.IsNullable = true;
Line 292: colvarCustomerRef.IsPrimaryKey = false;
Line 293: colvarCustomerRef.IsForeignKey = false;
Line 294: colvarCustomerRef.IsReadOnly = false;
Line 295: colvarCustomerRef.DefaultSetting = @"";
Line 296: colvarCustomerRef.ForeignKeyTableName = "";
Line 297: schema.Columns.Add(colvarCustomerRef);
Line 298:
Line 299: TableSchema.TableColumn colvarCustomerName = new TableSchema.TableColumn(schema);
Line 300: colvarCustomerName.ColumnName = "Customer_Name";
Line 301: colvarCustomerName.DataType = DbType.String;
Line 302: colvarCustomerName.MaxLength = 50;
Line 303: colvarCustomerName.AutoIncrement = false;
Line 304: colvarCustomerName.IsNullable = true;
Line 305: colvarCustomerName.IsPrimaryKey = false;
Line 306: colvarCustomerName.IsForeignKey = false;
Line 307: colvarCustomerName.IsReadOnly = false;
Line 308: colvarCustomerName.DefaultSetting = @"";
Line 309: colvarCustomerName.ForeignKeyTableName = "";
Line 310: schema.Columns.Add(colvarCustomerName);
Line 311:
Line 312: TableSchema.TableColumn colvarPaymentDueDate = new TableSchema.TableColumn(schema);
Line 313: colvarPaymentDueDate.ColumnName = "Payment_Due_date";
Line 314: colvarPaymentDueDate.DataType = DbType.DateTime;
Line 315: colvarPaymentDueDate.MaxLength = 0;
Line 316: colvarPaymentDueDate.AutoIncrement = false;
Line 317: colvarPaymentDueDate.IsNullable = true;
Line 318: colvarPaymentDueDate.IsPrimaryKey = false;
Line 319: colvarPaymentDueDate.IsForeignKey = false;
Line 320: colvarPaymentDueDate.IsReadOnly = false;
Line 321: colvarPaymentDueDate.DefaultSetting = @"";
Line 322: colvarPaymentDueDate.ForeignKeyTableName = "";
Line 323: schema.Columns.Add(colvarPaymentDueDate);
Line 324:
Line 325: TableSchema.TableColumn colvarPaymentDate = new TableSchema.TableColumn(schema);
Line 326: colvarPaymentDate.ColumnName = "Payment_Date";
Line 327: colvarPaymentDate.DataType = DbType.DateTime;
Line 328: colvarPaymentDate.MaxLength = 0;
Line 329: colvarPaymentDate.AutoIncrement = false;
Line 330: colvarPaymentDate.IsNullable = true;
Line 331: colvarPaymentDate.IsPrimaryKey = false;
Line 332: colvarPaymentDate.IsForeignKey = false;
Line 333: colvarPaymentDate.IsReadOnly = false;
Line 334: colvarPaymentDate.DefaultSetting = @"";
Line 335: colvarPaymentDate.ForeignKeyTableName = "";
Line 336: schema.Columns.Add(colvarPaymentDate);
Line 337:
Line 338: TableSchema.TableColumn colvarLocked = new TableSchema.TableColumn(schema);
Line 339: colvarLocked.ColumnName = "Locked";
Line 340: colvarLocked.DataType = DbType.Boolean;
Line 341: colvarLocked.MaxLength = 1;
Line 342: colvarLocked.AutoIncrement = false;
Line 343: colvarLocked.IsNullable = true;
Line 344: colvarLocked.IsPrimaryKey = false;
Line 345: colvarLocked.IsForeignKey = false;
Line 346: colvarLocked.IsReadOnly = false;
Line 347: colvarLocked.DefaultSetting = @"";
Line 348: colvarLocked.ForeignKeyTableName = "";
Line 349: schema.Columns.Add(colvarLocked);
Line 350:
Line 351: TableSchema.TableColumn colvarNote = new TableSchema.TableColumn(schema);
Line 352: colvarNote.ColumnName = "Note";
Line 353: colvarNote.DataType = DbType.String;
Line 354: colvarNote.MaxLength = 255;
Line 355: colvarNote.AutoIncrement = false;
Line 356: colvarNote.IsNullable = true;
Line 357: colvarNote.IsPrimaryKey = false;
Line 358: colvarNote.IsForeignKey = false;
Line 359: colvarNote.IsReadOnly = false;
Line 360: colvarNote.DefaultSetting = @"";
Line 361: colvarNote.ForeignKeyTableName = "";
Line 362: schema.Columns.Add(colvarNote);
Line 363:
Line 364: TableSchema.TableColumn colvarDateAdded = new TableSchema.TableColumn(schema);
Line 365: colvarDateAdded.ColumnName = "Date_Added";
Line 366: colvarDateAdded.DataType = DbType.DateTime;
Line 367: colvarDateAdded.MaxLength = 0;
Line 368: colvarDateAdded.AutoIncrement = false;
Line 369: colvarDateAdded.IsNullable = true;
Line 370: colvarDateAdded.IsPrimaryKey = false;
Line 371: colvarDateAdded.IsForeignKey = false;
Line 372: colvarDateAdded.IsReadOnly = false;
Line 373: colvarDateAdded.DefaultSetting = @"";
Line 374: colvarDateAdded.ForeignKeyTableName = "";
Line 375: schema.Columns.Add(colvarDateAdded);
Line 376:
Line 377: TableSchema.TableColumn colvar1stPayment = new TableSchema.TableColumn(schema);
Line 378: colvar1stPayment.ColumnName = "1st_Payment";
Line 379: colvar1stPayment.DataType = DbType.String;
Line 380: colvar1stPayment.MaxLength = 0;
Line 381: colvar1stPayment.AutoIncrement = false;
Line 382: colvar1stPayment.IsNullable = true;
Line 383: colvar1stPayment.IsPrimaryKey = false;
Line 384: colvar1stPayment.IsForeignKey = false;
Line 385: colvar1stPayment.IsReadOnly = false;
Line 386: colvar1stPayment.DefaultSetting = @"";
Line 387: colvar1stPayment.ForeignKeyTableName = "";
Line 388: schema.Columns.Add(colvar1stPayment);
Line 389:
Line 390: TableSchema.TableColumn colvar2ndPayment = new TableSchema.TableColumn(schema);
Line 391: colvar2ndPayment.ColumnName = "2nd_Payment";
Line 392: colvar2ndPayment.DataType = DbType.String;
Line 393: colvar2ndPayment.MaxLength = 0;
Line 394: colvar2ndPayment.AutoIncrement = false;
Line 395: colvar2ndPayment.IsNullable = true;
Line 396: colvar2ndPayment.IsPrimaryKey = false;
Line 397: colvar2ndPayment.IsForeignKey = false;
Line 398: colvar2ndPayment.IsReadOnly = false;
Line 399: colvar2ndPayment.DefaultSetting = @"";
Line 400: colvar2ndPayment.ForeignKeyTableName = "";
Line 401: schema.Columns.Add(colvar2ndPayment);
Line 402:
Line 403: TableSchema.TableColumn colvar3rdPayment = new TableSchema.TableColumn(schema);
Line 404: colvar3rdPayment.ColumnName = "3rd_Payment";
Line 405: colvar3rdPayment.DataType = DbType.String;
Line 406: colvar3rdPayment.MaxLength = 0;
Line 407: colvar3rdPayment.AutoIncrement = false;
Line 408: colvar3rdPayment.IsNullable = true;
Line 409: colvar3rdPayment.IsPrimaryKey = false;
Line 410: colvar3rdPayment.IsForeignKey = false;
Line 411: colvar3rdPayment.IsReadOnly = false;
Line 412: colvar3rdPayment.DefaultSetting = @"";
Line 413: colvar3rdPayment.ForeignKeyTableName = "";
Line 414: schema.Columns.Add(colvar3rdPayment);
Line 415:
Line 416: TableSchema.TableColumn colvar1stPaymentDate = new TableSchema.TableColumn(schema);
Line 417: colvar1stPaymentDate.ColumnName = "1st_Payment_Date";
Line 418: colvar1stPaymentDate.DataType = DbType.DateTime;
Line 419: colvar1stPaymentDate.MaxLength = 0;
Line 420: colvar1stPaymentDate.AutoIncrement = false;
Line 421: colvar1stPaymentDate.IsNullable = true;
Line 422: colvar1stPaymentDate.IsPrimaryKey = false;
Line 423: colvar1stPaymentDate.IsForeignKey = false;
Line 424: colvar1stPaymentDate.IsReadOnly = false;
Line 425: colvar1stPaymentDate.DefaultSetting = @"";
Line 426: colvar1stPaymentDate.ForeignKeyTableName = "";
Line 427: schema.Columns.Add(colvar1stPaymentDate);
Line 428:
Line 429: TableSchema.TableColumn colvar2ndPaymentDate = new TableSchema.TableColumn(schema);
Line 430: colvar2ndPaymentDate.ColumnName = "2nd_Payment_Date";
Line 431: colvar2ndPaymentDate.DataType = DbType.DateTime;
Line 432: colvar2ndPaymentDate.MaxLength = 0;
Line 433: colvar2ndPaymentDate.AutoIncrement = false;
Line 434: colvar2ndPaymentDate.IsNullable = true;
Line 435: colvar2ndPaymentDate.IsPrimaryKey = false;
Line 436: colvar2ndPaymentDate.IsForeignKey = false;
Line 437: colvar2ndPaymentDate.IsReadOnly = false;
Line 438: colvar2ndPaymentDate.DefaultSetting = @"";
Line 439: colvar2ndPaymentDate.ForeignKeyTableName = "";
Line 440: schema.Columns.Add(colvar2ndPaymentDate);
Line 441:
Line 442: TableSchema.TableColumn colvar3rdPaymentDate = new TableSchema.TableColumn(schema);
Line 443: colvar3rdPaymentDate.ColumnName = "3rd_Payment_Date";
Line 444: colvar3rdPaymentDate.DataType = DbType.DateTime;
Line 445: colvar3rdPaymentDate.MaxLength = 0;
Line 446: colvar3rdPaymentDate.AutoIncrement = false;
Line 447: colvar3rdPaymentDate.IsNullable = true;
Line 448: colvar3rdPaymentDate.IsPrimaryKey = false;
Line 449: colvar3rdPaymentDate.IsForeignKey = false;
Line 450: colvar3rdPaymentDate.IsReadOnly = false;
Line 451: colvar3rdPaymentDate.DefaultSetting = @"";
Line 452: colvar3rdPaymentDate.ForeignKeyTableName = "";
Line 453: schema.Columns.Add(colvar3rdPaymentDate);
Line 454:
Line 455: TableSchema.TableColumn colvarVas = new TableSchema.TableColumn(schema);
Line 456: colvarVas.ColumnName = "VAS";
Line 457: colvarVas.DataType = DbType.String;
Line 458: colvarVas.MaxLength = 0;
Line 459: colvarVas.AutoIncrement = false;
Line 460: colvarVas.IsNullable = false;
Line 461: colvarVas.IsPrimaryKey = false;
Line 462: colvarVas.IsForeignKey = false;
Line 463: colvarVas.IsReadOnly = false;
Line 464: colvarVas.DefaultSetting = @"";
Line 465: colvarVas.ForeignKeyTableName = "";
Line 466: schema.Columns.Add(colvarVas);
Line 467:
Line 468: BaseSchema = schema;
Line 469: //add this schema to the provider
Line 470: //so we can query it later
Line 471: DataService.Providers["MyProvider"].AddSchema("job",schema);
Line 472: }
Line 473:
Line 474: }
Line 475:
Line 476: #endregion
Line 477:
Line 478: #region Props
Line 479:
Line 480:
Line 481: [XmlAttribute("OrderDate")]
Line 482: public DateTime? OrderDate
Line 483: {
Line 484: get { return GetColumnValue<DateTime?>("Order_Date"); }
Line 485:
Line 486: set { SetColumnValue("Order_Date", value); }
Line 487:
Line 488: }
Line 489:
Line 490:
Line 491: [XmlAttribute("FileNo")]
Line 492: public string FileNo
Line 493: {
Line 494: get { return GetColumnValue<string>("File_No"); }
Line 495:
Line 496: set { SetColumnValue("File_No", value); }
Line 497:
Line 498: }
Line 499:
Line 500:
Line 501: [XmlAttribute("JobNo")]
Line 502: public int JobNo
Line 503: {
Line 504: get { return GetColumnValue<int>("Job_No"); }
Line 505:
Line 506: set { SetColumnValue("Job_No", value); }
Line 507:
Line 508: }
Line 509:
Line 510:
Line 511: [XmlAttribute("CustomerId")]
Line 512: public int? CustomerId
Line 513: {
Line 514: get { return GetColumnValue<int?>("Customer_ID"); }
Line 515:
Line 516: set { SetColumnValue("Customer_ID", value); }
Line 517:
Line 518: }
Line 519:
Line 520:
Line 521: [XmlAttribute("OrderTime")]
Line 522: public string OrderTime
Line 523: {
Line 524: get { return GetColumnValue<string>("Order_Time"); }
Line 525:
Line 526: set { SetColumnValue("Order_Time", value); }
Line 527:
Line 528: }
Line 529:
Line 530:
Line 531: [XmlAttribute("Contract")]
Line 532: public string Contract
Line 533: {
Line 534: get { return GetColumnValue<string>("Contract"); }
Line 535:
Line 536: set { SetColumnValue("Contract", value); }
Line 537:
Line 538: }
Line 539:
Line 540:
Line 541: [XmlAttribute("OrderSiteAddress")]
Line 542: public string OrderSiteAddress
Line 543: {
Line 544: get { return GetColumnValue<string>("Order_Site_Address"); }
Line 545:
Line 546: set { SetColumnValue("Order_Site_Address", value); }
Line 547:
Line 548: }
Line 549:
Line 550:
Line 551: [XmlAttribute("JobDescription")]
Line 552: public string JobDescription
Line 553: {
Line 554: get { return GetColumnValue<string>("Job_Description"); }
Line 555:
Line 556: set { SetColumnValue("Job_Description", value); }
Line 557:
Line 558: }
Line 559:
Line 560:
Line 561: [XmlAttribute("Vat")]
Line 562: public string Vat
Line 563: {
Line 564: get { return GetColumnValue<string>("VAT"); }
Line 565:
Line 566: set { SetColumnValue("VAT", value); }
Line 567:
Line 568: }
Line 569:
Line 570:
Line 571: [XmlAttribute("InvoicePrinted")]
Line 572: public bool? InvoicePrinted
Line 573: {
Line 574: get { return GetColumnValue<bool?>("Invoice_Printed"); }
Line 575:
Line 576: set { SetColumnValue("Invoice_Printed", value); }
Line 577:
Line 578: }
Line 579:
Line 580:
Line 581: [XmlAttribute("InvoicePrintingDate")]
Line 582: public DateTime? InvoicePrintingDate
Line 583: {
Line 584: get { return GetColumnValue<DateTime?>("Invoice_Printing_Date"); }
Line 585:
Line 586: set { SetColumnValue("Invoice_Printing_Date", value); }
Line 587:
Line 588: }
Line 589:
Line 590:
Line 591: [XmlAttribute("InvoiceTaxDate")]
Line 592: public DateTime? InvoiceTaxDate
Line 593: {
Line 594: get { return GetColumnValue<DateTime?>("Invoice_Tax_Date"); }
Line 595:
Line 596: set { SetColumnValue("Invoice_Tax_Date", value); }
Line 597:
Line 598: }
Line 599:
Line 600:
Line 601: [XmlAttribute("PaymentReceived")]
Line 602: public bool? PaymentReceived
Line 603: {
Line 604: get { return GetColumnValue<bool?>("Payment_Received"); }
Line 605:
Line 606: set { SetColumnValue("Payment_Received", value); }
Line 607:
Line 608: }
Line 609:
Line 610:
Line 611: [XmlAttribute("JobFinished")]
Line 612: public bool? JobFinished
Line 613: {
Line 614: get { return GetColumnValue<bool?>("Job_Finished"); }
Line 615:
Line 616: set { SetColumnValue("Job_Finished", value); }
Line 617:
Line 618: }
Line 619:
Line 620:
Line 621: [XmlAttribute("CustomerRef")]
Line 622: public string CustomerRef
Line 623: {
Line 624: get { return GetColumnValue<string>("CustomerRef"); }
Line 625:
Line 626: set { SetColumnValue("CustomerRef", value); }
Line 627:
Line 628: }
Line 629:
Line 630:
Line 631: [XmlAttribute("CustomerName")]
Line 632: public string CustomerName
Line 633: {
Line 634: get { return GetColumnValue<string>("Customer_Name"); }
Line 635:
Line 636: set { SetColumnValue("Customer_Name", value); }
Line 637:
Line 638: }
Line 639:
Line 640:
Line 641: [XmlAttribute("PaymentDueDate")]
Line 642: public DateTime? PaymentDueDate
Line 643: {
Line 644: get { return GetColumnValue<DateTime?>("Payment_Due_date"); }
Line 645:
Line 646: set { SetColumnValue("Payment_Due_date", value); }
Line 647:
Line 648: }
Line 649:
Line 650:
Line 651: [XmlAttribute("PaymentDate")]
Line 652: public DateTime? PaymentDate
Line 653: {
Line 654: get { return GetColumnValue<DateTime?>("Payment_Date"); }
Line 655:
Line 656: set { SetColumnValue("Payment_Date", value); }
Line 657:
Line 658: }
Line 659:
Line 660:
Line 661: [XmlAttribute("Locked")]
Line 662: public bool? Locked
Line 663: {
Line 664: get { return GetColumnValue<bool?>("Locked"); }
Line 665:
Line 666: set { SetColumnValue("Locked", value); }
Line 667:
Line 668: }
Line 669:
Line 670:
Line 671: [XmlAttribute("Note")]
Line 672: public string Note
Line 673: {
Line 674: get { return GetColumnValue<string>("Note"); }
Line 675:
Line 676: set { SetColumnValue("Note", value); }
Line 677:
Line 678: }
Line 679:
Line 680:
Line 681: [XmlAttribute("DateAdded")]
Line 682: public DateTime? DateAdded
Line 683: {
Line 684: get { return GetColumnValue<DateTime?>("Date_Added"); }
Line 685:
Line 686: set { SetColumnValue("Date_Added", value); }
Line 687:
Line 688: }
Line 689:
Line 690:
Line 691: [XmlAttribute("1stPayment")]
Line 692: public string 1stPayment
Line 693: {
Line 694: get { return GetColumnValue<string>("1st_Payment"); }
Line 695:
Line 696: set { SetColumnValue("1st_Payment", value); }
Line 697:
Line 698: }
Line 699:
Line 700:
Line 701: [XmlAttribute("2ndPayment")]
Line 702: public string 2ndPayment
Line 703: {
Line 704: get { return GetColumnValue<string>("2nd_Payment"); }
Line 705:
Line 706: set { SetColumnValue("2nd_Payment", value); }
Line 707:
Line 708: }
Line 709:
Line 710:
Line 711: [XmlAttribute("3rdPayment")]
Line 712: public string 3rdPayment
Line 713: {
Line 714: get { return GetColumnValue<string>("3rd_Payment"); }
Line 715:
Line 716: set { SetColumnValue("3rd_Payment", value); }
Line 717:
Line 718: }
Line 719:
Line 720:
Line 721: [XmlAttribute("1stPaymentDate")]
Line 722: public DateTime? 1stPaymentDate
Line 723: {
Line 724: get { return GetColumnValue<DateTime?>("1st_Payment_Date"); }
Line 725:
Line 726: set { SetColumnValue("1st_Payment_Date", value); }
Line 727:
Line 728: }
Line 729:
Line 730:
Line 731: [XmlAttribute("2ndPaymentDate")]
Line 732: public DateTime? 2ndPaymentDate
Line 733: {
Line 734: get { return GetColumnValue<DateTime?>("2nd_Payment_Date"); }
Line 735:
Line 736: set { SetColumnValue("2nd_Payment_Date", value); }
Line 737:
Line 738: }
Line 739:
Line 740:
Line 741: [XmlAttribute("3rdPaymentDate")]
Line 742: public DateTime? 3rdPaymentDate
Line 743: {
Line 744: get { return GetColumnValue<DateTime?>("3rd_Payment_Date"); }
Line 745:
Line 746: set { SetColumnValue("3rd_Payment_Date", value); }
Line 747:
Line 748: }
Line 749:
Line 750:
Line 751: [XmlAttribute("Vas")]
Line 752: public string Vas
Line 753: {
Line 754: get { return GetColumnValue<string>("VAS"); }
Line 755:
Line 756: set { SetColumnValue("VAS", value); }
Line 757:
Line 758: }
Line 759:
Line 760:
Line 761: #endregion
Line 762:
Line 763:
Line 764:
Line 765:
Line 766: //no foreign key tables defined (0)
Line 767:
Line 768:
Line 769:
Line 770: //no ManyToMany tables defined (0)
Line 771:
Line 772: #region ObjectDataSource support
Line 773:
Line 774:
Line 775: /// <summary>
Line 776: /// Inserts a record, can be used with the Object Data Source
Line 777: /// </summary>
Line 778: public static void Insert(DateTime? varOrderDate,string varFileNo,int? varCustomerId,string varOrderTime,string varContract,string varOrderSiteAddress,string varJobDescription,string varVat,bool? varInvoicePrinted,DateTime? varInvoicePrintingDate,DateTime? varInvoiceTaxDate,bool? varPaymentReceived,bool? varJobFinished,string varCustomerRef,string varCustomerName,DateTime? varPaymentDueDate,DateTime? varPaymentDate,bool? varLocked,string varNote,DateTime? varDateAdded,string var1stPayment,string var2ndPayment,string var3rdPayment,DateTime? var1stPaymentDate,DateTime? var2ndPaymentDate,DateTime? var3rdPaymentDate,string varVas)
Line 779: {
Line 780: Job item = new Job();
Line 781:
Line 782: item.OrderDate = varOrderDate;
Line 783:
Line 784: item.FileNo = varFileNo;
Line 785:
Line 786: item.CustomerId = varCustomerId;
Line 787:
Line 788: item.OrderTime = varOrderTime;
Line 789:
Line 790: item.Contract = varContract;
Line 791:
Line 792: item.OrderSiteAddress = varOrderSiteAddress;
Line 793:
Line 794: item.JobDescription = varJobDescription;
Line 795:
Line 796: item.Vat = varVat;
Line 797:
Line 798: item.InvoicePrinted = varInvoicePrinted;
Line 799:
Line 800: item.InvoicePrintingDate = varInvoicePrintingDate;
Line 801:
Line 802: item.InvoiceTaxDate = varInvoiceTaxDate;
Line 803:
Line 804: item.PaymentReceived = varPaymentReceived;
Line 805:
Line 806: item.JobFinished = varJobFinished;
Line 807:
Line 808: item.CustomerRef = varCustomerRef;
Line 809:
Line 810: item.CustomerName = varCustomerName;
Line 811:
Line 812: item.PaymentDueDate = varPaymentDueDate;
Line 813:
Line 814: item.PaymentDate = varPaymentDate;
Line 815:
Line 816: item.Locked = varLocked;
Line 817:
Line 818: item.Note = varNote;
Line 819:
Line 820: item.DateAdded = varDateAdded;
Line 821:
Line 822: item.1stPayment = var1stPayment;
Line 823:
Line 824: item.2ndPayment = var2ndPayment;
Line 825:
Line 826: item.3rdPayment = var3rdPayment;
Line 827:
Line 828: item.1stPaymentDate = var1stPaymentDate;
Line 829:
Line 830: item.2ndPaymentDate = var2ndPaymentDate;
Line 831:
Line 832: item.3rdPaymentDate = var3rdPaymentDate;
Line 833:
Line 834: item.Vas = varVas;
Line 835:
Line 836:
Line 837: if (HttpContext.Current != null)
Line 838: item.Save(HttpContext.Current.User.Identity.Name);
Line 839: else
Line 840: item.Save(Thread.CurrentPrincipal.Identity.Name);
Line 841: }
Line 842:
Line 843:
Line 844: /// <summary>
Line 845: /// Updates a record, can be used with the Object Data Source
Line 846: /// </summary>
Line 847: public static void Update(DateTime? varOrderDate,string varFileNo,int varJobNo,int? varCustomerId,string varOrderTime,string varContract,string varOrderSiteAddress,string varJobDescription,string varVat,bool? varInvoicePrinted,DateTime? varInvoicePrintingDate,DateTime? varInvoiceTaxDate,bool? varPaymentReceived,bool? varJobFinished,string varCustomerRef,string varCustomerName,DateTime? varPaymentDueDate,DateTime? varPaymentDate,bool? varLocked,string varNote,DateTime? varDateAdded,string var1stPayment,string var2ndPayment,string var3rdPayment,DateTime? var1stPaymentDate,DateTime? var2ndPaymentDate,DateTime? var3rdPaymentDate,string varVas)
Line 848: {
Line 849: Job item = new Job();
Line 850:
Line 851: item.OrderDate = varOrderDate;
Line 852:
Line 853: item.FileNo = varFileNo;
Line 854:
Line 855: item.JobNo = varJobNo;
Line 856:
Line 857: item.CustomerId = varCustomerId;
Line 858:
Line 859: item.OrderTime = varOrderTime;
Line 860:
Line 861: item.Contract = varContract;
Line 862:
Line 863: item.OrderSiteAddress = varOrderSiteAddress;
Line 864:
Line 865: item.JobDescription = varJobDescription;
Line 866:
Line 867: item.Vat = varVat;
Line 868:
Line 869: item.InvoicePrinted = varInvoicePrinted;
Line 870:
Line 871: item.InvoicePrintingDate = varInvoicePrintingDate;
Line 872:
Line 873: item.InvoiceTaxDate = varInvoiceTaxDate;
Line 874:
Line 875: item.PaymentReceived = varPaymentReceived;
Line 876:
Line 877: item.JobFinished = varJobFinished;
Line 878:
Line 879: item.CustomerRef = varCustomerRef;
Line 880:
Line 881: item.CustomerName = varCustomerName;
Line 882:
Line 883: item.PaymentDueDate = varPaymentDueDate;
Line 884:
Line 885: item.PaymentDate = varPaymentDate;
Line 886:
Line 887: item.Locked = varLocked;
Line 888:
Line 889: item.Note = varNote;
Line 890:
Line 891: item.DateAdded = varDateAdded;
Line 892:
Line 893: item.1stPayment = var1stPayment;
Line 894:
Line 895: item.2ndPayment = var2ndPayment;
Line 896:
Line 897: item.3rdPayment = var3rdPayment;
Line 898:
Line 899: item.1stPaymentDate = var1stPaymentDate;
Line 900:
Line 901: item.2ndPaymentDate = var2ndPaymentDate;
Line 902:
Line 903: item.3rdPaymentDate = var3rdPaymentDate;
Line 904:
Line 905: item.Vas = varVas;
Line 906:
Line 907: item.IsNew = false;
Line 908: if (HttpContext.Current != null)
Line 909: item.Save(HttpContext.Current.User.Identity.Name);
Line 910: else
Line 911: item.Save(Thread.CurrentPrincipal.Identity.Name);
Line 912: }
Line 913:
Line 914: #endregion
Line 915: #region Columns Struct
Line 916: public struct Columns
Line 917: {
Line 918: int i;
Line 919: public static string OrderDate = @"Order_Date";
Line 920: public static string FileNo = @"File_No";
Line 921: public static string JobNo = @"Job_No";
Line 922: public static string CustomerId = @"Customer_ID";
Line 923: public static string OrderTime = @"Order_Time";
Line 924: public static string Contract = @"Contract";
Line 925: public static string OrderSiteAddress = @"Order_Site_Address";
Line 926: public static string JobDescription = @"Job_Description";
Line 927: public static string Vat = @"VAT";
Line 928: public static string InvoicePrinted = @"Invoice_Printed";
Line 929: public static string InvoicePrintingDate = @"Invoice_Printing_Date";
Line 930: public static string InvoiceTaxDate = @"Invoice_Tax_Date";
Line 931: public static string PaymentReceived = @"Payment_Received";
Line 932: public static string JobFinished = @"Job_Finished";
Line 933: public static string CustomerRef = @"CustomerRef";
Line 934: public static string CustomerName = @"Customer_Name";
Line 935: public static string PaymentDueDate = @"Payment_Due_date";
Line 936: public static string PaymentDate = @"Payment_Date";
Line 937: public static string Locked = @"Locked";
Line 938: public static string Note = @"Note";
Line 939: public static string DateAdded = @"Date_Added";
Line 940: public static string 1stPayment = @"1st_Payment";
Line 941: public static string 2ndPayment = @"2nd_Payment";
Line 942: public static string 3rdPayment = @"3rd_Payment";
Line 943: public static string 1stPaymentDate = @"1st_Payment_Date";
Line 944: public static string 2ndPaymentDate = @"2nd_Payment_Date";
Line 945: public static string 3rdPaymentDate = @"3rd_Payment_Date";
Line 946: public static string Vas = @"VAS";
Line 947:
Line 948: }
Line 949:
Line 950: #endregion
Line 951: }
Line 952:
Line 953: }
Line 954:
Line 955:
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42