public void writeToCsv(string connectionString) { _studentToDB = new StudentToDB(connectionString); _studentToDB.WriteToCsvFile(); }
public static void boolLoadFromCSV(string fileName) { List<StudentModel> studentModel = new List<StudentModel>(); StudentModel tempStudent = new StudentModel(); _studentToDBObject = new StudentToDB(_connectionString); using (var fileReader = new StreamReader(fileName)) { string line; string[] details; while ((line = fileReader.ReadLine()) != null) { details = line.Split(','); tempStudent.Name = details[0]; tempStudent.EnrollmentNumber = Convert.ToInt32(details[1]); tempStudent.Marks = Convert.ToInt32(details[2]); tempStudent.Age = Convert.ToInt32(details[3]); tempStudent.Gender = details[4]; studentModel.Add(tempStudent); } } _studentToDBObject.InsertStudent(studentModel); }
public void AddStudent(string connectionString, string name, int enrollmentnumber, int marks, int age, string gender) { _studentToDB = new StudentToDB(connectionString); _studentToDB.AddNewStudent(name, enrollmentnumber, marks, age, gender); }