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