public ActionResult NewRequisiton(List <DataFromGrid> input, int id = 0)
{
var requId = 0;
var requisistionNos = input.Select(m => m.RequisitionNo);
var requsitionNo = _reliefRequisitionService.FindBy(m => requisistionNos.Contains(m.RequisitionNo) && m.RegionalRequestID != id);
if (requsitionNo.Count > 0)
{
var requsisions = _reliefRequisitionService.GetRequisitionByRequestId(id).ToList();
var datePref = _userAccountService.GetUserInfo(HttpContext.User.Identity.Name).DatePreference;
var existingRequisitionNo = requsitionNo.FirstOrDefault();
foreach (var reliefRequisitionNew in requsisions)
{
if (reliefRequisitionNew.RequestedDate.HasValue)
{
reliefRequisitionNew.RequestDatePref = reliefRequisitionNew.RequestedDate.Value.ToCTSPreferedDateFormat(datePref);
reliefRequisitionNew.RegionalRequestId = id;
}
reliefRequisitionNew.MonthName = RequestHelper.MonthName(reliefRequisitionNew.Month);
}
if (existingRequisitionNo != null)
{
ModelState.AddModelError("Errors", String.Format("{0} Requisition No already existed please Change Requisition No", existingRequisitionNo.RequisitionNo));
}
return(View(requsisions));
}
if (ModelState.IsValid)
{
var requisitionNumbers = input.ToDictionary(t => t.Number, t => t.RequisitionNo);
_reliefRequisitionService.AssignRequisitonNo(requisitionNumbers);
}
return(RedirectToAction("Index", "ReliefRequisition"));
}
public List <RequestAllocationViewModel> getIndexList(int regionId = 0, int RequisitionID = 0)
{
List <ReliefRequisition> req;// = _requisitionService.FindBy(r => r.RegionID == regionId && r.Status == (int)ReliefRequisitionStatus.HubAssigned);
if (RequisitionID > 0)
{
req = _requisitionService.FindBy(r => r.RequisitionID == RequisitionID && r.RegionID == regionId && r.Status == (int)ReliefRequisitionStatus.HubAssigned);
}
else
{
req = _requisitionService.FindBy(r => r.RegionID == regionId && r.Status == (int)ReliefRequisitionStatus.HubAssigned);
}
var result = req.ToList().Select(item => new RequestAllocationViewModel
{
Commodity = item.Commodity.Name,
RegionName = item.AdminUnit.Name,
ZoneName = item.AdminUnit1.Name,
RequisitionId = item.RequisitionID,
CommodityId = (int)item.CommodityID,
Amount = item.ReliefRequisitionDetails.Sum(a => a.Amount).ToPreferedWeightUnit(),
HubAllocationID = item.HubAllocations.ToList()[0].HubAllocationID,
HubName = item.HubAllocations.ToList()[0].Hub.Name,
// SIAllocations=item.ReliefRequisitionDetails.RegionalRequestDetails.First().Fdpid
// AllocatedAmount = geteAllocatedAmount(item),
// SIAllocations = getSIAllocations(item.HubAllocations.ToList()[0].ProjectCodeAllocations.ToList()),
FDPRequests = getRequestDetail(item),
FreeSIPCCodes = getSIPCLists(item.RequisitionID, (int)item.CommodityID),
}).ToList();
return(result);
}
//[HttpPost]
//public ActionResult Requisitions(IList<SelectFromGrid> input)
//{
// var requisionIds = (from item in input where (item.IsSelected !=null ?((string[])item.IsSelected)[0]: "off")=="on" select item.Number).ToList();
// var req = new List<List<int>>();
// req.Add(requisionIds);
// return CreateTransportRequisition(req);
//}
public ActionResult CreateTransportRequisition(int regionId)
{
try
{
var requisitions = _reliefRequisitionService.FindBy(t => t.RegionID == regionId && t.Status == (int)ReliefRequisitionStatus.SiPcAllocationApproved);
var programs = (from item in requisitions select item.ProgramID).Distinct().ToList();
var requisitionToDispatches = new List <List <int> >();
var currentUser = UserAccountHelper.GetUser(User.Identity.Name).UserProfileID;
foreach (var program in programs)
{
var requisitionToDispatche =
(from itm in requisitions where itm.ProgramID == program select itm.RequisitionID).ToList();
requisitionToDispatches.Add(requisitionToDispatche);
}
_transportRequisitionService.CreateTransportRequisition(requisitionToDispatches, currentUser);
return(RedirectToAction("Index", "TransportRequisition"));//,new {id=(int)TransportRequisitionStatus.Draft});
}
catch (Exception exception)
{
var log = new Logger();
log.LogAllErrorsMesseges(exception, _log);
ModelState.AddModelError("", exception.Message);
return(RedirectToAction("Main", "DispatchAllocation"));
throw;
}
}
public ActionResult ApprovedRequisitions([DataSourceRequest] DataSourceRequest request)
{
ViewBag.Months = new SelectList(RequestHelper.GetMonthList(), "Id", "Name");
var previousModelState = TempData["ModelState"] as ModelStateDictionary;
if (previousModelState != null)
{
foreach (KeyValuePair <string, ModelState> kvp in previousModelState)
{
if (!ModelState.ContainsKey(kvp.Key))
{
ModelState.Add(kvp.Key, kvp.Value);
}
}
}
var requisititions = _reliefRequisitionService.FindBy(r => r.Status == (int)ReliefRequisitionStatus.Approved);
var requisitionViewModel = HubAllocationViewModelBinder.ReturnRequisitionGroupByReuisitionNo(requisititions);
if (requisitionViewModel != null)
{
var total = requisitionViewModel.Count();
ViewData["total"] = total;
}
else
{
return(HttpNotFound());
}
//.re _reliefRequisitionDetailService.Get(r => r.ReliefRequisition.Status == 2, null, "ReliefRequisition,Donor");
return(View(requisitionViewModel.ToList()));
}
public ActionResult AllocateProjectCode()
{
var previousModelState = TempData["ModelState"] as ModelStateDictionary;
if (previousModelState != null)
{
foreach (KeyValuePair <string, ModelState> kvp in previousModelState)
{
if (!ModelState.ContainsKey(kvp.Key))
{
ModelState.Add(kvp.Key, kvp.Value);
}
}
}
var requisititions = _requisitionService.FindBy(r => r.Status == (int)ReliefRequisitionStatus.HubAssigned);
var requisitionViewModel = HubAllocationViewModelBinder.ReturnRequisitionGroupByReuisitionNo(requisititions);
if (requisitionViewModel != null)
{
var total = requisitionViewModel.Count();
ViewData["total"] = total;
}
else
{
return(HttpNotFound());
}
return(View(requisitionViewModel.ToList()));
}
public ActionResult AllocateProjectCode([DataSourceRequest] DataSourceRequest request, int regionId, int status)
{
ViewBag.requestStatus = status;
List <ReliefRequisition> requisititions = null;
if (regionId == -1 || status == -1)
{
return(Json((new List <RequisitionViewModel>()).ToDataSourceResult(request)));
}
requisititions = _reliefRequisitionService.FindBy(
r =>
r.Status == status && r.RegionID == regionId).OrderByDescending(t => t.RequisitionID).ToList();
var requisitionViewModel = HubAllocationViewModelBinder.ReturnRequisitionGroupByReuisitionNo(requisititions);
return(Json(requisitionViewModel.ToDataSourceResult(request)));
}
public List <RequestAllocationViewModel> getIndexList(int regionId = 0)
{
List <ReliefRequisition> req = _requisitionService.FindBy(r => r.RegionID == regionId && r.Status == (int)ReliefRequisitionStatus.HubAssigned);
var result = req.ToList().Select(item => new RequestAllocationViewModel
{
Commodity = item.Commodity.Name,
RegionName = item.AdminUnit.Name,
ZoneName = item.AdminUnit1.Name,
RequisitionId = item.RequisitionID,
CommodityId = (int)item.CommodityID,
Amount = item.ReliefRequisitionDetails.Sum(a => a.Amount),
HubAllocationID = item.HubAllocations.ToList()[0].HubAllocationID,
HubName = item.HubAllocations.ToList()[0].Hub.Name,
AllocatedAmount = geteAllocatedAmount(item),
SIAllocations = getSIAllocations(item.HubAllocations.ToList()[0].ProjectCodeAllocations.ToList()),
FreeSIPCCodes = getSIPCLists(item.RequisitionID, (int)item.CommodityID),
}).ToList();
return(result);
}
public ActionResult CancelChanges(int id)
{
var requisitions = _reliefRequisitionService.FindBy(t => t.RegionalRequestID == id);
foreach (var reliefRequisition in requisitions)
{
var deatils = _reliefRequisitionDetailService.FindBy(t => t.RequisitionID == reliefRequisition.RequisitionID);
foreach (var detail in deatils)
{
_reliefRequisitionDetailService.DeleteReliefRequisitionDetail(detail);
}
_reliefRequisitionService.DeleteReliefRequisition(reliefRequisition);
}
var request = _regionalRequestService.FindById(id);
request.Status = (int)RegionalRequestStatus.Approved;
_regionalRequestService.EditRegionalRequest(request);
return(RedirectToAction("Details", "Request", new { id = id }));
}
public WoredaStockDistributionWithDetailViewModel CheckWoredaDistribution(int woredaID = -1, int planID = -1, int month = -1, int programId = -1)
{
if (woredaID == -1 || planID == -1 || month == -1 || programId == -1)
{
return(null);
}
//var woredaStockDistribution = _utilizationService.FindBy(m => m.WoredaID == woredaID && m.Month == month && m.PlanID == planID).FirstOrDefault();
var zoneID = _commonService.GetZoneID(woredaID);
var regionID = _commonService.GetRegion(zoneID);
RegionalRequest regionalRequest = null;
if (programId == (int)Programs.Releif)
{
regionalRequest =
_regionalRequestService.FindBy(m => m.PlanID == planID && m.Round == month && m.RegionID == regionID)
.FirstOrDefault();
}
else if (programId == (int)Programs.PSNP)
{
regionalRequest = _regionalRequestService.FindBy(m => m.PlanID == planID && m.Month == month && m.RegionID == regionID)
.FirstOrDefault();
}
if (regionalRequest != null)
{
var requisition =
_reliefRequisitionService.FindBy(
m => m.RegionalRequestID == regionalRequest.RegionalRequestID && m.ZoneID == zoneID);
if (requisition != null)
{
var woredaStockDistribution = _utilizationService.FindBy(m => m.WoredaID == woredaID && m.Month == month && m.PlanID == planID).FirstOrDefault();
if (woredaStockDistribution == null)
{
var fdpStockDistribution = _commonService.GetFDPs(woredaID);
var woredaDistributionDetailViewModels = new List <WoredaDistributionDetailViewModel>();
foreach (var reliefRequisition in requisition)
{
var detail = GetWoredaStockDistribution(fdpStockDistribution, reliefRequisition);
if (detail != null)
{
woredaDistributionDetailViewModels.AddRange(detail);
}
}
var listOfFdps = new WoredaStockDistributionWithDetailViewModel
{
WoredaDistributionDetailViewModels = woredaDistributionDetailViewModels,
};
return(listOfFdps);
}
var woredaStockDistributionWithDetailViewModel = new WoredaStockDistributionWithDetailViewModel()
{
WoredaStockDistributionID = woredaStockDistribution.WoredaStockDistributionID,
WoredaID = woredaStockDistribution.WoredaID,
ProgramID = woredaStockDistribution.ProgramID,
PlanID = woredaStockDistribution.PlanID,
Month = woredaStockDistribution.WoredaStockDistributionID,
DirectSupport = woredaStockDistribution.DirectSupport,
PublicSupport = woredaStockDistribution.PublicSupport,
ActualBeneficairies = woredaStockDistribution.ActualBeneficairies,
MaleBetween5And18Years = woredaStockDistribution.MaleBetween5And18Years,
FemaleLessThan5Years = woredaStockDistribution.FemaleLessThan5Years,
MaleAbove18Years = woredaStockDistribution.MaleAbove18Years,
MaleLessThan5Years = woredaStockDistribution.MaleLessThan5Years,
FemaleAbove18Years = woredaStockDistribution.FemaleAbove18Years,
FemaleBetween5And18Years = woredaStockDistribution.FemaleBetween5And18Years,
WoredaDistributionDetailViewModels = (from woredaDistributionDetail in woredaStockDistribution.WoredaStockDistributionDetails
from reliefRequisition in requisition
where woredaDistributionDetail.CommodityID == reliefRequisition.CommodityID
let lossReason = woredaDistributionDetail.LossReason
where lossReason != null
select new WoredaDistributionDetailViewModel()
{
WoredaStockDistributionDetailID = woredaDistributionDetail.WoredaStockDistributionDetailID,
FdpId = woredaDistributionDetail.FdpId,
FDP = woredaDistributionDetail.FDP.Name,
CommodityID = GetRequisionInfo(reliefRequisition.RequisitionID, woredaDistributionDetail.FdpId).CommodityID,
CommodityName = GetRequisionInfo(reliefRequisition.RequisitionID, woredaDistributionDetail.FdpId).CommodityName,
AllocatedAmount = GetRequisionInfo(reliefRequisition.RequisitionID, woredaDistributionDetail.FdpId).AllocatedAmount,
NumberOfBeneficiaries = GetRequisionInfo(reliefRequisition.RequisitionID, woredaDistributionDetail.FdpId).BeneficaryNumber,
//RequisitionDetailViewModel = GetRequisionInfo(reliefRequisition.RequisitionID, woredaDistributionDetail.FdpId),
dispatched = GetDispatchAllocation(reliefRequisition.RequisitionNo, woredaDistributionDetail.FDP.FDPID),
delivered = GetDelivered(reliefRequisition.RequisitionNo, woredaDistributionDetail.FDP.FDPID),
RequistionNo = reliefRequisition.RequisitionNo,
Round = reliefRequisition.Round,
Month = RequestHelper.MonthName(reliefRequisition.Month),
BeginingBalance = woredaDistributionDetail.StartingBalance,
EndingBalance = woredaDistributionDetail.EndingBalance,
DistributedAmount = woredaDistributionDetail.DistributedAmount,
TotalIn = woredaDistributionDetail.TotalIn,
TotalOut = woredaDistributionDetail.TotoalOut,
LossAmount = woredaDistributionDetail.LossAmount,
LossReasonId = (int)lossReason,
RequisitionId = woredaDistributionDetail.RequisitionId,
DistributionStartDate = woredaDistributionDetail.DistributionStartDate,
DistributionEndDate = woredaDistributionDetail.DistributionEndDate
}
).ToList()
};
return(woredaStockDistributionWithDetailViewModel);
}
return(null);
}
return(null);
}
public JsonResult RegionalData(int regionID)
{
var requests = _regionalRequestService.FindBy(t => t.RegionID == regionID);
var requisitions = _reliefRequisitionService.FindBy(t => t.RegionID == regionID);
var totalRequests = requests.Count();
var currentPlan = _hrdService.FindBy(t => t.Status == 3).FirstOrDefault().PlanID;
var utilizations = _utilization.FindBy(t => t.PlanID == currentPlan);
var sum18 = 0;
var sum518 = 0;
var sum5 = 0;
var female = 0;
var male = 0;
if (utilizations != null)
{
foreach (var i in utilizations)
{
sum18 = +(i.FemaleAbove18Years + i.MaleAbove18Years);
sum5 = +(i.FemaleLessThan5Years + i.MaleLessThan5Years);
sum518 = +(i.FemaleBetween5And18Years + i.MaleBetween5And18Years);
female = +(i.FemaleAbove18Years + i.FemaleBetween5And18Years + i.FemaleLessThan5Years);
male = +(i.MaleAbove18Years + i.MaleBetween5And18Years + i.MaleLessThan5Years);
}
}
var draft = (from r in requests
where r.Status == 1
select r).Count();
var approved = (from r in requests
where r.Status == 2
select r).Count();
var closed = (from r in requests
where r.Status == 3
select r).Count();
var federalApp = (from r in requests
where r.Status >= 4
select r).Count();
var reqApp = (from r in requisitions
where r.Status == 2
select r).Count();
var reqDraft = (from r in requisitions
where r.Status == 1
select r).Count();
var reqHub = (from r in requisitions
where r.Status >= 3
select r).Count();
var d = new DashboardData();
if (totalRequests != 0)
{
d.ApprovedRequests = (decimal)approved;
d.PendingRequests = (decimal)(draft);
d.HubAssignedRequests = (decimal)(closed);
d.FederalApproved = (decimal)(federalApp);
}
if (requisitions.Count() != 0)
{
d.ApprovedRequisitions = ((decimal)(reqApp));
d.HubAssignedRequisitions = ((decimal)(reqHub));
d.PendingRequisitions = ((decimal)(reqDraft));
}
d.Above18 = sum18;
d.Bet5And8 = sum518;
d.Below5 = sum5;
d.Female = female;
d.Male = male;
d.IncomingCommodity = 25131;
d.IncomingDispatches = 2142;
return(Json(d, JsonRequestBehavior.AllowGet));
}
