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;
}
