protected void Page_Load(object sender, EventArgs e)
{
HelperClasses.Token myToken = new HelperClasses.Token();
if (myToken.getToken() == "")
{
Response.Redirect("Home.aspx");
}
else
{
try
{
string url = Request.Url.AbsoluteUri;
int uidIndex = url.IndexOf("?uid=") + 5;
int fidIndex = url.IndexOf("&fid=");
string uid = url.Substring(uidIndex, fidIndex - uidIndex);
string fid = url.Substring(fidIndex + 5);
int index = url.IndexOf("&fid=");
HelperClasses.IvleUserInfo userInfo = new HelperClasses.IvleUserInfo();
string userID = userInfo.getUserID();
string friendID = url.Substring(index + 5);
if (uid == userID)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Server=tcp:yq6ulqknjf.database.windows.net,1433;Database=ModulesDB;User ID=rstyle@yq6ulqknjf;Password=Zxcv2345;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";
conn.Open();
string insert = "SELECT(friendName) FROM FriendList WHERE userID='" + userID + "' and friendID='" + friendID + "'";
SqlCommand cmd = new SqlCommand(insert, conn);
chatTitleLabel.Text = (string)cmd.ExecuteScalar();
conn.Close();
}
else
{
Response.Redirect("Chats.aspx");
}
}
catch
{
Response.Redirect("Chats.aspx");
}
}
}
public void TypeText(string text, string docId)
{
HelperClasses.IvleUserInfo userInfo = new HelperClasses.IvleUserInfo();
string userID = userInfo.getUserID();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Server=tcp:yq6ulqknjf.database.windows.net,1433;Database=ModulesDB;User ID=rstyle@yq6ulqknjf;Password=Zxcv2345;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";
conn.Open();
string selectDocID = "SELECT docID FROM documents WHERE memberID='" + userID + "';";
SqlCommand cmd = new SqlCommand(selectDocID, conn);
SqlDataReader dataReader = null;
dataReader = cmd.ExecuteReader();
string sqlDocID = null;
List<String> uniqueIDList = new List<String>();
while (dataReader.Read())
{
sqlDocID = dataReader["docID"].ToString();
uniqueIDList.Add(sqlDocID);
}
conn.Close();
//Clients.All.textTyped(connectionId, text);
foreach (string id in uniqueIDList)
{
if(id == docId)
{
//Clients.Others.textTyped(text);
Clients.OthersInGroup(docId).textTyped(text);
conn.Open();
string update = "UPDATE mydoc SET data =N'" + text + "' WHERE docId='"
+ docId + "';";
SqlCommand updateCmd = new SqlCommand(update, conn);
updateCmd.ExecuteNonQuery();
conn.Close();
break;
}
}
//Clients.All.textTyped(text);
}
public void RegisterChatGroup(String docId ,String uid)
{
HelperClasses.IvleUserInfo userInfo = new HelperClasses.IvleUserInfo();
string userID = userInfo.getUserID();
if (userID == uid)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Server=tcp:yq6ulqknjf.database.windows.net,1433;Database=ModulesDB;User ID=rstyle@yq6ulqknjf;Password=Zxcv2345;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";
conn.Open();
string selectDocID = "SELECT memberID FROM documents WHERE docId='" + docId + "';";
SqlCommand cmd = new SqlCommand(selectDocID, conn);
SqlDataReader dataReader = null;
dataReader = cmd.ExecuteReader();
string sqlMemberID = null;
List<String> memberIDList = new List<String>();
while (dataReader.Read())
{
sqlMemberID = dataReader["memberID"].ToString();
memberIDList.Add(sqlMemberID);
}
conn.Close();
foreach (string id in memberIDList)
{
if (uid == id)
{
Groups.Add(Context.ConnectionId, docId);
break;
}
}
}
}
private HttpCookie userIdCookie()
{
HttpCookie userIdCookie = new HttpCookie("userIdCookie");
IvleUserInfo userInfo = new IvleUserInfo();
userIdCookie.Value = userInfo.getUserID();
userIdCookie.Expires = DateTime.Now.AddDays(1);
//userCookie.Expires = DateTime.Now.AddSeconds(2);
return userIdCookie;
}
private HttpCookie userInfoCookie()
{
HttpCookie userCookie = new HttpCookie("userCookie");
IvleUserInfo userInfo = new IvleUserInfo();
userCookie.Values["username"] = userInfo.getUserName();
userCookie.Values["userID"] = userInfo.getUserID();
userCookie.Values["userEmail"] = userInfo.getUserEmail();
userCookie.Expires = DateTime.Now.AddDays(1);
//userCookie.Expires = DateTime.Now.AddSeconds(2);
return userCookie;
}
protected void Page_Load(object sender, EventArgs e)
{
string url = Request.Url.AbsoluteUri;
int typeIndex = url.IndexOf("?type=") + 6;
int uidIndex = url.IndexOf("&uid=");
int urlIndex = url.IndexOf("&url=");
string type = url.Substring(typeIndex, uidIndex - typeIndex);
string uid = url.Substring(uidIndex + 5, urlIndex-(uidIndex+5));
string myUrl = url.Substring(urlIndex + 5);
Label1.Text = type;
Label2.Text = uid;
Label3.Text = myUrl;
HelperClasses.IvleUserInfo userInfo = new HelperClasses.IvleUserInfo();
string userID = userInfo.getUserID();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Server=tcp:yq6ulqknjf.database.windows.net,1433;Database=ModulesDB;User ID=rstyle@yq6ulqknjf;Password=Zxcv2345;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";
if(type == "public")
{
conn.Open();
string delete = "DELETE FROM PublicChatList WHERE UniqueId='" + uid + "' AND MemberID='" + userID + "';";
SqlCommand deleteCmd = new SqlCommand(delete, conn);
deleteCmd.ExecuteNonQuery();
conn.Close();
Response.Redirect(myUrl);
}
if(type == "group")
{
conn.Open();
string delete = "DELETE FROM PrivateChatList WHERE UniqueId='" + uid + "' AND MemberID='" + userID + "';";
SqlCommand deleteCmd = new SqlCommand(delete, conn);
deleteCmd.ExecuteNonQuery();
conn.Close();
Response.Redirect(myUrl);
}
if(type == "individual")
{
conn.Open();
string delete = "DELETE FROM IndividualChatList WHERE friendID='" + uid + "' AND UserID='" + userID + "';";
delete += "DELETE FROM IndividualChatList WHERE friendID='" + userID + "' AND UserID='" + uid + "';";
SqlCommand deleteCmd = new SqlCommand(delete, conn);
deleteCmd.ExecuteNonQuery();
conn.Close();
Response.Redirect(myUrl);
}
if(type == "doc")
{
conn.Open();
string delete = "DELETE FROM Documents WHERE docID='" + uid + "' AND memberID='" + userID + "';";
SqlCommand deleteCmd = new SqlCommand(delete, conn);
deleteCmd.ExecuteNonQuery();
conn.Close();
Response.Redirect(myUrl);
}
}
public void addFriendToSql()
{
HelperClasses.IvleUserInfo userInfo = new HelperClasses.IvleUserInfo();
string url = HttpContext.Current.Request.RawUrl;
string userName = userInfo.getUserName();
string userID = userInfo.getUserID();
string friendID = "";
string friendName = "";
if (url.IndexOf('?') > -1)
{
int idIndex = url.IndexOf("id=");
int nameIndex = url.IndexOf("name=");
friendID = url.Substring(idIndex + 3, 8);
friendID = friendID.ToLower();
friendName = url.Substring(nameIndex + 5);
friendName = friendName.Replace("%20", " ");
friendName = System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(friendName.ToLower());
//Response.Redirect(Request.Url.AbsoluteUri);
try
{
Boolean notFriend = true;
SqlWrapper _SqlWrapper = new SqlWrapper(@"Server=tcp:yq6ulqknjf.database.windows.net,1433;Database=ModulesDB;User ID=rstyle@yq6ulqknjf;Password=Zxcv2345;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;");
DataTable _DataTable = _SqlWrapper.executeQuery(@"SELECT friendID FROM friendList");
String htmlCode = String.Empty;
foreach (DataRow _DataRow in _DataTable.Rows)
{
if (_DataRow["friendID"].ToString() == friendID)
{
notFriend = false;
break;
}
}
if(friendID == userID)
{
notFriend = false;
}
if (notFriend == true)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Server=tcp:yq6ulqknjf.database.windows.net,1433;Database=ModulesDB;User ID=rstyle@yq6ulqknjf;Password=Zxcv2345;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;";
conn.Open();
string insert = "INSERT into FriendList(userID,userName,friendID,friendName, isFriend, isAck, isAccepted) " + " VALUES ('" + userID + "', '" + userName + "', '" + friendID + "', '" + friendName + "','False','False','False')"
+ "INSERT into FriendList(userID,userName,friendID,friendName, isFriend, isAck, isAccepted) " + " VALUES ('" + friendID + "', '" + friendName + "', '" + userID + "', '" + userName + "','False','False','False');";
SqlCommand cmd = new SqlCommand(insert, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect("Friend.aspx");
}
}
catch { }
}
}
protected void chatLinkButton_Click(object sender, EventArgs e)
{
HelperClasses.IvleUserInfo userInfo = new HelperClasses.IvleUserInfo();
string userID = userInfo.getUserID();
Response.Redirect("GroupChat.aspx");
}
