private void ConfigureEntitRolesTable(DbModelBuilder modelBuilder, string discriminator)
{
var roles = modelBuilder.Entity <IdentityRole>().ToTable(UtilAut.GetTableRoles(), UtilAut.GetSchema());
roles.Map <AppRole>(appRole => appRole.Requires(discriminator).HasValue("APPROLE"));
roles.HasMany(role => role.Users).WithRequired().HasForeignKey(uRol => uRol.RoleId);
}
public async Task <ActionResult> Edit(AppRole appRole)
{
if (!ValidateModel(appRole, ModelState))
{
return(View(appRole));
}
var role = RoleManager.FindById(appRole.Id);
if (role == null)
{
ModelState.AddModelError(UtilGral.ERROR_FROM_CONTROLLER, "El Área no existe");
return(View(appRole));
}
if (role.Id == Guid.Empty.ToString())
{
ModelState.AddModelError(UtilGral.ERROR_FROM_CONTROLLER, "NOTA: El área pública no se puede deshabilitar");
appRole.activo = true;
}
role.activo = appRole.activo;
role.Name = appRole.Name;
role.ModificationUserName = UtilAut.GetUserId();
role.ModificationDate = DateTime.Now;
await RoleManager.UpdateAsync(role);
return(RedirectToAction("Index"));
}
public IdentityDBContext()
: base(UtilAut.GetConnectionString(), throwIfV1Schema: false)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <IdentityDBContext, IdentityConfiguration>());
Configuration.ProxyCreationEnabled = false;
Configuration.LazyLoadingEnabled = false;
}
private void ConfigureEntityUsersTable(DbModelBuilder modelBuilder, string discriminator)
{
var users = modelBuilder.Entity <IdentityUser>().ToTable(UtilAut.GetTableUsers(), UtilAut.GetSchema());
users.Map <AppUser>(appUser => appUser.Requires(discriminator).HasValue("APPUSER"));
users.HasMany(user => user.Roles).WithRequired().HasForeignKey(rUsers => rUsers.UserId);
users.HasMany(user => user.Claims).WithRequired().HasForeignKey(uClaims => uClaims.UserId);
users.HasMany(user => user.Logins).WithRequired().HasForeignKey(uLogins => uLogins.UserId);
}
public ActionResult Create()
{
Modelo modelo = new Modelo();
modelo.usr_crea = UtilAut.GetUserId();
modelo.fec_crea = DateTime.Now;
GetMarcas(null);
return(View(modelo));
}
// GET: Marcas/Create
public ActionResult Create()
{
var marca = new Marca();
marca.usr_crea = UtilAut.GetUserId();
marca.fec_crea = DateTime.Now;
marca.id = 0;
return(View(marca));
}
public ActionResult Create()
{
var transporte = new Transporte();
transporte.fec_crea = DateTime.Now;
transporte.usr_crea = UtilAut.GetUserId();
GetTipoTransporte(null);
return(View(transporte));
}
public ActionResult Create()
{
TipoTransporte tipTrans = new TipoTransporte();
tipTrans.usr_crea = UtilAut.GetUserId();
tipTrans.fec_crea = DateTime.Now;
tipTrans.id = 0;
GetMarcas(null);
return(View(tipTrans));
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
var discriminator = "DISC";
modelBuilder.Entity <IdentityUserRole>().ToTable(UtilAut.GetTableUserRoles(), UtilAut.GetSchema())
.HasKey(userRole => new { userRole.UserId, userRole.RoleId });
modelBuilder.Entity <IdentityUserLogin>().ToTable(UtilAut.GetTableLogins(), UtilAut.GetSchema())
.HasKey(userLogin => new { userLogin.UserId, userLogin.ProviderKey, userLogin.LoginProvider });
modelBuilder.Entity <IdentityUserClaim>().ToTable(UtilAut.GetTableClaims(), UtilAut.GetSchema());
ConfigureEntityUsersTable(modelBuilder, discriminator);
ConfigureEntitRolesTable(modelBuilder, discriminator);
}
public async Task <ActionResult> Edit(Pais pais)
{
if (ModelState.IsValid)
{
pais.fec_modif = DateTime.Now;
pais.usr_modif = UtilAut.GetUserId();
db.Entry(pais).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(pais));
}
public async Task <ActionResult> Edit(Marca marca)
{
if (ModelState.IsValid)
{
marca.usr_modif = UtilAut.GetUserId();
marca.fec_modif = DateTime.Now;
db.Entry(marca).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View("Create", marca));
}
public ActionResult Create()
{
Chofere chofer = new Chofere();
chofer.usr_crea = UtilAut.GetUserId();
chofer.fec_crea = DateTime.Now;
chofer.Persona = new Persona()
{
usr_crea = UtilAut.GetUserId(),
fec_crea = DateTime.Now,
activo = true
};
return(View(chofer));
}
public async Task <ActionResult> Create(Pais pais)
{
if (ModelState.IsValid)
{
pais.fec_crea = DateTime.Now;
pais.usr_crea = UtilAut.GetUserId();
db.Paises.Add(pais);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(pais));
}
public async Task <ActionResult> Create(Menu menuView)
{
if (string.IsNullOrEmpty(menuView.name) ||
string.IsNullOrEmpty(menuView.url))
{
return(View(menuView));
}
menuView.usr_crea = UtilAut.GetUserId();
menuView.fec_crea = DateTime.Now;
Menu.RemoveUnassignedArea(menuView);
db.Menus.Add(menuView);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit(TipoTransporte tipoTransporte)
{
if (ModelState.IsValid)
{
tipoTransporte.usr_modif = UtilAut.GetUserId();
tipoTransporte.fec_modif = DateTime.Now;
db.Entry(tipoTransporte).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
GetMarcas(tipoTransporte);
return(View("Create", tipoTransporte));
}
public async Task <ActionResult> Edit(Chofere chofere)
{
if (ModelState.IsValid)
{
chofere.usr_modif = UtilAut.GetUserId();
chofere.fec_modif = DateTime.Now;
chofere.Persona.usr_modif = UtilAut.GetUserId();
chofere.Persona.fec_modif = DateTime.Now;
db.Entry(chofere.Persona).State = EntityState.Modified;
db.Entry(chofere).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(chofere));
}
public async Task <PartialViewResult> AddState(Estado estado)
{
if (Request.IsAjaxRequest())
{
Pais pais = await db.Paises.FindAsync(estado.id_pais);
pais.Estados.Add(new Estado()
{
nombre = estado.nombre,
activo = true,
usr_crea = UtilAut.GetUserId(),
fec_crea = DateTime.Now
});
db.Entry(pais).State = EntityState.Modified;
await db.SaveChangesAsync();
return(PartialView("EstadoLista", pais.Estados));
}
return(PartialView("_ErrorParcial"));
}
// GET: Rutas/Create
public ActionResult Create()
{
Ruta ruta = new Ruta()
{
usr_crea = UtilAut.GetUserId(),
fec_crea = DateTime.Now,
Direccione = new Direccione()
{
usr_crea = UtilAut.GetUserId(),
fec_crea = DateTime.Now,
activo = true
},
Direccione1 = new Direccione()
{
usr_crea = UtilAut.GetUserId(),
fec_crea = DateTime.Now,
activo = true
}
};
return(View("Create", ruta));
}
public async Task <ActionResult> Edit(Menu menuView)
{
if (string.IsNullOrEmpty(menuView.name) ||
string.IsNullOrEmpty(menuView.url))
{
return(View(menuView));
}
Menu menu = await db.Menus.FindAsync(menuView.id);
if (menu == null)
{
ModelState.AddModelError(UtilGral.ERROR_FROM_CONTROLLER, "El Menú no existe");
return(View(menuView));
}
menu.usr_modif = UtilAut.GetUserId();
menu.fec_modif = DateTime.Now;
Menu.UpdateMenus(menu, menuView.MenuByAreas);
db.Entry(menu).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create(AppRole appRole)
{
if (!ValidateModel(appRole, ModelState))
{
return(View(appRole));
}
var role = RoleManager.FindByName(appRole.Name);
if (role != null)
{
ModelState.AddModelError(UtilGral.ERROR_FROM_CONTROLLER, "El Área ya existe");
return(View(appRole));
}
var result = await RoleManager.CreateAsync(new AppRole {
activo = appRole.activo,
CreationDate = DateTime.Now,
CreationUserName = UtilAut.GetUserId(),
Name = appRole.Name
});
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create(AppUser appUser)
{
if (InValidUser(appUser))
{
return(View(appUser));
}
var user = UserManager.FindByName(appUser.User);
if (user != null)
{
ModelState.AddModelError(UtilGral.ERROR_FROM_CONTROLLER, "El usuario ya existe");
return(View(appUser));
}
user = new AppUser()
{
UserName = appUser.User,
Email = appUser.Email,
EmailConfirmed = true,
FirstName = appUser.FirstName,
LastName = appUser.LastName,
CreationDate = DateTime.Now,
CreationUserName = UtilAut.GetUserId(),
Password = appUser.Password,
User = appUser.User,
PhoneNumber = appUser.PhoneNumber,
activo = appUser.activo
};
var result = await UserManager.CreateAsync(user, appUser.Password);
var roles = appUser.RolesByUser.Where(role => role.Asignado).Select(role => role.Name).ToArray();
if (roles.Length > 0)
{
UserManager.AddToRoles(user.Id, roles);
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit(Ruta ruta)
{
ruta.Direccione.Estado = await db.Estados.FindAsync(ruta.Direccione.id_estado);
ruta.Direccione1.Estado = await db.Estados.FindAsync(ruta.Direccione1.id_estado);
ruta.fec_modif = DateTime.Now;
ruta.usr_modif = UtilAut.GetUserId();
ruta.Direccione.fec_modif = DateTime.Now;
ruta.Direccione.usr_modif = UtilAut.GetUserId();
ruta.Direccione1.fec_modif = DateTime.Now;
ruta.Direccione1.usr_modif = UtilAut.GetUserId();
if (ModelState.IsValid)
{
db.Entry(ruta.Direccione1).State = EntityState.Modified;
db.Entry(ruta.Direccione).State = EntityState.Modified;
db.Entry(ruta).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View("Create", ruta));
}
public TransprtEntities()
: base(UtilAut.GetConnectionString())
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <TransprtEntities, TransprtConfiguration>());
}
