コード例 #1
0
        public ActionResult PreviousBoardExam(int id)
        {
            StudentInfoViewModel model = new StudentInfoViewModel();

            model.PreviousInstitutionList = new List <StudentInfoPreviousInstitutionViewModel>();
            model.Id = id;

            //var entity = db.StudentInfoPreviousInstitution.Where(m=>m.StudentInfo_FK == id);
            var p = db.StudentInfoPreviousInstitution.Any(m => m.StudentInfo_FK == id);

            if (p == false)
            {
                using (var _sdb = new JamiyahDBEntities())
                {
                    foreach (var item in _sdb.BoardExamination)
                    {
                        StudentInfoPreviousInstitutionViewModel _institutionObj = new StudentInfoPreviousInstitutionViewModel();
                        _institutionObj.ExamName = item.ExminationName;

                        StudentInfoPreviousInstitution _studentInfoPreviousInstitutionEntity = new StudentInfoPreviousInstitution();
                        _studentInfoPreviousInstitutionEntity.ExamName       = _institutionObj.ExamName;
                        _studentInfoPreviousInstitutionEntity.StudentInfo_FK = id;
                        _sdb.StudentInfoPreviousInstitution.Add(_studentInfoPreviousInstitutionEntity);
                        // db.SaveChanges();
                    }
                    //save at the end
                    _sdb.SaveChanges();
                }
            }

            IQueryable <StudentInfoPreviousInstitution> query = db.StudentInfoPreviousInstitution.Where(m => m.StudentInfo_FK == id);

            var data = query.Select(asset => new StudentInfoPreviousInstitutionViewModel()
            {
                Id                  = asset.Id,
                StudentInfo_FK      = asset.StudentInfo_FK,
                ExamName            = asset.ExamName,
                ExamYear            = asset.ExamYear,
                InstitutionName     = asset.InstitutionName,
                InstitutionCode     = asset.InstitutionCode,
                InstitutionDistrict = asset.InstitutionDistrict,
                RegiNo              = asset.RegiNo,
                RollNo              = asset.RollNo,
                Grade               = asset.Grade
            }).ToList();

            model.PreviousInstitutionList = data;

            return(View(model));
        }
コード例 #2
0
        public ActionResult Create(StudentInfoViewModel model, HttpPostedFileBase PostedLogo)
        {
            if (ModelState.IsValid)
            {
                StudentInfo entity = new StudentInfo();

                if (PostedLogo != null)
                {
                    byte[] imgBinaryData = new byte[PostedLogo.ContentLength];
                    int    readresult    = PostedLogo.InputStream.Read(imgBinaryData, 0, PostedLogo.ContentLength);
                    entity.StudentPhoto = imgBinaryData;
                }

                entity.StudentNameBangla                = model.StudentNameBangla;
                entity.StudentNameEnglish               = model.StudentNameEnglish;
                entity.StudentNameArabic                = model.StudentNameArabic;
                entity.StudentDateOfBirth               = model.StudentDateOfBirth;
                entity.GenderId                         = model.GenderId;
                entity.Nationality                      = model.Nationality;
                entity.FatherNameBangla                 = model.FatherNameBangla;
                entity.FatherNameEnglish                = model.FatherNameEnglish;
                entity.FatherIsAlive                    = model.FatherIsAlive;
                entity.FatherOccupation                 = model.FatherOccupation;
                entity.MotherNameBangla                 = model.MotherNameBangla;
                entity.MotherNameEnglish                = model.MotherNameEnglish;
                entity.MotherIsAlive                    = model.MotherIsAlive;
                entity.MotherMobile                     = model.MotherMobile;
                entity.GuardianName                     = model.GuardianName;
                entity.GuardianOccupation               = model.GuardianOccupation;
                entity.GuardianHouseNo                  = model.GuardianHouseNo;
                entity.GuardianVillage                  = model.GuardianVillage;
                entity.GuardianPostOffice               = model.GuardianPostOffice;
                entity.GuardianThana                    = model.GuardianThana;
                entity.GuardianDistrict                 = model.GuardianDistrict;
                entity.RelationWithGuardian             = model.RelationWithGuardian;
                entity.YearlyIncomeGuardian             = model.YearlyIncomeGuardian;
                entity.PermanentAddressHouse            = model.PermanentAddressHouse;
                entity.PermanentAddressVillage          = model.PermanentAddressVillage;
                entity.PermanentAddressPostOffice       = model.PermanentAddressPostOffice;
                entity.PermanentAddressThana            = model.PermanentAddressThana;
                entity.PermanentAddressDistrict         = model.PermanentAddressDistrict;
                entity.HonarablePersonNameInArea        = model.HonarablePersonNameInArea;
                entity.PreviousInstitutionName          = model.PreviousInstitutionName;
                entity.PreviousInstitutionAddress       = model.PreviousInstitutionAddress;
                entity.PreviousInstitutionClass         = model.PreviousInstitutionClass;
                entity.PreviousInstitutionClearanceNo   = model.PreviousInstitutionClearanceNo;
                entity.PreviousInstitutionClearanceDate = model.PreviousInstitutionClearanceDate;
                entity.AdmittedDepartmentId             = model.AdmittedDepartmentId;
                entity.Brach = model.AdmittedBranchId;

                entity.IsAssign = false;

                db.StudentInfo.Add(entity);
                db.SaveChanges();

                model.Id = entity.Id;

                // var entity = db.BoardExamination.All();

                var p = db.StudentInfoPreviousInstitution.Any(m => m.StudentInfo_FK == model.Id);

                if (p == false)
                {
                    using (var _sdb = new JamiyahDBEntities())
                    {
                        foreach (var item in _sdb.BoardExamination)
                        {
                            StudentInfoPreviousInstitutionViewModel _institutionObj = new StudentInfoPreviousInstitutionViewModel();
                            _institutionObj.ExamName = item.ExminationName;

                            StudentInfoPreviousInstitution _studentInfoPreviousInstitutionEntity = new StudentInfoPreviousInstitution();
                            _studentInfoPreviousInstitutionEntity.ExamName       = _institutionObj.ExamName;
                            _studentInfoPreviousInstitutionEntity.StudentInfo_FK = model.Id;
                            _sdb.StudentInfoPreviousInstitution.Add(_studentInfoPreviousInstitutionEntity);
                            // db.SaveChanges();
                        }
                        //save at the end
                        _sdb.SaveChanges();
                    }
                }


                return(RedirectToAction("Edit", new { id = model.Id }));
            }


            ViewBag.GenderId             = new SelectList(db.Gender.OrderBy(m => m.GenderName), "Id", "GenderName");
            ViewBag.AdmittedDepartmentId = new SelectList(db.Department.OrderBy(m => m.Name), "Id", "Name");
            ViewBag.BranchId             = new SelectList(db.Company.OrderBy(m => m.CompanyName), "CompanyKey", "CompanyName");

            return(View(model));
        }