//(方法)將喜歡的食譜+進收藏夾
private void likeintoColn(int RecipeID, string FolderName, int Mid)
{
var q = (this.dbcontext.CollectionFolder_Table.Where(m => m.MemberID == Mid && m.CollectionFolder == FolderName).Select(m => m.CollectionFolderID)).FirstOrDefault();
int id = Convert.ToInt32(q);
Collection_Table _collection = new Collection_Table()
{
CollectionFolderID = id,
ReicipeID = RecipeID,
Datetime = DateTime.Now
};
dbcontext.Collection_Table.Add(_collection);
dbcontext.SaveChanges();
MessageBox.Show("成功加入收藏夾");
Close();
}
//(方法)將此頁的食譜加入收藏
private void Addintocoln(int rpid)
{
var countsame = this.Delicious.Collection_Table.Where(m => m.CollectionFolder_Table.MemberID == memberData.MemberID && m.ReicipeID == rpid).Count();
if (countsame > 0)
{
MessageBox.Show("已加入收藏過");
btn_Favorites.Enabled = false;
}
else
{
var q = this.Delicious.CollectionFolder_Table.Where(m => m.MemberID == memberData.MemberID && m.CollectionFolder == "我的最愛").Select(m => m.CollectionFolderID).FirstOrDefault();
Collection_Table coln_table = new Collection_Table()
{
CollectionFolderID = q,
ReicipeID = rpid,
Datetime = DateTime.Now
};
this.Delicious.Collection_Table.Add(coln_table);
this.Delicious.SaveChanges();
MessageBox.Show("成功加入我的收藏");
}
btn_Favorites.ForeColor = Color.Yellow;
}