partial void DeleteStudentInfo(StudentInfo instance);
 partial void InsertStudentInfo(StudentInfo instance);
 partial void UpdateStudentInfo(StudentInfo instance);
        public void AddNewStudent(string p1, string p2, string p3, string p4, string p5, string p6, string p7, string p8, string p9, string p10, string p11, string p12, string p13, string p14, string p15, string p16, string p17, string p18, string p19)
        {
            LoginInfo l = new LoginInfo()
            {
                ID = p1,
                Password = p2,
                Status = p3
            };
            dataContext.GetTable<LoginInfo>().InsertOnSubmit(l);
            try
            {
                dataContext.SubmitChanges();
            }
            catch (Exception ex)
            {

            }

            StudentInfo s = new StudentInfo()
            {
                ID = p1,
                FirstName = p4,
                LastName = p5,
                Department = p6,
                Semester = p7,
                CreditCompleted = Convert.ToInt32(p8),
                DateOfBirth = Convert.ToDateTime(p9),
                BloodGroup = p10,
                FatherName = p11,
                FatherNumber = p12,
                MotherName = p13,
                MotherNumber = p14,
                GuardianName = p15,
                GuardianNumber = p16,
                Address = p17,
                Mobile = p18,
                Email = p19,
                CGPA = 0
            };
            dataContext.GetTable<StudentInfo>().InsertOnSubmit(s);
            try
            {
                dataContext.SubmitChanges();
            }
            catch (Exception ex)
            {

            }
        }