public FileD SelectById(int file_id)
{
lock (locker)
{
using (MySqlCommand sqlCommand = new MySqlCommand("SELECT * FROM files WHERE file_id=@file_id", connection))
{
sqlCommand.Parameters.AddWithValue("@file_id", file_id);
using (MySqlDataReader reader = sqlCommand.ExecuteReader())
{
if (reader.Read())
{
FileD file = new FileD();
file.file_id = reader.GetInt32(0);
file.file_path = reader.IsDBNull(1) ? "" : reader.GetString(1);
file.file_name = reader.GetString(2);
file.file_type = reader.IsDBNull(3) ? "" : reader.GetString(3);
file.file_extension = reader.IsDBNull(4) ? "" : reader.GetString(4);
return(file);
}
else
{
return(null);
}
}
}
}
}
public FileD SelectById(int file_id)
{
lock (locker)
{
using (MySqlCommand sqlCommand = new MySqlCommand(selectbyid, connection))
{
using (MySqlDataReader reader = sqlCommand.ExecuteReader())
{
if (reader.Read())
{
FileD file = new FileD();
file.file_id = reader.GetInt32(0);
file.file_path = reader.IsDBNull(1) ? "" : reader.GetString(1);
file.file_name = reader.GetString(2);
file.file_type = reader.IsDBNull(3) ? "" : reader.GetString(3);
file.file_extension = reader.IsDBNull(4) ? "" : reader.GetString(4);
return(file);
}
else
{
return(null);
}
}
}
}
}
public FileD AddFile(FileD file)
{
if (file != null)
{
lock (locker)
{
using (MySqlCommand sqlCommand = new MySqlCommand(insert, connection))
{
sqlCommand.Parameters.AddWithValue("@file_path", file.file_path);
sqlCommand.Parameters.AddWithValue("@file_name", file.file_name);
sqlCommand.Parameters.AddWithValue("@file_type", file.file_type);
sqlCommand.Parameters.AddWithValue("@file_extension", file.file_extension);
sqlCommand.ExecuteNonQuery();
file.file_id = (int)sqlCommand.LastInsertedId;
sqlCommand.Dispose();
}
}
return(file);
}
return(null);
}