//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);
}
