public Message Login(LoginVM login)
{
var res = new Message();
try
{
using (var context = new ModeloAula())
{
var vGetaccesss = context.STUDENTs.AsQueryable().
Where(x => x.STATUS_ITEM == true && x.EMAIL == login.Email && x.PWD == login.PWD).FirstOrDefault <STUDENT>();
// TODO analizar lo del
if (vGetaccesss != null)
{
Mapper.Initialize(cfg => cfg.CreateMap <STUDENT, StudentVM>());
var viewModel = AutoMapper.Mapper.Map <StudentVM>(vGetaccesss);
res.details = JsonConvert.SerializeObject(viewModel, Formatting.None);
}
else
{
res.details = "* Verificar usuario y/o contraseña";
res.details = JsonConvert.SerializeObject(res, Formatting.None);
}
}
}
catch (Exception ex)
{
res.details = String.Format("* Incidencia al obtener credenciales detalles: {0}", ex.Message);
}
return(res);
}
public Message Delete(int id)
{
var res = new Message();
try
{
using (var context = new ModeloAula())
{
var objschoolsubject = context.SCHOOL_SUBJECTS.AsQueryable().Where(x => x.ID == id).FirstOrDefault();
if (objschoolsubject != null)
{
objschoolsubject.STATUS_ITEM = false;
objschoolsubject.MODIFICATION_DATE = DateTime.Now;
}
else
{
throw new Exception("* Materia escolar no existe, favor de veríficar");
}
context.Entry(objschoolsubject).State = EntityState.Modified;
context.SaveChanges();
res.status_item = true;
res.details = "Borrado con éxito";
res.details = JsonConvert.SerializeObject(res, Formatting.None);
}
}
catch (Exception ex)
{
res.details = String.Format("* Incidencia al borrar Materia Escolar detalles:{0}", ex.Message);
}
return(res);
}
public Message Update(SchoolSubjectVM objSchoolSubject)
{
var res = new Message();
try
{
using (var context = new ModeloAula())
{
var vobjSchoolSubject = context.SCHOOL_SUBJECTS.AsQueryable().Where(x => x.ID == objSchoolSubject.Id).SingleOrDefault();
if (vobjSchoolSubject != null)
{
vobjSchoolSubject.RATING_RECORD = objSchoolSubject.RatingRecord;
vobjSchoolSubject.MODIFICATION_DATE = DateTime.Now;
vobjSchoolSubject.MAKER = objSchoolSubject.MAKER;
}
else
{
throw new Exception("* Materia Escolar No existe");
}
context.Entry(vobjSchoolSubject).State = EntityState.Modified;
context.SaveChanges();
res.status_item = true;
res.details = "* Se han realizado los cambios correctamente";
res.details = JsonConvert.SerializeObject(res, Formatting.None);
}
}
catch (Exception ex)
{
res.details = String.Format("* Incidencia al modíficar información de la materia escolar detalles:{0}", ex.Message);
}
return(res);
}
public Message Create(SchoolAttendaceVM objSAVM)
{
var res = new Message();
try
{
SCHOOL_ATTENDANCE viewModel = new SCHOOL_ATTENDANCE { ATTENDANCE_RECORD = objSAVM.AttendanceRecord, STATUS_ITEM = true, CREATE_DATE = DateTime.Now, ID_SCHOOL_SUBJECTS = objSAVM.IdSchoolSubject, MAKER = objSAVM.MAKER, MODIFICATION_DATE = DateTime.Now };
using (var context = new ModeloAula())
{
var vRegister = context.SCHOOL_ATTENDANCE.AsQueryable().Where(x => x.ID_SCHOOL_SUBJECTS == objSAVM.IdSchoolSubject).SingleOrDefault();
if (vRegister != null)
throw new Exception(string.Format("* Ya se encuentra asignado la asistencia "));
context.Entry(viewModel).State = EntityState.Added;
context.SaveChanges();
objSAVM.Id = viewModel.ID;
res.status_item = true;
res.details = JsonConvert.SerializeObject(objSAVM, Formatting.None);
}
}
catch (Exception ex)
{
res.status_item = false;
res.details = String.Format("* Incidencia al crear Materia Escolar detalles:{0}", ex.Message);
}
return res;
}
public Message Update(SchoolAttendaceVM objSchoolAttendance)
{
var res = new Message();
try
{
using (var context = new ModeloAula())
{
var vobjSchoolAttendance = context.SCHOOL_ATTENDANCE.AsQueryable().Where(x => x.ID == objSchoolAttendance.Id).SingleOrDefault();
if (vobjSchoolAttendance != null)
{
vobjSchoolAttendance.ATTENDANCE_RECORD = objSchoolAttendance.AttendanceRecord;
vobjSchoolAttendance.MODIFICATION_DATE = DateTime.Now;
vobjSchoolAttendance.MAKER = objSchoolAttendance.MAKER;
}
else
throw new Exception(string.Format("* Asistencia {0} No existe", objSchoolAttendance.Id));
context.Entry(vobjSchoolAttendance).State = EntityState.Modified;
context.SaveChanges();
res.status_item = true;
res.details = string.Format("* Se han realizado los cambios correctamente de la asistencia {0}", objSchoolAttendance.Id);
res.details = JsonConvert.SerializeObject(res, Formatting.None);
}
}
catch (Exception ex)
{
res.details = String.Format("* Incidencia al modíficar información de la materia escolar detalles:{0}", ex.Message);
}
return res;
}
public Message GetbyID(int id)
{
var res = new Message();
try
{
using (var context = new ModeloAula())
{
if (id == -10)
{
var objschoolattendance = context.SCHOOL_ATTENDANCE.AsQueryable().ToList();
List<SchoolAttendaceVM> viewModel = new List<SchoolAttendaceVM>();
foreach (var item in objschoolattendance)
{
var tmp = new SchoolAttendaceVM { Id = item.ID, AttendanceRecord = item.ATTENDANCE_RECORD, IdSchoolSubject = item.ID_SCHOOL_SUBJECTS, MAKER = item.MAKER, StatusItem = item.STATUS_ITEM };
viewModel.Add(tmp);
}
if (viewModel.Count > 0)
{
res.status_item = true;
res.details = JsonConvert.SerializeObject(viewModel, Formatting.None);
}
else
{
res.status_item = false;
res.details = "* Sin registros";
}
}
else
{
var objschoolattendance = context.SCHOOL_ATTENDANCE.AsQueryable().Where(x => x.ID == id).SingleOrDefault();
if (objschoolattendance != null)
{
var viewModel = new SchoolAttendaceVM { Id = objschoolattendance.ID, AttendanceRecord = objschoolattendance.ATTENDANCE_RECORD, IdSchoolSubject = objschoolattendance.ID_SCHOOL_SUBJECTS, MAKER = objschoolattendance.MAKER, StatusItem = objschoolattendance.STATUS_ITEM };
res.status_item = true;
res.details = JsonConvert.SerializeObject(viewModel, Formatting.None);
}
else
{
res.status_item = false;
res.details = String.Format("* Incidencia veríficar la asistencia en esta materia escolar");
}
}
}
}
catch (Exception ex)
{
res.status_item = false;
res.details = String.Format("* Incidencia en el modulo la Asistencia de Materia Escolar:{0}", ex.Message);
}
return res;
}
public Message Create(SchoolSubjectVM objSchoolSubject)
{
var res = new Message();
try
{
// Convert to object required
Mapper.Initialize(cfg => cfg.CreateMap <SchoolSubjectVM, SCHOOL_SUBJECTS>().ForMember(x => x.ID_CAT_DET, y => y.MapFrom(c => c.IdCatDet))
.ForMember(x => x.RATING_RECORD, y => y.MapFrom(c => c.RatingRecord))
.ForMember(x => x.ID_STUDENT, y => y.MapFrom(c => c.IdStudent)));
var viewModel = AutoMapper.Mapper.Map <SCHOOL_SUBJECTS>(objSchoolSubject);
using (var context = new ModeloAula())
{
// TODO validate if exist School Subject
var vSchoolSubject = context.CATALOG_DETAILS.AsQueryable().Where(x => x.ID_CATALOG_DEFINITION == (int)CATALOG_TABLES.SCHOOL_SUBJECTS && x.ROW_ITEM == objSchoolSubject.IdCatDet).SingleOrDefault();
if (vSchoolSubject == null)
{
throw new Exception("* Debe elegir una materia escolar Hábil");
}
// TODO validate if exist Student
var vStudent = context.STUDENTs.AsQueryable().Where(x => x.ID == objSchoolSubject.IdStudent && x.STATUS_ITEM == true).SingleOrDefault();
if (vStudent == null)
{
throw new Exception("* Debe elegir un estudiante Hábil");
}
// TODO validate if exist Register
var vRegister = context.SCHOOL_SUBJECTS.AsQueryable().Where(x => x.ID_CAT_DET == objSchoolSubject.IdCatDet && x.ID_STUDENT == objSchoolSubject.IdStudent).SingleOrDefault();
if (vRegister != null)
{
throw new Exception(string.Format("* Ya se encuentra asignado {0} para {1}", vSchoolSubject.FIELD0, vStudent.NAME));
}
context.Entry(viewModel).State = EntityState.Added;
context.SaveChanges();
objSchoolSubject.Id = viewModel.ID;
res.status_item = true;
res.details = JsonConvert.SerializeObject(objSchoolSubject, Formatting.None);
}
}
catch (Exception ex)
{
res.status_item = false;
res.details = String.Format("* Incidencia al crear Materia Escolar detalles:{0}", ex.Message);
}
return(res);
}
public Message GetbyID(int id)
{
var res = new Message();
try
{
Mapper.Initialize(cfg => cfg.CreateMap <SCHOOL_SUBJECTS, SchoolSubjectVM>().ForMember(x => x.IdCatDet, y => y.MapFrom(c => c.ID_CAT_DET))
.ForMember(x => x.RatingRecord, y => y.MapFrom(c => c.RATING_RECORD))
.ForMember(x => x.IdStudent, y => y.MapFrom(c => c.ID_STUDENT)));
using (var context = new ModeloAula())
{
if (id == -10)
{
var objschoolsubject = context.SCHOOL_SUBJECTS.AsQueryable().ToList();
List <SchoolSubjectVM> viewModel = Mapper.Map <List <SCHOOL_SUBJECTS>, List <SchoolSubjectVM> >(objschoolsubject);
res.status_item = true;
res.details = JsonConvert.SerializeObject(viewModel, Formatting.None);
}
else
{
var objschoolsubject = context.SCHOOL_SUBJECTS.AsQueryable().Where(x => x.ID == id).SingleOrDefault();
if (objschoolsubject != null)
{
var viewModel = Mapper.Map <SchoolSubjectVM>(objschoolsubject);
res.status_item = true;
res.details = JsonConvert.SerializeObject(viewModel, Formatting.None);
}
else
{
res.status_item = false;
res.details = String.Format("* Incidencia veríficar id de la materia escolar");
}
}
}
}
catch (Exception ex)
{
res.status_item = false;
res.details = String.Format("* Incidencia en el modulo Materia Escolar:{0}", ex.Message);
}
return(res);
}
public Message GetbyID(int id)
{
var res = new Message();
try
{
using (var context = new ModeloAula())
{
if (id == -10)
{
var objstudent = context.STUDENTs.AsQueryable().ToList();
Mapper.Initialize(cfg => cfg.CreateMap <STUDENT, StudentVM>());
//var viewModel = Mapper.Map<StudentVM>(objstudent);
List <StudentVM> viewModel = Mapper.Map <List <STUDENT>, List <StudentVM> >(objstudent);
res.status_item = true;
res.details = JsonConvert.SerializeObject(viewModel, Formatting.None);
}
else
{
var objstudent = context.STUDENTs.AsQueryable().Where(x => x.ID == id).FirstOrDefault();
if (objstudent != null)
{
Mapper.Initialize(cfg => cfg.CreateMap <STUDENT, StudentVM>());
var viewModel = AutoMapper.Mapper.Map <StudentVM>(objstudent);
res.status_item = true;
res.details = JsonConvert.SerializeObject(viewModel, Formatting.None);
}
else
{
res.status_item = false;
res.details = String.Format("* Incidencia veríficar id usuario");
}
}
}
}
catch (Exception ex)
{
res.status_item = false;
res.details = String.Format("* Incidencia al borrar usuario detalles:{0}", ex.Message);
}
return(res);
}
public Message Create(StudentVM student)
{
var res = new Message();
var email = new Email {
To = new List <string> {
student.Email
}, typeEmail = TypeEmail.CREATE
};
try
{
student.Token = "-1000";
//student.Status = true;
Mapper.Initialize(cfg => cfg.CreateMap <StudentVM, STUDENT>());
var viewModel = AutoMapper.Mapper.Map <STUDENT>(student);
viewModel.STATUS_ITEM = true;
using (var context = new ModeloAula())
{
if (!context.STUDENTs.Any(x => x.EMAIL == viewModel.EMAIL))
{
Task.Run(() => email.SendAsync());
context.Entry(viewModel).State = EntityState.Added;
context.SaveChanges();
student.ID = viewModel.ID;
res.status_item = true;
res.details = JsonConvert.SerializeObject(student, Formatting.None);
}
else
{
res.status_item = false;
res.details = string.Format("* El usuario {0} ya existe", viewModel.EMAIL);
}
}
}
catch (Exception ex)
{
res.details = String.Format("* Incidencia al crear usuario detalles:{0}", ex.Message);
}
Task.WaitAll();
return(res);
}
public Message Update(StudentVM student)
{
var res = new Message();
try
{
if (student.ID > 0)
{
using (var context = new ModeloAula())
{
var objstudent = context.STUDENTs.AsQueryable().Where(x => x.ID == student.ID).FirstOrDefault();
if (objstudent != null)
{
objstudent.NAME = student.Name;
objstudent.LASTNAME = student.LastName;
objstudent.PWD = student.PWD;
objstudent.EMAIL = student.Email;
objstudent.STATUS_ITEM = student.Status;
objstudent.MODIFICATION_DATE = DateTime.Now;
student.Token = objstudent.TOKEN = HashCore.Token();
}
context.Entry(objstudent).State = EntityState.Modified;
context.SaveChanges();
res.status_item = true;
res.details = JsonConvert.SerializeObject(student, Formatting.None);
}
}
else
{
res.status_item = false;
res.details = String.Format("* Incidencia veríficar id usuario");
}
}
catch (Exception ex)
{
res.details = String.Format("* Incidencia al crear usuario detalles:{0}", ex.Message);
}
return(res);
}
public Message Delete(int id)
{
var res = new Message();
try
{
if (id > 0)
{
using (var context = new ModeloAula())
{
var objstudent = context.STUDENTs.AsQueryable().Where(x => x.ID == id).FirstOrDefault();
if (objstudent != null)
{
objstudent.STATUS_ITEM = false;
objstudent.MODIFICATION_DATE = DateTime.Now;
}
context.Entry(objstudent).State = EntityState.Modified;
context.SaveChanges();
res.status_item = true;
res.details = "Borrado con éxito";
res.details = JsonConvert.SerializeObject(res, Formatting.None);
}
}
else
{
res.status_item = false;
res.details = String.Format("* Incidencia veríficar id usuario");
}
}
catch (Exception ex)
{
res.details = String.Format("* Incidencia al borrar usuario detalles:{0}", ex.Message);
}
return(res);
}
public bool SendAsync()
{
try
{
// get config
using (var _context = new ModeloAula())
{
switch (typeEmail)
{
case TypeEmail.CREATE:
var emailconfigV2 = _context.CATALOG_DETAILS.AsQueryable().Where(x => x.ID_CATALOG_DEFINITION == (int)CATALOG_TABLES.EMAIL && x.ROW_ITEM == (int)typeEmail).Select(x => new { x.FIELD0, x.FIELD1, x.FIELD2, x.FIELD3, x.FIELD4, x.FIELD5 }).FirstOrDefault();
this.Subject = emailconfigV2.FIELD0;
this.Body = emailconfigV2.FIELD1;
this.From = emailconfigV2.FIELD2;
this.PWD = emailconfigV2.FIELD3;
this.smtp = emailconfigV2.FIELD4;
this.port = int.Parse(emailconfigV2.FIELD5);
break;
case TypeEmail.DELETE:
break;
default:
break;
}
}
// start
var message = new MimeMessage();
message.From.Add(new MailboxAddress("UDO", From));
if (To == null)
{
throw new Exception("* Se requiere destinatario");
}
else
{
foreach (string item in To)
{
message.To.Add(new MailboxAddress(item.Split('@')[0], item));
}
}
message.Subject = Subject;
message.Body = new TextPart("html")
{
Text = @Body
};
using (var client = new SmtpClient())
{
// For demo-purposes, accept all SSL certificates (in case the server supports STARTTLS)
client.ServerCertificateValidationCallback = (s, c, h, e) => true;
client.Connect(this.smtp, this.port, false);
// Note: since we don't have an OAuth2 token, disable
// the XOAUTH2 authentication mechanism.
client.AuthenticationMechanisms.Remove("XOAUTH2");
// Note: only needed if the SMTP server requires authentication
client.Authenticate(this.From, this.PWD);
client.Send(message);
client.Disconnect(true);
}
// end
}
catch (Exception ex)
{
// TODO add nlog or insight
Console.WriteLine(ex.Message);
res = false;
}
return(res);
}
