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 WriteToCsvFile()
{
FileStream writerObject = File.Create("C:\\hack\\Write.csv");
writerObject.Close();
SqlConnection connection = new SqlConnection(_connectionString);
connection.Open();
string query = @"select * from Student";
SqlCommand command = new SqlCommand(query, connection);
SqlDataReader reader = command.ExecuteReader();
StudentModel studentModelObject;
using (StreamWriter writer = new StreamWriter("C:\\hack\\Write.csv"))
{
while (reader.Read())
{
studentModelObject = new StudentModel();
studentModelObject.Name = reader["Name"].ToString();
studentModelObject.EnrollmentNumber = Convert.ToInt32(reader["EnrollmentNumber"].ToString());
studentModelObject.Marks = Convert.ToInt32(reader["Marks"].ToString());
studentModelObject.Age = Convert.ToInt32(reader["Age"].ToString());
studentModelObject.Gender = reader["Gender"].ToString();
writer.Write(studentModelObject.Name + ",");
writer.Write(studentModelObject.EnrollmentNumber + ",");
writer.Write(studentModelObject.Marks + ",");
writer.Write(studentModelObject.Age + ",");
writer.Write(studentModelObject.Gender);
}
}
connection.Close();
}
