private void viewOrd_Load(object sender, EventArgs e) { try { con.DBopen(); con.SqlQuery("SELECT ord_id AS [Order ID], buyer_code AS [Buyer Code],ord_date AS [Order Date], req_ship_date AS [Requested Ship Date], conf_ship_date AS [Confirmed Ship Date],hs_code AS [HS Code],order_val AS [Order Value],trans_split AS [Transaction Split],article AS [Article],ci_no AS [CI No] FROM Orders"); viewOgrid.DataSource = con.SelQryEx(); viewOgrid.ClearSelection(); foreach (DataGridViewColumn col in viewOgrid.Columns) { col.Width = (viewOgrid.Width - 4) / viewOgrid.Columns.Count; } } catch (Exception error) { MessageBox.Show(error.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { con.DBclose(); } }
private void addOrd_Load(object sender, EventArgs e) { con.DBopen(); autoIncriment(id_txt, "SELECT MAX(ord_id) FROM Orders"); try { con.SqlQuery("SELECT buyer_code FROM Buyer ORDER BY buyer_code ASC"); foreach (DataRow dr in con.SelQryEx().Rows) { bc_cmb.Items.Add(dr[0].ToString()); } con.SqlQuery("SELECT article FROM Orders ORDER BY article ASC"); foreach (DataRow dr in con.SelQryEx().Rows) { ar_cmb.Items.Add(dr[0].ToString()); } con.SqlQuery("SELECT ci_no FROM Orders ORDER BY article ASC"); foreach (DataRow dr in con.SelQryEx().Rows) { ci_cmb.Items.Add(dr[0].ToString()); } } catch (Exception error) { MessageBox.Show(error.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } con.DBclose(); }
private void loadCombo() { con.DBopen(); try { con.SqlQuery("SELECT buyer_code FROM Buyer "); foreach (DataRow dr in con.SelQryEx().Rows) { bc_cmb.Items.Add(dr[0].ToString()); } con.SqlQuery("SELECT article FROM Orders "); foreach (DataRow dr in con.SelQryEx().Rows) { ar_cmb.Items.Add(dr[0].ToString()); } con.SqlQuery("SELECT ci_no FROM Orders "); foreach (DataRow dr in con.SelQryEx().Rows) { ci_cmb.Items.Add(dr[0].ToString()); } } catch (Exception er) { MessageBox.Show(er.Message); } finally { con.DBclose(); } }
private void viewo_frm_Load(object sender, EventArgs e) { try { conn.SqlQuery("SELECT payment_id AS [Payment ID],ord_id AS [Order ID],buyer_code AS [Buyer Code],FORMAT( [val_USD],'N2') AS [Value (USD)],FORMAT( [val_LKR],'N2') AS [Value (LKR)],paydate AS [Date],payment_terms AS [Payment Terms] FROM GmntPayment "); viewPgrid.DataSource = conn.SelQryEx(); viewPgrid.ClearSelection(); foreach (DataGridViewColumn col in viewPgrid.Columns) { col.Width = (viewPgrid.Width - 4) / viewPgrid.Columns.Count; } } catch (Exception er) { MessageBox.Show(er.Message); } finally { conn.DBclose(); } }
private void viewo_frm_Load(object sender, EventArgs e) { placeHolders(); conn.DBopen(); try { autoIncriment(pid_txt, "SELECT MAX(payment_id) FROM GmntPayment"); conn.SqlQuery("SELECT ord_id FROM Orders "); foreach (DataRow dr in conn.SelQryEx().Rows) { oid_cmb.Items.Add(dr[0].ToString()); } } catch (Exception er) { MessageBox.Show(er.Message); } finally { conn.DBclose(); } }
private void viewSamples_Load(object sender, EventArgs e) { conn.DBopen(); try { conn.SqlQuery("SELECT Samp_id AS [Sample ID],ord_id AS [Order ID],Buyer_code AS [Buyer Code],FORMAT( [cost_USD],'N2') AS [Cost (USD)],FORMAT( [cost_LKR],'N2') AS [Cost (LKR)],Delivered_date AS [Delivered Date],samp_status AS [Status] FROM Gmnt_sample "); viewSgrid.DataSource = conn.SelQryEx(); viewSgrid.ClearSelection(); //Add link column to end of the grid to view fashion sketch DataGridViewLinkColumn bcol = new DataGridViewLinkColumn(); bcol.HeaderText = " Picture "; bcol.Text = "View"; bcol.LinkColor = Color.Blue; bcol.Name = "FP"; bcol.UseColumnTextForLinkValue = true; viewSgrid.Columns.Add(bcol); foreach (DataGridViewColumn col in viewSgrid.Columns) { col.Width = (viewSgrid.Width - 4) / viewSgrid.Columns.Count; } } catch (Exception er) { MessageBox.Show(er.Message); } finally { conn.DBclose(); } }
private void viewo_frm_Load(object sender, EventArgs e) { con.DBopen(); try { con.SqlQuery("SELECT buyer_code AS [Buyer Code], company AS [Company],address AS [Address] ,country AS [Country],email AS [Email]FROM Buyer "); viewCgrid.DataSource = con.SelQryEx(); } catch (Exception error) { MessageBox.Show(error.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { con.DBclose(); } }
private void loadCombo() { conn.DBopen(); try { conn.SqlQuery("SELECT ord_id FROM Orders "); foreach (DataRow dr in conn.SelQryEx().Rows) { oid_cmb.Items.Add(dr[0].ToString()); } } catch (Exception er) { MessageBox.Show(er.Message); } conn.DBclose(); }
public static string getName(TextBox un, TextBox pw) { string name; DBconnect conn = new DBconnect(); conn.DBopen(); try { conn.SqlQuery("SELECT user_name from login WHERE user_name = '" + un.Text + "' AND password ='******' "); DataTable dt = conn.SelQryEx(); SqlDataReader re = conn.SelQryRedEx(); re.Read(); name = (string)(re[0]); return(name); } catch (Exception er) { return(null); } finally { conn.DBclose(); } }
private void addSamples_frm_Load(object sender, EventArgs e) { conn.DBopen(); autoIncriment(sam_txt, "SELECT MAX(samp_id) FROM Gmnt_sample"); string x = "Please select an order"; oid_cmb.Text = x; placeHolders(); try { conn.SqlQuery("SELECT ord_id FROM Orders "); foreach (DataRow dr in conn.SelQryEx().Rows) { oid_cmb.Items.Add(dr[0].ToString()); } } catch (Exception er) { MessageBox.Show(er.Message); } conn.DBclose(); }
public static void login(TextBox un, TextBox pw, Label l, Form lgfrm, PictureBox p1, PictureBox p2) { DBconnect conn = new DBconnect(); conn.DBopen(); try { conn.SqlQuery("SELECT user_name,password,desig from login WHERE user_name = '" + un.Text + "' AND password ='******' "); DataTable dt = conn.SelQryEx(); SqlDataReader re = conn.SelQryRedEx(); re.Read(); if (un.Text == "User Name" || pw.Text == "Password") { MessageBox.Show("Please enter the user name and the password"); p1.Image = Resources.userRed; p2.Image = Resources.locked_padlockR; un.Text = "User Name"; un.ForeColor = Color.FromArgb(218, 214, 218); pw.Text = "Password"; pw.ForeColor = Color.FromArgb(218, 214, 218); } else { if (dt.Rows.Count == 0) { MessageBox.Show("Invalid Username or Password."); un.Clear(); pw.Clear(); l.Text = "Wrong username or password.Try again."; l.ForeColor = Color.FromArgb(232, 17, 35); l.Visible = true; lgfrm.ActiveControl = un; p1.Image = Resources.userRed; p2.Image = Resources.locked_padlockR; } else { l.Visible = false; if (re.HasRows) { string desig = (string)(re[2]); if (desig == "Sales") { dash frm = new dash(); lgfrm.Visible = false; frm.ShowDialog(); } else if (desig == "Account") { AccountingManagementSysem.Hm frm = new AccountingManagementSysem.Hm(); lgfrm.Visible = false; frm.ShowDialog(); } else if (desig == "Manu") { Manufacturing_Management_System.manudashboard frm = new Manufacturing_Management_System.manudashboard(); lgfrm.Visible = false; frm.ShowDialog(); } else if (desig == "Purch") { Project001.viewinvoice frm = new Project001.viewinvoice(); lgfrm.Visible = false; frm.ShowDialog(); } else if (desig == "Ship") { Package_and_shipment.homepage frm = new Package_and_shipment.homepage(); lgfrm.Visible = false; frm.ShowDialog(); } else if (desig == "Main") { AccountingManagementSysem.Hm frm = new AccountingManagementSysem.Hm(); lgfrm.Visible = false; frm.ShowDialog(); } } } } } catch (Exception er) { MessageBox.Show(er.Message); } finally { conn.DBclose(); } }