public ActionResult GetAllChildren(FormCollection form) { SalesForcVIewModel obj = new SalesForcVIewModel(); List <string> selectedList = new List <string>(); obj.StateModel = new List <Parent>(); obj.StateModel = GetAllParrent(); int level = 3; /// var value = Request.Form["SalesForce.StateModel"] ?? Request.Form["StateModel"]; selectedList.Add(form["dd1"]); selectedList.Add(form["dd2"]); selectedList.Add(form["dd3"]); if (!string.IsNullOrEmpty(value)) { level = 2; } var value1 = Request.Form["ddlcity"]; if (!string.IsNullOrEmpty(Request.Form["dd2"])) { level = 3; } string strDDLValue = value.ToString(); //strDDLValue = "MB-RSM-BTB"; var lstEmp = db.sp_GetAllChildrenForParent(strDDLValue, level).Select(i => new MT_SellOut { Day = i.Day, SalesOrg = i.SalesOrg, CustomerCode = i.CustomerCode, SalesRouteCode = i.SalesRouteCode, ID = i.ID, Name = i.Name, Store = i.Store, Target = i.Target, Perform = i.Perform, Rate = i.Rate, LineID = i.LineID, SalesForceLevel = i.SalesForceLevel, ParentCode = i.ParentCode, SalesForceCode = i.SalesForceCode } ).OrderBy(x => x.LineID) .ToList();; DataTable Dt = ExcelPackageExtensions.ToDataTable(lstEmp); MultiModel model = new MultiModel { Dt = Dt, SalesForce = obj, SelectedList = selectedList }; return(View(model)); }
public ActionResult SearchSellOut() { //var lstSellOut = sellOutRepository.List.OrderBy(x => x.LineID).ToList(); //DataTable Dt = ExcelPackageExtensions.ToDataTable(lstSellOut); //return View("ImportPerform", Dt); SalesForcVIewModel obj = new SalesForcVIewModel(); obj.StateModel = new List <Parent>(); obj.StateModel = GetAllParrent(); return(View(obj)); }