public static void insertMediaFile(DatabaseConnection db, Stream file, int id, Permissions per)
{
PreparedStatement stmt1 = db.Prepare("SELECT * FROM media WHERE id = " + id.ToString());
SqlDataReader reader = db.Query(null, stmt1);
Media mediaMeta = null;
while (reader.Read())
{
int mediaId = reader.GetInt32(reader.GetOrdinal("id"));
int mediaCategory = reader.GetInt32(reader.GetOrdinal("media_category_id"));
int user = reader.GetInt32(reader.GetOrdinal("user_account_id"));
string mediaFileLocation = reader.GetString(reader.GetOrdinal("file_location"));
string title = reader.GetString(reader.GetOrdinal("title"));
string description = reader.GetString(reader.GetOrdinal("description"));
int mediaLength = reader.GetInt32(reader.GetOrdinal("minutes"));
string format = reader.GetString(reader.GetOrdinal("format"));
mediaMeta = new Media(mediaId, mediaCategory, user, mediaFileLocation, title, description, mediaLength, format);
}
reader.Close();
string fileLocation = @"C:\RentItServices\Rentit26\MediaFiles\" + mediaMeta.id.ToString();
System.IO.Directory.CreateDirectory(fileLocation);
string fileDir = fileLocation + @"\" + mediaMeta.title + "." + mediaMeta.format;
FileStream writer = new FileStream(fileDir, FileMode.Create, FileAccess.Write);
byte[] bytes = new Byte[4096];
int bytesRead = 0;
while ((bytesRead = file.Read(bytes, 0, bytes.Length)) != 0)
{
writer.Write(bytes, 0, bytesRead);
}
file.Close();
writer.Close();
string fileStream = "http://rentit.itu.dk/RentIt26/MediaFiles/" + mediaMeta.id.ToString() + "/" + mediaMeta.title + "." + mediaMeta.format;
PreparedStatement stmt2 = db.Prepare("UPDATE media SET file_location = '"+fileStream+"' WHERE id = "+mediaMeta.id.ToString());
db.Command(null, stmt2);
}
public PermissionsTest()
{
dbCon = new DatabaseConnection("SMU");
permission = Permissions.createPermissions(new User(14, null, null, null), dbCon);
userHandler = new UserHandler(dbCon, permission);
}
