// GET: AdmitCardApproval
public JsonResult GiveApproval(long stdId)
{
var user = User.Identity.Name;
var li = db.AdmitCardApprovals.Where(c => c.StudentInfoId == stdId);
foreach (var ap in li)
{
ap.IsPrevious = true;
}
db.SaveChanges();
var a = new AdmitCardApproval()
{
StudentInfoId = stdId,
IsPaymentComplete = true,
IsPrevious = true,
ApproveBy = user,
ApproveDate = DateTime.Now
};
db.AdmitCardApprovals.Add(a);
var r = db.SaveChanges();
return(Json(r, JsonRequestBehavior.AllowGet));
}
public ActionResult PaymentAutoApprove(PaymentUploadVm vm)
{
var user = User.Identity.Name;
ViewBag.ExamId = new SelectList(db.Exams, "Id", "Name");
ViewBag.ProgramId = new SelectList(db.Programs, "Id", "ShortName");
var semester = db.Semesters.SingleOrDefault(c => c.IsActive);
if (semester == null)
{
return(View());
}
ViewBag.SemesterId = semester.Id;
ViewBag.Semester = semester.Name + " " + semester.Year;
var entity = db.Payments.Where(c => !c.IsDelete && c.ProgramId == vm.ProgramId && c.SemesterId == vm.SemesterId && c.ExamId == vm.ExamId && c.DuesPercentAmount <= 1000).ToList();
foreach (var p in entity)
{
var student = db.StudentInfos.FirstOrDefault(c => c.IdNo == p.StudentId && !c.IsDelete);
if (student != null)
{
if (db.AdmitCardApprovals.Any(c => c.PaymentId == p.Id && c.IsPaymentComplete))
{
continue;
}
var li = db.AdmitCardApprovals.Where(c => c.StudentInfoId == student.Id);
foreach (var ap in li)
{
ap.IsPrevious = true;
}
db.SaveChanges();
var a = new AdmitCardApproval()
{
PaymentId = p.Id,
StudentInfoId = student.Id,
IsPaymentComplete = true,
ApproveBy = user,
ApproveDate = DateTime.Now
};
db.AdmitCardApprovals.Add(a);
var r = db.SaveChanges();
}
}
return(Json(1, JsonRequestBehavior.AllowGet));
}
public JsonResult DueApproval(long stdId, long?requestId, string date, long paymentId)
{
var li = db.AdmitCardApprovals.Where(c => c.StudentInfoId == stdId);
foreach (var ap in li)
{
ap.IsPrevious = true;
}
db.SaveChanges();
var stds = db.AdmitCardRequests.Where(c => c.StudentInfoId == stdId);
foreach (var std in stds)
{
std.IsDone = true;
std.Status = true;
}
db.SaveChanges();
var user = User.Identity.Name;
var a = new AdmitCardApproval()
{
PaymentId = paymentId,
StudentInfoId = stdId,
ExceptedDate = DateTimeFormatter.StringToDate(date),
IsSpecialPermission = true,
Comments = "",
IsPrevious = false,
ApproveBy = user,
ApproveDate = DateTime.Now
};
db.AdmitCardApprovals.Add(a);
var r = db.SaveChanges();
return(Json(r, JsonRequestBehavior.AllowGet));
}
