public bool Insert(ProductInfo obj) { var da = new SqlDbDataAccess(); SqlCommand cmd = da.GetCommand( "INSERT INTO [dbo].[Product] ([Pname],[price],[quan],[unit]) VALUES (@pname, @price, @quan,@unit)"); var p1 = new SqlParameter("@Pname", SqlDbType.VarChar, 50) {Value = obj.Pname}; var p2 = new SqlParameter("@price", SqlDbType.VarChar, 50) {Value = obj.Price}; var p3 = new SqlParameter("@quan", SqlDbType.Int) {Value = obj.Quan}; var p4 = new SqlParameter("@unit", SqlDbType.VarChar) {Value = obj.Unit}; cmd.Parameters.Add(p1); cmd.Parameters.Add(p2); cmd.Parameters.Add(p3); cmd.Parameters.Add(p4); cmd.Connection.Open(); int val = cmd.ExecuteNonQuery(); cmd.Connection.Close(); return val > 0; }
private void Add_inventory_button_Click(object sender, EventArgs e) { if (pname_tbox.Text.Equals("") && Pprice_tbox.Text.Equals("") && Pavailable_tbox.Text.Equals("")) { return; } var product = new ProductInfo { Pname = pname_tbox.Text, Price = Pprice_tbox.Text, Quan = Int32.Parse(Pavailable_tbox.Text), Unit = Unit_textBox.Text }; var pdata = new ProductData(); if (pdata.Insert(product)) { MessageBox.Show(@"Product Add Successfully"); } else { MessageBox.Show(@"ERROR ! Try Again"); } }
private List<ProductInfo> GetData(SqlCommand cmd) { cmd.Connection.Open(); SqlDataReader reader = cmd.ExecuteReader(); var list = new List<ProductInfo>(); while (reader.Read()) { var obj = new ProductInfo { Id = reader.GetInt32(0), Pname = reader.GetString(1), Price = reader.GetString(2), Quan = reader.GetInt32(3), Unit = reader.GetString(4) }; list.Add(obj); } reader.Close(); cmd.Connection.Close(); return list; }