public void setDatosProfesor(SessionDB session, EstadodeCuentaWebModel model) { if (sesion.tipouser == 'P' || sesion.tipouser == 'E') { //sesion.vdata["ID_PERSONA"] = sesion.pkUser.ToString(); if (sesion.vdata["HmeAclzn"] == "No") { sesion.vdata["Sede"] = model.GetSede(sesion.vdata["IDSIU"]); } sesion.vdata["ID_PERSONA"] = model.GetIdPersona(sesion.vdata["IDSIU"], sesion.vdata["Sede"]).ToString(); model.ID_PERSONA = sesion.vdata["ID_PERSONA"]; //string sql = "SELECT IDSIU FROM PERSONAS WHERE ID_PERSONA = '" + model.ID_PERSONA + "'"; //ResultSet res = db.getTable(sql); //if (res.Next()) // sesion.vdata["IDSIU"] = res.Get("IDSIU"); //sql = "SELECT TOP 1 CVE_SEDE FROM ESTADODECUENTA WHERE ID_PERSONA = " + sesion.pkUser + " ORDER BY FECHA_R"; //sql = "SELECT TOP 1 CVE_SEDE FROM ESTADODECUENTA WHERE ID_PERSONA = " + model.ID_PERSONA + " ORDER BY FECHA_R"; //res = db.getTable(sql); //if (res.Next()) // sesion.vdata["Sede"] = res.Get("CVE_SEDE"); //else // sesion.vdata["Sede"] = "UAN"; } model.IDSIU = sesion.vdata["IDSIU"]; model.Sede = sesion.vdata["Sede"]; model.ID_PERSONA = sesion.vdata["ID_PERSONA"]; model.GetDatos(); }