// Get All
public IEnumerable <MotorcycleInfo> GetAllMotorcycle()
{
List <MotorcycleInfo> motorcycleList = new List <MotorcycleInfo>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SP_GetAllMotorcycle", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
MotorcycleInfo motorcycle = new MotorcycleInfo();
motorcycle.VINNumber = dr["VINNumber"].ToString();
motorcycle.ESCNumber = dr["ESCNumber"].ToString();
motorcycle.Owner = dr["Owner"].ToString();
motorcycle.Year = (int)dr["Year"];
motorcycle.Make = dr["Make"].ToString();
motorcycle.Model = dr["Model"].ToString();
motorcycle.TurnInDate = dr["TurnInDate"].ToString();
motorcycle.DateAcquired = dr["DateAcquired"].ToString();
motorcycle.EngineCC = dr["EngineCC"].ToString();
motorcycle.SiteID = dr["SiteID"].ToString();
motorcycle.SiteLocation = dr["SiteLocation"].ToString();
motorcycle.PurchasePrice = dr["PurchasePrice"].ToString();
motorcycle.CurrentValue = dr["CurrentValue"].ToString();
motorcycleList.Add(motorcycle);
}
con.Close();
}
return(motorcycleList);
}
public MotorcycleInfo GetMotorcycleByVIN(string vinNumber)
{
MotorcycleInfo emp = new MotorcycleInfo();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SP_GetMotorcycleById", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VINNumber", vinNumber);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
emp.VINNumber = dr["VINNumber"].ToString();
emp.ESCNumber = dr["ESCNumber"].ToString();
emp.Owner = dr["Owner"].ToString();
emp.Year = Convert.ToInt32(dr["Year"].ToString());
emp.Make = dr["Make"].ToString();
emp.Model = dr["Model"].ToString();
emp.TurnInDate = dr["TurnInDate"].ToString();
emp.DateAcquired = dr["DateAcquired"].ToString();
emp.EngineCC = dr["EngineCC"].ToString();
emp.SiteID = dr["SiteID"].ToString();
emp.SiteLocation = dr["SiteLocation"].ToString();
emp.PurchasePrice = dr["PurchasePrice"].ToString();
emp.CurrentValue = dr["CurrentValue"].ToString();
}
con.Close();
}
return(emp);
}
public void UpdateMotorcycle(MotorcycleInfo motorcycle)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SP_UpdateMotorcycle", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VINNumber", motorcycle.VINNumber);
cmd.Parameters.AddWithValue("@ESCNumber", motorcycle.ESCNumber);
cmd.Parameters.AddWithValue("@Owner", motorcycle.Owner);
cmd.Parameters.AddWithValue("@Year", motorcycle.Year);
cmd.Parameters.AddWithValue("@Make", motorcycle.Make);
cmd.Parameters.AddWithValue("@Model", motorcycle.Model);
cmd.Parameters.AddWithValue("@TurnInDate", motorcycle.TurnInDate);
cmd.Parameters.AddWithValue("@DateAcquired", motorcycle.DateAcquired);
cmd.Parameters.AddWithValue("@EngineCC", motorcycle.EngineCC);
cmd.Parameters.AddWithValue("@SiteID", motorcycle.SiteID);
cmd.Parameters.AddWithValue("@SiteLocation", motorcycle.SiteLocation);
cmd.Parameters.AddWithValue("@PurchasePrice", motorcycle.PurchasePrice);
cmd.Parameters.AddWithValue("@CurrentValue", motorcycle.CurrentValue);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
public void AddMotorcycle(MotorcycleInfo motorcycle)
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("SP_InsertMotorcycle", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
