public ActionResult Index() { List <StudentAddressVM> viewModels = new List <StudentAddressVM>(); StudentAddressBAL balObject = new StudentAddressBAL(); IQueryable <Entities.StudentAddress> entites = balObject.GetAll(); CountryBAL countryBAL = new CountryBAL(); IQueryable <Entities.Country> countries = countryBAL.GetAll(); StateBAL stateBAL = new StateBAL(); IQueryable <Entities.State> states = stateBAL.GetAll(); DistrictBAL DistrictObject = new DistrictBAL(); IQueryable <Entities.District> districts = DistrictObject.GetAll(); CityBAL CityObject = new CityBAL(); IQueryable <Entities.City> cities = CityObject.GetAll(); StudentBAL studentObject = new StudentBAL(); IQueryable <Entities.Student> students = studentObject.GetAll(); foreach (Entities.StudentAddress entity in entites) { StudentAddressVM viewModel = new StudentAddressVM(); viewModel.StudentId = entity.StudentId; viewModel.CurrentAddress = entity.CurrentAddress; viewModel.CurrentCountryId = entity.CurrentCountryId; viewModel.CurrentStateId = entity.CurrentStateId; viewModel.CurrentDistrictId = entity.CurrentDistrictId; viewModel.CurrentCityId = entity.CurrentCityId; viewModel.CurrentCountryName = countries.Where(c => c.CountryId == entity.CurrentCountryId).FirstOrDefault().CountryName; viewModel.CurrentStateName = states.Where(s => s.StateId == entity.CurrentStateId).FirstOrDefault().StateName; viewModel.CurrentDistrictName = districts.Where(c => c.DistrictId == entity.CurrentDistrictId).FirstOrDefault().DistrictName; viewModel.CurrentCityName = cities.Where(c => c.CityId == entity.CurrentDistrictId).FirstOrDefault().CityName; viewModel.PermentAddress = entity.PermentAddress; viewModel.PermentCountryId = entity.PermentCountryId; viewModel.PermentStateId = entity.PermentStateId; viewModel.PermentDistrictId = entity.PermentDistrictId; viewModel.PermentCityId = entity.PermentCityId; viewModel.PermentCountryName = countries.Where(c => c.CountryId == entity.PermentCountryId).FirstOrDefault().CountryName; viewModel.PermentStateName = states.Where(s => s.StateId == entity.PermentStateId).FirstOrDefault().StateName; viewModel.PermentDistrictName = districts.Where(c => c.DistrictId == entity.PermentDistrictId).FirstOrDefault().DistrictName; viewModel.PermentCityName = cities.Where(c => c.CityId == entity.PermentCityId).FirstOrDefault().CityName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; Entities.Student student = students.Where(s => s.StudentId == entity.StudentId).FirstOrDefault(); viewModel.StudentFullNameWithTitle = string.Concat(student.Title, " ", student.FirstName, " ", student.MiddleName, " ", student.LastName); viewModels.Add(viewModel); } return(View(new GridModel <StudentAddressVM> { Data = viewModels })); }
// // GET: /SysAdmin/Student/Edit/5 public ActionResult Edit(int id) { StudentAddressVM viewModel = new StudentAddressVM(); CountryBAL countryBAL = new CountryBAL(); viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem() { Text = obj.CountryName, Value = obj.CountryId.ToString() }; //Get Student Id StudentBAL balStudentObject = new StudentBAL(); IQueryable <Entities.Student> studentEntities = balStudentObject.FindBy(s => s.SrNo == id); if (studentEntities != null && studentEntities.Count() > 0) { Entities.Student studentEnity = studentEntities.FirstOrDefault(); viewModel.StudentId = studentEnity.StudentId; viewModel.StudentFullNameWithTitle = string.Concat(studentEnity.Title.Trim(), " ", studentEnity.FirstName.Trim(), " ", studentEnity.MiddleName.Trim(), " ", studentEnity.LastName).Trim(); viewModel.Status = true; } StudentAddressBAL balObject = new StudentAddressBAL(); IQueryable <Entities.StudentAddress> entites = balObject.GetAll(viewModel.StudentId); if (entites != null && entites.Count() > 0) { Entities.StudentAddress entity = entites.FirstOrDefault(); //viewModel.StudentId = entity.StudentId; //viewModel.StudentFullNameWithTitle = entity.StudentFullName; viewModel.CurrentAddress = entity.CurrentAddress; viewModel.CurrentCountryId = entity.CurrentCountryId; viewModel.CurrentStateId = entity.CurrentStateId; viewModel.CurrentDistrictId = entity.CurrentDistrictId; viewModel.CurrentCityId = entity.CurrentCityId; viewModel.PermentAddress = entity.PermentAddress; viewModel.PermentCountryId = entity.PermentCountryId; viewModel.PermentStateId = entity.PermentStateId; viewModel.PermentDistrictId = entity.PermentDistrictId; viewModel.PermentCityId = entity.PermentCityId; viewModel.CurrentPinCode = entity.CurrentPinCode; viewModel.PermentPinCode = entity.PermentPinCode; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; } //else //{ // viewModel.StudentId = id; // viewModel.StudentFullNameWithTitle = PresentationLayer.Other.CommanMethods.GetStudentName(id); // viewModel.Status = true; //} return(View(viewModel)); }