示例#1
0
        public static void UpdateStudent(student student)
        {
            using (ASMDataContext context = new ASMDataContext())
            {
                var dbStudent = context.students.SingleOrDefault(x => x.fname == student.fname);
                if (dbStudent != null)
                {
                    dbStudent.fname   = student.fname;
                    dbStudent.Surname = student.Surname;
                    dbStudent.bcode   = student.bcode;

                    context.SubmitChanges();
                }
            }
        }
示例#2
0
        public static void UpdateAttendance(attendance attendId)
        {
            using (ASMDataContext context = new ASMDataContext())
            {
                var dbStudent = context.attendances.SingleOrDefault(x => x.admno == attendId.admno);
                if (dbStudent != null)
                {
                    dbStudent.admno  = attendId.admno;
                    dbStudent.period = attendId.period;
                    dbStudent.weekno = attendId.weekno;

                    context.SubmitChanges();
                }
            }
        }
示例#3
0
        public static void UpdateStaff(faculty staff)
        {
            using (ASMDataContext context = new ASMDataContext())
            {
                var dbStaff = context.faculties.SingleOrDefault(x => x.fname == staff.fname);
                if (dbStaff != null)
                {
                    dbStaff.fname   = staff.fname;
                    dbStaff.Surname = staff.Surname;
                    dbStaff.dept    = staff.dept;

                    context.SubmitChanges();
                }
            }
        }