protected void AddProductButton_Click(object sender, CommandEventArgs e)
{
if (e.CommandName == "Add")
{
Page.Validate("Add");
}
Boolean fileOK = false;
String path = Server.MapPath("~/Catalog/Images/");
if (ProductImage.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(ProductImage.FileName).ToLower();
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
// Save to Images folder.
ProductImage.PostedFile.SaveAs(path + ProductImage.FileName);
// Save to Images/Thumbs folder.
ProductImage.PostedFile.SaveAs(path + "Thumbs/" + ProductImage.FileName);
}
catch (Exception ex)
{
LabelAddStatus.Text = ex.Message;
}
// Add product data to DB.
AddProducts products = new AddProducts();
bool addSuccess = products.AddProduct(AddProductName.Text, AddProductDescription.Text,
AddProductPrice.Text, DropDownAddCategory.SelectedValue, ProductImage.FileName);
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
{
LabelAddStatus.Text = "Unable to add new product to database.";
}
}
else
{
LabelAddStatus.Text = "Unable to accept file type.";
}
}
protected void AddProductBtn_Click(object sender, EventArgs e)
{
bool fileOk = false;
string path = Server.MapPath("~/Catalog/Images/");
if (ProductImage.HasFile)
{
string uploadedFileExt = Path.GetExtension(ProductImage.FileName).ToLower();
string[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
fileOk = allowedExtensions.Any(ext => ext == uploadedFileExt);
}
if (!fileOk)
{
AlertBox.Attributes.Add("class", AlertBox.Attributes["class"].Replace("alert-success", "alert-danger"));
AlertBox.Visible = true;
LabelAlertStatus.Text = "Unable to accept file type.";
return;
}
else
{
try
{
// Save to Images folder.
ProductImage.PostedFile.SaveAs(path + ProductImage.FileName);
// Save to Images/Thumb folder.
ProductImage.PostedFile.SaveAs(path + "Thumbs/" + ProductImage.FileName);
}
catch(Exception ex)
{
AlertBox.Attributes.Add("class", AlertBox.Attributes["class"].Replace("alert-success", "alert-danger"));
AlertBox.Visible = true;
LabelAlertStatus.Text = ex.Message;
}
// Add product data to DB.
AddProducts products = new AddProducts();
bool addSuccess = products.AddProduct(
AddProductName.Text, AddProductDescription.Text, AddProductPrice.Text,
DropDownAddCategory.SelectedValue, ProductImage.FileName
);
if(!addSuccess)
{
AlertBox.Attributes.Add("class", AlertBox.Attributes["class"].Replace("alert-success", "alert-danger"));
AlertBox.Visible = true;
LabelAlertStatus.Text = "Unable to add new product to database.";
return;
}
else
{
Response.Redirect($"{GetPageUrl()}?ProductAction=add");
}
}
}
protected void AddProductButton_Click(object sender, EventArgs e)
{
Boolean fOK = false;
String path = Server.MapPath("~/Catalog/Images/");
if (ProductImage.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(ProductImage.FileName).ToLower();
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fOK = true;
}
}
}
if (fOK)
{
try
{
// Zapis obraz
ProductImage.PostedFile.SaveAs(path + ProductImage.FileName);
// Zapis miniaturę obrazu.
ProductImage.PostedFile.SaveAs(path + "Thumbs/" + ProductImage.FileName);
}
catch (Exception ex)
{
LabelAddStatus.Text = ex.Message;
}
// Dodaj produkt do bazy danych DB.
AddProducts products = new AddProducts();
bool addSuccess = products.AddProduct(AddProductName.Text, AddProductDescription.Text,
AddProductPrice.Text, DropDownAddCategory.SelectedValue, ProductImage.FileName);
if (addSuccess)
{
// Przeładuj stronę.
string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect(pageUrl + "?ProductAction=add");
}
else
{
LabelAddStatus.Text = "Nie udało się dodać produktu do bazy danych.";
}
}
else
{
LabelAddStatus.Text = "Zły fomat pliku z zdjeciem, użyj: .gif, .png, .jpeg, .jpg .";
}
}
// Kada se klikne na AddProductButton, kod proverava HasFile svojstvo kontrole FileUpload.
//Ako kontrola ima datoteku i ako je dozvoljen tip datoteke (na osnovu ekstenzije datoteke), slika se čuva u \
//folderu Slike i folderu Images / Thumbs aplikacije.
protected void AddProductButton_Click(object sender, EventArgs e)
{
Boolean fileOK = false;
String path = Server.MapPath("~/Catalog/Images/");
if (ProductImage.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(ProductImage.FileName).ToLower();
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
// Save to Images folder.
ProductImage.PostedFile.SaveAs(path + ProductImage.FileName);
// Save to Images/Thumbs folder.
ProductImage.PostedFile.SaveAs(path + "Thumbs/" + ProductImage.FileName);
}
catch (Exception ex)
{
LabelAddStatus.Text = ex.Message;
}
// Add product data to DB.
AddProducts products = new AddProducts();
bool addSuccess = products.AddProduct(AddProductName.Text, AddProductDescription.Text,
AddProductPrice.Text, DropDownAddCategory.SelectedValue, ProductImage.FileName);
if (addSuccess)
{
// Ponovo ucitajte stranicu.
string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect(pageUrl + "?ProductAction=add");
}
else
{
LabelAddStatus.Text = "Nije moguce dodati novi proizvod u bazu podataka";
}
}
else
{
LabelAddStatus.Text = "Nije moguce prihvatiti tip datoteke.";
}
}
protected void AddProductButton_Click(object sender, EventArgs e)
{
var fileOk = false;
var path = Server.MapPath("~/Catalog/Images/");
if (ProductImage.HasFile)
{
var fileExtension = Path.GetExtension(ProductImage.FileName).ToLower();
string[] allowedExtensions = { ".gif", ".png", ".jpg", ".jpeg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOk = true;
}
}
}
if (fileOk)
{
try {
// Save to Images folder
ProductImage.PostedFile.SaveAs(path + ProductImage.FileName);
// Save to Images/Thumbs folder.
ProductImage.PostedFile.SaveAs($"{path}Thumbs/{ProductImage.FileName}");
} catch (Exception ex) {
LabelAddStatus.Text = ex.Message;
}
// Add product data to db
var products = new AddProducts();
var addSuccess = products.AddProduct(AddProductName.Text, AddProductDescription.Text, AddProductPrice.Text, ddlAddCategory.SelectedValue, ProductImage.FileName);
if (addSuccess)
{
// Reload the page
var pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect($"{pageUrl}?ProductAction=add");
}
else
{
LabelAddStatus.Text = "Unable to add new product to database";
}
}
else
{
LabelAddStatus.Text = "Unable to accept file type";
}
}
protected void AddProductButton_Click(object sender, EventArgs e)
{
string path = Server.MapPath("~/Catalog/Images/");
if (ProductImage.HasFile)
{
string fileExtension = System.IO.Path.GetExtension(ProductImage.FileName).ToLower();
string[] allowedextensions = { ".gif", ".png", ".jpeg", ".jpg" };
if (allowedextensions.Contains(fileExtension))
{
try
{
ProductImage.PostedFile.SaveAs(path + ProductImage.FileName);
ProductImage.PostedFile.SaveAs(path + "Thumbs/" + ProductImage.FileName);
}
catch (Exception ex)
{
LabelAddStatus.Text = ex.Message;
}
}
}
else
{
LabelAddStatus.Text = "Unable to accept file type.";
}
AddProducts products = new AddProducts();
bool addSuccess = products.AddProduct(AddProductName.Text, AddProductDescription.Text, AddProductPrice.Text, DropDownAddCategory.SelectedValue, ProductImage.FileName);
if (addSuccess)
{
string pageUrl = Request.Url.AbsoluteUri.Substring(0,
Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect(pageUrl + "?ProductAction=add");
}
else
{
LabelAddStatus.Text = "Unable to add new product to database.";
}
}
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();
}
}
}
protected void orderButton_Click(object sender, EventArgs e)
{
double total = 0.0;
string size, crust, sauce;
string topping = "";
if (smallButton.Checked)
{
total = 10.0;
size = "Size :Small,";
}
else if (mediumButton.Checked)
{
total = 13.0;
size = "Size :Medium,";
}
else
{
total = 16.0;
size = "Size :Large,";
}
if (regularButton.Checked)
{
total += 2.0;
crust = "Crust :Regular,";
}
else if (thinButton.Checked)
{
total += 4.0;
crust = "Crust :Thin,";
}
else
{
total += 6.0;
crust = "Crust :Thick,";
}
if (bbqButton.Checked)
{
total += 2.0;
sauce = "BBQ,";
}
else
{
total += 1.75;
sauce = "Pesto,";
}
List <String> toppingList = new List <string>();
foreach (ListItem item in CheckBoxList1.Items)
{
if (item.Selected)
{
toppingList.Add(item.Value);
topping += item.Value + ",";
total += 2.0;
}
}
/* if (pepperoniCheckbox.Checked)
* {
* total += 1.5;
* topping += "Pepperoni,";
* }
* else if (hamCheckbox.Checked)
* {
* total += 2.0;
* topping += "Ham,";
* }
* else if (freshgarlicCheckbox.Checked)
* {
* total += 0.75;
* topping += "Fresh Garlic,";
* }
* else if (onionCheckbox.Checked)
* {
* total += 0.75;
* topping += "Onion";
* }
* else if (mushroomCheckbox.Checked)
* {
* total += 0.75;
* topping += "Mushroom,";
* }
* else if (baconCheckbox.Checked)
* {
* total += 2.0;
* topping += "Bacon,";
* }
* else if (sausageCheckbox.Checked)
* {
* total += 1.5;
* topping += "Sausage";
*
* }*/
/* total = (pepperoniCheckbox.Checked) ? total + 1.5 : total;
* total = (hamCheckbox.Checked) ? total + 2.0 : total;
* total = (greenpepperCheckbox.Checked) ? total + 0.75 : total;
* total = (freshgarlicCheckbox.Checked) ? total + 1.5 : total;
* total = (onionCheckbox.Checked) ? total + 0.75 : total;
* total = (mushroomCheckbox.Checked) ? total + 0.75 : total;
* total = (baconCheckbox.Checked) ? total + 2.0 : total;
* total = (sausageCheckbox.Checked) ? total + 1.5 : total;*/
resultTotal.Text = total.ToString();
resulttext.Text = ("Size :" + size + "Crust :" + crust + "Sauce :" + sauce + "Topping :" + topping).ToString();
Label1.Text = "6";
Label2.Text = "pizzahotdog.jpg";
AddProducts products = new AddProducts();
products.AddProduct("Special :" + foodname.Text, resulttext.Text, resultTotal.Text, Label1.Text, Label2.Text);
Status.Text = "Your Own Food Create Successfully :)";
}
protected void UpdateProductButton_Click(object sender, EventArgs e)
{
Boolean fileOK = false;
String path = Server.MapPath("~/Catalog/Images/");
if (UpdateFileUpload.HasFile)
{
String fileExtension = System.IO.Path.GetExtension(UpdateFileUpload.FileName).ToLower();
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg" };
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOK = true;
}
}
}
if (fileOK)
{
try
{
// Save to Images folder.
UpdateFileUpload.PostedFile.SaveAs(path + UpdateFileUpload.FileName);
// Save to Images/Thumbs folder.
UpdateFileUpload.PostedFile.SaveAs(path + "Thumbs/" + UpdateFileUpload.FileName);
}
catch (Exception ex)
{
LabelAddStatus.Text = ex.Message;
}
// Add product data to DB.
AddProducts products = new AddProducts();
var ID = Convert.ToInt16(DropDownRemoveProduct.SelectedValue);
bool addSuccess = false;
using (var db = new ApplicationDbContext())
{
if (db.Products.Any(p => p.ProductID == ID))
{
addSuccess = products.AddProduct(UpdateNameTextBox.Text, UpdateDescriptionTextBox.Text,
UpdatePriceTextBox.Text, UpdateCategoryDropDownList.SelectedValue, UpdateFileUpload.FileName, ID);
}
else
{
addSuccess = products.AddProduct(UpdateNameTextBox.Text, UpdateDescriptionTextBox.Text,
UpdatePriceTextBox.Text, UpdateCategoryDropDownList.SelectedValue, UpdateFileUpload.FileName);
}
}
if (addSuccess)
{
// Reload the page.
Session["OutcomeMessage"] = ID == 0 ? "Added new product " + UpdateNameTextBox.Text : "Updated product " + UpdateNameTextBox.Text;
string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
Response.Redirect(pageUrl /*+ "?ProductAction=add"*/);
}
else
{
LabelAddStatus.Text = "Unable to add new product to database.";
}
}
else
{
LabelAddStatus.Text = "Unable to accept file type.";
}
}
