public List <studentfile> GetUploadedFile(string Id) { try { List <studentfile> studentfiles = new List <studentfile>(); List <studentfile> studentfiles1 = new List <studentfile>(); List <studentfile> studentfiles2 = new List <studentfile>(); studentfile studentfiles3 = new studentfile(); using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context()) { studentfiles1 = db.StudentIdupload.Where(x => x.StudentId.ToString() == Id && x.IsActive == true).Select(x => new studentfile { FileID = x.StudentUploadId, FileName = x.UploadFileName, FileType = x.UploadFileTitile }).ToList(); studentfiles.AddRange(studentfiles1); studentfiles2 = db.CertificateUpload.Where(x => x.StudentId.ToString() == Id && x.IsActive == true).Select(x => new studentfile { FileID = x.CertificteUploadId, FileName = x.UploadFileName, FileType = x.UploadFileTitile }).ToList(); studentfiles.AddRange(studentfiles2); var data = db.StudentDetails.Where(x => x.StudentId.ToString() == Id && x.IsActive == true).FirstOrDefault(); var d = data.StudentPhoto.Split("\\"); studentfiles3 = new studentfile { FileID = data.StudentId, FileName = d[8], FileType = "UploadPhoto" }; studentfiles.Add(studentfiles3); } return(studentfiles); } catch (Exception ex) { throw ex; } }
public Student GetStudentByID(string Id) { try { Student student = new Student(); List <studentfile> studentfiles = new List <studentfile>(); List <studentfile> studentfiles1 = new List <studentfile>(); List <studentfile> studentfiles2 = new List <studentfile>(); studentfile studentfiles3 = new studentfile(); using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context()) { student = (from s in db.StudentDetails from c in db.Course .Where(x => x.StudentId.ToString() == Id && s.IsActive == true).DefaultIfEmpty() from b in db.InBranch .Where(x => x.BranchId == s.BranchId).DefaultIfEmpty() from m in db.MainCourse .Where(x => x.MainCourseId == s.MainCourseId).DefaultIfEmpty() from mc in db.MainCourse .Where(x => x.MainCourseId == c.MainCourseId).DefaultIfEmpty() select new Student { StudentID = s.StudentId, CourseID = c.CourseId, CourseName = mc.Name, mainCourseID = mc.MainCourseId, FirstName = s.StudentFname, LastName = s.StudentLname, MiddleName = s.StudentMname, DOB = s.Dob, Gender = s.Gender, ParentName = s.ParentName, ParentMobileNo = s.ParentMobile, Email = s.Email, UserName = s.UserName, Password = s.Password, ContactNo = s.Mobile, AlternateContactNo = s.AlternateMobile, Location = s.Location, City = s.City, Address = s.Address, PinCode = s.Pincode, State = s.State, Coutry = s.Country, BranchID = s.BranchId, BranchName = b.BranchName, RegistrationDate = c.RegistrationDate, CourseStartDate = c.CourseStartDate, Batch = c.Batch, RegisterNo = c.RegistratioinNumber, RollNumber = c.RollNo, DiscountAmount = c.DiscountAmount, ReferedPerson = c.ReferredPerson, SourceOfEnquiry = c.SourceOfEnquiry, FeeDiscountApplicable = c.FeeDiscountApplicable, TypeofDiscount = c.TypeOfDiscount, Comments = s.Comments, IdProofType = c.IdproofType, IdProofNo = c.IdproofNumber, IsActive = s.IsActive, CreatedDate = s.CreatedDate, UploadedFile = studentfiles } ).Where(x => x.IsActive == true).OrderByDescending(x => x.CreatedDate).FirstOrDefault(); } return(student); } catch (Exception ex) { throw ex; } }