public static bool CreateStudent(studentprofile stuprofile)
{
using (var context = new AssessmentContext())
{
context.Database.Connection.Open();
stuprofile.CreatedDate = DateTime.Now;
stuprofile.LastModifiedDate = DateTime.Now;
context.studentprofile.Add(stuprofile);
context.SaveChanges();
var userexists = context.studentprofile.Select(x => x.FirstName == stuprofile.FirstName && x.LastName == stuprofile.LastName && x.DoB == stuprofile.DoB).FirstOrDefault();
return(userexists);
}
}
public static bool ModifyStudent(studentprofile stuprofile)
{
using (var context = new AssessmentContext())
{
try
{
context.Database.Connection.Open();
studentprofile studentPro = context.studentprofile.Where(x => x.iD == stuprofile.iD).First();
studentPro.FirstName = stuprofile.FirstName;
studentPro.LastName = stuprofile.LastName;
studentPro.DoB = stuprofile.DoB;
studentPro.Emailaddress = stuprofile.Emailaddress;
studentPro.LastModifiedDate = DateTime.Now;
context.SaveChanges();
}
catch (System.Data.Entity.Core.OptimisticConcurrencyException)
{
}
var userexists = context.studentprofile.Select(x => x.FirstName == stuprofile.FirstName && x.LastName == stuprofile.LastName && x.DoB == stuprofile.DoB).FirstOrDefault();
return(userexists);
}
}