public bool Add(int p_member_id, int p_categoryid, int p_source_id, int?p_content_id, string p_message) { try { SingleApartmentEntities db = new SingleApartmentEntities(); Information info = new Information(); info.InformationDate = DateTime.Now; info.InformationCategoryID = p_categoryid; //訊息分類來源 info.DocumentID = p_source_id; //可能是訂單號碼, 房號 ...... if (p_content_id != null) { InformationContent rowContent = db.InformationContent.Where(c => c.ContentID == p_content_id).FirstOrDefault(); if (rowContent != null) { //InformationSource此欄位可以是null info.InformationSource = p_content_id; //訊息ContentID if (!string.IsNullOrEmpty(p_message)) { info.InformationContent = rowContent.ContentText + p_message; } else { info.InformationContent = rowContent.ContentText; //訊息內容 } } else { info.InformationContent = "基本資料未輸入, 請洽系統管理員"; } } else { info.InformationContent = "Empty Message!"; } info.MemberID = p_member_id; info.Priority = "Normal"; info.Read_YN = "N"; info.Status = "Open"; db.Information.Add(info); db.SaveChanges(); return(true); } catch { return(false); } }
public void Connect(string userName) { var id = Context.ConnectionId; if (ConnectedUsers.Count(x => x.ConnectionId == id) == 0) { ConnectedUsers.Add(new UserDetail { ConnectionId = id, UserName = userName }); // send to caller Clients.Caller.onConnected(id, userName, ConnectedUsers, CurrentMessage); SingleApartmentEntities db = new SingleApartmentEntities(); var img = db.tMember.FirstOrDefault(r => r.fMemberName == userName).fImage; // send to all except caller client Clients.AllExcept(id).onNewUserConnected(id, userName, img); } }