protected void Button4_Click(object sender, EventArgs e)
{
System.Globalization.CultureInfo cultureinfo = new System.Globalization.CultureInfo("en-US");
decimal total = 0;
string day;
DataTable dt = new DataTable();
dt.Columns.Add("Day");
dt.Columns.Add("Code");
dt.Columns.Add("Total");
dt.Columns.Add("FirstName");
DateTime sta = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
DateTime end = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
CommonClassLibrary.CommonDataSet.PaymentProductOrderDetailUserDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.PaymentProductOrderDetailUserTableAdapter().GetDataStartDateEndDate(sta.ToString("MM-dd-yyyy"), end.ToString("MM-dd-yyyy"));
foreach (CommonClassLibrary.CommonDataSet.PaymentProductOrderDetailUserRow item in collection)
{
day = item.CreatedDate.ToString("yyyy-MM-dd HH:mm:ss");
total += item.Total;
dt.Rows.Add(day, "DGS-" + item.TicketOrder, item.Total.ToString("#,###") + ".-", item.FirstName + " " + item.LastName);
}
this.TicketOrderRepeater.DataSource = dt;
this.TicketOrderRepeater.DataBind();
}
protected void Button3_Click(object sender, EventArgs e)
{
System.Globalization.CultureInfo cultureinfo = new System.Globalization.CultureInfo("en-US");
if (Date_TextBox1.Text != "" && Date_TextBox2.Text != "")
{
decimal total = 0;
string day;
DataTable dt = new DataTable();
dt.Columns.Add("Day");
dt.Columns.Add("Code");
dt.Columns.Add("Total");
dt.Columns.Add("FirstName");
DateTime sta = DateTime.Parse((DateTime.Parse(this.Date_TextBox1.Text)).ToString("yyyy-MM-dd"));
DateTime end = DateTime.Parse((DateTime.Parse(this.Date_TextBox2.Text)).ToString("yyyy-MM-dd 23:59:59"));
//DateTime sta = Calendar1.SelectedDate;
//DateTime end = Calendar2.SelectedDate;
CommonClassLibrary.CommonDataSet.PaymentProductOrderDetailUserDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.PaymentProductOrderDetailUserTableAdapter().GetDataStartDateEndDate(sta.ToString("MM-dd-yyyy"), end.ToString("MM-dd-yyyy"));
foreach (CommonClassLibrary.CommonDataSet.PaymentProductOrderDetailUserRow item in collection)
{
day = item.CreatedDate.ToString("yyyy-MM-dd HH:mm:ss");
total += item.Total;
dt.Rows.Add(day, "DGS-" + item.TicketOrder, item.Total.ToString("#,###") + ".-", item.FirstName + " " + item.LastName);
}
this.TicketOrderRepeater.DataSource = dt;
this.TicketOrderRepeater.DataBind();
}
else
{
notification(false, "เลือกวันที่เริ่มต้นการค้นหา และวันที่สุดท้ายการค้นหาด้วยครับ");
}
}
//protected void Button1_Click(object sender, EventArgs e)
//{
// this.Calendar1.Visible = true;
//}
//protected void Calendar1_SelectionChanged(object sender, EventArgs e)
//{
// this.Calendar1.Visible = false;
// this.Button1.Text = this.Calendar1.SelectedDate.ToString("yyyy-MM-dd HH:mm:ss");
//}
//protected void Button2_Click(object sender, EventArgs e)
//{
// this.Calendar2.Visible = true;
//}
//protected void Calendar2_SelectionChanged(object sender, EventArgs e)
//{
// this.Calendar2.Visible = false;
// this.Button2.Text = this.Calendar2.SelectedDate.ToString("yyyy-MM-dd HH:mm:ss");
//}
public void getdata()
{
//string day = "";
//DataTable dt = new DataTable();
//dt.Columns.Add("Id");
//dt.Columns.Add("Code");
//dt.Columns.Add("Status");
//dt.Columns.Add("Day");
//dt.Columns.Add("Total");
////CommonClassLibrary.CommonDataSet.TicketOrderDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.TicketOrderTableAdapter().GetData();
////foreach (CommonClassLibrary.CommonDataSet.TicketOrderRow item in collection)
////{
//// if (item.Status == 2 || item.Status == 3) //confirm
//// {
//// CommonClassLibrary.CommonDataSet.OrderDetailDataTable collection2 = new CommonClassLibrary.CommonDataSetTableAdapters.OrderDetailTableAdapter().GetDataByTicketOrder(item.Id);
//// foreach (CommonClassLibrary.CommonDataSet.OrderDetailRow item2 in collection2)
//// {
//// day = item2.CheckInDate.ToString("dd-MM-yyyy");
//// time = item2.CheckInDate.ToString("HH:mm:ss");
//// dt.Rows.Add(item.Id, "DGS-" + item.Id, item.Status, day, time);
//// }
//// }
//CommonClassLibrary.CommonDataSet.TicketOrderDetailDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.TicketOrderDetailTableAdapter().GetDataByStatusBetween23();
//foreach (CommonClassLibrary.CommonDataSet.TicketOrderDetailRow item in collection)
//{
// day = item.CheckInDate.ToString("dd-MM-yyyy");
// dt.Rows.Add(item.Id, "DGS-" + item.Id, item.Status, day);
//}
//this.TicketOrderRepeater.DataSource = dt;
//this.TicketOrderRepeater.DataBind();
System.Globalization.CultureInfo cultureinfo = new System.Globalization.CultureInfo("en-US");
decimal total = 0;
string day;
DataTable dt = new DataTable();
dt.Columns.Add("Day");
dt.Columns.Add("Code");
dt.Columns.Add("Total");
dt.Columns.Add("FirstName");
DateTime sta = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
DateTime end = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
CommonClassLibrary.CommonDataSet.PaymentProductOrderDetailUserDataTable collection = new CommonClassLibrary.CommonDataSetTableAdapters.PaymentProductOrderDetailUserTableAdapter().GetDataStartDateEndDate(sta.ToString("MM-dd-yyyy"), end.ToString("MM-dd-yyyy"));
foreach (CommonClassLibrary.CommonDataSet.PaymentProductOrderDetailUserRow item in collection)
{
day = item.CreatedDate.ToString("yyyy-MM-dd HH:mm:ss");
total += item.Total;
dt.Rows.Add(day, "DGS-" + item.TicketOrder, item.Total.ToString("#,###") + ".-", item.FirstName + " " + item.LastName);
}
this.TicketOrderRepeater.DataSource = dt;
this.TicketOrderRepeater.DataBind();
}
