public ActionResult <SupplierDTO> ChangeSupplier(int id, [FromBody] SupplierDTO supplier) { if (supplier == null) { return(BadRequest()); } var existingSupplier = _supplierService.Get(id); if (existingSupplier == null) { return(NoContent()); } var newSupplier = new SupplierDTO { Id = id, Name = supplier.Name, Locality = supplier.Locality }; _supplierService.Update(newSupplier); return(Ok(newSupplier)); }
private SupplierDTO Create(SupplierViewModel viewModel) { try { log.Debug(SupplierViewModel.FormatSupplierViewModel(viewModel)); SupplierDTO supplier = new SupplierDTO(); // copy values viewModel.UpdateDTO(supplier, null); //RequestContext.Principal.Identity.GetUserId()); // audit supplier.CreateBy = null; //RequestContext.Principal.Identity.GetUserId(); supplier.CreateOn = DateTime.UtcNow; // add log.Debug("_supplierService.AddSupplier - " + SupplierDTO.FormatSupplierDTO(supplier)); int id = _supplierService.AddSupplier(supplier); supplier.SupplierId = id; log.Debug("result: 'success', id: " + id); return(supplier); } catch (Exception e) { // error log.Error(e.ToString()); throw; } }
public void UpdateSupplier(SupplierDTO supplierDTO) { Supplier newSupplier = supplierMapper.Map <Supplier>(supplierDTO); Database.Suppliers.Update(newSupplier); Database.Save(); }
public List <SupplierDTO> getListCongNoNCC() { string sql = "SELECT distinct tt.MaNCC, tt.TenNCC, kv.TenKV, cc.DiaChi" + " FROM THONGTIN_PHIEUNHAPHANG tt, KHUVUC kv, NCC cc " + "WHERE tt.MaNCC = cc.MaNCC and cc.MaKV = kv.MaKV"; DataTable data = ConnectionDB.getData(sql); List <SupplierDTO> ListCongNoNCC = new List <SupplierDTO>(); if (data.Rows.Count > 0) { foreach (DataRow dataRow in data.Rows) { SupplierDTO x = new SupplierDTO(); x.TenNCC = dataRow["TenNCC"].ToString(); x.MaNCC = dataRow["MaNCC"].ToString(); x.KhuVuc = dataRow["TenKV"].ToString(); x.DiaChi = dataRow["DiaChi"].ToString(); x.SoDuDauKy = 0; x.ChiTrongKy = getTongCongNoCuaNCC(x.MaNCC, 2); x.PhatSinhTrongKy = (float)getPhatSinhTrongKyNCC(x.MaNCC); x.SoDuCongNo = x.PhatSinhTrongKy - x.ChiTrongKy; ListCongNoNCC.Add(x); } } return(ListCongNoNCC); }
public async Task Update(SupplierDTO dto) { await ValidateSupplier(dto, true); var repoObj = _mapper.Map <Supplier>(dto); await _repository.Update(repoObj); }
private void rdmXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { SupplierDTO supDTO = new SupplierDTO(); GridView gridView = grcNhaCungCap.FocusedView as GridView; string mabp = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaNCC"); // lấy được mã hàng cần update if (mabp == null) { XtraMessageBox.Show("Mời bạn chọn mã nhà cung cấp cần xóa"); } else { int check = supplierBUS.DeleteSupplierFromNCC(mabp); if (check == 1) { AddNhatKy("Xóa"); XtraMessageBox.Show("Delete thành công"); loadSupplier(); } else { XtraMessageBox.Show("Delete thất bại"); } } }
// PUT api/suppliers/id public IHttpActionResult PutSupllier(int id, [FromBody] SupplierModelView supplier) { var supOld = supplierService.GetById(id); if (supOld == null) { return(NotFound()); } if (supplier == null) { return(BadRequest()); } var newSup = new SupplierDTO { Id = id, CompanyName = supplier.CompanyName, Products = mapper.Map <ICollection <ProductModelView>, ICollection <ProductDTO> >(supplier.Products) }; supplierService.Update(newSup); return(Ok(new { Message = $"A supplier {supplier.CompanyName} has updated" })); }
public void CreateSupplier(SupplierDTO supplier) { var supplierEntity = _mapper.Map <Supplier>(supplier); _database.Suppliers.Add(supplierEntity); _database.Save(); }
public ActionResult Edit() { SupplierDTO supplierDTO = new SupplierDTO(); supplierDTO.RegisterDate = new DateTime(2020, 4, 11); return(View(supplierDTO)); }
public IHttpActionResult Delete(SupplierDTO objDTO) { _httpStatusCode = HttpStatusCode.BadRequest; _response = Content(_httpStatusCode, new ResponsePackage(_httpStatusCode)); if (!objDTO.IsValidate(Request, ref _response)) { return(_response); } try { var obj = AutoMapper.Mapper.Map <Supplier>(objDTO); var result = _unitOfWork.SupplierRepository.Delete(obj); _httpStatusCode = HttpStatusCode.OK; var output = GenerateOutput(_httpStatusCode, result); _response = Content(_httpStatusCode, output); } catch (Exception ex) { if (_log != null) { _log.Error("Error:", ex); } } return(_response); }
//DELETE api/issues/id public void Delete(SupplierDTO supplier) { //Need to have error handling! var supplierToDelete = supplierRepo.GetById(supplier.SupplierID); supplierRepo.Delete(supplierToDelete); }
private ExtSupplierDTO SupplierRecordAdded(SupplierDTO newRecord, Object additionalData) { SuppliersMergeParameter mergeParam = additionalData as SuppliersMergeParameter; ExtSupplierDTO supplierDetail = newRecord.Clone() as ExtSupplierDTO; supplierDetail.LastUpdateTime = AdjustClientUtcTimeToServerTime(newRecord.LastUpdateTime, mergeParam.ClientServerTimeDifference); supplierDetail.SystemUserID = mergeParam.SystemUserID; try { mergeParam.DataAccessObject.AddSupplier(supplierDetail); } catch (SqlException ex) { switch (ex.Number) { // Duplicate record found. case 2627: break; default: // Re-throw the exception if we don't recognise the error code. throw; } } return(supplierDetail); }
// PUT: api/Suppliers/5 public async Task <HttpResponseMessage> EditSupplier(int id, SupplierDTO supplier) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != supplier.Id || id == 0) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request")); } try { int result = await _supplierService.SaveSupplier(supplier); if (result == -1) { return(Request.CreateErrorResponse(HttpStatusCode.ExpectationFailed, "Not Saved.")); } if (result == 0) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found")); } return(Request.CreateResponse(HttpStatusCode.OK, supplier)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
// POST: api/Suppliers public async Task <HttpResponseMessage> PostSupplier(SupplierDTO supplier) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } try { if (supplier.Id != 0) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Bad Request")); } int newId = await _supplierService.SaveSupplier(supplier); if (newId == -1) { return(Request.CreateErrorResponse(HttpStatusCode.ExpectationFailed, "Not Saved.")); } supplier.Id = newId; var message = Request.CreateResponse(HttpStatusCode.Created, supplier); message.Headers.Location = new Uri(Request.RequestUri + supplier.Id.ToString()); return(message); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public SupplierRateDTO AddSupplierRate(int supplierId, decimal rate, DateTime startDate, DateTime?endDate) { if (endDate.HasValue && startDate >= endDate.Value) { throw new ValidationException("The end date must be greater than start date"); } SupplierDTO supplier = Get(supplierId); if (supplier == null) { throw new NotFoundException($"The supplier of id {supplierId} does not exists"); } ValidateOverLapping(startDate, endDate, supplier.SupplierRates); var supplierRate = new SupplierRateDTO { Rate = rate, StartDate = startDate, EndDate = endDate }; return(_supplierDao.SaveSupplierRate(supplier.SupplierId, supplierRate)); }
public async Task <IHttpActionResult> Post(SupplierDTO supplierDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var supplier = new Supplier() { SupplierId = Guid.NewGuid(), Address = supplierDTO.Address, GSTIN = supplierDTO.GSTIN, MobileNo = supplierDTO.MobileNo, Name = supplierDTO.Name, WalletBalance = 0, }; db.Suppliers.Add(supplier); try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (SupplierExists(supplier.SupplierId)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = supplier.SupplierId }, supplier)); }
public List <SupplierDTO> getListNCCMuaHang(int check, DateTime a, DateTime b) { string sql; if (check == 0) { sql = "SELECT distinct kv.TenKV, tt.MaNCC, tt.TenNCC " + "FROM THONGTIN_PHIEUNHAPHANG tt, NCC cc, KHUVUC kv WHERE tt.MaNCC = cc.MaNCC and cc.MaKV = kv.MaKV"; } else { sql = string.Format("SELECT distinct kv.TenKV, tt.MaNCC, tt.TenNCC " + "FROM THONGTIN_PHIEUNHAPHANG tt, NCC cc, KHUVUC kv WHERE tt.MaNCC = cc.MaNCC and cc.MaKV = kv.MaKV and tt.NgayLap between '{0}' and '{1}' ", a, b); } DataTable data = ConnectionDB.getData(sql); List <SupplierDTO> ListNCCMuaHang = new List <SupplierDTO>(); foreach (DataRow dataRow in data.Rows) { SupplierDTO x = new SupplierDTO(); x.MaNCC = dataRow["MaNCC"].ToString(); x.TenNCC = dataRow["TenNCC"].ToString(); x.KhuVuc = dataRow["TenKV"].ToString(); x.TongChiPhi = getSumTienFromNCC(x.MaNCC); ListNCCMuaHang.Add(x); } return(ListNCCMuaHang); }
private void btnSave_Click(object sender, EventArgs e) { SupplierDTO supDTO = new SupplierDTO(); supDTO.MaNCC = txtMa.Text; supDTO.TenNCC = txtTen.Text; supDTO.NguoiLienHe = txtNLH.Text; supDTO.MaKV = cbKhuVuc.EditValue != null?cbKhuVuc.EditValue.ToString() : null; supDTO.Fax = txtFax.Text; supDTO.DienThoai = txtDT.Text; supDTO.DiDong = txtDiDong.Text; supDTO.DiaChi = txtDiaChi.Text; supDTO.Active = bool.Parse(checkAc.Checked.ToString()); supDTO.ChucVu = txtChucVu.Text; int check = supBus.UpdateSup(supDTO); if (check == 1) { XtraMessageBox.Show("Update thành công"); this.Close(); } else { XtraMessageBox.Show("Update thất bại"); } }
public SupplierDTO Read(string id) { SupplierDTO supplierToReturn = null; using (sqlConnection = DataBaseConnectionFactory.Connection()) { int num; sqlConnection.Open(); using (SqlCommand sqlCommand = sqlConnection.CreateCommand()) { string readQuery = string.Format(@"SELECT * FROM Suppliers WHERE [RegionID] = {0}", id); sqlCommand.CommandText = readQuery; sqlCommand.CommandType = CommandType.Text; SqlDataReader reader = sqlCommand.ExecuteReader(); if (reader.HasRows) { reader.Read(); Int32.TryParse(reader["SupplierID"].ToString(), out num); supplierToReturn = new SupplierDTO() { SupplierId = num, CompanyName = reader["CompanyName"].ToString(), ContactName = reader["ContactName"].ToString() }; } } sqlConnection.Close(); } return(supplierToReturn); }
public SupplierDTO createSupplier(SupplierDTO supplierDTO) { try { Db.Ado.BeginTran(); SUPPLIER supplier = new SUPPLIER(); supplier.NAME = supplierDTO._name; supplier.PHONE = supplierDTO._phone; supplier.CREDIT_LEVEL = supplierDTO._credit_level; Db.Insertable(supplier).IgnoreColumns(it => new { it.SUPPLIER_ID }).ExecuteCommand(); var cid = Db.Ado.SqlQuery <int>("select ISEQ$$_75582.currval from dual"); var id = cid[0]; Db.Ado.CommitTran(); supplierDTO._supplier_id = id; return(supplierDTO); } catch (Exception e) { Db.Ado.RollbackTran(); return(null); } }
public SupplierDTO Update(SupplierDTO updatedRecord) { try { string query = @" UPDATE Suppliers SET SupplierCode = @SupplierCode, SupplierName = @SupplierName, SupplierContactNumber = @SupplierContactNumber, SupplierEmailAddress = @SupplierEmailAddress WHERE SupplierID = @SupplierID"; var queryParameters = new DynamicParameters(); queryParameters.Add("@SupplierCode", updatedRecord.SupplierCode); queryParameters.Add("@SupplierName", updatedRecord.SupplierName); queryParameters.Add("@SupplierContactNumber", updatedRecord.SupplierContactNumber); queryParameters.Add("@SupplierEmailAddress", updatedRecord.SupplierEmailAddress); queryParameters.Add("@SupplierID", updatedRecord.SupplierID); int rowsUpdated = Connection.Execute(query, queryParameters, CurrentTrans); return((rowsUpdated > 0) ? GetByID(updatedRecord.SupplierID) : throw noRecordEX); } catch (Exception ex) { throw SqlExceptionHandler.HandleSqlException(ex) ?? ex; } }
public ResultAction Put(SupplierDTO supplier) { ResultAction result = new ResultAction(); int row = 0; using (var scope = new TransactionScope()) { if (supplier.Id != null) { row = new SupplierService().Put(supplier); if (row > 0) { result.IsOk = true; result.Result = row; } else { result.Message = "Erro ao atualizar o fornecedor."; } } else { result.Message = "Fornecedor não encontrado."; } scope.Complete(); scope.Dispose(); } return(result); }
public SupplierDTO GetSupplier(int supplierId) { try { //Requires.NotNegative("supplierId", supplierId); log.Debug("supplierId: " + supplierId + " "); // get R_Supplier t = Repository.GetSupplier(supplierId); SupplierDTO dto = new SupplierDTO(t); log.Debug(SupplierDTO.FormatSupplierDTO(dto)); return(dto); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } }
internal ResultAction Post(SupplierDTO supplier) { ResultAction result = new ResultAction(); using (var scope = new TransactionScope()) { Supplier newSupplier = new Supplier(); newSupplier.CpfCnpj = supplier.CpfCnpj; newSupplier.Email = supplier.Email; newSupplier.Name = supplier.Name; newSupplier.PhoneNumber = supplier.PhoneNumber; int row = new SupplierService().Post(newSupplier); if (row > 0) { result.IsOk = true; result.Result = row; result.Message = "Fornecedor salvo com sucesso."; } else { result.Message = "Erro ao cadastrar um novo fornecedor."; } scope.Complete(); scope.Dispose(); } return(result); }
public override Task <SupplierDTO> CreateSupplier(SupplierDTO request, ServerCallContext context) { _supplierDao.Insert(_mapper.Map <Supplier>(request)); var supplier = _supplierDao.Get(request.Id); return(Task.FromResult(_mapper.Map <SupplierDTO>(supplier))); }
public int AddSupplier(SupplierDTO dto) { int id = 0; try { log.Debug(SupplierDTO.FormatSupplierDTO(dto)); R_Supplier t = SupplierDTO.ConvertDTOtoEntity(dto); // add id = Repository.AddSupplier(t); dto.SupplierId = id; log.Debug("result: 'success', id: " + id); } catch (System.Exception e) { // error log.Error(e.ToString()); throw; } return(id); }
public void GetSuppliersPaged_Success_Test() { // Arrange string searchTerm = ""; int pageIndex = 0; int pageSize = 10; // list IList <R_Supplier> list = new List <R_Supplier>(); for (int i = 1; i <= pageSize; i++) { list.Add(SampleSupplier(i)); } // create mock for repository var mock = new Mock <ISupplierRepository>(); mock.Setup(s => s.GetSuppliers(Moq.It.IsAny <string>(), Moq.It.IsAny <int>(), Moq.It.IsAny <int>())).Returns(list); // service SupplierService supplierService = new SupplierService(); SupplierService.Repository = mock.Object; // Act var resultList = supplierService.GetSuppliers(searchTerm, pageIndex, pageSize); SupplierDTO result = resultList.FirstOrDefault(); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.SupplierId); Assert.AreEqual(10, resultList.Count); }
public void GetSuppliers_Success_Test() { // Arrange R_Supplier supplier = SampleSupplier(1); IList <R_Supplier> list = new List <R_Supplier>(); list.Add(supplier); // create mock for repository var mock = new Mock <ISupplierRepository>(); mock.Setup(s => s.GetSuppliers()).Returns(list); // service SupplierService supplierService = new SupplierService(); SupplierService.Repository = mock.Object; // Act var resultList = supplierService.GetSuppliers(); SupplierDTO result = resultList.FirstOrDefault(); // Assert Assert.IsNotNull(result); Assert.AreEqual(1, result.SupplierId); }
public ActionResult Post(SupplierDTO supplier) { _supplier.CreateSupplier(supplier); var uri = Path.Combine(Request.Path.ToString(), Uri.EscapeUriString(supplier.Name)); return(Created(uri, supplier)); }
public async Task RemoveSupplierAsync(SupplierDTO supplierDTO) { var supplierToDelete = mapper.Map <SupplierDTO, Supplier>(supplierDTO); unitOfWork.Suppliers.Remove(supplierToDelete); await unitOfWork.CompleteAsync(); }
public static SupplierDTO CreateSupplierDTO(int supplierId, bool isValid, int suppierCompanyId, bool aircraftLeaseSupplier, bool aircraftPurchaseSupplier, bool engineLeaseSupplier, bool enginePurchaseSupplier, bool bFEPurchaseSupplier, bool maintainSupplier, bool otherSupplier, global::System.Collections.ObjectModel.ObservableCollection<BankAccountDTO> bankAccounts) { SupplierDTO supplierDTO = new SupplierDTO(); supplierDTO.SupplierId = supplierId; supplierDTO.IsValid = isValid; supplierDTO.SuppierCompanyId = suppierCompanyId; supplierDTO.AircraftLeaseSupplier = aircraftLeaseSupplier; supplierDTO.AircraftPurchaseSupplier = aircraftPurchaseSupplier; supplierDTO.EngineLeaseSupplier = engineLeaseSupplier; supplierDTO.EnginePurchaseSupplier = enginePurchaseSupplier; supplierDTO.BFEPurchaseSupplier = bFEPurchaseSupplier; supplierDTO.MaintainSupplier = maintainSupplier; supplierDTO.OtherSupplier = otherSupplier; if ((bankAccounts == null)) { throw new global::System.ArgumentNullException("bankAccounts"); } supplierDTO.BankAccounts = bankAccounts; return supplierDTO; }
public Supplier Map(SupplierDTO dto) { if (dto == null) return null; var supplier = Mapper.Map<SupplierDTO, Supplier>(dto); return supplier; }
public static SupplierDTO CreateSupplierDTO(int ID, int supplierType, bool isValid) { SupplierDTO supplierDTO = new SupplierDTO(); supplierDTO.Id = ID; supplierDTO.SupplierType = supplierType; supplierDTO.IsValid = isValid; return supplierDTO; }
public void AddToSuppliers(SupplierDTO supplierDTO) { base.AddObject("Suppliers", supplierDTO); }