public void OnPostNext()
{
String Search_User = HttpContext.Session.GetString("Search_User");
String Exception = "";
Boolean CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception);
MySqlCommand MySQLQuery = new MySqlCommand();
MySqlDataReader RecordReader;
String Requestor_1 = "";
String Current_User = HttpContext.Session.GetString("User_Name");
String Chat_OFFSET_String = HttpContext.Session.GetString("Chat_OFFSET");
int Chat_OFFSET = int.Parse(Chat_OFFSET_String);
OtherUserList = new List <String> {
};
IDList = new List <String> {
};
if (Search_User != null)
{
if (Chat_OFFSET == 0)
{
Chat_OFFSET += 50;
}
MySQLQuery.CommandText = "SELECT `Requestor_1`,`ID` FROM `DF_Public_Key` WHERE `Requestor_1`=@Current_User AND `Status`=@Status AND `Requestor_2` LIKE '%@Search_User%' LIMIT 50 OFFSET " + Chat_OFFSET.ToString();
MySQLQuery.Parameters.Add("@Search_User", MySqlDbType.Text).Value = Search_User;
MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User;
MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively";
MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection;
MySQLQuery.Prepare();
RecordReader = MySQLQuery.ExecuteReader();
while (RecordReader.Read())
{
Requestor_1 = RecordReader.GetValue(0).ToString();
OtherUserList.Add(Requestor_1);
IDList.Add(RecordReader.GetValue(1).ToString());
}
MyOwnMySQLConnectionClass.MyMySQLConnection.Close();
CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception);
MySQLQuery = new MySqlCommand();
MySQLQuery.CommandText = "SELECT `Requestor_2`,`ID` FROM `DF_Public_Key` WHERE `Requestor_2`=@Current_User AND `Status`=@Status AND `Requestor_1` LIKE '%@Search_User%' LIMIT 50 OFFSET " + Chat_OFFSET.ToString();
MySQLQuery.Parameters.Add("@Search_User", MySqlDbType.Text).Value = Search_User;
MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User;
MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively";
MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection;
MySQLQuery.Prepare();
RecordReader = MySQLQuery.ExecuteReader();
while (RecordReader.Read())
{
Requestor_1 = RecordReader.GetValue(0).ToString();
OtherUserList.Add(Requestor_1);
IDList.Add(RecordReader.GetValue(1).ToString());
}
MyOwnMySQLConnectionClass.MyMySQLConnection.Close();
HttpContext.Session.SetString("Chat_OFFSET", (Chat_OFFSET + 50).ToString());
}
else
{
if (Chat_OFFSET == 0)
{
Chat_OFFSET += 50;
}
MySQLQuery.CommandText = "SELECT `Requestor_1`,`ID` FROM `DF_Public_Key` WHERE `Requestor_1`=@Current_User AND `Status`=@Status AND LIMIT 50 OFFSET " + Chat_OFFSET.ToString();
MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User;
MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively";
MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection;
MySQLQuery.Prepare();
RecordReader = MySQLQuery.ExecuteReader();
while (RecordReader.Read())
{
Requestor_1 = RecordReader.GetValue(0).ToString();
OtherUserList.Add(Requestor_1);
IDList.Add(RecordReader.GetValue(1).ToString());
}
MyOwnMySQLConnectionClass.MyMySQLConnection.Close();
CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception);
MySQLQuery = new MySqlCommand();
MySQLQuery.CommandText = "SELECT `Requestor_2`,`ID` FROM `DF_Public_Key` WHERE `Requestor_2`=@Current_User AND `Status`=@Status LIMIT 50 OFFSET " + Chat_OFFSET.ToString();
MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User;
MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively";
MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection;
MySQLQuery.Prepare();
RecordReader = MySQLQuery.ExecuteReader();
while (RecordReader.Read())
{
Requestor_1 = RecordReader.GetValue(0).ToString();
OtherUserList.Add(Requestor_1);
IDList.Add(RecordReader.GetValue(1).ToString());
}
MyOwnMySQLConnectionClass.MyMySQLConnection.Close();
HttpContext.Session.SetString("Chat_OFFSET", (Chat_OFFSET + 50).ToString());
}
}