Example #1
0
        public ChitietSP BS_ChitietSP(int id)
        {
            try
            {
                ChitietSP ct_sp = new ChitietSP();

                var _id = new SqlParameter
                {
                    ParameterName = "id",
                    Value         = id
                };
                var _id2 = new SqlParameter
                {
                    ParameterName = "id",
                    Value         = id
                };
                var _id3 = new SqlParameter
                {
                    ParameterName = "id",
                    Value         = id
                };

                ct_sp = db.Database.SqlQuery <ChitietSP>(
                    "thongtinsp_theoid @id", _id).FirstOrDefault();

                if (ct_sp != null)
                {
                    List <ImgProduct> lst = new List <ImgProduct>();
                    lst          = db.Database.SqlQuery <ImgProduct>("ds_anhsp_theoid_sp @id", _id2).ToList();
                    ct_sp.LstImg = lst;


                    List <AttrProduct> lstAttr = new List <AttrProduct>();
                    lstAttr = db.Database.SqlQuery <AttrProduct>("ds_thuoctinh_sp_theoid_sp @id", _id3).ToList();
                    ct_sp.LstAttrProduct = lstAttr;
                }

                return(ct_sp);
            }
            catch (Exception e)
            {
                return(null);
            }
        }