public async Task <IActionResult> Edit(int id, [Bind("ID,Name,RoadNo")] AreaViewModel area)
{
if (id != area.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
Area _area = new Area();
_area.ID = area.ID;
_area.Name = area.Name;
_area.RoadNo = area.RoadNo;
_context.Update(_area);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AreaExists(area.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(area));
}
public string CreateArea(AreaViewModel areaViewModel)
{
if (ModelState.IsValid)
{
var result = iUnitOfWork.Repository <Area>().GetMany(x => x.Name == areaViewModel.AreaName).Any();
if (!result)
{
try
{
Area area = new Area();
area.Name = areaViewModel.AreaName;
area.IsActive = true;
area.CityId = areaViewModel.CityId;
iUnitOfWork.Repository <Area>().Add(area);
bool save = iUnitOfWork.Commit();
return("Added Successfully");
}
catch (Exception exception)
{
System.Diagnostics.Debug.WriteLine(exception);
return("Some internal Error Occure");
}
}
else
{
return("Area Already Exists");
}
}
return("Please try after some time");
}
// GET: Areas/Details/5
//public async Task<IActionResult> Details(int? id)
//{
// if (id == null)
// {
// return NotFound();
// }
// var area = await _context.Areas
// .FirstOrDefaultAsync(m => m.ID == id);
// if (area == null)
// {
// return NotFound();
// }
// return View(area);
//}
// GET: Areas/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
var area = await _context.Areas.FindAsync(id);
if (area == null)
{
return(NotFound());
}
if (HttpContext.Session.GetString("UserAdmin") != null)
{
AreaViewModel _area = new AreaViewModel();
_area.ID = area.ID;
_area.Name = area.Name;
_area.RoadNo = area.RoadNo;
return(View(_area));
}
else
{
return(RedirectToAction("Admin", "Account"));
}
}
public async Task <IActionResult> Create([FromBody] AreaViewModel avm)
{
try
{
CurrentUser cUser = new CurrentUser(HttpContext, _configuration);
avm.UserId = cUser.UserId;
avm.ReturnKey = 1;
avm.AreaId = 0;
avm.Active = "Y";
var result = await areaRepo.SaveOrUpdate(avm);
await auditLogService.LogActivity(cUser.UserId, cUser.HostIP, cUser.SessionId, "Area", "Area Created.");
return(Ok(result));
}
catch (CustomException cex)
{
var returnObj = new EmaintenanceMessage(cex.Message, cex.Type, cex.IsException, cex.Exception?.ToString());
return(StatusCode(StatusCodes.Status500InternalServerError, returnObj));
}
catch (Exception ex)
{
return(StatusCode(StatusCodes.Status500InternalServerError, new EmaintenanceMessage(ex.Message)));
}
}
public ViewResult Create(Navigator navigator)
{
AreaViewModel model = Utilities.ObjectFactory.CreateArea(navigator);
model.AreaName = String.Empty;
return(View("Create", model));
}
public async Task <IActionResult> Edit([Required][FromRoute] int id)
{
if (ModelState.IsValid)
{
try
{
AreaViewModel areaViewModel = new AreaViewModel
{
Id = id,
Areas = (await lawyerDbContext.GetAreaViewAsync())
.Where(m => m.Id == id)
.Select(m => new AreaMap
{
Name = m.Name,
Description = m.Description,
LanguageId = m.LanguageId
})
.OrderBy(m => m.LanguageId).ToList(),
Languages = await lawyerDbContext.Languages
.AsNoTracking()
.ToListAsync(),
MeetingMinute = (await lawyerDbContext.Areas.SingleOrDefaultAsync(m => m.Id == id)).MeetingMinute
};
return(View(areaViewModel));
}
catch { }
}
return(RedirectToAction(nameof(Index)));
}
public ActionResult SearchAreaList(AreaSearchFilter searchFilter)
{
Logger.Info(_logMsg.Clear().SetPrefixMsg("Search Area").ToInputLogString());
try
{
if (ModelState.IsValid)
{
_areaFacade = new AreaFacade();
var model = new AreaViewModel();
model.SearchFilter = searchFilter;
model.AreaList = _areaFacade.GetAreaList(model.SearchFilter);
ViewBag.PageSize = model.SearchFilter.PageSize;
// Logger.Info(_logMsg.Clear().SetPrefixMsg("Search Customer").ToSuccessLogString());
return(PartialView("~/Views/Area/_AreaList.cshtml", model));
}
return(Json(new
{
Valid = false,
Error = string.Empty
}));
}
catch (Exception ex)
{
Logger.Info(_logMsg.Clear().SetPrefixMsg("Search Area").ToFailLogString());
return(Error(new HandleErrorInfo(ex, this.ControllerContext.RouteData.Values["controller"].ToString(),
this.ControllerContext.RouteData.Values["action"].ToString())));
}
}
public IEnumerable <UsuarioViewModel> Get()
{
var usuarios = this.usuarioRepositorio
.ObterTodosComAreaEPerfil();
var usuariosViewModel = new List <UsuarioViewModel>();
foreach (var usuario in usuarios)
{
var viewModel = new UsuarioViewModel
{
Id = usuario.Id,
Ativo = usuario.Ativo,
Email = usuario.Email,
Expira = usuario.Expira,
ExpiraEm = usuario.ExpiraEm,
Nome = usuario.Nome,
Login = usuario.Login,
Senha = usuario.Senha,
Area = AreaViewModel.Criar(usuario.Area),
Perfil = PerfilViewModel.Criar(usuario.Perfil)
};
usuariosViewModel.Add(viewModel);
}
return(usuariosViewModel as IEnumerable <UsuarioViewModel>);
}
public AreaPage()
{
InitializeComponent();
BindingContext = viewModel = new AreaViewModel();
GemeindeListe.ItemsSource = viewModel.GemeindeListe;
KantonListe.ItemsSource = viewModel.KantonListe;
var selectedGemeinde = ApplicationHandler.Gemeinden.FirstOrDefault(x => x.Id == ApplicationHandler.AreaConfiguration.GemeindeId);
var selectedKanton = ApplicationHandler.Kantone.FirstOrDefault(x => x.Id == ApplicationHandler.AreaConfiguration.KantonId);
areaConfiguration = ApplicationHandler.AreaConfiguration;
if (selectedGemeinde == null && selectedKanton == null)
{
GemeindeListe.SelectedItem = GemeindeListe.Items.First();
KantonListe.SelectedItem = KantonListe.Items.First();
AllSwiss.IsToggled = true;
OnToggled(null, null);
}
else
{
if (selectedGemeinde != null)
{
GemeindeListe.SelectedItem = GemeindeListe.Items.Where(item => item == selectedGemeinde.Bezeichnung)
.FirstOrDefault();
GemeindeListe.SelectedIndex = GemeindeListe.Items.IndexOf(GemeindeListe.Items.Where(item => item == selectedGemeinde.Bezeichnung).FirstOrDefault());
}
if (selectedKanton != null)
{
KantonListe.SelectedItem = KantonListe.Items.Where(item => item == selectedKanton.Bezeichnung)
.FirstOrDefault();
KantonListe.SelectedIndex = KantonListe.Items.IndexOf(KantonListe.Items.Where(item => item == selectedKanton.Bezeichnung).FirstOrDefault());
}
}
}
public IActionResult Editar(AreaViewModel areaVM)
{
if (ModelState.IsValid)
{
try
{
AreasRepository areasRepository = new AreasRepository();
var areaResult = areasRepository.GetAreaByNombre(areaVM.SectorEstrategico.ToLower());
//Regex regex = new Regex(@"^[a-zA-ZñÑáéíóúÁÉÍÓÚ\s 0-9 ]+$");
Regex regex = new Regex(@"^[a-zA-ZñÑáéíóúÁÉÍÓÚ\s ]+$");
bool resultado = true;
resultado = regex.IsMatch(areaVM.SectorEstrategico);
if (!resultado)
{
ModelState.AddModelError("", "No se aceptan números y caracteres especiales en el nombre (Solo: a-z, A-Z).");
return(View(areaVM));
}
Regex regexNoNumStart = new Regex(@"[0-9]| $");
bool resultadoNoNumStart = false;
string textoFirstChart = areaVM.SectorEstrategico.Substring(0, 1);
resultadoNoNumStart = regexNoNumStart.IsMatch(textoFirstChart);
if (resultadoNoNumStart)
{
ModelState.AddModelError("", "No se permite iniciar con NÚMERO o con ESPACIO.");
return(View(areaVM));
}
if (areaResult == null)
{
areasRepository.UpdateAreaVM(areaVM);
return(RedirectToAction("Area", "Administrador"));
}
else if (areaResult.IdArea == areaVM.IdArea)
{
areaResult.SectorEstrategico = areaVM.SectorEstrategico;
areasRepository.Update(areaResult);
return(RedirectToAction("Area", "Administrador"));
}
else
{
ModelState.AddModelError("", "Ya existe este sector estrategico.");
return(View(areaVM));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
return(View(areaVM));
}
}
else
{
return(View(areaVM));
}
}
public ActionResult Search()
{
try
{
var areaVM = new AreaViewModel();
areaVM.SearchFilter = new AreaSearchFilter()
{
AreaName = string.Empty,
Status = string.Empty,
PageNo = 1,
PageSize = 15,
SortField = "AreaName",
SortOrder = "ASC"
};
ViewBag.PageSize = areaVM.SearchFilter.PageSize;
ViewBag.Message = string.Empty;
return(View(areaVM));
}
catch (Exception ex)
{
Logger.Info(_logMsg.Clear().SetPrefixMsg("List Area").ToFailLogString());
return(Error(new HandleErrorInfo(ex, this.ControllerContext.RouteData.Values["controller"].ToString(),
this.ControllerContext.RouteData.Values["action"].ToString())));
}
}
public AreaViewModel Update(AreaViewModel obj)
{
BeginTransaction();
_areaService.Update(Mapper.Map <AreaViewModel, Area>(obj));
Commit();
return(obj);
}
public IQueryable <Area> Buscar(AreaViewModel filtro)
{
IQueryable <Area> queryable = this.context.Areas;
if (filtro.Nombre != null && !string.IsNullOrEmpty(filtro.Nombre.Trim()))
{
queryable = queryable.Where(a => a.Nombre.Contains(filtro.Nombre.Trim()));
}
if (!string.IsNullOrEmpty(filtro.FechaCreacion))
{
DateTime desde = DateTime.Parse(filtro.FechaCreacion);
queryable = queryable.Where(a => a.FechaCreacion >= desde);
DateTime hasta = desde.AddDays(1).AddSeconds(-1);
queryable = queryable.Where(a => a.FechaCreacion <= hasta);
}
if (filtro.UltimoUsuarioModifico != null && !string.IsNullOrEmpty(filtro.UltimoUsuarioModifico.Trim()))
{
queryable = queryable.Where(a => a.UltimoUsuarioModifico.Contains(filtro.UltimoUsuarioModifico.Trim()));
}
if (!string.IsNullOrEmpty(filtro.FechaUltimaModificacion))
{
DateTime desde = DateTime.Parse(filtro.FechaUltimaModificacion);
queryable = queryable.Where(a => a.FechaUltimaModificacion >= desde);
DateTime hasta = desde.AddDays(1).AddSeconds(-1);
queryable = queryable.Where(a => a.FechaUltimaModificacion <= hasta);
}
return(queryable);
}
public void Salvar([FromBody] AreaViewModel areaViewModel)
{
Area area = null;
TipoTrilha tipoTrilha = TipoTrilha.Alteracao;
if (areaViewModel.Id == 0)
{
area = new Area();
tipoTrilha = TipoTrilha.Criacao;
}
else
{
area = this.areaRepositorio.ObterPorId(areaViewModel.Id);
tipoTrilha = TipoTrilha.Alteracao;
}
area.Ativo = areaViewModel.Ativo;
area.Nome = areaViewModel.Nome;
area.Abreviacao = areaViewModel.Abreviacao;
area.Segura = areaViewModel.Segura;
if (areaViewModel.Parent != null)
{
area.Parent = new Area {
Id = areaViewModel.Parent.Id
};
}
this.areaRepositorio.Salvar(area);
this.logarAcaoSistema.Execute(
tipoTrilha,
"Manutencao de Área",
"Area criada no sistema");
}
public ActionResult Update(AreaViewModel area)
{
if (area.AreaContract.IsValid())
{
var status = _areaService.Update(area.AreaContract);
switch (status)
{
case ResultStatus.Success:
return(RedirectToAction("Index"));
case ResultStatus.Failed:
ModelState.AddModelError("", string.Format("修改区域信息{0}失败", area.AreaContract.AreaName));
break;
}
}
var exists = _areaService.Get(properties: new[] { "Id", "AreaName" }).Select(p => new SelectListItem
{
Text = p.AreaName,
Value = p.Id.ToString(),
}).ToList();
ViewData["Areas"] = exists;
ViewData["AreaItem"] = area.AreaContract.ParentId;
ModelState.AddModelError("Error", area.AreaContract.ErrorMessage);
var areaInfo = _areaService.Get(area.AreaContract.Id);
if (areaInfo != null)
{
return(View(new AreaViewModel(areaInfo)));
}
throw new ItemNotExistException("指定区域不存在!");
}
public string ObtenerSubAreasByAreasIdQuery(AreaViewModel area)
{
string query = $"select * from SubArea where AreaId = '{area.Id}'";
return(string.Format(
CultureInfo.CurrentCulture, query));
}
public ActionResult MasterPartial(int masterCode)
{
AreaViewModel areaVM = masterCode == 0? new AreaViewModel() : Mapper.Map <Area, AreaViewModel>(_areaBusiness.GetArea(masterCode));
areaVM.IsUpdate = masterCode == 0 ? false : true;
return(PartialView("_AddArea", areaVM));
}
public ActionResult Criar()
{
if (ModelState.IsValid)
{
var cacheKey = "areas";
var cacheAreas = _distributedCache.GetString(cacheKey);
var areas = _mapper.Map <List <AreaViewModel> >(_areaRepository.ListarTodos().ToList());
if (!string.IsNullOrEmpty(cacheAreas))
{
areas = JsonConvert.DeserializeObject <List <AreaViewModel> >(cacheAreas);
}
var novaArea = new AreaViewModel()
{
IdArea = areas.Max(x => x.IdArea) + 1,
Descricao = "area " + (areas.Max(x => x.IdArea) + 1),
Status = ViewModel.Enum.StatusViewModel.statusAtual.ATIVADO
};
areas.Add(novaArea);
var distributedCacheOption = new DistributedCacheEntryOptions();
distributedCacheOption.SetAbsoluteExpiration(TimeSpan.FromMinutes(_configurationRedis.getConfiguration().tempoCacheMinutos));
_distributedCache.SetString(cacheKey, JsonConvert.SerializeObject(areas), distributedCacheOption);
Console.WriteLine("Adicionado nova area");
return(Ok());
}
Console.WriteLine("Erro ao adicionar area");
return(BadRequest(ModelState));
}
public ActionResult SearchSelectSubAreaList(SelectSubAreaSearchFilter searchFilter)
{
Logger.Info(_logMsg.Clear().SetPrefixMsg("Search SelectSubArea").ToInputLogString());
try
{
if (ModelState.IsValid)
{
_subAreaFacade = new SubAreaFacade();
var model = new AreaViewModel();
model.SelectSearchFilter = searchFilter;
model.SelectSubAreaList = _subAreaFacade.GetSelectSubAreaList(model.SelectSearchFilter);
ViewBag.PageSize = model.SelectSearchFilter.PageSize;
return(PartialView("~/Views/Area/_SelectSubAreaList.cshtml", model));
}
return(Json(new
{
Valid = false,
Error = string.Empty
}));
}
catch (Exception ex)
{
Logger.Error("Exception occur:\n", ex);
Logger.Info(_logMsg.Clear().SetPrefixMsg("Search SelectSubArea").Add("Error Message", ex.Message).ToFailLogString());
return(Error(new HandleErrorInfo(ex, this.ControllerContext.RouteData.Values["controller"].ToString(),
this.ControllerContext.RouteData.Values["action"].ToString())));
}
}
public async Task <IEnumerable <dynamic> > SaveOrUpdate([FromBody] AreaViewModel avm)
{
string sql = "dbo.EAppSaveArea";
using (var conn = util.MasterCon())
{
try
{
return(await(conn.QueryAsync <dynamic>(sql, new
{
avm.AreaId,
avm.PlantAreaId,
avm.LanguageId,
avm.AreaName,
avm.Descriptions,
avm.Active,
avm.UserId,
avm.ReturnKey
}, commandType: CommandType.StoredProcedure)));
}
catch (Exception ex)
{
throw new CustomException("Unable to Save Or Update, Please Contact Support!!!", "Error", true, ex);
}
}
}
private AreaViewModel GetAreaViewModel(long idArea)
{
AreaViewModel avm = new AreaViewModel();
avm.Area = dbContext.Area.SingleOrDefault(a => a.idArea == idArea);
avm.Subareas = dbContext.Subarea.Where(a => a.idArea == idArea).ToList();
return(avm);
}
public async Task <int> Guardar(AreaViewModel areaViewModel)
{
Area area = AutoMapper.Mapper.Map <Area>(areaViewModel);
await AreaRepository.Guardar(area);
return(area.Id);
}
public IActionResult Delete(AreaViewModel areaViewModel)
{
var area = _adminDatabaseContext.Areas.First(a => a.AreaId == areaViewModel.Id);
_adminDatabaseContext.Areas.Remove(area);
_adminDatabaseContext.SaveChanges();
return(RedirectToAction("Index"));
}
private void OpenAreaView(object obj)
{
var view = new AreaView();
AreaViewModel vm = new AreaViewModel(this);
view.DataContext = vm;
SelectedView = view;
}
/// <summary>
/// 实时界面数据刷新
/// </summary>
private void Page_Frush()
{
areaBase.AreaList.Clear();
foreach (var model in AreaViewModel.GetAreaList())
{
areaBase.AreaList.Add(model);
}
this.AreaDataGrid.ItemsSource = areaBase.AreaList;
}
/// <summary>
/// AreaViewModelToArea,
/// funcion que mapea las areasViewModel a Areas
/// </summary>
/// <param name="area">AreaViewModel a mapear a Areas</param>
/// <returns>Vista de modelo AreaViewModel</returns>
/// <author>Oscar Julian Rojas </author>
/// <date>09/06/2020</date>
public Area AreaViewModelToArea(AreaViewModel areaViewModel)
{
return(new Area
{
Id = areaViewModel.Id,
Nombre = areaViewModel.Name,
Codigo = areaViewModel.Code
});
}
public void InsertAreaVM(AreaViewModel area_VM)
{
Area area = new Area()
{
SectorEstrategico = area_VM.SectorEstrategico
};
Insert(area);
}
public AreaViewModel Add(AreaViewModel obj)
{
var area = Mapper.Map <AreaViewModel, Area>(obj);
BeginTransaction();
_areaService.Add(area);
Commit();
return(obj);
}
public async Task <ActionResult> Ver(string id)
{
AreaViewModel model = await AreaService.GetById(Int32.Parse(id));
model.Titulo = "Áreas";
ViewBag.Titulo = model.Titulo;
return(View(model));
}
// GET: Area/Create
public ActionResult Create()
{
var locationModel = _locationService.GetAll();
ViewBag.locationViewModel = Mapper.Map <IEnumerable <Location>, IEnumerable <LocationViewModel> >(locationModel);
var viewModel = new AreaViewModel();
return(View(viewModel));
}