public List <KhuyenMaiDTO> select()
        {
            Fxuly xuLy = new Fxuly();
            List <KhuyenMaiDTO> listKM = new List <KhuyenMaiDTO>();
            string query = String.Empty;

            query += "select [MAKM], [TENKM], [TGBD], [TGKT], [MUCGIAMGIA] from [KHUYENMAI]";
            using (SqlConnection con = new SqlConnection(xuLy.ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.Connection  = con;
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = query;
                    try
                    {
                        con.Open();
                        SqlDataReader reader = null;
                        reader = cmd.ExecuteReader();
                        if (reader.HasRows == true)
                        {
                            while (reader.Read())
                            {
                                KhuyenMaiDTO db = new KhuyenMaiDTO();
                                db.Makm       = int.Parse(reader["MAKM"].ToString());
                                db.Tenkm      = reader["TENKM"].ToString();
                                db.TgBD       = DateTime.Parse(reader["TGBD"].ToString());
                                db.TgKT       = DateTime.Parse(reader["TGKT"].ToString());
                                db.Mucgiamgia = int.Parse(reader["MUCGIAMGIA"].ToString());
                                listKM.Add(db);
                            }
                        }
                        con.Close();
                        con.Dispose();
                    }
                    catch (Exception ex)
                    {
                        con.Close();
                        con.Dispose();
                    }
                }
                return(listKM);
            }
        }
        public List <KhuyenMaiDTO> selectLoadCB()
        {
            string query = String.Empty;
            Fxuly  xuLy  = new Fxuly();

            query += "select [MAKM], [TENKM], [MUCGIAMGIA] FROM [KHUYENMAI] ";
            List <KhuyenMaiDTO> list = new List <KhuyenMaiDTO>();

            using (SqlConnection con = new SqlConnection(xuLy.ConnectionString))
            {
                using (SqlCommand cmd = new SqlCommand())
                {
                    cmd.Connection  = con;
                    cmd.CommandType = System.Data.CommandType.Text;
                    cmd.CommandText = query;
                    try
                    {
                        con.Open();
                        SqlDataReader reader = null;
                        reader = cmd.ExecuteReader();
                        if (reader.HasRows == true)
                        {
                            while (reader.Read())
                            {
                                KhuyenMaiDTO kn = new KhuyenMaiDTO();
                                kn.maKhuyenMai  = int.Parse(reader["MAKM"].ToString());
                                kn.tenKhuyenMai = reader["TENKM"].ToString();
                                kn.mucKhuyenMai = int.Parse(reader["MUCGIAMGIA"].ToString());
                                list.Add(kn);
                            }
                        }
                        con.Close();
                        con.Dispose();
                    }
                    catch (Exception ex)
                    {
                        con.Close();
                        return(null);
                    }
                }
                return(list);
            }
        }