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