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); }