public ActionResult OperarMenu(Models.Data.Menu model)
{
try
{
if (ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
if (model.IdMenu <= 0)
{
db.Menu.Add(model);
db.SaveChanges();
//model.Add();
}
else
{
var original = db.Menu.Find(model.IdMenu);
if (original != null)
{
db.Entry(original).CurrentValues.SetValues(model);
db.SaveChanges();
}
// model.Update();
}
}
}
catch (Exception ex)
{
ModelState.AddModelError("s", ex);
}
return(PartialView("Menu", model));
}
public ActionResult DeleteUserToRole(int pIdRole, int pIdUser)
{
try
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
UsuarioPorRol model = db.UsuarioPorRol.Where(x => x.IdRol == pIdRole && x.IdUsuario == pIdUser).FirstOrDefault();
db.UsuarioPorRol.Attach(model);
db.Entry(model).State = EntityState.Deleted;
HistoricoUsuarioPorRol model2 = new HistoricoUsuarioPorRol();
model2.IdRol = model.IdRol;
model2.IdUsuario = model.IdUsuario;
model2.TransacUser = model.TransacUser;
model2.TransacDateTime = model.TransacDateTime;
model2.HistoricTransacUser = "******";
model2.HistoricTransacDateTime = DateTime.Now;
db.HistoricoUsuarioPorRol.Add(model2);
db.SaveChanges();
return(Json(new { success = true, error = "" }));
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex.Message }));
}
}
public ActionResult User_Create([DataSourceRequest] DataSourceRequest request, ViewModelUsuario model)
{
try
{
if (model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
Usuario efModel = new Usuario
{
GE_Persona = model.GE_Persona.CopyPropertiesTo(new GE_Persona()),
IdPersona = model.IdPersona,
IdTipoUsuario = model.IdTipoUsuario,
NombreUsuario = model.NombreUsuario,
};
efModel.Contraseña = model.NombreUsuario.Encrypt();
efModel.Activo = true;
model.GE_Persona.Id = db.GE_Persona.Max(x => x.Id) + 1;
db.GE_Persona.Add(efModel.GE_Persona);
db.Usuario.Add(efModel);
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult Object_Create([DataSourceRequest] DataSourceRequest request, ViewModelObjeto model)
{
try
{
if (model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
Objeto obj = new Objeto
{
Activo = true,
Descripcion = model.Description,
IdObjetoPadre = model.IdNewPermissionParent,
IdProducto = model.IdProduct,
Nombre = model.Name
};
db.Objeto.Add(obj);
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError("Model", ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult GlobalParameter_Create([DataSourceRequest] DataSourceRequest request, ViewModelParametroGeneral model)
{
try
{
ParametroGeneral efModel = model.CopyPropertiesTo(new ParametroGeneral());
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
efModel.Activo = true;
efModel.TransacUser = this.HttpContext.GetActualUser().NombreUsuario;
efModel.TransacDateTime = DateTime.Now;
if (ModelState.IsValid)
{
try
{
switch (efModel.IdParametroTipo)
{
case (int)EParametroTipo.String:
Convert.ToString(model.Valor);
break;
case (int)EParametroTipo.Entero:
Convert.ToInt32(model.Valor);
break;
case (int)EParametroTipo.Decimal:
Convert.ToDecimal(model.Valor);
break;
case (int)EParametroTipo.Booleano:
Convert.ToBoolean(model.Valor);
break;
case (int)EParametroTipo.FechaHora:
Convert.ToDateTime(model.Valor);
break;
case (int)EParametroTipo.Hora:
Convert.ToDateTime(model.Valor);
break;
case (int)EParametroTipo.EncryptString:
BarcoSoftUtilidades.Utilidades.Cryptography.Decrypt(model.Valor);
break;
}
db.ParametroGeneral.Add(efModel);
db.SaveChanges();
}
catch (Exception ex)
{
ModelState.AddModelError("Valor", ex.Message);
}
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult Product_Create([DataSourceRequest] DataSourceRequest request, Producto model)
{
if (model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
model.Activo = true;
db.Producto.Add(model);
db.SaveChanges();
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult GlobalParameter_Update([DataSourceRequest] DataSourceRequest request, ViewModelParametroGeneral model)
{
try
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
var original = db.ParametroGeneral.Find(model.IdParametroGeneral);
model.TransacUser = this.HttpContext.GetActualUser().NombreUsuario;
model.TransacDateTime = DateTime.Now;
if (ModelState.IsValid && original != null)
{
switch (model.IdParametroTipo)
{
case (int)EParametroTipo.Entero:
Convert.ToInt32(model.Valor);
break;
case (int)EParametroTipo.Decimal:
Convert.ToDecimal(model.Valor);
break;
case (int)EParametroTipo.Booleano:
Convert.ToBoolean(model.Valor);
break;
case (int)EParametroTipo.FechaHora:
Convert.ToDateTime(model.Valor);
break;
case (int)EParametroTipo.Hora:
Convert.ToDateTime(model.Valor);
break;
case (int)EParametroTipo.EncryptString:
BarcoSoftUtilidades.Utilidades.Cryptography.Decrypt(model.Valor);
break;
}
db.Entry(original).CurrentValues.SetValues(model);
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult Owner_Create([DataSourceRequest] DataSourceRequest request, Propietario model)
{
try
{
if (model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
model.Activo = true;
db.Propietario.Add(model);
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult Product_Update([DataSourceRequest] DataSourceRequest request, Producto model)
{
try
{
if (model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
db.Producto.Attach(model);
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult AddUserToRole(int pIdRole, int pIdUser)
{
try
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
UsuarioPorRol model = new UsuarioPorRol();
model.IdRol = pIdRole;
model.IdUsuario = pIdUser;
model.TransacUser = "******";
model.TransacDateTime = DateTime.Now;
db.UsuarioPorRol.Add(model);
db.SaveChanges();
return(Json(new { success = true, error = "" }));
}
catch (Exception ex)
{
return(Json(new { success = false, error = ex.Message }));
}
}
public ActionResult Role_Update([DataSourceRequest] DataSourceRequest request, Rol model)
{
try
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
var original = db.Rol.Find(model.IdRol);
if (model != null && ModelState.IsValid && original != null)
{
db.Entry(original).CurrentValues.SetValues(model);
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError("Model", ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult UserType_Create([DataSourceRequest] DataSourceRequest request, ViewModelTipoUsuario model)
{
try
{
TipoUsuario efModel = model.CopyPropertiesTo(new TipoUsuario());
if (model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
efModel.Activo = true;
efModel.IdTipoUsuario = db.TipoUsuario.Max(x => x.IdTipoUsuario) + 1;
db.TipoUsuario.Add(efModel);
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult UserType_Destroy([DataSourceRequest] DataSourceRequest request, TipoUsuario model)
{
try
{
if (model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
model.Activo = false;
db.TipoUsuario.Attach(model);
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult User_Destroy([DataSourceRequest] DataSourceRequest request, ViewModelUsuario model)
{
try
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
var original = db.Usuario.Find(model.IdUsuario);
model.Activo = false;
if (ModelState.IsValid && original != null)
{
db.Entry(original).CurrentValues.SetValues(model);
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult GlobalParameter_Destroy([DataSourceRequest] DataSourceRequest request, ViewModelParametroGeneral model)
{
try
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
var original = db.ParametroGeneral.Find(model.IdParametroGeneral);
model.TransacUser = this.HttpContext.GetActualUser().NombreUsuario;
model.TransacDateTime = DateTime.Now;
model.Activo = false;
if (ModelState.IsValid && original != null)
{
db.Entry(original).CurrentValues.SetValues(model);
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError(string.Empty, ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult Object_Destroy([DataSourceRequest] DataSourceRequest request, ViewModelObjeto model, bool pOperar)
{
try
{
if (pOperar && model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
Objeto obj = db.Objeto.Where(x => x.IdObjeto == model.IdPermission).FirstOrDefault();
obj.Activo = false;
db.Objeto.Attach(obj);
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError("Model", ex.Message);
//throw new Exception(ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
public ActionResult Object_Update([DataSourceRequest] DataSourceRequest request, ViewModelObjeto model)
{
try
{
if (model != null && ModelState.IsValid)
{
Models.Data.EkiibrateDBEntities db = new Models.Data.EkiibrateDBEntities(true);
Objeto obj = db.Objeto.Where(x => x.IdObjeto == model.IdPermission).FirstOrDefault();
obj.Activo = true;
obj.Nombre = model.Name;
obj.Descripcion = model.Description;
obj.IdObjetoPadre = model.IdNewPermissionParent;
db.Objeto.Attach(obj);
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
ModelState.AddModelError("Model", ex.Message);
}
return(Json(new[] { model }.ToDataSourceResult(request, ModelState)));
}
