Ejemplo n.º 1
0
        public static void ResetRowCombos(LIVEX.UserControls.AsistenciaMaestros am)
        {
            am.cmbUID.Text  = "";
            am.cmbName.Text = "";
            //am.cmbTeacherNames.Text = "";
            am.dpDate.Text  = "";
            am.cmbHour.Text = "";

            am.cmbUID.IsEnabled  = false;
            am.cmbName.IsEnabled = false;
            //am.cmbTeacherNames.IsEnabled = false;
            am.dpDate.IsEnabled            = false;
            am.cmbHour.IsEnabled           = false;
            am.btnCheckBlue.IsEnabled      = false;
            am.btnCheckBlueEdit.IsEnabled  = false;
            am.btnCheckBlueEdit.Visibility = Visibility.Collapsed;
            am.btnCheckBlue.Visibility     = Visibility.Visible;

            BitmapImage b = new BitmapImage();

            b.BeginInit();
            b.UriSource = new Uri("pack://application:,,,/LIVEX;component/Images/002-checked.png");
            b.EndInit();
            am.imgCheck.Stretch = Stretch.Uniform;
            am.imgCheck.Source  = b;
        }
Ejemplo n.º 2
0
        public static void EditSelected(LIVEX.UserControls.AsistenciaMaestros am)
        {
            string              uid        = am.cmbUID.Text;
            livexEntities       context    = new livexEntities();
            asistencia_maestros teacherAtt = context.asistencia_maestros.FirstOrDefault(x => x.UID == uid);
            string              hour       = am.cmbHour.Text;
            var time = hour.Split(':');

            teacherAtt.Name = am.cmbName.Text;
            teacherAtt.hour = Int32.Parse(time[0]);
            teacherAtt.min  = Int32.Parse(time[1]);
            if (time.Count() > 2)
            {
                teacherAtt.sec = Int32.Parse(time[2]);
            }
            else
            {
                teacherAtt.sec = 0;
            }

            teacherAtt.date = Convert.ToDateTime(am.dpDate.Text);

            int result = context.SaveChanges();

            if (result >= 0)
            {
                MessageBox.Show("El registro se guardó exitosamente");
            }
            else
            {
                MessageBox.Show("El registro NO se guardó");
            }
        }
Ejemplo n.º 3
0
        public static void refreshCombos(LIVEX.UserControls.AsistenciaMaestros am)
        {
            livexEntities       context = new livexEntities();
            asistencia_maestros a       = new asistencia_maestros();
            teacher             t       = new teacher();

            if (am.cmbUID.SelectedItem != null || am.cmbUID.Text != "")
            {
                string uid = am.cmbUID.SelectedItem.ToString();
                a = context.asistencia_maestros.FirstOrDefault(x => x.UID == uid);
                if (a != null)
                {
                    am.cmbName.Text          = a.Name;
                    am.cmbName.SelectedValue = a.Name;

                    //teacher teacherFound = context.teacher.FirstOrDefault(x => x.uid == a.UID);

                    //if (teacherFound != null)
                    //{
                    //    am.cmbTeacherNames.Text = teacherFound.teacher_names + " " + teacherFound.teacher_lastname;
                    //    am.cmbTeacherNames.SelectedValue = teacherFound.teacher_names + " " + teacherFound.teacher_lastname;
                    //}
                }
            }
        }
Ejemplo n.º 4
0
        public static void InitCombos(LIVEX.UserControls.AsistenciaMaestros am)
        {
            livexEntities              context         = new livexEntities();
            List <teacher>             lstTeachers     = context.teacher.ToList();
            List <asistencia_maestros> lstasm          = context.asistencia_maestros.ToList();
            List <string>              lstUID          = new List <string>();
            List <string>              lstNames        = new List <string>();
            List <string>              lstTeacherNames = new List <string>();
            List <string>              lstHours        = new List <string>();

            foreach (asistencia_maestros a in lstasm)
            {
                lstUID.Add(a.UID);
                lstNames.Add(a.Name);
            }

            foreach (teacher t in lstTeachers)
            {
                lstTeacherNames.Add(t.teacher_names + " " + t.teacher_lastname);
            }

            //am.cmbTeacherNames.ItemsSource = lstTeacherNames.Distinct().ToList();
            am.cmbUID.ItemsSource  = lstUID.Distinct().ToList();
            am.cmbName.ItemsSource = lstNames.Distinct().ToList();
            am.cmbHour.Items.Add("01:00");
            am.cmbHour.Items.Add("02:00");
            am.cmbHour.Items.Add("03:00");
            am.cmbHour.Items.Add("04:00");
            am.cmbHour.Items.Add("05:00");
            am.cmbHour.Items.Add("06:00");
            am.cmbHour.Items.Add("07:00");
            am.cmbHour.Items.Add("08:00");
            am.cmbHour.Items.Add("09:00");
            am.cmbHour.Items.Add("10:00");
            am.cmbHour.Items.Add("11:00");
            am.cmbHour.Items.Add("12:00");
            am.cmbHour.Items.Add("13:00");
            am.cmbHour.Items.Add("14:00");
            am.cmbHour.Items.Add("15:00");
            am.cmbHour.Items.Add("16:00");
            am.cmbHour.Items.Add("17:00");
            am.cmbHour.Items.Add("18:00");
            am.cmbHour.Items.Add("19:00");
            am.cmbHour.Items.Add("20:00");
            am.cmbHour.Items.Add("21:00");
            am.cmbHour.Items.Add("22:00");
            am.cmbHour.Items.Add("23:00");
            am.cmbHour.Items.Add("00:00");
        }
