public ActionResult Create([Bind(Include = "OrderID,CustomerID,EmployeeID,OrderDate,RequiredDate,ShippedDate,ShipperID,Freight,ShipName,ShipAddress,ShipCity,ShipRegion,ShipPostalCode,ShipCountry,productName,UnitPrice,Qty")] Orders orders)
{
if (ModelState.IsValid)
{
orders.Freight = (string.IsNullOrEmpty(orders.Freight.ToString())) ? 0 : orders.Freight;
orders.ShipCountry = (string.IsNullOrEmpty(orders.ShipCountry)) ? string.Empty : orders.ShipCountry;
orders.ShipCity = (string.IsNullOrEmpty(orders.ShipCity)) ? string.Empty : orders.ShipCity;
orders.ShipRegion = (string.IsNullOrEmpty(orders.ShipRegion)) ? string.Empty : orders.ShipRegion;
orders.ShipPostalCode = (string.IsNullOrEmpty(orders.ShipPostalCode)) ? string.Empty : orders.ShipPostalCode;
orders.ShipAddress = (string.IsNullOrEmpty(orders.ShipAddress)) ? string.Empty : orders.ShipAddress;
orders.ShipName = (string.IsNullOrEmpty(orders.ShipName)) ? string.Empty : orders.ShipName;
db.Orders.Add(orders);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "FullName");
ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CompanyName");
ViewBag.ShipperID = new SelectList(db.Shippers, "ShipperID", "CompanyName");
ViewBag.productName = new SelectList(db.Products, "ProductID", "ProductName");
return(View(orders));
}
protected void Button1_Click1(object sender, EventArgs e)
{
using (TSQL2012Entities myEntities = new TSQL2012Entities())
{
var del = (from review in myEntities.Products
where review.productid == id
select review).SingleOrDefault();
myEntities.Products.Remove(del);
myEntities.SaveChanges();
}
id_tx.Text = string.Empty;
}
protected void Button1_Click(object sender, EventArgs e)
{
using (TSQL2012Entities myEntities = new TSQL2012Entities())
{
var obj = new Product();
obj.productname = name_tx.Text;
obj.supplierid = Convert.ToInt32(DropDownList1.SelectedValue);
obj.categoryid = Convert.ToInt32(DropDownList2.SelectedValue);
obj.unitprice = Convert.ToDecimal(price_tx.Text);
obj.discontinued = Discont_check.Checked;
myEntities.Products.Add(obj);
myEntities.SaveChanges();
}
name_tx.Text = string.Empty;
price_tx.Text = string.Empty;
Discont_check.Checked = false;
grid.Visible = true;
}
protected void Button1_Click(object sender, EventArgs e)
{
using (TSQL2012Entities myEntities = new TSQL2012Entities())
{
var update = (from review in myEntities.Products
where review.productid == id
select review).SingleOrDefault();
update.productname = name_tx.Text;
update.supplierid = Convert.ToInt32(DropDownList1.SelectedValue);
update.categoryid = Convert.ToInt32(DropDownList2.SelectedValue);
update.unitprice = Convert.ToDecimal(price_tx.Text);
update.discontinued = Discont_check.Checked;
myEntities.SaveChanges();
}
name_tx.Text = string.Empty;
price_tx.Text = string.Empty;
Discont_check.Checked = false;
grid.Visible = true;
}
