//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);
}
private void Translate_DMO_to_BDO(DataModel.Warehouse warehouse_dmo, Warehouse_BDO warehouse_bdo)
{
warehouse_bdo.Warehouse_ID = warehouse_dmo.Warehouse_ID;
warehouse_bdo.Warehouse_Name = warehouse_dmo.Warehouse_Name;
warehouse_bdo.Street = warehouse_dmo.Street;
warehouse_bdo.City = warehouse_dmo.City;
warehouse_bdo.State = warehouse_dmo.State;
warehouse_bdo.Zipcode = warehouse_dmo.Zipcode;
}
//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);
}