public ActionResult Edit(string partNumber)
{
PartVM part = _partManager.RetrievePartInformationByPartNumber(partNumber);
ViewBag.Title = "Edit Part Information";
return(View(part));
}
public ActionResult Delete(string partNumber)
{
if (partNumber == null)
{
return(RedirectToAction("Index"));
}
PartVM part = _partManager.RetrievePartInformationByPartNumber(partNumber);
return(View(part));
}
// GET: Repair/Details/5
public ActionResult Details(string id)
{
ViewBag.Title = "Part Details";
List <PartVM> parts = _partsManager.getAllParts();
PartVM part = null;
foreach (PartVM part2 in parts)
{
if (part2.SerialNumber == id)
{
part = part2;
}
}
return(View(part));
}
} // End UpdatePartInformation()
/// <summary>
/// CREATED BY: Matt Deaton
/// DATE CREATED: 2020-05-09
///
/// Method to Select a Part to Move in Inventory.
///
/// </summary>
/// <param name="partNumber"></param>
/// <returns></returns>
public PartVM SelectPartByPartNumberForMovingInventory(string partNumber)
{
PartVM part = null;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_by_part_number", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PartNumber", partNumber);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
part = new PartVM()
{
PartNumber = reader.GetString(0),
Quantity = reader.GetInt32(1),
PartName = reader.GetString(2),
Location = reader.GetString(3),
Description = reader.GetString(4),
Cost = reader.GetDecimal(5)
};
}
}
reader.Close();
}
catch (Exception up)
{
throw up;
}
finally
{
conn.Close();
}
return(part);
} // End SelectPartByPartNumberForMovingInventory()
public List <PartVM> returnAllParts()
{
List <PartVM> parts = new List <PartVM>();
//Declare variables
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_return_all_parts");
//Setup cmd object
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
//Try to execute the query
try
{
conn.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
string partType = reader.GetString(0);
string serialNumber = reader.GetString(1);
Decimal cost = reader.GetDecimal(2);
int lineItemID = reader.IsDBNull(3) ? 0 : reader.GetInt32(3);
PartVM part = new PartVM();
part.setSerialNumber(serialNumber);
part.setPartType(partType);
part.setCost(cost);
part.RepairLineItemID = lineItemID;
parts.Add(part);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(parts);
}
} // End SelectPartByPartNumberForMovingInventory()
/// <summary>
/// CREATED BY: Matt Deaton
/// DATE CREATED: 2020-05-09
///
/// Method to Select Part information by the part number.
///
/// </summary>
/// <param name="partNumber"></param>
/// <returns></returns>
public PartVM SelectPartInformationByPartNumber(string partNumber)
{
PartVM part = null;
var conn = DBConnection.GetConnection();
var cmd = new SqlCommand("sp_select_part_information_by_part_number", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PartNumber", partNumber);
try
{
conn.Open();
var reader = cmd.ExecuteReader();
if (reader.HasRows)
{
reader.Read();
part = new PartVM()
{
PartNumber = reader.GetString(0),
PartName = reader.GetString(1),
Description = reader.GetString(2),
Cost = reader.GetDecimal(3)
};
}
reader.Close();
}
catch (Exception up)
{
throw up;
}
finally
{
conn.Close();
}
return(part);
} // End SelectPartInformationByPartNumber()
