public static List <CardView> GetCardViews()
{
List <CardView> cardViews = new List <CardView>();
string queryString = @"SELECT RestaurantID,Name,Address,PathToLogo FROM Restaurants";
var enviroment = Environment.CurrentDirectory;
string projectDirectory = Directory.GetParent(enviroment).Parent.FullName;
SqlConnection sqlConnection = new SqlConnection(connectionString);
sqlConnection.Open();
DataSet dataInfo = new DataSet();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(queryString, sqlConnection);
sqlDataAdapter.Fill(dataInfo, "info");
foreach (DataRow dr in dataInfo.Tables["info"].Rows)
{
CardView cardView = new CardView();
cardView.ID = int.Parse(dr.ItemArray.GetValue(0).ToString());
cardView.Name = dr.ItemArray.GetValue(1).ToString();
cardView.Address = dr.ItemArray.GetValue(2).ToString();
cardView.Path = projectDirectory + @"\Resources\" + dr.ItemArray.GetValue(3).ToString();
cardViews.Add(cardView);
}
sqlConnection.Close();
return(cardViews);
}
public void SetCardViewControler(CardView cardView)
{
LogoRestaurant.Image = Image.FromFile(cardView.Path);
LogoRestaurant.SizeMode = PictureBoxSizeMode.StretchImage;
ID = cardView.ID;
Title.AutoSize = true;
Address.AutoSize = true;
Title.Text = cardView.Name;
Address.Text = cardView.Address;
}
