public void Delete(BillDetails obj)
{
ClearParameter();
AddParameter("@billid", obj.BillId);
AddParameter("@menuitemid", obj.MenuItemId);
FetchData("sp_Delete_TempBillDetails");
}
public void InsertOrUpdate(BillDetails obj)
{
ClearParameter();
AddParameter("@billdetailid", obj.BillDetailId);
AddParameter("@billid", obj.BillId);
AddParameter("@menuitemid", obj.MenuItemId);
AddParameter("@quantity", obj.Quantity);
AddParameter("@unitprice", obj.UnitPrice);
AddParameter("@isdiscountavailable", obj.IsDiscountAvailable);
AddParameter("@totalprice", obj.TotalPrice);
AddParameter("@receivedby", 1);
FetchData("sp_InsertUpdate_BillDetails");
}
private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
btnUpdate.Enabled = false;
cmbMenuItem.Enabled = true;
BillDetails billDetails = new BillDetails();
billDetails.BillId = _billId;
billDetails.MenuItemId = Convert.ToInt32(ListView1.FocusedItem.SubItems[1].Text);
billDetails.Quantity = Convert.ToInt32(txtSaleQty.Text);
billDetails.UnitPrice = Convert.ToDecimal(ListView1.FocusedItem.SubItems[3].Text);
billDetails.IsDiscountAvailable = false;
billDetails.TotalPrice = Convert.ToDecimal(txtTotalAmount.Text);
billDetails.ReceivedBy = BaseObject.User_ID;
billDetails.IsDeleted = false;
new BllTempBillDetails().InsertOrUpdate(billDetails);
for (int j = 0; j <= ListView1.Items.Count - 1; j++)
{
if (ListView1.Items[j].SubItems[1].Text == ListView1.FocusedItem.SubItems[1].Text)
{
ListView1.Items[j].SubItems[3].Text = txtPrice.Text;
ListView1.Items[j].SubItems[4].Text = txtSaleQty.Text;
ListView1.Items[j].SubItems[5].Text = txtTotalAmount.Text;
txtSubTotal.Text = subtot().ToString();
Calculate();
BillInfo billInfo = createBillInfoObject();
new BllBillInfo().InsertOrUpdate(billInfo);
cmbMenuItem.Text = "";
txtPrice.Text = "";
txtSaleQty.Text = "";
txtTotalAmount.Text = "";
//cmbMenuItem.Focus();
txtMenuCode.Focus();
return;
}
}
}
catch (Exception ex)
{
KryptonMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (_billId == 0)
{
KryptonMessageBox.Show("Please select Menu item", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (ListView1.Items.Count == 0)
{
KryptonMessageBox.Show("Please select Menu item", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtDiscountPer.Text == "")
{
KryptonMessageBox.Show("Please insert Discount Percent", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtDiscountPer.Focus();
return;
}
if (txtTaxPer.Text == "")
{
KryptonMessageBox.Show("Please insert Vat Percent", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTaxPer.Focus();
return;
}
if (txtServiceChargePer.Text == "")
{
KryptonMessageBox.Show("Please insert Service charge Percent", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtServiceChargePer.Focus();
return;
}
int paymenttypeid = Convert.ToInt32(cmbPaymentType.SelectedValue);
if (paymenttypeid == 4 || paymenttypeid == 5)
{
if (txtRemarks.Text.Trim() == "")
{
KryptonMessageBox.Show("Please insert Remarks for Void/Complementary payment", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtRemarks.Focus();
return;
}
}
int disPer = Convert.ToInt32(txtDiscountPer.Text);
if (disPer > 0)
{
if (txtRemarks.Text.Trim() == "")
{
KryptonMessageBox.Show("Please insert Remarks for Discount.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtRemarks.Focus();
return;
}
}
string msg = "You choose " + cmbPaymentType.Text.Trim() + " payment type.\n" + Messages.SaveConfirmation;
DialogResult dr = KryptonMessageBox.Show(msg, Text, MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (dr == DialogResult.Yes)
{
BillInfo _billInfo = createBillInfoObject();
_billInfo.BillId = _billId;
_billInfo.BillNo = "B" + _billId;
_billInfo.PaymentTypeId = paymenttypeid;
_billInfo.IsClosed = true;
for (int j = 0; j <= ListView1.Items.Count - 1; j++)
{
BillDetails billDetails = new BillDetails();
billDetails.BillId = _billId;
billDetails.MenuItemId = Convert.ToInt32(cmbMenuItem.SelectedValue.ToString());
billDetails.Quantity = Convert.ToInt32(ListView1.Items[j].SubItems[4].Text);
billDetails.UnitPrice = Convert.ToDecimal(ListView1.Items[j].SubItems[3].Text);
billDetails.IsDiscountAvailable = false;
billDetails.TotalPrice = Convert.ToDecimal(ListView1.Items[j].SubItems[5].Text);
billDetails.ReceivedBy = BaseObject.User_ID;
new BllBillDetails().InsertOrUpdate(billDetails);
}
new BllBillInfo().InsertOrUpdate(_billInfo);
btnSave.Enabled = false;
btnPrintInvoice.Enabled = true;
KryptonMessageBox.Show("Successfully completed", "Bill Payment", MessageBoxButtons.OK, MessageBoxIcon.Information);
Reset();
}
}
private void btnRemove_Click(object sender, EventArgs e)
{
try
{
if (ListView1.Items.Count == 0)
{
KryptonMessageBox.Show("No items to remove", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (ListView1.Items.Count == 1)
{
KryptonMessageBox.Show("You can not remove single item", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int itmCnt = 0;
int i = 0;
int t = 0;
BillDetails billDetails = new BillDetails();
billDetails.BillId = _billId;
billDetails.MenuItemId = Convert.ToInt32(ListView1.FocusedItem.SubItems[1].Text);
billDetails.Quantity = Convert.ToInt32(ListView1.FocusedItem.SubItems[4].Text);
billDetails.UnitPrice = Convert.ToDecimal(ListView1.FocusedItem.SubItems[3].Text);
billDetails.IsDiscountAvailable = false;
billDetails.TotalPrice = Convert.ToDecimal(ListView1.FocusedItem.SubItems[5].Text);
billDetails.ReceivedBy = BaseObject.User_ID;
billDetails.IsDeleted = false;
new BllTempBillDetails().DeleteData(billDetails);
ListView1.FocusedItem.Remove();
itmCnt = ListView1.Items.Count;
t = 1;
for (i = 1; i <= itmCnt + 1; i++)
{
//Dim lst1 As New ListViewItem(i)
//ListView1.Items(i).SubItems(0).Text = t
t = t + 1;
}
txtSubTotal.Text = subtot().ToString();
Calculate();
BillInfo billInfo = createBillInfoObject();
new BllBillInfo().InsertOrUpdate(billInfo);
}
btnRemove.Enabled = false;
if (ListView1.Items.Count == 0)
{
txtSubTotal.Text = "";
}
}
catch (Exception ex)
{
KryptonMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnAddToCart_Click(object sender, EventArgs e)
{
try
{
if (cmbTableNo.Text == "")
{
KryptonMessageBox.Show("Please select Table", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (cmbMenuItem.Text == "")
{
KryptonMessageBox.Show("Please select product name", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtSaleQty.Text == "")
{
KryptonMessageBox.Show("Please enter quantity", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtSaleQty.Focus();
return;
}
int SaleQty = Convert.ToInt32(txtSaleQty.Text);
if (SaleQty == 0)
{
KryptonMessageBox.Show("no. of quantity can not be zero", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtSaleQty.Focus();
return;
}
if (txtKotNo.Text.Trim() == "")
{
KryptonMessageBox.Show("Please enter KOT No.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtKotNo.Focus();
return;
}
int parsedValue;
if (!int.TryParse(txtPax.Text, out parsedValue))
{
KryptonMessageBox.Show("Please enter valid PAX.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPax.Focus();
return;
}
btnRemove.Enabled = false;
//cmbMenuItem.Focus();
txtMenuCode.Focus();
if (ListView1.Items.Count == 0)
{
ListViewItem lst = new ListViewItem();
lst.SubItems.Add(cmbMenuItem.SelectedValue.ToString());
lst.SubItems.Add(cmbMenuItem.Text);
lst.SubItems.Add(txtPrice.Text);
lst.SubItems.Add(txtSaleQty.Text);
lst.SubItems.Add(txtTotalAmount.Text);
ListView1.Items.Add(lst);
txtSubTotal.Text = subtot().ToString();
Calculate();
BillInfo billInfo = createBillInfoObject();
_billId = new BllBillInfo().InsertOrUpdate(billInfo);
txtBillNo.Text = "B" + _billId.ToString();
BillDetails billDetails = new BillDetails();
billDetails.BillId = _billId;
billDetails.MenuItemId = Convert.ToInt32(cmbMenuItem.SelectedValue.ToString());
billDetails.Quantity = Convert.ToInt32(txtSaleQty.Text);
billDetails.UnitPrice = Convert.ToDecimal(txtPrice.Text);
billDetails.IsDiscountAvailable = false;
billDetails.TotalPrice = Convert.ToDecimal(txtTotalAmount.Text);
billDetails.ReceivedBy = BaseObject.User_ID;
billDetails.IsDeleted = false;
new BllTempBillDetails().InsertOrUpdate(billDetails);
cmbMenuItem.Text = "";
txtPrice.Text = "";
txtSaleQty.Text = "";
txtTotalAmount.Text = "";
return;
}
for (int j = 0; j <= ListView1.Items.Count - 1; j++)
{
if (ListView1.Items[j].SubItems[1].Text == cmbMenuItem.SelectedValue.ToString())
{
ListView1.Items[j].SubItems[1].Text = cmbMenuItem.SelectedValue.ToString();
ListView1.Items[j].SubItems[2].Text = cmbMenuItem.Text;
ListView1.Items[j].SubItems[3].Text = txtPrice.Text;
ListView1.Items[j].SubItems[4].Text = (Convert.ToInt32(ListView1.Items[j].SubItems[4].Text) + Convert.ToInt32(txtSaleQty.Text)).ToString();
ListView1.Items[j].SubItems[5].Text = (Convert.ToDecimal(ListView1.Items[j].SubItems[5].Text) + Convert.ToDecimal(txtTotalAmount.Text)).ToString();
txtSubTotal.Text = subtot().ToString();
Calculate();
BillDetails billDetails = new BillDetails();
billDetails.BillId = _billId;
billDetails.MenuItemId = Convert.ToInt32(cmbMenuItem.SelectedValue.ToString());
billDetails.Quantity = Convert.ToInt32(ListView1.Items[j].SubItems[4].Text);
billDetails.UnitPrice = Convert.ToDecimal(ListView1.Items[j].SubItems[3].Text);
billDetails.IsDiscountAvailable = false;
billDetails.TotalPrice = Convert.ToDecimal(ListView1.Items[j].SubItems[5].Text);
billDetails.ReceivedBy = BaseObject.User_ID;
billDetails.IsDeleted = false;
new BllTempBillDetails().InsertOrUpdate(billDetails);
BillInfo billInfo = createBillInfoObject();
new BllBillInfo().InsertOrUpdate(billInfo);
cmbMenuItem.Text = "";
txtPrice.Text = "";
txtSaleQty.Text = "";
txtTotalAmount.Text = "";
return;
}
}
ListViewItem lst1 = new ListViewItem();
lst1.SubItems.Add(cmbMenuItem.SelectedValue.ToString());
lst1.SubItems.Add(cmbMenuItem.Text);
lst1.SubItems.Add(txtPrice.Text);
lst1.SubItems.Add(txtSaleQty.Text);
lst1.SubItems.Add(txtTotalAmount.Text);
ListView1.Items.Add(lst1);
txtSubTotal.Text = subtot().ToString();
Calculate();
BillDetails billDetails2 = new BillDetails();
billDetails2.BillId = _billId;
billDetails2.MenuItemId = Convert.ToInt32(cmbMenuItem.SelectedValue.ToString());
billDetails2.Quantity = Convert.ToInt32(txtSaleQty.Text);
billDetails2.UnitPrice = Convert.ToDecimal(txtPrice.Text);
billDetails2.IsDiscountAvailable = false;
billDetails2.TotalPrice = Convert.ToDecimal(txtTotalAmount.Text);
billDetails2.ReceivedBy = BaseObject.User_ID;
billDetails2.IsDeleted = false;
new BllTempBillDetails().InsertOrUpdate(billDetails2);
BillInfo billInfo2 = createBillInfoObject();
new BllBillInfo().InsertOrUpdate(billInfo2);
cmbMenuItem.Text = "";
txtPrice.Text = "";
txtSaleQty.Text = "";
txtTotalAmount.Text = "";
return;
}
catch (Exception ex)
{
KryptonMessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
