public bool Delete(string shelfCode)
{
var shelf = ShelfRepository.GetQueryable()
.FirstOrDefault(s => s.SHELF_CODE == shelfCode);
if (shelf != null)
{
//Del(CellRepository, shelf.Cells);
ShelfRepository.Delete(shelf);
ShelfRepository.SaveChanges();
}
else
{
return(false);
}
return(true);
}
public bool Save(CMD_SHELF shelf)
{
var shelfSave = ShelfRepository.GetQueryable().FirstOrDefault(s => s.SHELF_CODE == shelf.SHELF_CODE);
var warehouse = WarehouseRepository.GetQueryable().FirstOrDefault(w => w.WAREHOUSE_CODE == shelf.WAREHOUSE_CODE);
var area = AreaRepository.GetQueryable().FirstOrDefault(a => a.AREA_CODE == shelf.AREA_CODE);
shelfSave.SHELF_CODE = shelf.SHELF_CODE;
shelfSave.SHELF_NAME = shelf.SHELF_NAME;
shelfSave.STATION_NO = shelf.STATION_NO;
shelfSave.CRANE_NO = shelf.CRANE_NO;
shelfSave.ROW_COUNT = shelf.ROW_COUNT;
shelfSave.COLUMN_COUNT = shelf.COLUMN_COUNT;
shelfSave.WAREHOUSE_CODE = warehouse.WAREHOUSE_CODE;
shelfSave.AREA_CODE = area.AREA_CODE;
shelfSave.MEMO = shelf.MEMO;
ShelfRepository.SaveChanges();
return(true);
}
public bool Save(Shelf shelf)
{
var shelfSave = ShelfRepository.GetQueryable().FirstOrDefault(s => s.ShelfCode == shelf.ShelfCode);
var warehouse = WarehouseRepository.GetQueryable().FirstOrDefault(w => w.WarehouseCode == shelf.WarehouseCode);
var area = AreaRepository.GetQueryable().FirstOrDefault(a => a.AreaCode == shelf.AreaCode);
shelfSave.ShelfCode = shelfSave.ShelfCode;
shelfSave.ShelfName = shelf.ShelfName;
shelfSave.ShortName = shelf.ShortName;
shelfSave.ShelfType = shelf.ShelfType;
shelfSave.CellCols = shelf.CellCols;
shelfSave.CellRows = shelf.CellRows;
shelfSave.ImgX = shelf.ImgX;
shelfSave.ImgY = shelf.ImgY;
shelfSave.Warehouse = warehouse;
shelfSave.Area = area;
shelfSave.Description = shelf.Description;
shelfSave.IsActive = shelf.IsActive;
shelfSave.UpdateTime = DateTime.Now;
ShelfRepository.SaveChanges();
return(true);
}