public string Validate(WarehouseDTO warehouse) { if (null == warehouse) { return(GenericMessages.ObjectIsNull); } if (warehouse.Address == null) { return("Address " + GenericMessages.ObjectIsNull); } if (warehouse.OrganizationId == 0 || new OrganizationService(true).Find(warehouse.OrganizationId.ToString()) == null) { return("Organization is null/disabled "); } if (String.IsNullOrEmpty(warehouse.DisplayName)) { return(warehouse.DisplayName + " " + GenericMessages.StringIsNullOrEmpty); } if (warehouse.DisplayName.Length > 255) { return(warehouse.DisplayName + " can not be more than 255 characters "); } return(string.Empty); }
public async Task <bool> SaveAsync(WarehouseDTO warehouseDomain, long userId, long orgId) { // Warehouse warehouse = new Warehouse(); // if (warehouse.Id == 0) // { // warehouse.WarehouseName = warehouseDomain.WarehouseName; // warehouse.Remarks = warehouseDomain.Remarks; // warehouse.IsActive = warehouseDomain.IsActive; // warehouse.EUserId = userId; // warehouse.EntryDate = DateTime.Now; // warehouseRepository.Insert(warehouse); // } // else // { // warehouse.Remarks = warehouseDomain.Remarks; // warehouse.IsActive = warehouseDomain.IsActive; // warehouse.UpUserId = userId; // warehouse.UpdateDate = DateTime.Now; // warehouseRepository.Update(warehouse); // } // return await warehouseRepository.SaveAsync(); //} return(await _inventoryDb.Db.SaveChangesAsync() > 0); }
public void Get_warehouse_hierarchy_should_return_warehouse() { var warehouses = new List <WarehouseDTO>(); var root = new WarehouseDTO() { Code = "ROOT", Description = "Root WH", Duration = 0.5m, Parent = null }; warehouses.Add(root); var truck = new TruckDTO() { Code = "TMOC", Parent = null, Duration = 0.5m, Latitude = 14, Longitude = 40, NumberPlate = "MOCKTRK-1", Radius = 10m }; var trucks = new List <TruckDTO>(); trucks.Add(truck); warehouseRepMock.Setup(input => input.FindByParent(null)).Returns(warehouses); truckRepMock.Setup(input => input.FindByParent(It.IsAny <WarehouseDTO>())).Returns(trucks); // Act var result = warehouse.GetWarehouseHierarchy(); // Assert Assert.IsInstanceOfType(result, typeof(WarehouseModel)); }
public bool SaveWarehouse(WarehouseDTO warehouseDTO, long userId, long orgId) { Warehouse warehouse = new Warehouse(); if (warehouseDTO.Id == 0) { warehouse.WarehouseName = warehouseDTO.WarehouseName; warehouse.Remarks = warehouseDTO.Remarks; warehouse.IsActive = warehouseDTO.IsActive; warehouse.EUserId = userId; warehouse.EntryDate = DateTime.Now; warehouse.OrganizationId = orgId; warehouseRepository.Insert(warehouse); } else { warehouse = GetWarehouseOneByOrgId(warehouseDTO.Id, orgId); warehouse.Remarks = warehouseDTO.Remarks; warehouse.IsActive = warehouseDTO.IsActive; warehouse.UpUserId = userId; warehouse.UpdateDate = DateTime.Now; warehouseRepository.Update(warehouse); } return(warehouseRepository.Save()); }
public async Task MakeWarehouse(WarehouseDTO warehouseDTO) { var mapper = new Mapper(config); unit.Warehouses.Create(mapper.Map <WarehouseDTO, Warehouse>(warehouseDTO)); unit.Save(); }
private void updateWarehouse() { GridView gridView = grcWarehouse.FocusedView as GridView; // WarehouseDTO warehouse = new WarehouseDTO(); warehouse.iMaKho = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iMaKho"); warehouse.iTenKho = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iTenKho"); warehouse.iLienHe = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iGhiChu"); warehouse.iDiaChi = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iDiaChi"); warehouse.iDienThoai = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iDienThoai"); warehouse.iKyHieu = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iKyHieu"); warehouse.iGhiChu = (string)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iGhiChu"); warehouse.iActive = (bool)gridView.GetRowCellValue(gridView.FocusedRowHandle, "iActive"); frmUpdateWarehouse fUpdateWarehouse = new frmUpdateWarehouse(warehouse); fUpdateWarehouse.ShowDialog(); if (statusAction == 1) { loadWarehouse(); statusAction = 0; } else { } }
public int RegisterProductAtWarehouse(WarehouseDTO warehouseDto) { using var connection = new SqlConnection(_configuration.GetConnectionString("PjatkDb")); var command = new SqlCommand { Connection = connection, CommandText = "AddProductToWarehouse", CommandType = CommandType.StoredProcedure }; command.Parameters.AddWithValue("@IdProduct", warehouseDto.IdProduct); command.Parameters.AddWithValue("@IdWarehouse", warehouseDto.IdWarehouse); command.Parameters.AddWithValue("@Amount", warehouseDto.Amount); command.Parameters.AddWithValue("@CreatedAt", warehouseDto.CreatedAt); connection.Open(); command.ExecuteNonQuery(); command.CommandText = "SELECT MAX(IdProductWarehouse) AS maxId FROM Product_Warehouse"; command.CommandType = CommandType.Text; var sqlDataReader = command.ExecuteReader(); sqlDataReader.Read(); int addedId = Convert.ToInt32(sqlDataReader["maxId"].ToString()); connection.Close(); return(addedId); }
public AddPayment(BusinessPartnerDTO customerDTO, WarehouseDTO warehouseDTO) { AddPaymentViewModel.Errors = 0; InitializeComponent(); Messenger.Default.Send <WarehouseDTO>(warehouseDTO); Messenger.Default.Send <BusinessPartnerDTO>(customerDTO); }
public void Create(WarehouseDTO w) { w.Id = _autoinc++; _warehouses.Add(w); foreach (var tr in w.Trucks) { _truckRepo.Create(tr); } }
public ObservableCollection <WarehouseDTO> GetWarehouses(string CityName) { ObservableCollection <WarehouseDTO> warehouses = new ObservableCollection <WarehouseDTO>(); try { var httpWebRequest = (HttpWebRequest)WebRequest.Create("https://api.novaposhta.ua/v2.0/json/"); httpWebRequest.ContentType = "application/json"; httpWebRequest.Method = "POST"; using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream())) { string json = "{\"modelName\": \"AddressGeneral\"," + "\"calledMethod\": \"getWarehouses\"," + "\"methodProperties\": {" + $"\"CityName\":\"{CityName}\"" + "}," + "\"apiKey\": \"" + $"{config.ApiKeyNP}" + "\"" + "}"; streamWriter.Write(json); } var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse(); using (var streamReader = new StreamReader(httpResponse.GetResponseStream())) { var str = streamReader.ReadToEnd(); JObject search = JObject.Parse(str); IList <JToken> results = search["data"].Children().ToList(); foreach (JToken result in results) { WarehouseDTO warehouse = new WarehouseDTO(); string description = result["Description"].ToString(); warehouse.Description = description; string warehouseRef = result["Ref"].ToString(); warehouse.WarehouseRef = warehouseRef; int number = Convert.ToInt32(result["Number"].ToString()); warehouse.Number = number; string cityRef = result["CityRef"].ToString(); warehouse.CityRef = cityRef; string cityDescription = result["CityDescription"].ToString(); warehouse.CityDescription = cityDescription; warehouses.Add(warehouse); } } } catch (Exception ex) { } return(warehouses); }
private void LoadReferences(IDbConnection db, WarehouseDTO entity) { const string productQuery = "SELECT p.* FROM Products as p INNER JOIN ProductWarehouses as ps ON p.Id = ps.ProductId WHERE ps.WarehouseId = @Id"; entity.Products = mapper.Map <List <ProductDTO> >(db.Query <Product>(productQuery, entity)); const string requestDeliveriesQuery = "SELECT * FROM RequestDeliverys WHERE WarehouseId = @Id"; entity.RequestDeliveries = mapper.Map <List <RequestDeliveryDTO> >(db.Query <RequestDelivery>(requestDeliveriesQuery, entity)); }
public ActionResult <WarehouseDTO> GetWarehouse(int id) { WarehouseDTO item = repository.Get(id); if (item == null) { return(NotFound()); } return(item); }
public void Update(WarehouseDTO stock) { var mapper = new MapperConfiguration( configration => configration. CreateMap <WarehouseDTO, Warehouse>()). CreateMapper(); Database.Warehouses.Update(mapper.Map <WarehouseDTO, Warehouse>(stock)); Database.Save(); }
private void ExecuteAddNewWarehouseViewCommand() { SelectedWarehouse = new WarehouseDTO { Address = new AddressDTO { Country = "ኢትዮጲያ", City = "አዲስ አበባ" } }; }
public bool ImportWarehouse(WarehouseDTO a) { if (WarehouseDAO.Instance.insert(a) == true && ProductDAO.Instance.update_soluong(a.Masp, a.So_luong) == true) { return(true); } else { return(false); } }
public frmUpdateWarehouse(WarehouseDTO w) : this() { warehouse.iMaKho = w.iMaKho; warehouse.iTenKho = w.iTenKho; warehouse.iLienHe = w.iLienHe; warehouse.iDiaChi = w.iDiaChi; warehouse.iDienThoai = w.iDienThoai; warehouse.iKyHieu = w.iKyHieu; warehouse.iGhiChu = w.iGhiChu; warehouse.iActive = w.iActive; }
public List <WarehouseDTO> FindByParent(WarehouseDTO parent) { try { return(_dbContext.Warehouses.Where(w => w.Parent.Code == parent.Code).ToList()); } catch (Exception ex) { throw new DalException("DAL error finding warehouse by parent", ex); } }
private void ExecuteAddNewWarehouseViewCommand() { SelectedWarehouse = new WarehouseDTO { Address = new AddressDTO { Country = "Ethiopia", City = "Addis Abeba" } }; }
public WarehouseDTO Get(int id) { using IDbConnection db = new SqlConnection(connectionString); const string query = "SELECT * FROM Warehouses WHERE Id = @Id"; WarehouseDTO entity = mapper.Map <WarehouseDTO>(db.QueryFirstOrDefault <Warehouse>(query, new { Id = id })); LoadReferences(db, entity); return(entity); }
public List <TruckDTO> FindByParent(WarehouseDTO warehouse) { try { return(_dbContext.Trucks.Where(t => t.Parent == warehouse).ToList()); } catch (Exception ex) { throw new DalException("DAL error finding trucks by parent", ex); } }
private void ValidateProduct(WarehouseDTO warehouseDto) { if (!_repository.ProductExists(warehouseDto.IdProduct)) { throw new ProductDoesntExistException(warehouseDto.IdProduct); } if (!_repository.WarehouseExists(warehouseDto.IdWarehouse)) { throw new WarehouseDoesntExistException(warehouseDto.IdWarehouse); } }
public void Create(WarehouseDTO warehouse) { try { _dbContext.Warehouses.Add(warehouse); _dbContext.SaveChanges(); } catch (Exception ex) { throw new DalException("DAL error creating warehouse", ex); } }
public void Delete(WarehouseDTO warehouse) { try { _dbContext.Warehouses.Remove(warehouse); _dbContext.SaveChanges(); } catch (Exception ex) { throw new DalException("DAL error deleting warehouse", ex); } }
public ItemEntry(ItemQuantityDTO itemQtyDto, WarehouseDTO warehouseDto, System.Windows.Visibility itemsQtyVisibility) { ItemEntryViewModel.Errors = 0; InitializeComponent(); //TxtBlockItemsQuantity.Visibility = itemsQtyVisibility; //TxtItemsQuantity.Visibility = itemsQtyVisibility; Messenger.Default.Send <ItemQuantityDTO>(itemQtyDto); Messenger.Default.Send <WarehouseDTO>(warehouseDto); Messenger.Reset(); }
public void GetWarehouses() { var warehouses = new WarehouseService(true).GetAll().ToList(); warehouses.Insert(0, new WarehouseDTO { Id = -1, DisplayName = "Choose Store/Shop" }); Warehouses = warehouses; SelectedFromWarehouse = Warehouses.FirstOrDefault(); SelectedToWarehouse = Warehouses.FirstOrDefault(); }
public int RegisterProductAtWarehouse(WarehouseDTO warehouseDto) { ValidateProduct(warehouseDto); var orderId = _repository.GetOrderId(warehouseDto.IdProduct, warehouseDto.Amount, warehouseDto.CreatedAt); if (_repository.IsOrderCompleted(orderId)) { throw new OrderAlreadyCompletedException(orderId); } return(_repository.RegisterProductAtWarehouse(warehouseDto, orderId)); }
public async Task <IActionResult> Update(WarehouseDTO model) { if (model == null) { return(BadRequest()); } var warehouse = await _service.GetById(model.Id); var entry = _mapper.Map <WarehouseDTO, Warehouse>(model, warehouse); var result = await _service.Update(entry); return(Ok(result)); }
private void ExecuteAddNewWarehouseViewCommand() { SelectedWarehouse = new WarehouseDTO { OrganizationId = SelectedOrganization.Id, WarehouseNumber = (Organizations.Count * 10) + (Warehouses.Count + 1),//Not getting the right number, we should also have org number field on orgDTO Address = new AddressDTO { Country = "Ethiopia", City = "Addis Abeba" } }; }
public void Get_warehouse_by_code_should_return_warehouse() { var ware = new WarehouseDTO() { Code = "ROOT", Description = "Root WH", Duration = 0.5m, Parent = null }; warehouseRepMock.Setup(input => input.GetByCode(It.IsAny <string>())).Returns(ware); var result = warehouse.GetWarehouseByCode("ROOT"); // Assert Assert.IsInstanceOfType(result, typeof(WarehouseModel)); }
public bool edit(WarehouseDTO a) { DataTable c = ProductDAO.Instance.viewinfo(a.Masp); if (int.Parse(c.Rows[0]["ton_tai"].ToString()) == 0) { return(false); } if (WarehouseDAO.Instance.edit(a) && WarehouseDAO.Instance.update_ton_kho(a.Masp, sl_tonkho)) { return(true); } return(false); }