public async Task <IActionResult> Edit(int id, [Bind("Id,YearId,RegionId,Vrp,NumberOfEnterprises,WasteGeneration,ExpendituresOnEnvProt,TotalEmissions,CarbonMonoxide,Methane,NitrogenDioxide,NitricOxide,Soot,SulfurDioxide,NonMetOrgCompounds,CarbonDioxide,FromMobileSources")] IndicatorsModel indicatorsModel)
{
if (id != indicatorsModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(indicatorsModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!IndicatorsModelExists(indicatorsModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["RegionId"] = new SelectList(_context.Regions, "Id", "Id", indicatorsModel.RegionId);
ViewData["YearId"] = new SelectList(_context.Years, "Id", "Id", indicatorsModel.YearId);
return(View(indicatorsModel));
}
public async Task <IActionResult> Post(IndicatorsModel indicatorModel)
{
indicatorModel.TypeOfForm = await _dataContext.TypeOfForm.FirstOrDefaultAsync(i => i.Id == indicatorModel.TypeOfForm.Id);
indicatorModel.GroupOfIndicators = await _dataContext.GroupOfIndicators.FirstOrDefaultAsync(i => i.Id == indicatorModel.GroupOfIndicators.Id);
var model = await _dataContext.Indicators.FirstOrDefaultAsync(i => i.Name == indicatorModel.Name);
if (model != null)
{
model.TypeOfForm = await _dataContext.TypeOfForm.FirstOrDefaultAsync(i => i.Id == indicatorModel.TypeOfForm.Id);
model.GroupOfIndicators = await _dataContext.GroupOfIndicators.FirstOrDefaultAsync(i => i.Id == indicatorModel.GroupOfIndicators.Id);
_dataContext.Indicators.Update(model);
}
else
{
await _dataContext.AddAsync(indicatorModel);
}
int?x = await _dataContext.SaveChangesAsync();
if (x.HasValue)
{
return(Ok(true));
}
else
{
return(BadRequest("Прозошла ошибка"));
}
}
public async Task <IActionResult> Create([Bind("Id,YearId,RegionId,Vrp,NumberOfEnterprises,WasteGeneration,ExpendituresOnEnvProt,TotalEmissions,CarbonMonoxide,Methane,NitrogenDioxide,NitricOxide,Soot,SulfurDioxide,NonMetOrgCompounds,CarbonDioxide,FromMobileSources")] IndicatorsModel indicatorsModel)
{
if (ModelState.IsValid)
{
_context.Add(indicatorsModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["RegionId"] = new SelectList(_context.Regions, "Id", "Id", indicatorsModel.RegionId);
ViewData["YearId"] = new SelectList(_context.Years, "Id", "Id", indicatorsModel.YearId);
return(View(indicatorsModel));
}
public ActionResult Index()
{
ViewBag.Message = "Графики на Highcharts.";
var gridModel = new LogJqGridModel();
var grid = gridModel.LogGrid;
// NOTE: you need to call this method in the action that fetches the data as well,
// so that the models match
LogSetupGrid(grid);
IndicatorsModel model = new IndicatorsModel()
{
LogGrid = gridModel
};
SkladDataContext context = new SkladDataContext();
// Check permissions
int currentUserId = WebSecurity.CurrentUserId;
string[] roles = Roles.GetRolesForUser(WebSecurity.CurrentUserName);
if (roles.Contains("limitedemployee"))
{
IQueryable <UserProfile> userProfiles = context.UserProfiles.Where(x => x.UserId == currentUserId);
model.Employees = userProfiles;
model.Managers = userProfiles;
}
else
{
model.Employees = context.UserProfiles.Where(x => x.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Employee);
model.Managers = context.UserProfiles
.Where(x => x.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Manager || x.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Employee);
}
/*employee
*
* var result = (from u in datacontextModel.UserProfiles
* where u.DisplayName.ToLower().Contains(term.ToLower()) && (u.ContactTypeId ==
* (int)EntityEnum.ContactTypeEnum.Manager || u.ContactTypeId == (int)EntityEnum.ContactTypeEnum.Employee)
* select new { u.DisplayName, u.UserId }).ToList();
*/
return(View(model));
}
public static List <IVolume> OfferedVolume(bool prevMonth)
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.OfferedVolume(prevMonth));
}
public static IUsers TotalUserCount()
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.TotalUserCount());
}
public static ILatency TotalLatency(bool prevMonth)
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.TotalLatency(prevMonth));
}
public static IRatings Ratings(bool prevMonth)
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.Ratings(prevMonth));
}
public static ILatency AverageLatency(bool prevMonth)
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.AverageLatency(prevMonth));
}
public static List <IUsers> DetailedUserRegistrationDetails(string startDate, string endDate, string type)
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.UserDetails(startDate, endDate, type));
}
public static List <IDonations> DetailedAmount(string startDate, string endDate, string type)
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.DonationDetails(startDate, endDate, type));
}
public static List <IRatings> DetailedRatings(string startDate, string endDate, string type)
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.DetailedRatings(startDate, endDate, type));
}
public static List <ILatency> DetailedAverageLatency(string startDate, string endDate, string type)
{
IndicatorsModel indicator = new IndicatorsModel();
return(indicator.DetailedAverageLatency(startDate, endDate, type));
}
