// GET: StudentKrsV2/Create
public ActionResult Create(long Student_Id, short Term_Year_Id, short Class_Prog_Id, int?Course_Id, short?Class_Id, string UrlReferrer)
{
var Student = db.Acd_Student.Where(k => k.Student_Id == Student_Id).Single();
ViewBag.Course_Id = new SelectList(db.usp_GetOfferredCourseForKRSByStudent(Term_Year_Id, Student.Department_Id, Class_Prog_Id, Student.Entry_Year_Id, Student_Id), "Course_Id", "Course_Name", Course_Id);
ViewBag.Class_Id = new SelectList(new[] { new { ID = "0", Name = "" } }, "ID", "Name");
//ViewBag.Term_Year_Id = Term_Year_Id;
//ViewBag.Student_Id = Student_Id;
//ViewBag.Class_Prog_Id = Class_Prog_Id;
ViewBag.UrlReferrer = UrlReferrer ?? System.Web.HttpContext.Current.Request.UrlReferrer.ToString();
Acd_Student_Krs acd_Student_Krs = new Acd_Student_Krs();
acd_Student_Krs.Term_Year_Id = Term_Year_Id;
acd_Student_Krs.Student_Id = Student_Id;
acd_Student_Krs.Class_Prog_Id = Class_Prog_Id;
if (Course_Id != null)
{
var CourseCostForKRS = db.usp_GetCourseCostForKRS(Term_Year_Id, Student.Department_Id, Class_Prog_Id, Student.Entry_Year_Id, Course_Id).Single();
acd_Student_Krs.Sks = Convert.ToDecimal(CourseCostForKRS.applied_sks);
acd_Student_Krs.Amount = Convert.ToInt32(CourseCostForKRS.amount);
ViewBag.Class_Id = new SelectList(db.Acd_Offered_Course.Where(z => z.Course_Id == Course_Id && z.Term_Year_Id == Term_Year_Id), "Class_Id", "Mstr_Class.Class_Name");
}
if (Class_Id != null)
{
var ClassInfo = db.usp_GetClassInfoForKRS(Term_Year_Id, Student.Department_Id, Class_Prog_Id, Course_Id, Class_Id).Single();
ViewBag.Dosen = "";
ViewBag.Kapasitas = ClassInfo.Capacity;
ViewBag.Terdaftar = ClassInfo.Used;
ViewBag.SisaKuota = ClassInfo.Free;
}
return(View(acd_Student_Krs));
}
// GET: StudentKrsV2/Edit/5
public ActionResult Edit(long?id, short?Class_Id, string UrlReferrer)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
if (acd_Student_Krs == null)
{
return(HttpNotFound());
}
var Student = db.Acd_Student.Where(k => k.Student_Id == acd_Student_Krs.Student_Id).Single();
ViewBag.CourseName = db.Acd_Course.Where(c => c.Course_Id == acd_Student_Krs.Course_Id).Select(c => c.Course_Name).First();
ViewBag.Class_Id = new SelectList(db.Acd_Offered_Course.Where(z => z.Course_Id == acd_Student_Krs.Course_Id && z.Term_Year_Id == acd_Student_Krs.Term_Year_Id), "Class_Id", "Mstr_Class.Class_Name", acd_Student_Krs.Class_Id);
ViewBag.UrlReferrer = UrlReferrer ?? System.Web.HttpContext.Current.Request.UrlReferrer.ToString();
var ClassInfo = db.usp_GetClassInfoForKRS(acd_Student_Krs.Term_Year_Id, Student.Department_Id, acd_Student_Krs.Class_Prog_Id, acd_Student_Krs.Course_Id, Class_Id ?? acd_Student_Krs.Class_Id).Single();
if (ClassInfo.Free <= 0)
{
ViewBag.Notif = "Kelas Sudah Penuh.";
}
ViewBag.Dosen = "";
ViewBag.Kapasitas = ClassInfo.Capacity;
ViewBag.Terdaftar = ClassInfo.Used;
ViewBag.SisaKuota = ClassInfo.Free;
return(View(acd_Student_Krs));
}
public ActionResult Edit([Bind(Include = "Krs_Id,Student_Id,Term_Year_Id,Course_Id,Class_Prog_Id,Class_Id,Sks,Amount,Nb_Taking,Krs_Date,Due_Date,Cost_Item_Id,Is_Approved,Is_Locked,Modified_By,Modified_Date,Created_Date,Order_Id,Created_By")] Acd_Student_Krs acd_Student_Krs, string UrlReferrer)
{
if (ModelState.IsValid)
{
var Student = db.Acd_Student.Find(acd_Student_Krs.Student_Id);
var ClassInfo = db.usp_GetClassInfoForKRS(acd_Student_Krs.Term_Year_Id, Student.Department_Id, acd_Student_Krs.Class_Prog_Id, acd_Student_Krs.Course_Id, acd_Student_Krs.Class_Id).Single();
if (ClassInfo.Free <= 0)
{
ViewBag.NotifMessage = "Kelas Sudah Penuh.";
ViewBag.CourseName = db.Acd_Course.Where(c => c.Course_Id == acd_Student_Krs.Course_Id).Select(c => c.Course_Name).First();
ViewBag.Class_Id = new SelectList(db.Acd_Offered_Course.Where(z => z.Course_Id == acd_Student_Krs.Course_Id && z.Term_Year_Id == acd_Student_Krs.Term_Year_Id), "Class_Id", "Mstr_Class.Class_Name", acd_Student_Krs.Class_Id);
ViewBag.Dosen = "";
ViewBag.Kapasitas = ClassInfo.Capacity;
ViewBag.Terdaftar = ClassInfo.Used;
ViewBag.SisaKuota = ClassInfo.Free;
ViewBag.UrlReferrer = UrlReferrer;
return(View(acd_Student_Krs));
}
acd_Student_Krs.Modified_Date = DateTime.Now;
db.Entry(acd_Student_Krs).State = EntityState.Modified;
db.SaveChanges();
return(Redirect(UrlReferrer));
}
return(View(acd_Student_Krs));
}
// GET: Student_Khsv2/Edit/5
public ActionResult Edit(long?Krs_Id)
{
if (Krs_Id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(Krs_Id);
if (acd_Student_Krs == null)
{
return(HttpNotFound());
}
short?department_Id = acd_Student_Krs.Acd_Student.Department_Id;
var listGradeLetter = db.Acd_Grade_Department.Where(x => x.Department_Id == department_Id)
.Select(x => new
{
Grade_Letter_Id = x.Acd_Grade_Letter.Grade_Letter_Id,
Grade_Letter = x.Acd_Grade_Letter.Grade_Letter
}).ToList();
short?grade_Letter_Id = null;
if (acd_Student_Krs.Acd_Student_Khs.FirstOrDefault() != null)
{
grade_Letter_Id = acd_Student_Krs.Acd_Student_Khs.FirstOrDefault().Grade_Letter_Id;
}
ViewBag.Grade_Letter_Id = new SelectList(listGradeLetter, "Grade_Letter_Id", "Grade_Letter", grade_Letter_Id);
return(View(acd_Student_Krs));
}
public ActionResult Create([Bind(Include = "Krs_Id,Student_Id,Term_Year_Id,Course_Id,Class_Prog_Id,Class_Id,Sks,Amount,Nb_Taking,Krs_Date,Due_Date,Cost_Item_Id,Is_Approved,Is_Locked,Modified_By,Modified_Date,Created_Date,Order_Id,Created_By")] Acd_Student_Krs acd_Student_Krs, string UrlReferrer)
{
if (ModelState.IsValid)
{
var Student = db.Acd_Student.Find(acd_Student_Krs.Student_Id);
var ClassInfo = db.usp_GetClassInfoForKRS(acd_Student_Krs.Term_Year_Id, Student.Department_Id, acd_Student_Krs.Class_Prog_Id, acd_Student_Krs.Course_Id, acd_Student_Krs.Class_Id).Single();
var Saldo = db.usp_Saldo(acd_Student_Krs.Student_Id, acd_Student_Krs.Term_Year_Id).Single();
decimal UsedSKS = db.Acd_Student_Krs.Where(k => k.Student_Id == acd_Student_Krs.Student_Id && k.Term_Year_Id == acd_Student_Krs.Term_Year_Id).Select(p => p.Sks).DefaultIfEmpty().Sum();
decimal AllowedSKS = db.usp_GetAllowedSKSForKRS(acd_Student_Krs.Term_Year_Id, acd_Student_Krs.Student_Id).Single().Value;
var CourseCostForKRS = db.usp_GetCourseCostForKRS(acd_Student_Krs.Term_Year_Id, Student.Department_Id, acd_Student_Krs.Class_Prog_Id, Student.Entry_Year_Id, acd_Student_Krs.Course_Id).Single();
if (ClassInfo.Free <= 0 || (AllowedSKS - UsedSKS) < CourseCostForKRS.applied_sks || Saldo.SisaSaldoSaatIni < CourseCostForKRS.amount)
{
if (ClassInfo.Free <= 0)
{
ViewBag.NotifMessage = "Kelas Sudah Penuh.";
}
if ((AllowedSKS - UsedSKS) < CourseCostForKRS.applied_sks)
{
ViewBag.NotifMessage = "Sisa SKS tidak mencukupi.";
}
if (Saldo.SisaSaldoSaatIni < CourseCostForKRS.amount)
{
ViewBag.NotifMessage = "Sisa Saldo tidak mencukupi.";
}
ViewBag.Term_Year_Id = acd_Student_Krs.Term_Year_Id;
ViewBag.Student_Id = acd_Student_Krs.Student_Id;
ViewBag.Class_Prog_Id = acd_Student_Krs.Class_Prog_Id;
ViewBag.Course_Id = new SelectList(db.usp_GetOfferredCourseForKRSByStudent(acd_Student_Krs.Term_Year_Id, Student.Department_Id, acd_Student_Krs.Class_Prog_Id, Student.Entry_Year_Id, Student.Student_Id), "course_id", "course_name", acd_Student_Krs.Course_Id);
ViewBag.Class_Id = new SelectList(db.Acd_Offered_Course.Where(z => z.Course_Id == acd_Student_Krs.Course_Id && z.Term_Year_Id == acd_Student_Krs.Term_Year_Id), "Class_Id", "Mstr_Class.Class_Name", acd_Student_Krs.Class_Id);
ViewBag.Dosen = "";
ViewBag.Kapasitas = ClassInfo.Capacity;
ViewBag.Terdaftar = ClassInfo.Used;
ViewBag.SisaKuota = ClassInfo.Free;
ViewBag.UrlReferrer = UrlReferrer;
return(View(acd_Student_Krs));
}
acd_Student_Krs.Created_Date = DateTime.Now;
acd_Student_Krs.Krs_Date = DateTime.Now;
acd_Student_Krs.Modified_Date = DateTime.Now;
acd_Student_Krs.Cost_Item_Id = 3; //deposit KRS, nanti dikembangkan bisa 9(KKN)
db.Acd_Student_Krs.Add(acd_Student_Krs);
db.SaveChanges();
return(Redirect(UrlReferrer));
}
return(View(acd_Student_Krs));
}
// GET: StudentKrsV2/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
if (acd_Student_Krs == null)
{
return(HttpNotFound());
}
return(View(acd_Student_Krs));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
if (acd_Student_Krs == null)
{
return(HttpNotFound());
}
//for url
return(View(acd_Student_Krs));
}
// GET: StudentKrsV2/Delete/5
//public ActionResult Delete(long? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
// if (acd_Student_Krs == null)
// {
// return HttpNotFound();
// }
// return View(acd_Student_Krs);
//}
// POST: StudentKrsV2/Delete/5
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
public ActionResult Delete(long id)
{
string UrlReferrer = System.Web.HttpContext.Current.Request.UrlReferrer.ToString();
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
var khscount = db.Acd_Student_Khs.Where(p => p.Krs_Id == acd_Student_Krs.Krs_Id).Count();
if (khscount > 0)
{
TempData["gagalHapus"] = "Data KRS sudah terpakai di KHS.";
return(Redirect(UrlReferrer));
}
TempData["berhasilHapus"] = "Berhasil Hapus Data.";
db.Acd_Student_Krs.Remove(acd_Student_Krs);
db.SaveChanges();
return(Redirect(UrlReferrer));
}
public ActionResult Edit([Bind(Include = "Krs_Id,Student_Id,Term_Year_Id,Course_Id,Class_Prog_Id,Class_Id,Sks,Amount,Nb_Taking,Krs_Date,Due_Date,Cost_Item_Id,Is_Approved,Is_Locked,Modified_By,Modified_Date,Created_Date,Order_Id,Created_By")] Acd_Student_Krs acd_Student_Krs)
{
if (ModelState.IsValid)
{
db.Entry(acd_Student_Krs).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Course_Id = new SelectList(db.Acd_Course, "Course_Id", "Course_Code", acd_Student_Krs.Course_Id);
ViewBag.Student_Id = new SelectList(db.Acd_Student, "Student_Id", "Nim", acd_Student_Krs.Student_Id);
ViewBag.Cost_Item_Id = new SelectList(db.Fnc_Cost_Item, "Cost_Item_Id", "Cost_Item_Code", acd_Student_Krs.Cost_Item_Id);
ViewBag.Class_Id = new SelectList(db.Mstr_Class, "Class_Id", "Class_Name", acd_Student_Krs.Class_Id);
ViewBag.Class_Prog_Id = new SelectList(db.Mstr_Class_Program, "Class_Prog_Id", "Class_Prog_Code", acd_Student_Krs.Class_Prog_Id);
ViewBag.Term_Year_Id = new SelectList(db.Mstr_Term_Year.OrderByDescending(ty => ty.Term_Year_Id), "Term_Year_Id", "Term_Year_Name", acd_Student_Krs.Term_Year_Id);
return(View(acd_Student_Krs));
}
public ActionResult DeleteConfirmed(long id, int Offered_Course_id)
{
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
short? Department_Id = acd_Student_Krs.Acd_Student.Department_Id;
db.Acd_Student_Krs.Remove(acd_Student_Krs);
db.SaveChanges();
//return RedirectToAction("Index");
return(RedirectToAction("List", new
{
Term_Year_Id = acd_Student_Krs.Term_Year_Id,
Class_Prog_Id = acd_Student_Krs.Class_Prog_Id,
Course_Id = acd_Student_Krs.Course_Id,
Class_Id = acd_Student_Krs.Class_Id,
Department_Id = Department_Id,
Offered_Course_id = Offered_Course_id
}));
}
// GET: StudentKrsV1/Delete/5
public ActionResult Delete(long?id, int Offered_Course_id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
if (acd_Student_Krs == null)
{
return(HttpNotFound());
}
//for url
ViewBag.Offered_Course = Offered_Course_id;
return(View(acd_Student_Krs));
}
public ActionResult Insert(short Term_Year_Id, Int64 Student_Id)
{
var student = db.Acd_Student.Where(k => k.Student_Id == Student_Id).Single();
var curEntryYear = db.Acd_Curriculum_Entry_Year.Where(k => k.Term_Year_Id == Term_Year_Id && k.Department_Id == student.Department_Id && k.Entry_Year_Id == student.Entry_Year_Id).Single();
ViewBag.Course_Id = new SelectList(db.usp_GetOfferredCourseForKRSByStudent(Term_Year_Id, student.Department_Id, curEntryYear.Class_Prog_Id, student.Entry_Year_Id, Student_Id), "course_id", "course_name");
ViewBag.Class_Id = new SelectList(new[] { new { ID = "0", Name = "-- Pilih Kelas --" } }, "ID", "Name");
ViewBag.Term_Year_Id = Term_Year_Id;
ViewBag.Student_Id = Student_Id;
ViewBag.Class_Prog_Id = curEntryYear.Class_Prog_Id;
//ViewBag.Curriculum_Id = db.Acd_Curriculum_Entry_Year.Where(p => p.Department_Id == student.Department_Id && p.Entry_Year_Id == student.Entry_Year_Id && p.Term_Year_Id == Term_Year_Id).SingleOrDefault().Curriculum_Id;
Acd_Student_Krs acd_Student_Krs = new Acd_Student_Krs();
acd_Student_Krs.Term_Year_Id = Term_Year_Id;
acd_Student_Krs.Student_Id = Student_Id;
acd_Student_Krs.Class_Prog_Id = curEntryYear.Class_Prog_Id;
return(View());
}
public ActionResult Delete(int id)
{
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
Acd_Student student = db.Acd_Student.Find(acd_Student_Krs.Student_Id);
var khscount = db.Acd_Student_Khs.Where(p => p.Krs_Id == acd_Student_Krs.Krs_Id).Count();
if (khscount > 0)
{
ViewBag.NotifMessage = "Data KRS sudah terpakai di KHS.";
return(View(acd_Student_Krs));
}
db.Acd_Student_Krs.Remove(acd_Student_Krs);
db.SaveChanges();
return(RedirectToAction("Index", "KRSv2", new
{
Student_NIM = student.Nim,
Term_Year_Id = acd_Student_Krs.Term_Year_Id
}));
}
// GET: StudentKrsV1/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Acd_Student_Krs acd_Student_Krs = db.Acd_Student_Krs.Find(id);
if (acd_Student_Krs == null)
{
return(HttpNotFound());
}
ViewBag.Course_Id = new SelectList(db.Acd_Course, "Course_Id", "Course_Code", acd_Student_Krs.Course_Id);
ViewBag.Student_Id = new SelectList(db.Acd_Student, "Student_Id", "Nim", acd_Student_Krs.Student_Id);
ViewBag.Cost_Item_Id = new SelectList(db.Fnc_Cost_Item, "Cost_Item_Id", "Cost_Item_Code", acd_Student_Krs.Cost_Item_Id);
ViewBag.Class_Id = new SelectList(db.Mstr_Class, "Class_Id", "Class_Name", acd_Student_Krs.Class_Id);
ViewBag.Class_Prog_Id = new SelectList(db.Mstr_Class_Program, "Class_Prog_Id", "Class_Prog_Code", acd_Student_Krs.Class_Prog_Id);
ViewBag.Term_Year_Id = new SelectList(db.Mstr_Term_Year.OrderByDescending(ty => ty.Term_Year_Id), "Term_Year_Id", "Term_Year_Name", acd_Student_Krs.Term_Year_Id);
return(View(acd_Student_Krs));
}
public ActionResult Edit(Acd_Student_Krs acd_Student_Krs)
{
if (ModelState.IsValid)
{
var student = db.Acd_Student.Find(acd_Student_Krs.Student_Id);
var classInfo = db.usp_GetClassInfoForKRS(acd_Student_Krs.Term_Year_Id, student.Department_Id, acd_Student_Krs.Class_Prog_Id, acd_Student_Krs.Course_Id, acd_Student_Krs.Class_Id).Single();
//var saldo = db.usp_Saldo(acd_Student_Krs.Student_Id, acd_Student_Krs.Term_Year_Id).Single();
//decimal usedSKS = db.Acd_Student_Krs.Where(k => k.Student_Id == acd_Student_Krs.Student_Id && k.Term_Year_Id == acd_Student_Krs.Term_Year_Id).Sum(p => p.Sks);
//decimal AllowedSKS = db.usp_GetAllowedSKSForKRS(acd_Student_Krs.Term_Year_Id, acd_Student_Krs.Student_Id).Single().Value;
//var CourseCostForKRS = db.usp_GetCourseCostForKRS(acd_Student_Krs.Term_Year_Id, student.Department_Id, acd_Student_Krs.Class_Prog_Id, student.Entry_Year_Id, acd_Student_Krs.Course_Id).Single();
if (classInfo.Free <= 0)
{
ViewBag.Course_Id = new SelectList(db.usp_GetOfferredCourseForKRSByStudent(acd_Student_Krs.Term_Year_Id, student.Department_Id, acd_Student_Krs.Class_Prog_Id, student.Entry_Year_Id, student.Student_Id), "course_id", "course_name", acd_Student_Krs.Course_Id);
ViewBag.Class_Id = new SelectList(db.Acd_Offered_Course.Where(z => z.Course_Id == acd_Student_Krs.Course_Id && z.Term_Year_Id == acd_Student_Krs.Term_Year_Id), "Class_Id", "Mstr_Class.Class_Name", acd_Student_Krs.Class_Id);
ViewBag.NotifMessage = "Kelas Sudah Penuh.";
return(View(acd_Student_Krs));
}
//if ((AllowedSKS - usedSKS) < CourseCostForKRS.applied_sks)
//{
// ViewBag.Course_Id = new SelectList(db.usp_GetOfferredCourseForKRSByStudent(acd_Student_Krs.Term_Year_Id, student.Department_Id, acd_Student_Krs.Class_Prog_Id, student.Entry_Year_Id, student.Student_Id), "course_id", "course_name", acd_Student_Krs.Course_Id);
// ViewBag.Class_Id = new SelectList(db.Acd_Offered_Course.Where(z => z.Course_Id == acd_Student_Krs.Course_Id && z.Term_Year_Id == acd_Student_Krs.Term_Year_Id), "Class_Id", "Mstr_Class.Class_Name", acd_Student_Krs.Class_Id);
// ViewBag.NotifMessage = "Sisa SKS tidak mencukupi.";
// return View(acd_Student_Krs);
//}
//if (saldo.SisaSaldoSaatIni < CourseCostForKRS.amount)
//{
// ViewBag.Course_Id = new SelectList(db.usp_GetOfferredCourseForKRSByStudent(acd_Student_Krs.Term_Year_Id, student.Department_Id, acd_Student_Krs.Class_Prog_Id, student.Entry_Year_Id, student.Student_Id), "course_id", "course_name", acd_Student_Krs.Course_Id);
// ViewBag.Class_Id = new SelectList(db.Acd_Offered_Course.Where(z => z.Course_Id == acd_Student_Krs.Course_Id && z.Term_Year_Id == acd_Student_Krs.Term_Year_Id), "Class_Id", "Mstr_Class.Class_Name", acd_Student_Krs.Class_Id);
// ViewBag.NotifMessage = "Sisa Saldo tidak mencukupi.";
// return View(acd_Student_Krs);
//}
db.Acd_Student_Krs.Attach(acd_Student_Krs); // attach in the Unchanged state
db.Entry(acd_Student_Krs).Property(r => r.Class_Id).IsModified = true;
db.SaveChanges();
return(RedirectToAction("Index", new { Student_NIM = student.Nim, Term_Year_Id = acd_Student_Krs.Term_Year_Id }));
}
return(View());
}
public ActionResult ListAdd(IEnumerable <long> checkStudent_IdToAdd, short Department_Id, int Offered_Course_id, short Entry_Year_Id, Acd_Student_Krs acd_Student_Krs)
{
bool errorSave = false;
if (ModelState.IsValid)
{
if (checkStudent_IdToAdd == null)
{
TempData["massage"] = "Pilih data terlebih dahulu!";
return(Redirect(Request.UrlReferrer.ToString()));
}
if (validKouta(Offered_Course_id, acd_Student_Krs.Term_Year_Id, acd_Student_Krs.Class_Prog_Id, acd_Student_Krs.Course_Id, acd_Student_Krs.Class_Id, checkStudent_IdToAdd) == false)
{
TempData["massage"] = "Kuota kelas tidak cukup!";
return(Redirect(Request.UrlReferrer.ToString()));
}
var getCourseCostForKRS = db.usp_GetCourseCostForKRS(acd_Student_Krs.Term_Year_Id, Department_Id, acd_Student_Krs.Class_Prog_Id, Entry_Year_Id, acd_Student_Krs.Course_Id)
.Select(x => new
{
x.amount,
x.applied_sks
}).First();
try
{
int jmlSkipLoop = 0;
List <Vm_notif_error> listIdError = new List <Vm_notif_error>();
foreach (var i in checkStudent_IdToAdd)
{
bool errorSks = false;
bool errorSaldo = false;
int OsksAllowed = 0;
decimal OsksAmbil = 0;
long OSisaSaldoSaatIni = 0;
if (validSks(out OsksAllowed, out OsksAmbil, i, acd_Student_Krs.Term_Year_Id, getCourseCostForKRS.applied_sks) == false)
{
errorSks = true;
}
if (validSaldo(out OSisaSaldoSaatIni, i, acd_Student_Krs.Term_Year_Id, getCourseCostForKRS.amount) == false)
{
errorSaldo = true;
}
if (errorSks || errorSaldo)
{
listIdError.Add(new Vm_notif_error
{
Student_Id = i,
errorSks = errorSks,
errorSaldo = errorSaldo,
sksAllowed = OsksAllowed,
sksAmbil = OsksAmbil,
SisaSaldoSaatIni = OSisaSaldoSaatIni
});
jmlSkipLoop = jmlSkipLoop + 1;
continue;
}
acd_Student_Krs.Student_Id = i;
acd_Student_Krs.Sks = Convert.ToDecimal(getCourseCostForKRS.applied_sks);
acd_Student_Krs.Amount = Convert.ToInt32(getCourseCostForKRS.amount);
acd_Student_Krs.Created_Date = DateTime.Now;
acd_Student_Krs.Krs_Date = DateTime.Now;
acd_Student_Krs.Modified_Date = DateTime.Now;
acd_Student_Krs.Cost_Item_Id = 3; //deposit KRS, nanti dikembangkan bisa 9(KKN)
db.Acd_Student_Krs.Add(acd_Student_Krs);
db.SaveChanges();
}
if (jmlSkipLoop > 0)
{
errorSave = true;
if (jmlSkipLoop <= 10)
{
TempData["detailMassage"] = listIdError;
//string html = string.Empty;
//foreach (var item in listIdError)
//{
// html = "<tr><td>" + item.NimNama.Nim + "</td><td>" + item.NimNama.Full_Name + "</td><td>" + item.Keterangan + "</td></tr>";
//}
//TempData["detailMassage"] = "<table>" + html + "</table>";
}
else
{
TempData["detailMassage1"] = jmlSkipLoop + " Mahasisawa gagal diinput";
}
//TempData["detailMassage"] = listIdError;
//TempData["massage"] = jmlSkipLoop + " Mahasisawa gagal diinput";
//string[] arrayIdError;
//arrayIdError = listIdError.ConvertAll<String>(p => p.Student_Id.ToString()).ToArray<String>();
}
}
catch (Exception)
{
TempData["massage"] = "Proses gagal. Terjadi kesalahan database!";
errorSave = true;
}
}
if (errorSave)
{
return(RedirectToAction("ListAdd", new
{
Term_Year_Id = acd_Student_Krs.Term_Year_Id,
Class_Prog_Id = acd_Student_Krs.Class_Prog_Id,
Department_Id = Department_Id,
Course_Id = acd_Student_Krs.Course_Id,
Class_Id = acd_Student_Krs.Class_Id,
Offered_Course_id = Offered_Course_id,
Entry_Year_Id = Entry_Year_Id
}));
}
else
{
TempData["massage_success"] = "Sukses, data berhasil ditambahkan";
return(RedirectToAction("List", new {
Term_Year_Id = acd_Student_Krs.Term_Year_Id,
Class_Prog_Id = acd_Student_Krs.Class_Prog_Id,
Course_Id = acd_Student_Krs.Course_Id,
Department_Id = Department_Id,
Class_Id = acd_Student_Krs.Class_Id,
Offered_Course_id = Offered_Course_id
}));
}
}