-
Notifications
You must be signed in to change notification settings - Fork 1
/
Activity.cs
93 lines (86 loc) · 2.59 KB
/
Activity.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Linq;
using System.Data.Linq.Mapping;
namespace PCMExceltoSQLDatabase
{
//Class used for collecting Excel Data and then for inputting it into LINQ Entity object which is inserted into Database. It is used since it has all static
//fields so it can be used in a global scope.
public class globalexcel5
{
public static int BusinessID,ActivityID;
public static string Business, Rep, Rep2, InvTeam1, Invteam2, ActivityType;
public static DateTime StartDate;
}
[Table(Name = "Activity")]//Name of SQL Table this Object should be mapped to
class Activity
{
//Object properties that will be mapped to SQL Table Columns
private int _BusinessID;
[Column( Storage = "_BusinessID")]
public int BusinessID
{
get { return this._BusinessID; }
set { this._BusinessID = value; }
}
private int _ActivityID;
[Column(IsPrimaryKey = true, Storage = "_ActivityID")]
public int ActivityID
{
get { return this._ActivityID; }
set { this._ActivityID = value; }
}
private string _Business;
[Column( Storage = "_Business")]
public string Business
{
get { return this._Business; }
set { this._Business = value; }
}
private string _Rep;
[Column(Storage = "_Rep")]
public string Rep
{
get { return this._Rep; }
set { this._Rep = value; }
}
private string _Rep2;
[Column(Storage = "_Rep2")]
public string Rep2
{
get { return this._Rep2; }
set { this._Rep2 = value; }
}
private string _InvTeam1;
[Column( Storage = "_InvTeam1")]
public string InvTeam1
{
get { return this._InvTeam1; }
set { this._InvTeam1 = value; }
}
private string _InvTeam2;
[Column( Storage = "_InvTeam2")]
public string InvTeam2
{
get { return this._InvTeam2; }
set { this._InvTeam2 = value; }
}
private DateTime _StartDate;
[Column(Storage = "_StartDate")]
public DateTime StartDate
{
get { return this._StartDate; }
set { this._StartDate = value; }
}
private string _ActivityType;
[Column(Storage = "_ActivityType")]
public string ActivityType
{
get { return this._ActivityType; }
set { this._ActivityType = value; }
}
}
}