public List <CAr> getAllCars()
{
SqlConnection con = new SqlConnection(@"Data Source=(localdb)\ProjectsV12;Initial Catalog=CarDatabase;Integrated Security=True");
List <CAr> carlist = new List <CAr>();
try
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from CArs", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
CAr carinfo = new CAr();
carinfo.ID = Convert.ToInt32(dt.Rows[i]["ID"]);
carinfo.Manufacture = dt.Rows[i]["Manufacture"].ToString();
carinfo.Make = dt.Rows[i]["Make"].ToString();
carinfo.Color = dt.Rows[i]["Color"].ToString();
carinfo.Release_Year = Convert.ToDateTime(dt.Rows[i]["Release_Year"]);
carinfo.Seating = Convert.ToInt32(dt.Rows[i]["Seating"]);
carlist.Add(carinfo);
}
con.Close();
}
return(carlist);
}
catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
{
throw;
}
}
public void addCar(string manufacure, string make, string color, DateTime release_year, int seating)
{
CarDatabaseEntities3 entitites = new CarDatabaseEntities3();
try
{
CAr car = new CAr
{
Manufacture = manufacure,
Make = make,
Color = color,
Release_Year = release_year,
Seating = seating
};
entitites.CArs.Add(car);
entitites.SaveChanges();
}
catch (System.Data.Entity.Infrastructure.DbUpdateException ex)
{
throw;
}
}