/// <summary>
/// Purpose: Add a new Product to the database
/// Accepts: Hashtable
/// Returns: String (Product Code)
/// </summary>
public string AddProduct(Hashtable hsh)
{
//The product code that was added to database
string retProdcd = "";
Product prod = new Product();
QuickStart_DBEntities dbContext;
try
{
dbContext = new QuickStart_DBEntities();
prod.ProductCode = Convert.ToString(hsh["productcode"]);
prod.Name = Convert.ToString(hsh["name"]);
prod.Brand = Convert.ToString(hsh["brand"]);
prod.Description = Convert.ToString(hsh["description"]);
prod.CategoryID = Convert.ToInt32(hsh["categoryid"]);
prod.MSRP = Convert.ToDouble(hsh["msrp"]);
prod.isFreeShipping = Convert.ToBoolean(hsh["isfreeshipping"]);
prod.isTaxFree = Convert.ToBoolean(hsh["istaxfree"]);
prod.QuantityInStock = Convert.ToInt32(hsh["quantityinstock"]);
prod.IsQuantityUnlimited = Convert.ToBoolean(hsh["isquantityunlimited"]);
prod.Created = DateTime.Now;
prod.Modified = null;
prod.isActive = true; //set to active
dbContext.AddToProducts(prod);
dbContext.SaveChanges();
retProdcd = prod.ProductCode;
dbContext.Detach(prod);
}
catch (Exception e)
{
ErrorRoutine(e, "ProductData", "AddProduct");
}
return retProdcd;
}
/// <summary>
/// Purpose: Update an existing Product in the database
/// Accepts: Hashtable
/// Returns: Boolean
/// </summary>
public bool UpdateProduct(Hashtable hsh)
{
bool isSuccess = false;
Product prod = new Product();
QuickStart_DBEntities dbContext;
try
{
dbContext = new QuickStart_DBEntities();
string prodcd = hsh["productcode"].ToString();
prod = dbContext.Products.FirstOrDefault(p => p.ProductCode == prodcd);
prod.Name = Convert.ToString(hsh["name"]);
prod.Brand = Convert.ToString(hsh["brand"]);
prod.Description = Convert.ToString(hsh["description"]);
prod.CategoryID = Convert.ToInt32(hsh["categoryid"]);
prod.MSRP = Convert.ToDouble(hsh["msrp"]);
prod.isFreeShipping = Convert.ToBoolean(hsh["isfreeshipping"]);
prod.isTaxFree = Convert.ToBoolean(hsh["istaxfree"]);
prod.QuantityInStock = Convert.ToInt32(hsh["quantityinstock"]);
prod.IsQuantityUnlimited = Convert.ToBoolean(hsh["isquantityunlimited"]);
//need 'modified' but not 'created' during an update
prod.Modified = DateTime.Now;
prod.isActive = Convert.ToBoolean(hsh["isactive"]);
dbContext.SaveChanges();
isSuccess = true;
}
catch (Exception e)
{
ErrorRoutine(e, "ProductData", "UpdateProduct");
}
return isSuccess;
}
/// <summary>
/// Deprecated Method for adding a new object to the Products EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToProducts(Product product)
{
base.AddObject("Products", product);
}
/// <summary>
/// Purpose: Grabs product information based on product code
/// Accepts: String
/// Returns: Hashtable
/// </summary>
public Hashtable GetProductByCode(string code)
{
Product obj = new Product();
QuickStart_DBEntities dbContext;
Hashtable hsh = new Hashtable();
try
{
dbContext = new QuickStart_DBEntities();
obj = dbContext.Products.FirstOrDefault(p => p.ProductCode == code);
if (obj != null)
{
hsh["productcode"] = obj.ProductCode;
hsh["name"] = obj.Name;
hsh["brand"] = obj.Brand;
hsh["description"] = obj.Description;
hsh["categoryid"] = obj.CategoryID;
hsh["msrp"] = obj.MSRP;
hsh["isfreeshipping"] = obj.isFreeShipping;
hsh["istaxfree"] = obj.isTaxFree;
hsh["quantityinstock"] = obj.QuantityInStock;
hsh["isquantityunlimited"] = obj.IsQuantityUnlimited;
hsh["created"] = obj.Created;
hsh["modified"] = obj.Modified;
hsh["isactive"] = obj.isActive;
}
}
catch (Exception ex)
{
ErrorLoggerData.ErrorRoutine(ex, "ProductData", "GetProductByCode");
}
return hsh;
}
/// <summary>
/// Create a new Product object.
/// </summary>
/// <param name="productCode">Initial value of the ProductCode property.</param>
public static Product CreateProduct(global::System.String productCode)
{
Product product = new Product();
product.ProductCode = productCode;
return product;
}