public Upload AddUpload(ref Upload upload)
{
lock (locker)
{
if (upload.upload_name != null)
{
if (upload.upload_name.Length > 30)
{
upload.upload_name = upload.upload_name.Substring(0, 30);
}
}
using (MySqlCommand command = new MySqlCommand(insertUpload, connection))
{
command.Parameters.AddWithValue("@upload_name", upload.upload_name);
command.Parameters.AddWithValue("@created_at", upload.created_at);
command.ExecuteNonQuery();
upload.upload_id = (int)command.LastInsertedId;
command.Dispose();
}
}
return(upload);
}
public List <Upload> GetListUploads()
{
List <Upload> uploads = new List <Upload>();
lock (locker)
{
using (MySqlCommand command = new MySqlCommand(insertUpload, connection))
{
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Upload upload = new Upload();
upload.upload_id = reader.GetInt32(0);
upload.upload_name = reader.GetString(1);
upload.created_at = reader.GetInt32(2);
uploads.Add(upload);
}
}
}
}
return(uploads);
}
