Example #1
0
        Select(string name)

        {
            using (var Context = new Model.DomainModel.DTO.EF.onlineshopingEntities())

            {
                List <Model.Helper.SpHelper.Product1.Getproducthelper> listproduct
                    = new List <Helper.SpHelper.Product1.Getproducthelper>();
                try
                {
                    return(Context.Database.SqlQuery
                           <Model.Helper.SpHelper.Product1.Getproducthelper>
                               (Model.Helper.SpHelper.Product1.Productsphelper.Usp_Getproduct, new SqlParameter("@categoryname", name)).ToList());
                }
                catch (Exception)
                {
                    throw;
                }
            }
        }
Example #2
0
 public List <Model.Helper.SpHelper.Category.Getcategoryhelper> Select()
 {
     using (var Context = new Model.DomainModel.DTO.EF.onlineshopingEntities())
     {
         List <Helper.SpHelper.Category.Getcategoryhelper>
         list_Category = new List
                         <Helper.SpHelper.Category.Getcategoryhelper>();
         try
         {
             list_Category = (Context.Database.SqlQuery
                              <Model.Helper.SpHelper.Category.Getcategoryhelper>
                                  (Model.Helper.SpHelper.Category.Categorysphelper.Usp_getcategory)).ToList();
         }
         catch (Exception)
         {
             throw;
         }
         return(list_Category);
     }
 }