private void glassButton5_Click(object sender, EventArgs e)
{
ReceiptForm rc = new ReceiptForm(dataGridView1.CurrentRow.Cells[0].Value.ToString(), user, "rec");
rc.ShowDialog();
}
private void glassButton5_Click(object sender, EventArgs e)
{
int supr = 0;
bool chngeoccur = false;
decimal cashamount = 0;
decimal cashamount2 = 0;
for (int ii = 0; ii < dataGridView1.Rows.Count; ii++)
{
if (dataGridView1.Rows[ii].Cells[2].Value.ToString() != "0")
{
chngeoccur = true;
}
}
if (chngeoccur==true)
{
if (MessageBox.Show("Are you sure you want to void selected Item(s)?", "Void Transaction", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//try
{
for (int ii = 0; ii < dataGridView1.Rows.Count; ii++)
{
// MessageBox.Show(dataGridView1.Rows[ii].Cells[0].Value.ToString());
if (dataGridView1.Rows[ii].Cells[4].Value.ToString().Contains("Void"))
{
MessageBox.Show(dataGridView1.Rows[ii].Cells[1].Value.ToString() + " is already void");
}
else
{
if (dataGridView1.Rows[ii].Cells[2].Value.ToString() != "0")
{
int quandif = 0;
int quandif2 = 0;
decimal newamount = Convert.ToDecimal(dataGridView1.Rows[ii].Cells[5].Value.ToString());
decimal newamount2 = 0;
{
string query;
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from trans_items WHERE trans_item_id = '" + dataGridView1.CurrentRow.Cells[3].Value.ToString() + "' ";
dbFill(query);
while (dbReader.Read())
{
quandif2 = Convert.ToInt32(dbReader["quan"].ToString());
quandif = quandif2 - Convert.ToInt32(dataGridView1.Rows[ii].Cells[2].Value.ToString());
newamount2 = newamount * quandif;
}
dbReader.Close();
dbConn.Close();
}
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
{
// query33 = " Update trans_items Set sum_amount = '" + dataGridView1.Rows[ii].Cells[6].Value.ToString() + "',quan = '" + quandif + "', notes = '" + "Void " + "(" + System.DateTime.Now.ToShortDateString() + ")" + "' Where trans_item_id = '" + dataGridView1.Rows[ii].Cells[3].Value.ToString() + "'";
query33 = " Update trans_items Set sum_amount = '" + dataGridView1.Rows[ii].Cells[6].Value.ToString() + "',quan = '" + quandif + "' Where trans_item_id = '" + dataGridView1.Rows[ii].Cells[3].Value.ToString() + "'";
}
dbQuery(query33);
if (supr == 0)
{
MessageBox.Show("Item(s) are now void.");
}
supr++;
}
{
{
decimal qq1 = 0;
decimal qq2 = 0;
int qq3 = 0;
int qq4 = 0;
string query;
string newdate = dateparser(Convert.ToDateTime(dataGridView1.Rows[ii].Cells[7].Value)).ToString();
// MessageBox.Show(newdate);
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from totaltrans Where time_sum LIKE '" + newdate + "%' AND item_name = '" + dataGridView1.Rows[ii].Cells[1].Value.ToString() + "'";
dbFill(query);
while (dbReader.Read())
{
qq1 = Convert.ToDecimal(dbReader["sum_amount"].ToString());
qq2 = qq1 - (Convert.ToDecimal(dataGridView1.Rows[ii].Cells[2].Value.ToString()) * (Convert.ToDecimal(dataGridView1.Rows[ii].Cells[5].Value.ToString())));
qq3 = Convert.ToInt32(dbReader["quan"].ToString());
qq4 = qq3 - (Convert.ToInt32(dataGridView1.Rows[ii].Cells[2].Value.ToString()));
// MessageBox.Show(qq2.ToString() + qq4.ToString());
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
{
query33 = " Update totaltrans Set sum_amount = '" + qq2.ToString() + "',quan = '" + qq4.ToString() + "'WHERE time_sum LIKE '" + newdate + "%' AND item_name = '" + dataGridView1.Rows[ii].Cells[1].Value.ToString() + "'";
}
dbQuery(query33);
}
}
dbReader.Close();
dbConn.Close();
}
}
{
{
int qq3 = 0;
int qq4 = 0;
string query;
string newdate = dateparser(Convert.ToDateTime(dataGridView1.Rows[ii].Cells[7].Value)).ToString();
// MessageBox.Show(newdate);
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from itemlist Where item_name = '" + dataGridView1.Rows[ii].Cells[1].Value.ToString() + "'";
dbFill(query);
while (dbReader.Read())
{
qq3 = Convert.ToInt32(dbReader["quan"].ToString());
qq4 = qq3 + (Convert.ToInt32(dataGridView1.Rows[ii].Cells[2].Value.ToString()));
// MessageBox.Show(qq2.ToString() + qq4.ToString());
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
{
query33 = " Update itemlist Set quan = '" + qq4.ToString() + "'WHERE item_name = '" + dataGridView1.Rows[ii].Cells[1].Value.ToString() + "'";
}
dbQuery(query33);
}
}
dbReader.Close();
dbConn.Close();
}
}
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
try
{
query33 = "Insert Into voidtable Values('" + "VOID" + idcomponent() + ":" + textBox1.Text + "','" + dataGridView1.Rows[ii].Cells[3].Value.ToString() + "','" + dataGridView1.Rows[ii].Cells[1].Value.ToString() + "','" + dataGridView1.Rows[ii].Cells[2].Value.ToString() + "','" + datecomponent() + "','" + "Void" + "')";
dbQuery(query33);
}
catch
{
upvoidtable(dataGridView1.Rows[ii].Cells[3].Value.ToString(), Convert.ToInt32(dataGridView1.Rows[ii].Cells[2].Value.ToString()));
}
}
{
{
string query;
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from trans_items Where trans_id = '" + textBox1.Text + "'";
dbFill(query);
while (dbReader.Read())
{
cashamount = (Convert.ToDecimal(dbReader["sum_amount"].ToString())) + cashamount;
}
dbReader.Close();
dbConn.Close();
}
{
string query;
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from trans_misc Where trans_id = '" + textBox1.Text + "'";
dbFill(query);
while (dbReader.Read())
{
cashamount2 = (Convert.ToDecimal(dbReader["payment"].ToString())) - cashamount;
}
dbReader.Close();
dbConn.Close();
}
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
{
query33 = "Update trans_misc Set trans_misc.change = '" + cashamount2 + "'Where trans_id = '" + textBox1.Text + "'";
// query33 = " Update totaltrans Set sum_amount = '" + qq2.ToString() + "',quan = '" + qq4.ToString() + "'WHERE time_sum LIKE '" + newdate + "%' AND item_name = '" + dataGridView1.Rows[ii].Cells[1].Value.ToString() + "'";
}
dbQuery(query33);
}
string name = "";
{
string query;
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from logs WHERE userna = '" + user + "'";
dbFill(query);
while (dbReader.Read())
{
name = dbReader["names"].ToString();
}
dbReader.Close();
dbConn.Close();
}
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = "Insert Into security Values('" + System.DateTime.Now.ToString() + "(" + System.DateTime.Now.Millisecond.ToString() + ")_" + name + "','" + "Voided Transaction ID: " + textBox1.Text + "','" + System.DateTime.Now.ToString() + "','" + name + "','" + terms() + "')";
dbQuery(query33);
}
}
ReceiptForm rc = new ReceiptForm(textBox1.Text, user, "void");
rc.Show();
{
dataGridView1.Rows.Clear();
glassButton2.Enabled = false;
glassButton5.Enabled = false;
glassButton3.Enabled = false;
textBox1.Text = "";
}
}
}
}
}
}
// catch { }
}
}
private void finalize()
{
timex = 0;
bool meronmonth = false; bool meronAnnual = false;
counta = dataGridView1.Rows.Count;
try
{
if (counta == 0)
{
MessageBox.Show("Please add items using Add to List button", "Blue and Silver Bookshop", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (pricetag2 > (Convert.ToDecimal(textBox1.Text)))
{
MessageBox.Show("The cash you entered is not enough. \nPlease check if you mispelled the correct input.", "Blue and Silver Bookshop", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
if (MessageBox.Show("Are you sure you want to finalize?", "Inventory System", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int currentcount = 0;
decimal currAmount = 0;
decimal currAmounta = 0; int currentcounta = 0;
decimal currAmountmm = 0; int currentcountmm = 0;
decimal currAmountm = 0; int currentcountm = 0;
{
change = Convert.ToDecimal(textBox1.Text) - pricetag2;
label12.Text = "₱ " + Convert.ToDouble(textBox1.Text).ToString("#,##0.00");
label10.Text = "₱ " + change.ToString("#,##0.00");
rubik = "TRANS" + System.DateTime.Now.Year.ToString() + System.DateTime.Now.Month.ToString() + System.DateTime.Now.Day.ToString() + System.DateTime.Now.Millisecond.ToString();
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = "Insert Into transaction Values('" + rubik + "','" + timecomponent() + "','" + user + "')";
dbQuery(query33);
}
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = "Insert Into trans_misc Values('" + rubik + "','" + change + "','" + Convert.ToDecimal(textBox1.Text) + "')";
dbQuery(query33);
}
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = "Insert Into security Values('" + System.DateTime.Now.ToString() + "(" + System.DateTime.Now.Millisecond.ToString() + ")_" + name + "','" + "Created a transaction w/ the ID: " + rubik + "','" + System.DateTime.Now.ToString() + "','" + name + "','"+terms()+"')";
dbQuery(query33);
}
{
do
{
bool meron = false;
{
string query = "";
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
if ((System.DateTime.Now.Month.Equals(1)) || (System.DateTime.Now.Month.Equals(3)) || (System.DateTime.Now.Month.Equals(5)) || (System.DateTime.Now.Month.Equals(7)) || (System.DateTime.Now.Month.Equals(8)) || (System.DateTime.Now.Month.Equals(10)) || (System.DateTime.Now.Month.Equals(12)))
{
query = "Select * from totaltrans WHERE time_sum BETWEEN '" + monthCom() + "1" + "' AND '" + monthCom() + "31 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "month" + "'";
}
else if ((System.DateTime.Now.Month.Equals(4)) || (System.DateTime.Now.Month.Equals(6)) || (System.DateTime.Now.Month.Equals(9)) || (System.DateTime.Now.Month.Equals(11)))
{
query = "Select * from totaltrans WHERE time_sum BETWEEN '" + monthCom() + "1" + "' AND '" + monthCom() + "30 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "month" + "'";
}
else if ((System.DateTime.Now.Month.Equals(2)))
{
query = "Select * from totaltrans WHERE time_sum BETWEEN '" + monthCom() + "1" + "' AND '" + monthCom() + "28 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "month" + "'";
}
dbFill(query);
while (dbReader.Read())
{
// MessageBox.Show("may month");
meronmonth = true;
currentcountmm = int.Parse(dbReader["quan"].ToString());
currAmountmm = decimal.Parse(dbReader["sum_amount"].ToString());
}
dbReader.Close();
dbConn.Close();
}
{
string query;
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from totaltrans WHERE time_sum BETWEEN '" + datecomponent() + "' AND '" + datecomponent() + " 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "daily" + "'";
dbFill(query);
while (dbReader.Read())
{
meron = true;
currentcountm = int.Parse(dbReader["quan"].ToString());
currAmountm = decimal.Parse(dbReader["sum_amount"].ToString());
}
dbReader.Close();
dbConn.Close();
}
{
string query;
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from totaltrans WHERE time_sum BETWEEN '" + yearCom() + "1/1" + "' AND '" + yearCom() + "12/31 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "annual" + "'";
dbFill(query);
while (dbReader.Read())
{
// MessageBox.Show("may annu nakita");
meronAnnual = true;
currentcounta = int.Parse(dbReader["quan"].ToString());
currAmounta = decimal.Parse(dbReader["sum_amount"].ToString());
}
dbReader.Close();
dbConn.Close();
}
if (meronAnnual == false)
{
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = "Insert Into totaltrans Values('" + "TIAN" + idcomponent() + "','" + dataGridView1.Rows[counta - 1].Cells[6].Value.ToString() + "','" + dataGridView1.Rows[counta - 1].Cells[1].Value.ToString() + "','" + dataGridView1.Rows[counta - 1].Cells[3].Value.ToString() + "','" + timecomponent() + "','" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "','" + Convert.ToDecimal(dataGridView1.Rows[counta - 1].Cells[4].Value.ToString()) + "','" + "annual" + "')";
dbQuery(query33);
// MessageBox.Show("may insert annu");
}
}
else if (meronAnnual == true)
{
{
currAmounta = decimal.Parse(dataGridView1.Rows[counta - 1].Cells[4].Value.ToString()) + currAmounta;
currentcounta = int.Parse(dataGridView1.Rows[counta - 1].Cells[3].Value.ToString()) + currentcounta;
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = " Update totaltrans Set quan = '" + currentcounta + "', sum_amount = '" + currAmounta + "' Where time_sum BETWEEN '" + yearCom() + "1/1" + "' AND '" + yearCom() + "12/31 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "annual" + "'";
dbQuery(query33);
// MessageBox.Show("may update annu");
}
}
if (meron == false)
{
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = "Insert Into totaltrans Values('" + "TIDA" + idcomponent() + "','" + dataGridView1.Rows[counta - 1].Cells[6].Value.ToString() + "','" + dataGridView1.Rows[counta - 1].Cells[1].Value.ToString() + "','" + dataGridView1.Rows[counta - 1].Cells[3].Value.ToString() + "','" + timecomponent() + "','" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "','" + Convert.ToDecimal(dataGridView1.Rows[counta - 1].Cells[4].Value.ToString()) + "','" + "daily" + "')";
dbQuery(query33);
}
}
else
{
{
currAmountm = decimal.Parse(dataGridView1.Rows[counta - 1].Cells[4].Value.ToString()) + currAmountm;
currentcountm = int.Parse(dataGridView1.Rows[counta - 1].Cells[3].Value.ToString()) + currentcountm;
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = " Update totaltrans Set quan = '" + currentcountm + "', sum_amount = '" + currAmountm + "' Where time_sum BETWEEN '" + datecomponent() + "' AND '" + datecomponent() + " 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "daily" + "'";
dbQuery(query33);
}
}
if (meronmonth == false)
{
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = "Insert Into totaltrans Values('" + "TIMN" + idcomponent() + "','" + dataGridView1.Rows[counta - 1].Cells[6].Value.ToString() + "','" + dataGridView1.Rows[counta - 1].Cells[1].Value.ToString() + "','" + dataGridView1.Rows[counta - 1].Cells[3].Value.ToString() + "','" + timecomponent() + "','" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "','" + Convert.ToDecimal(dataGridView1.Rows[counta - 1].Cells[4].Value.ToString()) + "','" + "month" + "')";
// MessageBox.Show("may month ins");
dbQuery(query33);
}
}
else if (meronmonth == true)
{
{
currAmountmm = decimal.Parse(dataGridView1.Rows[counta - 1].Cells[4].Value.ToString()) + currAmountmm;
currentcountmm = int.Parse(dataGridView1.Rows[counta - 1].Cells[3].Value.ToString()) + currentcountmm;
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
if ((System.DateTime.Now.Month.Equals(1)) || (System.DateTime.Now.Month.Equals(3)) || (System.DateTime.Now.Month.Equals(5)) || (System.DateTime.Now.Month.Equals(7)) || (System.DateTime.Now.Month.Equals(8)) || (System.DateTime.Now.Month.Equals(10)) || (System.DateTime.Now.Month.Equals(12)))
{
query33 = " Update totaltrans Set quan = '" + currentcountmm + "', sum_amount = '" + currAmountmm + "' Where time_sum BETWEEN '" + monthCom() + "1" + "' AND '" + monthCom() + "31 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "month" + "'";
}
else if ((System.DateTime.Now.Month.Equals(4)) || (System.DateTime.Now.Month.Equals(6)) || (System.DateTime.Now.Month.Equals(9)) || (System.DateTime.Now.Month.Equals(11)))
{
query33 = " Update totaltrans Set quan = '" + currentcountmm + "', sum_amount = '" + currAmountmm + "' Where time_sum BETWEEN '" + monthCom() + "1" + "' AND '" + monthCom() + "30 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "month" + "'";
}
else
{
query33 = " Update totaltrans Set quan = '" + currentcountmm + "', sum_amount = '" + currAmountmm + "' Where time_sum BETWEEN '" + monthCom() + "1" + "' AND '" + monthCom() + "28 23:59:59" + "' AND item_id = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "' AND typex = '" + "month" + "'";
}
// MessageBox.Show("may update month");
dbQuery(query33);
}
}
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = "Insert Into trans_items Values('" + "ITEM" + idcomponent() + "','" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "','" + dataGridView1.Rows[counta - 1].Cells[1].Value.ToString() + "','" + rubik + "','" + dataGridView1.Rows[counta - 1].Cells[3].Value.ToString() + "','" + dataGridView1.Rows[counta - 1].Cells[4].Value.ToString() + "','" + "" + "')";
dbQuery(query33);
}
{
string query;
StreamReader sr = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr.ReadLine();
StreamReader sr3 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr3.ReadLine();
StreamReader sr4 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr4.ReadLine();
string sConnection = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection = new MySqlConnection(sConnection);
query = "Select * from itemlist WHERE item_no = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "'";
dbFill(query);
while (dbReader.Read())
{
quan = int.Parse(dbReader["quan"].ToString());
}
dbReader.Close();
dbConn.Close();
}
minquan = quan - (int.Parse(dataGridView1.Rows[counta - 1].Cells[3].Value.ToString()));
//MessageBox.Show(minquan.ToString());
{
string query33;
StreamReader sr33 = new StreamReader(Application.StartupPath.ToString() + "//data.txt");
line = sr33.ReadLine();
StreamReader sr34 = new StreamReader(Application.StartupPath.ToString() + "//dataP.txt");
dbP = sr34.ReadLine();
StreamReader sr35 = new StreamReader(Application.StartupPath.ToString() + "//dataU.txt");
dbU = sr35.ReadLine();
string sConnection33 = "SERVER=" + line + ";" + "DATABASE=lamolinventory;" + "UID=" + dbU + ";" + "PASSWORD='******';";
MySqlConnection sqlConnection33 = new MySqlConnection(sConnection33);
query33 = " Update itemlist Set quan = '" + minquan + "' Where item_no = '" + dataGridView1.Rows[counta - 1].Cells[5].Value.ToString() + "'";
dbQuery(query33);
}
counta--;
} while (counta > 0);
}
label15.Text = label1.Text;
label16.Text = label10.Text;
label17.Text = label12.Text;
ReceiptForm rc = new ReceiptForm(rubik, user, "rec");
// timer3.Enabled = true;
if (checkBox1.Checked == true)
{
textBox5.Visible = true;
label5.Visible = false;
textBox5.Focus();
}
else
{
textBox5.Visible = false;
label5.Visible = true;
textBox2.Focus();
}
if (checkBox2.Checked == true)
{
// newTrans();
}
// newTrans();
textBox4.Text = "0";
rc.ShowDialog();
}
}
}
}
catch
{
textBox1.Text = "";
MessageBox.Show("Invalid Cash Input!", "Blue and Silver Bookshop", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
