public void InsertChatUserMessage(Chat msg)
{
tblMessageUser c = new tblMessageUser()
{
MSG_USER_FROM = msg.FromUserID,
MSG_USER_TO = msg.ToUserID,
MSG_ID = dc.tblMessages.Where(z => z.TBL_MSG_TIME == msg.Time).First().TBL_MSG_ID,
};
dc.tblMessageUsers.InsertOnSubmit(c);
dc.SubmitChanges();
}
public void InsertChatMessage(Chat msg)
{
var m = new tblMessage()
{
TBL_MSG_TEXT = msg.Message,
TBL_MSG_TIME = msg.Time,
};
dc.tblMessages.InsertOnSubmit(m);
dc.SubmitChanges();
}
public void SetDocViewed(bool Viewed, Chat Msg)
{
var M = dc.tblMessageUsers.Where(z => z.MSG_ID == Msg.MessageID && z.MSG_USER_TO == UserID);
if (M != null) M.First().MSG_VIEWED = Viewed;
}
private void chatSendButton_Click(object sender, EventArgs e)
{
var msg = new StringBuilder();
msg.Append(chatInputTextBox.Text);
int index = 0;
DateTime time = new DateTime();
foreach (var tu in SendToList)
{
var c = new Chat();
c.FromUserID = admin.UserID;
c.ToUserID = tu;
if (index == 0) time = service.GetChatTime();
c.Time = time;
c.Message = msg.ToString();
if (index == 0) t.InsertChatMessage(c);
t.InsertChatUserMessage(c);
index++;
}
chatInputTextBox.Clear();
}
void t_NewMessage(object sender, Chat.NewMessageEventArgs e)
{
if (_SelectedUser.ID != e.FromUserID)
{
var msg = AlsiUtils.Utilities.WrapWords(e.Message, 30);
balloonNotify(App.NewMessage, e.FromUser + " :", msg, newMsgNotify);
}
}
private void LoadChat()
{
t = new Chat();
t.NewMessage += new Chat.OnNewMessage(t_NewMessage);
Utilities.SetWindowTheme(userListView.Handle, "Explorer", null);
Utilities.SetWindowTheme(chatHistoryListView.Handle, "Explorer", null);
chatSendButton.BackgroundImage = Properties.Resources.Messages_DisAbled_icon;
chatSendButton.Enabled = false;
userUpdateBW.DoWork += new DoWorkEventHandler(userUpdateBW_DoWork);
ToolTip userInfoTootltip = new ToolTip();
userInfoTootltip.SetToolTip(userListView, "Check to select users to send message to.\nHighlight a user to view chat.");
PopulateUserListView();
Text = Text + " Logged in as " + admin.UserList.Where(x => x.ID == admin.UserID).First().USER_NAME;
try
{
userListView.Items[0].Selected = true;
// SendTEST();
// Environment.Exit(0);
}
catch { }
}
public List<Chat> GetChatMessages(int ThisUser, int FromUser)
{
var msgList = new List<Chat>();
var Sent = dc.tblMessageUsers.Where(z => z.MSG_USER_FROM == ThisUser && z.MSG_USER_TO == FromUser);
var Inbox = dc.tblMessageUsers.Where(z => z.MSG_USER_TO == ThisUser && z.MSG_USER_FROM == FromUser);
var All = Sent.Union(Inbox).OrderBy(z => z.tblMessage.TBL_MSG_TIME);//.Where(z => z.tblMessage.TBL_MSG_TIME >= DateTime.Now.AddDays(-1));
if (Inbox.Count() == 0) return new List<Chat>();
int fromid = Inbox.AsEnumerable().Last().MSG_USER_FROM;
e = new NewMessageEventArgs();
e.FromUser = dc.tblUsers.Where(z => z.ID == fromid).First().USER_NAME;
e.FromUserID = dc.tblUsers.Where(z => z.ID == fromid).First().ID;
e.Message = Inbox.ToList().Last().tblMessage.TBL_MSG_TEXT;
InboxMsgCount = dc.tblMessageUsers.Where(z => z.MSG_USER_TO == ThisUser).Count();
foreach (var msg in All)
{
bool V = false;
if (msg.MSG_VIEWED == null) V = false;
else
V = (bool)msg.MSG_VIEWED;
var c = new Chat()
{
FromUserID = (int)msg.MSG_USER_FROM,
ToUserID = (int)msg.MSG_USER_TO,
Time = (DateTime)msg.tblMessage.TBL_MSG_TIME,
Message = msg.tblMessage.TBL_MSG_TEXT,
MessageID = (int)msg.MSG_ID,
Viewed = V,
};
msgList.Add(c);
}
return msgList;
}
