private void chkNoCharge_CheckedChanged(object sender, EventArgs e) { try { // if (chkNoCharge.Checked) { //----------------------------------------------------------------------- string selectedTable = cmbTableNo.SelectedValue.ToString(); List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); var data = _entities.billAndSettlements.Where(x => x.orderDecrip == "No Charge").ToList(); foreach (var item in data) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = item.kot; model.orderDecrip = item.orderDecrip; model.guestName = item.fname + " " + item.lname; model.ordDate = item.ordDate.ToString("dd-MMM-yyyy"); model.ordTime = item.ordTime; model.totalDue = item.totalDue; model.mobile = item.mobile; modelList.Add(model); } dataGridView2.DataSource = modelList; dataGridView2.ClearSelection(); } } catch (Exception x) { } }
private void btnDatSearcsh_Click(object sender, EventArgs e) { try { btnMergePayFinal.Visible = false; //----------------------------------------------------------------------- string selectedTable = cmbTableNo.SelectedValue.ToString(); List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); var data = _entities.billAndSettlements.Where(x => x.ordDate == dateTimePicker1.Value.Date).ToList(); foreach (var item in data) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = item.kot; model.orderDecrip = item.orderDecrip; model.guestName = item.fname + " " + item.lname; model.ordDate = item.ordDate.ToString("dd-MMM-yyyy"); model.ordTime = item.ordTime; model.totalDue = item.totalDue; model.mobile = item.mobile; modelList.Add(model); } dataGridView2.DataSource = modelList; dataGridView2.ClearSelection(); } catch (Exception x) { } }
void dataGridBind() { try { _entities = new KBBQEntities(); var data = _entities.billAndSettlements.Where(x => x.mode == "PAID").ToList(); List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); int row = 1; foreach (var item in data) { billAndSettlementVM model = new billAndSettlementVM(); model.rowNo = row; model.kot = _entities.detailsSettlements.Where(x => x.KOT == item.kot).FirstOrDefault().receiptno; model.orderDecrip = item.orderDecrip; model.ordDate = item.ordDate.ToString("dd-MMM-yyyy"); model.tax1_Amt = item.tax1_Amt; model.tax2_Amt = item.tax2_Amt; row++; modelList.Add(model); } dataGridView2.DataSource = modelList; } catch (Exception x) { } }
private void btnSearch_Click(object sender, EventArgs e) { try { btnMergePayFinal.Visible = false; //------------------------------------------------------------------------------------- string selectedTable = cmbTableNo.SelectedValue.ToString(); List <billAndSettlement> data = new List <billAndSettlement>(); List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); if (cboSearcshMode.SelectedIndex.Equals(0)) //Fname { data = _entities.billAndSettlements.Where(x => x.fname.Contains(txtSearcsh.Text)).ToList(); } else if (cboSearcshMode.SelectedIndex.Equals(1)) //Lname { data = _entities.billAndSettlements.Where(x => x.lname.Contains(txtSearcsh.Text)).ToList(); } else if (cboSearcshMode.SelectedIndex.Equals(3)) //Receipt { if (txtSearcsh.Text != string.Empty) { data = _entities.billAndSettlements.Where(x => x.kot == (txtSearcsh.Text)).ToList(); } } else if (cboSearcshMode.SelectedIndex.Equals(2)) //mobile { if (txtSearcsh.Text != string.Empty) { data = _entities.billAndSettlements.Where(x => x.mobile.Contains(txtSearcsh.Text)).ToList(); } } foreach (var item in data) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = item.kot; model.orderDecrip = item.orderDecrip; model.guestName = item.fname + " " + item.lname; model.ordDate = item.ordDate.ToString("dd-MMM-yyyy"); model.ordTime = item.ordTime; model.totalDue = item.totalDue; model.mobile = item.mobile; modelList.Add(model); } dataGridView2.DataSource = modelList; dataGridView2.ClearSelection(); } catch (Exception x) { } }
private void cmbTableNo_SelectedIndexChanged(object sender, EventArgs e) { try { btnMergePay.Visible = true; _entities = new KBBQEntities(); //var data = _entities.tblOrderInfoes.Where(x => x.tableNo == cmbTableNo.SelectedText.ToString()).ToList(); //foreach (var item in data) //{ // selectClass.selectBillAndSettlementTableNo(dataGridView1, cmbTableNo.SelectedValue.ToString()); //} dataGridView2.Refresh(); recNoToPass = new List <billAndSettlementVM>(); string tablCMBSelected = cmbTableNo.Text.ToString(); List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); var data = _entities.tblOrderInfoes.Where(x => x.tableNo == tablCMBSelected).ToList(); foreach (var item in data) { var dataSettlement = _entities.billAndSettlements.Where(x => x.kot == item.KOT && x.mode == "UNPAID").FirstOrDefault(); if (dataSettlement != null) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = dataSettlement.kot; model.orderDecrip = dataSettlement.orderDecrip; model.guestName = dataSettlement.fname + " " + dataSettlement.lname; model.ordDate = Convert.ToDateTime(item.ordDate).ToString("dd-MMM-yyyy"); model.ordTime = dataSettlement.ordTime; model.totalDue = dataSettlement.totalDue; model.mobile = dataSettlement.mobile; modelList.Add(model); recNoToPass.Add(model); } } dataGridView2.DataSource = modelList; dataGridView2.ClearSelection(); } catch (Exception x) { } }
private void bindGridViewForPageLoad() { try { getTableNo(); // dataGridView2.Rows.Clear(); dataGridView2.Refresh(); List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); List <billAndSettlement> data = new List <billAndSettlement>(); data = _entities.billAndSettlements.Where(x => x.mode == "UNPAID").ToList(); foreach (var item in data) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = item.kot; model.orderDecrip = item.orderDecrip; model.guestName = item.fname + " " + item.lname; model.ordDate = item.ordDate.ToString("dd-MMM-yyyy"); model.ordTime = item.ordTime; model.totalDue = item.totalDue; model.mobile = item.mobile; modelList.Add(model); } dataGridView2.DataSource = modelList; dataGridView2.ClearSelection(); } catch (Exception x) { } }
private void btnView_Click(object sender, EventArgs e) { _entities = new KBBQEntities(); if (recNoList == null) { //viewClass.viewBillTransaction(dataGridView1, txtReceiptNum.Text.Trim()); List <billAndSettlementVM> modellist = new List <billAndSettlementVM>(); billAndSettlementVM model = new billAndSettlementVM(); var data = _entities.billAndSettlements.Where(x => x.kot == txtReceiptNo.Text.Trim()).FirstOrDefault(); model.kot = data.kot; model.ordDate = data.ordDate.ToString("dd-MMM-yyyy"); model.ordTime = data.ordTime; model.totalDue = data.totalDue; modellist.Add(model); dataGridView1.DataSource = modellist; } else { List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); foreach (var item in recNoList) { billAndSettlementVM model = new billAndSettlementVM(); var data = _entities.billAndSettlements.Where(x => x.kot == item.kot).FirstOrDefault(); model.kot = data.kot; model.ordDate = Convert.ToDateTime(item.ordDate).ToString("dd-MMM-yyyy"); model.ordTime = data.ordTime; model.totalDue = data.totalDue; modelList.Add(model); } dataGridView1.DataSource = modelList; } }
private void frmRecall_Load(object sender, EventArgs e) { try { errorProvider1.SetError(cmbTableNo, "Select Table No"); _entities = new KBBQEntities(); dataGridView2.AutoGenerateColumns = false; getTableNo(); if (cmbTableNo.Items.Count > 0) { cmbTableNo.SelectedIndex = 0; btnMergePayFinal.Visible = true; } else { btnMergePayFinal.Visible = false; } dataGridView2.RowTemplate.Height = 35; cboSearcshMode.SelectedIndex = 0; //--------------------------------------------- List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); List <billAndSettlement> data = new List <billAndSettlement>(); if (cmbTableNo.Items.Count == 0) { data = _entities.billAndSettlements.Where(x => x.mode == "UNPAID").ToList(); foreach (var item in data) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = item.kot; model.orderDecrip = item.orderDecrip; model.guestName = item.fname + " " + item.lname; model.mobile = item.mobile; model.ordDate = item.ordDate.ToString("dd-MMM-yyyy"); model.ordTime = item.ordTime; model.totalDue = item.totalDue; modelList.Add(model); } } else { string selectedTable = cmbTableNo.Text.ToString(); var datas = _entities.tblOrderInfoes.Where(x => x.tableNo == selectedTable).ToList(); //data = _entities.billAndSettlements.Where(x => x. == selectedTable).ToList(); foreach (var item in datas) { var datss = _entities.billAndSettlements.Where(x => x.kot == item.KOT && x.mode == "UNPAID").FirstOrDefault(); if (datss != null) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = datss.kot; model.orderDecrip = datss.orderDecrip; model.guestName = datss.fname + " " + datss.lname; model.ordDate = Convert.ToDateTime(item.ordDate).ToString("dd-MMM-yyyy"); model.ordTime = datss.ordTime; model.totalDue = datss.totalDue; model.mobile = item.mobile; modelList.Add(model); } } } dataGridView2.DataSource = modelList; dataGridView2.ClearSelection(); } catch (Exception x) { } }
private void btnMyOrder_Click(object sender, EventArgs e) { try { _entities = new KBBQEntities(); DateTimePicker dates = new DateTimePicker(); if (btnMyOrder.Text.Equals("My Order")) { btnMyOrder.Text = "All Orders"; btnMergePayFinal.Visible = false; //----------------------------------------------------------------------- //string selectedTable = cmbTableNo.SelectedValue.ToString(); List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); //string dts = Convert.ToDateTime(dateTimePicker1.Text).ToString("yyyy-MM-dd"); //DateTime dt=Convert.ToDateTime(dts); var data = _entities.billAndSettlements.ToList(); foreach (var item in data) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = item.kot; model.orderDecrip = item.orderDecrip; model.guestName = item.fname + " " + item.lname; model.ordDate = item.ordDate.ToString("dd-MMM-yyyy"); model.ordTime = item.ordTime; model.totalDue = item.totalDue; model.mobile = item.mobile; modelList.Add(model); } dataGridView2.DataSource = modelList; dataGridView2.ClearSelection(); } else if (btnMyOrder.Text.Equals("All Orders")) { btnMergePayFinal.Visible = true; btnMyOrder.Text = "My Order"; // btnMyOrder.Image = Properties.Resources.Office_Customer_Male_Light_icon; //----------------------------------------------------------------------- string selectedTable = cmbTableNo.SelectedValue.ToString(); List <billAndSettlementVM> modelList = new List <billAndSettlementVM>(); var data = _entities.billAndSettlements.Where(x => x.ordDate == dateTimePicker1.Value.Date).ToList(); foreach (var item in data) { billAndSettlementVM model = new billAndSettlementVM(); model.kot = item.kot; model.orderDecrip = item.orderDecrip; model.guestName = item.fname + " " + item.lname; model.ordDate = item.ordDate.ToString("dd-MMM-yyyy"); model.ordTime = item.ordTime; model.totalDue = item.totalDue; model.mobile = item.mobile; modelList.Add(model); } dataGridView2.DataSource = modelList; dataGridView2.ClearSelection(); } } catch (Exception x) { } }