//Insert message into the database public void ChatSendMessage(string chatMessageInsert, string username) { Models.Database d = Models.Database.CurrentInstance; try { //Initialize Command MySqlCommand cmd = new MySqlCommand(queryString, d.conn); //Open connection d.OpenConnection(); //Set date time DateTime date = DateTime.Now; string dateStr, timeStr, dateTimeStr; dateTimeStr = date.ToString("dd/MM/yyy hh:mm tt"); dateStr = date.ToString("dd/MM/yyyy"); timeStr = date.ToString("hh:mm tt"); //Encode msg chatMessageInsert = encInit.EncodeStuff(chatMessageInsert); //Encrypt msg chatMessageInsert = aes_obj.AesEncrypt(chatMessageInsert); //Insert query queryString = "INSERT INTO dububase.chat(chatMessage, chatDate, chatTime, username) VALUES(@sendmessage, @chatdate, @chattime, @username)"; cmd.CommandText = queryString; //Add parameters cmd.Parameters.AddWithValue("@sendmessage", chatMessageInsert); cmd.Parameters.AddWithValue("@chatdate", dateStr); cmd.Parameters.AddWithValue("@chattime", dateTimeStr); cmd.Parameters.AddWithValue("@username", username); cmd.ExecuteNonQuery(); }//Exception catch (System.Data.SqlClient.SqlException ex) { string errorMsg = "Error"; errorMsg += ex.Message; throw new Exception(errorMsg); } finally { //Close connection d.CloseConnection(); } }