private void cmbSubC_SelectedIndexChanged(object sender, EventArgs e)
{
dbString dbc = new dbString();
string conString = dbc.connectionSring;
MySqlConnection con = new MySqlConnection(conString);
try
{
con.Open();
string query = "SELECT `proId`, `proName`FROM `producttable` WHERE `proSubCategory`= '" + cmbSubC.Text + "'";
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(query, con);
DataTable dataTable = new DataTable();
mySqlDataAdapter.Fill(dataTable);
DataRow dataRow = dataTable.NewRow();
dataRow.ItemArray = new object[] { 0, "--Select--" };
dataTable.Rows.InsertAt(dataRow, 0);
cmbProduct.DataSource = dataTable;
cmbProduct.DisplayMember = "proName";
cmbProduct.ValueMember = "proId";
}
catch
{
// MessageBox.Show("Error");
}
finally
{
con.Close();
}
}
/// <summary>
/// End
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void productSummery_Load(object sender, EventArgs e)
{
//TextBox Values
cmbSelect.Text = "Yearly";
cmbType.Text = "By Qty";
cmbYear.Text = "2019";
cmbMonth.Text = "January";
cmbCategory.Text = "Select";
cmbSubC.Text = "Select";
cmbProduct.Text = "Select";
dbString dbc = new dbString();
string conString = dbc.connectionSring;
MySqlConnection con = new MySqlConnection(conString);
try
{
con.Open();
string query = "SELECT `categoryId`, `categoryName` FROM `productcategory` WHERE 1";
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(query, con);
DataTable dataTable = new DataTable();
mySqlDataAdapter.Fill(dataTable);
DataRow dataRow = dataTable.NewRow();
dataRow.ItemArray = new object[] { 0, "--Select--" };
dataTable.Rows.InsertAt(dataRow, 0);
cmbCategory.DataSource = dataTable;
cmbCategory.DisplayMember = "categoryName";
cmbCategory.ValueMember = "categoryId";
}
catch { }
finally {
con.Close();
}
}
///
private void updateDataGridView(String queryString, String duration)
{
//Removing previous content
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
dataGridView1.ColumnCount = 2;
dataGridView1.Columns[0].Name = duration;
dataGridView1.Columns[1].Name = "Sales Amount";
dbString dbc = new dbString();
string conString = dbc.connectionSring;
MySqlConnection con = new MySqlConnection(conString);
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(queryString, con);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
//txtSupName.Text = (rdr[4]).ToString();
// txtPlaced.Text = (rdr[5]).ToString();
// txtExpected.Text = (rdr[6]).ToString();
string[] row = new string[] { (rdr[0]).ToString(), (rdr[1]).ToString() };
dataGridView1.Rows.Add(row);
//productList.Add(new InvPurchaseOrder.NodePO(Convert.ToInt32(rdr[0]), rdr[1].ToString(), Convert.ToSingle(rdr[2]), Convert.ToSingle(rdr[3]), Convert.ToSingle(rdr[4]), Convert.ToSingle(rdr[6]), Convert.ToInt32(rdr[5]), Convert.ToSingle(rdr[7])));
}
}
catch (Exception exec)
{
// MessageBox.Show("Erro r" + exec);
}
finally
{
con.Close();
duration = "";
queryString = "";
}
}
private void button2_Click(object sender, EventArgs e)
{
button2.Enabled = false;
button2.Hide();
txtPO.Enabled = false;
dbString db = new dbString();
string connString = db.connectionSring;
MySqlConnection conn = new MySqlConnection(connString);
try
{
conn.Open();
string rtn = @"SELECT ppq.`product_id`, pro.proName, pro.proMinPrice, ppq.`product_qty`,sup.SupName, po.datePlaced,
po.dateExpected FROM `purchaseorder_product_quantitytable` ppq join `purchaseordertable` po ON ppq.`purchaseorderId`=po.po_id JOIN
producttable pro ON pro.proId=ppq.`product_id` JOIN suppliertable sup ON pro.proSupplierId=sup.supId WHERE ppq.`purchaseorderId`='" + txtPO.Text + "' And po.`status`='0'";
MySqlCommand cmd = new MySqlCommand(rtn, conn);
MySqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
txtSupName.Text = (rdr[4]).ToString();
txtPlaced.Text = (rdr[5]).ToString();
txtExpected.Text = (rdr[6]).ToString();
string[] row = new string[] { (rdr[0]).ToString(), (rdr[1]).ToString(), (rdr[2]).ToString(), rdr[3].ToString( ), (rdr[3]).ToString( ) };
dataGridView1.Rows.Add(row);
}
cellvalueChanged();
CalculateOtherData();
}
catch (Exception exb)
{
MessageBox.Show("" + exb);
}
finally
{
conn.Close();
}
}
private void btnPO_Click(object sender, EventArgs e)
{
dbString db = new dbString();
string connString = db.connectionSring;
MySqlConnection conn = new MySqlConnection(connString);
if (txtInvoice.Text != "")
{
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
try
{
string rtn2 = @"UPDATE `producttable` SET `proStock`= (`proStock`+ '" + Convert.ToSingle(dataGridView1.Rows[i].Cells[4].Value) + "' ) WHERE `proId` = '" + dataGridView1.Rows[i].Cells[0].Value + "'";
conn.Open();
MySqlCommand comm = conn.CreateCommand();
comm.CommandText = rtn2;
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
// MessageBox.Show("Some Exception has Occured Please try again.");
}
finally
{
conn.Close();
}
}
try
{
string rtn = @"INSERT INTO `recievedtable`( `poId`, `invoiceNo`, `recievedDate`, `total`) VALUES ('" + txtPO.Text + "', '" + txtInvoice.Text + "','" + DateTime.Today.ToString("yyyy-MM-dd") + "', '" + txtOrdervalue.Text + "')";
conn.Open();
MySqlCommand comm = conn.CreateCommand();
comm.CommandText = rtn;
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
//MessageBox.Show("Some Exception has Occured Please try again.");
}
finally
{
conn.Close();
}
//////////////////////////////////////
//Update PO Table
try
{
string rtn1 = @"UPDATE `purchaseordertable` SET `status`= '1' WHERE `po_id` = " + Convert.ToInt32(txtPO.Text) + "";
conn.Open();
MySqlCommand comm = conn.CreateCommand();
comm.CommandText = rtn1;
comm.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("Some Exception has Occured Please try again.");
}
finally
{
conn.Close();
this.Close();
}
}
else
{
MessageBox.Show("Please Enter the Invoice Number");
}
}
private void updateDataGridView(String queryString, String duration)
{
//Removing previous content
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
dataGridView1.ColumnCount = 2;
dataGridView1.Columns[0].Name = duration;
dataGridView1.Columns[1].Name = "Sales Amount";
dbString dbc = new dbString();
string conString = dbc.connectionSring;
MySqlConnection con = new MySqlConnection(conString);
try
{
con.Open();
MySqlCommand cmd = new MySqlCommand(queryString, con);
MySqlDataReader rdr = cmd.ExecuteReader();
int i = 1;
while (rdr.Read() && i < 33)
{
if (cmbSelect.Text == "Daily")
{
{
for (int x = 0; x < 32; x++)
{
if (rdr[0].ToString() == ("0" + i.ToString() + "-08-2019"))
{
string[] row1 = new string[] { (rdr[0]).ToString(), (rdr[1]).ToString() };
dataGridView1.Rows.Add(row1);
break;
}
else if (rdr[0].ToString() == i.ToString() + "-08-2019")
{
string[] row1 = new string[] { (rdr[0]).ToString(), (rdr[1]).ToString() };
dataGridView1.Rows.Add(row1);
break;
}
else
{
string[] row1 = new string[] { i + ("-08-2019").ToString(), "0" };
dataGridView1.Rows.Add(row1);
i++;
}
}
}
}
else
{
string[] row = new string[] { (rdr[0]).ToString(), (rdr[1]).ToString() };
dataGridView1.Rows.Add(row);
}
i++;
}
}
catch (Exception exec)
{
MessageBox.Show("Erro r" + exec);
}
finally
{
con.Close();
}
}
