protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Beer b = new PremiumBeer();
b.Name = "Primator";
b.Weight = b.InitialWeight = 645;
b.Country = "CZECH";
using (TweetBeerContainer dbContainer = new TweetBeerContainer())
{
#region Inserting
dbContainer.AddToBeer(b);
dbContainer.SaveChanges();
#endregion
#region Updating
b.Name = "Corona";
dbContainer.SaveChanges();
#endregion
#region Delete
//dbContainer.DeleteObject(b);
//dbContainer.SaveChanges();
#endregion
#region LINQ Query
var coronas = from beer in dbContainer.Beer.ToList()
where beer.Name == "Corona"
select beer;
#endregion
}
#region Equivalent to using
//TweetBeerContainer v = null;
//try
//{
// v = new TweetBeerContainer();
// // Fazer um monte de coisa
//}
//catch
//{
//}
//finally
//{
// v.Dispose();
//}
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
ViewState["S"] = "Test";
ViewState["S1"] = "Test2";
ViewState["S3"] = "Test3";
ViewState["S4"] = "Test4";
//ObjectCache memCache = new MemoryCache("beerCache");
var favoriteList = new List<FavoriteBeer>();
//if (Cache["favoriteBeers"] != null && memCache["favoriteBeers"] != null)
//{
// favoriteList = Cache["favoriteBeers"] as List<FavoriteBeer>;
//}
//else
//{
using (TweetBeerContainer tbContainer = new TweetBeerContainer())
{
favoriteList = tbContainer.FavoriteBeerSet.ToList();
foreach (FavoriteBeer fvBeer in favoriteList)
{
this.lbFavorites.Items.Add(new ListItem(fvBeer.Beer.Name, fvBeer.Beer.Id.ToString()));
}
}
//Cache["favoriteBeers"] = favoriteList;
//memCache.Add("favoriteBeers", favoriteList, DateTime.Now.AddMonths(1));
//}
}
protected void Page_Load(object sender, EventArgs e)
{
// Exercício: Preencher DropDownList do controle
// com as cervejas que estiverem no banco de dados TweetBeer!
// Lembrem-se: cada item terá um value (Id) e um text (Name)
// Lembrem-se 2: este carregamento deve ser executado apenas uma vez!
if (!IsPostBack)
{
using (TweetBeerContainer dbContainer = new TweetBeerContainer())
{
var listItems = (from b in dbContainer.Beer.ToList()
select new ListItem(b.Name, b.Id.ToString())).ToArray();
foreach (var li in listItems)
{
if (this.ddlBeerList.Items
.Cast<ListItem>()
.Count(x => x.Text == li.Text) == 0)
{
this.ddlBeerList.Items.Add(li);
}
}
}
}
}
protected void btnAddToFavorites_Click(object sender, EventArgs e)
{
string v = ViewState["S"] as string;
ListItem selectedBeer = this.ucBeerList.SelectedBeer;
if (selectedBeer != null)
{
this.lbFavorites.Items.Add(new ListItem(selectedBeer.Text));
#region Adding in Database
using (TweetBeerContainer tweetBeerContainer = new TweetBeerContainer())
{
long id = Int64.Parse(selectedBeer.Value);
Beer currentBeer = tweetBeerContainer.Beer
.Single(b => b.Id == id);
FavoriteBeer favoriteBeer = new FavoriteBeer();
favoriteBeer.Beer = currentBeer;
favoriteBeer.CreationDate = DateTime.Now;
favoriteBeer.User = Session["userName"] as string;
tweetBeerContainer.AddToFavoriteBeerSet(favoriteBeer);
tweetBeerContainer.SaveChanges();
// Twitter
currentBeer.Tweet(String.Format("{0} added to favorites by {1}",
currentBeer.Name, favoriteBeer.User
));
}
#endregion
}
// Cleaning up Beer List
this.ucBeerList.RemoveSelectedBeer();
}