public static ItemPO MapDOtoPO(IItemDO iFrom)
{
ItemPO oTo = new ItemPO(); //creating a new instance
//PO //DO
oTo.ItemID = iFrom.ItemID;
oTo.UserID = iFrom.UserID;
oTo.ItemName = iFrom.ItemName;
oTo.Used = iFrom.Used;
oTo.Description = iFrom.Description;
return(oTo); //return PO
}
public void UpdateItem(IItemDO iItem)
{
try
{
using (SqlConnection connectionToSql = new SqlConnection(_ConnectionString))
{
using (SqlCommand command = new SqlCommand("UPDATE_ITEMS", connectionToSql))
{
try
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 30;
//Passing parameters in from Sql
command.Parameters.AddWithValue("@ItemID", iItem.ItemID);
command.Parameters.AddWithValue("@UserID", iItem.UserID);
command.Parameters.AddWithValue("@ItemName", iItem.ItemName);
command.Parameters.AddWithValue("@Used", iItem.Used);
command.Parameters.AddWithValue("@Description", iItem.Description);
connectionToSql.Open();
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw (e); //throw to outside try catch
}
finally
{
connectionToSql.Close(); //Saftey
connectionToSql.Dispose();
}
}
}
}
catch (Exception e)
{
throw (e); //throw to controller
}
finally
{
//Onshore standards
}
}
public void CreateItem(IItemDO iItem)
{
try
{
using (SqlConnection connectionToSql = new SqlConnection(_ConnectionString))
{
using (SqlCommand command = new SqlCommand("CREATE_ITEMS", connectionToSql))
{
try
{
command.CommandType = CommandType.StoredProcedure;
command.CommandTimeout = 30;
command.Parameters.AddWithValue("@UserID", iItem.UserID);
command.Parameters.AddWithValue("@ItemName", iItem.ItemName);
command.Parameters.AddWithValue("@Used", iItem.Used);
command.Parameters.AddWithValue("@Description", iItem.Description);
connectionToSql.Open();
command.ExecuteNonQuery();
}
catch (Exception e)
{
throw (e); //We are going to log and write the error once it gets to the controller
}
finally
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
}
}
catch (Exception e)
{
throw (e);
}
finally
{
//Onshore Standards
}
}
public ActionResult UpdateItem(ItemVM iItem)
{
ActionResult oResponse = null;
if (Session["Username"] == null || (Int16)Session["Role"] == 3)
{
//Guest & User
oResponse = RedirectToAction("Index", "Home");
}
else
{
if (ModelState.IsValid) //if correct info
{
try
{
//give mapping a variable to be used
IItemDO update = ItemMap.MapPOtoDO(iItem.Item);
//Call the method to be used
ItemAccess.UpdateItem(update);
//Return to the view to see changes
oResponse = RedirectToAction("ViewItems", "Item");
}
catch (Exception e)
{ //for the errors thrown below
iItem.ErrorMessage = "Sorry your request cannot be processed";
ErrorLog.LogError(e);
oResponse = RedirectToAction("UpdateItem", "Item");
}
finally
{
//Onshore standards
}
}
else //if it isn't valid information
{
oResponse = View(iItem); //Return to the Update page to fill out info again
}
}
return(oResponse);
}
public ActionResult UpdateItem(long ItemID)
{
ActionResult oResponse = null;
if (Session["Username"] == null || (Int16)Session["Role"] == 3)
{ //Guest & User
oResponse = RedirectToAction("Index", "Home");
}
else
{
//Create a new instance of the object
ItemVM newVM = new ItemVM();
//set the method to a variable to be used
IItemDO item = ItemAccess.ViewItemsByID(ItemID);
//set mapping to a variable
newVM.Item = ItemMap.MapDOtoPO(item);
//return view
oResponse = View(newVM);
}
return(oResponse);
}
public ActionResult CreateItem(ItemVM iItem)
{
ActionResult oResponse = null; //set to null to determine if valid or not
if (Session["Username"] == null)
{
oResponse = RedirectToAction("Index", "Home");
}
else
{
if (ModelState.IsValid)
{ //if info correct
try
{
//Mapping into a variable
IItemDO Itemform = ItemMap.MapPOtoDO(iItem.Item);
//Using the mehtod in DAL to create item
ItemAccess.CreateItem(Itemform);
//Return the view
oResponse = RedirectToAction("ViewItemsByUserID", "User", new { UserID = (long)Session["UserID"] });
}
catch (Exception e)
{
iItem.ErrorMessage = "We are sorry, we can not process your request";
ErrorLog.LogError(e); //Log error in file
oResponse = View(iItem); //return view
}
finally
{
//Onshore Standards
}
}
else //if info incorrect
{
oResponse = View(iItem); //return to view once on
}
}
return(oResponse); //return view
}
