public ActionResult Check([Bind(Include = "InvoiceId,Amount,DateTime,FeePeriod,StudentId")] TuitionFee tuitionFee)
{
List <Student> students = db.Students.ToList();
IEnumerable <TuitionFee> tuitionFees;
List <int> paidStudentIds = new List <int>();
List <Student> studentList = db.Students.ToList();
if (ModelState.IsValid)
{
tuitionFees = from r in db.TuitionFees.AsQueryable()
where r.FeePeriod.Month >= tuitionFee.FeePeriod.Month && r.FeePeriod.Year == tuitionFee.FeePeriod.Year
select r;
foreach (TuitionFee t in tuitionFees)
{
paidStudentIds.Add(t.StudentId);
}
foreach (Student s in students)
{
foreach (int i in paidStudentIds)
{
if (s.Id == i)
{
studentList.Remove(s);
break;
}
}
}
return(View("GetStudents", studentList));
}
return(View(tuitionFee));
}
public async Task <IActionResult> Edit(string id, [Bind("Id,Amount")] TuitionFee tuitionFee)
{
if (id != tuitionFee.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tuitionFee);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TuitionFeeExists(tuitionFee.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tuitionFee));
}
public List <TuitionFee> GetAllLastPaymentData(string Id)
{
var _TuitionFeeList = new List <TuitionFee>();
string query = ("Select *from tuitionFees Where StudentId='" + Id + "' And Year(Date)='" + DateTime.Now.Year + "' ");
var reader = _MainRepository.Reader(query, _MainRepository.ConnectionString());
if (reader.HasRows)
{
while (reader.Read())
{
var _TuitionFee = new TuitionFee();
_TuitionFee.StudentId = (reader["StudentId"].ToString());
_TuitionFee.Fees = Convert.ToDecimal(reader["Fees"].ToString());
_TuitionFee.Due = Convert.ToDecimal(reader["Due"].ToString());
_TuitionFee.Date = (reader["Date"].ToString());
_TuitionFeeList.Add(_TuitionFee);
}
}
reader.Close();
return(_TuitionFeeList);
}
public ActionResult Create([Bind(Include = "InvoiceId,Amount,DateTime,FeePeriod,StudentId")] TuitionFee tuitionFee)
{
IEnumerable <TuitionFee> tuitionFees;
if (ModelState.IsValid)
{
tuitionFees = from r in db.TuitionFees.AsQueryable()
where r.StudentId == tuitionFee.StudentId
orderby r.FeePeriod descending
select r;
TuitionFee t = tuitionFees.FirstOrDefault();
tuitionFee.DateTime = DateTime.Now;
if ((tuitionFee.FeePeriod.Month - t.FeePeriod.Month) <= 1)
{
db.TuitionFees.Add(tuitionFee);
db.SaveChanges();
return(RedirectToAction("GetAll"));
}
else
{
return(RedirectToAction("ErrorDate"));
}
}
ViewBag.StudentId = new SelectList(db.Students, "Id", "Name", tuitionFee.StudentId);
return(View(tuitionFee));
}
public ActionResult DeleteConfirmed(int id)
{
TuitionFee tuitionFee = db.TuitionFees.Find(id);
db.TuitionFees.Remove(tuitionFee);
db.SaveChanges();
return(RedirectToAction("GetAll"));
}
public async Task <IActionResult> Create([Bind("Id,Amount")] TuitionFee tuitionFee)
{
if (ModelState.IsValid)
{
_context.Add(tuitionFee);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tuitionFee));
}
public ActionResult Edit([Bind(Include = "InvoiceId,Amount,DateTime,FeePeriod,StudentId")] TuitionFee tuitionFee)
{
if (ModelState.IsValid)
{
db.Entry(tuitionFee).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("GetAll"));
}
ViewBag.StudentId = new SelectList(db.Students, "Id", "Name", tuitionFee.StudentId);
return(View(tuitionFee));
}
// GET: TuitionFees/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TuitionFee tuitionFee = db.TuitionFees.Find(id);
if (tuitionFee == null)
{
return(HttpNotFound());
}
return(View(tuitionFee));
}
// GET: TuitionFees/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TuitionFee tuitionFee = db.TuitionFees.Find(id);
if (tuitionFee == null)
{
return(HttpNotFound());
}
ViewBag.StudentId = new SelectList(db.Students, "Id", "Name", tuitionFee.StudentId);
return(View(tuitionFee));
}
public ActionResult SearchByMonth([Bind(Include = "InvoiceId,DateTime,Amount,FeePeriod,StudentId")] TuitionFee tuitionFee)
{
IEnumerable <TuitionFee> tuitionFees;
if (ModelState.IsValid)
{
tuitionFees = from r in db.TuitionFees.AsQueryable()
where r.DateTime.Month == tuitionFee.DateTime.Month
select r;
return(View("GetAll", tuitionFees));
}
return(View(tuitionFee));
}
protected void PaidFeesButton_Click(object sender, EventArgs e)
{
try
{
TuitionFee _TuitionFee = new TuitionFee();
_TuitionFee.StudentId = txtStudentId.Text;
_TuitionFee.Fees = Convert.ToDecimal(txtPaid.Text);
_TuitionFee.Due = Convert.ToDecimal(txtAfterRremaining.Text);
_TuitionFee.Date = Convert.ToDateTime(txtDate.Text).ToShortDateString();
int paidsuccess = _TuitionFeesRepository.PaidFees(_TuitionFee);
if (paidsuccess > 0)
{
Response.Redirect(Request.Url.AbsoluteUri);
}
}
catch { }
}
public TuitionFee GetLastPaymentData(string Id)
{
TuitionFee _TuitionFee = null;
string query = "Select top 1 *from tuitionFees Where StudentId='" + Id + "' And Year(Date)='" + DateTime.Now.Year + "' order by Date desc";
var reader = _MainRepository.Reader(query, _MainRepository.ConnectionString());
if (reader.HasRows)
{
reader.Read();
_TuitionFee = new TuitionFee();
_TuitionFee.LastPaid = Convert.ToDecimal(reader["Fees"].ToString());
_TuitionFee.RemainingDue = Convert.ToDecimal(reader["Due"].ToString());
_TuitionFee.Date = (reader["Date"].ToString());
}
reader.Close();
return(_TuitionFee);
}
public int PaidFees(TuitionFee _TuitionFee)
{
string query = "Insert Into TuitionFees(StudentId,Fees,Due,Date) Values ('" + _TuitionFee.StudentId + "','" + _TuitionFee.Fees + "','" + _TuitionFee.Due + "','" + _TuitionFee.Date + "')";
return(_MainRepository.ExecuteNonQuery(query, _MainRepository.ConnectionString()));
}
