//<----------------進入廣場聊天室 全體跳出上線通知--------------------------> public void Login_sq_chatroom(int id) { var list = db.tMembers.FirstOrDefault(m => m.MemberID == id); var cookie = Context.Request.GetHttpContext().Request.Cookies["AutoLogin"]["MemberName"]; tSqChatroom tsc = new tSqChatroom(); tsc.MemberID = id; db.tSqChatroom.Add(tsc); db.SaveChanges(); Clients.All.login(cookie, list.ImgURL); }
/// <summary> /// Saves the import data. /// </summary> /// <param name="importZipCodes">The import zip codes.</param> /// <exception cref="System.NotImplementedException"></exception> public void SaveImportData(IEnumerable <tCustomizeTopic> importTest) { try { ////先砍掉全部資料 //using (var db = new dbTeam2_FinalEntities()) //{ // foreach (var item in db.tCustomizeTopic.OrderBy(x => x.種類)) // { // db.tCustomizeTopic.Remove(item); // } // db.SaveChanges(); //} //再把匯入的資料給存到資料庫 using (var db = new dbTeam2_FinalEntities()) { foreach (var item in importTest) { db.tCustomizeTopic.Add(item); } db.SaveChanges(); } } catch (Exception ex) { throw; } }
//<------------------照片上傳--------------------> public JsonResult Imgupload(HttpPostedFileBase photo) { string filepath = ""; int MemberID = int.Parse(Request.Cookies["AutoLogin"]["MemberID"]); if (photo.ContentLength > 0) { filepath = $"/MemberImg/Member{MemberID}.jpg"; photo.SaveAs(Server.MapPath("~") + filepath); db.tMembers.FirstOrDefault(m => m.MemberID == MemberID).ImgURL = filepath; db.SaveChanges(); } return(Json(filepath, JsonRequestBehavior.AllowGet)); }
//<---------------------------------顯示單筆主要文章----------------------------> public JsonResult DiscussSingle(int ArticleID, int MemberID) { db.tArticle.FirstOrDefault(m => m.ArticleID == ArticleID).ViewCount++; db.SaveChanges(); var list = db.tArticle.Where(m => m.ArticleID == ArticleID).Select(m => new { ArticleID = m.ArticleID, MemberName = db.tMembers.FirstOrDefault(t => t.MemberID == m.MemberID).MemberName, Category = m.Category, MemberID = m.MemberID, Title = m.Title, Main = m.Main, UpTime = m.UpTime, LoveCount = m.LoveCount, ViewCount = m.ViewCount, LoveStatus = db.tArticleLove.FirstOrDefault(t => t.MemberID == MemberID && t.ArticleID == ArticleID) != null, }); return(Json(list, JsonRequestBehavior.AllowGet)); }
public void create(Table _entity) { dbTable.Add(_entity); db.SaveChanges(); }