예제 #1
0
 public AdmissionFormViewModel GetViewModel(long formno)
 {
     try
     {
         NICTDbContext          db      = new NICTDbContext();
         AdmissionFormViewModel myModel = new AdmissionFormViewModel()
         {
             AboutNICT        = db.AboutNICTs.SingleOrDefault(x => x.Form_No == formno),
             AdmissionForm    = db.AdmisionForms.SingleOrDefault(x => x.Form_No == formno),
             EduQualification = db.EduQualifications.SingleOrDefault(x => x.Form_No == formno),
             Files            = db.Files.Where(x => x.Form_No == formno).ToList(),
             Installment      = db.Installments.Where(x => x.Form_No == formno).OrderByDescending(y => y.Datetime).First(),
             JobExperience    = db.JobExperiences.SingleOrDefault(x => x.Form_No == formno),
             KnowledgeOfComp  = db.KnowledgeOfComps.SingleOrDefault(x => x.Form_No == formno),
             StudentDetail    = db.StudentDetails.SingleOrDefault(x => x.Form_No == formno),
         };
         return(myModel);
     }
     catch (Exception ex)
     {
         return(null);
     }
 }