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));
}
