private static ExpenseByWorker LoadExpenseByWorker(SqlDataReader reader) { //Создаём пустой объект ExpenseByWorker expenseByWorker = new ExpenseByWorker(); //Заполняем поля объекта в соответствии с названиями полей результирующего // набора данных expenseByWorker.Date = reader.GetDateTime(reader.GetOrdinal("date")); expenseByWorker.Description = reader.GetString(reader.GetOrdinal("description")); expenseByWorker.idConsumption = reader.GetInt32(reader.GetOrdinal("idConsumption")); expenseByWorker.idType = reader.GetInt32(reader.GetOrdinal("idType")); expenseByWorker.idWorker = reader.GetInt32(reader.GetOrdinal("idWorker")); expenseByWorker.Sum = reader.GetDouble(reader.GetOrdinal("sum")); return(expenseByWorker); }
public void Add(ExpenseByWorker expense) { using (var conn = GetConnection()) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = "INSERT INTO ExpenseByWorker (date, description, idType, idWorker, sum)" + "VALUES (@date, @description, @idType, @idWorker, @sum)"; cmd.Parameters.AddWithValue("@date", expense.Date); cmd.Parameters.AddWithValue("@description", expense.Description); //cmd.Parameters.AddWithValue("@idConsumption", expense.idConsumption); cmd.Parameters.AddWithValue("@idType", expense.idType); cmd.Parameters.AddWithValue("@idWorker", expense.idWorker); cmd.Parameters.AddWithValue("@sum", expense.Sum); cmd.ExecuteNonQuery(); } } }
public void Update(ExpenseByWorker expense) { using (var conn = GetConnection()) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = "UPDATE ExpenseByWorkers SET date = @date, description = @description, " + "idType = @idType, idWorker = @idWorker, sum = @sum " + "WHERE idConsumption = @idConsumption"; cmd.Parameters.AddWithValue("@idConsumption", expense.idConsumption); cmd.Parameters.AddWithValue("@date", expense.Date); cmd.Parameters.AddWithValue("@description", expense.Description); cmd.Parameters.AddWithValue("@idType", expense.idType); cmd.Parameters.AddWithValue("@idWorker", expense.idWorker); cmd.Parameters.AddWithValue("@sum", expense.Sum); cmd.ExecuteNonQuery(); } } }