public List <ProductDO> GetAllProducts()
{
SqlCommand cmd = new SqlCommand("select * from product", conn);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
SubCategoryManagement subCategoryManagement = new SubCategoryManagement();
BrandManagement brandManagement = new BrandManagement();
var query = from p in ds.Tables[0].AsEnumerable()
select new ProductDO
{
Product_ID = Convert.ToInt32(p[0]),
Product_Name = p[1].ToString(),
Price = Convert.ToInt32(p[2]),
SubCategory = subCategoryManagement.GetSubCategoryByID(Convert.ToInt32(p[3])),
Brand = brandManagement.GetBrandByID(Convert.ToInt32(p[4])),
Size = p[5].ToString(),
Color = p[6].ToString(),
Product_Image = p[7].ToString(),
Description = p[8].ToString(),
Quantity = Convert.ToInt32(p[9]),
//UpdatedDate = Convert.ToDateTime(p[10])
};
return(query.ToList());
}
public ProductDO GetProductByID(int Product_ID)
{
SqlCommand cmd = new SqlCommand("Select * from Product where Product_ID = @Product_ID", conn);
cmd.Parameters.AddWithValue("@Product_ID", Product_ID);
SqlDataReader reader = null;
ProductDO modelData = new ProductDO();
SubCategoryManagement subCategoryManagement = new SubCategoryManagement();
BrandManagement brandManagement = new BrandManagement();
conn.Open();
reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
modelData.Product_ID = Convert.ToInt32(reader[0]);
modelData.Product_Name = reader[1].ToString();
modelData.Price = Convert.ToInt32(reader[2]);
//modelData.Category_ID = Convert.ToInt32(reader[3]);
modelData.SubCategory_ID = Convert.ToInt32(reader[3]);
modelData.SubCategory = subCategoryManagement.GetSubCategoryByID(Convert.ToInt32(reader[3]));
modelData.Brand_ID = Convert.ToInt32(reader[4]);
modelData.Brand = brandManagement.GetBrandByID(Convert.ToInt32(reader[4]));
modelData.Size = reader[5].ToString();
modelData.Color = reader[6].ToString();
modelData.Product_Image = reader[7].ToString();
modelData.Description = reader[8].ToString();
modelData.Quantity = Convert.ToInt32(reader[9]);
//modelData.UpdatedDate = Convert.ToDateTime(reader[10]);
}
// reader.Close();
conn.Close();
return(modelData);
}