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);
        }
    }