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