public void TestGetAllOK()
{
SetUpDB();
PartMapper pm = new PartMapper();
ArrayList a = pm.GetAllParts(conn);
TearDown();
Assert.AreEqual(a.Count, 3);
}
public void TestGetPartOK()
{
SetUpDB();
PartMapper pm = new PartMapper();
Part p = pm.GetPart(2, conn);
TearDown();
Assert.AreEqual(p.partno, 2);
}
public void TestGetPartFail()
{
SetUpDB();
PartMapper pm = new PartMapper();
Part p = pm.GetPart(4, conn);
TearDown();
Assert.AreEqual(p, null);
}
public void TestCreatePartFail()
{
SetUpDB();
PartMapper pm = new PartMapper();
Part p = new Part(2, "PartD", 34.50m, 25);
int rowsupdated = pm.InsertPart(p, conn);
TearDown();
Assert.AreEqual(rowsupdated, 0);
}
public void TestDeletePartFail()
{
SetUpDB();
PartMapper pm = new PartMapper();
int rowsupdated = pm.DeletePart(4, conn);
ArrayList a = pm.GetAllParts(conn);
TearDown();
Assert.AreEqual(rowsupdated, 0);
Assert.AreEqual(a.Count, 3);
}
public void TestDeletePartOK()
{
SetUpDB();
PartMapper pm = new PartMapper();
int rowsupdated = pm.DeletePart(2, conn);
Part p = pm.GetPart(2, conn);
TearDown();
Assert.AreEqual(rowsupdated, 1);
Assert.AreEqual(p, null);
}
public void TestCreatePartOK()
{
SetUpDB();
PartMapper pm = new PartMapper();
Part p = new Part(4, "PartD", 34.50m, 25);
int rowsupdated = pm.InsertPart(p, conn);
Part pnew = pm.GetPart(4, conn);
TearDown();
Assert.AreEqual(rowsupdated, 1);
Assert.AreEqual(pnew.partname, "PartD");
}
public void TestUpdatePartFail()
{
SetUpDB();
PartMapper pm = new PartMapper();
Part p = pm.GetPart(2, conn);
p.partno = 4;
int rowsupdated = pm.UpdatePart(p, conn);
TearDown();
Assert.AreEqual(rowsupdated, 0);
}
public void TestGetAllEmpty()
{
SetUpDB();
PartMapper pm = new PartMapper();
pm.DeletePart(1, conn);
pm.DeletePart(2, conn);
pm.DeletePart(3, conn);
ArrayList a = pm.GetAllParts(conn);
TearDown();
Assert.AreEqual(a.Count, 0);
}
// User view for all parts
public ActionResult ViewAllParts(DirtbikeModel iDirtbikeModel, PartModel iPartModel)
{
// Must be logged in to any role to access this view
if (((LoginModel)Session["loginModel"]) != null)
{
MapperDirtbike map = new MapperDirtbike();
Dirtbike iDirtbike = new Dirtbike();
iDirtbike = map.MapDirtbike(iDirtbikeModel);
DirtbikeBLL selectDirtbike = new DirtbikeBLL();
// Returned list of Dirtbikes from Database
List <Dirtbike> listDirtbike = selectDirtbike.Select(iDirtbike);
/* Get Dirtbike values from database and set it to
* viewbag to pass it to view for drop downlist*/
IEnumerable <SelectListItem> makes = listDirtbike.Select(m => new SelectListItem
{
Value = m.Make,
Text = m.Make
});
ViewBag.Make = makes;
IEnumerable <SelectListItem> makeYear = listDirtbike.Select(m => new SelectListItem
{
Value = m.MakeYear.ToString(),
Text = m.MakeYear.ToString()
});
ViewBag.MakeYear = makeYear;
IEnumerable <SelectListItem> models = listDirtbike.Select(m => new SelectListItem
{
Value = m.Model,
Text = m.Model
});
ViewBag.Model = models;
/* PartModel */
PartMapper partMap = new PartMapper();
Part iPart = new Part();
iPart = partMap.MapDirtbike(iPartModel);
PartBLL selectPart = new PartBLL();
// Create List object for returned parts
List <Part> listParts = selectPart.SelectAllParts(iPart);
return(View(listParts));
}
else
{
return(RedirectToAction("login", "home"));
}
}
public void TestUpdatePartOK()
{
SetUpDB();
PartMapper pm = new PartMapper();
Part p = pm.GetPart(2, conn);
p.price = 1000.50m;
int rowsupdated = pm.UpdatePart(p, conn);
Part pnew = pm.GetPart(2, conn);
TearDown();
Assert.AreEqual(rowsupdated, 1);
Assert.AreEqual(pnew.price, 1000.50m);
}
// User View for specific part
public ActionResult ViewPart(PartModel iPartID)
{
// Must be logged in to any role to access this view
if (((LoginModel)Session["loginModel"]) != null)
{
ViewBag.Title = "Part View";
/* PartModel */
PartMapper partMap = new PartMapper();
Part iPart = new Part();
iPart = partMap.MapDirtbike(iPartID);
PartBLL selectPart = new PartBLL();
// Create List object for returned parts where partID is the same as partID from user clicked part in Parts view
List <Part> part = selectPart.SelectAllParts(iPart).Where(p => p.PartID == iPartID.PartID).ToList();
return(View(part));
}
else
{
return(RedirectToAction("login", "home"));
}
}
