public ActionResult Edit(DistrictVM viewModel) { try { // TODO: Add update logic here if (ModelState.IsValid) { Entities.District entity = new Entities.District(); entity.DistrictId = viewModel.DistrictId; entity.StateId = viewModel.StateId; entity.DistrictName = viewModel.DistrictName; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; DistrictBAL balObject = new DistrictBAL(); balObject.Edit(entity); return(RedirectToAction("Index")); } else { // AcademicYearBAL academicYearBAL = new AcademicYearBAL(); // viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() }; return(View(viewModel)); } } catch { // AcademicYearBAL academicYearBAL = new AcademicYearBAL(); // viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() }; return(View()); } }
public ActionResult Select() { string mode = Request.QueryString["Grid-mode"]; if (!string.IsNullOrEmpty(mode)) { return(this.RedirectToAction("Create")); } else { List <DistrictVM> viewModels = new List <DistrictVM>(); DistrictBAL balObject = new DistrictBAL(); IQueryable <Entities.District> entites = balObject.GetAll(); foreach (Entities.District entity in entites) { DistrictVM viewModel = new DistrictVM(); viewModel.DistrictId = entity.DistrictId; viewModel.DistrictName = entity.DistrictName; viewModel.StateName = entity.StateName; viewModel.CountryName = entity.CountryName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(View(new GridModel <DistrictVM> { Data = viewModels })); } }
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 })); }
/// <summary> /// method for get state list /// </summary> /// <returns>District list</returns> public JsonResult GetDistrictList() { DistrictBAL balObject = new DistrictBAL(); var destrictList = from obj in balObject.GetAll() select new SelectListItem() { Text = obj.DistrictName, Value = obj.DistrictId.ToString() }; return(this.Json(destrictList, JsonRequestBehavior.AllowGet)); }
/// <summary> /// method for get District list /// </summary> /// <returns>District list</returns> public JsonResult GetPermentDistrictList(int PermentStateId) { DistrictBAL balObject = new DistrictBAL(); var districtList = from obj in balObject.GetAll().Where(c => c.StateId == PermentStateId && c.Status == true) select new SelectListItem() { Text = obj.DistrictName, Value = obj.DistrictId.ToString() }; return(this.Json(districtList, JsonRequestBehavior.AllowGet)); }
// // GET: /SysAdmin/City/Create public ActionResult Create() { CityVM viewModel = new CityVM(); DistrictBAL districtBAL = new DistrictBAL(); viewModel.Districts = from obj in districtBAL.GetAll() select new SelectListItem() { Text = obj.DistrictName, Value = obj.DistrictId.ToString() }; viewModel.Status = true; return(View(viewModel)); }
// // POST: /SysAdmin/District/Delete/5 //[HttpPost] public ActionResult Delete(int id) { try { // TODO: Add delete logic here DistrictBAL balObject = new DistrictBAL(); balObject.Delete(id); return(RedirectToAction("Index")); } catch { return(View()); } }
// // GET: /SysAdmin/District/Details/5 public ActionResult Details(int id) { DistrictVM viewModel = new DistrictVM(); DistrictBAL balObject = new DistrictBAL(); IQueryable <Entities.District> entites = balObject.FindBy(a => a.DistrictId == id); if (entites != null && entites.Count() > 0) { Entities.District entity = entites.FirstOrDefault(); viewModel.DistrictId = entity.DistrictId; viewModel.DistrictName = entity.DistrictName; StateBAL stateBAL = new StateBAL(); IQueryable <Entities.State> states = stateBAL.GetAll(); viewModel.StateName = stateBAL.FindBy(c => c.StateId == entity.StateId).FirstOrDefault().StateName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; } return(View(viewModel)); }
// // GET: /SysAdmin/City/Details/5 public ActionResult Details(int id) { CityVM viewModel = new CityVM(); CityBAL balObject = new CityBAL(); IQueryable <Entities.City> entites = balObject.FindBy(a => a.CityId == id); if (entites != null && entites.Count() > 0) { Entities.City entity = entites.FirstOrDefault(); viewModel.CityId = entity.CityId; viewModel.CityName = entity.CityName; DistrictBAL districtBAL = new DistrictBAL(); IQueryable <Entities.District> states = districtBAL.GetAll(); viewModel.DistrictName = districtBAL.FindBy(c => c.DistrictId == entity.DistrictId).FirstOrDefault().DistrictName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; } return(View(viewModel)); }
public ActionResult Index() { List <DistrictVM> viewModels = new List <DistrictVM>(); DistrictBAL balObject = new DistrictBAL(); IQueryable <Entities.District> entites = balObject.GetAll(); foreach (Entities.District entity in entites) { DistrictVM viewModel = new DistrictVM(); viewModel.DistrictId = entity.DistrictId; viewModel.DistrictName = entity.DistrictName; viewModel.StateName = entity.StateName; viewModel.CountryName = entity.CountryName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(View(new GridModel <DistrictVM> { Data = viewModels })); }
// // GET: /SysAdmin/District/Edit/5 public ActionResult Edit(int id) { DistrictVM viewModel = new DistrictVM(); DistrictBAL balObject = new DistrictBAL(); IQueryable <Entities.District> entites = balObject.FindBy(a => a.DistrictId == id); if (entites != null && entites.Count() > 0) { Entities.District entity = entites.FirstOrDefault(); viewModel.DistrictId = entity.DistrictId; viewModel.DistrictName = entity.DistrictName; viewModel.StateId = entity.StateId; viewModel.StateName = entity.StateName; viewModel.CountryName = entity.CountryName; viewModel.CountryId = entity.CountryId; viewModel.StateName = entity.StateName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; } return(View(viewModel)); }
public ActionResult Create(CityVM viewModel) { try { // TODO: Add insert logic here if (ModelState.IsValid) { Entities.City entity = new Entities.City(); entity.CityId = viewModel.CityId; entity.DistrictId = viewModel.DistrictId; entity.CityName = viewModel.CityName; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; CityBAL balObject = new CityBAL(); balObject.Add(entity); return(RedirectToAction("Index")); } else { DistrictBAL destrictBAL = new DistrictBAL(); viewModel.Districts = from obj in destrictBAL.GetAll() select new SelectListItem() { Text = obj.DistrictName, Value = obj.DistrictId.ToString() }; return(View(viewModel)); } } catch { DistrictBAL destrictBAL = new DistrictBAL(); viewModel.Districts = from obj in destrictBAL.GetAll() select new SelectListItem() { Text = obj.DistrictName, Value = obj.DistrictId.ToString() }; return(View(viewModel)); } }
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); }