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);
        }
Beispiel #3
0
        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;
        }
Beispiel #4
0
        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 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);
        }
Beispiel #6
0
        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);
        }
Beispiel #7
0
        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);
        }
Beispiel #8
0
        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);
        }