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));
}
