private void uncollect_Click(object sender, EventArgs e)
{
Database db = new Database();
DataTable dt = new DataTable();
dt = db.select("select * from TON where IsRecieved = 0 ");
for (int i = 0; i < dt.Rows.Count; i++)
{
string query = "insert into rptData values ('" + dt.Rows[i][0] + ""
+ " (TON)', '" + dt.Rows[i][1] + "','" + dt.Rows[i][2] + "')";
db.inserUpdateDelete(query);
}
dt = db.select("SELECT grn.GRNID, grn.date, sup.supName, sup.location, grn.IsDelivered FROM "
+ " GRN grn INNER JOIN Supplier sup ON grn.supID = sup.supID where grn.IsDelivered = 0");
for (int i = 0; i < dt.Rows.Count; i++)
{
string query = "insert into rptData values ( '" + dt.Rows[i][0] + ""
+ " (GRN)', '" + dt.Rows[i][1] + "','" + dt.Rows[i][2] + " , " + dt.Rows[i][3].ToString() + "')";
db.inserUpdateDelete(query);
}
UncollectedItems uncollectedItems = new UncollectedItems();
uncollectedItems.ShowDialog();
}
private void uncollect_Click(object sender, EventArgs e)
{
UncollectedItems uncollectedItems = new UncollectedItems();
uncollectedItems.ShowDialog();
}
