public OutUserOptions GetUserOptions(string executiveID, string ind_menu, string svrpath)
{
if (executiveID == "" || executiveID == null)
{
return(null);
}
string connectionString = DataBaseHelper.GetConnectionString("DLG");
OutUserOptions response = new OutUserOptions();
var ora = new OracleServer(connectionString);
UserOptions status;
List <UserOptions> list = new List <UserOptions>();
string command = string.Empty;
try
{
command = "select cedula, ind_menu_inicio, funcionalidad_nombre, ventana_objeto from dlg_portal_get_user_options";
command = command + string.Format(" where ind_menu_inicio = {0} and cedula = '{1}' ", ind_menu, executiveID);
var rdr = ora.ExecuteCommand(command);
while (rdr.Read())
{
status = new UserOptions();
status.funcionalidad_nombre = DBNull.Value.Equals(rdr["funcionalidad_nombre"]) ? string.Empty : rdr["funcionalidad_nombre"].ToString();
if (ind_menu == "5")
{
status.ventana_objeto = DBNull.Value.Equals(rdr["ventana_objeto"]) ? string.Empty : rdr["ventana_objeto"].ToString();
}
else
{
status.ventana_objeto = DBNull.Value.Equals(rdr["ventana_objeto"]) ? string.Empty : /*svrpath +*/ rdr["ventana_objeto"].ToString();
}
list.Add(status);
}
rdr.Close();
response.lstUserOptions = list;
response.msg = new Response
{
errorCode = "200",
errorMessage = "OK"
};
}
catch (Exception ex)
{
throw new Exception("UserDAO.GetUserOptions", ex);
}
finally
{
ora.Dispose();
}
return(response);
}
public OutUserOptions GetUserOptions(string executiveID, string ind_menu, string svrpath)
{
OutUserOptions userOptions = new OutUserOptions();
try
{
UserDAO dao = new UserDAO();
userOptions = dao.GetUserOptions(executiveID, ind_menu, svrpath);
dao.ChangeEstadoSoli(executiveID);
}
catch (Exception ex)
{
//escribir en el log
LogHelper.WriteLog("Models", "ManagerUser", "GetUserOptions", ex, "");
}
return(userOptions);
}
