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())
{
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 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 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 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;
}
}
