//By default get all public files public static List <File> GetFilesByAccessType(File.AccessType accessType = File.AccessType.PUBLIC) { List <File> fileList = new List <File>(); try { MySqlConnection conn = GetMySqlConnection(); MySqlCommand cmd = new MySqlCommand(GET_FILES_BY_ACCESS_TYPE_SQL, conn); cmd.Parameters.AddWithValue("@accessType", accessType.ToString()); MySqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { File newFile = new File(rdr.GetString(1), rdr.GetString(2), rdr.GetString(3), rdr.GetInt16(4), FileUtils.AccessTypeConverter(rdr.GetString(5)), rdr.GetDateTime(6)); fileList.Add(newFile); } rdr.Close(); } catch (Exception e) { //TO-DO } return(fileList); }
public static void UpdateAccessType(PrimaryKey pk, File.AccessType newAccessType) { try { MySqlConnection conn = GetMySqlConnection(); MySqlCommand cmd = new MySqlCommand(UPDATE_ACCESS_TYPE_SQL, conn); cmd.Parameters.AddWithValue("@fileName", pk.FileName); cmd.Parameters.AddWithValue("@owner", pk.Owner); cmd.Parameters.AddWithValue("@incCount", pk.IncCount); cmd.Parameters.AddWithValue("@newAccessType", newAccessType.ToString()); cmd.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine("Error: {0}", e.ToString()); } }
public static void InsertFile(PrimaryKey pk, String filePath, File.AccessType accessType = File.AccessType.PRIVATE) { try { MySqlConnection conn = GetMySqlConnection(); MySqlCommand cmd = new MySqlCommand(INSERT_SQL, conn); cmd.Parameters.AddWithValue("@fileName", pk.FileName); cmd.Parameters.AddWithValue("@owner", pk.Owner); cmd.Parameters.AddWithValue("@incCount", pk.IncCount); cmd.Parameters.AddWithValue("@filePath", filePath); cmd.Parameters.AddWithValue("@accessType", accessType.ToString()); cmd.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine("Error: {0}", e.ToString()); } }