Exemple #1
0
        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));
        }
Exemple #2
0
        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");
                }
            }
        }
Exemple #7
0
        // 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" }));
        }
Exemple #8
0
        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);
        }
Exemple #11
0
        //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);
        }
Exemple #13
0
        // 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));
            }
        }
Exemple #14
0
        // 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));
        }
Exemple #16
0
        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));
        }
Exemple #17
0
        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);
        }
Exemple #18
0
        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");
            }
        }
Exemple #19
0
        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);
        }
Exemple #20
0
        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);
            }
        }
Exemple #21
0
        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;
            }
        }
Exemple #22
0
        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);
        }
Exemple #23
0
        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;
            }
        }
Exemple #24
0
        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);
        }
Exemple #25
0
        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)));
        }
Exemple #26
0
        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);
        }
Exemple #27
0
        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);
        }
Exemple #28
0
        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));
        }
Exemple #30
0
        public async Task RemoveSupplierAsync(SupplierDTO supplierDTO)
        {
            var supplierToDelete = mapper.Map <SupplierDTO, Supplier>(supplierDTO);

            unitOfWork.Suppliers.Remove(supplierToDelete);

            await unitOfWork.CompleteAsync();
        }
Exemple #31
0
 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;
 }
Exemple #33
0
 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;
 }
Exemple #34
0
 public void AddToSuppliers(SupplierDTO supplierDTO)
 {
     base.AddObject("Suppliers", supplierDTO);
 }