protected void btnCheck_Click(object sender, EventArgs e)
{
List <CShoppingCart> cartList = Session["cart"] as List <CShoppingCart>;
CBookFactory bookfactory = new CBookFactory();
COrdersFactory orderfactory = new COrdersFactory();
int bookId, bookPrice, count, subtotal;
DateTime orderDate;
string note;
try
{
foreach (CShoppingCart c in cartList)
{
bookId = bookfactory.getbookId(c.書名);
bookPrice = Convert.ToInt32(c.單價);
count = Convert.ToInt32(c.數量);
subtotal = Convert.ToInt32(c.小計);
orderDate = Convert.ToDateTime(c.訂購日期);
note = "收件人姓名" + tboxName1.Text + "電話" + tboxPhone1.Text + "地址" + tboxAddress1.Text + "email" + tboxEmail1.Text +
"信用卡號碼" + tboxCardID.Text + "信用卡有效日期" + tboxCardMonth.Text + tboxCardYear.Text + "信用卡安全碼" + tboxSecurityID.Text;
COrders order = new COrders()
{
book_id = bookId, bookPrice = bookPrice, count = count, subtotal = subtotal, orderDate = orderDate, note = note
};
orderfactory.insertOrder(order);
}
}
catch (Exception)
{
Response.Write("<script>alert('" + orderfactory.message + "')</script>");
}
(Session["cart"] as List <CShoppingCart>).Clear();
Response.Write("<script>alert('" + orderfactory.message + "')</script>");
Response.Redirect("redirect.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
COrdersFactory factory = new COrdersFactory();
COrders order = new COrders()
{
book_id = 10002, bookPrice = 1200, count = 2, subtotal = 2400, orderDate = Convert.ToDateTime("2015/6/17"), note = "test"
};
factory.insertOrder(order);
}
private void reset_order_money(COrders order)
{
var menu = dao.get_Menu("name", order.menu);
//var menu = db.Menu.FirstOrDefault(x => x.name == order.menu);
if (menu != null)
{
if (order.priceType == "每小时")
{
order.money = Convert.ToDouble(menu.addMoney);
}
else if (order.comboId == null)
{
order.money = menu.price * order.number;
}
else if (order.comboId != null)
{
var combo = dao.get_Combo("id", order.comboId);
if (combo == null)
{
return;
}
var freeIds = combo.disAssemble_freeIds();
var pars = new List <string>();
var vals = new List <string>();
int count = freeIds.Count;
for (int i = 0; i < count; i++)
{
pars.Add("id");
vals.Add(freeIds[i].ToString());
}
var freeMenus = dao.get_Menus(pars, vals, "or").Select(x => x.name);
if (!freeMenus.Contains(order.menu))
{
order.money = menu.price * order.number;
}
}
}
else
{
var combo = dao.get_Combo("id", order.comboId);
order.money = combo.get_combo_price(dao);
}
}
public void insertOrder(COrders order)
{
try
{
SqlDataSource sds = new SqlDataSource();
sds.ConnectionString = connectionString;
sds.InsertCommand = "dbo.insertOrders";
sds.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
sds.InsertParameters.Add(new Parameter("book_id", DbType.Int32, order.book_id.ToString()));
sds.InsertParameters.Add(new Parameter("bookPrice", DbType.Int32, order.bookPrice.ToString()));
sds.InsertParameters.Add(new Parameter("count", DbType.Int32, order.count.ToString()));
sds.InsertParameters.Add(new Parameter("subtotal", DbType.Int32, order.subtotal.ToString()));
sds.InsertParameters.Add(new Parameter("orderDate", DbType.DateTime, order.orderDate.ToString()));
sds.InsertParameters.Add(new Parameter("note", DbType.String, order.note));
sds.Insert();
message = "insert success";
}
catch (Exception ex)
{
message = ex.Message;
}
}
