public async Task <ActionResult> Create(Finerecords finerecords)
{
if (finerecords != null)
{
finerecords.TotalAmount = finerecords.FineAmount;
int classid = (from alias in db.students where alias.Id == finerecords.StudentId select alias.ClassId).FirstOrDefault();
finerecords.SemesterClass = (from alias in db.classes where alias.Id == classid select alias.ClassName).FirstOrDefault();
finerecords.Name = (from alias in db.students where alias.Id == finerecords.StudentId select alias.StudentName).FirstOrDefault();
Finerecords fineslip = new Finerecords();
transactionrecords transaction = new transactionrecords();
fineslip.Id = finerecords.Id;
fineslip.TotalAmount = finerecords.TotalAmount;
fineslip.Payingstatus = finerecords.Payingstatus;
fineslip.FineAmount = finerecords.FineAmount;
fineslip.SubmissionDate = finerecords.SubmissionDate;
fineslip.Remarks = finerecords.Remarks;
//here normal record ends and students retrieving record start
fineslip.SemesterClass = finerecords.SemesterClass;
fineslip.Name = finerecords.Name;
fineslip.StudentId = finerecords.StudentId;
//here insterting transaction record
transaction.PersonId = fineslip.StudentId;
transaction.TransactionAmount = fineslip.TotalAmount;
transaction.TransactionDate = fineslip.SubmissionDate;
transaction.TransactionYear = DateTime.Now.Year;
transaction.TransactionType = "Fine";
db.Finerecords.Add(fineslip);
await db.SaveChangesAsync();
db.Entry(fineslip).GetDatabaseValues();
int getid = fineslip.Id;
TempData["Fineid"] = getid;
//here saving the created record of each specific tranaction
db.transactionecords.Add(transaction);
await db.SaveChangesAsync();
return(RedirectToAction("PrintfineSlip"));
}
ViewBag.StudentId = new SelectList(db.students, "Id", "StudentName", finerecords.StudentId);
return(View(finerecords));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Finerecords finerecords = await db.Finerecords.FindAsync(id);
db.Finerecords.Remove(finerecords);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Name,SemesterClass,SubmissionDate,FineAmount,TotalAmount,Payingstatus,Remarks,StudentId")] Finerecords finerecords)
{
if (ModelState.IsValid)
{
db.Entry(finerecords).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.StudentId = new SelectList(db.students, "Id", "StudentName", finerecords.StudentId);
return(View(finerecords));
}
// GET: Finerecords/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Finerecords finerecords = await db.Finerecords.FindAsync(id);
if (finerecords == null)
{
return(HttpNotFound());
}
return(View(finerecords));
}
// GET: Finerecords/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Finerecords finerecords = await db.Finerecords.FindAsync(id);
if (finerecords == null)
{
return(HttpNotFound());
}
ViewBag.StudentId = new SelectList(db.students, "Id", "StudentName", finerecords.StudentId);
return(View(finerecords));
}
// GET: Finerecords/Create
public ActionResult Create()
{
ViewBag.StudentId = db.students.Select(c => new SelectListItem {
Value = c.Id.ToString(), Text = c.Id.ToString()
})
.ToList();
var view = new Finerecords
{
SubmissionDate = DateTime.Now.Date,
Remarks = "Write Fine Reason/Category",
Payingstatus = "Full Fine Paid"
};
return(View(view));
}
//here below is the fine slip
public ActionResult PrintfineSlip()
{
int id = Convert.ToInt32(TempData["Fineid"]);
if (id == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Finerecords fineslip = db.Finerecords.Find(Convert.ToInt32(id));
if (fineslip == null)
{
return(HttpNotFound());
}
return(View(fineslip));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,BookTitle,BookId,AssignedBy,AssignedDate,ReturnDate,StudedRegId,StudentName,StudentDepartment,StudentClass,Comments,fineComment,ReceivedStatus,Receiveddate,fineslipid,finestatus")] LibarayIssuedBooks libarayIssuedBooks)
{
if (ModelState.IsValid)
{
// public string fineComment { get; set; }
//public string ReceivedStatus { get; set; }
//public DateTime Receiveddate { get; set; }
//public string fineslipid { get; set; }
//public string finestatus { get; set; }
libarayIssuedBooks.Receiveddate = DateTime.Now;
if (libarayIssuedBooks.ReturnDate > libarayIssuedBooks.ReturnDate)
{
if (libarayIssuedBooks.fineslipid == "")
{
ViewBag.finemsg = "Provide the Fine Challan ID to Proceed.";
return(View(libarayIssuedBooks));
}
int convert = Convert.ToInt32(libarayIssuedBooks.fineslipid);
Finerecords checkrecord = await db.Finerecords.FindAsync(convert);
if (checkrecord == null)
{
ViewBag.finemsg = "Provided Fine Challan ID Not Matched.";
}
libarayIssuedBooks.finestatus = "Fined";
}
else
{
libarayIssuedBooks.finestatus = "Not Fined";
}
libarayIssuedBooks.ReceivedStatus = "Received";
db.Entry(libarayIssuedBooks).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(libarayIssuedBooks));
}