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