public static FolderModel GetFolder(string id) { FolderModel folder = new FolderModel(); conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { string query = "SELECT * FROM [gallery].[dbo].[Folder] WHERE id=" + id; System.Diagnostics.Debug.WriteLine("Zapytanie: " + query); SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { folder.id = dr["ID"].ToString(); folder.name = dr["Name"].ToString(); folder.description = dr["Description"].ToString(); folder.miniatureID = dr["MiniatureID"].ToString(); Console.WriteLine(); } } conn.Close(); return(folder); }
public static List <FolderModel> GetAllFolders() { List <FolderModel> folders = new List <FolderModel>(); conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { string query = "SELECT * FROM [gallery].[dbo].[Folder]"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { FolderModel folder = new FolderModel(); folder.id = dr["ID"].ToString(); folder.name = dr["Name"].ToString(); folder.description = dr["Description"].ToString(); folder.miniatureID = dr["MiniatureID"].ToString(); folders.Add(folder); Console.WriteLine(); } } conn.Close(); return(folders); }
public static void EditFolder(FolderModel folder) { conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { string query = "UPDATE [gallery].[dbo].[Folder] SET Name = '" + folder.name + "', Description = '" + folder.description + "', MiniatureID = '" + folder.miniatureID + "' WHERE id=" + folder.id; System.Diagnostics.Debug.WriteLine("Zapytanie: " + query); SqlCommand cmd = new SqlCommand(query, conn); cmd.ExecuteNonQuery(); } conn.Close(); }
public static void AddFolder(FolderModel folder) { conn.Open(); if (conn.State == System.Data.ConnectionState.Open) { string query = "INSERT INTO [gallery].[dbo].[Folder] (Name, Description, MiniatureID) VALUES ('" + folder.name + "', '" + folder.description + "', '" + folder.miniatureID + "')"; System.Diagnostics.Debug.WriteLine("Zapytanie: " + query); SqlCommand cmd = new SqlCommand(query, conn); cmd.ExecuteNonQuery(); } conn.Close(); }