protected void Button1_Click(object sender, EventArgs e) { if (Session["CustomerUID"] != null && (dsPackage.dtSelectedPackageDataTable)Session["selectedPackage"] != null) { OrderPackageDetail opd; OrderPackage op = new OrderPackage(); clsPackage pk = new clsPackage(); DataTable dt = new DataTable(); DataTable dtOrderPackage = new DataTable(); int OrderPackageUID = 0; //Insert Order op.CustomerUID = Convert.ToInt32(Session["CustomerUID"]); op.OrderNo = lblOrderNo.Text.Trim(); op.OrderDate = Convert.ToDateTime(lblOrderDate.Text.Trim()); op.Total = Convert.ToDecimal(txtTotal.Text.Trim()); op.VAT = Convert.ToDecimal(txtVat.Text.Trim()); op.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim()); op.StatusFlage = "A"; op.CUser = 99; op.CWhen = DateTime.Now; op.MUser = 99; op.MWhen = DateTime.Now; db.OrderPackages.InsertOnSubmit(op); db.SubmitChanges(); //Insert Order Detail dtOrderPackage = pk.SearchPackageOrdeByOrderNo(lblOrderNo.Text.Trim()); if (dtOrderPackage.Rows.Count > 0 && dtOrderPackage != null) { OrderPackageUID = Convert.ToInt32(dtOrderPackage.Rows[0]["UID"]); dt = (dsPackage.dtSelectedPackageDataTable)Session["selectedPackage"]; for (int i = 0; i <= dt.Rows.Count - 1; i++) { opd = new OrderPackageDetail(); opd.OrderPackageUID = OrderPackageUID; opd.PackageUID = Convert.ToInt32(dt.Rows[i]["UID"]); opd.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]); opd.Qty = Convert.ToInt32(dt.Rows[i]["Qty"]); opd.Total = opd.UnitPrice * opd.Qty; opd.StatusFlag = "A"; opd.CUser = 99; opd.CWhen = DateTime.Now; opd.MUser = 99; opd.MWhen = DateTime.Now; db.OrderPackageDetails.InsertOnSubmit(opd); db.SubmitChanges(); opd = null; } } Session["OrderNo"] = lblOrderNo.Text.Trim(); Response.Redirect("PackageOrder3.aspx"); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('Session หมดอายุ กรุณาเลือกแพ็คเกจที่ต้องการใหม่อีกครั้งครับ')", true); } }
partial void DeleteOrderPackageDetail(OrderPackageDetail instance);
partial void UpdateOrderPackageDetail(OrderPackageDetail instance);
partial void InsertOrderPackageDetail(OrderPackageDetail instance);
protected void Button1_Click(object sender, EventArgs e) { if (Session["CustomerUID"] != null && (dsPackage.dtSelectedPackageDataTable)Session["selectedPackage"] != null) { OrderPackageDetail opd; OrderPackage op = new OrderPackage(); clsPackage pk = new clsPackage(); DataTable dt = new DataTable(); DataTable dtOrderPackage = new DataTable(); int OrderPackageUID = 0; //Insert Order op.CustomerUID = Convert.ToInt32(Session["CustomerUID"]); op.OrderNo = lblOrderNo.Text.Trim(); op.OrderDate = Convert.ToDateTime(lblOrderDate.Text.Trim()); op.Total = Convert.ToDecimal(txtTotal.Text.Trim()); op.VAT = Convert.ToDecimal(txtVat.Text.Trim()); op.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim()); op.StatusFlage = "A"; op.CUser = 99; op.CWhen = DateTime.Now; op.MUser = 99; op.MWhen = DateTime.Now; db.OrderPackages.InsertOnSubmit(op); db.SubmitChanges(); //Insert Order Detail dtOrderPackage = pk.SearchPackageOrdeByOrderNo(lblOrderNo.Text.Trim()); if(dtOrderPackage.Rows.Count > 0 && dtOrderPackage !=null) { OrderPackageUID = Convert.ToInt32(dtOrderPackage.Rows[0]["UID"]); dt = (dsPackage.dtSelectedPackageDataTable)Session["selectedPackage"]; for (int i = 0; i <= dt.Rows.Count - 1; i++) { opd = new OrderPackageDetail(); opd.OrderPackageUID = OrderPackageUID; opd.PackageUID = Convert.ToInt32(dt.Rows[i]["UID"]); opd.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]); opd.Qty = Convert.ToInt32(dt.Rows[i]["Qty"]); opd.Total = opd.UnitPrice * opd.Qty; opd.StatusFlag = "A"; opd.CUser = 99; opd.CWhen = DateTime.Now; opd.MUser = 99; opd.MWhen = DateTime.Now; db.OrderPackageDetails.InsertOnSubmit(opd); db.SubmitChanges(); opd = null; } } Session["OrderNo"] = lblOrderNo.Text.Trim(); Response.Redirect("PackageOrder3.aspx"); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('Session หมดอายุ กรุณาเลือกแพ็คเกจที่ต้องการใหม่อีกครั้งครับ')", true); } }