public FileExcelService(FileWrapper fw)
{
this.fw = fw;
_fileExcelRepository = new ExcelRepository();
_excelDetailRepository = new ExcelDetailRepository();
_oraTruckRepository = new OraTruckRepository();
_assignService = new AssignService();
_oraVoyageService = new OraVoyageService();
_oraVoyageRepository = new OraVoyageRepository();
_oraTruckService = new OraTruckService();
}
///
/// <summary>
/// Assign Truck to Voyage
/// </summary>
/// <param name="trkNo">Truck No</param>
/// <param name="voyId">Voyage Id</param>
/// <param name="partnerId">Partner id</param>
/// <returns></returns>
///
public bool AssignTrkToVoy(string trkNo, string voyCode, int partnerId)
{
Logger.Info("AssignTrkToVoy trkNo=" + trkNo + " voyCode=" + voyCode + " partnerId=" + partnerId);
try
{
PARTNER_TRUCK assigned;
_oraTruckService = new OraTruckService();
_oraTruckPartnerRepository = new OraTruckPartnerRepository();
_oraVoyageService = new OraVoyageService();
_oraPartnerRepository = new OraPartnerRepository();
//Find Voyage by voyage code
var voyage = _oraVoyageService.GetByVoyCode(voyCode);
//Find Truck by truck no
var truck = _oraTruckService.GetByTruckNo(trkNo);
//Find Partner by Id
var partner = _oraPartnerRepository.GetById(partnerId);
//Check if voyage or truck or parner is in database
if (voyage == null || truck == null || partner == null)
{
return(false);
}
//Create an Assigned object
assigned = new PARTNER_TRUCK
{
PNR_ID = partnerId,
TRK_ID = truck.ID,
VOY_ID = voyage.ID
};
_oraTruckPartnerRepository.Insert(assigned);
return(true);
}
catch (Exception e)
{
Logger.Error("AssignTrkToVoy Error: ", e);
throw e;
}
}
