public ActionResult GetProjecCodetForCommodity(int?CommodityId)
{
UserProfile user = _userProfileService.GetUser(User.Identity.Name);
var projectCodes = _projectCodeService.GetProjectCodesForCommodity(user.DefaultHub.HubID, CommodityId.Value);
return(Json(new SelectList(projectCodes, "ProjectCodeId", "ProjectName"), JsonRequestBehavior.AllowGet));
}
public ActionResult Index(int?StoreID, int?CommodityID, string ProjectID)
{
ViewBag.StoreID = new SelectList(GetCurrentUserProfile().DefaultHub.Stores, "StoreID", "Name", StoreID);
//var StoreI = new SelectList(GetCurrentUserProfile().DefaultHub.Stores,"StoreID","Name", StoreID);
ViewBag.CommodityID = new SelectList(_commodityService.GetAllParents(), "CommodityID", "Name", CommodityID);
ViewBag.ProjectID =
new SelectList(
_projectCodeService.GetProjectCodesForCommodity(GetCurrentUserProfile().DefaultHub.HubID,
(CommodityID.HasValue) ? CommodityID.Value : 1), "ProjectCodeId", "ProjectName");
//UserProfile user =UserProfile.GetUser(User.Identity.Name);
//var projectInputReceives = db.Receives.FirstOrDefault(p => p.ProjectNumber == ProjectID);
//var projectInputDispatches = db.Dispatches.FirstOrDefault(p => p.ProjectNumber == ProjectID);
//string projectSelected = "";
//if (projectInputReceives != null)
//{
// projectSelected = projectInputReceives.ProjectNumber;
//}
//else if (projectInputDispatches != null)
//{
// projectSelected = projectInputDispatches.ProjectNumber;
//}
ViewBag.BinCards = _storeService.GetBinCard(UserProfile.DefaultHub.HubID, StoreID, CommodityID, ProjectID).ToList();
//ViewBag.StoreID = new SelectList(db.Stores.Where(s => s.HubID == user.DefaultWarehouse.HubID), "StoreID", "Name");
//ViewBag.CommodityID = new SelectList(db.Commodities, "CommodityID", "Name");
//var UniqueprojectsReceives = from r in db.Receives
// group r by r.ProjectNumber into b
// select b;
//var UniqueprojectsReceivesProjects = from Ur in UniqueprojectsReceives
// where Ur.Key != null
// select new Cats.Web.Hub.Models.Project()
// {
// Name = Ur.FirstOrDefault().ProjectNumber,
// ProjectID = Ur.FirstOrDefault().ProjectNumber //Ur.FirstOrDefault().ReceiveID
// };
//var UniqueprojectsDispatches = from d in db.Dispatches
// group d by d.ProjectNumber into a
// select a;
//var UniqueprojectsDispatchesProjects = from Ud in UniqueprojectsDispatches
// where Ud.Key != null
// select new Cats.Web.Hub.Models.Project()
// {
// Name = Ud.FirstOrDefault().ProjectNumber,
// ProjectID = Ud.FirstOrDefault().ProjectNumber//Ud.FirstOrDefault().DispatchID
// };
//List<Cats.Web.Hub.Models.Project> Uniqueprojects = UniqueprojectsReceivesProjects.Concat(UniqueprojectsDispatchesProjects).ToList();//.Distinct(new NameComparer());//,new NameComparer());
//var perfectUniques = Uniqueprojects.Distinct(new NameComparer());
//ViewBag.ProjectID = new SelectList(perfectUniques, "ProjectID", "Name");
return(View());
}
public ActionResult GetProjecCodetForCommodity(int?CommodityId)
{
var projectCodes = _projectCodeService.GetProjectCodesForCommodity(UserProfile.DefaultHub.Value, CommodityId.Value);
return(Json(new SelectList(projectCodes, "ProjectCodeId", "ProjectName"), JsonRequestBehavior.AllowGet));
}
