public ActionResult Actuals() { ClientVisitListModel m = new ClientVisitListModel(); m.SearchCriteriaModel.IsActualInVisitGroup = true; return(Actuals(m)); }
public ActionResult Actuals(ClientVisitListModel clientVisitModel) { ClientVisitSearchCriteria criteria = clientVisitModel.SearchCriteriaModel.GetClientSearchCriteria(); criteria.IsActualInVisitGroup = true; DataPage <ClientVisitInfo> clients = clientBusinessLogic.ClientVisit_Find( criteria, new List <SortCriteria <ClientVisitSortField> >(), new PageRequest() { PageNumber = clientVisitModel.PageNumber, PageSize = clientVisitModel.PageSize }); ClientVisitListModel model = new ClientVisitListModel() { Items = clients.Data .Select(item => new ClientVisitInfoModel(item)), SearchCriteriaModel = new ClientVisitSearchCriteriaModel( criteria), PageNumber = clientVisitModel.PageNumber, PageSize = clientVisitModel.PageSize, TotalCount = clients.TotalCount }; return(View(model)); }
public ActionResult Index() { ClientVisitListModel model = new ClientVisitListModel(CurrentUser); if (TempData["ClientVisitSaveDataModel"] != null) { model.SearchCriteriaModel = (ClientVisitSearchCriteriaModel)TempData["ClientVisitSaveDataModel"]; DataPage <ClientVisitInfo> clients = clientBusinessLogic.ClientVisit_Find( model.SearchCriteriaModel.GetClientSearchCriteria(), new List <SortCriteria <ClientVisitSortField> >(), new PageRequest() { PageNumber = 1, PageSize = 100 }); model.Items = clients.Data .Select(item => new ClientVisitInfoModel(item)); } return(Index(model)); }
public ActionResult SNILSReport(SNILSReportModel model) { string NameDeliveryPoint = string.Empty; ClientVisitListModel clientVisitModel = new ClientVisitListModel(); clientVisitModel.SearchCriteriaModel.StatusDateFrom = model.DateSnilsFrom; clientVisitModel.SearchCriteriaModel.StatusDateTo = model.DateSnilsTo; //для Администраторов ограничений по точкам - нет if (Role.Administrator.Id == Role.GetRealRole(CurrentUser).Id || Role.AdministratorBSO.Id == Role.GetRealRole(CurrentUser).Id) { if (model.DeliveryPointIds.Count > 0) { clientVisitModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds; foreach (var item in model.DeliveryPointIds) { NameDeliveryPoint = NameDeliveryPoint + ", " + model.DeliveryPoints.Where(a => a.Value == item.ToString()).Select(b => b.Text).FirstOrDefault(); } NameDeliveryPoint = NameDeliveryPoint.Trim(',', ' '); } else { NameDeliveryPoint = "Все точки"; } } else { //для ответственного if (Role.ResponsibleBSO == Role.GetRealRole(CurrentUser)) { if (model.DeliveryPointIds.Count > 0) { clientVisitModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds; } else {//все точки для ответственного model.DeliveryPoints = ReferencesProvider.GetDeliveryPointsForResponsibleBSO(CurrentUser.Id, false); foreach (var item in model.DeliveryPoints) { if (item.Value != "") { model.DeliveryPointIds.Add(long.Parse(item.Value)); } } clientVisitModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds; } foreach (var item in model.DeliveryPointIds) { NameDeliveryPoint = NameDeliveryPoint + ", " + model.DeliveryPoints.Where(a => a.Value == item.ToString()).Select(b => b.Text).FirstOrDefault(); } NameDeliveryPoint = NameDeliveryPoint.Trim(',', ' '); } else { //для всех остальных, только по их собственной точке clientVisitModel.SearchCriteriaModel.DeliveryPointIds = new List <long>() { CurrentUser.DeliveryPoint.Id }; model.DeliveryPointIds = new List <long>() { CurrentUser.DeliveryPoint.Id }; NameDeliveryPoint = model.DeliveryPoints.Where(a => a.Value == model.DeliveryPointIds.FirstOrDefault().ToString()).Select(b => b.Text).FirstOrDefault(); } } ClientVisitSearchCriteria criteria = clientVisitModel.SearchCriteriaModel.GetClientSearchCriteria(); criteria.IsActualInVisitGroup = true; List <ClientVisitInfo> clients = clientBusinessLogic.ClientVisit_Find( criteria, new List <SortCriteria <ClientVisitSortField> >(), new PageRequest() { PageNumber = 1, PageSize = int.MaxValue }).Data; //Отсекаем только гр. РФ clients = clients.Where(a => a.Citizenship == "РОССИЯ").ToList(); // Все статусы кроме: "ошибочная запись код 6", "выдан и отправлен в фонд код 11", "изготовлен другой компанией код 7", "перерегистрация завершена код 8" clients = clients.Where(a => !(a.Status.Code == "6" || a.Status.Code == "11" || a.Status.Code == "7" || a.Status.Code == "8") ).ToList(); //Отсекаем по СНИЛС //нет СНИЛС //заявкой без СНИЛС является любая заявка, где поле СНИЛС заполнено иначе, чем XXX-XXX-XXX YY if (model.IsSnilsNotEmpty == false) { clients = clients.Where(a => (string.IsNullOrEmpty(a.SNILS) || !(a.SNILS.Length == 14 && a.SNILS[3] == '-' && a.SNILS[7] == '-' && a.SNILS[11] == ' '))).ToList(); } //есть СНИЛС if (model.IsSnilsNotEmpty == true) { clients = clients.Where(a => (!string.IsNullOrEmpty(a.SNILS)) && (a.SNILS.Length == 14 && a.SNILS[3] == '-' && a.SNILS[7] == '-' && a.SNILS[11] == ' ')).ToList(); } List <Entities.User> listUser = userBusinessLogic.Find(""); SNILSReport printedForm = new SNILSReport(clients, model.DateSnilsFrom, model.DateSnilsTo, NameDeliveryPoint, CurrentUser.Fullname, model.IsSnilsNotEmpty, listUser); return(File(printedForm.GetExcel(), System.Net.Mime.MediaTypeNames.Application.Octet, string.Format("Заявки и наличие СНИЛС.xlsx"))); }