public int Insert()
{
int result = 0;
try
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblBill bill = new tblBill();
bill.Id = Guid.NewGuid();
bill.UserId = this.UserId;
bill.BillDestinationId = this.DesinationId;
bill.DueDate = this.DueDate;
bill.BillAmount = this.BillAmount;
bill.PaidOnTime = this.PaidOnTime;
dc.tblBills.Add(bill);
result = dc.SaveChanges();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Update()
{
try
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
if (this.Id != Guid.Empty)
{
tblUser user = dc.tblUsers.Where(c => c.Id == this.Id).FirstOrDefault();
user.FirstName = this.FirstName;
user.LastName = this.LastName;
user.BillingAddress = this.BillingAddress;
user.Address = this.Address;
user.City = this.City;
user.State = this.State;
user.ZipCode = this.ZipCode;
user.Password = this.Password;
user.Email = this.Email;
return(dc.SaveChanges());
}
else
{
throw new Exception("Id is not set.");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Update()
{
try
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
if (this.Id != Guid.Empty)
{
tblBill bill = dc.tblBills.Where(c => c.Id == this.Id).FirstOrDefault();
bill.UserId = this.UserId;
bill.BillDestinationId = this.DesinationId;
bill.DueDate = this.DueDate;
bill.BillAmount = this.BillAmount;
bill.PaidOnTime = this.PaidOnTime;
return(dc.SaveChanges());
}
else
{
throw new Exception("Id is not set.");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Insert()
{
int result = 0;
try
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblUser user = new tblUser();
user.Id = Guid.NewGuid();
user.FirstName = this.FirstName;
user.LastName = this.LastName;
user.BillingAddress = this.BillingAddress;
user.Address = this.Address;
user.City = this.City;
user.State = this.State;
user.ZipCode = this.ZipCode;
user.Password = this.Password;
user.Email = this.Email;
dc.tblUsers.Add(user);
result = dc.SaveChanges();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblPayment tblpayment = dc.tblPayments.Where(c => c.Description == "UpdatedPayment").FirstOrDefault();
dc.tblPayments.Remove(tblpayment);
dc.SaveChanges();
tblPayment newpayment = dc.tblPayments.Where(c => c.Description == "UpdatedPayment").FirstOrDefault();
Assert.IsNull(newpayment);
}
}
public void DeleteTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblUser tbluser = dc.tblUsers.Where(c => c.FirstName == "Jay").FirstOrDefault();
dc.tblUsers.Remove(tbluser);
dc.SaveChanges();
tblUser newuser = dc.tblUsers.Where(c => c.FirstName == "Jay").FirstOrDefault();
Assert.IsNull(newuser);
}
}
public void DeleteTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblBill tblbill = dc.tblBills.Where(c => c.BillAmount == 100).FirstOrDefault();
dc.tblBills.Remove(tblbill);
dc.SaveChanges();
tblBill newbill = dc.tblBills.Where(c => c.BillAmount == 100).FirstOrDefault();
Assert.IsNull(newbill);
}
}
public void DeleteTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblBillDestination tblbilldestination = dc.tblBillDestinations.Where(c => c.BusinessName == "Chase").FirstOrDefault();
dc.tblBillDestinations.Remove(tblbilldestination);
dc.SaveChanges();
tblBillDestination newdestination = dc.tblBillDestinations.Where(c => c.BusinessName == "Chase").FirstOrDefault();
Assert.IsNull(newdestination);
}
}
public void UpdateTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblPayment tblpayment = dc.tblPayments.Where(c => c.Description == "TestPayment").FirstOrDefault();
tblpayment.Description = "UpdatedPayment";
dc.SaveChanges();
tblPayment newpayment = dc.tblPayments.Where(c => c.Description == "UpdatedPayment").FirstOrDefault();
Assert.AreNotEqual(newpayment.Description, "TestPayment");
}
}
public void UpdateTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblBillDestination tblbilldestination = dc.tblBillDestinations.Where(c => c.BusinessName == "Chase").FirstOrDefault();
tblbilldestination.BusinessAddress = "4401 W Wisconsin Ave";
dc.SaveChanges();
tblBillDestination newdestination = dc.tblBillDestinations.Where(c => c.BusinessAddress == "4401 W Wisconsin Ave").FirstOrDefault();
Assert.AreNotEqual(tblbilldestination.BusinessAddress, "111 E Wisconsin Ave");
}
}
public void UpdateTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblUser tbluser = dc.tblUsers.Where(c => c.Password == "Test1").FirstOrDefault();
tbluser.Password = "******";
dc.SaveChanges();
tblUser newuser = dc.tblUsers.Where(c => c.Password == "TestUpdate").FirstOrDefault();
Assert.AreNotEqual(tbluser.Password, "Test1");
}
}
public void InsertTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblPayment tblpayment = new tblPayment();
tblpayment.Id = Guid.NewGuid();
tblpayment.Description = "TestPayment";
dc.tblPayments.Add(tblpayment);
dc.SaveChanges();
tblPayment newpayment = dc.tblPayments.Where(c => c.Description == "TestPayment").FirstOrDefault();
Assert.AreEqual(newpayment.Description, "TestPayment");
}
}
public void InsertTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblBillDestination tblbilldestination = new tblBillDestination();
tblbilldestination.Id = Guid.NewGuid();
tblbilldestination.BusinessName = "Chase";
tblbilldestination.BusinessAddress = "111 E Wisconsin Ave";
dc.tblBillDestinations.Add(tblbilldestination);
dc.SaveChanges();
tblBillDestination newdestination = dc.tblBillDestinations.Where(c => c.BusinessName == "Chase").FirstOrDefault();
Assert.AreEqual(tblbilldestination.BusinessName, newdestination.BusinessName);
}
}
public int Insert()
{
int result = 0;
try
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblPayment make = new tblPayment();
make.Id = Guid.NewGuid();
make.Description = this.Description;
dc.tblPayments.Add(make);
result = dc.SaveChanges();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblUser user = dc.tblUsers.Where(c => c.FirstName == "Owen").FirstOrDefault();
tblBillDestination destination = dc.tblBillDestinations.Where(c => c.BusinessName == "Spectrum").FirstOrDefault();
tblBill tblbill = new tblBill();
tblbill.Id = Guid.NewGuid();
tblbill.UserId = user.Id;
tblbill.BillDestinationId = destination.Id;
tblbill.BillAmount = 50;
tblbill.DueDate = new DateTime(2019, 5, 1);
tblbill.PaidOnTime = true;
dc.tblBills.Add(tblbill);
dc.SaveChanges();
tblBill newbill = dc.tblBills.Where(c => c.BillAmount == 50).FirstOrDefault();
Assert.AreEqual(newbill.BillAmount, 50);
}
}
public int Update()
{
try
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
if (this.Id != Guid.Empty)
{
tblPayment make = dc.tblPayments.Where(c => c.Id == this.Id).FirstOrDefault();
make.Description = this.Description;
return(dc.SaveChanges());
}
else
{
throw new Exception("Id is not set.");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Insert()
{
int result = 0;
try
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblBillDestination billDestination = new tblBillDestination();
billDestination.Id = Guid.NewGuid();
billDestination.BusinessName = this.BusinessName;
billDestination.BusinessAddress = this.BusinessAddress;
dc.tblBillDestinations.Add(billDestination);
result = dc.SaveChanges();
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int Delete()
{
try
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
if (this.Id != Guid.Empty)
{
tblBillDestination billDestination = dc.tblBillDestinations.Where(c => c.Id == this.Id).FirstOrDefault();
dc.tblBillDestinations.Remove(billDestination);
return(dc.SaveChanges());
}
else
{
throw new Exception("Id is not set.");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void InsertTest()
{
using (BudgetManagementEntities dc = new BudgetManagementEntities())
{
tblUser tbluser = new tblUser();
tbluser.Id = Guid.NewGuid();
tbluser.FirstName = "Jay";
tbluser.LastName = "Hemes";
tbluser.Address = "123 Main Strees";
tbluser.BillingAddress = "123 Main Street";
tbluser.City = "Neenah";
tbluser.State = "Wisconsin";
tbluser.ZipCode = 54956;
tbluser.Password = "******";
tbluser.Email = "*****@*****.**";
dc.tblUsers.Add(tbluser);
dc.SaveChanges();
tblUser newuser = dc.tblUsers.Where(c => c.FirstName == "Jay").FirstOrDefault();
Assert.AreEqual(newuser.FirstName, "Jay");
}
}
