public IEnumerable<VR_Rendimiento_A_Academ> GetYearsByUser(string userName)
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
this.db = new SGA_DesarrolloEntities();
var years = (from y in db.VR_Rendimiento_A_Academ
join e in db.R_Estudiantes
on y.Estudiante equals e.IdPersona
join p in db.P_Personas
on e.IdPersona equals p.IdPersona
orderby y.A_Adem
where p.login_red == userName
select y
);
return years;
}
catch (System.Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}
public IEnumerable<R_RegistroNotas> GetGrades(string userName, int year, string period)
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
this.db = new SGA_DesarrolloEntities();
db.Configuration.ProxyCreationEnabled = false;
var grades = (from g in db.R_RegistroNotas.Include(g => g.R_Cursos)
join s in db.R_Estudiantes
on g.Estudiante equals s.IdPersona
where s.usuario == userName
&& g.A_Adem == year
&& g.Trimestre == period
select g);
return grades;
}
catch (System.Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}
public IEnumerable<P_Notas> GetOldUserMessages(string userName, int last)
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
IEnumerable<P_Notas> messages;
SGA_DesarrolloEntities context = new SGA_DesarrolloEntities();
context.Configuration.ProxyCreationEnabled = false;
messages = (from n in context.P_Notas
join p in context.P_Personas
on n.IdPersona equals p.IdPersona
where p.login_red == userName && n.idNota <= last
select n).Take(50);
return messages;
}
catch (Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}
public IEnumerable<VR_Rendimiento_Periodos> GetPeriodsByYearAndUser(string userName, int year)
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
this.db = new SGA_DesarrolloEntities();
var periods = (from p in db.VR_Rendimiento_Periodos
join e in db.R_Estudiantes
on p.Estudiante equals e.IdPersona
join pe in db.P_Personas
on e.IdPersona equals pe.IdPersona
where pe.login_red == userName
&& p.A_Adem == year
select p
);
return periods;
}
catch (System.Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}
private bool ValidateUser(LogOnModel model)
{
bool valid = false;
using (SGA_DesarrolloEntities context = new SGA_DesarrolloEntities())
{
valid = context.P_Personas.Count(p => p.login_red == model.UserName) > 0;
if (valid)
{
DirectoryEntry entry = new DirectoryEntry("LDAP://" + ConfigurationManager.AppSettings["Domain"].ToString(), model.UserName, model.Password);
//TODO: uncomment this line in server.
object nativeObject = entry.NativeObject;
}
}
return valid;
}
public IEnumerable<VR_Rendimiento_A_Academ> GetVR_Rendimiento_A_Academ()
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
this.db = new SGA_DesarrolloEntities();
return db.VR_Rendimiento_A_Academ.AsEnumerable();
}
catch (System.Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}
public IEnumerable<R_RegistroNotas> GetR_RegistroNotas()
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
this.db = new SGA_DesarrolloEntities();
var r_registronotas = db.R_RegistroNotas.Include(r => r.R_Estudiantes);
return r_registronotas.AsEnumerable();
}
catch (System.Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}
public VR_Rendimiento_A_Academ GetVR_Rendimiento_A_Academ(int id)
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
this.db = new SGA_DesarrolloEntities();
VR_Rendimiento_A_Academ vr_rendimiento_a_academ = db.VR_Rendimiento_A_Academ.Find(id);
if (vr_rendimiento_a_academ == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
return vr_rendimiento_a_academ;
}
catch (System.Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}
public IEnumerable<P_NotasPublicas> GetOldPublicMessages(int last)
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
SGA_DesarrolloEntities context = new SGA_DesarrolloEntities();
context.Configuration.ProxyCreationEnabled = false;
IEnumerable<P_NotasPublicas> notas;
notas = (from pm in context.P_NotasPublicas
where pm.Activa == true && pm.idNotasPublicas <= last
select pm).Take(50); ;
return notas;
}
catch (Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}
public R_RegistroNotas GetR_RegistroNotas(int id)
{
try
{
NameValueCollection user = HttpUtility.ParseQueryString(Request.RequestUri.Query);
Impersonate.ImpersonateUser(ConfigurationManager.AppSettings["Domain"].ToString(), user["UserName"], user["Password"]);
this.db = new SGA_DesarrolloEntities();
R_RegistroNotas r_registronotas = db.R_RegistroNotas.Find(id);
if (r_registronotas == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
return r_registronotas;
}
catch (System.Exception)
{
throw;
}
finally
{
Impersonate.UndoImpersonation();
}
}