using CurrenciesDAL.Models;

using CurrenciesDAL;

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

​

namespace CurrenciesDAL

{

    public static class ColoursManager

    {

        public static Colour GetColour(int colourId, string name)

        {

            //get connection from DB class

​

            using (SqlConnection conn = DB.GetConnection())

            {

                using (SqlCommand cmd = new SqlCommand())

                {

                    cmd.Connection = conn;

                    cmd.CommandText = "SELECT * FROM Colours WHERE Id = " +colourId + "AND name = " + name + ";";

​

                    SqlDataReader reader = cmd.ExecuteReader();

​

                    if (reader.HasRows)

                    {

                        //generate a new category object

                        //and fill it with data from the reader

                        Colour c = new Colour();

                        c.Id = reader.GetInt32(0);

                        c.Name = reader.GetString(1);

                        return c;

​

                    }

                    else

                    {

                        return null;

                    }

                }

            }

        }

        public static List<Colour> GetColourList(int Id, string name)

        {

            //create empty list to hold currency objects

            List<Colour> colours = new List<Colour>();

​

            //get a connection from DB class

            using (SqlConnection conn = DB.GetConnection())

            {   //create a command using the connection

                using (SqlCommand cmd = new SqlCommand())

                {

                    cmd.Connection = conn;

                    cmd.CommandText = "SELECT * FROM Colours WHERE Id = " +colourId + "AND name = " + name + ";";

​

                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())

                    {

                        //generatate a new category object

                        //and fill it with data from the reader

                        Colour colour = new Colour();

                        colour.Id = reader.GetInt32(0);

                        colour.Name = reader.GetString(1);

                        //add the filled category to my list

                        colour.Add(currency);

                    }

                }

            }

​

            //return the list

            return colour;

        }

    }

};