public ActionResult GetAllocations(string RquisitionNo, int?CommodityID, bool Uncommited)
{
ViewBag.req = RquisitionNo;
ViewBag.Com = CommodityID;
ViewBag.Uncommited = Uncommited;
var list = new List <BLL.DispatchAllocation>();
BLL.UserProfile user = _userProfileService.GetUser(User.Identity.Name);
if (!string.IsNullOrEmpty(RquisitionNo) && CommodityID.HasValue)
{
list = _dispatchAllocationService.GetAllocations(RquisitionNo, CommodityID.Value, user.DefaultHub.HubID, Uncommited, user.PreferedWeightMeasurment);
}
else if (!string.IsNullOrEmpty(RquisitionNo))
{
list = _dispatchAllocationService.GetAllocations(RquisitionNo, user.DefaultHub.HubID, Uncommited);
}
List <DispatchAllocationViewModelDto> FDPAllocations = new List <DispatchAllocationViewModelDto>();
foreach (var dispatchAllocation in list)
{
var DAVMD = new DispatchAllocationViewModelDto();
string preferedWeightMeasurment = user.PreferedWeightMeasurment.ToUpperInvariant();
//if (preferedWeightMeasurment == "MT" && dispatchAllocation.Commodity.CommodityTypeID == 1) //only for food
//{
// DAVMD.Amount = dispatchAllocation.Amount / 10;
// DAVMD.DispatchedAmount = dispatchAllocation.DispatchedAmount / 10;
// DAVMD.RemainingQuantityInQuintals = dispatchAllocation.RemainingQuantityInQuintals / 10;
//}
//else
{
DAVMD.Amount = dispatchAllocation.Amount;
DAVMD.DispatchedAmount = dispatchAllocation.DispatchedAmount;
DAVMD.RemainingQuantityInQuintals = dispatchAllocation.RemainingQuantityInQuintals;
}
DAVMD.DispatchAllocationID = dispatchAllocation.DispatchAllocationID;
DAVMD.CommodityName = dispatchAllocation.Commodity.Name;
DAVMD.CommodityID = dispatchAllocation.CommodityID;
DAVMD.RequisitionNo = dispatchAllocation.RequisitionNo;
DAVMD.BidRefNo = dispatchAllocation.BidRefNo;
DAVMD.ProjectCodeID = dispatchAllocation.ProjectCodeID;
DAVMD.ShippingInstructionID = dispatchAllocation.ShippingInstructionID;
DAVMD.Region = dispatchAllocation.FDP.AdminUnit.AdminUnit2.AdminUnit2.Name;
DAVMD.Zone = dispatchAllocation.FDP.AdminUnit.AdminUnit2.Name;
DAVMD.Woreda = dispatchAllocation.FDP.AdminUnit.Name;
DAVMD.FDPName = dispatchAllocation.FDP.Name;
DAVMD.TransporterName = dispatchAllocation.Transporter.Name;
DAVMD.IsClosed = dispatchAllocation.IsClosed;
DAVMD.AmountInUnit = DAVMD.Amount;
DAVMD.DispatchedAmountInUnit = dispatchAllocation.DispatchedAmountInUnit;
DAVMD.RemainingQuantityInUnit = dispatchAllocation.RemainingQuantityInUnit;
FDPAllocations.Add(DAVMD);
}
return(PartialView("AllocationList", FDPAllocations));
}
private DispatchAllocationViewModelDto BindDispatchAllocationViewModelDto(DispatchAllocation dispatchAllocation)
{
var target = new DispatchAllocationViewModelDto();
target.Amount = dispatchAllocation.Amount;
target.AmountInUnit = dispatchAllocation.AmountInUnit;
target.BidRefNo = dispatchAllocation.BidRefNo;
target.CommodityID = dispatchAllocation.CommodityID;
target.CommodityName = dispatchAllocation.Commodity.Name;
target.DispatchAllocationID = dispatchAllocation.DispatchAllocationID;
target.DispatchedAmount = dispatchAllocation.DispatchedAmount;
target.DispatchedAmountInUnit = dispatchAllocation.DispatchedAmountInUnit;
target.FDPName = dispatchAllocation.FDP.Name;
target.IsClosed = dispatchAllocation.IsClosed;
target.ProjectCodeID = dispatchAllocation.ProjectCodeID;
//TODO:Check Region,zone,woreda Name
target.Region = dispatchAllocation.FDP.AdminUnit.AdminUnit2.Name;
target.RemainingQuantityInQuintals = dispatchAllocation.RemainingQuantityInQuintals;
target.RemainingQuantityInUnit = dispatchAllocation.RemainingQuantityInUnit;
target.RequisitionNo = dispatchAllocation.RequisitionNo;
target.ShippingInstructionID = dispatchAllocation.ShippingInstructionID;
target.TransporterName = dispatchAllocation.Transporter.Name;
target.Woreda = dispatchAllocation.FDP.AdminUnit.Name;
target.Zone = dispatchAllocation.FDP.AdminUnit.AdminUnit2.Name;
return(target);
}
public List <DispatchAllocationViewModelDto> GetCommitedAllocationsByHubDetached(int hubId, string PreferedWeightMeasurment, bool?closedToo, int?AdminUnitId, int?CommodityType)
{
List <DispatchAllocationViewModelDto> GetUncloDetacheced = new List <DispatchAllocationViewModelDto>();
var unclosed = (from dAll in db.DispatchAllocations
where dAll.ShippingInstructionID.HasValue && dAll.ProjectCodeID.HasValue &&
hubId == dAll.HubID
select dAll);
if (AdminUnitId.HasValue)
{
BLL.AdminUnit adminunit = repository.AdminUnit.FindById(AdminUnitId.Value);
if (adminunit.AdminUnitType.AdminUnitTypeID == 2)//by region
{
unclosed =
unclosed.Where(p => p.FDP.AdminUnit.AdminUnit2.AdminUnit2.AdminUnitID == AdminUnitId.Value);
}
else if (adminunit.AdminUnitType.AdminUnitTypeID == 3)//by zone
{
unclosed =
unclosed.Where(p => p.FDP.AdminUnit.AdminUnit2.AdminUnitID == AdminUnitId.Value);
}
else if (adminunit.AdminUnitType.AdminUnitTypeID == 4)//by woreda
{
unclosed =
unclosed.Where(p => p.FDP.AdminUnit.AdminUnitID == AdminUnitId.Value);
}
//DAVMD.Region = adminunit.FDP.AdminUnit.AdminUnit2.AdminUnit2.;
//DAVMD.Zone = adminunit.FDP.AdminUnit.AdminUnit2.Name;
//DAVMD.Woreda = adminunit.FDP.AdminUnit.Name;
//unclosed = unclosed.Where(p => p.FDP.AdminUnitID == AdminUnitId.Value);
}
if (closedToo == null || closedToo == false)
{
unclosed = unclosed.Where(p => p.IsClosed == false);
}
else
{
unclosed = unclosed.Where(p => p.IsClosed == true);
}
if (CommodityType.HasValue)
{
unclosed = unclosed.Where(p => p.Commodity.CommodityTypeID == CommodityType.Value);
}
else
{
unclosed = unclosed.Where(p => p.Commodity.CommodityTypeID == 1);//by default
}
foreach (var dispatchAllocation in unclosed)
{
var DAVMD = new DispatchAllocationViewModelDto();
if (PreferedWeightMeasurment.ToUpperInvariant() == "MT" && dispatchAllocation.Commodity.CommodityTypeID == 1) //only for food
{
DAVMD.Amount = dispatchAllocation.Amount / 10;
DAVMD.DispatchedAmount = dispatchAllocation.DispatchedAmount / 10;
DAVMD.RemainingQuantityInQuintals = dispatchAllocation.RemainingQuantityInQuintals / 10;
}
else
{
DAVMD.Amount = dispatchAllocation.Amount;
DAVMD.DispatchedAmount = dispatchAllocation.DispatchedAmount;
DAVMD.RemainingQuantityInQuintals = dispatchAllocation.RemainingQuantityInQuintals;
}
DAVMD.DispatchAllocationID = dispatchAllocation.DispatchAllocationID;
DAVMD.CommodityName = dispatchAllocation.Commodity.Name;
DAVMD.RequisitionNo = dispatchAllocation.RequisitionNo;
DAVMD.BidRefNo = dispatchAllocation.BidRefNo;
DAVMD.Region = dispatchAllocation.FDP.AdminUnit.AdminUnit2.AdminUnit2.Name;
DAVMD.Zone = dispatchAllocation.FDP.AdminUnit.AdminUnit2.Name;
DAVMD.Woreda = dispatchAllocation.FDP.AdminUnit.Name;
DAVMD.FDPName = dispatchAllocation.FDP.Name;
DAVMD.IsClosed = dispatchAllocation.IsClosed;
DAVMD.AmountInUnit = DAVMD.Amount;
DAVMD.DispatchedAmountInUnit = dispatchAllocation.DispatchedAmountInUnit;
DAVMD.RemainingQuantityInUnit = dispatchAllocation.RemainingQuantityInUnit;
GetUncloDetacheced.Add(DAVMD);
// db.Detach(dispatchAllocation);
}
return(GetUncloDetacheced);
}
public List <DispatchAllocationViewModelDto> GetCommitedAllocationsByHubDetached(int hubId,
string PreferedWeightMeasurment,
bool?closedToo,
int?AdminUnitId,
int?CommodityType)
{
List <DispatchAllocationViewModelDto> GetUncloDetacheced = new List <DispatchAllocationViewModelDto>();
//TODO:Check whether both si and pc is required for checking
var unclosed =
_unitOfWork.DispatchAllocationRepository.Get(
t => (t.ShippingInstructionID.HasValue || t.ProjectCodeID.HasValue) &&
hubId == t.HubID
);
if (AdminUnitId.HasValue)
{
AdminUnit adminunit = _unitOfWork.AdminUnitRepository.FindById(AdminUnitId.Value);
if (adminunit.AdminUnitType.AdminUnitTypeID == 2) //by region
{
unclosed =
unclosed.Where(p => p.FDP.AdminUnit.AdminUnit2.AdminUnit2.AdminUnitID == AdminUnitId.Value);
}
else if (adminunit.AdminUnitType.AdminUnitTypeID == 3) //by zone
{
unclosed =
unclosed.Where(p => p.FDP.AdminUnit.AdminUnit2.AdminUnitID == AdminUnitId.Value);
}
else if (adminunit.AdminUnitType.AdminUnitTypeID == 4) //by woreda
{
unclosed =
unclosed.Where(p => p.FDP.AdminUnitID == AdminUnitId.Value);
}
//DAVMD.Region = adminunit.FDP.AdminUnit.AdminUnit2.AdminUnit2.;
//DAVMD.Zone = adminunit.FDP.AdminUnit.AdminUnit2.Name;
//DAVMD.Woreda = adminunit.FDP.AdminUnit.Name;
//unclosed = unclosed.Where(p => p.FDP.AdminUnitID == AdminUnitId.Value);
}
if (closedToo == null || closedToo == false)
{
unclosed = unclosed.Where(p => p.IsClosed == false);
}
else
{
unclosed = unclosed.Where(p => p.IsClosed == true);
}
if (CommodityType.HasValue)
{
unclosed = unclosed.Where(p => p.Commodity.CommodityTypeID == CommodityType.Value);
}
else
{
unclosed = unclosed.Where(p => p.Commodity.CommodityTypeID == 1); //by default
}
foreach (var dispatchAllocation in unclosed)
{
var DAVMD = new DispatchAllocationViewModelDto();
if (PreferedWeightMeasurment.ToUpperInvariant() == "MT " &&
dispatchAllocation.Commodity.CommodityTypeID == 1) //only for food
{
DAVMD.Amount = dispatchAllocation.Amount;
DAVMD.DispatchedAmount = dispatchAllocation.DispatchedAmount;
DAVMD.RemainingQuantityInQuintals = dispatchAllocation.RemainingQuantityInQuintals;
}
else
{
DAVMD.Amount = dispatchAllocation.Amount * 10;
DAVMD.DispatchedAmount = dispatchAllocation.DispatchedAmount * 10;
DAVMD.RemainingQuantityInQuintals = dispatchAllocation.RemainingQuantityInQuintals * 10;
}
DAVMD.DispatchAllocationID = dispatchAllocation.DispatchAllocationID;
DAVMD.CommodityName = dispatchAllocation.Commodity.Name;
DAVMD.RequisitionNo = dispatchAllocation.RequisitionNo;
DAVMD.BidRefNo = dispatchAllocation.BidRefNo;
DAVMD.Region = dispatchAllocation.FDP.AdminUnit.AdminUnit2.AdminUnit2.Name;
DAVMD.Zone = dispatchAllocation.FDP.AdminUnit.AdminUnit2.Name;
DAVMD.Woreda = dispatchAllocation.FDP.AdminUnit.Name;
DAVMD.FDPName = dispatchAllocation.FDP.Name;
DAVMD.IsClosed = dispatchAllocation.IsClosed;
if (dispatchAllocation.Transporter != null)
{
DAVMD.TransporterName = dispatchAllocation.Transporter.Name;
}
DAVMD.Round = (dispatchAllocation.Round == null)?"-":dispatchAllocation.Round.ToString();
DAVMD.AmountInUnit = DAVMD.Amount;
DAVMD.DispatchedAmountInUnit = dispatchAllocation.DispatchedAmountInUnit;
DAVMD.RemainingQuantityInUnit = dispatchAllocation.RemainingQuantityInUnit;
GetUncloDetacheced.Add(DAVMD);
// db.Detach(dispatchAllocation);
}
return(GetUncloDetacheced);
}
