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