Esempio n. 1
0
        public List <Product> ProductList()
        {
            DataTable dt = new DataTable();

            dt = objblproduct.GetAllProduct();
            List <Product> lstcat = new List <Product>();
            Product        retobj;

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        retobj                 = new Product();
                        retobj.ProductId       = Convert.ToInt32(dt.Rows[i]["ProductId"].ToString());
                        retobj.ProductName     = dt.Rows[i]["ProductName"].ToString();
                        retobj.ProductImage    = dt.Rows[i]["ProductImage"].ToString();
                        retobj.ActualImage     = dt.Rows[i]["ActualImage"].ToString();
                        retobj.Description     = dt.Rows[i]["Description"].ToString();
                        retobj.InsertedBy      = dt.Rows[i]["InsertedBy"].ToString();
                        retobj.InsertedOn      = Convert.ToDateTime(dt.Rows[i]["InsertedOn"].ToString());
                        retobj.CategaryName    = dt.Rows[0]["CategaryName"].ToString();
                        retobj.SubCategaryName = dt.Rows[0]["SubCategaryName"].ToString();
                        retobj.SubCategaryId   = dt.Rows[0]["SubCategaryId"].ToString();
                        retobj.CategaryId      = dt.Rows[i]["CategaryId"].ToString();
                        retobj.UpdatedBy       = dt.Rows[i]["UpdatedBy"].ToString();
                        retobj.UpdatedOn       = Convert.ToDateTime(dt.Rows[i]["UpdatedOn"].ToString());
                        lstcat.Add(retobj);
                    }
                }
            }
            return(lstcat);
        }