public UserAccount GetUser(long id)
{
using (var context = new QualificationsDBEntities())
{
return(context.UserAccount.FirstOrDefault(x => x.UserAccountId == id));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
value = true;
string nombrePrograma = ddl_Programas.SelectedValue;
if (nombrePrograma != "")
{
ProgramaID = proxyProgram.GetProgramID(nombrePrograma);
using (var context = new QualificationsDBEntities())
{
//QualificationsDBEntities context = new QualificationsDBEntities();
var pensum = from p in context.Pensum
join m in context.Module
on p.ModuleCode equals m.ModuleCode
join pr in context.GraduateProgram
on p.GraduateProgram equals pr.GraduateProgramaId
where p.GraduateProgram == ProgramaID
orderby m.ModuleName.Substring(0, 1) ascending
select new
{
Modulo = m.ModuleName,
Modalidad = m.Mode
};
GridView1.DataSource = pensum;
GridView1.DataBind();
}
}
//ddl_Programas.Items.Clear();
}
public void GetAll()
{
using (SqlConnection con = new SqlConnection("Data Source=DV41117NR\\SQLEXPRESS2008;Initial Catalog=QualificationsDB;User ID=sa;Password=123qwe;"))
{
QualificationsDBEntities context = new QualificationsDBEntities();
var user = from u in context.UserAccount
join p in context.Person
on u.UserAccountId equals p.PersonId
join ust in context.ListAccountStatus
on u.AccountStatus equals ust.UserStatusCode
join urole in context.UserRole
on u.UserAccountId equals urole.UserAccountId
join lr in context.ListRole
on urole.RoleCode equals lr.RoleCode
where lr.RoleName == "Docente" || lr.RoleName == "Estudiante"
select new
{
Cuenta = u.Account,
Password = u.Password,
Nombre = p.Name,
ApellidoPaterno = p.FirstName,
ApellidoMaterno = p.LastName,
Profesión = p.Profession,
FechaCreación = p.CreateDate,
Actualización = p.VersionDate,
Estado = ust.UserStatusDescription,
Rol = lr.RolDescription
};
GridView1.DataSource = user;
GridView1.DataBind();
}
}
public void ListaEstudiantesModulo(long ModuloId, int versionId)
{
using (var context = new QualificationsDBEntities())
{
var reporte = from sm in context.StudentModule
join p in context.Person
on sm.Student equals p.PersonId
join tm in context.TeachingModule
on sm.TeachingModuleCode equals tm.TeachingModuleCode
join op in context.OpeningProgram
on tm.OpeningCode equals op.OpeningCode
join m in context.Module
on tm.ModuleCode equals m.ModuleCode
join gp in context.GraduateProgram
on op.ProgramId equals gp.GraduateProgramaId
join v in context.Version
on op.Version equals v.ID
where m.ModuleCode == ModuloId && op.Version == versionId
orderby p.Name.Substring(0, 1) ascending
select new
{
Código = p.PersonId,
Nombre = p.Name + " " + p.FirstName + " " + p.LastName,
};
GridView1.DataSource = reporte;
GridView1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string value = TextBox1.Text;
using (var context = new QualificationsDBEntities())
{
var teachmod = from tm in context.TeachingModule
join u in context.UserAccount
on tm.Teacher equals u.UserAccountId
join p in context.Person
on u.UserAccountId equals p.PersonId
join op in context.OpeningProgram
on tm.OpeningCode equals op.OpeningCode
join m in context.Module
on tm.ModuleCode equals m.ModuleCode
join gp in context.GraduateProgram
on op.ProgramId equals gp.GraduateProgramaId
join v in context.Version
on op.Version equals v.ID
where m.ModuleName == value
orderby p.Name.Substring(0, 1) ascending
select new
{
Docente = p.Name + " " + p.FirstName + " " + p.LastName,
Módulo = m.ModuleName,
Programa = gp.ProgramName,
Versión = v.ProgramVersion,
Inicio = tm.ModuleStartDate,
Fin = tm.ModuleEndDate
};
GridView1.DataSource = teachmod;
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if ((string)Session["value"] == "false")
//{
int count = 0;
proxyProgram = new AcademicServiceClient("WSHttpBinding_IAcademicService");
proxyModule = new ModuleAdminServiceClient("WSHttpBinding_IModuleAdminService");
proxyAsignation = new ModuleAsigAdminServiceClient("WSHttpBinding_IModuleAsigAdminService");
if (!IsPostBack)
{
using (var context = new QualificationsDBEntities())
{
//QualificationsDBEntities context = new QualificationsDBEntities();
var program = from p in context.GraduateProgram
orderby p.ProgramName.Substring(0, 1) ascending
select p;
foreach (var query in program)
{
//Añadiendo al DropDownList con los nombres de los Programas de Postgrado
ddl_Programas.Items.Insert(count, query.ProgramName);
count = count + 1;
}
//Session["value"] = "true"; //inicializado en el WebForm Authentication
}
}
//}
}
public EvaluationPlan GetPlanEvaluacion(long planId)
{
using (var context = new QualificationsDBEntities())
{
return(context.EvaluationPlan.FirstOrDefault(x => x.EvaluationCode == planId));
}
}
public void programasPostgrado()
{
int count = 0;
string nombre = string.Empty;
using (SqlConnection con = new SqlConnection("Data Source=DV41117NR\\SQLEXPRESS2008;Initial Catalog=QualificationsDB;User ID=sa;Password=123qwe;"))
{
QualificationsDBEntities context = new QualificationsDBEntities();
var user = from op in context.OpeningProgram
join p in context.GraduateProgram
on op.ProgramId equals p.GraduateProgramaId
join v in context.Version
on op.Version equals v.ID
join s in context.StatusOpening
on op.Status equals s.ID
where op.Status == 1
orderby v.ID
select new
{
ID = op.ProgramId,
nombre = op.ProgramId
};
ddl_Programas.DataSource = user;
ddl_Programas.DataTextField = "nombre";
ddl_Programas.DataValueField = "ID";
ddl_Programas.DataBind();
}
}
public void versiones(long id)
{
using (var context = new QualificationsDBEntities())
{
//QualificationsDBEntities context = new QualificationsDBEntities();
var openprogram = from op in context.OpeningProgram
join p in context.GraduateProgram
on op.ProgramId equals p.GraduateProgramaId
join v in context.Version
on op.Version equals v.ID
join s in context.StatusOpening
on op.Status equals s.ID
where op.Status == 1 && op.ProgramId == id
orderby v.ID
select new
{
ID = v.ID,
Version = v.ProgramVersion
};
ddl_Versiones.DataSource = openprogram;
ddl_Versiones.DataTextField = "Version";
ddl_Versiones.DataValueField = "ID";
ddl_Versiones.DataBind();
}
}
public StudentModule GetStudentModule(long id)
{
using (var context = new QualificationsDBEntities())
{
return(context.StudentModule.FirstOrDefault(x => x.StudentModuleCode == id));
}
}
public void docentes()
{
int count = 0;
string nombre = string.Empty;
using (SqlConnection con = new SqlConnection("Data Source=DV41117NR\\SQLEXPRESS2008;Initial Catalog=QualificationsDB;User ID=sa;Password=123qwe;"))
{
QualificationsDBEntities context = new QualificationsDBEntities();
var user = from u in context.UserAccount
join p in context.Person
on u.UserAccountId equals p.PersonId
join ust in context.ListAccountStatus
on u.AccountStatus equals ust.UserStatusCode
join urole in context.UserRole
on u.UserAccountId equals urole.UserAccountId
join lr in context.ListRole
on urole.RoleCode equals lr.RoleCode
where urole.RoleCode == 3
orderby p.Name.Substring(0, 1) ascending
select new
{
ID = p.PersonId,
nombre = p.Name + " " + p.FirstName + " " + p.LastName
};
ddl_Docentes.DataSource = user;
ddl_Docentes.DataTextField = "nombre";
ddl_Docentes.DataValueField = "ID";
ddl_Docentes.DataBind();
}
}
public void Reporte(long userid)
{
using (var context = new QualificationsDBEntities())
{
var query = from q in context.StudentModule
join p in context.Person
on q.Student equals p.PersonId
join tm in context.TeachingModule
on q.TeachingModuleCode equals tm.TeachingModuleCode
join qua in context.Qualifications
on q.StudentModuleCode equals qua.StudentModuleCode
join to in context.Totals
on q.StudentModuleCode equals to.Code
join pe in context.EvaluationPlan
on qua.EvaluationPlanCode equals pe.EvaluationCode
where q.Student == userid
select new
{
Descripción = pe.Description,
Calificación = qua.Qualification,
Fecha = pe.Date,
Ponderación = pe.Consideration
};
GridView1.DataSource = query;
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
proxyModule = new ModuleAdminServiceClient("WSHttpBinding_IModuleAdminService");
proxyProgram = new AcademicServiceClient("WSHttpBinding_IAcademicService");
proxyAsignation = new ModuleAsigAdminServiceClient("WSHttpBinding_IModuleAsigAdminService");
updateModule = new Module();
long moduleID = proxyModule.GetModuleID(Request.Params["ModuleName"].ToString());
updateModule = Get(moduleID);
if (!IsPostBack)
{
int count = 0;
txt_ModuleName.Text = updateModule.ModuleName;
using (var context = new QualificationsDBEntities())
{
var program = from p in context.GraduateProgram
orderby p.ProgramName.Substring(0, 1) ascending
select p;
foreach (var query in program)
{
//Añadiendo al DropDownList con los nombres de los Programas de Postgrado
ddl_Programas.Items.Insert(count, query.ProgramName);
count = count + 1;
}
}
}
}
public GraduateProgram GetProgram(long id)
{
using (var context = new QualificationsDBEntities())
{
return(context.GraduateProgram.FirstOrDefault(x => x.GraduateProgramaId == id));
}
}
public Person GetPerson(long id)
{
using (var context = new QualificationsDBEntities())
{
return(context.Person.FirstOrDefault(x => x.PersonId == id));
}
}
public void modulos(long ProgramaID)
{
int count = 0;
using (SqlConnection con = new SqlConnection("Data Source=DV41117NR\\SQLEXPRESS2008;Initial Catalog=QualificationsDB;User ID=sa;Password=123qwe;"))
{
QualificationsDBEntities context = new QualificationsDBEntities();
var pensum = from p in context.Pensum
join m in context.Module
on p.ModuleCode equals m.ModuleCode
join pr in context.GraduateProgram
on p.GraduateProgram equals pr.GraduateProgramaId
where p.GraduateProgram == ProgramaID
orderby m.ModuleName.Substring(0, 1) ascending
select new
{
ID = m.ModuleCode,
Modulo = m.ModuleName
};
ddl_Modulos.DataSource = pensum;
ddl_Modulos.DataTextField = "Modulo";
ddl_Modulos.DataValueField = "ID";
ddl_Modulos.DataBind();
}
}
public Module Get(long ID)
{
using (var context = new QualificationsDBEntities())
{
return(context.Module.FirstOrDefault(x => x.ModuleCode == ID));
}
}
public void Lista()
{
string cuenta = (string)Session["Cuenta"];
string contra = (string)Session["Contraseña"];
using (var context = new QualificationsDBEntities())
{
var teachmod = from tm in context.TeachingModule
join u in context.UserAccount
on tm.Teacher equals u.UserAccountId
join p in context.Person
on u.UserAccountId equals p.PersonId
join op in context.OpeningProgram
on tm.OpeningCode equals op.OpeningCode
join m in context.Module
on tm.ModuleCode equals m.ModuleCode
join gp in context.GraduateProgram
on op.ProgramId equals gp.GraduateProgramaId
join v in context.Version
on op.Version equals v.ID
where u.Account == cuenta & u.Password == contra
select new
{
//Docente = p.Name + " " + p.FirstName + " " +p.LastName,
Módulo = m.ModuleName,
Programa = gp.ProgramName,
Versión = v.ProgramVersion
};
GridView1.DataSource = teachmod;
GridView1.DataBind();
}
}
public void BeforeSelectedModule(long idModule, int contador)
{
for (int i = 0; i < ddl_Versiones.Items.Count; i++)
{
programID = long.Parse(ddl_Programas.SelectedValue);
versionID = int.Parse(ddl_Versiones.Items[i].Value);
openingID = proxyOpening.GetOpeningID(programID, versionID);
moduloID = idModule;
personID = Estudiante(carnet);
int cont = contador;
using (var context = new QualificationsDBEntities())
{
var studentmodule = from sm in context.StudentModule
join tm in context.TeachingModule
on sm.TeachingModuleCode equals tm.TeachingModuleCode
join op in context.OpeningProgram
on tm.OpeningCode equals op.OpeningCode
where op.Version == versionID
select new
{
tmID = sm.TeachingModuleCode,
sID = sm.Student
};
foreach (var x in studentmodule)
{
teamodID = proxyTeachMod.GetTeacherModule(moduloID, openingID);
if (x.tmID == teamodID && x.sID == personID)
{
CheckBoxSelectAll.Enabled = false;
CheckBoxListMoldulos.Items[cont].Enabled = false;
}
}
}
}
}
public void BuscarReporte(string name)
{
using (var context = new QualificationsDBEntities())
{
var reporte = from sm in context.StudentModule
join p in context.Person
on sm.Student equals p.PersonId
join tm in context.TeachingModule
on sm.TeachingModuleCode equals tm.TeachingModuleCode
join op in context.OpeningProgram
on tm.OpeningCode equals op.OpeningCode
join m in context.Module
on tm.ModuleCode equals m.ModuleCode
join gp in context.GraduateProgram
on op.ProgramId equals gp.GraduateProgramaId
join v in context.Version
on op.Version equals v.ID
where p.Name.Contains(name) || p.FirstName.Contains(name)
orderby p.Name.Substring(0, 1) ascending
select new
{
Nombre = p.Name,
Paterno = p.FirstName,
Materno = p.LastName,
Módulo = m.ModuleName,
Programa = gp.ProgramName,
Versión = v.ProgramVersion
};
GridView1.DataSource = reporte;
GridView1.DataBind();
}
}
public double TotalParcial(long studentModuleId)
{
double resultado = 0;
string dato = string.Empty;
float valor = 0;
double total = 0;
using (var context = new QualificationsDBEntities())
{
var query = from q in context.Qualifications
where q.StudentModuleCode == studentModuleId
select new
{
q.Qualification
};
foreach (var res in query)
{
dato = res.Qualification + "";
valor = float.Parse(dato);
resultado = resultado + (valor * 0.5);
}
total = resultado;
}
return(total);
}
public StatusThemeContent Entidad(long EstadoID)
{
using (var context = new QualificationsDBEntities())
{
return(context.StatusThemeContent.FirstOrDefault(x => x.StatusThemeContent1 == EstadoID));
}
}
public void Lista()
{
using (var context = new QualificationsDBEntities())
{
var teachmod = from tm in context.TeachingModule
join u in context.UserAccount
on tm.Teacher equals u.UserAccountId
join p in context.Person
on u.UserAccountId equals p.PersonId
join op in context.OpeningProgram
on tm.OpeningCode equals op.OpeningCode
join m in context.Module
on tm.ModuleCode equals m.ModuleCode
join gp in context.GraduateProgram
on op.ProgramId equals gp.GraduateProgramaId
join v in context.Version
on op.Version equals v.ID
select new
{
Docente = p.Name + " " + p.FirstName + " " + p.LastName,
Módulo = m.ModuleName,
Programa = gp.ProgramName,
Versión = v.ProgramVersion,
Inicio = tm.ModuleStartDate,
Fin = tm.ModuleEndDate
};
GridView1.DataSource = teachmod;
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (SqlCommand con = new SqlCommand("Data Source=DV41117NR\\SQLEXPRESS2008;Initial Catalog=QualificationsDB;User ID=sa;Password=123qwe;"))
{
QualificationsDBEntities context = new QualificationsDBEntities();
var openProgram = from op in context.OpeningProgram
join p in context.GraduateProgram
on op.ProgramId equals p.GraduateProgramaId
join v in context.Version
on op.Version equals v.ID
join s in context.StatusOpening
on op.Status equals s.ID
where op.Status == 1
orderby v.ID
select new
{
ProgramaPostgrado = p.ProgramName,
Versión = v.ProgramVersion,
Inicio = op.StartDate,
Finalización = op.EndDate,
Gestión = op.Gestion,
Estado = s.Description
};
GridView1.DataSource = openProgram;
GridView1.DataBind();
}
}
public OpeningProgram GetOpening(long id)
{
using (var context = new QualificationsDBEntities())
{
return(context.OpeningProgram.FirstOrDefault(x => x.OpeningCode == id));
}
}
public void ContenidoTematico(long id)
{
using (var context = new QualificationsDBEntities())
{
var query = from q in context.GlobalPlan
join tc in context.ContentThematic
on q.GlobalPlanCode equals tc.GlobalPlan
join st in context.StatusThemeContent
on tc.Code equals st.ContentCode
join s in context.StatusTheme
on st.StatusThemeCode equals s.ID
where q.GlobalPlanCode == id
select new
{
Tema = tc.Theme,
ObjetivoInstrumental = tc.InstrumentalObjectives,
TemasInvetigación = tc.InvestigationThemes,
TrabajoPersonal = tc.PersonalWork,
TrabajoGrupal = tc.GroupWork,
EstadoAvance = s.Status
};
gv_Contenido.DataSource = query;
gv_Contenido.DataBind();
}
}
public PasswordPolicy GetTamaño()
{
using (var context = new QualificationsDBEntities())
{
return(context.PasswordPolicy.FirstOrDefault(x => x.PasswordPolicyCode == "Tam"));
}
}
public void InsertOpening(OpeningProgram entity)
{
using (var context = new QualificationsDBEntities())
{
context.OpeningProgram.Attach(entity);
context.ObjectStateManager.ChangeObjectState(entity, System.Data.EntityState.Added);
context.SaveChanges();
}
}
public void UpdatePolicy(PasswordPolicy entity)
{
using (var context = new QualificationsDBEntities())
{
context.PasswordPolicy.Attach(entity);
context.ObjectStateManager.ChangeObjectState(entity, System.Data.EntityState.Modified);
context.SaveChanges();
}
}
public void InsertStudentModule(StudentModule entity)
{
using (var context = new QualificationsDBEntities())
{
context.StudentModule.Attach(entity);
context.ObjectStateManager.ChangeObjectState(entity, System.Data.EntityState.Added);
context.SaveChanges();
}
}
