public static long?GetCommunicationId(string currentUserId, string SelectedUserId) { DCDataContext db = new DCDataContext(); var q = db.SelectCommunicationId(Convert.ToInt64(currentUserId), Convert.ToInt64(SelectedUserId)).SingleOrDefault(); if (q != null) { return(q.Fld_Communication_ID); } //اگر بین دو کاربر تا حالا چتی ایجاد نشده بود یکی بساز Tbl_Messenger_Communication newCommunicationChat = new Tbl_Messenger_Communication() { Fld_Communication_ID = getLastCommunicationId() + 1, Fld_CommunicationType_ID = 1, Fld_Communication_Name = currentUserId + "To" + SelectedUserId, }; db.Tbl_Messenger_Communications.InsertOnSubmit(newCommunicationChat); db.SubmitChanges(); Tbl_Messenger_CommunicationUser newCommunicationUserCurrentUser = new Tbl_Messenger_CommunicationUser() { Fld_CommunicationUser_ID = getLastCommunicationUserId() + 1, Fld_User_ID = Convert.ToInt64(currentUserId), Fld_LastSeenID = 0, Fld_LastSeenDateTime = DateTime.Now, Fld_IsTop = false, Fld_Communication_ID = newCommunicationChat.Fld_Communication_ID }; db.Tbl_Messenger_CommunicationUsers.InsertOnSubmit(newCommunicationUserCurrentUser); db.SubmitChanges(); Tbl_Messenger_CommunicationUser newCommunicationUserCurrentSelectedUser = new Tbl_Messenger_CommunicationUser() { Fld_CommunicationUser_ID = getLastCommunicationUserId() + 1, Fld_User_ID = Convert.ToInt64(SelectedUserId), Fld_LastSeenID = 0, Fld_LastSeenDateTime = DateTime.Now, Fld_IsTop = false, Fld_Communication_ID = newCommunicationChat.Fld_Communication_ID }; db.Tbl_Messenger_CommunicationUsers.InsertOnSubmit(newCommunicationUserCurrentSelectedUser); db.SubmitChanges(); return(newCommunicationChat.Fld_Communication_ID); }
public static void UpdateLastseenId(string currentUserId, string communicationId, string newlastseenid) { DCDataContext db = new DCDataContext(); var result = (from a in db.Tbl_Messenger_CommunicationUsers where a.Fld_User_ID == Convert.ToInt64(currentUserId) && a.Fld_Communication_ID == Convert.ToInt64(communicationId) select a).SingleOrDefault(); result.Fld_LastSeenID = Convert.ToInt64(newlastseenid); db.SubmitChanges(); }
public static _Tbl_Messenger_Message sendMessage(_Tbl_Messenger_Message obj) { DCDataContext db = new DCDataContext(); Tbl_Messenger_Message t = new Tbl_Messenger_Message { Fld_Message_ID = obj._Fld_Message_ID, Fld_Communication_ID = obj._Fld_Communication_ID, Fld_Attachment_ID = obj._Fld_Attachment_ID, Fld_Message_ReplayID = obj._Fld_Message_ReplayID, Fld_Message_SenderID = obj._Fld_Message_SenderID, Fld_Message_SendDateTime = DateTime.Now, Fld_Message_Text = obj._Fld_Message_Text, Fld_Message_Immediate = obj._Fld_Message_Immediate, Fld_Messenger_Joined_ID = obj._Fld_Messenger_Joined_ID, Fld_Messenger_Joined_Value = obj._Fld_Messenger_Joined_Value }; db.Tbl_Messenger_Messages.InsertOnSubmit(t); db.SubmitChanges(); //در آخر پس از ثبت پیام در بانک همان را بازگشت میدهیم تا بتوانیم در صفحه نمایشش دهیم _Tbl_Messenger_Message t2 = new _Tbl_Messenger_Message() { _Fld_Message_ID = t.Fld_Message_ID, _Fld_Communication_ID = t.Fld_Communication_ID, _Fld_Attachment_ID = t.Fld_Attachment_ID, _Fld_Message_ReplayID = t.Fld_Message_ReplayID, _Fld_Message_SenderID = t.Fld_Message_SenderID, _Fld_Message_SendDateTime = t.Fld_Message_SendDateTime, _Fld_Message_Text = t.Fld_Message_Text, _Fld_Message_Immediate = t.Fld_Message_Immediate, _Fld_Messenger_Joined_ID = t.Fld_Messenger_Joined_ID, _Fld_Messenger_Joined_Value = t.Fld_Messenger_Joined_Value }; return(t2); }
public void EditCss(Tbl_Sitestyle_Css obj) { var result = (from a in db.Tbl_Sitestyle_Csses where a.Fld_Sitestyle_Css_Id == obj.Fld_Sitestyle_Css_Id select a).SingleOrDefault(); result.Fld_Sitestyle_Css_LanguageId = obj.Fld_Sitestyle_Css_LanguageId; result.Fld_Sitestyle_Css_Name = obj.Fld_Sitestyle_Css_Name; db.SubmitChanges(); }