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); }