public bool AddProduct(string ProductName, string ProductDesc,
string ProductPrice, string ProductCategory, string ProductImagePath)
{
var myProduct = new Product();
myProduct.ProductName = ProductName;
myProduct.Description = ProductDesc;
myProduct.UnitPrice = Convert.ToDouble(ProductPrice);
myProduct.ImagePath = ProductImagePath;
myProduct.CategoryID = Convert.ToInt32(ProductCategory);
using (ProductContext _db = new ProductContext())
{
_db.Products.Add(myProduct);
_db.SaveChanges();
}
return true;
}
protected void updateProductName_ServerValidate(object sender, ServerValidateEventArgs e)
{
//String connectionString = @"Data Source=DESKTOP-S3P3TBM\SQLEXPRESS;Initial Catalog=wingtiptoys.mdf;Integrated Security=True";
string connectionString = "Data Source=MYLAPTOP\\SQLEXPRESS;Database=wingtiptoys.mdf;Integrated Security=True";
string queryString = "SELECT * FROM dbo.Products WHERE ProductName = '" + DropDownUpdateProductName.SelectedItem.Text + "'";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(queryString, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
if (reader.Read())
{
//update product record in database
e.IsValid = true;
System.Diagnostics.Debug.WriteLine(e.Value.ToString() + " Exists");
//update product in database
using (var _db = new WingtipToys.Models.ProductContext())
{
var myItem = (from c in _db.Products where c.ProductName == DropDownUpdateProductName.SelectedItem.Text select c).FirstOrDefault();
if (myItem != null)
{
System.Diagnostics.Debug.WriteLine(myItem.Description);
//remove product from database
_db.Products.Remove(myItem);
_db.SaveChanges();
// Add product data to DB.
AddProducts products = new AddProducts();
var product = new WingtipToys.Models.Product();
//update name, description, and price, but keep same category id and image file path for now
bool addSuccess = products.AddProduct(DropDownUpdateProductName.SelectedItem.Text, UpdateProductDescription.Text,
UpdateProductPrice.Text, DropDownUpdateCategory.SelectedValue, myItem.ImagePath);
if (addSuccess)
{
// Reload the page.
string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect(pageUrl + "?ProductAction=add");
}
else
{
System.Diagnostics.Debug.WriteLine("Unable to add new product to database.");
}
}
else
{
System.Diagnostics.Debug.WriteLine("Unable to locate product.");
}
}
}
else
{
//Throw validation error because product does not exist and cannot be updated
e.IsValid = false;
System.Diagnostics.Debug.WriteLine(e.Value.ToString() + " Does not exist");
}
}
finally
{
reader.Close();
}
}
}