public void getdatarepeater()
{
DataTable dt = new DataTable();
dt.Columns.Add("Quantity");
dt.Columns.Add("Product");
//dt.Columns.Add("ProductDetail");
dt.Columns.Add("Price");
//dt.Columns.Add("Checkin");
//dt.Columns.Add("Checkout");
//dt.Columns.Add("Quantity");
dt.Columns.Add("Total");
dt.Columns.Add("ProductOrderID");
decimal total = 0;
long ID = long.Parse(Request.QueryString["Id"]);
CommonClassLibrary.CommonDataSet.ProductOrderDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.ProductOrderTableAdapter().GetDataByTicketOrder(ID);
foreach (CommonClassLibrary.CommonDataSet.ProductOrderRow item in collection)
{
CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProductShowName(item.Product);
foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item2 in collection2)
{
total += item.Total;
dt.Rows.Add(item2.KeyValue, item.Price.ToString("#,###") + ".-", item.Quantity, item.Total.ToString("#,###") + ".-", item.Id); // item.LastUpdated.ToString("dd-MM-yyyy") + " " + item.LastUpdated.ToString("HH:mm" + " น.")
}
}
this.DetailTicketOrderRepeater.DataSource = dt;
this.DetailTicketOrderRepeater.DataBind();
this.Total_Label.Text = total.ToString("#,###") + ".-";
}
public void GetDataPrint()
{
DataTable dt = new DataTable();
dt.Columns.Add("Product");
//dt.Columns.Add("ProductDetail");
dt.Columns.Add("Price");
dt.Columns.Add("Checkin");
dt.Columns.Add("Checkout");
dt.Columns.Add("Quantity");
dt.Columns.Add("Total");
dt.Columns.Add("ProductOrderID");
decimal total = 0;
long ID = long.Parse(Request.QueryString["Id"]);
CommonClassLibrary.CommonDataSet.ProductOrderDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.ProductOrderTableAdapter().GetDataByTicket2(ID);
foreach (CommonClassLibrary.CommonDataSet.ProductOrderRow item in collection)
{
CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProductShowName(item.Product);
foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item2 in collection2)
{
string name = "";
CommonClassLibrary.CommonDataSet.TextContentDataTable dt1 = new CommonClassLibrary.CommonDataSetTableAdapters.TextContentTableAdapter().GetDataById(long.Parse(item2.KeyValue));
name = dt1.Rows[0]["Thai"].ToString();
total += item.Total;
dt.Rows.Add(name, item.Price.ToString("#,###") + ".-", item.CreatedDate.ToString("dd-MM-yyyy") + " " + item.CreatedDate.ToString("HH:mm" + " น."), item.LastUpdated.ToString("dd-MM-yyyy") + " " + item.LastUpdated.ToString("HH:mm" + " น."), item.Quantity, item.Total.ToString("#,###") + ".-", item.Id);
}
}
Repeater1.DataSource = dt;
Repeater1.DataBind();
Label3.Text = total.ToString("#,###") + ".-";
DateLabel.Text = DateTime.Now.ToString();
IDT.Text = ID.ToString();
}
protected void Confirmorder_Button_Click(object sender, EventArgs e)
{
long ID = long.Parse(Request.QueryString["Id"]);
DataTable dt = new DataTable();
dt.Columns.Add("Product");
//dt.Columns.Add("ProductDetail");
dt.Columns.Add("Price");
dt.Columns.Add("Quantity");
dt.Columns.Add("Total");
dt.Columns.Add("ProductOrderID");
decimal total = 0;
CommonClassLibrary.CommonDataSet.ProductOrderDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.ProductOrderTableAdapter().GetDataByTicketOrder(ID);
foreach (CommonClassLibrary.CommonDataSet.ProductOrderRow item in collection)
{
CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProductShowName(item.Product);
foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item2 in collection2)
{
total += item.Price * item.Quantity;
dt.Rows.Add(item2.KeyValue, item.Price.ToString("#,###.00"), item.Quantity.ToString("#,###.00"), (item.Price * item.Quantity).ToString("#,###") + ".-", item.Id);
}
}
//Session["aaa"] = dt;
//Session["bb"] = total.ToString("#,###") + ".-";
if (new CommonClassLibrary.CommonDataSetTableAdapters.TicketOrderTableAdapter().UpdateQuery(DateTime.Now, DateTime.Now, 3, ID) == 1)
{
if (new CommonClassLibrary.CommonDataSetTableAdapters.ProductOrderTableAdapter().UpdateQueryStatus2(ID) != 0)
{
this.SuccessPanel.Visible = true;
this.SuccessLabel.Text = "บันทึกข้อมูลสำเร็จ";
this.ErrorPanel.Visible = false;
showbutton();
//Bill();
}
else
{
this.SuccessPanel.Visible = false;
this.ErrorPanel.Visible = true;
this.ErrorLabel.Text = "บันทึกข้อมูลไม่สำเร็จ";
}
getdatarepeater1();
this.DetailTicketOrderRepeater.DataSource = dt;
this.DetailTicketOrderRepeater.DataBind();
this.Total_Label.Text = total.ToString("#,###") + ".-";
// print
Repeater1.DataSource = dt;
Repeater1.DataBind();
Label3.Text = total.ToString("#,###") + ".-";
DateLabel.Text = DateTime.Now.ToString();
IDT.Text = ID.ToString();
//ConfirmOrderPrintPanel.Visible = true;
// Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "PrintConfirmDiv()", true);
//Button1_Click(sender, e);
}
}
protected void Payment_Button_Click(object sender, EventArgs e)
{
long ID = long.Parse(Request.QueryString["Id"]);
DataTable dt = new DataTable();
dt.Columns.Add("Product");
//dt.Columns.Add("ProductDetail");
dt.Columns.Add("Price");
dt.Columns.Add("Quantity");
dt.Columns.Add("Total");
dt.Columns.Add("ProductOrderID");
decimal total = 0;
CommonClassLibrary.CommonDataSet.ProductOrderDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.ProductOrderTableAdapter().GetDataByTicketOrder(ID);
foreach (CommonClassLibrary.CommonDataSet.ProductOrderRow item in collection)
{
CommonClassLibrary.CommonDataSet.ProductDetailDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.ProductDetailTableAdapter().GetDataByProductShowName(item.Product);
foreach (CommonClassLibrary.CommonDataSet.ProductDetailRow item2 in collection2)
{
total += item.Price * item.Quantity;
dt.Rows.Add(item2.KeyValue, item.Price.ToString("#,###.00"), item.Quantity.ToString("#,###.00"), (item.Price * item.Quantity).ToString("#,###") + ".-", item.Id);
}
}
// Session["aaa"] = dt;
// Session["bb"] = total.ToString("#,###") + ".-";
HttpCookie cookie = Request.Cookies[Resources.Resource.CookieName];
if (new CommonClassLibrary.CommonDataSetTableAdapters.PaymentTableAdapter().InsertQuery(ID, "-", DateTime.Now, DateTime.Now, 0, int.Parse(cookie.Values["Id"])) == 1)
{
this.SuccessPanel.Visible = true;
this.SuccessLabel.Text = "ชำระเงินสำเร็จ";
this.ErrorPanel.Visible = false;
//ConfirmOrderPrintPanel.Visible = true;
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "PrintConfirmDiv()", true);
showbutton();
}
else
{
this.SuccessPanel.Visible = false;
this.ErrorPanel.Visible = true;
this.ErrorLabel.Text = "ชำระเงินไม่สำเร็จ";
}
}
