private void btnSubmitLogin_Click(object sender, EventArgs e)
{
using (OrderEntities db = new OrderEntities())
{
string passwd = txtPassword.Text != "" ? HelperCS.Encrypt(txtPassword.Text) : "";
string usr = txtUserName.Text != "" ? txtUserName.Text.ToUpper() : "";
rownum = db.Login.Where(a => a.UserName == usr && a.Password == passwd).Count();
if (rownum > 0)
{
//DataInfo.UserLoginName = txtUserName.Text;
HelperCS.UserName = usr;
Form1 frm = this.FindForm() as Form1;
//frm.CheckUserLogin(txtUserName.Text);
//frm.pa
frm.CheckUserLogin();
//password anan168,ac2018
}
else
{
lblLoginValidate.Text = "";
lblLoginValidate.Text = "** InValid Username or Password ";
lblLoginValidate.Visible = true;
}
}
}
private void ProductManageUC_Load(object sender, EventArgs e)
{
HelperCS.AutoCompleteLoadValues(comboProductGroup, "Config-ProductCategory");
HelperCS.AutoCompleteLoadValues(comboProductCarry, "Config-ProductCarry");
HelperCS.AutoCompleteLoadValues(comboProductUnit, "Config-ProductUnit");
if (productid > 0)
{
btnProductDelete.Visible = true;
BindProductData();
}
else
{
txtbProductName.Text = "";
txtbProductAbbr.Text = "";
comboProductGroup.SelectedIndex = 0;
txtbProductPrice.Text = "";
//txtbProductUnit.Text = "";
comboProductCarry.SelectedIndex = 0;
comboProductUnit.SelectedIndex = 0;
txtbProductAmount.Text = "";
txtbProductDescription.Text = "";
btnProductDelete.Visible = false;
}
}
private void GetInvoiceReportData(DateTime date, int customer)
{
string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value;
using (var dailydb = new OrderEntities())
{
var ds1 = (from x in dailydb.vwCustomerDetail
where x.CustomerID == customer
select x).ToList();
var ds2 = dailydb.GetOrderbyDay(date, customer).ToList();
if (ds1.Count() > 0 && ds2.Count() > 0)
{
ReportParameter p1 = new ReportParameter("ReportType", ReportName);
ReportParameter p2 = new ReportParameter("Date", RptDatePicker.Value.ToLongDateString());
ReportParameter p3 = new ReportParameter("DocumentNo", "INV");
ReportParameter p4 = new ReportParameter("BahtText", BahtToText(ds2));
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 });
CustomerBindingSource.DataSource = HelperCS.ToDataTable(ds1);
OrderBindingSource.DataSource = HelperCS.ToDataTable(ds2);
ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", CustomerBindingSource);
ReportDataSource rtpsource2 = new ReportDataSource("DataSet2", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource1);
reportViewer1.LocalReport.DataSources.Add(rtpsource2);
}
else
{
OrderBindingSource.DataSource = null;
}
}
}
private void btnEditPrice_Click(object sender, EventArgs e)
{
DialogResult res = InputBox.ShowDialog("กรุณาใส่รหัสเพื่อแก้ไขราคาสินค้า:",
"Authentication", //Text message (mandatory), Title (optional)
InputBox.Icon.Exclamation, //Set icon type (default info)
InputBox.Buttons.OkCancel, //Set buttons (default ok)
InputBox.Type.TextBoxPassword, //Set type (default nothing)
new string[] { "Item1", "Item2", "Item3" }, //String field as ComboBox items (default null)
true, //Set visible in taskbar (default false)
new System.Drawing.Font("Calibri", 10F, System.Drawing.FontStyle.Bold)); //Set font (default by system)
if (res == System.Windows.Forms.DialogResult.OK || res == System.Windows.Forms.DialogResult.Yes)
{
using (OrderEntities db = new OrderEntities())
{
string passwd = InputBox.ResultValue != "" ? HelperCS.Encrypt(InputBox.ResultValue) : ""; //InputBox.ResultValue = textbox form dialogresult
int rownum = db.Login.Where(a => a.UserName == "PRICE" && a.Password == passwd).Count();
if (rownum > 0)
{
log.Info("OrderUC:Edit Price user:"******" customerid:" + ComboOrderCustomer.SelectedItem.ToString() + " day:" + HelperCS.daycheckbox.ToString());
HelperCS.editprice = true;
CheckTabActive();
}
else
{
log.Error("OrderUC:Edit Price Error user:"******" customerid:" + ComboOrderCustomer.SelectedItem.ToString() + " day:" + HelperCS.daycheckbox.ToString());
Form frm = btnEditPrice.FindForm();
MessageBox.Show(frm, "คุณไม่มีสิทธิ์แก้ไขข้อมูล ", "Authorization Problem", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
//private DateTime sundate, mondate, tuedate, weddate, thudate, fridate, satdate;
public OrderUC()
{
InitializeComponent();
HelperCS.AutoCompleteLoadValues(ComboOrderCustomer, "Customer");
CheckDate();
lblEditmode.Text = "";
}
public ReportTable()
{
InitializeComponent();
HelperCS.AutoCompleteLoadValues(ddlCustomer, "Customer");
HelperCS.AutoCompleteLoadValues(ddlCustomerZone, "Config-Zone");
BindPageSize();
}
private void GetProductTransportReportData(DateTime date, int customerzone)
{
string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value;
string driver = ((KeyValuePair <string, string>)ddlCustomer.SelectedItem).Value;
using (var dailydb = new OrderEntities())
{
var ds = dailydb.GetProductTransport(date, customerzone).ToList();
if (ds.Count() > 0)
{
string datestring = HelperCS.DateTextThai(date, "TH", "dd MMM yyyy");
string day = HelperCS.daythai[(int)date.DayOfWeek - 1];
ReportParameter p1 = new ReportParameter("Date", datestring);
//ReportParameter p1 = new ReportParameter("Date", date.ToString("yyyy-MM-dd"));
ReportParameter p2 = new ReportParameter("Zone", driver);
ReportParameter p3 = new ReportParameter("ReportName", ReportName);
ReportParameter p4 = new ReportParameter("Day", day);
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 });
OrderBindingSource.DataSource = HelperCS.ToDataTable(ds);
ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource1);
}
else
{
OrderBindingSource.DataSource = null;
}
}
}
private void GetCustomerTransportTofuReportData(DateTime date)
{
string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value;
using (var dailydb = new OrderEntities())
{
List <GetCustomerTransportTofu_Result> ds = null;
ds = dailydb.GetCustomerTransportTofu(date).ToList();
if (ds.Count() > 0)
{
string datestring = HelperCS.DateTextThai(date, "TH", "dd MMM yyyy");
string day = HelperCS.daythai[(int)date.DayOfWeek - 1];
ReportParameter p1 = new ReportParameter("Date", datestring);
ReportParameter p2 = new ReportParameter("ReportName", ReportName);
ReportParameter p3 = new ReportParameter("Day", day);
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3 });
OrderBindingSource.DataSource = HelperCS.ToDataTable(ds);
ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource1);
}
else
{
OrderBindingSource.DataSource = null;
}
}
}
public CustomerUC()
{
InitializeComponent();
HelperCS.AutoCompleteLoadValues(ddlCustomer, "Customer");
HelperCS.AutoCompleteLoadValues(ddlCustomerZone, "Config-Zone");
BindPageSize();
fillGrid();
}
private void btnOrderSave_Click(object sender, EventArgs e)
{
MetroTile btn = (MetroTile)sender;
HelperCS.SaveAllOrder(btn);
lblEditmode.Text = "";
CheckTabActive();
}
public Form4()
{
InitializeComponent();
HelperCS.AutoCompleteLoadValues(MondayCustomerCombo, "Customer");
//BindTable();
}
private void ProductUC_Load(object sender, EventArgs e)
{
//lblValid.Text = "";
HelperCS.AutoCompleteLoadValues(ddlProduct, "Product");
HelperCS.AutoCompleteLoadValues(ddlProductCategory, "Config-ProductCategory");
//BindProductData(1);
BindPageSize();
fillGrid();
}
private void btnNewProduct_Click(object sender, EventArgs e)
{
Form1 frm = this.FindForm() as Form1;
frm.callControlPopup("ProductManageUC");
//BindProductData(1);
HelperCS.AutoCompleteLoadValues(ddlProduct, "Product");
fillGrid();
}
private DataTable DataEntity()
{
using (var dailydb = new OrderEntities())
{
// Get result from Stored Procedure
var ds = dailydb.GetDailyOrder("Monday", 1).ToList();
// if found item rows
if (ds.Count() > 0)
{
return(HelperCS.ToDataTable(ds));
}
else
{
return(new DataTable());
}
}
}
//private void LoadReport()
//{
// reportViewer1.ProcessingMode = ProcessingMode.Local;
// //string date = "16/11/2017";
// //DateTime dt = Convert.ToDateTime(date);
// //GetSalesOrderData(dt, 3);
//}
#region GET REPORT DATA
private void GetSalesOrderData(DateTime date, int customer)
{
using (var dailydb = new OrderEntities())
{
// Get result from Stored Procedure
var ds = dailydb.GetOrderbyDay(date, customer).ToList();
//OrderUC orderUC = new OrderUC();
if (ds.Count() > 0)
{
OrderBindingSource.DataSource = HelperCS.ToDataTable(ds);
ReportDataSource rtpsource = new ReportDataSource("DataSet1", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource);
}
else
{
OrderBindingSource.DataSource = null;
}
}
}
private DataTable DataEntityProduct()
{
using (var db = new OrderEntities())
{
// Get result from Stored Procedure
//db.sims.Where(x => x.has_been_modified).ToList();
var ds = (from x in db.Product
select x).ToList();
// if found item rows
if (ds.Count() > 0)
{
return(HelperCS.ToDataTable(ds));
}
else
{
return(new DataTable());
}
}
}
private void ProductGrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (dgv == null)
{
return;
}
if (dgv.CurrentRow.Selected)
{
//get value grid columnproductid
ProductManageUC.productid = Convert.ToInt32(dgv.Rows[dgv.CurrentRow.Index].Cells[0].Value);
}
Form1 frm = this.FindForm() as Form1;
frm.callControlPopup("ProductManageUC");
//BindProductData(1);
HelperCS.AutoCompleteLoadValues(ddlProduct, "Product");
fillGrid();
}
private void GetInvoiceReportData(DateTime date, int customer)
{
string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value;
using (var dailydb = new OrderEntities())
{
//var ds1 = (from x in dailydb.vwCustomerDetail
// where x.CustomerID == customer
// select x).ToList();
List <GetOrderCustomer_Result> ds1 = null;
List <GetOrderbyDay_Result> ds2 = null;
ds1 = dailydb.GetOrderCustomer(date, customer, "INV").ToList();
ds2 = dailydb.GetOrderbyDay(date, customer).ToList();
if (ds1.Count() > 0 && ds2.Count() > 0)
{
string docid = (from c in ds1 select(string) c.DocumentID).FirstOrDefault();
string datestring = HelperCS.DateTextThai(date, "TH", "dd MMM yyyy");
ReportParameter p1 = new ReportParameter("ReportType", ReportName);
//ReportParameter p2 = new ReportParameter("Date", RptDatePicker.Value.ToLongDateString());
ReportParameter p2 = new ReportParameter("Date", datestring);
ReportParameter p3 = new ReportParameter("BahtText", BahtToText(ds2.Sum(item => item.OrderTotal)));
ReportParameter p4 = new ReportParameter("DocumentID", docid);
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4 });
CustomerBindingSource.DataSource = null;
OrderBindingSource.DataSource = null;
CustomerBindingSource.DataSource = HelperCS.ToDataTable(ds1);
OrderBindingSource.DataSource = HelperCS.ToDataTable(ds2);
ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", CustomerBindingSource);
ReportDataSource rtpsource2 = new ReportDataSource("DataSet2", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource1);
reportViewer1.LocalReport.DataSources.Add(rtpsource2);
}
else
{
CustomerBindingSource.DataSource = null;
OrderBindingSource.DataSource = null;
}
}
}
private void CustomerManageUC_Load(object sender, EventArgs e)
{
HelperCS.AutoCompleteLoadValues(comboCustomerZone, "Config-Zone");
if (customerid > 0)
{
btnCustomerDelete.Visible = true;
BindCustomerData();
}
else
{
txtbCustomerName.Text = "";
txtbCustomerAbbr.Text = "";
txtbCustomerAddress1.Text = "";
txtbCustomerAddress2.Text = "";
txtbCustomerCitizenID.Text = "";
txtbCustomerDescription.Text = "";
txtbCustomerPhone.Text = "";
comboCustomerZone.SelectedIndex = 0;
chkCustomerShowPrice.Checked = false;
btnCustomerDelete.Visible = false;
}
}
private void ddlReportName_SelectedIndexChanged(object sender, EventArgs e)
{
string ReportNamekey = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Key;
if (ReportNamekey != "")
{
if (ddlReportName.SelectedIndex == 1 || ddlReportName.SelectedIndex == 2)
{
lblCustomer.Visible = true;
ddlCustomer.Visible = true;
lblCustomer.Text = "รายชื่อลูกค้า";
HelperCS.AutoCompleteLoadValues(ddlCustomer, "Customer");
}
else if (ddlReportName.SelectedIndex == 3 || ddlReportName.SelectedIndex == 4)
{
lblCustomer.Visible = true;
ddlCustomer.Visible = true;
lblCustomer.Text = "พื้นที่ส่งสินค้า";
HelperCS.AutoCompleteLoadValues(ddlCustomer, "Config-Zone");
}
else if (ddlReportName.SelectedIndex == 5)
{
lblCustomer.Visible = false;
ddlCustomer.Visible = false;
lblCustomer.Text = "";
//HelperCS.AutoCompleteLoadValues(ddlCustomer, "Config-Zone");
}
else
{
lblCustomer.Visible = false;
ddlCustomer.Visible = false;
lblCustomer.Text = "";
}
}
else
{
}
}
public Form3()
{
InitializeComponent();
HelperCS.AutoCompleteLoadValues(comboBox1, "Product");
HelperCS.AutoCompleteLoadValues(comboBox2, "Customer");
}
private void BindTable(int cusid)
{
HelperCS.dt = null;
HelperCS.CreatePanelTable(SundaytbHeadPanel, SundaytbPanel, "Monday", cusid);
}
//private void BindGrid()
//{
// using(OrderEntities db = new OrderEntities())
// {
// var query = from x in db.Order
// select x;
// SetGridData(OrderTab.SelectedTab, query.ToList());
// //SundayGrid.DataSource = query.ToList();
// //SundayGrid.Font = new Font("Segoe UI", 11f, FontStyle.Regular, GraphicsUnit.Pixel);
// }
//}
/*
* private void BindGrid(DataGridView grid, string day)
* {
* try
* {
* if (comboBox1.SelectedIndex >= 0)
* {
* //int customerid = ddlCustomerOrder.SelectedIndex;
* using (var dailydb = new DailyOrderEntities())
* {
* // Get result from Stored Procedure
*
* var ds = dailydb.GetDailyOrder(day, customerid).ToList();
*
* // if found item rows
* if (ds.Count() > 0)
* {
* grid.DataSource = ds;
* CreateProductComboBox(grid);
* }
* else
* {
*
* //SetControlTemplateTable(Grid);
* }
* }
* }
*
* }
* catch (Exception ex)
* {
*
* }
* }
*
* private void CreateProductComboBox(DataGridView grid)
* {
* DataGridViewComboBoxColumn comboboxColumn = new DataGridViewComboBoxColumn();
* comboboxColumn = CreateProductComboBoxColumn();
* SetAlternateChoicesUsingDataSource(comboboxColumn);
* comboboxColumn.HeaderText = "Product Combo";
* grid.Columns.Insert(0, comboboxColumn);
* }
*
*
* enum ColumnName
* {
* OrderId,
* OrderDate,
* CustomerID,
* ProductID,
* ProductPrice,
* ProductAmount,
* Description,
* OrderStatus,
* WeekDay,
* ProductName
* };
* private void SetAlternateChoicesUsingDataSource(DataGridViewComboBoxColumn comboboxColumn)
* {
* {
* comboboxColumn.DataSource = DataEntityProduct();
* comboboxColumn.ValueMember = "Id";
* comboboxColumn.DisplayMember = "Text";
* //comboboxColumn.ValueMember = ColumnName.ProductName.ToString();
* //comboboxColumn.DisplayMember = comboboxColumn.ValueMember;
* }
* }
*
* private object DataEntityProduct()
* {
* using (var db = new OrderEntities())
* {
* var ds = db.Product.Select(x => new
* {
* Id = x.ProductID,
* Text = x.ProductName + " / " + x.ProductID
* }).ToList();
*
* // if found item rows
* if (ds.Count() > 0)
* {
* return HelperCS.ToDataTable(ds);
* }
* else
* {
* return new DataTable();
* }
* //var query = from x in db.Product select x;
* //// customerGroup is an IGrouping<string, Customer>
* //foreach (var item in query)
* //{
* // string id = item.ProductID.ToString();
* // string Name = item.ProductName.ToString();
* //}
* }
* }
*
* private DataGridViewComboBoxColumn CreateProductComboBoxColumn()
* {
* DataGridViewComboBoxColumn column =
* new DataGridViewComboBoxColumn();
* {
*
* column.DataPropertyName = ColumnName.ProductName.ToString();
* column.HeaderText = ColumnName.ProductName.ToString();
* column.DropDownWidth = 160;
* column.Width = 90;
* column.MaxDropDownItems = 3;
* column.FlatStyle = FlatStyle.Flat;
* }
* return column;
* }
*
* private void BindGrid(MetroGrid Grid,string day)
* {
*
* try {
* if (ddlCustomerOrder.SelectedIndex >= 0)
* {
* int customerid = ddlCustomerOrder.SelectedIndex;
* //using (OrderEntities db = new OrderEntities())
* //{
* // var result_id = (from d in db.vwOrder
* // where d.CustomerID == customerid
* // select d);
* // var result = from x in result_id
* // where x.OrderDay.Contains(day)
* // select x;
*
* // Grid.DataSource = result.ToList();
* // Grid.Font = new Font("Segoe UI", 14f, FontStyle.Regular, GraphicsUnit.Pixel);
* //}
* //using (DailyOrderEntities store = new DailyOrderEntities()) { }
* using (var dailydb = new DailyOrderEntities())
* {
* // Get result from Stored Procedure
*
* var ds = dailydb.GetDailyOrder(day, customerid).ToList();
*
* // if found item rows
* if (ds.Count() > 0)
* {
* Grid.DataSource = ds;
* Grid.Font = new Font("Segoe UI", 14f, FontStyle.Regular, GraphicsUnit.Pixel);
* DataGridTextBoxColumn txtPrice = new DataGridTextBoxColumn();
* }
* else
* {
*
* SetControlTemplateTable(Grid);
* }
* }
* }
* }
* catch(Exception ex)
* {
*
* }
* }
*
* private void SetControlTemplateTable(MetroGrid Grid)
* {
* DataRow dr = dt.NewRow();
* dr["#"] = "";
* dr["run"] = 1;
* dr["ProductName"] = 1;
* DataGridTextBoxColumn txtPrice = new DataGridTextBoxColumn();
* DataGridTextBoxColumn txtAmount = new DataGridTextBoxColumn();
*
* dr["ProductUnit"] = "1";
* dr["Price"] = txtPrice;
* dr["ProductAmount"] = txtAmount;
* dr["SumPrice"] = "2221";
*
* }
*
* private void CreateTemplateTable()
* {
* dt = new DataTable();
* dt.Columns.Add("#", Type.GetType("System.String"));
* dt.Columns.Add("run", Type.GetType("Int32"));
* dt.Columns.Add("ProductName", Type.GetType("System.String"));
* dt.Columns.Add("ProductUnit", Type.GetType("System.String"));
* dt.Columns.Add("Price", Type.GetType("System.Decimal"));
* dt.Columns.Add("ProductAmount", Type.GetType("Int32"));
* dt.Columns.Add("SumPrice", Type.GetType("System.Decimal"));//String.Format("0.00", dtTable.Columns["TestQuantity"]);
* dt.PrimaryKey = new DataColumn[] { dt.Columns["run"] };
* }
*
*/
#region Method
private void CheckTabActive()
{
OrderTab.AutoSize = true;
//OrderTab.MaximumSize = //new (1800, 900);
//check select customer beform bind data
if (ComboOrderCustomer.SelectedIndex > 0)
{
HelperCS.editlabel = lblEditmode;
HelperCS.editbtn = btnOrderEdit;
if (OrderTab.SelectedTab == OrderTab.TabPages["SundayTab"])
{
//if (chkbOrderSunday.Checked == true)
//{
// HelperCS.WeekOrder[0] = true;
// HelperCS.CreatePanelTable(pnlSundayHead, pnlMainSundayBody, "Sunday", customerid);
//}
//else
//{
// HelperCS.WeekOrder[0] = false;
// //ClearPanel("Sunday");
//}
chkbOrderSunday.Checked = HelperCS.editmode ? true : chkbOrderSunday.Checked;
HelperCS.WeekOrder[0] = chkbOrderSunday.Checked ? true : false;
HelperCS.daycheckbox = chkbOrderSunday;
HelperCS.CreatePanelTable(pnlSundayHead, pnlMainSundayBody, "Sunday", customerid);
}
else if (OrderTab.SelectedTab == OrderTab.TabPages["MondayTab"])
{
//if (chkbOrderMonday.Checked == true)
//{
// HelperCS.WeekOrder[1] = true;
// HelperCS.CreatePanelTable(pnlMondayHead, pnlMainMondayBody, "Monday", customerid);
//}
//else
//{
// HelperCS.WeekOrder[1] = false;
// //ClearPanel("Monday");
//}
chkbOrderMonday.Checked = HelperCS.editmode ? true : chkbOrderMonday.Checked;
HelperCS.WeekOrder[1] = chkbOrderMonday.Checked ? true : false;
HelperCS.daycheckbox = chkbOrderMonday;
HelperCS.CreatePanelTable(pnlMondayHead, pnlMainMondayBody, "Monday", customerid);
}
else if (OrderTab.SelectedTab == OrderTab.TabPages["TuesdayTab"])
{
//if (chkbOrderTuesday.Checked == true)
//{
// HelperCS.WeekOrder[2] = true;
// HelperCS.CreatePanelTable(pnlTuesdayHead, pnlMainTuesdayBody, "Tuesday", customerid);
//}
//else
//{
// HelperCS.WeekOrder[2] = false;
// //ClearPanel("Tuesday");
//}
chkbOrderTuesday.Checked = HelperCS.editmode ? true : chkbOrderTuesday.Checked;
HelperCS.WeekOrder[2] = chkbOrderTuesday.Checked ? true : false;
HelperCS.daycheckbox = chkbOrderTuesday;
HelperCS.CreatePanelTable(pnlTuesdayHead, pnlMainTuesdayBody, "Tuesday", customerid);
}
else if (OrderTab.SelectedTab == OrderTab.TabPages["WednesdayTab"])
{
//if (chkbOrderWednesday.Checked == true)
//{
// HelperCS.WeekOrder[3] = true;
// HelperCS.CreatePanelTable(pnlWednesdayHead, pnlMainWednesdayBody, "Wednesday", customerid);
//}
//else
//{
// HelperCS.WeekOrder[3] = false;
// //ClearPanel("Wednesday");
//}
chkbOrderWednesday.Checked = HelperCS.editmode ? true : chkbOrderWednesday.Checked;
HelperCS.WeekOrder[3] = chkbOrderWednesday.Checked ? true : false;
HelperCS.daycheckbox = chkbOrderWednesday;
HelperCS.CreatePanelTable(pnlWednesdayHead, pnlMainWednesdayBody, "Wednesday", customerid);
}
else if (OrderTab.SelectedTab == OrderTab.TabPages["ThursdayTab"])
{
//if (chkbOrderThursday.Checked == true)
//{
// HelperCS.WeekOrder[4] = true;
// HelperCS.CreatePanelTable(pnlThursdayHead, pnlMainThursdayBody, "Thursday", customerid);
//}
//else
//{
// HelperCS.WeekOrder[4] = false;
// //ClearPanel("Thursday");
//}
chkbOrderThursday.Checked = HelperCS.editmode ? true : chkbOrderThursday.Checked;
HelperCS.WeekOrder[4] = chkbOrderThursday.Checked ? true : false;
HelperCS.daycheckbox = chkbOrderThursday;
HelperCS.CreatePanelTable(pnlThursdayHead, pnlMainThursdayBody, "Thursday", customerid);
}
else if (OrderTab.SelectedTab == OrderTab.TabPages["FridayTab"])
{
//if (chkbOrderFriday.Checked == true)
//{
// HelperCS.WeekOrder[5] = true;
// HelperCS.CreatePanelTable(pnlFridayHead, pnlMainFridayBody, "Friday", customerid);
//}
//else
//{
// HelperCS.WeekOrder[5] = false;
// //ClearPanel("Friday");
//}
chkbOrderFriday.Checked = HelperCS.editmode ? true : chkbOrderFriday.Checked;
HelperCS.WeekOrder[5] = chkbOrderFriday.Checked ? true : false;
HelperCS.daycheckbox = chkbOrderFriday;
HelperCS.CreatePanelTable(pnlFridayHead, pnlMainFridayBody, "Friday", customerid);
}
else if (OrderTab.SelectedTab == OrderTab.TabPages["SaturdayTab"])
{
//if (chkbOrderSaturday.Checked == true)
//{
// HelperCS.WeekOrder[6] = true;
// HelperCS.CreatePanelTable(pnlSaturdayHead, pnlMainSaturdayBody, "Saturday", customerid);
//}
//else
//{
// HelperCS.WeekOrder[6] = false;
// //ClearPanel("Saturday");
//}
chkbOrderSaturday.Checked = HelperCS.editmode ? true : chkbOrderSaturday.Checked;
HelperCS.WeekOrder[6] = chkbOrderSaturday.Checked ? true : false;
HelperCS.daycheckbox = chkbOrderSaturday;
HelperCS.CreatePanelTable(pnlSaturdayHead, pnlMainSaturdayBody, "Saturday", customerid);
}
}
else
{
//MetroMessageBox.Show(this, "Please Select Customer Before");
}
}
private void BindTable(int cusid)
{
HelperCS.dt = null;
HelperCS.CreatePanelTable(pnlMondayGridHead, pnlMondayGridBody, "Monday", cusid);
}
public OrderMondayUC()
{
InitializeComponent();
HelperCS.AutoCompleteLoadValues(ComboMondayCustomer, "Customer");
}
private void GetReceiveWeeklyReportData(DateTime date, int customer, bool showprice)
{
string ReportName = ((KeyValuePair <string, string>)ddlReportName.SelectedItem).Value;
using (var dailydb = new OrderEntities())
{
List <GetOrderCustomer_Result> ds1 = null;
List <GetReceiveWeeklyPrice_Result> ds2 = null;
List <GetReceiveWeekly_Result> ds3 = null;
ds1 = dailydb.GetOrderCustomer(date, customer, "RCD").ToList();
bool rowno = false;
string bahttext = "";
DataTable dtorder;
if (showprice)
{
ds2 = dailydb.GetReceiveWeeklyPrice(date, customer).ToList();
rowno = ds2.Count() > 0 ? true : false;
bahttext = rowno ? BahtToText(ds2.Sum(item => item.total)) : "";
dtorder = HelperCS.ToDataTable(ds2);
}
else
{
ds3 = dailydb.GetReceiveWeekly(date, customer).ToList();
rowno = ds3.Count() > 0 ? true : false;
bahttext = rowno ? BahtToText(ds3.Sum(item => item.total)) : "";
dtorder = HelperCS.ToDataTable(ds3);
}
//string datestring = HelperCS.DateTextThai(RptDatePicker.Value,"TH","dd MMM yyyy");
string datestring = HelperCS.DateTextThai(DateTime.Now, "TH", "dd MMM yyyy");
if (ds1.Count() > 0 && rowno)
{
CustomerBindingSource.DataSource = HelperCS.ToDataTable(ds1);
OrderBindingSource.DataSource = dtorder;
//string sunday = dt.Rows[i].Field<int>(j);
DateTime startdate = (from c in ds1 select(DateTime) c.OrderStartDate).FirstOrDefault();
string docid = (from c in ds1 select(string) c.DocumentID).FirstOrDefault();
ReportParameter p1 = new ReportParameter("ReportType", ReportName);
ReportParameter p2 = new ReportParameter("Date", datestring);
ReportParameter p3 = new ReportParameter("BahtText", bahttext);
ReportParameter p4 = new ReportParameter("suntext", HelperCS.DateTextThai(startdate, "TH", "dd-MMM"));
ReportParameter p5 = new ReportParameter("montext", HelperCS.DateTextThai(startdate.AddDays(1), "TH", "dd-MMM"));
ReportParameter p6 = new ReportParameter("tuetext", HelperCS.DateTextThai(startdate.AddDays(2), "TH", "dd-MMM"));
ReportParameter p7 = new ReportParameter("wedtext", HelperCS.DateTextThai(startdate.AddDays(3), "TH", "dd-MMM"));
ReportParameter p8 = new ReportParameter("thrtext", HelperCS.DateTextThai(startdate.AddDays(4), "TH", "dd-MMM"));
ReportParameter p9 = new ReportParameter("fritext", HelperCS.DateTextThai(startdate.AddDays(5), "TH", "dd-MMM"));
ReportParameter p10 = new ReportParameter("sattext", HelperCS.DateTextThai(startdate.AddDays(6), "TH", "dd-MMM"));
ReportParameter p11 = new ReportParameter("DocumentID", docid);
reportViewer1.LocalReport.SetParameters(new ReportParameter[] { p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11 });
ReportDataSource rtpsource1 = new ReportDataSource("DataSet1", CustomerBindingSource);
ReportDataSource rtpsource2 = new ReportDataSource("DataSet2", OrderBindingSource);
reportViewer1.LocalReport.DataSources.Add(rtpsource1);
reportViewer1.LocalReport.DataSources.Add(rtpsource2);
}
else
{
CustomerBindingSource.DataSource = null;
OrderBindingSource.DataSource = null;
}
}
}
public ReportViewerUC()
{
InitializeComponent();
HelperCS.AutoCompleteLoadValues(ddlCustomer, "Customer");
HelperCS.AutoCompleteLoadValues(ddlReportName, "Config-ReportName");
}
