public ActionResult Create(tblDefineFeesStudentMst tbldefinefeesstudentmst, FormCollection form) { if (ModelState.IsValid) { var selectedStudentIds = form["selectedStudentList"].Split(','); tbldefinefeesstudentmst.TotalStudents = int.Parse(form["totalStudentNumber"]); tbldefinefeesstudentmst.FeesTypeID = int.Parse(form["feeType"]); tbldefinefeesstudentmst.IsDelete = false; tbldefinefeesstudentmst.PostDate = DateTime.Now; var obj = db.tblDefineFeesStudentMst.Add(tbldefinefeesstudentmst); db.SaveChanges(); foreach (var studentId in selectedStudentIds) { var admissionId = int.Parse(studentId); db.tblDefineFeesStudentDtl.Add(new tblDefineFeesStudentDtl { DefineFeesStudentID = obj.DefineFeesStudentID, AdmissionID = admissionId }); } db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.tblClassMst, "ClassID", "ClassName", tbldefinefeesstudentmst.ClassID); ViewBag.SectionID = new SelectList(db.tblSection, "SectionID", "SectionName", tbldefinefeesstudentmst.SectionID); ViewBag.StageID = new SelectList(db.tblStage, "StageID", "StageName", tbldefinefeesstudentmst.StageID); return(View(tbldefinefeesstudentmst)); }
public ActionResult Edit(tblDefineFeesStudentMst tbldefinefeesstudentmst, FormCollection form) { if (ModelState.IsValid) { var defineFeesStudentId = int.Parse(form["defineFeeStudentId"]); var obj = db.tblDefineFeesStudentMst.FirstOrDefault(x => x.DefineFeesStudentID == defineFeesStudentId); var selectedStudentIds = form["selectedStudentList"].Split(','); obj.FeesTypeID = int.Parse(form["feeType"]); obj.SectionID = tbldefinefeesstudentmst.SectionID; obj.StageID = tbldefinefeesstudentmst.StageID; obj.ClassID = tbldefinefeesstudentmst.ClassID; obj.UpdateDate = DateTime.Now; db.SaveChanges(); db.tblDefineFeesStudentDtl.RemoveRange(db.tblDefineFeesStudentDtl.Where(x => x.DefineFeesStudentID == defineFeesStudentId)); db.SaveChanges(); foreach (var studentId in selectedStudentIds) { var admissionId = int.Parse(studentId); db.tblDefineFeesStudentDtl.Add(new tblDefineFeesStudentDtl { DefineFeesStudentID = defineFeesStudentId, AdmissionID = admissionId }); } db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ClassID = new SelectList(db.tblClassMst, "ClassID", "ClassName", tbldefinefeesstudentmst.ClassID); ViewBag.SectionID = new SelectList(db.tblSection, "SectionID", "SectionName", tbldefinefeesstudentmst.SectionID); ViewBag.StageID = new SelectList(db.tblStage, "StageID", "StageName", tbldefinefeesstudentmst.StageID); return(View(tbldefinefeesstudentmst)); }
// GET: /definefeestudant/Delete/5 public ActionResult Delete(long?id) { tblDefineFeesStudentMst tbldefinefeesstudentmst = db.tblDefineFeesStudentMst.Find(id); tbldefinefeesstudentmst.IsDelete = true; db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: /definefeestudant/Details/5 public ActionResult Details(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblDefineFeesStudentMst tbldefinefeesstudentmst = db.tblDefineFeesStudentMst.Find(id); if (tbldefinefeesstudentmst == null) { return(HttpNotFound()); } return(View(tbldefinefeesstudentmst)); }
public ActionResult Edit(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tblDefineFeesStudentMst tbldefinefeesstudentmst = db.tblDefineFeesStudentMst.Find(id); if (tbldefinefeesstudentmst == null) { return(HttpNotFound()); } ViewBag.ClassList = db.tblClassMst.ToList(); ViewBag.StageList = db.tblStage.ToList(); var feeTypes = db.tblFeesType.ToList(); ViewBag.feeTypes = feeTypes; var sectionList = new List <tblSection>(); var result = (from _tblClassDtls in db.tblClassDtl join jsec in db.tblSection on _tblClassDtls.SectionID equals jsec.SectionID where _tblClassDtls.ClassID == tbldefinefeesstudentmst.ClassID && jsec.IsActive == true && jsec.IsDelete != true && jsec.SchoolID == portalutilities._schollid select new { id = jsec.SectionID, name = jsec.SectionName }).ToList(); foreach (var sec in result) { sectionList.Add(new tblSection { SectionID = sec.id, SectionName = sec.name }); } ViewBag.SectionList = sectionList; return(View(tbldefinefeesstudentmst)); }