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