public FrmDiscount(FrmCreateNewInvoice count)
{
InitializeComponent();
cn = new SqlConnection(dbcon.MyConnection());
dis = count;
this.KeyPreview = true;
}
public FrmQuantity(FrmCreateNewInvoice frm)
{
InitializeComponent();
cn = new SqlConnection(dbcon.MyConnection());
F2 = frm;
this.KeyPreview = true;
}
public FrmLookUp(FrmCreateNewInvoice Fr2)
{
InitializeComponent();
cn = new SqlConnection(dbcon.MyConnection());
F2 = Fr2;
this.KeyPreview = true;
}
public void ShowInvoiceInFront()
{
//Off the visibility of the Button of see products
BtnSeeProducts.Visible = false;
BtnInvoices.Visible = false;
BtnCustomers.Visible = false;
//Pass the label name of the user logged in
//Off the visibility of the Button of User Account
BtnUserAccount.Visible = false;
Indicator8.Visible = false;
//This line of code here is the process of passing the Full name of account logged in to the system,
//so, we can record the name of the invoicer who process the order.
PasslblName = lblUsername.Text;
//Container 1
FrmCreateNewInvoice XXL = new FrmCreateNewInvoice(); //Set a variable to call the form
XXL.Size = Container1.Size;
XXL.TopLevel = false; //Make the toplevel = 0
Container1.Controls.Clear(); //Clear the Container first (Para kung may laman matatanggal muna bago mo ilagay kung anung form man ilalagay mo)
Container1.Controls.Add(XXL);
XXL.BringToFront(); //Bring the form in front of the other peripherals
XXL.LoadCustomersFromDatabaseToCustomerCombobox(); // Populate the Customer Combobox with Customer name in the database
XXL.Show(); //Show the form
//Indicators
Indicator1.Visible = true; //1
Indicator2.Visible = false; //0
Indicator3.Visible = false; //0
Indicator4.Visible = false; //0
Indicator5.Visible = false; //0
Indicator6.Visible = false; //0
Indicator7.Visible = false; //0
}
private void TxtQty_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
if (e.KeyChar == 46)
{
//accept .(for cents or decimal places)
}
else if (e.KeyChar == 8)
{
//accept backspace
}
else if ((e.KeyChar < 48) || (e.KeyChar > 57)) //ascii code 48 - 57 between 0-9
{
e.Handled = true;
}
if ((e.KeyChar == 13) && (txtQty.Text != String.Empty))
{
bool found = false;
String id = "";
int invoice_qty = 0;
cn.Open();
cm = new SqlCommand("SELECT * FROM tblInvoiceOrder WHERE invoiceno = @invoiceno and prodcode = @prodcode", cn);
cm.Parameters.AddWithValue("@invoiceno", F2.lblInvoiceNo.Text);
cm.Parameters.AddWithValue("@prodcode", prodcode);
dr = cm.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
found = true;
id = dr["id"].ToString();
invoice_qty = int.Parse(dr["qty"].ToString());
}
else
{
found = false;
}
dr.Close();
cn.Close();
if (found == true)
{
//For Stock Validation Condition
if (qty < int.Parse(txtQty.Text) + invoice_qty)
{
MessageBox.Show("Unable to Proceed, Remaining Quantity of product on hand is " + qty, "Stock Validation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
cn.Open();
cm = new SqlCommand("UPDATE tblInvoiceOrder SET qty = (qty + " + int.Parse(txtQty.Text) + ") WHERE id = '" + id + "'", cn);
cm.ExecuteNonQuery();
cn.Close();
F2.LoadInvoiceOrder();
this.Dispose();
}
else
{
//For Stock Validation Condition
if (qty < int.Parse(txtQty.Text) + invoice_qty)
{
MessageBox.Show("Unable to Proceed. The Remaining Quantity of the product on hand is " + qty, "Stock Validation", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
FrmCreateNewInvoice inv = new FrmCreateNewInvoice();
cn.Open();
cm = new SqlCommand("INSERT INTO tblInvoiceOrder (invoiceno, customer, address, prodcode, proddescrip, prodprice, qty, stockdate, name, payment, days, billaddress, duedate) VALUES (@invoiceno, @customer, @address, @code, @desc, @price, @qty, @date, @name, @payment, @days, @bill, @duedate)", cn);
cm.Parameters.AddWithValue("@invoiceno", transno);
cm.Parameters.AddWithValue("@customer", F2.txtCustomer.Text);
cm.Parameters.AddWithValue("@address", F2.txtAddress.Text);
cm.Parameters.AddWithValue("@code", prodcode);
cm.Parameters.AddWithValue("@desc", proddescrip);
cm.Parameters.AddWithValue("@price", prodprice);
cm.Parameters.AddWithValue("@qty", int.Parse(txtQty.Text));
cm.Parameters.AddWithValue("@name", F2.lblUsername.Text);
cm.Parameters.AddWithValue("@date", F2.bunifuDatepicker1.Value);
cm.Parameters.AddWithValue("@payment", F2.cbxPayment.Text);;
cm.Parameters.AddWithValue("@days", F2.Dmdays.Text);
cm.Parameters.AddWithValue("@bill", F2.txtBilling.Text);
cm.Parameters.AddWithValue("@duedate", F2.DueDateCalendar.Value.ToString("yyyyMMdd"));
cm.ExecuteNonQuery();
cn.Close();
F2.LoadInvoiceOrder();
this.Dispose();
}
}
}
catch (Exception ex)
{
cn.Close();
MessageBox.Show(ex.Message);
// MessageBox.Show("Product Quantity is now insufficient.", "Stock Validation", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public FrmInvoicePreview(FrmCreateNewInvoice cre)
{
InitializeComponent();
cn = new SqlConnection(dbcon.MyConnection());
inv = cre;
}