public async Task <bool> Update(Warehouse Warehouse)
{
WarehouseDAO WarehouseDAO = DataContext.Warehouse.Where(x => x.Id == Warehouse.Id).FirstOrDefault();
if (WarehouseDAO == null)
{
return(false);
}
WarehouseDAO.Id = Warehouse.Id;
WarehouseDAO.Code = Warehouse.Code;
WarehouseDAO.Name = Warehouse.Name;
WarehouseDAO.Address = Warehouse.Address;
WarehouseDAO.OrganizationId = Warehouse.OrganizationId;
WarehouseDAO.ProvinceId = Warehouse.ProvinceId;
WarehouseDAO.DistrictId = Warehouse.DistrictId;
WarehouseDAO.WardId = Warehouse.WardId;
WarehouseDAO.StatusId = Warehouse.StatusId;
WarehouseDAO.RowId = Warehouse.RowId;
WarehouseDAO.UpdatedAt = StaticParams.DateTimeNow;
await DataContext.SaveChangesAsync();
await SaveReference(Warehouse);
return(true);
}
public IActionResult Put(int sku, [FromBody] Product product)
{
if (sku <= 0)
{
return(BadRequest("Please inform a Sku!"));
}
if (!ProductDAO.Exists(sku))
{
return(BadRequest("The Sku is already in use!"));
}
WarehouseDAO.Delete(sku);
foreach (Warehouse w in product.Inventory.Warehouses)
{
WarehouseDAO.CreateRecord(w, sku);
}
if (ProductDAO.Update(product))
{
return(Ok("Successfully updated the record"));
}
return(BadRequest("Error while updating record!"));
}
public IActionResult Get(int sku)
{
if (sku <= 0)
{
return(BadRequest("Please inform a Sku!"));
}
if (!ProductDAO.Exists(sku))
{
return(BadRequest("No Sku found!"));
}
List <Warehouse> warehouses = WarehouseDAO.Find(sku);
Inventory inventory = new Inventory
{
Warehouses = warehouses
};
Product product = new Product
{
Sku = sku,
Name = ProductDAO.Find(sku),
Inventory = inventory
};
return(Ok(product));
}
public async Task <bool> BulkMerge(List <Warehouse> Warehouses)
{
List <WarehouseDAO> WarehouseDAOs = new List <WarehouseDAO>();
foreach (Warehouse Warehouse in Warehouses)
{
WarehouseDAO WarehouseDAO = new WarehouseDAO();
WarehouseDAO.Id = Warehouse.Id;
WarehouseDAO.Code = Warehouse.Code;
WarehouseDAO.Name = Warehouse.Name;
WarehouseDAO.Address = Warehouse.Address;
WarehouseDAO.OrganizationId = Warehouse.OrganizationId;
WarehouseDAO.ProvinceId = Warehouse.ProvinceId;
WarehouseDAO.DistrictId = Warehouse.DistrictId;
WarehouseDAO.WardId = Warehouse.WardId;
WarehouseDAO.StatusId = Warehouse.StatusId;
WarehouseDAO.RowId = Warehouse.RowId;
WarehouseDAO.CreatedAt = StaticParams.DateTimeNow;
WarehouseDAO.UpdatedAt = StaticParams.DateTimeNow;
WarehouseDAOs.Add(WarehouseDAO);
}
await DataContext.BulkMergeAsync(WarehouseDAOs);
return(true);
}
public async Task <bool> Delete(Warehouse Warehouse)
{
WarehouseDAO WarehouseDAO = await DataContext.Warehouse.Where(x => x.Id == Warehouse.Id).FirstOrDefaultAsync();
DataContext.Warehouse.Remove(WarehouseDAO);
await DataContext.SaveChangesAsync();
return(true);
}
/// <summary>
/// 콤보박스를 세팅하는 함수
/// </summary>
private void SettingCombo()
{
WarehouseDAO warehouseDAO = new WarehouseDAO();
warehouses = warehouseDAO.GetWarehouses(new Warehouse());
foreach (var item in warehouses)
{
cmb_before.Items.Add(item.Warehouse_name);
}
}
public IActionResult Delete(int sku)
{
if (sku > 0)
{
if (ProductDAO.Delete(sku) && WarehouseDAO.Delete(sku))
{
return(Ok("Successfully removed the record"));
}
}
return(BadRequest());
}
public async Task <bool> Update(Warehouse Warehouse)
{
WarehouseDAO WarehouseDAO = DataContext.Warehouse.Where(x => x.Id == Warehouse.Id).FirstOrDefault();
WarehouseDAO.Id = Warehouse.Id;
WarehouseDAO.Name = Warehouse.Name;
WarehouseDAO.Phone = Warehouse.Phone;
WarehouseDAO.Email = Warehouse.Email;
WarehouseDAO.Address = Warehouse.Address;
WarehouseDAO.PartnerId = Warehouse.PartnerId;
await DataContext.SaveChangesAsync();
return(true);
}
public List <TruckDAO> FindByParent(WarehouseDAO parent)
{
List <TruckDAO> result;
if (parent == null)
{
return(null);
}
_logger.Debug("Searching trucks of parent '" + parent.Code + "'");
result = _trucks.Where(t => t.Parent.Code == parent.Code).ToList();
return(result);
}
public IActionResult Post([FromBody] Product product)
{
if (ProductDAO.Exists(product.Sku))
{
return(BadRequest("The Sku is already in use!"));
}
foreach (Warehouse w in product.Inventory.Warehouses)
{
WarehouseDAO.CreateRecord(w, product.Sku);
}
ProductDAO.CreateRecord(product);
return(Ok("Successfully inserted the new record"));
}
public List <WarehouseDAO> FindByParent(WarehouseDAO parent)
{
List <WarehouseDAO> result;
if (parent == null)
{
return(_warehouses.Where(w => w.Parent == null).ToList());
}
else
{
_logger.Debug(string.Format("Searching for Warehouse with parent '{0}'", parent == null ? "" : parent.Code));
result = _warehouses.Where(w => (w.Parent != null ? w.Parent.Code == parent.Code : false)).ToList();
}
return(result);
}
public async Task <bool> Create(Warehouse Warehouse)
{
WarehouseDAO WarehouseDAO = new WarehouseDAO();
WarehouseDAO.Id = Warehouse.Id;
WarehouseDAO.Name = Warehouse.Name;
WarehouseDAO.Phone = Warehouse.Phone;
WarehouseDAO.Email = Warehouse.Email;
WarehouseDAO.Address = Warehouse.Address;
WarehouseDAO.PartnerId = Warehouse.PartnerId;
await DataContext.Warehouse.AddAsync(WarehouseDAO);
await DataContext.SaveChangesAsync();
Warehouse.Id = WarehouseDAO.Id;
return(true);
}
public async Task <bool> Create(Warehouse Warehouse)
{
WarehouseDAO WarehouseDAO = new WarehouseDAO();
WarehouseDAO.Id = Warehouse.Id;
WarehouseDAO.Code = Warehouse.Code;
WarehouseDAO.Name = Warehouse.Name;
WarehouseDAO.Address = Warehouse.Address;
WarehouseDAO.OrganizationId = Warehouse.OrganizationId;
WarehouseDAO.ProvinceId = Warehouse.ProvinceId;
WarehouseDAO.DistrictId = Warehouse.DistrictId;
WarehouseDAO.WardId = Warehouse.WardId;
WarehouseDAO.StatusId = Warehouse.StatusId;
WarehouseDAO.RowId = Warehouse.RowId;
WarehouseDAO.CreatedAt = StaticParams.DateTimeNow;
WarehouseDAO.UpdatedAt = StaticParams.DateTimeNow;
DataContext.Warehouse.Add(WarehouseDAO);
await DataContext.SaveChangesAsync();
Warehouse.Id = WarehouseDAO.Id;
await SaveReference(Warehouse);
return(true);
}
public void Delete(WarehouseDAO t)
{
_warehouses.Remove(t);
}
public void Update(WarehouseDAO t)
{
throw new NotImplementedException();
}
public void Create(WarehouseDAO t)
{
t.Id = _autoinc++;
_warehouses.Add(t);
}
