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 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 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 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 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();
}
}
public static void autoIncriment(Control t, string sqlQuery)
{
DBconnect conn = new DBconnect();
conn.DBopen();
conn.SqlQuery(sqlQuery);
SqlDataReader re = conn.SelQryRedEx();
try
{
re.Read();
string value = re[0].ToString();
if (value == "")
{
t.Text = "PMT0001";
}
else
{
string temp = value.Substring(3, 4);
int number = Convert.ToInt32(temp);
number++;
string result = number.ToString().PadLeft(4, '0');
t.Text = "PMT" + result.ToString();
}
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
conn.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();
}
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 button1_Click(object sender, EventArgs e)
{
try
{
String strBLOBFilePath = @"C:\Users\BHAGI\Pictures\Screenshots\b.png";
FileStream fsBLOBFile = new FileStream(strBLOBFilePath, FileMode.Open, FileAccess.Read);
Byte[] bytBLOBData = new Byte[fsBLOBFile.Length];
fsBLOBFile.Read(bytBLOBData, 0, bytBLOBData.Length);
fsBLOBFile.Close();
conn.SqlQuery("INSERT INTO login Values('bolt','bole','1234','" + bytBLOBData + "')");
conn.InsQryEx();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void loadPicture(string name)
{
conn.DBopen();
try
{
conn.SqlQuery("SELECT [fashion_sketch] FROM Gmnt_sample WHERE [Samp_id] = '" + name + "'");
SqlDataReader re = conn.SelQryRedEx();
re.Read();
string img = (string)(re[0]);
FP_pb.Image = Image.FromFile(img);
FP_pb.SizeMode = PictureBoxSizeMode.StretchImage;
FP_pb.BorderStyle = BorderStyle.None;
}
catch (Exception er)
{
MessageBox.Show(er.Message);
}
conn.DBclose();
}
private void cntry_txt_SelectedIndexChanged(object sender, EventArgs e)
{
con.DBopen();
try
{
string code = cntry_cmb.Text;
con.SqlQuery("SELECT phonecode FROM country where nicename = @parameter ");
con.cmd.Parameters.AddWithValue("@parameter", code);
Int32 no = (Int32)con.cmd.ExecuteScalar();
phc_txt.Text = "+" + no.ToString();
phc_txt.Enabled = false;
}
catch (Exception error)
{
MessageBox.Show(error.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.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 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();
}
}
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();
}
}
