public static string Csvinsert()
{
List<MyMappedCSVFile> values = File.ReadAllLines(@"C:\Users\Sanket\Desktop\Neudesic\CSVRecord")
.Skip(1)
.Select(v => MyMappedCSVFile.FromCsv(v))
.ToList();
foreach (var rowl in values)
{
EmployeeEntities _repo = new EmployeeEntities();
EMP emp = new EMP();
Console.WriteLine(rowl);
emp.EID = rowl.EID;
emp.ENAME = rowl.Name;
emp.DOB = rowl.DOB;
emp.LOCATION = rowl.location;
emp.DOJ = rowl.DOJ;
try
{
_repo.EMPs.Add(emp);
_repo.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString() + "Warning");
}
}
Console.WriteLine("\n Want to enter another option ? y/n");
string choice2 = Console.ReadLine();
return choice2;
}
public static MyMappedCSVFile FromCsv(string csvLine)
{
string[] values = csvLine.Split(',');
MyMappedCSVFile obj = new MyMappedCSVFile();
obj.EID = Convert.ToInt32(values[0]);
obj.Name = Convert.ToString(values[2]);
obj.DOB = Convert.ToDateTime(values[10]);
obj.location = Convert.ToString(values[34]);
obj.DOJ = Convert.ToDateTime(values[14]);
return obj;
}
