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(); }