// // GET: /SysAdmin/Student/Edit/5 public ActionResult Edit(int id) { StudentParentVM viewModel = new StudentParentVM(); 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; } StudentParentBAL balObject = new StudentParentBAL(); IQueryable <Entities.StudentParent> entites = balObject.FindBy(a => a.StudentId == viewModel.StudentId); if (entites != null && entites.Count() > 0) { Entities.StudentParent entity = entites.FirstOrDefault(); viewModel.Title = entity.Title.Trim(); viewModel.FirstName = entity.FirstName.Trim(); viewModel.MiddleName = entity.MiddleName.Trim(); viewModel.LastName = entity.LastName.Trim(); viewModel.Gender = entity.Gender.Trim(); viewModel.CurrentAddress = entity.Address.Trim(); viewModel.CurrentCountryId = entity.CountryId; viewModel.CurrentStateId = entity.StateId; viewModel.CurrentDistrictId = entity.DistrictId; viewModel.CurrentCityId = entity.CityId; viewModel.CurrentPinCode = entity.PinCode; viewModel.MobileNo = entity.MobileNumber; viewModel.ContactNumber = entity.ContactNo; viewModel.Occupation = entity.Occupation.Trim(); viewModel.CompanyName = entity.CompanyName.Trim(); viewModel.CompanyAddress = entity.CompanyAddress.Trim(); viewModel.CompanyContactNo = entity.CompanyContactNo.Trim(); viewModel.BankName = entity.BankName.Trim(); viewModel.AccountNo = entity.AccountNo.Trim(); viewModel.Branch = entity.Branch.Trim(); viewModel.IFSCCode = entity.IFSCCode.Trim(); // viewModel.StudentFullNameWithTitle = entity.StudentFullName.Trim(); viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; } //else //{ // viewModel.StudentFullNameWithTitle = PresentationLayer.Other.CommanMethods.GetStudentName(id); // viewModel.Status = true; //} return(View(viewModel)); }
public ActionResult Edit(StudentParentVM viewModel) { try { // TODO: Add update logic here if (ModelState.IsValid) { Entities.StudentParent entity = new Entities.StudentParent(); entity.StudentId = viewModel.StudentId; entity.Title = viewModel.Title; entity.FirstName = viewModel.FirstName; entity.MiddleName = viewModel.MiddleName; entity.LastName = viewModel.LastName; entity.Gender = viewModel.Gender; entity.Address = viewModel.CurrentAddress; entity.CountryId = viewModel.CurrentCountryId; entity.StateId = viewModel.CurrentStateId; entity.DistrictId = viewModel.CurrentDistrictId; entity.CityId = viewModel.CurrentCityId; entity.PinCode = viewModel.CurrentPinCode.HasValue ? Convert.ToInt32(viewModel.CurrentPinCode) : 0; entity.MobileNumber = viewModel.MobileNo; entity.ContactNo = viewModel.ContactNumber; entity.Occupation = viewModel.Occupation; entity.CompanyName = viewModel.CompanyName; entity.CompanyAddress = viewModel.CompanyAddress; entity.CompanyContactNo = viewModel.CompanyContactNo; entity.BankName = string.IsNullOrEmpty(viewModel.BankName) ? string.Empty : viewModel.BankName.Trim(); entity.AccountNo = string.IsNullOrEmpty(viewModel.AccountNo) ? string.Empty : viewModel.AccountNo.Trim(); entity.Branch = string.IsNullOrEmpty(viewModel.Branch) ? string.Empty : viewModel.Branch.Trim(); entity.IFSCCode = string.IsNullOrEmpty(viewModel.IFSCCode) ? string.Empty : viewModel.IFSCCode.Trim(); entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; StudentParentBAL balObject = new StudentParentBAL(); IQueryable <Entities.StudentParent> StudentParents = balObject.FindBy(s => s.StudentId == viewModel.StudentId); if (StudentParents != null && StudentParents.Count() > 0) { balObject.Edit(entity); } else { balObject.Add(entity); } return(RedirectToAction("Index", "Student")); } else { 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() }; return(View(viewModel)); } } catch { 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() }; return(View()); } }
private DataSet LeavingCertificate(int StudentId) { DataSet ds = new DataSet(); ds.DataSetName = "DataSourceForReport"; DataTable dt = new DataTable("LeavingCertificate"); dt.TableName = "LeavingCertificate"; dt.Columns.Add(new DataColumn("StudentId", typeof(string))); dt.Columns.Add(new DataColumn("FirstName", typeof(string))); dt.Columns.Add(new DataColumn("MiddleName", typeof(string))); dt.Columns.Add(new DataColumn("LastName", typeof(string))); dt.Columns.Add(new DataColumn("MotherName", typeof(string))); dt.Columns.Add(new DataColumn("MotherTounge", typeof(string))); dt.Columns.Add(new DataColumn("ReligionName", typeof(string))); dt.Columns.Add(new DataColumn("CastName", typeof(string))); dt.Columns.Add(new DataColumn("SubCast", typeof(string))); dt.Columns.Add(new DataColumn("Nationality", typeof(string))); dt.Columns.Add(new DataColumn("PlaceOfBirth", typeof(string))); dt.Columns.Add(new DataColumn("DateOfBirth", typeof(DateTime))); dt.Columns.Add(new DataColumn("DateOfBirthInWord", typeof(string))); dt.Columns.Add(new DataColumn("LastSchool", typeof(string))); dt.Columns.Add(new DataColumn("DateOfAdmission", typeof(DateTime))); dt.Columns.Add(new DataColumn("Progress", typeof(string))); dt.Columns.Add(new DataColumn("Conduct", typeof(string))); dt.Columns.Add(new DataColumn("DateOfLeaveingSchool", typeof(DateTime))); dt.Columns.Add(new DataColumn("ClassInWhichStudingAndSinceWhen", typeof(string))); dt.Columns.Add(new DataColumn("Reason", typeof(string))); dt.Columns.Add(new DataColumn("Remark", typeof(string))); dt.Columns.Add(new DataColumn("RegisterNo", typeof(int))); dt.Columns.Add(new DataColumn("TCNo", typeof(string))); dt.Columns.Add(new DataColumn("TCPrinted", typeof(bool))); dt.Columns.Add(new DataColumn("AdharcardNo", typeof(string))); dt.Columns.Add(new DataColumn("DateOfLeaveingSchoolInWords", typeof(string))); dt.Columns.Add(new DataColumn("Taluka", typeof(string))); dt.Columns.Add(new DataColumn("District", typeof(string))); dt.Columns.Add(new DataColumn("state", typeof(string))); dt.Columns.Add(new DataColumn("Country", typeof(string))); int studentId = (int)PresentationLayer.Helpers.SessionHelper.StudentId; // Fetch the District, State, Country from database *********** string strDistrict, strState, strCountry, strCity; strDistrict = strState = strCountry = strCity = ""; //balObject.FindBy(s => s.StudentId == studentId ); StudentParentBAL balObjectAddr = new StudentParentBAL(); IQueryable <Entities.StudentParent> entites1 = balObjectAddr.FindBy(s => s.StudentId == studentId); if (entites1 != null && entites1.Count() > 0) { Entities.StudentParent entity1 = entites1.FirstOrDefault(); 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> District = DistrictObject.GetAll(); CityBAL CityObject = new CityBAL(); IQueryable <Entities.City> Cities = CityObject.GetAll(); strCountry = countries.Where(c => c.CountryId == entity1.CountryId).FirstOrDefault().CountryName; strState = states.Where(s => s.StateId == entity1.StateId).FirstOrDefault().StateName; strDistrict = District.Where(c => c.DistrictId == entity1.DistrictId).FirstOrDefault().DistrictName; strCity = Cities.Where(c => c.CityId == entity1.CityId).FirstOrDefault().CityName; } // ********* StudentBAL balObject = new StudentBAL(); //IQueryable<Entities.Student> entites = balObject.FindBy(s => s.StudentId == studentId ); IQueryable <Entities.Student> entites = balObject.GetAll(SessionHelper.SchoolId).Where(c => c.StudentId == studentId); if (entites != null && entites.Count() > 0) { Entities.Student entity = entites.FirstOrDefault(); DataRow dr = dt.NewRow(); dr["StudentId"] = entity.UStudentId; dr["FirstName"] = entity.FirstName.Trim(); dr["MiddleName"] = entity.MiddleName.Trim();; dr["LastName"] = entity.LastName.Trim();; dr["MotherName"] = entity.MotherName.Trim();; dr["ReligionName"] = entity.ReligionName.Trim();; dr["CastName"] = entity.CastName.Trim(); dr["SubCast"] = ""; //TODO dr["Nationality"] = entity.Nationality.Trim(); dr["DateOfBirth"] = entity.DateOfBirth; //Date dr["PlaceOfBirth"] = entity.PlaceOfBirth; if (entity.DateOfBirth != null) { dr["DateOfBirthInWord"] = DateToText(entity.DateOfBirth); } else { dr["DateOfBirthInWord"] = ""; } dr["LastSchool"] = entity.LastSchoolAttended; dr["DateOfAdmission"] = entity.DateOfAdmission; //Date if (entity.DateOfAdmission != null) { dr["DateOfAdmission"] = entity.DateOfAdmission;//Date } dr["Progress"] = entity.Progress; dr["Conduct"] = entity.Conduct; if (entity.DateOfLeavingSchool != null) { dr["DateOfLeaveingSchool"] = entity.DateOfLeavingSchool;//Date dr["DateOfLeaveingSchoolInWords"] = DateToText((System.DateTime)entity.DateOfLeavingSchool); } else { dr["DateOfLeaveingSchoolInWords"] = ""; } dr["ClassInWhichStudingAndSinceWhen"] = entity.ClassInWhichStudingAndSinceWhen; dr["Reason"] = entity.ReasonForLeavingSchool; dr["Remark"] = entity.RemarkOnTC; dr["RegisterNo"] = entity.RegisterId; dr["TCPrinted"] = entity.TCPrinted; if (!entity.TCPrinted) { long maxTCNo = balObject.GetMaxTCNo(); dr["TCNo"] = FormatedTCNo(Convert.ToString(maxTCNo + 1)); //if (isPrintExport) // UpdateTCDetails(studentId); } else { dr["TCNo"] = FormatedTCNo(Convert.ToString(entity.TCNo)); } if (isPrintExport) { UpdateTCDetails(studentId); } dr["AdharcardNo"] = entity.AdharcardNo; dr["MotherTounge"] = entity.MotherTounge; // **** dr["Taluka"] = strCity; dr["District"] = strDistrict; dr["state"] = strState; dr["Country"] = strCountry; dt.Rows.Add(dr); reportName = entity.RegisterId + "_" + entity.LastName.Trim() + "_" + entity.FirstName.Trim(); } ds.Tables.Add(getSchoolDetails()); ds.Tables.Add(dt); return(ds); }