コード例 #1
0
        private Charge AddRandomCharge(int employeeId)
        {
            Charge charge =
                new Charge()
                {
                    AccountNumber = this._random.Next(),
                    BilledAmount = this._random.Next(1000),
                    Category = this._random.Next(),
                    Description = this._random.Next().ToString(),
                    EmployeeId = employeeId,
                    ExpenseDate = DateTime.Today,
                    ExpenseType = this._random.Next(),
                    Location = this._random.Next().ToString(),
                    Merchant = this._random.Next().ToString(),
                    Notes = this._random.Next().ToString(),
                    ReceiptRequired = false,
                    TransactionAmount = this._random.Next(1000),
                };

            ExpenseService service = new ExpenseService();
            service.SaveCharge(charge);
            return charge;
        }
コード例 #2
0
 public int SaveCharge(Charge charge)
 {
     using (DbDataContext db = new DbDataContext())
     {
         Charge dbCharge;
         if (charge.ChargeId == 0)
         {
             dbCharge = charge;
             db.Charges.InsertOnSubmit(dbCharge);
         }
         else
         {
             dbCharge = db.Charges.Single(item => item.ChargeId == charge.ChargeId);
             dbCharge.AccountNumber = charge.AccountNumber;
             dbCharge.BilledAmount = charge.BilledAmount;
             dbCharge.Category = charge.Category;
             dbCharge.Description = charge.Description;
             dbCharge.EmployeeId = charge.EmployeeId;
             dbCharge.ExpenseDate = charge.ExpenseDate;
             dbCharge.ExpenseReportId = charge.ExpenseReportId;
             dbCharge.ExpenseType = charge.ExpenseType;
             dbCharge.Location = charge.Location;
             dbCharge.Merchant = charge.Merchant;
             dbCharge.Notes = charge.Notes;
             dbCharge.ReceiptRequired = charge.ReceiptRequired;
             dbCharge.TransactionAmount = charge.TransactionAmount;
         }
         db.SubmitChanges();
         return dbCharge.ChargeId;
     }            
 }
コード例 #3
0
ファイル: Db.designer.cs プロジェクト: BretStateham/AzureLabs
 partial void DeleteCharge(Charge instance);
コード例 #4
0
ファイル: Db.designer.cs プロジェクト: BretStateham/AzureLabs
 partial void UpdateCharge(Charge instance);
コード例 #5
0
ファイル: Db.designer.cs プロジェクト: BretStateham/AzureLabs
 partial void InsertCharge(Charge instance);
コード例 #6
0
ファイル: Db.designer.cs プロジェクト: BretStateham/AzureLabs
		private void detach_Charges(Charge entity)
		{
			this.SendPropertyChanging();
			entity.Employee = null;
		}
コード例 #7
0
ファイル: Db.designer.cs プロジェクト: BretStateham/AzureLabs
		private void attach_Charges(Charge entity)
		{
			this.SendPropertyChanging();
			entity.Employee = this;
		}
コード例 #8
0
ファイル: Db.designer.cs プロジェクト: BretStateham/AzureLabs
		private void detach_Charges(Charge entity)
		{
			this.SendPropertyChanging();
			entity.ExpenseReport = null;
		}
コード例 #9
0
        public void Create_Charge()
        {
            Employee employee = this.AddRandomEmployee();

            Charge charge =
                new Charge()
                {
                    AccountNumber = 0,
                    BilledAmount = 1,
                    Category = 2,
                    Description = "3",
                    EmployeeId = employee.EmployeeId,
                    ExpenseDate = new DateTime(2013, 9, 28),
                    ExpenseType = (int) ChargeType.Business,
                    Location = "4",
                    Merchant = "5",
                    Notes = "6",
                    ReceiptRequired = true,
                    TransactionAmount = 7,
                };

            ExpenseService service = new ExpenseService();

            int chargeId = service.SaveCharge(charge);

            Assert.AreNotEqual(0, chargeId);
            Assert.AreEqual(chargeId, charge.ChargeId);
        }