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