private IEnumerable<CompanyViewModel> GetCompanyViewModels()
{
//List<StrategicBusinessUnitViewModel> sbuViewModels = new List<StrategicBusinessUnitViewModel>();
List<CompanyViewModel> companyViewModels = new List<CompanyViewModel>();
try
{
using (ASJDE context = new ASJDE())
{
IQueryable<Company> companies = (from c in context.Companies select c);
foreach (Company company in companies)
{
CompanyViewModel companyViewModel = new CompanyViewModel();
companyViewModel.Name = company.Entity.Name;
companyViewModel.StrategicBusinessUnitViews = new List<StrategicBusinessUnitViewModel>();
Company co = company;
IQueryable<StrategicBusinessUnit> sbus = (from s in context.StrategicBusinessUnits
where s.Entity.EntityStatus.ID == 1
&& s.CompanyID == co.ID
select s);
foreach (var strategicBusinessUnit in sbus)
{
StrategicBusinessUnitViewModel sbuViewModel = new StrategicBusinessUnitViewModel();
sbuViewModel.Name = strategicBusinessUnit.Entity.Name;
sbuViewModel.OBUViewModels = new List<OperationalBusinessUnitViewModel>();
StrategicBusinessUnit sbUnit = strategicBusinessUnit;
IQueryable<OperationalBusinessUnit> obs = (from o in context.OperationalBusinessUnits
where o.Entity.EntityStatus.ID == 1
&& o.StrategicBusinessUnitID == sbUnit.ID
select o);
foreach (var operationalBusinessUnit in obs)
{
OperationalBusinessUnitViewModel obuViewModel = new OperationalBusinessUnitViewModel();
obuViewModel.Name = operationalBusinessUnit.Entity.Name;
obuViewModel.BUViewModels = new List<BusinessUnitViewModel>();
OperationalBusinessUnit bUnit = operationalBusinessUnit;
IQueryable<BusinessUnit> bus = (from b in context.BusinessUnits
where b.Entity.EntityStatus.ID == 1
&& b.OperationalBusinessUnitID == bUnit.ID
select b);
foreach (var bu in bus)
{
BusinessUnitViewModel buViewModel = new BusinessUnitViewModel();
buViewModel.Name = bu.Entity.Name;
buViewModel.BranchViewModels = new List<BranchViewModel>();
BusinessUnit bu1 = bu;
IQueryable<Branch> branchs = (from br in context.Branches
where br.Entity.EntityStatus.ID == 1
&& br.BusinessUnitID == bu1.ID
select br);
foreach (var branch in branchs)
{
BranchViewModel branchViewModel = new BranchViewModel();
branchViewModel.Name = branch.Entity.Name;
branchViewModel.DepotViewModels = new List<DepotViewModel>();
Branch branch1 = branch;
var depots = (from d in context.Depots
where d.Entity.EntityStatus.ID == 1
&& d.BranchID == branch1.ID
select d);
foreach (var depot in depots)
{
DepotViewModel depotViewModel = new DepotViewModel();
depotViewModel.Name = depot.Entity.Name;
branchViewModel.DepotViewModels.Add(depotViewModel);
}
buViewModel.BranchViewModels.Add(branchViewModel);
}
obuViewModel.BUViewModels.Add(buViewModel);
}
sbuViewModel.OBUViewModels.Add(obuViewModel);
}
companyViewModel.StrategicBusinessUnitViews.Add(sbuViewModel);
}
companyViewModels.Add(companyViewModel);
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
return null;
}
return companyViewModels;
}
public ActionResult SBUDestroy([DataSourceRequest] DataSourceRequest request, StrategicBusinessUnitViewModel strategicBusinessUnitViewModel)
{
try
{
if (strategicBusinessUnitViewModel != null)
{
using (ASJDE context = new ASJDE())
{
StrategicBusinessUnit strategicBusinessUnit = (from s in context.StrategicBusinessUnits
where s.ID == strategicBusinessUnitViewModel.ID
select s).FirstOrDefault();
context.StrategicBusinessUnits.Remove(strategicBusinessUnit);
context.SaveChanges();
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return Json(ModelState.ToDataSourceResult());
}
public ActionResult SBUUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, StrategicBusinessUnitViewModel strategicBusinessUnitViewModel)
{
try
{
if (ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
StrategicBusinessUnit strategicBusinessUnit = (from s in context.StrategicBusinessUnits
where s.ID == strategicBusinessUnitViewModel.ID
select s).FirstOrDefault();
if (strategicBusinessUnit != null)
{
strategicBusinessUnit.EntityID = strategicBusinessUnitViewModel.EntityID;
strategicBusinessUnit.CompanyID = strategicBusinessUnitViewModel.CompanyID;
context.SaveChanges();
}
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return Json(new[] { strategicBusinessUnitViewModel }.ToDataSourceResult(dataSourceRequest, ModelState));
}
public ActionResult SBUCreate([DataSourceRequest] DataSourceRequest request, StrategicBusinessUnitViewModel strategicBusinessUnitViewModel)
{
try
{
if (strategicBusinessUnitViewModel != null && ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
StrategicBusinessUnit strategicBusinessUnit = new StrategicBusinessUnit
{
CompanyID = strategicBusinessUnitViewModel.CompanyID,
EntityID = strategicBusinessUnitViewModel.EntityID
};
context.StrategicBusinessUnits.Add(strategicBusinessUnit);
context.SaveChanges();
strategicBusinessUnitViewModel.ID = strategicBusinessUnit.ID;
}
}
return Json(new[] { strategicBusinessUnitViewModel }.ToDataSourceResult(request, ModelState));
}
catch (Exception e)
{
logger.Error("Exception", e);
return null;
}
}
