public ActionResult DeleteConfirmed(int id) { StudentFeeRecords studentFeeRecords = db.StudentFeeRecords.Find(id); db.StudentFeeRecords.Remove(studentFeeRecords); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Name,FatherName,SemesterClass,SubmissionDate,AdmissionFeeTutionFee,HostelFee,SecFee,PaymentMethod,GrossTotalAmount,Payingstatus,Year,batch,Remarks,StudentId")] StudentFeeRecords studentFeeRecords) { if (ModelState.IsValid) { db.Entry(studentFeeRecords).State = EntityState.Modified; db.SaveChanges();//here its is bug on the year format attribute will solve soon (pending). return(RedirectToAction("Index")); } ViewBag.StudentId = new SelectList(db.students, "Id", "StudentName", studentFeeRecords.StudentId); return(View(studentFeeRecords)); }
// GET: StudentFeeRecords/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentFeeRecords studentFeeRecords = db.StudentFeeRecords.Find(id); if (studentFeeRecords == null) { return(HttpNotFound()); } return(View(studentFeeRecords)); }
// GET: StudentFeeRecords/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentFeeRecords studentFeeRecords = db.StudentFeeRecords.Find(id); if (studentFeeRecords == null) { return(HttpNotFound()); } ViewBag.StudentId = new SelectList(db.students, "Id", "StudentName", studentFeeRecords.StudentId); return(View(studentFeeRecords)); }
public ActionResult PrintSlip() { int id = Convert.ToInt32(TempData["Feeid"]); if (id == 0) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentFeeRecords studentFeeRecords = db.StudentFeeRecords.Find(Convert.ToInt32(id)); if (studentFeeRecords == null) { return(HttpNotFound()); } return(View(studentFeeRecords)); }
// GET: StudentFeeRecords/Create public ActionResult Create() { ViewBag.StudentId = db.students.Select(c => new SelectListItem { Value = c.Id.ToString(), Text = c.Id.ToString() }) .ToList(); var view = new StudentFeeRecords { batch = System.DateTime.Now.Year, SubmissionDate = DateTime.Now.Date, Remarks = "Paid On Time", PaymentMethod = "Cash" }; return(View(view)); }
public ActionResult Create(StudentFeeRecords studentFeeRecords) { if (ModelState.IsValid) { studentFeeRecords.GrossTotalAmount = studentFeeRecords.AdmissionFeeTutionFee + studentFeeRecords.SecFee + studentFeeRecords.HostelFee; studentFeeRecords.Payingstatus = "Paid"; int classid = (from alias in db.students where alias.Id == studentFeeRecords.StudentId select alias.ClassId).FirstOrDefault(); studentFeeRecords.SemesterClass = (from alias in db.classes where alias.Id == classid select alias.ClassName).FirstOrDefault(); studentFeeRecords.batch = DateTime.Now.Year; studentFeeRecords.Name = (from alias in db.students where alias.Id == studentFeeRecords.StudentId select alias.StudentName).FirstOrDefault(); studentFeeRecords.FatherName = (from alias in db.students where alias.Id == studentFeeRecords.StudentId select alias.GuardianName).FirstOrDefault(); studentFeeRecords.Year = DateTime.Now; StudentFeeRecords finalslip = new StudentFeeRecords(); transactionrecords transaction = new transactionrecords(); finalslip.Id = studentFeeRecords.Id; finalslip.FatherName = studentFeeRecords.FatherName; finalslip.GrossTotalAmount = studentFeeRecords.GrossTotalAmount; finalslip.Payingstatus = studentFeeRecords.Payingstatus; finalslip.PaymentMethod = studentFeeRecords.PaymentMethod; finalslip.HostelFee = studentFeeRecords.HostelFee; finalslip.SecFee = studentFeeRecords.SecFee; finalslip.AdmissionFeeTutionFee = studentFeeRecords.AdmissionFeeTutionFee; finalslip.SubmissionDate = studentFeeRecords.SubmissionDate; finalslip.Remarks = studentFeeRecords.Remarks; finalslip.Year = studentFeeRecords.Year; finalslip.batch = studentFeeRecords.batch; //here normal record ends and students retrieving record start finalslip.SemesterClass = studentFeeRecords.SemesterClass; finalslip.Name = studentFeeRecords.Name; finalslip.FatherName = studentFeeRecords.FatherName; finalslip.StudentId = studentFeeRecords.StudentId; //here insterting transaction record transaction.PersonId = finalslip.StudentId; transaction.TransactionAmount = finalslip.GrossTotalAmount; transaction.TransactionDate = finalslip.SubmissionDate; transaction.TransactionYear = finalslip.batch; transaction.TransactionType = "Fees"; finalslip.AddedOn = DateTime.UtcNow.AddHours(5); db.StudentFeeRecords.Add(finalslip); db.SaveChanges(); db.Entry(finalslip).GetDatabaseValues(); int getid = finalslip.Id; TempData["Feeid"] = getid; //here saving the created record of each specific tranaction db.transactionecords.Add(transaction); db.SaveChanges(); return(RedirectToAction("PrintSlip")); } ViewBag.StudentId = new SelectList(db.students, "Id", "StudentName", studentFeeRecords.StudentId); return(View(studentFeeRecords)); }