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