List <RfqViewModel> getViewModelList(int BidPlanID, int RegionID)
{
TransportBidPlan bidPlan = _transportBidPlanService.FindById(BidPlanID);
List <TransportBidPlanDetail> regionalPlan = _transportBidPlanDetailService.FindBy(t => t.BidPlanID == BidPlanID && t.Destination.AdminUnit2.AdminUnit2.AdminUnitID == RegionID);
var regionalPlanSorted =
(from planDetail in regionalPlan
orderby planDetail.Source.Name, planDetail.Destination.AdminUnit2.Name, planDetail.DestinationID, planDetail.ProgramID
select planDetail
).ToList();
List <RfqViewModel> regionPlanDistinct = (from rg in regionalPlanSorted
select new RfqViewModel
{
SourceWarehouse = rg.Source.Name,
DestinationZone = rg.Destination.AdminUnit2.Name,
RegionName = rg.Destination.AdminUnit2.AdminUnit2.Name,
DestinationWoreda = rg.Destination.Name,
Quantity = rg.Quantity
})
.GroupBy(rg => new { rg.SourceWarehouse, rg.DestinationZone, rg.DestinationWoreda })
.Select(s => s.FirstOrDefault()).ToList();
return(regionPlanDistinct);
}
public TransportBidPlanViewModel CopyToView(TransportBidPlan transportbidplan)
{
return(new TransportBidPlanViewModel {
TransportBidPlanID = transportbidplan.TransportBidPlanID
, Year = transportbidplan.Year
, YearHalf = transportbidplan.YearHalf
});
}
public FileResult Print(int bidID, int regionID)
{
var datePref = _userAccountService.GetUserInfo(HttpContext.User.Identity.Name).DatePreference;
var reportPath = Server.MapPath("~/Report/Procurment/RFQ.rdlc");
var bid = _bidService.FindById(bidID);
var planID = bid.TransportBidPlanID;
TransportBidPlan bidPlan = _transportBidPlanService.FindById(planID);
List <TransportBidPlanDetail> regionalPlan = _transportBidPlanDetailService.FindBy(t => t.BidPlanID == planID && t.Destination.AdminUnit2.AdminUnit2.AdminUnitID == regionID);
var totalReliefAmount = regionalPlan.Where(m => m.ProgramID == 1).Sum(m => m.Quantity);
var totalPsnpAmount = regionalPlan.Where(m => m.ProgramID == 2).Sum(m => m.Quantity);
var rfqDetail = (from transportBidPlanDetail in regionalPlan
select new RfqPrintViewModel
{
Source = transportBidPlanDetail.Source.Name,
Zone = transportBidPlanDetail.Destination.AdminUnit2.Name,
Woreda = transportBidPlanDetail.Destination.Name,
WoredaID = transportBidPlanDetail.DestinationID,
Region = transportBidPlanDetail.Destination.AdminUnit2.AdminUnit2.Name,
BidReference = bid.BidNumber,
ProgramID = transportBidPlanDetail.ProgramID,
Quantity = transportBidPlanDetail.Quantity / 10,
BidOpeningdate = bid.OpeningDate.ToCTSPreferedDateFormat(datePref),
BidOpeningTime = bid.startTime
}
).Where(m => m.Quantity > 0)
.GroupBy(ac => new
{
ac.Woreda,
ac.Source,
ac.Region,
ac.Zone
})
.Select(ac => new RfqPrintViewModel
{
Source = ac.Key.Source,
Zone = ac.Key.Zone,
Woreda = ac.Key.Woreda,
Region = ac.Key.Region,
BidReference = bid.BidNumber,
Quantity = ac.Sum(m => m.Quantity),
ReliefAmount = totalReliefAmount / 10,
PsnpAmount = totalPsnpAmount / 10,
BidOpeningdate = bid.OpeningDate.ToCTSPreferedDateFormat(datePref),
BidOpeningTime = bid.startTime
});
var reportData = rfqDetail;
var dataSourceName = "RFQDataset";
var result = ReportHelper.PrintReport(reportPath, reportData, dataSourceName);
return(File(result.RenderBytes, result.MimeType));
}
public bool DeleteTransportBidPlan(TransportBidPlan item)
{
if (item == null)
{
return(false);
}
_unitOfWork.TransportBidPlanRepository.Delete(item);
_unitOfWork.Save();
return(true);
}
public ActionResult Edit(TransportBidPlan transportbidplan)
{
if (ModelState.IsValid)
{
_transportBidPlanService.UpdateTransportBidPlan(transportbidplan);
return(RedirectToAction("Index"));
}
loadLookups(transportbidplan);
return(View(transportbidplan));
}
//
// GET: /Procurement/TransportBidPlan/Details/5
public ActionResult Details(int id = 0)
{
TransportBidPlan transportbidplan = fetchFromDB(id);
if (transportbidplan == null)
{
return(HttpNotFound());
}
return(View(transportbidplan));
}
//
// GET: /Procurement/TransportBidPlan/Details/5
public ActionResult WarehouseSelection(int id = 0)
{
TransportBidPlan transportbidplan = fetchFromDB(id);
ViewBag.WarehouseID = _hubService.GetAllHub();
@ViewBag.bidPlan = transportbidplan;
ViewBag.RegionCollection = _adminUnitService.FindBy(t => t.AdminUnitTypeID == 2);
List <WarehouseProgramViewModel> table = GetWoredaWarehouseProgram(id, 0);
return(View(table));
}
//
// GET: /Procurement/TransportBidPlan/Edit/5
public ActionResult Edit(int id = 0)
{
TransportBidPlan transportbidplan = fetchFromDB(id);
if (transportbidplan == null)
{
return(HttpNotFound());
}
loadLookups(transportbidplan);
return(View(transportbidplan));
}
public ActionResult Create(TransportBidPlan transportbidplan)
{
if (ModelState.IsValid)
{
ViewBag.Message = "Invalid Model";
var transportPlan = _transportBidPlanService.FindBy(m => m.Year == transportbidplan.Year && m.YearHalf == transportbidplan.YearHalf).FirstOrDefault();
if (transportPlan == null)
{
var woredas = _adminUnitService.FindBy(m => m.AdminUnitTypeID == 4);
var psnptransportBidPlanDetail = (from detail in woredas
where _transportBidPlanDetailService.GetWoredaGroupedPsnpAmount(detail.AdminUnitID) > 0
select new TransportBidPlanDetail()
{
DestinationID = detail.AdminUnitID,
SourceID =
_hubService.GetNearestWarehouse(detail.AdminUnitID).
HubID,
ProgramID = 2,
Quantity =
_transportBidPlanDetailService.
GetWoredaGroupedPsnpAmount(detail.AdminUnitID)
}).ToList();
var relieftransportBidPlanDetail = (from detail in woredas
where _transportBidPlanDetailService.GetHrdCommodityAmount(detail.AdminUnitID) > 0
select new TransportBidPlanDetail()
{
DestinationID = detail.AdminUnitID,
SourceID =
_hubService.GetNearestWarehouse(detail.AdminUnitID).
HubID,
ProgramID = 1,
Quantity =
_transportBidPlanDetailService.GetHrdCommodityAmount
(detail.AdminUnitID)
}).ToList();
var transportbidplanDetail = psnptransportBidPlanDetail.Union(relieftransportBidPlanDetail).ToList();
transportbidplan.TransportBidPlanDetails = transportbidplanDetail;
_transportBidPlanService.AddTransportBidPlan(transportbidplan);
return(RedirectToAction("Index"));
}
ModelState.AddModelError("Errors", @"Bid Plan For this Year and Period already Exists");
}
loadLookups(transportbidplan);
return(View(transportbidplan));
}
public ActionResult Details(int BidID = 0)
{
//ViewBag.RegionID = new SelectList(_adminUnitService.GetAllAdminUnit(), "AdminUnitID", "Name", RegionID);
var datePref = _userAccountService.GetUserInfo(HttpContext.User.Identity.Name).DatePreference;
var bid = _bidService.FindById(BidID);
if (bid == null)
{
return(HttpNotFound());
}
var RegionID = bid.RegionID;
var r = _adminUnitService.FindById(bid.RegionID);
ViewBag.SelectedRegion = r.Name;
ViewBag.BidID = new SelectList(_bidService.GetAllBid(), "BidID", "BidNumber", BidID);
ViewBag.RegionID = new SelectList(_adminUnitService.FindBy(t => t.AdminUnitTypeID == 2), "AdminUnitID", "Name", RegionID);
var bidPlanID = bid.TransportBidPlanID;
ViewBag.BidReference = bid.BidNumber;
ViewBag.OpeningDate = bid.OpeningDate.ToCTSPreferedDateFormat(datePref);
ViewBag.bid = BidID;
ViewBag.reg = RegionID;
TransportBidPlan bidPlan = _transportBidPlanService.FindById(bidPlanID);
List <TransportBidPlanDetail> regionalPlan = _transportBidPlanDetailService.FindBy(t => t.BidPlanID == bidPlanID && t.Destination.AdminUnit2.AdminUnit2.AdminUnitID == RegionID);
var regionalPlanSorted =
(from planDetail in regionalPlan
orderby planDetail.Source.Name, planDetail.Destination.AdminUnit2.Name, planDetail.DestinationID, planDetail.ProgramID
select planDetail
).ToList();
var regionPlanDistinct = (from rg in regionalPlanSorted
select new RfqViewModel()
{
SourceWarehouse = rg.Source.Name,
DestinationZone = rg.Destination.AdminUnit2.Name,
DestinationWoreda = rg.Destination.Name,
RegionName = rg.Destination.AdminUnit2.AdminUnit2.Name,
Quantity = rg.Quantity / 10,
}
).Where(m => m.Quantity > 0)
.GroupBy(ac => new
{
ac.DestinationWoreda,
ac.SourceWarehouse,
ac.RegionName,
ac.DestinationZone
})
.Select(ac => new RfqViewModel
{
SourceWarehouse = ac.Key.SourceWarehouse,
DestinationZone = ac.Key.DestinationZone,
DestinationWoreda = ac.Key.DestinationWoreda,
RegionName = ac.Key.RegionName,
Quantity = ac.Sum(m => m.Quantity)
});
ViewBag.regionalPlanSorted = regionalPlanSorted;
ViewBag.regionPlanDistinct = regionPlanDistinct;
ViewBag.BidPlan = bidPlan;
ViewBag.region = RegionID;
ViewBag.total = regionPlanDistinct.Sum(m => m.Quantity);
ViewBag.bidOpeningTime = bid.startTime;
return(View(bidPlan));
}
public void Init()
{
var bidWinner = new List <BidWinner>
{
new BidWinner
{
BidWinnerID = 1,
BidID = 1,
DestinationID = 23,
SourceID = 4,
Tariff = 12,
Position = 1,
Bid = new Bid
{
BidID = 1,
StartDate = new DateTime(12 / 12 / 2004),
EndDate = new DateTime(12 / 12 / 2005),
TransportBidPlanID = 1
}
}
};
var bidWinnerService = new Mock <IBidWinnerService>();
bidWinnerService.Setup(m => m.GetAllBidWinner()).Returns(bidWinner);
var applicationSetting = new List <ApplicationSetting>
{
new ApplicationSetting
{
SettingID = 1,
SettingName = "CurrentBid",
SettingValue = "1"
}
};
var applicationSettingService = new Mock <IApplicationSettingService>();
applicationSettingService.Setup(m => m.FindBy(b => b.SettingName == "CurrentBid")).Returns(applicationSetting);
var workFlowStatus = new List <WorkflowStatus>
{
new WorkflowStatus {
Description = "Draft",
StatusID = 1,
WorkflowID = 8
},
new WorkflowStatus
{
Description = "Approved",
StatusID = 2,
WorkflowID = 8
},
new WorkflowStatus
{
Description = "Signed",
StatusID = 3,
WorkflowID = 8
}
};
var workFlowStatusService = new Mock <IWorkflowStatusService>();
var userAccountService = new Mock <IUserAccountService>();
userAccountService.Setup(t => t.GetUserInfo(It.IsAny <string>())).Returns(new UserInfo
{
UserName = "******",
DatePreference = "en"
});
var bid = new List <Bid>
{
new Bid
{
BidID = 1,
StartDate = new DateTime(12 / 12 / 2004),
EndDate = new DateTime(12 / 12 / 2005),
TransportBidPlanID = 1
},
new Bid
{
BidID = 2,
StartDate = new DateTime(12 / 12 / 2004),
EndDate = new DateTime(12 / 12 / 2005),
TransportBidPlanID = 2
}
};
var bidService = new Mock <IBidService>();
bidService.Setup(m => m.FindById(1)).Returns(new Bid
{
BidID = 1,
StartDate = new DateTime(12 / 12 / 2004),
EndDate = new DateTime(12 / 12 / 2005),
TransportBidPlanID = 1
});
var transportBidPlan = new TransportBidPlan
{
TransportBidPlanID = 1,
Year = 2012,
YearHalf = 1,
ProgramID = 1,
Program = new Program {
ProgramID = 1, Name = "Relief"
},
TransportBidPlanDetails = new List <TransportBidPlanDetail>
{
new TransportBidPlanDetail
{
TransportBidPlanDetailID = 1,
BidPlanID = 1,
BidPlan = new TransportBidPlan {
TransportBidPlanID = 1, ProgramID = 1, Year = 2012, YearHalf = 2
},
ProgramID = 1,
Program = new Program {
ProgramID = 1, Name = "Relief"
},
SourceID = 25,
Source = new Hub {
HubID = 1, Name = "Adama"
},
DestinationID = 2,
Destination = new AdminUnit {
AdminUnitID = 1, Name = "Admin Unit Name"
},
Quantity = 123
},
new TransportBidPlanDetail
{
TransportBidPlanDetailID = 2,
BidPlanID = 1,
BidPlan = new TransportBidPlan {
TransportBidPlanID = 2, ProgramID = 2, Year = 2012, YearHalf = 2
},
ProgramID = 1,
Program = new Program {
ProgramID = 1, Name = "PSNP"
},
SourceID = 24,
Source = new Hub {
HubID = 2, Name = "Kombolecha"
},
DestinationID = 3,
Destination = new AdminUnit {
AdminUnitID = 3, Name = "Admin Unit Name"
},
Quantity = 100
}
}
};
var transportPlanService = new Mock <ITransportBidPlanService>();
transportPlanService.Setup(m => m.FindById(It.IsAny <int>())).Returns(transportBidPlan);
var fakeContext = new Mock <HttpContextBase>();
var identity = new GenericIdentity("User");
var principal = new GenericPrincipal(identity, null);
fakeContext.Setup(t => t.User).Returns(principal);
var controllerContext = new Mock <ControllerContext>();
controllerContext.Setup(t => t.HttpContext).Returns(fakeContext.Object);
_bidAdministrationController = new BidAdministrationController(bidWinnerService.Object, applicationSettingService.Object, workFlowStatusService.Object,
userAccountService.Object, bidService.Object, transportPlanService.Object);
}
public bool AddTransportBidPlan(TransportBidPlan item)
{
_unitOfWork.TransportBidPlanRepository.Add(item);
_unitOfWork.Save();
return(true);
}
public bool loadLookups(TransportBidPlan transportbidplan)
{
ViewBag.ProgramID = new SelectList(_programService.GetAllProgram(), "ProgramID", "Name", transportbidplan.ProgramID);
return(true);
}
public TransportBidPlan fetchFromDB(int id)
{
TransportBidPlan transportbidplan = _transportBidPlanService.FindById(id);
return(transportbidplan);
}
public ActionResult CreateAjax([DataSourceRequest] DataSourceRequest request, TransportBidPlan transportbidplan)
{
if (transportbidplan != null && ModelState.IsValid)
{
_transportBidPlanService.AddTransportBidPlan(transportbidplan);
}
return(Json(new[] { transportbidplan }.ToDataSourceResult(request, ModelState)));
}
public ActionResult UpdateAjax([DataSourceRequest] DataSourceRequest request, TransportBidPlan transportbidplan)
{
_transportBidPlanService.UpdateTransportBidPlan(transportbidplan);
// transportService.EditTransporter(transporter);
return(Json(ModelState.ToDataSourceResult(), JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteAjax2([DataSourceRequest] DataSourceRequest request, TransportBidPlan transportbidplan)
{
if (transportbidplan != null)
{
_transportBidPlanService.DeleteById(transportbidplan.TransportBidPlanID);
//transportService.DeleteTransporter(transporter);
}
return(Json(ModelState.ToDataSourceResult()));
}
