public void Add(Color obj)
{
using (SqlConnection con = new SqlConnection(db.ConnectionString))
{
string query = null;
con.Open();
if (obj.ID == 0)
{
query = "Insert into Colors values(@Name)";
}
else
{
query = "Update Colors set Name= @Name where ID = @ID";
}
using (SqlCommand cmd = new SqlCommand(query, con))
{
if (obj.ID != 0)
{
cmd.Parameters.AddWithValue("@ID", obj.ID);
}
cmd.Parameters.AddWithValue("@Name", obj.Name);
db.AddCommandToTransaction(cmd);
}
}
}
public void Add(Advertisement obj)
{
using (SqlConnection con = new SqlConnection(db.ConnectionString))
{
string query = null;
con.Open();
if (obj.ID == 0)
{
query = @"Insert into Advertisements
values(@CreationDate,@RefreshDate,@CityID,@CarID,@VIP,@PhotoDirectory)";
}
else
{
query = @"update Advertisements set CreationDate =@CreationDate,RefreshDate = @RefreshDate,CityID = @CityID,CarID = @CarID,VIP = @VIP
where ID = @ID";
}
using (SqlCommand cmd = new SqlCommand(query, con))
{
if (obj.ID != 0)
{
cmd.Parameters.AddWithValue("@ID", obj.ID);
}
cmd.Parameters.AddWithValue("@CreationDate", obj.CreationDate);
cmd.Parameters.AddWithValue("@RefreshDate", obj.RefreshDate ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@CityID", obj.City.ID);
cmd.Parameters.AddWithValue("@CarID", obj.Car.ID);
cmd.Parameters.AddWithValue("@VIP", obj.VIP);
cmd.Parameters.AddWithValue("@PhotoDirectory", obj.PhotoDirectory ?? (object)DBNull.Value);
db.AddCommandToTransaction(cmd);
}
}
}
public void CreateOrEditUser(User obj)
{
using (SqlConnection con = new SqlConnection(db.ConnectionString))
{
string query = null;
con.Open();
if (obj.ID == 0)
{
query = @"insert into Users values(@Id,@RoleID,@UserName,@NormalizedUserName,@Email,@EmailConfirmed,@Password,@PasswordHash,@PhoneNumber,
@PhoneNumberConfirmed,@TwoFactorEnabled)";
}
else
{
query = @"Update Users set UserName = @UserName,NormalizedUserName= @NormalizedUserName,Email= @Email,EmailConfirmed=@EmailConfirmed,
Password = @Password,PasswordHash = @PasswordHash,PhoneNumber= @PhoneNumber,@PhoneNumberConfirmed = PhoneNumberConfirmed,TwoFactorEnabled = @TwoFactorEnabled where Id = @Id";
}
using (SqlCommand cmd = new SqlCommand(query, con))
{
if (obj.ID != 0)
{
cmd.Parameters.AddWithValue("Id", obj.ID);
}
cmd.Parameters.AddWithValue("@UserName", obj.UserName);
cmd.Parameters.AddWithValue("@NormalizedUserName", obj.NormalizedUserName);
cmd.Parameters.AddWithValue("@Email", obj.Email ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@EmailConfirmed", obj.EmailConfirmed);
cmd.Parameters.AddWithValue("@Password", obj.Password ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("PasswordHash", obj.PasswordHash ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@PhoneNUmber", obj.PhoneNumber ?? (object)DBNull.Value);
cmd.Parameters.AddWithValue("@PhoneNumberConfirmed", obj.PhoneNumberConfirmed);
cmd.Parameters.AddWithValue("@TwoFactorEnabled", obj.TwoFactorEnabled);
db.AddCommandToTransaction(cmd);
}
}
}
public void Add(Role obj)
{
using (SqlConnection con = new SqlConnection(db.ConnectionString))
{
string query = null;
con.Open();
if (obj.ID == 0)
{
query = "Insert into Roles values(@Name,@NormalizedName)";
}
else
{
query = "update Roles set Name = @Name,NormalizedName = @NormalizedName where Id = @Id";
}
using (SqlCommand cmd = new SqlCommand(query, con))
{
if (obj.ID != 0)
{
cmd.Parameters.AddWithValue("@Id", obj.ID);
}
cmd.Parameters.AddWithValue("@Name", obj.Name);
cmd.Parameters.AddWithValue("@NormalizedName", obj.NormalizedName);
db.AddCommandToTransaction(cmd);
}
}
}
