//Given a name, fetch Warehouse from Warehouses table
//Returns a Warehouse_BDO object
public Warehouse_BDO Get_Warehouse_By_Name(string warehouse_Name)
{
//Create Warehouse_BDO object
Warehouse_BDO warehouse_BDO = new Warehouse_BDO();
//Create new DTO for Warehouse query result
DataModel.Warehouse warehouse_DTO_Result = new DataModel.Warehouse();
//Call Warehouse_Qs.Get_Warehouse_By_Name
Warehouse_Qs warehouse_Query = new Warehouse_Qs();
warehouse_DTO_Result = warehouse_Query.Get_Warehouse_By_Name(warehouse_Name);
//If Warehouse is found, tranlsate to BDO object
if (warehouse_DTO_Result.Warehouse_Name != null && warehouse_DTO_Result.Street != null &&
warehouse_DTO_Result.City != null && warehouse_DTO_Result.State != null && warehouse_DTO_Result.Zipcode != null)
{
warehouse_BDO.Warehouse_ID = warehouse_DTO_Result.Warehouse_ID;
warehouse_BDO.Warehouse_Name = warehouse_DTO_Result.Warehouse_Name;
warehouse_BDO.Street = warehouse_DTO_Result.Street;
warehouse_BDO.City = warehouse_DTO_Result.City;
warehouse_BDO.State = warehouse_DTO_Result.State;
warehouse_BDO.Zipcode = warehouse_DTO_Result.Zipcode;
}
return(warehouse_BDO);
}
//Return list of Warehouses in a database
public List <Warehouse_BDO> GetWarehouses()
{
List <Warehouse_BDO> Warehouse_List = new List <Warehouse_BDO>();
List <DataModel.Warehouse> warehouses_DTO_result = new List <DataModel.Warehouse>();
Warehouse_Qs warehouse_query = new Warehouse_Qs();
warehouses_DTO_result = warehouse_query.Get_All_Warehouses();
if (warehouses_DTO_result != null)
{
foreach (DataModel.Warehouse w in warehouses_DTO_result)
{
Warehouse_BDO warehouse_BDO_ = new Warehouse_BDO();
// Translate Data Model Object to Business Domain Object.
Translate_DMO_to_BDO(w, warehouse_BDO_);
Warehouse_List.Add(warehouse_BDO_);
}
return(Warehouse_List);
}
return(Warehouse_List);
}
//Given an ID, delete Warehouse from Warehouses table
//Returns a boolean
public bool Delete_Warehouse_By_ID(int warehouse_ID, ref string message)
{
var ret = false;
//Call Warehouse_Qs.Delete_Warehouse_By_ID
Warehouse_Qs warehouse_Query = new Warehouse_Qs();
ret = warehouse_Query.Delete_Warehouse_By_ID(warehouse_ID, ref message);
return(ret);
}
//Given a Warehouse_BDO object, add to Warehouses table
//Returns a boolean
public bool Create_Warehouse(ref Warehouse_BDO warehouse_BDO, ref string message)
{
var ret = false;
//Create new DTO object for Warehouse query
DataModel.Warehouse warehouse_DTO = new DataModel.Warehouse();
//Translate BDO to DTO for Warehouse_Qs
warehouse_DTO.Warehouse_Name = warehouse_BDO.Warehouse_Name;
warehouse_DTO.Street = warehouse_BDO.Street;
warehouse_DTO.City = warehouse_BDO.City;
warehouse_DTO.State = warehouse_BDO.State;
warehouse_DTO.Zipcode = warehouse_BDO.Zipcode;
//Call Warehouse_Qs.Create
Warehouse_Qs warehouse_Create_Query = new Warehouse_Qs();
ret = warehouse_Create_Query.Create(warehouse_DTO, ref message);
return(ret);
}
