/// <summary>
/// Delete Standalone Truck by truckId
/// </summary>
/// <param name="truckId">Int32:truckId</param>
public void DeleteStandaloneTruck(Int32 truckId)
{
using (TransactionScope transactionScope = new TransactionScope())
{
IList<StandaloneTruckDocDetails> lstStandaloneTruckDoc = GetStandaloneTruckDocDetailsByTruckId(truckId);
(from truckDocDetail in lstStandaloneTruckDoc select truckDocDetail).Update(
truckDocDetail => truckDocDetail.StandaloneTruck_Doc_IsDeleted = true);
foreach (var standaloneTruckDocs in lstStandaloneTruckDoc)
{
DeleteStandaloneTruckDocDetails(standaloneTruckDocs);
}
StandaloneTrucksDTO standaloneTruckDetails = GetStandaloneTruckByTruckId(truckId);
standaloneTruckDetails.StandaloneTruck_IsDeleted = true;
standalonetruck standaloneTruckEntity = new standalonetruck();
AutoMapper.Mapper.Map(standaloneTruckDetails, standaloneTruckEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<standalonetruck>>().Update(standaloneTruckEntity);
transactionScope.Complete();
}
}
private void Fixupstandalonetruck(standalonetruck previousValue)
{
if (previousValue != null && previousValue.bookings.Contains(this))
{
previousValue.bookings.Remove(this);
}
if (standalonetruck != null)
{
if (!standalonetruck.bookings.Contains(this))
{
standalonetruck.bookings.Add(this);
}
if (Booking_StandAlone_Truck_Id != standalonetruck.StandaloneTruck_Id)
{
Booking_StandAlone_Truck_Id = standalonetruck.StandaloneTruck_Id;
}
}
else if (!_settingFK)
{
Booking_StandAlone_Truck_Id = null;
}
}
/// <summary>
/// Save And Update Standalone Trucks
/// </summary>
/// <param name="truckDetails"></param>
/// <returns></returns>
public int SaveAndUpdateStandaloneTrucks(StandaloneTrucksDTO truckDetails)
{
standalonetruck standaloneTruckEntity = new standalonetruck();
AutoMapper.Mapper.Map(truckDetails, standaloneTruckEntity);
if (truckDetails.StandaloneTruck_Id == 0)
{
ESalesUnityContainer.Container.Resolve<IGenericRepository<standalonetruck>>().Save(standaloneTruckEntity);
}
else
{
ESalesUnityContainer.Container.Resolve<IGenericRepository<standalonetruck>>().Update(standaloneTruckEntity);
}
//return the value
return standaloneTruckEntity.StandaloneTruck_Id;
}
private void Fixupstandalonetruck(standalonetruck previousValue)
{
if (previousValue != null && previousValue.standalonetruckdocdetails.Contains(this))
{
previousValue.standalonetruckdocdetails.Remove(this);
}
if (standalonetruck != null)
{
if (!standalonetruck.standalonetruckdocdetails.Contains(this))
{
standalonetruck.standalonetruckdocdetails.Add(this);
}
if (StandaloneTruck_Doc_TruckId != standalonetruck.StandaloneTruck_Id)
{
StandaloneTruck_Doc_TruckId = standalonetruck.StandaloneTruck_Id;
}
}
}
/// <summary>
/// Get inactive truck details by truck type and truck no and activate it
/// </summary>
/// <param></param>
/// <returns></returns>
public void ActivateInactiveTruck(int truckType, string truckNumber)
{
using (TransactionScope transaction = new TransactionScope())
{
if (truckType == 1)
{
TruckDetailsDTO _truckObj = new TruckDetailsDTO();
truckdetail upTruckEntity = new truckdetail();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<truckdetail>>()
.GetSingle(item => item.Truck_RegNo == truckNumber), _truckObj);
_truckObj.Truck_IsDeleted = false;
_truckObj.Truck_IsSuspended = false;
AutoMapper.Mapper.Map(_truckObj, upTruckEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<truckdetail>>().Update(upTruckEntity);
}
else if (truckType == 2)
{
StandaloneTrucksDTO _standaloneTruckObj = new StandaloneTrucksDTO();
standalonetruck upstandaloneTruckEntity = new standalonetruck();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<standalonetruck>>()
.GetSingle(item => item.StandaloneTruck_RegNo == truckNumber), _standaloneTruckObj);
_standaloneTruckObj.StandaloneTruck_IsDeleted = false;
_standaloneTruckObj.StandaloneTruck_IsSuspended = false;
AutoMapper.Mapper.Map(_standaloneTruckObj, upstandaloneTruckEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<standalonetruck>>().Update(upstandaloneTruckEntity);
}
transaction.Complete();
}
}
/// <summary>
/// Get all Inactive Truck Details
/// </summary>
/// <param></param>
/// <returns></returns>
public IList<TruckVerificationDTO> GetAllInactiveTruckDetails()
{
DateTime currDate = DateTime.Now.Date;
int lastYear = (currDate.Year) - 1;
DateTime lastDate = new DateTime(lastYear, currDate.Month, currDate.Day);
// Settlements occured in last one year
List<settlementofaccount> lstSettlementOfAcct = ESalesUnityContainer.Container.Resolve<IGenericRepository<settlementofaccount>>()
.GetQuery().Where(item => item.Account_CreatedDate >= lastDate && item.Account_CreatedDate <= currDate)
.OrderByDescending(F => F.Account_CreatedDate).ToList();
List<SettlementOfAccountsDTO> lstAccount = new List<SettlementOfAccountsDTO>();
if (lstSettlementOfAcct.Count > 0)
{
AutoMapper.Mapper.Map(lstSettlementOfAcct, lstAccount);
}
// List of trucks having settlement in last one year
List<string> lstTrucks = lstAccount.Where(item => item.Account_Booking_Truck_RegNo != null).Select(item => item.Account_Booking_Truck_RegNo).ToList<string>();
// List of all customer trucks
List<TruckDetailsDTO> lstTruckDetails = new List<TruckDetailsDTO>();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<truckdetail>>()
.GetQuery().Where(item => item.Truck_IsBlacklisted == false && item.Truck_IsDeleted == false).ToList(), lstTruckDetails);
// List of trucks that are not involved in settlement from last one year
List<TruckDetailsDTO> listDistinctTrucks = lstTruckDetails.FindAll(T => !lstTrucks.Contains(T.Truck_RegNo));
// Mark trucks as inactive
foreach (TruckDetailsDTO item in listDistinctTrucks)
{
truckdetail upTruckEntity = new truckdetail();
item.Truck_IsSuspended = true;
item.Truck_IsDeleted = true;
AutoMapper.Mapper.Map(item, upTruckEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<truckdetail>>().Update(upTruckEntity);
}
// List of standalone trucks having settlement in last one year
List<string> lstStandaloneTrucks = lstAccount.Where(item => item.Account_Booking_StandaloneTruck_RegNo != null).Select(item => item.Account_Booking_StandaloneTruck_RegNo).ToList<string>();
// List of all standalone trucks
List<StandaloneTrucksDTO> lstStandaloneDetails = new List<StandaloneTrucksDTO>();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<standalonetruck>>()
.GetQuery().Where(item => item.StandaloneTruck_IsBlacklisted == false && item.StandaloneTruck_IsDeleted == false).ToList(), lstStandaloneDetails);
// List of standalone trucks that are not involved in settlement from last one year
List<StandaloneTrucksDTO> listDistinctStandaloneTrucks = lstStandaloneDetails.FindAll(T => !lstStandaloneTrucks.Contains(T.StandaloneTruck_RegNo));
// Mark standalone trucks as inactive
foreach (StandaloneTrucksDTO item in listDistinctStandaloneTrucks)
{
standalonetruck upStandaloneTruckEntity = new standalonetruck();
item.StandaloneTruck_IsSuspended = true;
item.StandaloneTruck_IsDeleted = true;
AutoMapper.Mapper.Map(item, upStandaloneTruckEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<standalonetruck>>().Update(upStandaloneTruckEntity);
}
List<TruckVerificationDTO> trucks = new List<TruckVerificationDTO>();
AutoMapper.Mapper.Map(ESalesUnityContainer.Container.Resolve<IGenericRepository<truckverification>>()
.GetQuery().Where(item => item.Truck_IsSuspended == 1 && item.Truck_IsDeleted == 1), trucks);
return trucks;
}
/// <summary>
/// Update Caution List For Standalone Trucks
/// </summary>
/// <param name="standaloneTruck"></param>
/// <returns></returns>
public int UpdateCautionListForStandaloneTrucks(StandaloneTrucksDTO standaloneTruck)
{
standalonetruck standaloneTruckEntity = new standalonetruck();
AutoMapper.Mapper.Map(standaloneTruck, standaloneTruckEntity);
ESalesUnityContainer.Container.Resolve<IGenericRepository<standalonetruck>>().Update(standaloneTruckEntity);
//return value
return standaloneTruckEntity.StandaloneTruck_Id;
}
