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