public bool add(ProductEntity product)
{
bool rvalue = false;
try
{
if (DBconnection.Connect())
{
SqlCommand cmd = new SqlCommand("new_product", DBconnection.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@code", SqlDbType.VarChar).Value = product.Product_code1;
cmd.Parameters.AddWithValue("@name", SqlDbType.VarChar).Value = product.Product_name1;
cmd.Parameters.AddWithValue("@description", SqlDbType.Text).Value = product.Product_description1;
cmd.Parameters.AddWithValue("@qty_in_hand", SqlDbType.Float).Value = product.Qty_in_hand;
cmd.Parameters.AddWithValue("@is_active", SqlDbType.TinyInt).Value = product.Is_active;
cmd.Parameters.AddWithValue("@is_deleted", SqlDbType.TinyInt).Value = product.Is_deleted;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
rvalue = true;
}
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
return(rvalue);
}
