// LOAD MSGS //
public Messages[] LoadMsgs(int chatId)
{
using (MySqlConnection conn = new MySqlConnection(connStr))
{
conn.Open();
ChatId = chatId;
var reader = new MySqlCommand($"SELECT user.id, user.login, msg.id AS msg_id, msg.text, msg.time FROM `msg` INNER JOIN `user` ON (user.id = sender_id) WHERE (chat_id = {chatId})", conn).ExecuteReader();
List <Messages> m = new List <Messages>();
while (reader.Read())
{
int senderId = reader.GetInt32("id");
String senderLogin = reader.GetString("login");
String msgText = reader.GetString("text");
DateTime time = reader.GetDateTime("time");
// setup data
m.Add(displayNewDateIfRequired(time));
// msgs
if (senderId == UserId)
{
m.Add(new Outbox(msgText, time.ToString("HH:mm:ss"), reader.GetInt32("msg_id"), this));
}
else if (senderId == 0)
{
m.Add(new ChatInfo(msgText));
}
else
{
m.Add(new Inbox(senderLogin, msgText, time.ToString("HH:mm:ss")));
}
}
reader.Close();
return(m.ToArray());
}
}
public string Select_Date_Format_2(string query)
{
string str = "";
if (this.OpenConnection())
{
MySqlDataReader reader = new MySqlCommand(query, this.connection).ExecuteReader();
while (reader.Read())
{
str = reader.GetDateTime(0).ToString("yyyy-MM-dd", CultureInfo.InvariantCulture);
}
reader.Close();
this.CloseConnection();
return(str);
}
return(str);
}
public void LoadBanedIP(ref object banips)
{
MySqlConnection connection = DAO.GetConnection();
try
{
connection.Open();
string cmdText = "SELECT * FROM banned_ip";
MySqlDataReader mySqlDataReader = new MySqlCommand(cmdText, connection).ExecuteReader();
while (mySqlDataReader.Read())
{
string @string = mySqlDataReader.GetString("mask");
DateTime dateTime = mySqlDataReader.GetDateTime("time_end");
object[] array;
bool[] array2;
NewLateBinding.LateCall(banips, null, "Add", array = new object[2]
{
@string,
new BannedIP(@string, dateTime)
}, null, null, array2 = new bool[2]
{
true,
false
}, IgnoreReturn: true);
if (array2[0])
{
@string = (string)Conversions.ChangeType(RuntimeHelpers.GetObjectValue(array[0]), typeof(string));
}
}
mySqlDataReader.Close();
}
catch (Exception ex)
{
ProjectData.SetProjectError(ex);
Exception ex2 = ex;
log.Error((object)ex2);
ProjectData.ClearProjectError();
}
finally
{
connection.Close();
}
}
public static void GetRequests(long id)
{
using (var connection = new MySqlConnection(ConnectionDB.Connection))
{
connection.Open();
using (var reader = new MySqlCommand($"SELECT * FROM Requests WHERE IDEmpl = {id}", connection).ExecuteReader())
{
while (reader.Read())
{
Application.Current.Dispatcher.Invoke(() => RequestsList.Add(
new URequest(reader.GetInt64("ID"), reader.GetString("Text"), reader.GetDateTime("Date"), reader.GetInt64("State").ToString(), SetBackGround(reader.GetInt64("State")))));
}
}
connection.Close();
}
}