public DataTable adminUser(RequestAdminUser request)
{
try
{
DataTable response = new DataTable();
SqlParameter[] param = new SqlParameter[13];
DataBase db = new DataBase();
param[0] = new SqlParameter("@id", request.id);
param[1] = new SqlParameter("@idPerson", request.idPerson);
param[2] = new SqlParameter("@loginName", request.loginName);
param[3] = new SqlParameter("@personalKey", request.personalKey);
param[4] = new SqlParameter("@attemps", request.attemps);
param[5] = new SqlParameter("@name", request.name);
param[6] = new SqlParameter("@idRole", request.idRole);
param[7] = new SqlParameter("@stateRecord", request.stateRecord);
param[8] = new SqlParameter("@userRegister", request.userRegister);
param[9] = new SqlParameter("@dateRegister", request.dateRegister);
param[10] = new SqlParameter("@userUpdate", request.userUpdate);
param[11] = new SqlParameter("@dateUpdate", request.dateUpdate);
param[12] = new SqlParameter("@flag", request.flag);
response = db.executeDataTable("spAdminUser", param);
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult UpdateUser(ResponseAdminUserList item1, RequestAdminUser item2, ResponseAdminUserDetail item3, ResponseAdminUser item4)
{
if (ModelState.IsValid)
{
LogicAdminUser adm = new LogicAdminUser();
ResponseAdminUser response = new ResponseAdminUser();
item2.flag = 'M';
item2.dateUpdate = DateTime.Now;
item2.userUpdate = Session["user"].ToString();
item2.userRegister = "";
response = adm.setUser(item2);
if (response.code == 50000)
{
Session.Add("msgOk", response.message);
}
else
{
Session.Add("msgEr", response.message);
}
}
return(RedirectToAction("User"));
}
public ActionResult addUser(ResponseAdminUserList item1, RequestAdminUser item2, ResponseAdminUserDetail item3, ResponseAdminUser item4)
{
// Método para agregar Rol
if (ModelState.IsValid)
{
LogicAdminUser adm = new LogicAdminUser();
item2.id = 0;
item2.stateRecord = true;
item2.flag = 'N';
item2.dateRegister = DateTime.Now;
item2.userRegister = Session["user"].ToString();
item2.dateUpdate = DateTime.Now;
item2.userUpdate = Session["user"].ToString();
item2.profession = 9; // Profesión genérica
item4 = adm.setUser(item2);
if (item4.code == 50000)
{
Session.Add("msgOk", item4.message);
}
else
{
Session.Add("msgEr", item4.message);
}
}
Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser> response =
new Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser>(item1, item2, item3, item4);
return(RedirectToAction("User"));
}
public ActionResult UpdateUser(string id)
{
// Cargar los datos del usuario a modificar
RequestAdminUser req = new RequestAdminUser();
ResponseAdminUserList res = new ResponseAdminUserList();
LogicAdminUser logic = new LogicAdminUser();
req.id = int.Parse(id);
res = logic.getUserList(req);
// Recuperar los campos de la persona
RequestPerson reqPer = new RequestPerson();
ResponsePersonList resPer = new ResponsePersonList();
LogicAdminPerson logicPer = new LogicAdminPerson();
reqPer.id = res.lst[0].idPerson;
resPer = logicPer.getPerson(reqPer);
// Setear los campos del modelo
req.attemps = res.lst[0].attemps;
req.dateBorn = resPer.lst[0].dateBorn;
req.dateRegister = res.lst[0].dateRegister;
req.dateUpdate = res.lst[0].dateUpdate;
req.document = resPer.lst[0].document;
req.firstLastName = resPer.lst[0].firstLastName;
req.firstName = resPer.lst[0].firstName;
req.flag = 'M';
req.homeAddress = resPer.lst[0].homeAddress;
req.homePhone = resPer.lst[0].homePhone;
req.idRole = res.lst[0].idRole;
req.idPerson = res.lst[0].idPerson;
req.loginName = res.lst[0].loginName;
req.movilPhone1 = resPer.lst[0].movilPhone1;
req.movilPhone2 = resPer.lst[0].movilPhone2;
req.name = res.lst[0].name;
req.personalKey = res.lst[0].personalKey;
req.profession = resPer.lst[0].profession;
req.secondLastName = resPer.lst[0].secondLastName;
req.secondName = resPer.lst[0].secondName;
req.stateRecord = res.lst[0].stateRecord;
req.typeDocument = resPer.lst[0].typeDocument;
req.userRegister = res.lst[0].userRegister;
req.userUpdate = res.lst[0].userUpdate;
req.workPhone = resPer.lst[0].workPhone;
req.workplace = resPer.lst[0].workplace;
Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser> response =
new Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser>(res, req, null, null);
return(View(response));
}
public ActionResult User()
{
// Obtener el listado de Usuarios
RequestAdminUser req = new RequestAdminUser();
ResponseAdminUserList res = new ResponseAdminUserList();
LogicAdminUser logic = new LogicAdminUser();
req.id = 0;
res = logic.getUserList(req);
req.stateRecord = true;
Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser> response =
new Tuple <ResponseAdminUserList, RequestAdminUser, ResponseAdminUserDetail, ResponseAdminUser>(res, null, null, null);
return(View(response));
}
public ResponseAdminUser adminUser(RequestAdminUser request)
{
try
{
DataTable dt = new DataTable();
DataAdminUser datUser = new DataAdminUser();
ResponseAdminUser response = new ResponseAdminUser();
request.personalKey = LogicPrincipal.encryptSHA1(request.personalKey);
dt = datUser.adminUser(request);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
response.code = int.Parse(dt.Rows[0]["code"].ToString());
response.message = dt.Rows[0]["message"].ToString();
response.status = int.Parse(dt.Rows[0]["state"].ToString());
}
}
return(response);
}
catch (System.Data.SqlClient.SqlException exSql)
{
// Cuando sea una excepción por SQL ya vendrá el mensaje de error controlado
throw exSql;
}
catch (Exception ex)
{
// Registrar el error real
DataLogError datError = new DataLogError();
LogError error = new LogError();
error.module = "ADMIN";
error.method = "adminUser";
error.errorMessage = ex.Message;
error.moreInfo = request.id.ToString();
datError.newError(error);
// Modificar la excepción
Exception exResult = new Exception("Error no controlado, favor consultar con el administrador del sistema.");
throw exResult;
}
}
public DataTable getAdminUser(RequestAdminUser request)
{
try
{
DataTable response = new DataTable();
SqlParameter[] param = new SqlParameter[1];
DataBase db = new DataBase();
param[0] = new SqlParameter("@id", request.id);
response = db.executeDataTable("spGetAdminUser", param);
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public ResponseAdminUser adminUser(RequestAdminUser request)
{
ResponseAdminUser response = new ResponseAdminUser();
try
{
LogicAdminUser logicUser = new LogicAdminUser();
request.dateRegister = System.DateTime.Now;
request.dateUpdate = System.DateTime.Now;
response = logicUser.adminUser(request);
}
catch (System.Data.SqlClient.SqlException exSql)
{
// Cuando sea una excepción por SQL ya vendrá el mensaje de error controlado
response.code = exSql.ErrorCode;
response.message = exSql.Message;
response.status = exSql.State;
}
catch (Exception ex)
{
// Registrar el error real
LogicLogError logicError = new LogicLogError();
LogError error = new LogError();
error.module = "ADMIN";
error.method = "adminUser";
error.errorMessage = ex.Message;
error.moreInfo = request.id.ToString();
logicError.newError(error);
response.code = -1;
response.message = "Error no controlado, favor consultar con el administrador del sistema.";
}
return(response);
}
public ResponseAdminUser setUser(RequestAdminUser req)
{
ResponseAdminUser rUser = new ResponseAdminUser();
ResponsePerson rPerson = new ResponsePerson();
try
{
LogicCommon com = new LogicCommon();
string json = "";
int idPerson = req.idPerson;
int idUser = req.id;
// Primero Registrar la persona
if (req.flag != 'N')
{
req.id = idPerson;
}
json = com.HttpPost("Person/crudPerson", req);
rPerson = JsonConvert.DeserializeObject <ResponsePerson>(json);
if (rPerson.code == 50000)
{
if (req.flag == 'N')
{
req.idPerson = rPerson.status;
}
else
{
req.id = idUser;
}
// Completar el nombre completo para el usuario
req.name = req.firstName + " ";
req.name += req.secondName == null ? "" : req.secondName + " ";
req.name += req.firstLastName == null ? "" : req.firstLastName + " ";
req.name += req.secondLastName == null ? "" : req.secondLastName;
req.name = req.name.Trim();
// Ahora registrar el usuario
json = com.HttpPost("User/adminUser", req);
rUser = JsonConvert.DeserializeObject <ResponseAdminUser>(json);
// Revertir perfil de la persona, ya que no fue posible crear el usuario
if (rUser.code != 50000)
{
}
}
else
{
rUser.code = -1;
rUser.message = "Error creando el perfil de la persona, favor contactar con el administrador del sistema";
}
return(rUser);
}
catch (Exception ex)
{
rUser.code = -1;
rUser.message = ex.Message;
}
return(rUser);
}
public ResponseAdminUserList getUserList(RequestAdminUser req)
{
ResponseAdminUserList response = new ResponseAdminUserList();
try
{
LogicCommon com = new LogicCommon();
string json = com.HttpPost("User/getAdminUser", req);
response = JsonConvert.DeserializeObject <ResponseAdminUserList>(json);
// Cargar el listado completo de Roles
RequestAdminRole reqRole = new RequestAdminRole();
ResponseAdminRoleList resRole = new ResponseAdminRoleList();
LogicAdminRole logicRole = new LogicAdminRole();
List <SelectListItem> lstTmpRole = new List <SelectListItem>();
// Obtener el listado completo de Roles
reqRole.id = 0;
resRole = logicRole.getRoleList(reqRole);
// Llenar el listado de Roles
foreach (ResponseAdminRoleDetail r in resRole.lst)
{
lstTmpRole.Add(new SelectListItem
{
Text = r.detail,
Value = r.id.ToString(),
Selected = r.id == req.idRole ? true : false
});
}
// Agregar el listado de Roles
response.lstRole = lstTmpRole;
// Cargar el catálogo de tipos de documentos
RequestAdminClsMaster reqCls = new RequestAdminClsMaster();
ResponseAdminClsMasterList resCls = new ResponseAdminClsMasterList();
LogicAdminClsMaster logicCls = new LogicAdminClsMaster();
List <SelectListItem> lstTmpCls = new List <SelectListItem>();
// Obtener el catálogo de tipos de documentos
reqCls.catalogId = "TIPOSDOCUMENTO";
reqCls.child = true;
resCls = logicCls.getClsMasterList(reqCls);
// Llenar el listado de acuerdo al catálogo
foreach (ResponseAdminClsMasterDetail r in resCls.lst)
{
lstTmpCls.Add(new SelectListItem
{
Text = r.detail,
Value = r.id.ToString(),
Selected = r.id == req.typeDocument ? true : false
});
}
// Agregar el listado del catálogo documentos
response.lstTypeDocument = lstTmpCls;
return(response);
}
catch (Exception ex)
{
response.code = -1;
response.message = ex.Message;
}
return(response);
}
public ResponseAdminUserList getAdminUserList(RequestAdminUser request)
{
try
{
DataTable dt = new DataTable();
DataAdminUser datUser = new DataAdminUser();
ResponseAdminUserDetail adminUser;
ResponseAdminUserList response = new ResponseAdminUserList();
dt = datUser.getAdminUser(request);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
response.code = 1;
response.message = "Se encontraron registros";
response.status = 1;
response.lst = new List <ResponseAdminUserDetail>();
foreach (DataRow dr in dt.Rows)
{
adminUser = new ResponseAdminUserDetail();
adminUser.id = int.Parse(dr["id"].ToString());
adminUser.idPerson = int.Parse(dr["idPerson"].ToString());
adminUser.loginName = dr["loginName"].ToString();
adminUser.personalKey = dr["personalKey"].ToString();
adminUser.attemps = int.Parse(dr["attemps"].ToString());
adminUser.name = dr["name"].ToString();
adminUser.idRole = int.Parse(dr["idRole"].ToString());
adminUser.stateRecord = bool.Parse(dr["stateRecord"].ToString());
adminUser.userRegister = dr["userRegister"].ToString();
adminUser.dateRegister = DateTime.Parse(dr["dateRegister"].ToString());
adminUser.userUpdate = dr["userUpdate"].ToString();
adminUser.dateUpdate = DateTime.Parse(dr["dateUpdate"].ToString());
response.lst.Add(adminUser);
}
}
else
{
response.code = 0;
response.message = "No se encontraron registros";
response.status = 0;
}
}
else
{
response.code = 0;
response.message = "No se encontraron registros";
response.status = 0;
}
return(response);
}
catch (System.Data.SqlClient.SqlException exSql)
{
// Cuando sea una excepción por SQL ya vendrá el mensaje de error controlado
throw exSql;
}
catch (Exception ex)
{
// Registrar el error real
DataLogError datError = new DataLogError();
LogError error = new LogError();
error.module = "ADMIN";
error.method = "getAdminUserList";
error.errorMessage = ex.Message;
error.moreInfo = request.id.ToString();
datError.newError(error);
// Modificar la excepción
Exception exResult = new Exception("Error no controlado, favor consultar con el administrador del sistema.");
throw exResult;
}
}
