private void dataGridView2_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView2.Columns[e.ColumnIndex].Name == "Delete")
{
DialogResult myResult;
myResult = MessageBox.Show("Are you really delete the item?", "Delete Confirmation", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (myResult == DialogResult.OK)
{
_entities = new KBBQEntities();
var cellId = Convert.ToInt32(dataGridView2.CurrentRow.Cells[0].Value);
updateClass = new clsUpdate();
updateClass.updateBillAndSettlement(cellId.ToString(), "CANCELLED", "", 0);
_entities = new KBBQEntities();
var data = _entities.DailySales.Where(x => x.KOT == cellId.ToString()).ToList();
foreach (var item in data)
{
_entities.DailySales.Remove(item);
_entities.SaveChanges();
}
bindGridViewForPageLoad();
}
}
}
private void btnCashout_Click(object sender, EventArgs e)
{
_entities = new KBBQEntities();
if (recNoList == null || recNoList.Count == 0)
{
updateClass = new clsUpdate();
insertClass = new clsInsert();
frmPopupChange popChange = new frmPopupChange();
popChange.label3.Text = string.Format("{0:n2}", double.Parse(ComputePayment().ToString()));
popChange.ShowDialog();
string cashier = selectClass.getWaiterByID(getCashierName);
insertClass.insertTodetailsSettlement(txtReceiptNum.Text, dateTimePicker1, dateTimePicker1, "Inr", double.Parse(txtCustOwes.Text), "Inr", double.Parse(txtRateTimesAmtPaid.Text), changeDue, "Cash", "-", "-", "-", cashier, txtReceiptNo.Text.Trim());
if (txtDisc.Text == string.Empty)
{
txtDisc.Text = "0";
}
updateClass.updateBillAndSettlement(this.txtReceiptNum.Text, "PAID", txtCode.Text, Convert.ToDecimal(txtDisc.Text));
}
else
{
updateClass = new clsUpdate();
insertClass = new clsInsert();
frmPopupChange popChange = new frmPopupChange();
popChange.label3.Text = string.Format("{0:n2}", double.Parse(ComputePayment().ToString()));
popChange.ShowDialog();
string cashier = selectClass.getWaiterByID(getCashierName);
if (txtDisc.Text == string.Empty)
{
txtDisc.Text = "0";
}
decimal amtTemp = 0, lastPaid = 0;
string lastKot = "";
foreach (var item in recNoList)
{
decimal amtFromKOT = _entities.billAndSettlements.Where(x => x.kot == item.kot).FirstOrDefault().totalDue;
amtTemp += amtFromKOT;
insertClass.insertTodetailsSettlement(item.kot, dateTimePicker1, dateTimePicker1, "Inr", double.Parse(amtFromKOT.ToString()), "Inr", double.Parse(amtFromKOT.ToString()), 0, "Cash", "-", "-", "-", cashier, txtReceiptNo.Text.Trim());
updateClass.updateBillAndSettlement(item.kot, "PAID", txtCode.Text, Convert.ToDecimal(txtDisc.Text));
lastKot = item.kot;
lastPaid = amtFromKOT;
}
if (Convert.ToDecimal(txtRateTimesAmtPaid.Text) > amtTemp)
{
amtTemp = Convert.ToDecimal(txtRateTimesAmtPaid.Text) - amtTemp;
lastPaid = lastPaid + amtTemp;
updateClass.updateDetailsBillAndSettlement(lastKot, double.Parse(lastPaid.ToString()), changeDue);
}
if (Convert.ToDecimal(txtRateTimesAmtPaid.Text) < amtTemp)
{
amtTemp = amtTemp - Convert.ToDecimal(txtRateTimesAmtPaid.Text);
lastPaid = lastPaid - amtTemp;
amtTemp = Convert.ToDecimal(txtRateTimesAmtPaid.Text) - amtTemp;
updateClass.updateDetailsBillAndSettlement(lastKot, double.Parse(lastPaid.ToString()), changeDue);
}
}
MessageBox.Show("Payment successfully taken", "SAVED - King Bar Beque Restaurant", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
