Inventory-Management-Source-Code/Inventory Source Code.txt at main · MyCodingProject77/Inventory-Management-Source-Code · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128


           Add Code

           Add button Code


       SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-ADG77QL\SQLEXPRESS;Initial Catalog=inventorydb;Integrated Security=True");

       con.Open();

       var sqlQuery = "";

       sqlQuery = @"INSERT INTO [inventorydb].dbo.[protab] ([ProductId],[ProductName],[Price])

             VALUES
            ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox2.Text + "')";

                }


        SqlCommand cnn = new SqlCommand(sqlQuery, con);
        cnn.ExecuteNonQuery();
        con.Close();
        MessageBox.Show("Record Added Successfully", "Add", MessageBoxButtons.OK, MessageBoxIcon.Information);
        ShowData();


        Form_Load

        ShowData();


       Update Code


       SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-ADG77QL\SQLEXPRESS;Initial Catalog=inventorydb;Integrated Security=True");

   con.Open();

   var sqlQuery = "";


   sqlQuery = @"UPDATE [protab] SET [ProductName] = '" + textBox2.Text + "' ,[Price] = '" + textBox3.Text + "' WHERE [ProductId] = '" + textBox1.Text + "'";

   SqlCommand cnn = new SqlCommand(sqlQuery, con);

   cnn.ExecuteNonQuery();
   con.Close();
   MessageBox.Show("Record Updated Successfully", "Update", MessageBoxButtons.OK, MessageBoxIcon.Information);


         Delete Code


        SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-ADG77QL\SQLEXPRESS;Initial Catalog=inventorydb;Integrated Security=True");

     con.Open();

     var sqlQuery = "";

     sqlQuery = @"DELETE FROM [protab] WHERE [ProductId] = '" + textBox1.Text + "'";

     SqlCommand cnn = new SqlCommand(sqlQuery, con);

     cnn.ExecuteNonQuery();

     con.Close();

     MessageBox.Show("Record Deleted Successfully...!");

     ShowData();


        public void ShowData()
        {
            SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-ADG77QL\SQLEXPRESS;Initial Catalog=inventorydb;Integrated Security=True");
            SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [inventorydb].dbo.[protab]", con);
            DataTable table = new DataTable();
            da.Fill(table);
            dataGridView1.Rows.Clear();

            foreach (DataRow item in table.Rows)
            {
                int n = dataGridView1.Rows.Add();
                dataGridView1.Rows[n].Cells["tid"].Value = item["ProductId"].ToString();
                dataGridView1.Rows[n].Cells["tname"].Value = item["ProductName"].ToString();
                dataGridView1.Rows[n].Cells["tprice"].Value = item["Price"].ToString();


            }


        if (dataGridView1.Rows.Count > 0)

            {

                label5.Text = dataGridView1.Rows.Count.ToString();
                label6.Text = dataGridView1.Rows.Count.ToString();
                float totQty = 0;
                for (int i = 0; i < dataGridView1.Rows.Count; ++i)
                {
                    totQty += float.Parse(dataGridView1.Rows[i].Cells["cquantity"].Value.ToString());
                    label6.Text = totQty.ToString();
                }
            }
            else
            {
                label5.Text = "0";
                label6.Text = "0";
            }