예제 #1
0
 public int Addstudent(StudInfo1 student)
 {
     try
     {
         Exercise_ERContainer cn = new Exercise_ERContainer();
         if (cn.StudInfo1Set.Find(student.studentid) == null)
         {
             cn.StudInfo1Set.Add(student);
         }
         cn.SaveChanges();
         return(1);
     }
     //catch (DbEntityValidationException ex)
     catch (Exception ex)
     {
         Console.WriteLine(ex.Message);
         return(0);
     }
 }
예제 #2
0
        ////endfromexcel//////////////////

        /////save student to db

        /////save student to db

        public static void savestudents(int classid)
        {
            Service_stuClient serviceDB = new Service_stuClient();
            List <Exercise_DAL.class_student> c_studl  = new List <Exercise_DAL.class_student>();
            List <Exercise_DAL.StudInfo1>     studentl = new List <Exercise_DAL.StudInfo1>();

            foreach (Student st in studentList)
            {
                Exercise_DAL.StudInfo1 sttemp = new Exercise_DAL.StudInfo1();
                sttemp.studentid = st.studentid;
                sttemp.name      = st.name;
                sttemp.pd        = "11111111";
                Exercise_DAL.class_student c_st = new Exercise_DAL.class_student();
                c_st.classid   = classid;
                c_st.studentid = st.studentid;
                c_st.classno   = st.no;
                c_studl.Add(c_st);
                studentl.Add(sttemp);
            }
            serviceDB.Addstu(c_studl, studentl);
            ///////////////////////////////////////////////
        }