public void AddNewMonth(AddMonthLocationViewModel addMonthLocationViewModel)
{
try
{
using (ASJDE context = new ASJDE())
{
var user = Session["user"] as User;
HoursWorked hoursWorked = new HoursWorked
{
CountryID = addMonthLocationViewModel.CountryID,
LocationID = addMonthLocationViewModel.LocationID,
Year = addMonthLocationViewModel.Year,
Month = addMonthLocationViewModel.Month,
CreatedByDate = DateTime.Now,
CreatedBy = user.LastName + ", " + user.FirstName,
CreatedByUserName = user.UserName
};
context.HoursWorkeds.Add(hoursWorked);
context.SaveChanges();
}
}
catch (DbEntityValidationException dbEx)
{
logger.Error("Exception", dbEx);
}
catch (Exception e)
{
logger.Error("Exception", e);
}
}
public static List <Year> YearFiltered(int countryID)
{
List <Year> allYears = Year();
List <Year> years = new List <Year>();
try
{
using (ASJDE context = new ASJDE())
{
foreach (Year allYear in allYears)
{
int countOfLocationsInCountry = (from l in context.Locations
where l.CountryID == countryID && l.LocationStatusID == 1
select l).Count();
var y = (from h in context.HoursWorkeds
where h.CountryID == countryID &&
h.Year == allYear.ID
group h by h.Month
into grp
select new
{
Month = grp.Key,
Locations = grp.Select(l => l.LocationID)
}).ToList();
List <int> monthsInThisYear = new List <int>();
foreach (var z in y)
{
int countOfDistinct = z.Locations.Distinct().Count();
if (countOfDistinct == countOfLocationsInCountry)
{
monthsInThisYear.Add(z.Month);
}
}
List <int> allMonths = new List <int>();
for (int i = 1; i < 13; i++)
{
allMonths.Add(i);
}
IEnumerable <int> x = allMonths.Except(monthsInThisYear);
if (x.Any())
{
years.Add(allYear);
}
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(years);
}
public ActionResult HoursWorkedDestroy([DataSourceRequest] DataSourceRequest request,
HoursWorkedViewModel hoursWorkedViewModel)
{
try
{
if (hoursWorkedViewModel != null)
{
using (ASJDE context = new ASJDE())
{
HoursWorked hoursWorked = (from hw in context.HoursWorkeds
where hw.ID == hoursWorkedViewModel.ID
select hw).FirstOrDefault();
context.HoursWorkeds.Remove(hoursWorked);
context.SaveChanges();
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(Json(ModelState.ToDataSourceResult()));
}
public JsonResult VideoList(int areaID, int?id)
{
var context = new ASJDE();
IQueryable result;
if (id.HasValue)
{
result = context.Videos.Where(v => v.VideoGroupID == id).Select(v => new
{
id = v.ID,
v.Name,
hasChildren = false,
type = "video",
});
}
else
{
result = context.VideoGroups.Where(vg => vg.VideoAreaID == areaID).Select(vg => new
{
id = vg.ID,
vg.Name,
hasChildren = (from v in context.Videos where v.VideoGroupID == vg.ID select v.ID).Any(),
type = "group",
});
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult OBUCreate([DataSourceRequest] DataSourceRequest request, OperationalBusinessUnitViewModel operationalBusinessUnitViewModel)
{
try
{
if (operationalBusinessUnitViewModel != null && ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
OperationalBusinessUnit operationalBusinessUnit = new OperationalBusinessUnit
{
StrategicBusinessUnitID = operationalBusinessUnitViewModel.StrategicBusinessUnitID,
EntityID = operationalBusinessUnitViewModel.EntityID
};
context.OperationalBusinessUnits.Add(operationalBusinessUnit);
context.SaveChanges();
operationalBusinessUnitViewModel.ID = operationalBusinessUnit.ID;
}
}
return(Json(new[] { operationalBusinessUnitViewModel }.ToDataSourceResult(request, ModelState)));
}
catch (Exception e)
{
logger.Error("Exception", e);
return(null);
}
}
public ActionResult VideoCreate([DataSourceRequest] DataSourceRequest request, VideoViewModel videoViewModel)
{
try
{
if (videoViewModel != null && ModelState.IsValid)
{
using (var context = new ASJDE())
{
var video = new Video
{
VideoGroupID = videoViewModel.GroupID,
Name = videoViewModel.Name,
ReferenceID = videoViewModel.ReferenceID,
CreatedDate = DateTime.Now,
CreatedByUser = ""
};
context.Videos.Add(video);
context.SaveChanges();
videoViewModel.ID = video.ID;
}
}
return(Json(new[] { videoViewModel }.ToDataSourceResult(request, ModelState)));
}
catch (Exception e)
{
Logger.Error("Exception", e);
return(null);
}
}
public ActionResult GroupCreate([DataSourceRequest] DataSourceRequest request, GroupViewModel groupViewModel)
{
try
{
if (groupViewModel != null && ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoGroup = new VideoGroup
{
VideoAreaID = groupViewModel.AreaID,
Name = groupViewModel.Name,
};
context.VideoGroups.Add(videoGroup);
context.SaveChanges();
groupViewModel.ID = videoGroup.ID;
}
}
return(Json(new[] { groupViewModel }.ToDataSourceResult(request, ModelState)));
}
catch (Exception e)
{
Logger.Error("Exception", e);
return(null);
}
}
public ActionResult GroupUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, GroupViewModel groupViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoGroup = context.VideoGroups.FirstOrDefault(vg => vg.ID == groupViewModel.ID);
if (videoGroup != null)
{
videoGroup.Name = groupViewModel.Name;
videoGroup.VideoAreaID = groupViewModel.AreaID;
}
context.SaveChanges();
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return(Json(new[] { groupViewModel }.ToDataSourceResult(dataSourceRequest, ModelState)));
}
public ActionResult AreaUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, AreaViewModel areaViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoArea = context.VideoAreas.FirstOrDefault(va => va.ID == areaViewModel.ID);
if (videoArea != null)
{
videoArea.CompanyID = areaViewModel.CompanyID;
videoArea.StrategicBusinessUnitID = areaViewModel.StrategicBusinessUnitID;
videoArea.OperationalBusinessUnitID = areaViewModel.OperationalBusinessUnitID;
videoArea.BusinessUnitID = areaViewModel.BusinessUnitID;
videoArea.BranchID = areaViewModel.BranchID;
videoArea.DepotID = areaViewModel.DepotID;
videoArea.Name = areaViewModel.Name;
}
context.SaveChanges();
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return(Json(new[] { areaViewModel }.ToDataSourceResult(dataSourceRequest, ModelState)));
}
public ActionResult AreaCreate([DataSourceRequest] DataSourceRequest request, AreaViewModel areaViewModel)
{
try
{
if (areaViewModel != null && ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoArea = new VideoArea
{
CompanyID = areaViewModel.CompanyID,
StrategicBusinessUnitID = areaViewModel.StrategicBusinessUnitID,
OperationalBusinessUnitID = areaViewModel.OperationalBusinessUnitID,
BusinessUnitID = areaViewModel.BusinessUnitID,
BranchID = areaViewModel.BranchID,
DepotID = areaViewModel.DepotID,
Name = areaViewModel.Name
};
context.VideoAreas.Add(videoArea);
context.SaveChanges();
areaViewModel.ID = videoArea.ID;
}
}
return(Json(new[] { areaViewModel }.ToDataSourceResult(request, ModelState)));
}
catch (Exception e)
{
Logger.Error("Exception", e);
return(null);
}
}
public ActionResult CompanyCreate([DataSourceRequest] DataSourceRequest request, CompanyViewModel companyViewModel)
{
try
{
if (companyViewModel != null && ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
Company company = new Company
{
ID = companyViewModel.ID,
EntityID = companyViewModel.EntityID
};
context.Companies.Add(company);
context.SaveChanges();
companyViewModel.ID = company.ID;
}
}
return Json(new[] { companyViewModel }.ToDataSourceResult(request, ModelState));
}
catch (Exception e)
{
logger.Error("Exception", e);
return null;
}
}
public ActionResult VideoUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, VideoViewModel videoViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var context = new ASJDE())
{
var video = context.Videos.FirstOrDefault(v => v.ID == videoViewModel.ID);
if (video != null)
{
video.Name = videoViewModel.Name;
video.VideoGroupID = videoViewModel.GroupID;
video.ReferenceID = videoViewModel.ReferenceID;
context.SaveChanges();
}
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return(Json(new[] { videoViewModel }.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);
}
}
public ActionResult LocationUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, LocationViewModel locationViewModel)
{
try
{
if (ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
//Video video = (from v in context.Videos
// where v.ID == locationViewModel.ID
// select v).FirstOrDefault();
//if (video != null)
//{
// video.Name = locationViewModel.Name;
// video.VideoGroupID = locationViewModel.GroupID;
// video.ReferenceID = locationViewModel.ReferenceID;
// context.SaveChanges();
//}
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(Json(new[] { locationViewModel }.ToDataSourceResult(dataSourceRequest, ModelState)));
}
public ActionResult EntityUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, EntityViewModel entityViewModel)
{
try
{
if (ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
Entity entity = (from v in context.Entities
where v.ID == entityViewModel.ID
select v).FirstOrDefault();
if (entity != null)
{
entity.LocationID = entityViewModel.LocationID;
entity.StatusID = entityViewModel.StatusID;
entity.Name = entityViewModel.Name;
entity.Code = entityViewModel.Code;
entity.CostCenter = entityViewModel.CostCenter;
context.SaveChanges();
}
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(Json(new[] { entityViewModel }.ToDataSourceResult(dataSourceRequest, ModelState)));
}
public ActionResult EntityCreate([DataSourceRequest] DataSourceRequest request, EntityViewModel entityViewModel)
{
try
{
if (entityViewModel != null && ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
Entity entity = new Entity
{
LocationID = entityViewModel.LocationID,
StatusID = entityViewModel.StatusID,
Name = entityViewModel.Name,
Code = entityViewModel.Code,
CostCenter = entityViewModel.CostCenter
};
context.Entities.Add(entity);
context.SaveChanges();
entityViewModel.ID = entity.ID;
}
}
return(Json(new[] { entityViewModel }.ToDataSourceResult(request, ModelState)));
}
catch (Exception e)
{
logger.Error("Exception", e);
return(null);
}
}
public ActionResult OBUDestroy([DataSourceRequest] DataSourceRequest request, OperationalBusinessUnitViewModel operationalBusinessUnitViewModel)
{
try
{
if (operationalBusinessUnitViewModel != null)
{
using (ASJDE context = new ASJDE())
{
OperationalBusinessUnit operationalBusinessUnit = (from s in context.OperationalBusinessUnits
where
s.ID ==
operationalBusinessUnitViewModel.ID
select s).FirstOrDefault();
context.OperationalBusinessUnits.Remove(operationalBusinessUnit);
context.SaveChanges();
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(Json(ModelState.ToDataSourceResult()));
}
public static List<LocationViewModel> GetLocationsByCountryID(decimal countryID)
{
ASJDE context = new ASJDE();
List<LocationViewModel> locationViewModels = (from a in context.Locations
where a.CountryID == countryID
select new LocationViewModel
{
ID = a.ID,
LocationStatusID = a.LocationStatusID,
CurrencyID = a.CountryID,
CountryID = a.CountryID,
Name = a.Name,
Address1 = a.Address1,
Address2 = a.Address2,
City = a.City,
State = a.State,
PostalCode = a.PostalCode,
Description = a.Description,
Status = a.LocationStatus.Name
}
).OrderBy(x => x.Name).ToList();
return locationViewModels;
}
public ActionResult CompanyCreate([DataSourceRequest] DataSourceRequest request, CompanyViewModel companyViewModel)
{
try
{
if (companyViewModel != null && ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
Company company = new Company
{
ID = companyViewModel.ID,
EntityID = companyViewModel.EntityID
};
context.Companies.Add(company);
context.SaveChanges();
companyViewModel.ID = company.ID;
}
}
return(Json(new[] { companyViewModel }.ToDataSourceResult(request, ModelState)));
}
catch (Exception e)
{
logger.Error("Exception", e);
return(null);
}
}
public static List<EntityViewModel> GetEntitiesByLocationIDHours(decimal locationID)
{
ASJDE context = new ASJDE();
string hoursAllowInactiveEntities = ConfigurationManager.AppSettings.Get("HoursAllowInactiveEntities");
IQueryable<EntityViewModel> entityViewModels = (from a in context.Entities
where a.LocationID == locationID
select new EntityViewModel
{
ID = a.ID,
Name = a.Name,
LocationID = a.LocationID,
StatusID = a.StatusID,
Code = a.Code,
CostCenter = a.CostCenter ?? "",
Status = a.EntityStatus.Name
}
).OrderBy(x => x.Name);
if (hoursAllowInactiveEntities == "No")
{
entityViewModels = entityViewModels.Where(x => x.StatusID != 2);
}
return entityViewModels.ToList();
}
public static List <Month> MonthFiltered(int countryID, int locationID, int year)
{
List <Month> allMonths = Month();
List <Month> months = new List <Month>();
try
{
using (ASJDE context = new ASJDE())
{
List <int> monthsInThisYear = (from i in context.HoursWorkeds
where i.CountryID == countryID && i.Year == year && i.LocationID == locationID
select i.Month).ToList();
months = (from al in allMonths
where !monthsInThisYear.Contains(al.ID)
select al).ToList();
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(months);
}
public ActionResult IncidentDestroy([DataSourceRequest] DataSourceRequest request, SafetyIncidentViewModel safetyIncidentViewModel)
{
safetyIncidentViewModel.EmailMessage = "This incident has been deleted";
SendEmail(safetyIncidentViewModel);
try
{
if (safetyIncidentViewModel != null)
{
using (ASJDE context = new ASJDE())
{
SafetyIncident safetyIncident = (from si in context.SafetyIncidents
where si.ID == safetyIncidentViewModel.ID
select si).FirstOrDefault();
context.SafetyIncidents.Remove(safetyIncident);
context.SaveChanges();
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(Json(ModelState.ToDataSourceResult()));
}
public static List <EntityViewModel> GetEntitiesByLocationIDSafety(decimal locationID)
{
ASJDE context = new ASJDE();
string safetyAllowInactiveEntities = ConfigurationManager.AppSettings.Get("SafetyAllowInactiveEntities");
IQueryable <EntityViewModel> entityViewModels = (from a in context.Entities
where a.LocationID == locationID
select new EntityViewModel
{
ID = a.ID,
Name = a.Name,
LocationID = a.LocationID,
StatusID = a.StatusID,
Code = a.Code,
CostCenter = a.CostCenter ?? "",
Status = a.EntityStatus.Name
}
).OrderBy(x => x.Name);
if (safetyAllowInactiveEntities == "No")
{
entityViewModels = entityViewModels.Where(x => x.StatusID != 2);
}
return(entityViewModels.ToList());
}
public static List <LocationViewModel> GetLocationsByCountryID(decimal countryID)
{
ASJDE context = new ASJDE();
List <LocationViewModel> locationViewModels = (from a in context.Locations
where a.CountryID == countryID
select new LocationViewModel
{
ID = a.ID,
LocationStatusID = a.LocationStatusID,
CurrencyID = a.CountryID,
CountryID = a.CountryID,
Name = a.Name,
Address1 = a.Address1,
Address2 = a.Address2,
City = a.City,
State = a.State,
PostalCode = a.PostalCode,
Description = a.Description,
Status = a.LocationStatus.Name
}
).OrderBy(x => x.Name).ToList();
return(locationViewModels);
}
public ActionResult LocationCreate([DataSourceRequest] DataSourceRequest request, LocationViewModel locationViewModel)
{
try
{
if (locationViewModel != null && ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
//Video video = new Video
//{
// VideoGroupID = locationViewModel.GroupID,
// Name = locationViewModel.Name,
// ReferenceID = locationViewModel.ReferenceID,
// CreatedDate = DateTime.Now,
// CreatedByUser = ""
//};
//context.Videos.Add(video);
//context.SaveChanges();
//locationViewModel.ID = video.ID;
}
}
return(Json(new[] { locationViewModel }.ToDataSourceResult(request, ModelState)));
}
catch (Exception e)
{
logger.Error("Exception", e);
return(null);
}
}
public ActionResult OBUUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, OperationalBusinessUnitViewModel operationalBusinessUnitViewModel)
{
try
{
if (ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
OperationalBusinessUnit operationalBusinessUnit = (from s in context.OperationalBusinessUnits
where
s.ID ==
operationalBusinessUnitViewModel.ID
select s).FirstOrDefault();
if (operationalBusinessUnit != null)
{
operationalBusinessUnit.EntityID = operationalBusinessUnitViewModel.EntityID;
operationalBusinessUnit.StrategicBusinessUnitID = operationalBusinessUnitViewModel.StrategicBusinessUnitID;
context.SaveChanges();
}
}
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(Json(new[] { operationalBusinessUnitViewModel }.ToDataSourceResult(dataSourceRequest, ModelState)));
}
public ActionResult IncidentUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, SafetyIncidentViewModel safetyIncidentViewModel)
{
try
{
if (ModelState.IsValid)
{
using (ASJDE context = new ASJDE())
{
var existingIncident = (from si in context.SafetyIncidents
where si.ID == safetyIncidentViewModel.ID
select si).FirstOrDefault();
existingIncident.StatusID = safetyIncidentViewModel.StatusID;
existingIncident.EmployeeTypeID = safetyIncidentViewModel.EmployeeTypeID;
existingIncident.SiteCategoryID = safetyIncidentViewModel.SiteCategoryID;
existingIncident.TypeID = safetyIncidentViewModel.TypeID;
existingIncident.OutcomeID = safetyIncidentViewModel.OutcomeID;
existingIncident.UnsafeActID = safetyIncidentViewModel.UnsafeActID;
existingIncident.CauseCategoryID = safetyIncidentViewModel.CauseCategoryID;
existingIncident.CauseID = safetyIncidentViewModel.CauseID;
existingIncident.DateOfIncident = safetyIncidentViewModel.DateOfIncident;
existingIncident.EmployeeName = safetyIncidentViewModel.EmployeeName;
existingIncident.Title = safetyIncidentViewModel.Title;
existingIncident.WorkRelated = safetyIncidentViewModel.WorkRelated;
existingIncident.LocationSite = safetyIncidentViewModel.LocationSite;
existingIncident.Description = safetyIncidentViewModel.Description;
existingIncident.DaysAwayFromWork = safetyIncidentViewModel.DaysAwayFromWork;
existingIncident.DaysTransferredRestricted = safetyIncidentViewModel.DaysTransferredRestricted;
existingIncident.ReturnToWork = safetyIncidentViewModel.ReturnToWork;
existingIncident.DateReturnedToWork = safetyIncidentViewModel.DateReturnedToWork;
existingIncident.RootCause = safetyIncidentViewModel.RootCause;
existingIncident.CorrectiveAction = safetyIncidentViewModel.CorrectiveAction;
existingIncident.ResponsiblePerson = safetyIncidentViewModel.ResponsiblePerson;
existingIncident.Deadline = safetyIncidentViewModel.Deadline;
existingIncident.Complete = safetyIncidentViewModel.Complete;
existingIncident.Recordable = safetyIncidentViewModel.Recordable;
existingIncident.LocationID = safetyIncidentViewModel.LocationID;
existingIncident.CountryID = safetyIncidentViewModel.CountryID;
existingIncident.EntityID = safetyIncidentViewModel.EntityID;
existingIncident.DateReturnedToWorkRestricted =
safetyIncidentViewModel.DateReturnedToWorkRestricted;
context.SaveChanges();
}
}
SendEmail(safetyIncidentViewModel);
}
catch (DbEntityValidationException)
{
return(null);
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(Json(new[] { safetyIncidentViewModel }.ToDataSourceResult(dataSourceRequest, ModelState)));
}
public static List <GroupViewModel> GroupFiltered(decimal areaId)
{
using (var context = new ASJDE())
{
return(context.VideoGroups.Where(a => a.VideoAreaID == areaId).Select(a => new GroupViewModel
{
ID = a.ID,
Name = a.Name
}).ToList());
}
}
public static List<GroupViewModel> GroupFiltered(decimal areaId)
{
using (var context = new ASJDE())
{
return context.VideoGroups.Where(a => a.VideoAreaID == areaId).Select(a => new GroupViewModel
{
ID = a.ID,
Name = a.Name
}).ToList();
}
}
public static List <Month> MonthFiltered(int countryID, int year)
{
List <Month> allMonths = Month();
List <Month> months = new List <Month>();
try
{
using (ASJDE context = new ASJDE())
{
int countOfLocationsInCountry = (from l in context.Locations
where l.CountryID == countryID && l.LocationStatusID == 1
select l).Count();
var y = (from h in context.HoursWorkeds
where h.CountryID == countryID &&
h.Year == year
group h by h.Month
into grp
select new
{
Month = grp.Key,
Locations = grp.Select(l => l.LocationID)
}).ToList();
//List<int> monthsInThisYear = (from i in context.HoursWorkeds
// where i.CountryID == countryID && i.Year == year
// select i.Month).ToList();
List <int> monthsInThisYear = new List <int>();
foreach (var z in y)
{
int countOfDistinct = z.Locations.Distinct().Count();
if (countOfDistinct == countOfLocationsInCountry)
{
monthsInThisYear.Add(z.Month);
}
}
months = (from al in allMonths
where !monthsInThisYear.Contains(al.ID)
select al).ToList();
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return(months);
}
public IQueryable <LogViewModel> GetAllVideoLogs()
{
var context = new ASJDE();
var logViewModels = context.VideoLogs.Select(vl => new LogViewModel
{
ID = vl.ID,
UserName = vl.User,
});
return(logViewModels);
}
public static List<Month> MonthFiltered(int countryID, int year)
{
List<Month> allMonths = Month();
List<Month> months = new List<Month>();
try
{
using (ASJDE context = new ASJDE())
{
int countOfLocationsInCountry = (from l in context.Locations
where l.CountryID == countryID && l.LocationStatusID == 1
select l).Count();
var y = (from h in context.HoursWorkeds
where h.CountryID == countryID
&& h.Year == year
group h by h.Month
into grp
select new
{
Month = grp.Key,
Locations = grp.Select(l => l.LocationID)
}).ToList();
//List<int> monthsInThisYear = (from i in context.HoursWorkeds
// where i.CountryID == countryID && i.Year == year
// select i.Month).ToList();
List<int> monthsInThisYear = new List<int>();
foreach (var z in y)
{
int countOfDistinct = z.Locations.Distinct().Count();
if (countOfDistinct == countOfLocationsInCountry)
{
monthsInThisYear.Add(z.Month);
}
}
months = (from al in allMonths
where !monthsInThisYear.Contains(al.ID)
select al).ToList();
}
}
catch (Exception e)
{
logger.Error("Exception", e);
}
return months;
}
public IQueryable<CauseViewModel> GetAllCauses()
{
ASJDE context = new ASJDE();
IQueryable<CauseViewModel> causeViewModels = (from a in context.SafetyIncidentCauses
select new CauseViewModel
{
ID = a.ID,
Name = a.Name
}
);
return causeViewModels;
}
public IQueryable <EntityStatusViewModel> GetAllEntityStatuss()
{
ASJDE context = new ASJDE();
IQueryable <EntityStatusViewModel> statusViewModels = (from a in context.EntityStatus
select new EntityStatusViewModel
{
ID = a.ID,
Name = a.Name
}
);
return(statusViewModels);
}
public IQueryable <EmployeeTypeViewModel> GetAllEmployeeTypes()
{
ASJDE context = new ASJDE();
IQueryable <EmployeeTypeViewModel> employeeTypeViewModels = (from a in context.SafetyIncidentEmployeeTypes
select new EmployeeTypeViewModel
{
ID = a.ID,
Name = a.Name
}
);
return(employeeTypeViewModels);
}
public IQueryable <OutcomeViewModel> GetAllOutcomes()
{
ASJDE context = new ASJDE();
IQueryable <OutcomeViewModel> outcomeViewModels = (from a in context.SafetyIncidentOutcomes
select new OutcomeViewModel
{
ID = a.ID,
Name = a.Name
}
);
return(outcomeViewModels);
}
public static List<BranchViewModel> GetBranchsByBusinessUnitID(decimal businessUnitID)
{
ASJDE context = new ASJDE();
List<BranchViewModel> branchViewModels = (from a in context.Branches
where a.BusinessUnitID == businessUnitID
select new BranchViewModel
{
ID = a.ID,
Name = a.Entity.Name
}
).OrderBy(x => x.Name).ToList();
return branchViewModels;
}
public static List<BusinessUnitViewModel> GetBusinessUnitsByOperationalBusinessUnitID(decimal OperationalBusinessUnitID)
{
ASJDE context = new ASJDE();
List<BusinessUnitViewModel> buViewModels = (from a in context.BusinessUnits
where a.OperationalBusinessUnitID == OperationalBusinessUnitID
select new BusinessUnitViewModel
{
ID = a.ID,
Name = a.Entity.Name
}
).OrderBy(x => x.Name).ToList();
return buViewModels;
}
public static List<DepotViewModel> GetDepotsByBranchID(decimal branchID)
{
ASJDE context = new ASJDE();
List<DepotViewModel> depotViewModels = (from a in context.Depots
where a.BranchID == branchID
select new DepotViewModel
{
ID = a.ID,
Name = a.Entity.Name
}
).OrderBy(x => x.Name).ToList();
return depotViewModels;
}
public static List<CauseViewModel> GetCauseByCauseCategoryID(decimal causeCategoryID)
{
ASJDE context = new ASJDE();
List<CauseViewModel> causeViewModels = (from a in context.SafetyIncidentCauses
where a.CauseCategoryID == causeCategoryID
select new CauseViewModel
{
ID = a.ID,
Name = a.Name
}
).ToList();
return causeViewModels;
}
public static List<AreaViewModel> AreaFiltered(AreaFilter areaFilter)
{
var context = new ASJDE();
return context.VideoAreas.Where(a => a.CompanyID == areaFilter.CompanyID &&
(areaFilter.StrategicBusinessUnitID != null ? a.StrategicBusinessUnitID == areaFilter.StrategicBusinessUnitID : a.StrategicBusinessUnitID == null) &&
(areaFilter.OperationalBusinessUnitID != null ? a.OperationalBusinessUnitID == areaFilter.OperationalBusinessUnitID : a.OperationalBusinessUnitID == null) &&
(areaFilter.BusinessUnitID != null ? a.BusinessUnitID == areaFilter.BusinessUnitID: a.BusinessUnitID == null) &&
(areaFilter.BranchID != null ? a.BranchID == areaFilter.BranchID : a.BranchID == null) &&
(areaFilter.DepotID != null ? a.DepotID == areaFilter.DepotID : a.DepotID == null))
.Select(a => new AreaViewModel
{
ID = a.ID,
CompanyID = a.CompanyID.Value,
StrategicBusinessUnitID = a.StrategicBusinessUnitID.Value,
OperationalBusinessUnitID = a.OperationalBusinessUnitID.Value,
BusinessUnitID = a.BusinessUnitID.Value,
BranchID = a.BranchID.Value,
DepotID = a.DepotID.Value,
Name = a.Name
}).ToList();
}
public IQueryable<LocationViewModel> GetAllLocationsWithStatus()
{
ASJDE context = new ASJDE();
IQueryable<LocationViewModel> locationViewModels = (from a in context.Locations
select new LocationViewModel
{
ID = a.ID,
LocationStatusID = a.LocationStatusID,
CurrencyID = a.CountryID,
CountryID = a.CountryID,
Name = a.Name + (a.LocationStatusID == 2 ? " : " + a.LocationStatus.Name : ""),
Address1 = a.Address1,
Address2 = a.Address2,
City = a.City,
State = a.State,
PostalCode = a.PostalCode,
Description = a.Description,
Status = a.LocationStatus.Name
}
).OrderBy(x => x.Name);
return locationViewModels;
}
public IQueryable<AreaViewModel> GetAllAreas()
{
var context = new ASJDE();
var areaViewModels = context.VideoAreas.Select(a => new AreaViewModel
{
ID = a.ID,
CompanyID = a.CompanyID.Value,
StrategicBusinessUnitID = a.StrategicBusinessUnitID.Value,
OperationalBusinessUnitID = a.OperationalBusinessUnitID.Value,
BusinessUnitID = a.BusinessUnitID.Value,
BranchID = a.BranchID.Value,
DepotID = a.DepotID.Value,
Name = a.Name
});
return areaViewModels;
}
public IQueryable<GroupViewModel> GetAllGroups()
{
var context = new ASJDE();
var groupViewModels = context.VideoGroups.Select(g => new GroupViewModel
{
ID = g.ID,
AreaID = g.VideoAreaID,
Name = g.Name,
CompanyID = g.VideoArea.CompanyID,
StrategicBusinessUnitID = g.VideoArea.StrategicBusinessUnitID,
OperationalBusinessUnitID = g.VideoArea.OperationalBusinessUnitID,
BusinessUnitID = g.VideoArea.BusinessUnitID,
BranchID = g.VideoArea.BranchID,
DepotID = g.VideoArea.DepotID
});
return groupViewModels;
}
public IQueryable<VideoViewModel> GetAllVideos()
{
var context = new ASJDE();
var videoViewModels = context.Videos.Select(v => new VideoViewModel
{
CompanyID = v.VideoGroup.VideoArea.CompanyID,
StrategicBusinessUnitID = v.VideoGroup.VideoArea.StrategicBusinessUnitID,
OperationalBusinessUnitID = v.VideoGroup.VideoArea.OperationalBusinessUnitID,
BusinessUnitID = v.VideoGroup.VideoArea.BusinessUnitID,
BranchID = v.VideoGroup.VideoArea.BranchID,
DepotID = v.VideoGroup.VideoArea.DepotID,
ID = v.ID,
AreaID = v.VideoGroup.VideoAreaID,
GroupID = v.VideoGroupID,
Name = v.Name,
ReferenceID = v.ReferenceID
});
return videoViewModels;
}
public VideoArea GetAreaById(int areaId)
{
var videoArea = new VideoArea();
try
{
using (var context = new ASJDE())
{
videoArea = context.VideoAreas.FirstOrDefault(va => va.ID == areaId);
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return videoArea;
}
public IEnumerable<AreaViewModel> GetAreaViewModels()
{
using (var context = new ASJDE())
{
var videoAreas = context.VideoAreas.Where(a => a.CompanyID == 1
&& a.StrategicBusinessUnitID == null
&& a.OperationalBusinessUnitID == null
&& a.BusinessUnitID == null
&& a.BranchID == null
&& a.DepotID == null);
return GetAreaViewModelsByVideoAreas(context, videoAreas);
}
}
public ActionResult VideoCreate([DataSourceRequest] DataSourceRequest request, VideoViewModel videoViewModel)
{
try
{
if (videoViewModel != null && ModelState.IsValid)
{
using (var context = new ASJDE())
{
var video = new Video
{
VideoGroupID = videoViewModel.GroupID,
Name = videoViewModel.Name,
ReferenceID = videoViewModel.ReferenceID,
CreatedDate = DateTime.Now,
CreatedByUser = ""
};
context.Videos.Add(video);
context.SaveChanges();
videoViewModel.ID = video.ID;
}
}
return Json(new[] { videoViewModel }.ToDataSourceResult(request, ModelState));
}
catch (Exception e)
{
Logger.Error("Exception", e);
return null;
}
}
public Video GetVideoById(long referenceId)
{
try
{
using (var context = new ASJDE())
{
var video = context.Videos.FirstOrDefault(v => v.ID == referenceId);
return video;
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
return null;
}
}
public ActionResult GroupCreate([DataSourceRequest] DataSourceRequest request, GroupViewModel groupViewModel)
{
try
{
if (groupViewModel != null && ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoGroup = new VideoGroup
{
VideoAreaID = groupViewModel.AreaID,
Name = groupViewModel.Name,
};
context.VideoGroups.Add(videoGroup);
context.SaveChanges();
groupViewModel.ID = videoGroup.ID;
}
}
return Json(new[] { groupViewModel }.ToDataSourceResult(request, ModelState));
}
catch (Exception e)
{
Logger.Error("Exception", e);
return null;
}
}
public ActionResult VideoUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, VideoViewModel videoViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var context = new ASJDE())
{
var video = context.Videos.FirstOrDefault(v => v.ID == videoViewModel.ID);
if (video != null)
{
video.Name = videoViewModel.Name;
video.VideoGroupID = videoViewModel.GroupID;
video.ReferenceID = videoViewModel.ReferenceID;
context.SaveChanges();
}
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return Json(new[] { videoViewModel }.ToDataSourceResult(dataSourceRequest, ModelState));
}
public JsonResult VideoList(int areaID, int? id)
{
var context = new ASJDE();
IQueryable result;
if (id.HasValue)
{
result = context.Videos.Where(v => v.VideoGroupID == id).Select(v => new
{
id = v.ID,
v.Name,
hasChildren = false,
type = "video",
});
}
else
{
result = context.VideoGroups.Where(vg => vg.VideoAreaID == areaID).Select(vg => new
{
id = vg.ID,
vg.Name,
hasChildren = (from v in context.Videos where v.VideoGroupID == vg.ID select v.ID).Any(),
type = "group",
});
}
return Json(result, JsonRequestBehavior.AllowGet);
}
public ActionResult GroupUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, GroupViewModel groupViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoGroup = context.VideoGroups.FirstOrDefault(vg => vg.ID == groupViewModel.ID);
if (videoGroup != null)
{
videoGroup.Name = groupViewModel.Name;
videoGroup.VideoAreaID = groupViewModel.AreaID;
}
context.SaveChanges();
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return Json(new[] { groupViewModel }.ToDataSourceResult(dataSourceRequest, ModelState));
}
public ActionResult VideoDestroy([DataSourceRequest] DataSourceRequest request, VideoViewModel videoViewModel)
{
try
{
if (videoViewModel != null)
{
using (var context = new ASJDE())
{
var video = context.Videos.FirstOrDefault(v => v.ID == videoViewModel.ID);
context.Videos.Remove(video);
context.SaveChanges();
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return Json(ModelState.ToDataSourceResult());
}
public ActionResult AreaUpdate([DataSourceRequest] DataSourceRequest dataSourceRequest, AreaViewModel areaViewModel)
{
try
{
if (ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoArea = context.VideoAreas.FirstOrDefault(va => va.ID == areaViewModel.ID);
if (videoArea != null)
{
videoArea.CompanyID = areaViewModel.CompanyID;
videoArea.StrategicBusinessUnitID = areaViewModel.StrategicBusinessUnitID;
videoArea.OperationalBusinessUnitID = areaViewModel.OperationalBusinessUnitID;
videoArea.BusinessUnitID = areaViewModel.BusinessUnitID;
videoArea.BranchID = areaViewModel.BranchID;
videoArea.DepotID = areaViewModel.DepotID;
videoArea.Name = areaViewModel.Name;
}
context.SaveChanges();
}
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
return Json(new[] { areaViewModel }.ToDataSourceResult(dataSourceRequest, ModelState));
}
public IEnumerable<SBUVideoHierarchy> GetSbuVideoHierarchy()
{
var sbuVideoHierarchies = new List<SBUVideoHierarchy>();
using (var context = new ASJDE())
{
var sbusWithVideos = context.VideoAreas.Where(a => a.CompanyID == 1 && a.StrategicBusinessUnitID != null).Select(a => a.StrategicBusinessUnitID).Distinct();
sbuVideoHierarchies.AddRange(sbusWithVideos.Select(sbusWithVideo => context.StrategicBusinessUnits.FirstOrDefault(s => s.ID == sbusWithVideo)).Select(sbu => new SBUVideoHierarchy
{
ID = sbu.ID,
Name = sbu.Entity.Name,
OBUVideoHierarchies = new List<OBUVideoHierarchy>()
}));
}
return sbuVideoHierarchies;
}
public ActionResult AreaCreate([DataSourceRequest] DataSourceRequest request, AreaViewModel areaViewModel)
{
try
{
if (areaViewModel != null && ModelState.IsValid)
{
using (var context = new ASJDE())
{
var videoArea = new VideoArea
{
CompanyID = areaViewModel.CompanyID,
StrategicBusinessUnitID = areaViewModel.StrategicBusinessUnitID,
OperationalBusinessUnitID = areaViewModel.OperationalBusinessUnitID,
BusinessUnitID = areaViewModel.BusinessUnitID,
BranchID = areaViewModel.BranchID,
DepotID = areaViewModel.DepotID,
Name = areaViewModel.Name
};
context.VideoAreas.Add(videoArea);
context.SaveChanges();
areaViewModel.ID = videoArea.ID;
}
}
return Json(new[] { areaViewModel }.ToDataSourceResult(request, ModelState));
}
catch (Exception e)
{
Logger.Error("Exception", e);
return null;
}
}
public List<AreaViewModel> GetAreaViewModelsByVideoAreas(ASJDE context, IQueryable<VideoArea> videoAreas)
{
var areaViewModels = new List<AreaViewModel>();
foreach (var videoArea in videoAreas)
{
var areaViewModel = new AreaViewModel
{
ID = videoArea.ID,
Name = videoArea.Name,
GroupViewModels = new List<GroupViewModel>()
};
var area = videoArea;
var groups = context.VideoGroups.Where(g => g.VideoAreaID == area.ID);
foreach (var videoGroup in groups)
{
var groupViewModel = new GroupViewModel
{
ID = videoGroup.ID,
Name = videoGroup.Name,
VideoViewModels = new List<VideoViewModel>()
};
var vGroup = videoGroup;
var videos = context.Videos.Where(v => v.VideoGroupID == vGroup.ID);
foreach (var videoViewModel in videos.Select(video => new VideoViewModel
{
ID = video.ID,
Name = video.Name,
ReferenceID = video.ReferenceID,
Type = "video",
}))
{
groupViewModel.VideoViewModels.Add(videoViewModel);
}
areaViewModel.GroupViewModels.Add(groupViewModel);
}
areaViewModels.Add(areaViewModel);
}
return areaViewModels;
}
public IQueryable<LogViewModel> GetAllVideoLogs()
{
var context = new ASJDE();
var logViewModels = context.VideoLogs.Select(vl => new LogViewModel
{
ID = vl.ID,
UserName = vl.User,
});
return logViewModels;
}
public void LogVideo(int videoId)
{
try
{
using (var context = new ASJDE())
{
var videoLog = new VideoLog
{
VideoID = videoId,
User = _securityService.GetDomainAndUsername(),
TimeStamp = DateTime.Now
};
context.VideoLogs.Add(videoLog);
context.SaveChanges();
}
}
catch (Exception e)
{
Logger.Error("Exception", e);
}
}
