public IActionResult RemoveUserInterests([FromBody] UserInterestViewModel request)
{
_entityCRUDResponse = _userService.DeleteUserInterest(new IntegratorUserInterest()
{
Id = request.Id
});
return(new JsonResult(_entityCRUDResponse));
}
public IActionResult RemoveUserCurriculumVitaeLanguage([FromBody] UserInterestViewModel request)
{
_entityCRUDResponse = _userService.DeleteUserLanguage(new IntegratorUserLanguages()
{
Id = request.Id
});
return(new JsonResult(_entityCRUDResponse));
}
public IActionResult AddNewInterests([FromBody] UserInterestViewModel request)
{
_entityCRUDResponse = _interestService.AddInterest(new Interest()
{
Id = request.Id,
AnInterest = request.Interest
});
return(new JsonResult(_entityCRUDResponse));
}
public static FileStreamResult GetInterestReport(UserInterestViewModel uiModel, ReportViewModel reportModel)
{
ExcelPackage pckg = new ExcelPackage();
ExcelWorksheet i = pckg.Workbook.Worksheets.Add("ZoneInterest");
ExcelWorksheet h = pckg.Workbook.Worksheets.Add("History");
BuildInterest(i, uiModel);
BuildInterestHistory(h, reportModel);
return(ExcelAsFileStream("InterestReport.xlsx", pckg));
}
public IActionResult Create([FromBody] UserInterestViewModel userInterestViewModel)
{
try
{
serviceUser.AddInterestToAUser(userInterestViewModel.UserName, userInterestViewModel.IdInterest);
return(Ok());
}
catch (Exception e)
{
return(BadRequest());
}
}
/// <summary>
/// Получает содержимое страницы.
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
var model = new UserInterestViewModel();
model.UserInterestsGrid = new DataGridDescriptor();
model.UserInterestsGrid.Name = ControllerName;
model.UserInterestsGrid.Controller = ControllerName;
model.UserInterestsGrid.SearchInputs.Add(new TextSearchInput {
Id = "UserInterestSearchTitle", Value = string.Empty, Name = "Название"
});
model.UserInterestsGrid.Columns.Add(new TextGridColumn {
Name = "Дата", Id = "EventDate"
});
model.UserInterestsGrid.Columns.Add(new TextGridColumn {
Name = "Пользователь", Id = "UserFullName"
});
model.UserInterestsGrid.Columns.Add(new TextGridColumn {
Name = "Значения", Id = "Values"
});
model.UserInterestsGrid.Columns.Add(new TextGridColumn {
Name = "Описание", Id = "Description"
});
model.UserInterestsGrid.DeleteButtonGridColumn = new DeleteButtonGridColumn {
QuestionText = "Вы точно хотите удалить пункт вознаграждения для ", DataId = "UserFullName"
};
model.UserInterestsGrid.EditButtonGridColumn = new EditButtonGridColumn {
Height = 500, Width = 600
};
model.UserInterestsGrid.CreateButtonGrid = new CreateButtonGrid {
Name = "Создание вознаграждения", Height = 500, Width = 600
};
model.UserInterestsGrid.AutoLoad = true;
model.UserInterestsGrid.HasTableBorderedClass = true;
model.UserInterestsGrid.HasTableStripedClass = true;
return(View(model));
}
private static void BuildInterest(ExcelWorksheet i, UserInterestViewModel uiModel)
{
//header row
i.Cells["A1"].Value = "Precinct/ Zone";
i.Cells["B1"].Value = "Leads";
i.Cells["C1"].Value = "Conversions";
i.Cells["D1"].Value = "Residents";
i.Cells["E1"].Value = "% Penetration";
AsGreenHeader(i.Cells["A1:E1"]);
var rowCount = 2;
foreach (var locs in uiModel.Locations.GroupBy(l => l.PrecinctCode))
{
var indexOfHeaders = rowCount;
var loc = locs.First();
i.Cells["A" + indexOfHeaders].Value = loc.PrecinctCode;
AsGreyHeader(i.Cells["A" + indexOfHeaders + ":" + "E" + indexOfHeaders]);
rowCount += 1;
foreach (var zone in uiModel.Zones.Where(z => z.PrecinctCode == loc.PrecinctCode))
{
var zoneTotalUsers = zone.NoHousesInZone;
var usersInZone = uiModel.UsersAndOrders.Where(u => u.ZoneId == zone.ZoneId);
var zoneUsersCount = usersInZone.Count();
var zoneUsersWithOrders = usersInZone.Count(u => u.UserHasOrder == true);
var zonePenetrationPerc = zoneTotalUsers != 0 ? zoneUsersWithOrders / (decimal)zoneTotalUsers * 100 : 0;
i.Cells["A" + rowCount].Value = loc.PrecinctCode + " - " + zone.Code;
i.Cells["B" + rowCount].Value = zoneUsersCount;
i.Cells["C" + rowCount].Value = zoneUsersWithOrders;
i.Cells["D" + rowCount].Value = zoneTotalUsers;
i.Cells["E" + rowCount].Value = zonePenetrationPerc;
i.Cells["E" + rowCount].Style.Numberformat.Format = percFormat;
rowCount++;
}
rowCount++;
}
//fit column width to content
i.Cells[i.Dimension.Address].AutoFitColumns();
}
