protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LinqChatDataContext db = new LinqChatDataContext();
var user = (from u in db.Users
where u.usu_rut == myUsuario.Rut
select u).SingleOrDefault();
if (user != null)
{
Session["ChatUserID"] = user.UserID;
Session["ChatUsername"] = user.Username;
}
string roomId = (string)Request["roomId"];
lblRoomId.Text = roomId;
this.GetRoomInformation();
this.GetLoggedInUsers();
this.InsertMessage(ConfigurationManager.AppSettings["ChatLoggedInText"] + " " + DateTime.Now.ToString());
this.GetMessages();
// create a call back reference so we can log-out user when user closes the browser
string callBackReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "LogOutUser", "");
string logOutUserCallBackScript = "function LogOutUserCallBack(arg, context) { " + callBackReference + "; }";
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "LogOutUserCallBack", logOutUserCallBackScript, true);
}
}
/// <summary>
/// This will insert the passed text to the message table in the database
/// </summary>
private void InsertMessage(string text)
{
LinqChatDataContext db = new LinqChatDataContext();
Message message = new Message();
message.RoomID = Convert.ToInt32(lblRoomId.Text);
message.UserID = Convert.ToInt32(Session["ChatUserID"]);
if (String.IsNullOrEmpty(text))
{
message.Text = txtMessage.Text.Replace("<", "");
message.Color = ddlColor.SelectedValue;
}
else
{
message.Text = text;
message.Color = "gray";
}
message.ToUserID = null; // in the future, we will use this value for private messages
message.TimeStamp = DateTime.Now;
db.Messages.InsertOnSubmit(message);
db.SubmitChanges();
}
private void GetLoggedInUsers()
{
LinqChatDataContext db = new LinqChatDataContext();
// let's check if this authenticated user exist in the
// LoggedInUser table (means user is logged-in to this room)
var user = (from u in db.LoggedInUsers
where u.UserID == Convert.ToInt32(Session["ChatUserID"]) &&
u.RoomID == Convert.ToInt32(lblRoomId.Text)
select u).SingleOrDefault();
// if user does not exist in the LoggedInUser table
// then let's add/insert the user to the table
if (user == null)
{
LoggedInUser loggedInUser = new LoggedInUser();
loggedInUser.UserID = Convert.ToInt32(Session["ChatUserID"]);
loggedInUser.RoomID = Convert.ToInt32(lblRoomId.Text);
db.LoggedInUsers.InsertOnSubmit(loggedInUser);
db.SubmitChanges();
}
string userIcon;
StringBuilder sb = new StringBuilder();
// get all logged in users to this room
var loggedInUsers = from l in db.LoggedInUsers
where l.RoomID == Convert.ToInt32(lblRoomId.Text)
select l;
// list all logged in chat users in the user list
foreach (var loggedInUser in loggedInUsers)
{
// show user icon based on sex
if (loggedInUser.User.Sex.ToString().ToLower() == "m")
{
userIcon = "<img src='Images/manIcon.gif' style='vertical-align:middle' alt=''> ";
}
else
{
userIcon = "<img src='Images/womanIcon.gif' style='vertical-align:middle' alt=''> ";
}
// open the chat window when the logged-in user clicks another user in the list
if (loggedInUser.User.Username != (string)Session["ChatUsername"])
{
sb.Append(userIcon + "<a href=# onclick=\"window.open('ChatWindow.aspx?FromUserId=" + Session["ChatUserID"] +
"&ToUserId=" + loggedInUser.User.UserID + "&Username="******"','','width=400,height=200,scrollbars=no,toolbars=no,titlebar=no,menubar=no'); isLostFocus = 'true';\">" +
loggedInUser.User.Username + "</a><br>");
}
else
{
sb.Append(userIcon + "<b>" + loggedInUser.User.Username + "</b><br>");
}
}
// holds the names of the users shown in the chatroom
litUsers.Text = sb.ToString();
}
/// <summary>
/// We're doing 2 things here now so we want to validate whether we're trying to "LogOut" or "FocusThisWindow"
/// based on the eventArgument parameter that is passed via a JavaScript callback method
/// </summary>
void System.Web.UI.ICallbackEventHandler.RaiseCallbackEvent(string eventArgument)
{
_callBackStatus = "failed";
if (!String.IsNullOrEmpty(eventArgument))
{
// put back the focus on this window
if (eventArgument == "FocusThisWindow")
{
this.FocusThisWindow();
}
}
if (!String.IsNullOrEmpty(eventArgument))
{
if (eventArgument == "LogOut")
{
// log out the user by deleting from the LoggedInUser table
LinqChatDataContext db = new LinqChatDataContext();
var loggedInUser = (from l in db.LoggedInUsers
where l.UserID == Convert.ToInt32(Session["ChatUserID"]) &&
l.RoomID == Convert.ToInt32(lblRoomId.Text)
select l).SingleOrDefault();
db.LoggedInUsers.DeleteOnSubmit(loggedInUser);
db.SubmitChanges();
// insert a message that this user has logged out
this.InsertMessage("Just logged out! " + DateTime.Now.ToString());
}
}
_callBackStatus = "success";
}
private void GetLoggedInUsers()
{
LinqChatDataContext db = new LinqChatDataContext();
// let's check if this authenticated user exist in the
// LoggedInUser table (means user is logged-in to this room)
var user = (from u in db.LoggedInUsers
where u.UserID == Convert.ToInt32(Session["ChatUserID"]) &&
u.RoomID == Convert.ToInt32(lblRoomId.Text)
select u).SingleOrDefault();
// if user does not exist in the LoggedInUser table
// then let's add/insert the user to the table
if (user == null)
{
LoggedInUser loggedInUser = new LoggedInUser();
loggedInUser.UserID = Convert.ToInt32(Session["ChatUserID"]);
loggedInUser.RoomID = Convert.ToInt32(lblRoomId.Text);
db.LoggedInUsers.InsertOnSubmit(loggedInUser);
db.SubmitChanges();
}
string userIcon;
StringBuilder sb = new StringBuilder();
// get all logged in users to this room
var loggedInUsers = from l in db.LoggedInUsers
where l.RoomID == Convert.ToInt32(lblRoomId.Text)
select l;
// list all logged in chat users in the user list
foreach (var loggedInUser in loggedInUsers)
{
// show user icon based on sex
if (loggedInUser.User.Sex.ToString().ToLower() == "m")
{
userIcon = "<img src='Images/manIcon.gif' style='vertical-align:middle' alt=''> ";
}
else
{
userIcon = "<img src='Images/womanIcon.gif' style='vertical-align:middle' alt=''> ";
}
if (loggedInUser.User.Username != (string)Session["ChatUsername"])
{
sb.Append(userIcon + "<a href=#>" + loggedInUser.User.Username + "</a><br>");
}
else
{
sb.Append(userIcon + "<b>" + loggedInUser.User.Username + "</b><br>");
}
}
// holds the names of the users shown in the chatroom
litUsers.Text = sb.ToString();
}
private void GetLoggedInUsers()
{
LinqChatDataContext db = new LinqChatDataContext();
// let's check if this authenticated user exist in the
// LoggedInUser table (means user is logged-in to this room)
/*
* var user = (from u in db.LoggedInUsers
* where u.UserID == new Guid(Session["ChatUserID"].ToString())
* && u.RoomID == Convert.ToInt32(lblRoomId.Text)
* select u).SingleOrDefault();
*/
// if user does not exist in the LoggedInUser table
// then let's add/insert the user to the table
bool KullaniciLogOlmusmu = false;
using (Service1Client proxy = new Service1Client())
{
KullaniciLogOlmusmu = proxy.KullanıcıBelirliBirOdayaLogolmusmu(new Guid(Session["ChatUserID"].ToString()), Convert.ToInt32(lblRoomId.Text));
}
//Kullanıcı Log Olmamissa loggedinUsers Tablosuna yaz
if (!KullaniciLogOlmusmu)
{
using (Service1Client proxy = new Service1Client())
{
proxy.InsertLoggedInUsers(new Guid(Session["ChatUserID"].ToString()), Convert.ToInt32(lblRoomId.Text));
}
/*
* LoggedInUser loggedInUser = new LoggedInUser();
* loggedInUser.UserID = new Guid(Session["ChatUserID"].ToString());
* loggedInUser.RoomID = Convert.ToInt32(lblRoomId.Text);
* db.LoggedInUsers.InsertOnSubmit(loggedInUser);
* db.SubmitChanges();
*/
}
string userIcon;
StringBuilder sb = new StringBuilder();
// get all logged in users to this room
using (Service1Client proxy = new Service1Client())
{
var loggedInUsers = proxy.kal_BelirliBirOdadaSohbetEdenleriDon_ResultDon(short.Parse(lblRoomId.Text));
foreach (var item in loggedInUsers)
{
userIcon = "<img src='~/Images/womanIcon.gif' style='vertical-align:middle' alt=''> ";
//sb.Append(userIcon + "<b>" + Context.User.Identity.Name + "</b><br>");
sb.Append(userIcon + "<b>" + proxy.UserIddenUserNameDon(item.UserID) + "</b><br>");
}
litUsers.Text = sb.ToString();
}
}
public static IQueryable <Room> getListadoSalas(decimal idCondominio)
{
LinqChatDataContext db = new LinqChatDataContext();
var room = (from r in db.Rooms
where r.idCondominio == idCondominio
select r);
return(room);
}
private void GetRoomInformation()
{
// get the room information from the database
// we're going to set this up so that we can use
// many rooms if we want to
LinqChatDataContext db = new LinqChatDataContext();
var room = (from r in db.Rooms
where r.RoomID == Convert.ToInt32(lblRoomId.Text)
select r).SingleOrDefault();
lblRoomId.Text = room.RoomID.ToString();
lblRoomName.Text = room.Name;
}
/// <summary>
/// Because of the existence of the ToUserID (the user that we want to privately chat with)
/// we are only retrieving private messages between two (2) users
/// </summary>
private void InsertMessage()
{
Message message = new Message();
message.UserID = Convert.ToInt32(lblFromUserId.Text);
message.ToUserID = Convert.ToInt32(lblToUserId.Text);
message.TimeStamp = DateTime.Now;
message.Text = txtMessage.Text.Replace("<", "");
LinqChatDataContext db = new LinqChatDataContext();
db.Messages.InsertOnSubmit(message);
db.SubmitChanges();
}
void System.Web.UI.ICallbackEventHandler.RaiseCallbackEvent(string eventArgument)
{
_callBackStatus = "failed";
// log out the user by deleting from the LoggedInUser table
LinqChatDataContext db = new LinqChatDataContext();
var loggedInUser = (from l in db.LoggedInUsers
where l.UserID == Convert.ToInt32(Session["ChatUserID"]) &&
l.RoomID == Convert.ToInt32(lblRoomId.Text)
select l).SingleOrDefault();
db.LoggedInUsers.DeleteOnSubmit(loggedInUser);
db.SubmitChanges();
// insert a message that this user has logged out
this.InsertMessage("Acaba de desconectarse! " + DateTime.Now.ToString());
_callBackStatus = "success";
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
LinqChatDataContext db = new LinqChatDataContext();
var user = (from u in db.Users
where u.Username == Login1.UserName &&
u.Password == Login1.Password
select u).SingleOrDefault();
if (user != null)
{
e.Authenticated = true;
Session["ChatUserID"] = user.UserID;
Session["ChatUsername"] = user.Username;
}
else
{
e.Authenticated = false;
}
}
/// <summary>
/// Get the last 20 messages for this room
/// </summary>
private void GetMessages()
{
LinqChatDataContext db = new LinqChatDataContext();
var messages = (from m in db.Messages
where m.RoomID == Convert.ToInt32(lblRoomId.Text)
orderby m.TimeStamp descending
select m).Take(20).OrderBy(m => m.TimeStamp);
if (messages != null)
{
StringBuilder sb = new StringBuilder();
int ctr = 0; // toggle counter for alternating color
foreach (var message in messages)
{
// alternate background color on messages
if (ctr == 0)
{
sb.Append("<div style='padding: 10px;'>");
ctr = 1;
}
else
{
sb.Append("<div style='background-color: #EFEFEF; padding: 10px;'>");
ctr = 0;
}
if (message.User.Sex.ToString().ToLower() == "m")
{
sb.Append("<img src='Images/manIcon.gif' style='vertical-align:middle' alt=''> <span style='color: black; font-weight: bold;'>" + message.User.Username + ":</span> " + message.Text + "</div>");
}
else
{
sb.Append("<img src='Images/womanIcon.gif' style='vertical-align:middle' alt=''> <span style='color: black; font-weight: bold;'>" + message.User.Username + ":</span> " + message.Text + "</div>");
}
}
litMessages.Text = sb.ToString();
}
}
// This is where we send a private chat invitation to other chatters
private void InsertPrivateMessage()
{
// if the private message is sent to this user already,
// don't send it again
if (String.IsNullOrEmpty(lblMessageSent.Text))
{
// if any private message is found based on the
// from user id, or the to user id, then this
// private message will not be inserted
PrivateMessage privateMessage = new PrivateMessage();
privateMessage.UserID = Convert.ToInt32(lblFromUserId.Text);
privateMessage.ToUserID = Convert.ToInt32(lblToUserId.Text);
LinqChatDataContext db = new LinqChatDataContext();
db.PrivateMessages.InsertOnSubmit(privateMessage);
db.SubmitChanges();
// make sure to assign any value to this label
// to confirm that a message is sent to this user
lblMessageSent.Text = ConfigurationManager.AppSettings["ChatWindowMessageSent"];
}
}
protected void BtnLogOut_Click(object sender, EventArgs e)
{
// log out the user by deleting from the LoggedInUser table
LinqChatDataContext db = new LinqChatDataContext();
var loggedInUser = (from l in db.LoggedInUsers
where l.UserID == Convert.ToInt32(Session["ChatUserID"]) &&
l.RoomID == Convert.ToInt32(lblRoomId.Text)
select l).SingleOrDefault();
db.LoggedInUsers.DeleteOnSubmit(loggedInUser);
db.SubmitChanges();
// insert a message that this user has logged out
this.InsertMessage("Just logged out! " + DateTime.Now.ToString());
// clean the session
Session.RemoveAll();
Session.Abandon();
// redirect the user to the login page
Response.Redirect("Default.aspx");
}
/// <summary>
/// Check if anyone invited me to chat privately
/// </summary>
private void GetPrivateMessages()
{
LinqChatDataContext db = new LinqChatDataContext();
var privateMessage = (from pm in db.PrivateMessages
where pm.ToUserID == Convert.ToInt32(Session["ChatUserID"])
select pm).SingleOrDefault();
if (privateMessage != null)
{
lblChatNowUser.Text = privateMessage.User.Username;
btnChatNow.OnClientClick =
"window.open('ChatWindow.aspx?FromUserId=" + Session["ChatUserID"] +
"&ToUserId=" + privateMessage.UserID + "&Username="******"&IsReply=yes','','width=400,height=200,scrollbars=no,toolbars=no,titlebar=no,menubar=no'); isLostFocus = 'true';";
pnlChatNow.Visible = true;
db.PrivateMessages.DeleteOnSubmit(privateMessage);
db.SubmitChanges();
}
}
private void GetPrivateMessages()
{
LinqChatDataContext db = new LinqChatDataContext();
var privateMessages = (from m in db.Messages
where
(m.UserID == Convert.ToInt32(lblFromUserId.Text) && m.ToUserID == Convert.ToInt32(lblToUserId.Text))
||
(m.UserID == Convert.ToInt32(lblToUserId.Text) && m.ToUserID == Convert.ToInt32(lblFromUserId.Text))
orderby m.TimeStamp descending
select m).Take(20).OrderBy(m => m.TimeStamp);
if (privateMessages != null)
{
StringBuilder sb = new StringBuilder();
int ctr = 0; // toggle counter for alternating color
foreach (Message message in privateMessages)
{
// alternate background color on messages
if (ctr == 0)
{
sb.Append("<div style='padding: 10px;'>");
ctr = 1;
}
else
{
sb.Append("<div style='background-color: #EFEFEF; padding: 10px;'>");
ctr = 0;
}
sb.Append("<span style='color: black; font-weight: bold;'>" + message.User.Username + ":</span> " + message.Text + "</div>");
}
litMessages.Text = sb.ToString();
}
}
private void GetRoomInformation()
{
// get the room information from the database
// we're going to set this up so that we can use
// many rooms if we want to
LinqChatDataContext db = new LinqChatDataContext();
var room = (from r in db.Rooms
where r.RoomID == Convert.ToInt32(lblRoomId.Text)
select r).SingleOrDefault();
lblRoomId.Text = room.RoomID.ToString();
lblRoomName.Text = room.Name;
}
private void GetLoggedInUsers()
{
LinqChatDataContext db = new LinqChatDataContext();
// let's check if this authenticated user exist in the
// LoggedInUser table (means user is logged-in to this room)
/*
var user = (from u in db.LoggedInUsers
where u.UserID == new Guid(Session["ChatUserID"].ToString())
&& u.RoomID == Convert.ToInt32(lblRoomId.Text)
select u).SingleOrDefault();
*/
// if user does not exist in the LoggedInUser table
// then let's add/insert the user to the table
bool KullaniciLogOlmusmu=false;
using (Service1Client proxy = new Service1Client())
{
KullaniciLogOlmusmu = proxy.KullanıcıBelirliBirOdayaLogolmusmu(new Guid(Session["ChatUserID"].ToString()), Convert.ToInt32(lblRoomId.Text));
}
//Kullanıcı Log Olmamissa loggedinUsers Tablosuna yaz
if (!KullaniciLogOlmusmu)
{
using (Service1Client proxy = new Service1Client())
{
proxy.InsertLoggedInUsers(new Guid(Session["ChatUserID"].ToString()), Convert.ToInt32(lblRoomId.Text));
}
/*
LoggedInUser loggedInUser = new LoggedInUser();
loggedInUser.UserID = new Guid(Session["ChatUserID"].ToString());
loggedInUser.RoomID = Convert.ToInt32(lblRoomId.Text);
db.LoggedInUsers.InsertOnSubmit(loggedInUser);
db.SubmitChanges();
*/
}
string userIcon;
StringBuilder sb = new StringBuilder();
// get all logged in users to this room
using (Service1Client proxy = new Service1Client())
{
var loggedInUsers = proxy.kal_BelirliBirOdadaSohbetEdenleriDon_ResultDon(short.Parse(lblRoomId.Text));
foreach (var item in loggedInUsers)
{
userIcon = "<img src='~/Images/womanIcon.gif' style='vertical-align:middle' alt=''> ";
//sb.Append(userIcon + "<b>" + Context.User.Identity.Name + "</b><br>");
sb.Append(userIcon + "<b>" + proxy.UserIddenUserNameDon(item.UserID) + "</b><br>");
}
litUsers.Text = sb.ToString();
}
}
