public void AvgYearSales(InfoAnual a) { SqlCommand cmd = this.CreateCommand("avg_year_sales"); SqlParameter param; cmd.CommandType = CommandType.StoredProcedure; param = cmd.Parameters.Add(new SqlParameter("@codigo", SqlDbType.Char, 13)); param.Value = a.CodigoProduto; param = cmd.Parameters.Add(new SqlParameter("@year", SqlDbType.SmallInt)); param.Value = a.ano; MySession.EndTransaction(true, isMyTransaction); MySession.CloseConnection(isMyConnection); }
public void Delete(InfoAnual entity) { throw new NotImplementedException(); }