private void btn1_GD_view_Click(object sender, EventArgs e)
{
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
if (fFunc.checkSession(user_hash_lbl.Text.ToString(), double.Parse(ConfigurationManager.AppSettings["session_expiry"])) == false)
{
MessageBox.Show("Login expired ! Please login again.");
loginEnable();
tabControl1.SelectedTab = tabPage0;
}
else
{
TabControlGlobal TCG = new TabControlGlobal(user_id_lbl.Text, user_hash_lbl.Text);
dbTableFunctions dbFunc = new dbTableFunctions(user_id_lbl.Text, user_hash_lbl.Text);
GD_view_listView.Clear();
GD_view_listView.View = View.Details;
//fFunc.popListViewT(listView1, "po_details");
DataSet ds = new DataSet();
ds = dbc.SelectMyDA("SELECT * FROM po_details;");
fFunc.popListViewDS(GD_view_listView, ds);
//string query = "UPDATE `po_details` SET `job_number`= \"" + txtBox_gang_num.Text + "\", po_number = \"" + po_number_txtBox1.Text + "\", gang_number = \"" + gang_number_txtBox1.Text + "\" WHERE `id`=1 LIMIT 1; ";
//dbc.Update(query);
}
}
private void button_GD_edit_search_Click(object sender, EventArgs e)
{
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
string s1 = (textBox_GD_edit_GNumSearch.Text == "") ? "" : "%" + textBox_GD_edit_GNumSearch.Text + "%";
string s2 = (textBox_GD_edit_PONumSearch.Text == "") ? "" : "%" + textBox_GD_edit_PONumSearch.Text + "%";
string query = "SELECT cust_po_number, cust_name, SUM(order_qty), COUNT(po_details.id) ";
string query2 = "SELECT po_entry.id ";
string query3 = "FROM po_entry ";
query3 += " JOIN po_details ON po_entry.id = po_details.po_entry_id ";
query3 += " JOIN gang_number ON po_details.gang_number_id = gang_number.id ";
query3 += " WHERE po_details.po_entry_id IN ";
query3 += " (SELECT po_entry.id ";
query3 += " FROM po_entry ";
query3 += " JOIN po_details ON po_details.po_entry_id = po_entry.id ";
query3 += " JOIN gang_number ON po_details.gang_number_id = gang_number.id ";
query3 += " WHERE gang_number.gang_number_id LIKE '" + s1 + "' OR ";
query3 += " cust_po_number LIKE '" + s2 + "' ";
query3 += " GROUP BY po_entry.id)";
query3 += " GROUP BY cust_po_number;";
DataSet ds = new DataSet();
DataSet ds2 = new DataSet();
List<string> IDs = new List<string>();
ds = dbc.SelectMyDA(query + query3);
ds2 = dbc.SelectMyDA(query2 + query3);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
IDs.Add(ds2.Tables[0].Rows[i][0].ToString());
}
fFunc.popListViewDS(listView_GD_edit_searchResult, ds, assignColNames: false, assignTag: true, assignTagBy: IDs);
}
private void btn2_GD_view_Click(object sender, EventArgs e)
{
ConnectToPostgreSQL pgdb = new ConnectToPostgreSQL();
List<string> fldNames = new List<string>();
fldNames.Add("jccostcenterid");
fldNames.Add("jcdescription");
DataSet ds2 = pgdb.Select(fldNames, "costcenter");
DataTable dt = new DataTable();
dt = ds2.Tables[0];
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
fFunc.popListViewDS(GD_view_listView, ds2);
}
private void tabPage_GD_insert_Enter(object sender, EventArgs e)
{
txtBox_gang_num.Text = "";
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
string query = "SELECT cust_po_number, cust_name, SUM(order_qty), COUNT(id) ";
string query2 = "SELECT cust_po_number ";
string query3 = "FROM sales_vars ";
query3 += "WHERE cust_po_number NOT IN (SELECT sales_vars_id FROM graphics_vars_gang) ";
query3 += "GROUP BY cust_po_number;";
DataSet ds = new DataSet();
DataSet ds2 = new DataSet();
List<string> IDs = new List<string>();
ds = dbc.SelectMyDA(query + query3);
ds2 = dbc.SelectMyDA(query2 + query3);
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
IDs.Add(ds2.Tables[0].Rows[i][0].ToString());
}
fFunc.popListViewDS(listView_GD_insert_newPOs, ds, assignColNames: false, assignTag: true, assignTagBy: IDs);
}
private void button_SA_edit_search_Click(object sender, EventArgs e)
{
string s1 = (textBox_SA_edit_CustPoNum.Text == "") ? "" : "%" + textBox_SA_edit_CustPoNum.Text + "%";
string s2 = (textBox_SA_edit_CustName.Text == "") ? "" : "%" + textBox_SA_edit_CustName.Text + "%";
string s3 = (textBox_SA_edit_Notes.Text == "") ? "" : "%" + textBox_SA_edit_Notes.Text + "%";
string query = "SELECT cust_name, cust_po_number, DATE_FORMAT(req_date, '%Y-%m-%d'), notes ";
string query2 = " FROM sales_vars ";
query2 += " WHERE cust_po_number LIKE '" + s1 + "' OR ";
query2 += " cust_name LIKE '" + s2 + "' OR ";
query2 += " notes LIKE '" + s3 + "' ";
string query3 = " GROUP BY cust_po_number ";
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
DataSet ds = new DataSet();
DataSet ds2 = new DataSet();
ds = dbc.SelectMyDA(query + query2 + query3 + ";");
ds2 = dbc.SelectMyDA("SELECT cust_po_number " + query2 + query3 + ";");
List<string> IDs = new List<string>();
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
IDs.Add(ds2.Tables[0].Rows[i][0].ToString());
}
fFunc.popListViewDS(listView1_SA_edit_search, ds, assignColNames: false, assignTag: true, assignTagBy: IDs);
}