Ejemplo n.º 5
0
        public static bool validateAddRow(LIVEX.UserControls.AsistenciaMaestros am)
        {
            bool result = false;

            if (am.cmbUID.Text == "")
            {
                MessageBox.Show("Favor de seleccionar un ID de asistencia");
                return(false);
            }
            else
            {
                result = true;
            }

            if (am.cmbName.Text == "")
            {
                MessageBox.Show("Favor de seleccionar un Nombre de asistencia");
                return(false);
            }
            else
            {
                result = true;
            }

            if (am.dpDate.Text == "")
            {
                MessageBox.Show("Favor de seleccionar una Fecha");
                return(false);
            }
            else
            {
                result = true;
            }

            if (am.cmbHour.Text == "")
            {
                MessageBox.Show("Favor de seleccionar una Hora");
                return(false);
            }
            else
            {
                result = true;
            }

            return(result);
        }
Ejemplo n.º 6
0
        public static void DeleteRow(LIVEX.UserControls.AsistenciaMaestros am, object attRow)
        {
            TeacherAttendanceView row           = (TeacherAttendanceView)attRow;
            livexEntities         context       = new livexEntities();
            asistencia_maestros   teacherDelete = context.asistencia_maestros.FirstOrDefault(x => x.asistencia_maestrosID == row.id);

            if (teacherDelete != null)
            {
                context.asistencia_maestros.Remove(teacherDelete);
                int result = context.SaveChanges();
                if (result > 0)
                {
                    MessageBox.Show("El registro se borró exitosamente");
                }
                else
                {
                    MessageBox.Show("Error al borrar el registro");
                }
            }
        }
Ejemplo n.º 7
0
        public static void EditRow(LIVEX.UserControls.AsistenciaMaestros am, object attRow)
        {
            TeacherAttendanceView atteToEdit = (TeacherAttendanceView)attRow;

            am.cmbUID.IsEnabled  = true;
            am.cmbName.IsEnabled = true;
            //am.cmbTeacherNames.IsEnabled = true;
            am.cmbHour.IsEnabled          = true;
            am.dpDate.IsEnabled           = true;
            am.btnCheckBlueEdit.IsEnabled = true;

            am.cmbUID.Text  = atteToEdit.UID;
            am.cmbName.Text = atteToEdit.Name;
            //am.cmbTeacherNames.Text = atteToEdit.TeacherName;
            am.dpDate.Text  = atteToEdit.Date;
            am.cmbHour.Text = atteToEdit.Time;

            am.btnCheckBlue.Visibility     = Visibility.Collapsed;
            am.btnCheckBlueEdit.Visibility = Visibility.Visible;
        }
Ejemplo n.º 8
0
        public static void AddAttendaceRow(LIVEX.UserControls.AsistenciaMaestros am)
        {
            livexEntities       context = new livexEntities();
            asistencia_maestros newAtt  = new asistencia_maestros();
            DateTime            date    = Convert.ToDateTime(am.dpDate.Text);
            string hour = am.cmbHour.Text;
            var    time = hour.Split(':');

            newAtt.DN       = 1;
            newAtt.UID      = am.cmbUID.Text;
            newAtt.Name     = am.cmbName.Text;
            newAtt.Status   = "0";
            newAtt.Action   = 3;
            newAtt.APB      = 0;
            newAtt.JobCode  = 0;
            newAtt.date     = Convert.ToDateTime(date.ToShortDateString());
            newAtt.No       = 0;
            newAtt.filename = "LIVEX_Sys";
            newAtt.hour     = Int32.Parse(time[0]);
            newAtt.min      = Int32.Parse(time[1]);
            if (time.Count() > 2)
            {
                newAtt.sec = Int32.Parse(time[2]);
            }
            else
            {
                newAtt.sec = 0;
            }

            context.asistencia_maestros.Add(newAtt);
            int result = context.SaveChanges();

            if (result > 0)
            {
                MessageBox.Show("El registro se guardó exitosamente");
            }
            else
            {
                MessageBox.Show("El registro NO se guardó");
            }
        }