public HttpResponseMessage Put(MajorDTO toUpdate)
{
using (var context = new SistemaAcademico.DataModel.AcademicSystemContext())
{
var majorInDb = context.Majors.Where(m => m.MajorID == toUpdate.MajorID).FirstOrDefault();
majorInDb.Description = toUpdate.description;
majorInDb.MajorTitle = toUpdate.MajorTitle;
majorInDb.Area = context.Areas.Where(a => a.Name == toUpdate.Area).FirstOrDefault();
context.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
// GET: api/Majors
public IEnumerable <object> Get()
{
using (var c = new SistemaAcademico.DataModel.AcademicSystemContext())
{
return(c.Majors.Select(d => new
{
area = d.Area.Name,
MajorTitle = d.MajorTitle,
fechainicio = d.FechaIntroduccion,
id = d.MajorID,
description = d.Description,
CreditsCount = d.CreditsCount
}).ToList());
}
}
public IEnumerable <Object> getAllAsignaturas()
{
using (var context = new SistemaAcademico.DataModel.AcademicSystemContext())
{
var d = context.Asignaturas.Select(a => new
{
Nombre = a.Name,
Creditos = a.Credits,
ID = a.AsignatureID,
Tipo = a.TipoAsignatura
}).Select(dd => new
{
nombre = dd.Nombre,
tipo = (dd.Tipo == 0) ? "Teoria" : "Laboratorio",
id = dd.ID,
creditos = dd.Creditos
}).ToList();
return(d);
}
}
public HttpResponseMessage Register(userDTO id)
{
try
{
var newUser = new SistemaAcademico.Classes.User
{
Email = id.email,
Name = id.Name,
Name2 = id.Name2,
BirthDate = id.birthdate,
PhoneNum = id.phoneNum,
LastName = id.LastName,
UserType = id.userType,
Sex = id.sex
};
SHA512 SHA = new SHA512Managed();
string password = id.password;
var password_bytes = ASCIIEncoding.ASCII.GetBytes(password);
byte[] passBytes = new byte[password_bytes.Length];
for (int i = 0; i < password_bytes.Length; i++)
{
passBytes[i] = password_bytes[i];
}
string hashedPass = Convert.ToBase64String(SHA.ComputeHash(passBytes));
newUser.Password = hashedPass;
using (var context = new SistemaAcademico.DataModel.AcademicSystemContext())
{
context.Usuarios.Add(newUser);
context.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created, newUser.UserId));
}
}
catch (Exception e)
{
if (e.InnerException != null)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
// GET api/<controller>
public IEnumerable <object> Get()
{
using (var context = new SistemaAcademico.DataModel.AcademicSystemContext())
{
ViewModels.IndexViewModel Model = new ViewModels.IndexViewModel();
List <MenuOptionsDTO> MenuResults = new List <MenuOptionsDTO>();
var source = context.OpcionesDelMenu.Where(o => o.parent == null).OrderBy(o => o.order).ToList();
foreach (MenuOption Opcion in source)
{
MenuResults.Add(new MenuOptionsDTO
{
OpcionDeMenu = Opcion,
Childs = context.OpcionesDelMenu
.Where(child => child.parent.id == Opcion.id)
.OrderBy(o => o.order)
.ToList()
});
}
return(MenuResults);
}
}
public void Post(MajorDTO @new)
{
using (var c = new SistemaAcademico.DataModel.AcademicSystemContext())
{
var newMajor = new Classes.Major
{
MajorTitle = @new.MajorTitle,
FechaIntroduccion = DateTime.Now,
Area = c.Areas.Where(a => a.Name == @new.Area).FirstOrDefault(),
CreditsCount = @new.CreditsCount
};
if (@new.description == null)
{
newMajor.Description = "Pendiente".ToUpper();
}
else
{
newMajor.Description = @new.description;
}
c.Majors.Add(newMajor);
c.SaveChanges();
}
}
