public List <FieldVisitStExcel> FindRowsFromExcel(string[][] parseline, Dictionary <string, int> valueDictionary)
{
var distinctStudents = new List <FieldVisitStExcel>();
var sctx = new ApplicationDbContext();
var students = sctx.FieldVisitStExcel.ToList();
try
{
var parselineData = parseline.Skip(1).Distinct();
foreach (var eachStudent in parselineData)
{
var studentDetails = new FieldVisitStExcel();
studentDetails.CollegeFullName = eachStudent[valueDictionary["College"]];
studentDetails.CollegeShortName = eachStudent[valueDictionary["CollegeCode"]];
studentDetails.DateandTime = eachStudent[valueDictionary["Date"]];
studentDetails.Time = eachStudent[valueDictionary["Time"]];
studentDetails.Course = eachStudent[valueDictionary["Course"]];
studentDetails.Discussion = eachStudent[valueDictionary["Discussion"]];
studentDetails.Email = eachStudent[valueDictionary["Email"]];
studentDetails.FacebookURL = eachStudent[valueDictionary["FacebookURL"]];
studentDetails.Imagination = eachStudent[valueDictionary["Dream"]];
studentDetails.MobileNo = eachStudent[valueDictionary["Cell"]];
studentDetails.Name = eachStudent[valueDictionary["PersonName"]];
studentDetails.IsIntrestedInFirstMeet =
eachStudent[valueDictionary["Interested during First Meeting"]];
studentDetails.Replyed = eachStudent[valueDictionary["Replyed"]];
studentDetails.Year = eachStudent[valueDictionary["Year"]];
studentDetails.ContactAgain = eachStudent[valueDictionary["ContactAgain"]];
studentDetails.LKTM = eachStudent[valueDictionary["LKTM"]];
if (!string.IsNullOrEmpty(studentDetails.Name))
{
distinctStudents.Add(studentDetails);
if (!students.Any(s => s.Name == studentDetails.Name) &&
!students.Any(s => s.CollegeFullName == studentDetails.CollegeFullName))
{
sctx.FieldVisitStExcel.Add(studentDetails);
}
else
{
studentDetails.Id = students
.Where(s => s.Name == studentDetails.Name &&
s.CollegeFullName == studentDetails.CollegeFullName).Select(c => c.Id)
.FirstOrDefault();
}
}
}
sctx.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
return(distinctStudents);
}
public StudentDetailResponse GetStudents()
{
var studentDetailResponse = new StudentDetailResponse();
var studentDetailList = new List <FieldVisitStExcel>();
try
{
var students = _sctx.FieldVisitStExcel.ToList();
foreach (var student in students)
{
var studentDetails = new FieldVisitStExcel();
studentDetails.Id = student.Id;
studentDetails.CollegeFullName = student.CollegeFullName;
studentDetails.CollegeShortName = student.CollegeShortName;
studentDetails.DateandTime = student.DateandTime;
studentDetails.Time = student.Time;
studentDetails.Course = student.Course;
studentDetails.Discussion = student.Discussion;
studentDetails.Email = student.Email;
studentDetails.FacebookURL = student.FacebookURL;
studentDetails.Imagination = student.Imagination;
studentDetails.MobileNo = student.MobileNo;
studentDetails.Name = student.Name;
studentDetails.IsIntrestedInFirstMeet = student.IsIntrestedInFirstMeet;
studentDetails.Replyed = student.Replyed;
studentDetails.Year = student.Year;
studentDetails.ContactAgain = student.IsContactAgain;
studentDetails.LKTM = student.LKTM;
studentDetailList.Add(studentDetails);
}
}
catch (Exception)
{
}
studentDetailResponse.Students = studentDetailList;
return(studentDetailResponse);
}
