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