protected override void Seed(MYMA.Students.DAL.StudentDbContext context) { // This method will be called after migrating to the latest version. // You can use the DbSet<T>.AddOrUpdate() helper extension method // to avoid creating duplicate seed data. }
public override Task <StudentList> GetAllStudents(Empty request, ServerCallContext context) { var result = new StudentList(); try { using (MYMA.Students.DAL.StudentDbContext dbContext = new MYMA.Students.DAL.StudentDbContext()) { result.Students.AddRange( dbContext.Students.ToList() .Select(y => new Student() { AdmisstionDate = Google.Protobuf.WellKnownTypes.Timestamp.FromDateTime(y.AdmisstionDate.ToUniversalTime()), DateofBirth = Google.Protobuf.WellKnownTypes.Timestamp.FromDateTime(y.DateofBirth.ToUniversalTime()), FirstName = y.FirstName, LastName = y.LastName, MiddleName = y.MiddleName, Id = y.Id, MobileNumber = y.MobileNumber, UrduName = y.UrduName })); } } catch (Exception e) { var err = e.ToString(); } return(Task.FromResult(result)); }
public override Task <TransResult> RemoveStudnet(StudentId request, ServerCallContext context) { using (MYMA.Students.DAL.StudentDbContext dbContext = new MYMA.Students.DAL.StudentDbContext()) { var todelete = dbContext.Students.FirstOrDefault(s => s.Id == request.Id); var entitytoupdate = dbContext.Students.Remove(todelete); dbContext.SaveChanges(); } return(default);
public override Task <Student> GetStudent(StudentId request, ServerCallContext context) { var result = new Student(); using (MYMA.Students.DAL.StudentDbContext dbContext = new MYMA.Students.DAL.StudentDbContext()) { var record = dbContext.Students.FirstOrDefault(s => s.Id == request.Id); result.AdmisstionDate = Google.Protobuf.WellKnownTypes.Timestamp.FromDateTime(record.AdmisstionDate.ToUniversalTime()); result.DateofBirth = Google.Protobuf.WellKnownTypes.Timestamp.FromDateTime(record.DateofBirth.ToUniversalTime()); result.FirstName = record.FirstName; result.LastName = record.LastName; result.MiddleName = record.MiddleName; result.Id = record.Id; result.MobileNumber = record.MobileNumber; result.UrduName = record.UrduName; } return(Task.FromResult(result)); }
public override Task <Student> InsertStudent(Student request, ServerCallContext context) { using (MYMA.Students.DAL.StudentDbContext dbContext = new MYMA.Students.DAL.StudentDbContext()) { var entitytoupdate = dbContext.Students.Add(new Models.Student { LastName = request.LastName, MiddleName = request.MiddleName, FirstName = request.FirstName, DateofBirth = request.DateofBirth.ToDateTime(), AdmisstionDate = request.AdmisstionDate.ToDateTime(), MobileNumber = request.MobileNumber, UrduName = request.UrduName, Id = request.Id }); try { dbContext.SaveChanges(); } catch (DbEntityValidationException er) { foreach (var eve in er.EntityValidationErrors) { foreach (var ve in eve.ValidationErrors) { var error = ve.PropertyName + ve.ErrorMessage; } } } catch (Exception e) { var err = e.ToString(); throw; } } return(Task.FromResult(request)); }