private void btnSave_Click(object sender, EventArgs e)
{
////SQLConfig config = new SQLConfig();
config.sqlselect = "SELECT * FROM tblcategory WHERE CategoryId=" + lblCategoryId.Text;
config.sqladd = "INSERT INTO tblcategory (CategoryId,Category,CategoryType,Unit) VALUES ('" + lblCategoryId.Text + "','" + txtcategory.Text + "','" + txtType.Text + "','" + txtUnit.Text + "')";
config.sqledit = "UPDATE tblcategory SET Category='" + txtcategory.Text + "',CategoryType='" + txtType.Text + "',Unit='" + txtUnit.Text + "' WHERE CategoryId=" + lblCategoryId.Text;
config.msgadd = "New Category has been saved in the database.";
config.msgedit = "Category has been updated in the database.";
config.SaveUpdate(config.sqlselect, config.sqladd, config.msgadd, config.sqledit, config.msgedit);
string autoStart = txtcategory.Text.Substring(0, 3) + "-" + txtType.Text.Substring(0, 3) + "-";
if (categoryid == 0)
{
config.sqladd = "INSERT INTO tblautonumber (AutoStart,AutoEnd,AutoIncrement,CategoryId) VALUES ('" + autoStart + "',1,1," + lblCategoryId.Text + ")";
config.SaveData(config.sqladd);
}
else
{
config.sqledit = "UPDATE tblautonumber SET AutoStart ='" + autoStart + "' WHERE CategoryId=" + lblCategoryId.Text;
config.SaveData(config.sqledit);
}
frmCategory_Load(sender, e);
//MessageBox.Show(txtcategory.Text.Substring(0, 3));
//MessageBox.Show(txtType.Text.Substring(0, 3));
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
//double total;
DateTime today = DateTime.Now;
if (txtBarcode.Text == "" || dtgOrderlist.Rows.Count <= 0)
{
MessageBox.Show("Fields are required.", "Filled up", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
//total = double.Parse(txtPrice.Text) * Int32.Parse(txtQty.Text);
//pro.sqledit = "UPDATE tblproduct Set ProductQty = ProductQty + " + txtQty.Text + " WHERE Barcode = '" + txtBarcode.Text + "'";
//pro.SaveData(pro.sqledit);
foreach (DataGridViewRow r in dtgOrderlist.Rows)
{
pro.sqledit = "UPDATE tblproduct Set ProductQty = ProductQty + " + r.Cells[8].Value + " WHERE Barcode = '" + txtBarcode.Text + "'";
pro.SaveData(pro.sqledit);
pro.sqledit = "UPDATE tblorder Set Rem = 'Settled' WHERE OrderId = " + r.Cells[0].Value;
pro.SaveData(pro.sqledit);
pro.sqladd = "INSERT INTO tblstockin (Barcode,DateReceived,Price,ReceivedQty,SubTotal,UserId,OrderId) " +
" Values('" + txtBarcode.Text + "','" + today + "','" + txtPrice.Text +
"'," + r.Cells[8].Value + ",'" + r.Cells[10].Value +
"',1," + r.Cells[0].Value + ")";
pro.SaveData(pro.sqladd);
}
MessageBox.Show("Product has been added to the inventory.");
frmTransaction_Load(sender, e);
clearStockin();
txtBarcode.Clear();
txtBarcode.Focus();
//pro.sqledit = "UPDATE tblorder Set Rem = 'Settled' WHERE OrderId = " + dtgOrderlist.CurrentRow.Cells[0].Value;
//pro.SaveData(pro.sqledit);
////pro.sqladd = "INSERT INTO tblstockin (Barcode,DateReceived,Price,ReceivedQty,SubTotal,UserId) " +
//// " Values('" + txtBarcode.Text + "','" + today + "','" + txtPrice.Text + "'," + txtQty.Text + ",'" + total + "',1)";
//pro.sqladd = "INSERT INTO tblstockin (Barcode,DateReceived,Price,ReceivedQty,SubTotal,UserId,OrderId) " +
// " Values('" + txtBarcode.Text + "','" + today + "','" + txtPrice.Text +
// "'," + dtgOrderlist.CurrentRow.Cells[8].Value + ",'" + dtgOrderlist.CurrentRow.Cells[10].Value +
// "',1," + dtgOrderlist.CurrentRow.Cells[0].Value + ")";
//pro.SaveDataMsg(pro.sqladd, "Product has been added to the inventory.");
//frmTransaction_Load(sender, e);
//clearStockin();
//txtBarcode.Clear();
//txtBarcode.Focus();
//pro.sqlselect = "SELECT OrderId,Supplier,OrderDate,p.Barcode,ProductName,Description,Category,p.OriginalPrice,OrderQty,Unit,OrderTotal " +
// " FROM tblcategory c, tblproduct p,tblorder o , tblsupplier s " +
// " WHERE p.CategoryId=c.CategoryId AND p.Barcode=o.Barcode AND o.SupplierId=s.SupplierId AND Rem='Ordered' And p.Barcode = '" + txtBarcode.Text + "'";
//pro.LoadData(pro.sqlselect, dtgOrderlist);
//dtgOrderlist.Columns[0].Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void txtTenderAmount_KeyUp(object sender, KeyEventArgs e)
{
try
{
double subtot = double.Parse(txtTotalAmount.Text);
double tender = double.Parse(txtTenderAmount.Text);
DateTime today = DateTime.Now;
int totqty = 0;
if (e.KeyCode == Keys.Enter)
{
//MessageBox.Show(subtot.ToString());
//MessageBox.Show(tender.ToString());
if (tender >= subtot)
{
pnltenderAmount.Visible = false;
txtTotalAmount.Size = new Size(150, 35);
txtChange.Visible = true;
txtAmountTender.Visible = true;
lblamountTender.Visible = true;
lblchange.Visible = true;
foreach (DataGridViewRow row in dtgList.Rows)
{
pro.sqladd = "INSERT INTO tbltransaction (InvoiceNo,Barcode,TransactionDate,Price,TransVat,TransDiscount,TransactionQty,SubTotal,UserId) " +
"Values (" + lblTransactionId.Text + ",'" + row.Cells[0].Value +
"','" + today + "','" + row.Cells[3].Value + "','12','" + txtDiscount.Text +
"','" + row.Cells[4].Value + "','" + row.Cells[5].Value + "','" + UserIdStatusStrip.Text + "')";
//pro.SaveDataMsg(pro.sqladd, "Transaction has been saved!");
pro.SaveData(pro.sqladd);
pro.sqledit = "UPDATE tblproduct Set ProductQty=ProductQty-" + row.Cells[4].Value + " WHERE Barcode='" + row.Cells[0].Value + "'";
pro.SaveData(pro.sqledit);
totqty += int.Parse(row.Cells[4].Value.ToString());
}
pro.sqladd = "INSERT INTO tblsummary (InvoiceNo,TransactionDate,TotalQty,TransDiscount,TotalAmount,AmountTendered,Change) " +
" VALUES (" + lblTransactionId.Text + ",'" + today + "','" + totqty + "','" + txtDiscount.Text + "','" + txtTotalAmount.Text +
"','" + txtAmountTender.Text + "','" + txtChange.Text + "')";
pro.SaveData(pro.sqladd);
pro.UpdateAutonumber(11);
dtgList.Enabled = false;
txtBarcode.Enabled = false;
checkBox1.Enabled = false;
btnVoid.Enabled = false;
btnTender.Enabled = false;
totqty = 0;
frmInvoice frm = new frmInvoice(lblTransactionId.Text);
frm.ShowDialog();
}
else
{
MessageBox.Show("The amount you tendered is not valid.", "Not Valid", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
catch (Exception ex)
{
// MessageBox.Show(ex.Message);
//MessageBox.Show("The amount you tendered is not valid." + ex.Message);
}
}