public ProductSearchResponse GetAllProducts() { List<Product> products = new List<Product>(); productDataManager = new ProductDataManager(); DataSet ds = productDataManager.GetAllProducts(); ProductSearchResponse response = new ProductSearchResponse(); DataTable dt = new DataTable(); dt = ds.Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { Product product = new Product(); product.Id = Convert.ToInt32(dr["Id"]); product.Name = dr["Name"].ToString(); product.Description = dr["Description"].ToString(); product.Price = Convert.ToDecimal(dr["Price"]); product.Status = dr["Status"].ToString(); product.Category = new Category(); product.Category.CategoryName = Convert.ToString(dr["CategoryName"]); if (dr["CategoryId"] != System.DBNull.Value) { product.Category.CategoryId = Convert.ToInt32(dr["CategoryId"]); } products.Add(product); } } // NoOfRows = dt.Rows.Count; response.ProductList = products; response.Count = Convert.ToInt32(ds.Tables[1].Rows[0][0]); return response; }
public CategorySearchResponse GetCategories() { List<Category> categories = new List<Category>(); productDataManager = new ProductDataManager(); DataSet ds = productDataManager.GetCategories(); CategorySearchResponse response = new CategorySearchResponse(); DataTable dtCategory=new DataTable(); dtCategory = ds.Tables[0]; if (dtCategory.Rows.Count > 0) { foreach (DataRow dr in dtCategory.Rows) { Category category = new Category(); category.CategoryId = Convert.ToInt32(dr["CategoryId"]); category.CategoryName = dr["CategoryName"].ToString(); categories.Add(category); } } response.CategoryList = categories; return response; }
public int DeleteProducts(int Id) { productDataManager = new ProductDataManager(); return productDataManager.DeleteProducts(Id); }
public int UpdateProducts(Product product) { productDataManager = new ProductDataManager(); return productDataManager.UpdateProducts(product.Id,product.Name, product.Description, product.Price, product.Status,product.Category.CategoryId); }
public int InsertProduct(Product product) { productDataManager = new ProductDataManager(); return productDataManager.InsertProduct(product.Name, product.Description, product.Price, product.Status, product.Category.CategoryId); }
public int InsertCategory(Category category) { productDataManager = new ProductDataManager(); return productDataManager.InsertCategory(category.CategoryName,category.ImageName,category.ParentId); }