public int CreateChartRound(ChartRound chartRound)
{
using (SqlConnection connection = base.GetConnection())
{
SqlCommand command = new SqlCommand("_ChartRoundUpdate", connection) {
CommandType = CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@Type", 0);
command.Parameters.AddWithValue("@ChartRoundID", 1);
command.Parameters.AddWithValue("@ChartName", chartRound.ChartName);
command.Parameters.AddWithValue("@ChartRoundParentID", chartRound.ChartRoundParentID);
command.Parameters.AddWithValue("@Value", chartRound.Value);
command.Parameters.AddWithValue("@ChartPostDate", chartRound.ChartPostDate);
command.Parameters.AddWithValue("@ChartStatus", chartRound.ChartStatus);
connection.Open();
return command.ExecuteNonQuery();
}
}
public int CreateChartRound(ChartRound _chartRound)
{
ChartRoundDAO chartRoundDAO = new ChartRoundDAO();
return chartRoundDAO.CreateChartRound(_chartRound);
}
public int UpdateChartRound(ChartRound chartRound)
{
using (SqlConnection connection = base.GetConnection())
{
SqlCommand command = new SqlCommand("_ChartRoundUpdate", connection) {
CommandType = CommandType.StoredProcedure
};
command.Parameters.AddWithValue("@Type", 1);
command.Parameters.AddWithValue("@ChartRoundID", chartRound.ChartRoundID);
command.Parameters.AddWithValue("@ChartName", chartRound.ChartName);
command.Parameters.AddWithValue("@ChartRoundParentID", chartRound.ChartRoundParentID);
command.Parameters.AddWithValue("@Value", chartRound.Value);
command.Parameters.AddWithValue("@ChartPostDate", chartRound.ChartPostDate);
command.Parameters.AddWithValue("@ChartStatus", chartRound.ChartStatus);
connection.Open();
int i = command.ExecuteNonQuery();
if (i <= 0)
{
throw new DataAccessException("lỗi kh\x00f4ng thể cập nhật");
}
return i;
}
}
