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