public ActionResult updateStudent(edu_course.Models.Student stu, int id) { try { int schoolid = Convert.ToInt32(Session["school"]); ClassDBHandle gc = new ClassDBHandle(); List <tbl_ClassValidation> list = gc.GetClass(schoolid); ViewBag.schoolclass = new SelectList(list, "Class_Id", "Name"); SectionDBHandle section = new SectionDBHandle(); List <tbl_SectionValidation> sectionlist = section.GetSection(schoolid); ViewBag.schoolsection = new SelectList(sectionlist, "SectionID", "SectionName"); var data = db.Students.Where(x => x.Id == id).First(); if (data != null) { data.Name = stu.Name; data.ContactNo = stu.ContactNo; data.Email = stu.Email; data.Address = stu.Address; data.Class_Id = data.Class_Id; data.Section_Id = data.Section_Id; db.Entry(data).State = EntityState.Modified; db.SaveChanges(); ViewBag.Message = "Data Successfully Updated"; ModelState.Clear(); } } catch (Exception ex) { ViewBag.Message = "Not Submitted"; return(View()); } return(RedirectToAction("viewstudent", "Home")); }
public ActionResult addstudent(edu_course.Models.tbl_StudentValidation s) { try { int schoolid = Convert.ToInt32(Session["school"]); ClassDBHandle gc = new ClassDBHandle(); List <tbl_ClassValidation> list = gc.GetClass(schoolid); ViewBag.schoolclass = new SelectList(list, "Class_Id", "Name"); SectionDBHandle section = new SectionDBHandle(); List <tbl_SectionValidation> sectionlist = section.GetSection(schoolid); ViewBag.schoolsection = new SelectList(sectionlist, "SectionID", "SectionName"); edu_course.Models.Student a = new edu_course.Models.Student(); var userWithSameEmail = db.Students.Where(m => m.Email == s.Email).SingleOrDefault(); //checking if the emailid already exits for any user if (userWithSameEmail == null) { s.RegNo = StudentRegNo(s, s.Name); string filename = Path.GetFileNameWithoutExtension(s.UserImageFIle.FileName); string extension = Path.GetExtension(s.UserImageFIle.FileName); filename = DateTime.Now.ToString("yymmssff") + extension; a.ImagePath = "~/Content/img/users/" + filename; //image ko folder me save krwanay ke leye filename = Path.Combine(Server.MapPath("~/Content/img/users/"), filename); s.UserImageFIle.SaveAs(filename); a.Class_Id = s.Class_Id; a.Section_Id = s.Section_Id; a.School_Id = Convert.ToInt32(Session["school"]); a.Name = s.Name; a.RegNo = s.RegNo; a.Address = s.Address; a.Email = s.Email; a.ContactNo = s.ContactNo; a.Password = s.Password; a.RegisterationDate = DateTime.Now; db.Students.Add(a); db.SaveChanges(); } else { ViewBag.Message = "User with this Email Already Exist"; return(View()); } int studentlatestid = a.Id; loginTable l = new loginTable(); l.UserId = studentlatestid; l.Name = a.Name; l.Password = a.Password; l.RoleID = 4; l.Email = a.Email; db.loginTables.Add(l); db.SaveChanges(); ModelState.Clear(); ViewBag.Message = "Data Submitted"; } catch (Exception ex) { ViewBag.Message = "Not Submitted"; return(View()); } return(View()); }