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();
}