protected override void DataPortal_Update()
{
var dto = new SupplierEditDto();
dto.SupplierId = SupplierId;
dto.Name = Name;
dto.AddressLine1 = AddressLine1;
dto.AddressLine2 = AddressLine2;
dto.ZipCode = ZipCode;
dto.State = State;
dto.Country = Country;
using (var dalManager = DalFactoryInvoices.GetManager())
{
var args = new DataPortalHookArgs(dto);
OnUpdatePre(args);
var dal = dalManager.GetProvider <ISupplierEditDal>();
using (BypassPropertyChecks)
{
var resultDto = dal.Update(dto);
args = new DataPortalHookArgs(resultDto);
}
OnUpdatePost(args);
// flushes all pending data operations
FieldManager.UpdateChildren(this);
}
}
/// <summary>
/// Loads a <see cref="SupplierEdit"/> object from the given <see cref="SupplierEditDto"/>.
/// </summary>
/// <param name="data">The SupplierEditDto to use.</param>
private void Fetch(SupplierEditDto data)
{
// Value properties
LoadProperty(SupplierIdProperty, data.SupplierId);
LoadProperty(NameProperty, data.Name);
LoadProperty(AddressLine1Property, data.AddressLine1);
LoadProperty(AddressLine2Property, data.AddressLine2);
LoadProperty(ZipCodeProperty, data.ZipCode);
LoadProperty(StateProperty, data.State);
LoadProperty(CountryProperty, data.Country);
var args = new DataPortalHookArgs(data);
OnFetchRead(args);
}
/// <summary>
/// Inserts a new SupplierEdit object in the database.
/// </summary>
/// <param name="supplierEdit">The Supplier Edit DTO.</param>
/// <returns>The new <see cref="SupplierEditDto"/>.</returns>
public SupplierEditDto Insert(SupplierEditDto supplierEdit)
{
using (var ctx = ConnectionManager <SQLiteConnection> .GetManager("Invoices"))
{
using (var cmd = new SQLiteCommand("dbo.AddSupplierEdit", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SupplierId", supplierEdit.SupplierId).DbType = DbType.Int32;
cmd.Parameters.AddWithValue("@Name", supplierEdit.Name).DbType = DbType.String;
cmd.Parameters.AddWithValue("@AddressLine1", supplierEdit.AddressLine1 == null ? (object)DBNull.Value : supplierEdit.AddressLine1).DbType = DbType.String;
cmd.Parameters.AddWithValue("@AddressLine2", supplierEdit.AddressLine2 == null ? (object)DBNull.Value : supplierEdit.AddressLine2).DbType = DbType.String;
cmd.Parameters.AddWithValue("@ZipCode", supplierEdit.ZipCode == null ? (object)DBNull.Value : supplierEdit.ZipCode).DbType = DbType.String;
cmd.Parameters.AddWithValue("@State", supplierEdit.State == null ? (object)DBNull.Value : supplierEdit.State).DbType = DbType.String;
cmd.Parameters.AddWithValue("@Country", supplierEdit.Country == null ? (object)DBNull.Value : supplierEdit.Country.Value).DbType = DbType.Byte;
cmd.ExecuteNonQuery();
}
}
return(supplierEdit);
}
private SupplierEditDto Fetch(IDataReader data)
{
var supplierEdit = new SupplierEditDto();
using (var dr = new SafeDataReader(data))
{
if (dr.Read())
{
supplierEdit.SupplierId = dr.GetInt32("SupplierId");
supplierEdit.Name = dr.GetString("Name");
supplierEdit.AddressLine1 = dr.IsDBNull("AddressLine1") ? null : dr.GetString("AddressLine1");
supplierEdit.AddressLine2 = dr.IsDBNull("AddressLine2") ? null : dr.GetString("AddressLine2");
supplierEdit.ZipCode = dr.IsDBNull("ZipCode") ? null : dr.GetString("ZipCode");
supplierEdit.State = dr.IsDBNull("State") ? null : dr.GetString("State");
supplierEdit.Country = (byte?)dr.GetValue("Country");
}
}
return(supplierEdit);
}
public async Task <GetSupplierForEditOutput> GetSupplierForEdit(NullableIdInput <long> input)
{
SupplierEditDto supplierEditDto;
if (!input.Id.HasValue)
{
supplierEditDto = new SupplierEditDto();
}
else
{
IRepository <Supplier, long> repository = this._supplierRepository;
Supplier async = await repository.GetAsync(input.Id.Value);
supplierEditDto = async.MapTo <SupplierEditDto>();
}
return(new GetSupplierForEditOutput()
{
Supplier = supplierEditDto
});
}
public async Task <GetSupplierForEditOutput> GetSupplierForEdit(NullableIdInput input)
{
SupplierEditDto editDto;
if (input.Id.HasValue)
{
var hDto = await _supplierRepo.GetAsync(input.Id.Value);
editDto = hDto.MapTo <SupplierEditDto>();
}
else
{
editDto = new SupplierEditDto();
}
return(new GetSupplierForEditOutput
{
Supplier = editDto
});
}
/// <summary>
/// Updates in the database all changes made to the SupplierEdit object.
/// </summary>
/// <param name="supplierEdit">The Supplier Edit DTO.</param>
/// <returns>The updated <see cref="SupplierEditDto"/>.</returns>
public SupplierEditDto Update(SupplierEditDto supplierEdit)
{
using (var ctx = ConnectionManager <MySqlConnection> .GetManager("Invoices"))
{
using (var cmd = new MySqlCommand("dbo.UpdateSupplierEdit", ctx.Connection))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SupplierId", supplierEdit.SupplierId).DbType = DbType.Int32;
cmd.Parameters.AddWithValue("@Name", supplierEdit.Name).DbType = DbType.String;
cmd.Parameters.AddWithValue("@AddressLine1", supplierEdit.AddressLine1 == null ? (object)DBNull.Value : supplierEdit.AddressLine1).DbType = DbType.String;
cmd.Parameters.AddWithValue("@AddressLine2", supplierEdit.AddressLine2 == null ? (object)DBNull.Value : supplierEdit.AddressLine2).DbType = DbType.String;
cmd.Parameters.AddWithValue("@ZipCode", supplierEdit.ZipCode == null ? (object)DBNull.Value : supplierEdit.ZipCode).DbType = DbType.String;
cmd.Parameters.AddWithValue("@State", supplierEdit.State == null ? (object)DBNull.Value : supplierEdit.State).DbType = DbType.String;
cmd.Parameters.AddWithValue("@Country", supplierEdit.Country == null ? (object)DBNull.Value : supplierEdit.Country.Value).DbType = DbType.Byte;
var rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected == 0)
{
throw new DataNotFoundException("SupplierEdit");
}
}
}
return(supplierEdit);
}
public async Task <IHttpActionResult> PutSupplier(long id, SupplierEditDto supplierDto)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != supplierDto.Id)
{
return(BadRequest());
}
try
{
supplierDto.Id = id;
Supplier supplier = await _supplierService.GetByIdAsync(id);
Mapper.Map(supplierDto, supplier);
await _supplierService.UpdateAsync(supplier);
return(Ok(supplierDto));
}
catch (DbUpdateConcurrencyException)
{
if (!SupplierExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
}
public CreateOrEditSupplierViewModel(SupplierEditDto output)
{
output.MapTo(this);
}
public SupplierDto Edit(SupplierEditDto supplierEditDto)
{
return(new SupplierDto(_supplierUseCase.Edit(supplierEditDto)));
}
public ActionResult <SupplierDto> PutSupplier(int id, SupplierEditDto supplierEditDto)
{
return(new ActionResult <SupplierDto>(_supplierService.Edit(supplierEditDto)));
}
protected async Task UpdateSupplierAsync(SupplierEditDto input)
{
Supplier entity = await _supplierRepository.GetAsync(input.Id.Value);
await _supplierRepository.UpdateAsync(input.MapTo(entity));
}
protected async Task CreateSupplierAsync(SupplierEditDto input)
{
await _supplierRepository.InsertAsync(input.MapTo <Supplier>());
}
private async Task CreateSupplierAsync(SupplierEditDto input)
{
var supplier = input.MapTo <Supplier>();
await _supplierRepository.InsertAsync(supplier);
}
