public ActionResult DeleteConfirmed(long id) { tblSchool tblSchool = db.tblSchools.Find(id); db.tblSchools.Remove(tblSchool); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,SchoolName,Logo,AddressLine1,AddressLine2,AddressLine3,City,State,Country,Pincode,ContactNo1,ContactNo2,EmailId,StartingYear,CreateDate,UpdateDate")] tblSchool tblSchool) { if (ModelState.IsValid) { db.Entry(tblSchool).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblSchool)); }
public ActionResult Edit([Bind(Include = "SchoolID,Name,District")] tblSchool tblSchool) { if (ModelState.IsValid) { db.Entry(tblSchool).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblSchool)); }
public ActionResult Create([Bind(Include = "SchoolID,Name,District")] tblSchool tblSchool) { if (ModelState.IsValid) { db.tblSchools.Add(tblSchool); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tblSchool)); }
// GET: Schools/Delete/5 public ActionResult Delete(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblSchool tblSchool = db.tblSchools.Find(id); if (tblSchool == null) { return(HttpNotFound()); } return(View(tblSchool)); }
public ActionResult ShowEditExtra(string StudentId, string SchoolId) { StudentExtraCModel TModel = new StudentExtraCModel(); tblStudent TCtable = Connection.tblStudents.SingleOrDefault(x => x.StudentId == StudentId && x.SchoolId == SchoolId); tblSchool schl = Connection.tblSchools.SingleOrDefault(x => x.SchoolId == SchoolId); // TModel.IsActive = TCtable.IsActive; string SchoolName = schl.SchoolName; TModel.StudentId = TCtable.StudentId; TModel.StudentName = TCtable.studentName; TModel.SchoolName = SchoolName; var StudentSextra = Connection.SMGTloadScholExtraCadd(SchoolId, "%").ToList(); List <tblExtraCurricularActivity> result = StudentSextra.Select(x => new tblExtraCurricularActivity { ActivityCode = x.ActivityCode, ActivityName = x.ActivityName }).ToList(); ViewBag.studentextrac = new SelectList(StudentSextra, "ActivityCode", "ActivityName"); TModel.SchoolId = TCtable.SchoolId; return(PartialView("EditStudentEXtra", TModel)); }
public Response SaveSchoolMasterDetails(SchoolMasterCustomModel objModel) { using (response = new Response()) { using (dbcontext = new SchoolManagementEntities()) { try { response.success = true; if (objModel.SchoolId == 0) { var rs = dbcontext.tblSchools.FirstOrDefault(x => x.IsDeleted == false && x.Name == objModel.Name); if (rs == null) { tblSchool objAddNew = new tblSchool { Name = objModel.Name, MobileNo = objModel.MobileNo, ShortDescription = objModel.ShortDescription, EmailId = objModel.EmailId, Address = objModel.Address, Address2 = objModel.Address2, City = objModel.City, Country = objModel.Country, Image = objModel.Image, Logo = objModel.Logo, State = objModel.State, TagLine = objModel.TagLine, DDate = DateTime.Now, IsActive = true, IsDeleted = false, CreatedBy = objModel.CreatedBy, CreatedDate = DateTime.Now, ModifiedBy = objModel.ModifiedBy, ModifiedDate = DateTime.Now }; dbcontext.tblSchools.Add(objAddNew); dbcontext.SaveChanges(); response.responseData = new { SchoolId = objAddNew.SchoolId, Name = objAddNew.Name }; response.message = "Record Added Successfully!"; } else { response.success = false; response.message = "Record Already Exists!"; } } else { var rs = dbcontext.tblSchools.FirstOrDefault(x => x.IsDeleted == false && x.Name == objModel.Name && x.SchoolId != objModel.SchoolId); if (rs == null) { var objUpdate = dbcontext.tblSchools.FirstOrDefault(m => m.SchoolId == objModel.SchoolId); if (objUpdate != null) { objUpdate.Name = objModel.Name; objUpdate.ShortDescription = objModel.ShortDescription; objUpdate.MobileNo = objModel.MobileNo; objUpdate.EmailId = objModel.EmailId; objUpdate.Address = objModel.Address; objUpdate.Address2 = objModel.Address2; objUpdate.City = objModel.City; objUpdate.Country = objModel.Country; objUpdate.Image = objModel.Image; objUpdate.Logo = objModel.Logo; objUpdate.State = objModel.State; objUpdate.TagLine = objModel.TagLine; objUpdate.ModifiedBy = objModel.ModifiedBy; objUpdate.ModifiedDate = DateTime.Now; dbcontext.SaveChanges(); response.responseData = new { SchoolId = objUpdate.SchoolId, Name = objUpdate.Name }; response.message = "Record Updated Successfully!"; } } else { response.success = false; response.message = "Record Already Exists!"; } } return(response); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public ActionResult Edit(StudentModel Model) { string _path = ""; // string _pathL = ""; string _path1 = ""; string _pathL2 = ""; try { if (ModelState.IsValid) { // TODO: Add update logic here if (Model.StudentImageFile.ContentLength > 0) { string fnm = DateTime.Now.ToString(""); string nwString22 = fnm.Replace("-", "."); string nwString = nwString22.Replace("/", "."); string nwString2 = nwString.Replace(" ", "."); string time = nwString2.Replace(":", "."); string _FileName = time + "_" + Path.GetFileName(Model.StudentImageFile.FileName); _path = Path.Combine(Server.MapPath("~/Uploads/Student/Photo"), _FileName); _path1 = "~/Uploads/Student/Photo/" + _FileName; Model.StudentImageFile.SaveAs(_path); } } SchoolModel TModel = new SchoolModel(); StudentModel stdmodel = new StudentModel(); tblStudent tblstudnt = Connection.tblStudents.SingleOrDefault(x => x.StudentId == Model.StudentId); stdmodel.SchoolId = tblstudnt.SchoolId; stdmodel.StudentId = tblstudnt.StudentId; stdmodel.StudentName = tblstudnt.studentName; stdmodel.ModifiedBy = USession.User_Id; stdmodel.ModifiedDate = DateTime.Now; stdmodel.GradeId = tblstudnt.GradeId; stdmodel.HouseId = tblstudnt.HouseId; stdmodel.ClassId = tblstudnt.ClassId; String tblpath = tblstudnt.ImgUrl; stdmodel.DateOfBirth = tblstudnt.DateofBirth; stdmodel.Gender = tblstudnt.Gender; tblSchool TCtable = Connection.tblSchools.SingleOrDefault(x => x.SchoolId == Model.SchoolId); // TModel.IsActive = TCtable.IsActive; if (Model.Gender == null) { Model.Gender = stdmodel.Gender; } if (Model.SchoolId == null) { Model.SchoolId = stdmodel.SchoolId; } if (Model.StudentName == null) { Model.StudentName = stdmodel.StudentName; } if (Model.GradeId == null) { Model.GradeId = stdmodel.GradeId; } if (Model.HouseId == null) { Model.HouseId = stdmodel.HouseId; } if (_path == "") { _path = tblstudnt.ImgUrl; } //if (Model.Email == null) //{ // Model.Email = TModel.Email; //} //if (Model.MinuteforPeriod == null) //{ // Model.MinuteforPeriod = TModel.MinuteforPeriod; //} //if (Model.Telephone == null) //{ // Model.Telephone = TModel.Telephone; //} if (_path1 == "") { _path1 = TModel.ImagePath; } if (_pathL2 == "") { _pathL2 = TModel.LogoPath; } // ModelState. Model.UserId = "User1"; Model.ModifiedBy = "User1"; Model.ModifiedDate = DateTime.Now; Connection.SMGTModifyStudent(Model.SchoolId, Model.StudentId, Model.StudentName, Model.DateOfBirth, Model.GradeId, Model.ClassId, Model.Gender, Model.UserId, Model.HouseId, _path, Model.ModifiedBy, "Y"); //Connection.DCISModifySchool(Model.SchoolId, Model.SchoolGroup, Model.SchoolName, Model.SchoolRank, "Y", Model.Division, // Model.District, Model.Description, UserId, Model.Address1, Model.Address2, Model.Address3, Model.Email, Model.Fax, _path1, Convert.ToInt16(Model.MinuteforPeriod), Model.Telephone, Model.SchoolCategory, Model.Province, Model.WebAddress, _pathL2 // ); Connection.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult ShowEditStudent(string StudentId, string SchoolId) { StudentModel TModel = new StudentModel(); tblStudent TCtable = Connection.tblStudents.SingleOrDefault(x => x.StudentId == StudentId && x.SchoolId == SchoolId); tblSchool schl = Connection.tblSchools.SingleOrDefault(x => x.SchoolId == SchoolId); // TModel.IsActive = TCtable.IsActive; string SchoolName = schl.SchoolName; TModel.StudentId = TCtable.StudentId; TModel.StudentName = TCtable.studentName; TModel.SchoolName = SchoolName; TModel.DateOfBirth = TCtable.DateofBirth; TModel.ClassId = TCtable.ClassId; TModel.Gender = TCtable.Gender; TModel.UserId = TCtable.UserId; List <tblSchool> Scllist = Connection.tblSchools.Where(X => X.IsActive == "Y").ToList(); String sclid; if (SchoolId == null) { sclid = "%"; } else { sclid = SchoolId; } var SchoolHouse = Connection.SMGTgetSchoolHouseadd(sclid).ToList(); List <tblHouse> Shouselist = SchoolHouse.Select(x => new tblHouse { HouseId = x.HouseId, HouseName = x.HouseName, IsActive = x.IsActive }).ToList(); var SchoolGrade = Connection.SMGTgetSchoolGrade(sclid).ToList();//Need to Pass a Session Schoolid List <tblGrade> SchoolGradeList = SchoolGrade.Select(x => new tblGrade { GradeId = x.GradeId, GradeName = x.GradeName, IsActive = x.IsActive }).ToList(); List <tblClass> Sclasslist = Connection.tblClasses.Where(X => X.IsActive == "Y").ToList(); ViewBag.classDrpDown = new SelectList(Sclasslist, "ClassId", "ClassName"); ViewBag.SGradeDrpDown = new SelectList(SchoolGradeList, "GradeId", "GradeName"); ViewBag.HouseDrpDown = new SelectList(Shouselist, "HouseId", "HouseName"); ViewBag.SchoolDrpDown = new SelectList(Scllist, "SchoolId", "SchoolName"); List <tblSchoolCategory> SCategorylist = Connection.tblSchoolCategories.Where(X => X.IsActive == "Y").ToList(); ViewBag.SchoolCategoryDrpDown = new SelectList(SCategorylist, "SchoolCategoryId", "SchoolCategoryName"); // ViewBag.SchoolCategoryDrpDown = TCtable.SchoolCategory; List <tblProvince> provincelist = Connection.tblProvinces.Where(X => X.IsActive == "Y").ToList(); ViewBag.ProvinceDrpDown = new SelectList(provincelist, "ProvinceId", "ProvinceName"); List <tblSchoolGroup> schoolgrps = Connection.tblSchoolGroups.Where(X => X.IsActive == "Y").ToList(); ViewBag.SGroupDrpDown = new SelectList(schoolgrps, "GroupId", "GroupName"); List <tblDistrict> districtlist = Connection.tblDistricts.Where(X => X.IsActive == "Y").ToList(); ViewBag.DistrictDrpDown = new SelectList(districtlist, "DistrictId", "DistrictName"); List <tblDivision> divisionlist = Connection.tblDivisions.Where(X => X.IsActive == "Y").ToList(); ViewBag.DivisionDrpDown = new SelectList(divisionlist, "DivisionId", "DivisionName"); List <tblSchoolRank> Ranklist = Connection.tblSchoolRanks.Where(X => X.IsActive == "Y").ToList(); ViewBag.RankDrpDown = new SelectList(Ranklist, "SchoolRankId", "SchoolRankName"); List <tblSubject> sclSublist = Connection.tblSubjects.Where(X => X.IsActive == "Y").ToList(); ViewBag.SubjectscldrpList = new SelectList(sclSublist, "SubjectId", "SubjectName"); List <tblExtraCurricularActivity> excatlist = Connection.tblExtraCurricularActivities.Where(X => X.IsActive == "Y").ToList(); ViewBag.ActivitydrpList = new SelectList(excatlist, "ActivityCode", "ActivityName"); List <tblSubjectCategory> sclSubcatlist = Connection.tblSubjectCategories.Where(X => X.IsActive == "Y").ToList(); ViewBag.SubcatscldrpList = new SelectList(sclSubcatlist, "SubjectCategoryId", "SubjectCategoryName"); TModel.HouseId = TCtable.HouseId; TModel.GradeId = TCtable.GradeId; TModel.SchoolId = TCtable.SchoolId; TModel.SchoolIdw = TCtable.SchoolId; var SchoolClass = Connection.SMGTgetclassadd(SchoolId, TModel.GradeId).OrderBy(X => X.ClassName).ToList(); List <tblClass> SchoolGradeclasseList = SchoolClass.Select(x => new tblClass { ClassId = x.ClassId, ClassName = x.ClassName }).ToList(); ViewBag.SelectedschoolList = new SelectList(SchoolGradeclasseList, "ClassId", "ClassName"); return(PartialView("StudentEditView", TModel)); }