Ejemplo n.º 1
0
 public string InsertLearner(Person student)
 {
     try
     {
         digitalContext = new DigitalEntities();
         digitalContext.People.Add(student);
         digitalContext.SaveChanges();
         return student.FirstName + "was successfully added";
     }
     catch (Exception ex)
     {
         return "Learner not Added" + ex.Message;
     }
 }
Ejemplo n.º 2
0
 public string MasterRecord(AttendanceMaster master)
 {
     try
     {
         digitalContext = new DigitalEntities();
         digitalContext.AttendanceMasters.Add(master);
         digitalContext.SaveChanges();
          return "You signed";
     }
     catch (Exception ex)
     {
         return "Register was not signed, Please try again" + ex.Message;
     }
 }
 public void Window_Loaded(object sender, RoutedEventArgs e)
 {
     digitalContext = new DigitalEntities();
     SignModel sign = new SignModel();
     GetMentors();
     datePicker.SelectedDate = DateTime.Now;
     cmbStudent.SelectedIndex = 1;
     cmbMentorList.SelectedIndex = 1;
     Username.Text = "Welcome ," + SessionContext.UserName;
     LoadData();
     CustomViewModel model = new CustomViewModel();
     DateTime picker = (DateTime)datePicker.SelectedDate;
     item.DataContext = model.LoadData();
 }  
Ejemplo n.º 4
0
 public string SignRegister(AttendanceDetail detail)
 {
     try
     {
         digitalContext = new DigitalEntities();
         digitalContext.AttendanceDetails.Add(detail);
         digitalContext.SaveChanges();
             return "You signed";                
     }
     catch (Exception )
     {
         return null;
     }
 }
Ejemplo n.º 5
0
        public string InsertMentor( Person mentor)
        {
            try
            {
                digitalContext = new DigitalEntities();
                digitalContext.People.Add(mentor);
                digitalContext.SaveChanges();
                return mentor.FirstName + " " + " was successfully added";
            }
            catch (Exception ex)
            {

                return "Mentor not added" + ex.Message;
            }
        }
        public dynamic GetAttendance(DateTime picker)
        {
            digitalContext = new DigitalEntities();
            var q = from a in digitalContext.AttendanceDetails
                    join b in digitalContext.People  on new { a.PersonID } equals new { b.PersonID }
                    join c in digitalContext.AttendanceMasters on new { a.MasterID } equals new { c.MasterID }
                    where c.AttendanceDate == picker
                    select new
                    {
                       Name = b.FirstName,
                       Hours = a.HoursPerDay
                    };

            return q;
        }
Ejemplo n.º 7
0
 public string DeleteLearner(int id)
 {
     try
     {
         digitalContext = new DigitalEntities();
         Person student = digitalContext.People.Find(id);
         digitalContext.People.Attach(student);
         digitalContext.People.Remove(student);
         digitalContext.SaveChanges();
         return student.FirstName + "was successfully Deleted";
     }
     catch (Exception )
     {
         return "Learner not deleted" ; 
     }
 }
 public dynamic LoadData()
 {
     digitalContext = new DigitalEntities();
     List<Person> person = (from x in digitalContext.People
                            select x).ToList();
     IList<AttendanceDetail> details = (from x in digitalContext.AttendanceDetails
                                       select x).ToList();
     var query = person.Join(details,
                         c => c.PersonID,
                         ct => ct.PersonID,                                
                         (c, ct) => new CustomModel
                         {
                             Name = c.FirstName,
                             Hours = ct.HoursPerDay
                         });
     return query;
 }
 private void cmbMentorList_SelectionChanged(object sender, SelectionChangedEventArgs e)
 {
     try
     {
         int Index = cmbMentorList.SelectedIndex + 1;
         using (digitalContext = new DigitalEntities())
         {
             List<Person> student = (from x in digitalContext.People
                                     where x.RoleID == 1
                                     select x).ToList();
             cmbStudent.DataContext = student;
             Index = cmbMentorList.SelectedIndex + 1;
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }
 public void GetMentors()
 {
     try
     {
         using (digitalContext = new DigitalEntities())
         {
             List<Person> person = (from x in digitalContext.People
                                    where x.RoleID == 2
                                    select x).ToList();
             foreach (var item in person)
             {
                 cmbMentorList.Items.Add(item.FirstName + "  " + item.LastName.Substring(0, 1).ToUpper());
             }
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("mentors not found" + ex.Message);
     }
 }
Ejemplo n.º 11
0
 private void btn_Click(object sender, RoutedEventArgs e)
 {
     using (digitalContext = new DigitalEntities())
     {
         var mentor = (from t in digitalContext.People
                        where String.Compare(t.Username, txtUsername.Text) == 0
                        && String.Compare(t.Password,txtPassword.Password) == 0
                        select t).FirstOrDefault();
         if (mentor != null && !String.IsNullOrEmpty(mentor.Username))
         {
             SessionContext.UserID = mentor.PersonID;
            SessionContext.UserRole = Role.Person;
             SessionContext.UserName = mentor.FirstName;
             SessionContext.CurrentMentor = mentor;
             home.Show();                
             home.btnManage.IsEnabled = false;
             this.Close();
         }
         else
         {
             MessageBox.Show("Invalid Username or Password", "Please Try Again", MessageBoxButton.OK, MessageBoxImage.Error);                    
         }
       }           
 }
        private void DatePicker_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
        {
            listBox1.Items.Clear();
            combo.Items.Clear();
            DateTime picker = (DateTime)datePicker.SelectedDate;
            digitalContext = new DigitalEntities();
            var q = from a in digitalContext.AttendanceDetails
                    join b in digitalContext.People on new { a.PersonID } equals new { b.PersonID }
                    join c in digitalContext.AttendanceMasters on new { a.MasterID } equals new { c.MasterID }
                    where c.AttendanceDate == picker 
                    select new
                    {
                        b.FirstName,
                        a.HoursPerDay
                    };
            listBox1.Items.Add("Name" + "        "+ "   "  + "Hours");      
            foreach (var item in q)
            {
                listBox1.Items.Add(item.FirstName +"        " + item.HoursPerDay);
                combo.Items.Add(item.FirstName + "  " + item.HoursPerDay);
            }

        }
Ejemplo n.º 13
0
        private void Window_Loaded(object sender, RoutedEventArgs e)
        {
            try
            {
                using (digitalContext = new DigitalEntities())
                {
                    List<UserRole> role = (from x in digitalContext.UserRoles
                                           select x).ToList();

                    foreach (var item in role)
                    {
                        cmbStudentMentor.Items.Add(item.Name);
                    }
                }
            }
            catch (Exception)
            {

                throw;
            }
        }