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));
}
