//saves an order
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
using (sales db = new sales())
{
Order obj = new Order();
obj.qty = Convert.ToInt32(txtqty.Text);
obj.orderDate = Convert.ToDateTime(txtOrderDate.Text);
obj.shipDate = Convert.ToDateTime(txtShipDate.Text);
obj.tax = Convert.ToDouble(txtTax.Text);
obj.estimateShipDate = Convert.ToDateTime(txtEstShipDate.Text);
obj.price = Convert.ToDecimal(txtPrice.Text);
//save
db.Orders.Add(obj);
db.SaveChanges();
}
}
catch (Exception ex)
{
Response.Redirect("/error.aspx");
}
}
//purchase product on btn click and save data to database
protected void btnBuy_Click(object sender, EventArgs e)
{
try
{
using (sales db = new sales())
{
DateTime today = DateTime.Now;
Order obj = new Order();
obj.productID = Convert.ToInt32(ddlProduct.SelectedValue);
obj.qty = Convert.ToInt32(txtqty.Text);
obj.price = 10000.00m;
obj.shipDate = today;
obj.orderDate = today;
obj.tax = .11;
//save
db.Orders.Add(obj);
db.SaveChanges();
}
}
catch (Exception ex)
{
Response.Redirect("/error.aspx");
}
}