//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); }
// Translation method from ProductDTO to ProductBDO private void TranslateProductDTOToProductBDO(Product product, Product_BDO product_BDO) { product_BDO.Product_ID = product.ProductID; product_BDO.Product_Name = product.ProductName; product_BDO.CategoryRefID = product.CategoryRefID; product_BDO.Product_UPC = product.UPC; product_BDO.Product_Price = product.UnitPrice; }
public bool Create_Product(Product product_, ref string msg) { bool result = false; Product_BDO product_BDO = new Product_BDO(); TranslateProductDTOToProductBDO(product_, product_BDO); result = product_Logic.Create_Product(product_BDO, ref msg); return(result); }
//Given a Product_BDO, returns true/false depending on the success of the update public bool Update_Product_By_ID(ref Product_BDO product_BDO) { var product = Get_Product_By_ID(product_BDO.Product_ID); if (product == null) { return(false); } else { return(product_DAO.Update_Product_By_ID(ref product_BDO)); } }
//Given a Product_BDO, returns true/false depending on the success of the create public bool Create_Product(Product_BDO product_BDO, ref string message) { var product = new Product_BDO(); product = Get_Product_By_UPC(product_BDO.Product_UPC); if (product.Product_ID != 0) { message = "Product already exists!"; return(false); } else { message = "Product created"; return(product_DAO.Create_Product(ref product_BDO, ref message)); } }
//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); }
public bool UpdateProductByID(Product product) { var result = true; // Checking to see if price is valid if (product.UnitPrice <= 0) { result = false; } // UPC cannot be empty else if (product.UPC <= 0) { result = false; } // Product name cannot be empty else if (string.IsNullOrEmpty(product.ProductName)) { result = false; } // categoryID cannot be empty else if (product.CategoryRefID == 0) { result = false; } else { Product_BDO product_BDO = new Product_BDO(); TranslateProductDTOToProductBDO(product, product_BDO); return(product_Logic.Update_Product_By_ID(ref product_BDO)); } return(result); }