public ActionResult UpdateWarehouseSelectionAjax([DataSourceRequest] DataSourceRequest request, WarehouseProgramViewModel WarehouseAllocation)
{
if (WarehouseAllocation != null && ModelState.IsValid)
{
List <TransportBidPlanDetail> inDb = _transportBidPlanDetailService.FindBy(w =>
w.BidPlanID == WarehouseAllocation.BidPlanID &&
w.DestinationID == WarehouseAllocation.WoredaID &&
w.SourceID == WarehouseAllocation.WarehouseID
);
TransportBidPlanDetail psnp = new TransportBidPlanDetail
{
BidPlanID = WarehouseAllocation.BidPlanID,
SourceID = WarehouseAllocation.WarehouseID,
DestinationID = WarehouseAllocation.WoredaID,
Quantity = WarehouseAllocation.PSNP,
ProgramID = 2
};
UpdateBidPlanDetail(psnp);
TransportBidPlanDetail relief = new TransportBidPlanDetail
{
BidPlanID = WarehouseAllocation.BidPlanID,
SourceID = WarehouseAllocation.WarehouseID,
DestinationID = WarehouseAllocation.WoredaID,
Quantity = WarehouseAllocation.Relief,
ProgramID = 1
};
UpdateBidPlanDetail(relief);
}
return(Json(new[] { WarehouseAllocation }.ToDataSourceResult(request, ModelState)));
}
public ActionResult CreateWarehouseSelectionAjax([DataSourceRequest] DataSourceRequest request, WarehouseProgramViewModel warehouseAllocation,
int transportBidPlanID, int selectedWoreda = 0)
{
if (warehouseAllocation != null && ModelState.IsValid)
{
var reliefDetail = new TransportBidPlanDetail()
{
BidPlanID = transportBidPlanID,
DestinationID = selectedWoreda,
SourceID = warehouseAllocation.WarehouseID,
ProgramID = 1,
Quantity = warehouseAllocation.Relief
//_transportBidPlanDetailService.GetHrdCommodityAmount(selectedWoreda),
};
UpdateBidPlanDetail(reliefDetail);
var psnpDetail = new TransportBidPlanDetail()
{
BidPlanID = transportBidPlanID,
DestinationID = selectedWoreda,
SourceID = warehouseAllocation.WarehouseID,
ProgramID = 2,
Quantity = warehouseAllocation.PSNP
//_transportBidPlanDetailService.GetWoredaGroupedPsnpAmount(selectedWoreda),
};
UpdateBidPlanDetail(psnpDetail);
}
return(Json(new[] { warehouseAllocation }.ToDataSourceResult(request, ModelState)));
}
public ActionResult DeleteConfirmed(int id)
{
TransportBidPlanDetail transportbidplandetail = db.TransportBidPlanDetails.Find(id);
db.TransportBidPlanDetails.Remove(transportbidplandetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//
// GET: /Procurement/TransportBidPlanDetail/Details/5
public ActionResult Details(int id = 0)
{
TransportBidPlanDetail transportbidplandetail = db.TransportBidPlanDetails.Find(id);
if (transportbidplandetail == null)
{
return(HttpNotFound());
}
return(View(transportbidplandetail));
}
public bool DeleteTransportBidPlanDetail(TransportBidPlanDetail item)
{
if (item == null)
{
return(false);
}
_unitOfWork.TransportBidPlanDetailRepository.Delete(item);
_unitOfWork.Save();
return(true);
}
//
// GET: /Procurement/TransportBidPlanDetail/Delete/5
public ActionResult Delete(int id = 0)
{
_transportBidPlanDetailService.DeleteById(id);
return(RedirectToAction("Index"));
TransportBidPlanDetail transportbidplandetail = db.TransportBidPlanDetails.Find(id);
if (transportbidplandetail == null)
{
return(HttpNotFound());
}
return(View(transportbidplandetail));
}
//
// GET: /Procurement/TransportBidPlanDetail/Edit/5
public ActionResult Edit(int id = 0)
{
TransportBidPlanDetail transportbidplandetail = db.TransportBidPlanDetails.Find(id);
if (transportbidplandetail == null)
{
return(HttpNotFound());
}
ViewBag.BidPlanID = new SelectList(db.TransportBidPlans, "TransportBidPlanID", "TransportBidPlanID", transportbidplandetail.BidPlanID);
ViewBag.DestinationID = new SelectList(db.AdminUnits, "AdminUnitID", "Name", transportbidplandetail.DestinationID);
ViewBag.SourceID = new SelectList(db.Hubs, "HubId", "Name", transportbidplandetail.SourceID);
ViewBag.ProgramID = new SelectList(db.Programs, "ProgramID", "Name", transportbidplandetail.ProgramID);
return(View(transportbidplandetail));
}
public ActionResult Edit(TransportBidPlanDetail transportbidplandetail)
{
if (ModelState.IsValid)
{
db.Entry(transportbidplandetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.BidPlanID = new SelectList(db.TransportBidPlans, "TransportBidPlanID", "TransportBidPlanID", transportbidplandetail.BidPlanID);
ViewBag.DestinationID = new SelectList(db.AdminUnits, "AdminUnitID", "Name", transportbidplandetail.DestinationID);
ViewBag.SourceID = new SelectList(db.Hubs, "HubId", "Name", transportbidplandetail.SourceID);
ViewBag.ProgramID = new SelectList(db.Programs, "ProgramID", "Name", transportbidplandetail.ProgramID);
return(View(transportbidplandetail));
}
public List <Cats.Areas.Procurement.Models.WarehouseProgramViewModel> GetWoredaWarehouseProgram(int BidPlanID, int WoredaID)
{
//this._transportBidPlanDetailService.get
List <TransportBidPlanDetail> bidDetails = _transportBidPlanDetailService.FindBy(t => t.BidPlanID == BidPlanID && t.DestinationID == WoredaID);
var planDetail = _transportBidPlanDetailService.FindBy(m => m.BidPlanID == BidPlanID && m.DestinationID == WoredaID && m.ProgramID == 1);
var hubs = (from hub in planDetail
select new Cats.Models.Hub
{
HubID = hub.SourceID
});
List <WarehouseProgramViewModel> ret =
(from hub in hubs
select new WarehouseProgramViewModel
{
WarehouseID = hub.HubID,
WarehouseName = hub.Name,
PSNP = 0,
Relief = 0,
BidPlanID = BidPlanID,
WoredaID = WoredaID
}).ToList();
System.Collections.Generic.Dictionary <string, TransportBidPlanDetail> filled = new Dictionary <string, TransportBidPlanDetail>();
foreach (var i in bidDetails)
{
string hash = i.ProgramID + "_" + i.SourceID;
filled.Add(hash, i);// = i;
}
foreach (WarehouseProgramViewModel i in ret)
{
string hash_psnp = "2_" + i.WarehouseID;
string hash_relief = "1_" + i.WarehouseID;
if (filled.ContainsKey(hash_psnp))
{
TransportBidPlanDetail psnp = filled[hash_psnp];
i.PSNP = psnp.Quantity;
}
if (filled.ContainsKey(hash_relief))
{
TransportBidPlanDetail releif = filled[hash_relief];
i.Relief = releif.Quantity;
}
// ret.Add(filled, i);// = i;
}
return(ret);
}
public void UpdateBidPlanDetail(TransportBidPlanDetail bpd)
{
List <TransportBidPlanDetail> inDb = _transportBidPlanDetailService.FindBy(w =>
w.BidPlanID == bpd.BidPlanID &&
w.DestinationID == bpd.DestinationID &&
w.SourceID == bpd.SourceID &&
w.ProgramID == bpd.ProgramID
);
if (inDb.Count <= 0)
{
_transportBidPlanDetailService.AddTransportBidPlanDetail(bpd);
}
else
{
TransportBidPlanDetail bpd_orignal = inDb[0];
bpd_orignal.Quantity = bpd.Quantity;
_transportBidPlanDetailService.UpdateTransportBidPlanDetail(bpd_orignal);
}
}
public bool AddTransportBidPlanDetail(TransportBidPlanDetail item)
{
_unitOfWork.TransportBidPlanDetailRepository.Add(item);
_unitOfWork.Save();
return(true);
}
