private void dgv_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0 | e.ColumnIndex == 1) { transactionEL.Transactionid = Convert.ToInt32(dgv.SelectedRows[0].Cells["TRANSACTION ID"].Value); transactionEL = transactionBL.Select(transactionEL); } if (e.ColumnIndex == 0) { customerEL.Customerid = transactionEL.Customerid; customerBL.Select(customerEL); lblCustomerNameAndContactNumber.Text = customerEL.Fullname + "\n" + customerEL.Contactnumber; lblTransactionDate.Text = transactionEL.Transactiondatetime.ToString(); lblTotalAmount.Text = methods.ConvertToMoneyFormat(transactionEL.Totalamount); lblAmountTendered.Text = methods.ConvertToMoneyFormat(transactionEL.Amounttendered); lblChangeAmount.Text = methods.ConvertToMoneyFormat(transactionEL.ChangeAmount); if (transactionEL.Isvoid == 0) { pnlVoid.Visible = false; } else { pnlVoid.Visible = true; } PopulateDGVCartDetails(transactionEL.Transactionid.ToString()); lblTitle.Text = "VIEW TRANSACTION DETAILS OF TRANSACTION ID " + transactionEL.Transactionid; ShowView(true); } if (e.ColumnIndex == 1) { if (transactionEL.Isvoid == 0) { DialogResult dialogResult = MessageBox.Show("ARE YOU SURE TO VOID THIS SELECTED TRANSACTION?", "VOIDING", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { transactionEL.Isvoid = 1; ShowResult(transactionBL.Update(transactionEL)); } } else { MessageBox.Show("THIS TRANSACTION IS ALREADY VOIDED"); } } }
private void ResetForm() { lblTotalItems.ResetText(); lblTotalAmount.ResetText(); dgvCart.Rows.Clear(); lblNameAndNumber.ResetText(); CalculateCart(); txtSearchCustomers.ResetText(); txtSearchProducts.ResetText(); PopulateDGVCustomers(); PopulateDGVProducts(); customerEL = new EL.Registrations.customers(); productEL = new EL.Registrations.products(); transactionEL = new EL.Transactions.transactions(); productsintransactionEL = new EL.Transactions.productsintransactions(); }
public EL.Transactions.transactions Select(EL.Transactions.transactions transactionEL) { var dt = Helper.executeQuery("select * from transactions where transactionid = '" + transactionEL.Transactionid + "'"); if (dt.Rows.Count > 0) { transactionEL.Transactionid = Convert.ToInt32(dt.Rows[0]["transactionid"].ToString()); transactionEL.Customerid = Convert.ToInt32(dt.Rows[0]["customerid"].ToString()); transactionEL.Transactiondatetime = dt.Rows[0]["transactiondatetime"].ToString(); transactionEL.Totalamount = Convert.ToSingle(dt.Rows[0]["totalamount"].ToString()); transactionEL.Amounttendered = Convert.ToSingle(dt.Rows[0]["amounttendered"].ToString()); transactionEL.ChangeAmount = Convert.ToSingle(dt.Rows[0]["changeamount"].ToString()); transactionEL.Isvoid = Convert.ToInt32(dt.Rows[0]["isvoid"]); return(transactionEL); } else { return(null); } }
public bool Delete(EL.Transactions.transactions transactionEL) { return(Helper.executeNonQueryBool("delete from transactions where transactionid = '" + transactionEL.Transactionid + "'")); }
public bool Update(EL.Transactions.transactions transactionEL) { return(Helper.executeNonQueryBool("update transactions set customerid = '" + transactionEL.Customerid + "', transactiondatetime = '" + transactionEL.Transactiondatetime + "', totalamount = '" + transactionEL.Totalamount + "', amounttendered = '" + transactionEL.Amounttendered + "', changeamount = '" + transactionEL.ChangeAmount + "', isvoid = '" + transactionEL.Isvoid + "' where transactionid = '" + transactionEL.Transactionid + "'")); }
public long Insert(EL.Transactions.transactions transactionEL) { return(Helper.executeNonQueryLong("insert into transactions (customerid, transactiondatetime, totalamount, amounttendered, changeamount, isvoid) values ('" + transactionEL.Customerid + "', '" + transactionEL.Transactiondatetime + "', '" + transactionEL.Totalamount + "', '" + transactionEL.Amounttendered + "', '" + transactionEL.ChangeAmount + "', '" + transactionEL.Isvoid + "')")); }
public bool Delete(EL.Transactions.transactions transactionEL) { return(transactionDL.Delete(transactionEL)); }
public bool Update(EL.Transactions.transactions transactionEL) { return(transactionDL.Update(transactionEL)); }
public long Insert(EL.Transactions.transactions transactionEL) { return(transactionDL.Insert(transactionEL)); }
public EL.Transactions.transactions Select(EL.Transactions.transactions transactionEL) { return(transactionDL.Select(transactionEL)); }