//Given an ID, fetch Product from Products table //Returns a Product_BDO object public Product_BDO Get_Product_By_ID(int product_ID) { //Create Product_BDO object Product_BDO product_BDO = new Product_BDO(); //Create new DTO object for Product query result DataModel.Product product_DTO_Result = new DataModel.Product(); //Call Product_Qs.Get_Product_By_ID Product_Qs product_Query = new Product_Qs(); product_DTO_Result = product_Query.Get_Product_By_ID(product_ID); //If Product is found, translate to BDO object if (product_DTO_Result.Product_ID != 0) { product_BDO.Product_ID = product_DTO_Result.Product_ID; product_BDO.Product_Name = product_DTO_Result.Product_Name; product_BDO.Product_UPC = product_DTO_Result.Product_UPC; product_BDO.Product_Price = product_DTO_Result.Product_Price; product_BDO.CategoryRefID = product_DTO_Result.CategoryRefID; } return(product_BDO); }
//Given a Product_BDO object, add to Products table //Returns a boolean public bool Create_Product(ref Product_BDO product_BDO, ref string message) { bool ret = false; //Create new DTO object for Product query DataModel.Product product_DTO = new DataModel.Product(); //Translate BDO to DTO for Product_Qs product_DTO.Product_Name = product_BDO.Product_Name; product_DTO.Product_UPC = product_BDO.Product_UPC; product_DTO.Product_Price = product_BDO.Product_Price; product_DTO.CategoryRefID = product_BDO.CategoryRefID; //Call Product_Qs.Create Product_Qs product_Create_Query = new Product_Qs(); ret = product_Create_Query.Create(product_DTO, ref message); return(ret); }
//Given a Product_BDO object, update the Products table on Product_ID //Returns a boolean public bool Update_Product_By_ID(ref Product_BDO product_BDO) { var ret = false; //Create new DTO object for Product query DataModel.Product product_DTO = new DataModel.Product(); //Translate BDO to DTO for Product_Qs product_DTO.Product_ID = product_BDO.Product_ID; product_DTO.Product_Name = product_BDO.Product_Name; product_DTO.Product_UPC = product_BDO.Product_UPC; product_DTO.Product_Price = product_BDO.Product_Price; product_DTO.CategoryRefID = product_BDO.CategoryRefID; //Call Product_Qs.Update Product_Qs product_Update_Query = new Product_Qs(); ret = product_Update_Query.Update_Product_By_Product_ID(product_DTO); return(ret); }