-
Notifications
You must be signed in to change notification settings - Fork 1
/
Assets.cs
68 lines (61 loc) · 2.18 KB
/
Assets.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
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 globalexcel4
{
public static string AccountIdentifier;
public static decimal TotalMarketValue, CashBalance;
}
[Table(Name = "Assets")]//Name of SQL Table this Object should be mapped to
class Assets
{
//Compares Assets Object that contains Excel data to Assets object from SQL database and returns true if they are different meaning that rows have been changed in Excel file
//since last insert and returns false if the row has not been changed
public bool compare(Assets obj)
{
if (this.AccountIdentifier != obj.AccountIdentifier)
{
return true;
}
if (this.TotalMarketValue != obj.TotalMarketValue)
{
return true;
}
if (this.CashBalance != obj.CashBalance)
{
return true;
}
return false;
}
//Object properties that will be mapped to SQL Table Columns
private string _AccountIdentifier;
[Column(IsPrimaryKey = true, Storage = "_AccountIdentifier")]
public string AccountIdentifier
{
get { return this._AccountIdentifier; }
set { this._AccountIdentifier = value; }
}
private decimal _TotalMarketValue;
[Column(Storage = "_TotalMarketValue")]
public decimal TotalMarketValue
{
get { return this._TotalMarketValue; }
set { this._TotalMarketValue = value; }
}
private decimal _CashBalance;
[Column(Storage = "_CashBalance")]
public decimal CashBalance
{
get { return this._CashBalance; }
set { this._CashBalance = value; }
}
}
}