public void CreateFiguresStore(FiguresStore fs)
{
_connection.Open();
using (var cmd = new SqlCommand(@"
INSERT INTO Store (Name)
VALUES (@Name) "
, _connection))
{
cmd.Parameters.Add("@Name", SqlDbType.NVarChar);
cmd.Parameters["@Name"].Value = fs.Name;
cmd.ExecuteNonQuery();
}
}
public void UpdateStore(FiguresStore fs)
{
_connection.Open();
using (var cmd = new SqlCommand(@"
UPDATE Store
SET Name = @name
WHERE Id=@Id "
, _connection))
{
cmd.Parameters.Add("@Name", SqlDbType.NVarChar);
cmd.Parameters["@Name"].Value = fs.Name;
cmd.Parameters.Add("@Id", SqlDbType.Int);
cmd.Parameters["@Id"].Value = fs.Id;
cmd.ExecuteNonQuery();
}
}
