private static TypeExpense LoadTypeExpense(SqlDataReader reader)
{
//Создаём пустой объект
TypeExpense typeExpense = new TypeExpense();
//Заполняем поля объекта в соответствии с названиями полей результирующего
// набора данных
typeExpense.Description = reader.GetString(reader.GetOrdinal("descriptionExpense"));
typeExpense.idType = reader.GetInt32(reader.GetOrdinal("idType"));
typeExpense.Limited = reader.GetDouble(reader.GetOrdinal("limitedExpense"));
typeExpense.Title = reader.GetString(reader.GetOrdinal("titleExpense"));
return(typeExpense);
}
public void Add(TypeExpense typeExpense)
{
using (var conn = GetConnection())
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText =
"INSERT INTO TypeExpense(descriptionExpense, limitedExpense, titleExpense) " +
"VALUES( @descriptionExpense, @limitedExpense, @titleExpense)";
cmd.Parameters.AddWithValue("@descriptionExpense", typeExpense.Description);
cmd.Parameters.AddWithValue("@limitedExpense", typeExpense.Limited);
cmd.Parameters.AddWithValue("@titleExpense", typeExpense.Title);
cmd.ExecuteNonQuery();
}
}
}
public void Update(TypeExpense typeExpense)
{
using (var conn = GetConnection())
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "UPDATE TypeExpense SET descriptionExpense = @descriptionExpense, " +
"limitedExpense = @limitedExpense, titleExpense = @titleExpense WHERE idType = @idType";
cmd.Parameters.AddWithValue("@idType", typeExpense.idType);
cmd.Parameters.AddWithValue("@descriptionExpense", typeExpense.Description);
cmd.Parameters.AddWithValue("@limitedExpense", typeExpense.Limited);
cmd.Parameters.AddWithValue("@titleExpense", typeExpense.Title);
cmd.ExecuteNonQuery();
}
}
}
