//<----------------進入廣場聊天室 全體跳出上線通知-------------------------->
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();
}