public void AddSimpleAd(SimpleAd ad)
{
ad.Date = DateTime.Now;
using (var context = new SimpleAdsContext(_connectionString))
{
context.Ads.Add(ad);
context.SaveChanges();
}
}
private SimpleAd GetAdFromReader(SqlDataReader reader)
{
SimpleAd ad = new SimpleAd
{
Name = reader.Get <string>("Name"),
Description = reader.Get <string>("Description"),
PhoneNumber = reader.Get <string>("PhoneNumber"),
Id = reader.Get <int>("Id"),
UserId = reader.Get <int>("UserId")
};
return(ad);
}
public void AddSimpleAd(SimpleAd ad)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = "INSERT INTO Ads (Description, PhoneNumber, DateCreated, UserId) " +
"VALUES (@desc, @phone, GETDATE(), @userId) SELECT SCOPE_IDENTITY()";
command.Parameters.AddWithValue("@desc", ad.Description);
command.Parameters.AddWithValue("@phone", ad.PhoneNumber);
command.Parameters.AddWithValue("@userId", ad.UserId);
connection.Open();
ad.Id = (int)(decimal)command.ExecuteScalar();
}
}
public void AddSimpleAd(SimpleAd ad)
{
using (SqlConnection connection = new SqlConnection(_connectionString))
using (SqlCommand command = connection.CreateCommand())
{
command.CommandText = "INSERT INTO Ads (Description, Name, PhoneNumber, DateCreated) " +
"VALUES (@desc, @name, @phone, GETDATE()) SELECT SCOPE_IDENTITY()";
command.Parameters.AddWithValue("@desc", ad.Description);
object name = ad.Name;
if (name == null)
{
name = DBNull.Value;
}
command.Parameters.AddWithValue("@name", name);
command.Parameters.AddWithValue("@phone", ad.PhoneNumber);
connection.Open();
ad.Id = (int)(decimal)command.ExecuteScalar();
}
}
