public ActionResult DeleteConfirmed(long id, short Department_Id) { Acd_Yudisium acd_Yudisium = db.Acd_Yudisium.Find(id); db.Acd_Yudisium.Remove(acd_Yudisium); db.SaveChanges(); return(RedirectToAction("Index", new { Term_Year_Id = acd_Yudisium.Term_Year_Id, Department_Id = Department_Id })); }
//int proses 3 public ActionResult BeritaAcaraYudisium(int?Employee_Id, long?Student_Id, DateTime?tglY, string no, string namaJab, short?GraduatePredicateId, bool?IsGraduated) { if (TempData["shortMessage"] != null) { ViewBag.message = TempData["shortMessage"].ToString(); } ViewBag.OriUrl = System.Web.HttpContext.Current.Request.Url.AbsolutePath.ToString(); string DeptFunc = (string)Session["DeptFunc"]; Emp_Employee emp_Employee = new Emp_Employee(); if (Employee_Id != null) { emp_Employee = db.Emp_Employee.Find(Employee_Id); } long StudentId = Convert.ToInt64(TempData["StudentId"] ?? Student_Id); Acd_Yudisium acd_Yudisium = db.Acd_Yudisium.Find(StudentId); acd_Yudisium.Yudisium_Date = tglY ?? acd_Yudisium.Yudisium_Date; acd_Yudisium.Sk_Num = no ?? acd_Yudisium.Sk_Num; if (acd_Yudisium.Department_Functionary == null) { acd_Yudisium.Department_Functionary = namaJab ?? DeptFunc; } acd_Yudisium.Department_Functionary_Name = emp_Employee.Full_Name ?? acd_Yudisium.Department_Functionary_Name; acd_Yudisium.Department_Functionary_Nik = emp_Employee.Nik ?? acd_Yudisium.Department_Functionary_Nik; //View Data var acd_Student = new Acd_Student(); acd_Student = db.Acd_Student.Where(s => s.Student_Id == StudentId).FirstOrDefault(); ViewBag.Nim = acd_Student.Nim; ViewBag.Name = acd_Student.Full_Name; ViewBag.Department_Id = acd_Student.Department_Id; //viewbag for dropdown Is_Graduated List <SelectListItem> obj = new List <SelectListItem>(); obj.Add(new SelectListItem { Text = "Lulus", Value = "true" }); obj.Add(new SelectListItem { Text = "Tidak lulus", Value = "false" }); ViewBag.Is_Graduated = new SelectList(obj, "Value", "Text", IsGraduated ?? acd_Yudisium.Is_Graduated); //viewbag for dropdown Graduate_Predicate ViewBag.Graduate_Predicate_Id = new SelectList(db.Mstr_Graduate_Predicate, "Graduate_Predicate_Id", "Predicate_Name", GraduatePredicateId ?? acd_Yudisium.Graduate_Predicate_Id); return(View(acd_Yudisium)); }
public ActionResult Edit([Bind(Include = "Student_Id,Term_Year_Id,Sks_Total,Course_Count,Bnk,Gpa,Sk_Num,Sk_Date,Yudisium_Date,Graduate_Date,Application_Date,Is_Graduated,Graduate_Predicate_Id,Transcript_Num,Transcript_Date,Department_Functionary,Department_Functionary_Name,Department_Functionary_Nik,Faculty_Functionary,Faculty_Functionary_Name,Faculty_Functionary_Nik,Description,Graduation_Period_Id,Age_Year,Age_Month,Age_Day,Age_Year_Length,Age_Day_Length,Study_Length_Year,Study_Length_Month,Study_Length_Day,Study_Length_Sum_Year,Study_Length_Sum_Day,Study_Smt_Length,Study_Smt_Off_Length,Created_By,Created_Date,Modified_By,Modified_Date,Order_Id")] Acd_Yudisium acd_Yudisium, string OriUrl) { if (acd_Yudisium.Study_Length_Year == null) { var EntryYearStudent = db.Acd_Student.Where(s => s.Student_Id == acd_Yudisium.Student_Id).Select(s => s.Entry_Year_Id).First(); var EntryTermStudent = db.Acd_Student.Where(s => s.Student_Id == acd_Yudisium.Student_Id).Select(s => s.Entry_Term_Id).First(); DateTime?EntryDate = null; if (EntryTermStudent == 1) { string d = "01/09/"; EntryDate = Convert.ToDateTime(d + EntryYearStudent); } if (EntryTermStudent == 2) { var year = EntryYearStudent + 1; string d = "01/02/"; EntryDate = Convert.ToDateTime(d + year); } SelisihTanggal st = new SelisihTanggal(); st.OriTanggal_1 = EntryDate.Value; st.OriTanggal_2 = acd_Yudisium.Yudisium_Date.Value; //adding data to yudisium table acd_Yudisium.Study_Length_Year = st.Tahun; acd_Yudisium.Study_Length_Month = st.Bulan; acd_Yudisium.Study_Length_Day = st.Hari; acd_Yudisium.Study_Length_Sum_Year = Convert.ToDecimal(st.JmlTahun); acd_Yudisium.Study_Length_Sum_Day = Convert.ToInt16(st.JmlHari); } if (ModelState.IsValid) { string[] sOriUrl = OriUrl.Split('/'); //var idDept = db.Acd_Student.Where(s => s.Student_Id == acd_Yudisium.Student_Id).Select(s => s.Department_Id).FirstOrDefault(); System.Web.HttpContext.Current.Session["DeptFunc"] = acd_Yudisium.Department_Functionary; System.Web.HttpContext.Current.Session["FacFunc"] = acd_Yudisium.Faculty_Functionary; db.Entry(acd_Yudisium).State = EntityState.Modified; db.SaveChanges(); TempData["shortMessage"] = "Data berhasil disimpan"; return(RedirectToAction(sOriUrl[2], sOriUrl[1], new { Student_Id = acd_Yudisium.Student_Id })); } //ViewBag.Graduation_Period_Id = new SelectList(db.Acd_Graduation_Period, "Graduation_Period_Id", "Period_Name", acd_Yudisium.Graduation_Period_Id); //ViewBag.Student_Id = new SelectList(db.Acd_Student, "Student_Id", "Nim", acd_Yudisium.Student_Id); //ViewBag.Graduate_Predicate_Id = new SelectList(db.Mstr_Graduate_Predicate, "Graduate_Predicate_Id", "Predicate_Name", acd_Yudisium.Graduate_Predicate_Id); //ViewBag.Term_Year_Id = new SelectList(db.Mstr_Term_Year, "Term_Year_Id", "Term_Year_Name", acd_Yudisium.Term_Year_Id); return(View(acd_Yudisium)); }
// GET: Yudisium/Create public ActionResult Create(short idDept, short idTermYear, long Student_Id) { ViewBag.currentTermYear = idTermYear; ViewBag.CurrentDept = idDept; //View Data var acd_Student = new Acd_Student(); acd_Student = db.Acd_Student.Where(s => s.Student_Id == Student_Id).FirstOrDefault(); ViewBag.Nim = acd_Student.Nim; ViewBag.Name = acd_Student.Full_Name; //View Data var acd_Thesis = new Acd_Thesis(); acd_Thesis = db.Acd_Thesis.Where(th => th.Student_Id == Student_Id).FirstOrDefault(); if (acd_Thesis != null) { ViewBag.judul = acd_Thesis.Thesis_Title; ViewBag.judul_Eng = acd_Thesis.Thesis_Title_Eng; ViewBag.dosenPemb1 = acd_Thesis.Emp_Employee.Full_Name; ViewBag.dosenPemb2 = acd_Thesis.Emp_Employee1.Full_Name; ViewBag.tglSeminar = string.Format("{0:dddd, d MMMM yyyy}", acd_Thesis.Seminar_Date); ViewBag.tglPendadaran = string.Format("{0:dddd, d MMMM yyyy}", acd_Thesis.Thesis_Exam_Date); } //Input Data var acd_yudisium = new Acd_Yudisium(); var acd_transcript = db.Acd_Transcript.Where(t => t.Student_Id == Student_Id).ToList(); acd_yudisium.Student_Id = Student_Id; acd_yudisium.Term_Year_Id = idTermYear; if (acd_transcript.Count() != 0) { acd_yudisium.Sks_Total = Math.Round(Convert.ToDecimal(acd_transcript.Sum(t => t.Sks)), 0); acd_yudisium.Course_Count = Convert.ToByte(acd_transcript.Count()); acd_yudisium.Bnk = acd_transcript.Sum(t => t.Bnk_Value); acd_yudisium.Gpa = Math.Round(Convert.ToDecimal(acd_yudisium.Bnk / acd_yudisium.Sks_Total), 2); } acd_yudisium.Application_Date = DateTime.Now; //ViewBag.Graduation_Period_Id = new SelectList(db.Acd_Graduation_Period, "Graduation_Period_Id", "Period_Name"); //ViewBag.Student_Id = new SelectList(db.Acd_Student, "Student_Id", "Nim"); //ViewBag.Graduate_Predicate_Id = new SelectList(db.Mstr_Graduate_Predicate, "Graduate_Predicate_Id", "Predicate_Name"); //ViewBag.Term_Year_Id = new SelectList(db.Mstr_Term_Year, "Term_Year_Id", "Term_Year_Name"); return(View(acd_yudisium)); }
// GET: Yudisium/Details/5 public ActionResult Details(long?id) { ViewBag.proses = new string[] { "Surat Permohonan Yudisium", //proses 1 "Surat bebas pinjaman lab", //proses 2 "Berita acara yudisium", //proses 3 "Pengantar pembayaran wisuda", //proses 4 "Surat keterangan lulus", //proses 5 "Cetak transkrip", //proses 6 "Cetak bukti penyerahan TA" //proses 7 }; //View Data var acd_Student = new Acd_Student(); acd_Student = db.Acd_Student.Where(s => s.Student_Id == id).FirstOrDefault(); ViewBag.Nim = acd_Student.Nim; ViewBag.Name = acd_Student.Full_Name; //View Data var acd_Thesis = new Acd_Thesis(); acd_Thesis = db.Acd_Thesis.Where(th => th.Student_Id == id).FirstOrDefault(); if (acd_Thesis != null) { ViewBag.judul = acd_Thesis.Thesis_Title; ViewBag.judul_Eng = acd_Thesis.Thesis_Title_Eng; ViewBag.dosenPemb1 = acd_Thesis.Emp_Employee.Full_Name; ViewBag.dosenPemb2 = acd_Thesis.Emp_Employee1.Full_Name; ViewBag.tglSeminar = string.Format("{0:dddd, d MMMM yyyy}", acd_Thesis.Seminar_Date); ViewBag.tglPendadaran = string.Format("{0:dddd, d MMMM yyyy}", acd_Thesis.Thesis_Exam_Date); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Acd_Yudisium acd_Yudisium = db.Acd_Yudisium.Find(id); if (acd_Yudisium == null) { return(HttpNotFound()); } ViewBag.currentTermYear = acd_Yudisium.Term_Year_Id; ViewBag.CurrentDept = acd_Student.Department_Id; return(View(acd_Yudisium)); }
// GET: Yudisium/Delete/5 public ActionResult Delete(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Acd_Yudisium acd_Yudisium = db.Acd_Yudisium.Find(id); if (acd_Yudisium == null) { return(HttpNotFound()); } ViewBag.currentTermYear = acd_Yudisium.Term_Year_Id; ViewBag.CurrentDept = db.Acd_Student.Where(s => s.Student_Id == acd_Yudisium.Student_Id).Select(s => s.Department_Id).FirstOrDefault(); return(View(acd_Yudisium)); }
public ActionResult Create([Bind(Include = "Student_Id,Term_Year_Id,Sks_Total,Course_Count,Bnk,Gpa,Sk_Num,Sk_Date,Yudisium_Date,Graduate_Date,Application_Date,Is_Graduated,Graduate_Predicate_Id,Transcript_Num,Transcript_Date,Department_Functionary,Department_Functionary_Name,Department_Functionary_Nik,Faculty_Functionary,Faculty_Functionary_Name,Faculty_Functionary_Nik,Description,Graduation_Period_Id,Age_Year,Age_Month,Age_Day,Age_Year_Length,Age_Day_Length,Study_Length_Year,Study_Length_Month,Study_Length_Day,Study_Length_Sum_Year,Study_Length_Sum_Day,Study_Smt_Length,Study_Smt_Off_Length,Created_By,Created_Date,Modified_By,Modified_Date,Order_Id")] Acd_Yudisium acd_Yudisium) { acd_Yudisium.Gpa = Math.Round(Convert.ToDecimal(acd_Yudisium.Bnk / acd_Yudisium.Sks_Total), 2); var idDept = db.Acd_Student.Where(s => s.Student_Id == acd_Yudisium.Student_Id).Select(s => s.Department_Id).FirstOrDefault(); if (ModelState.IsValid) { db.Acd_Yudisium.Add(acd_Yudisium); db.SaveChanges(); return(RedirectToAction("Index", new { Term_Year_Id = acd_Yudisium.Term_Year_Id, Department_Id = idDept })); } //ViewBag.Graduation_Period_Id = new SelectList(db.Acd_Graduation_Period, "Graduation_Period_Id", "Period_Name", acd_Yudisium.Graduation_Period_Id); //ViewBag.Student_Id = new SelectList(db.Acd_Student, "Student_Id", "Nim", acd_Yudisium.Student_Id); //ViewBag.Graduate_Predicate_Id = new SelectList(db.Mstr_Graduate_Predicate, "Graduate_Predicate_Id", "Predicate_Name", acd_Yudisium.Graduate_Predicate_Id); //ViewBag.Term_Year_Id = new SelectList(db.Mstr_Term_Year, "Term_Year_Id", "Term_Year_Name", acd_Yudisium.Term_Year_Id); return(RedirectToAction("Create", new { idTermYear = acd_Yudisium.Term_Year_Id, idDept = idDept, Student_Id = acd_Yudisium.Student_Id })); }
//int proses 5 public ActionResult SuratKeteranganLulus(int?Employee_Id, long?Student_Id, DateTime?tglS, string namaJab) { if (TempData["shortMessage"] != null) { ViewBag.message = TempData["shortMessage"].ToString(); } ViewBag.OriUrl = System.Web.HttpContext.Current.Request.Url.AbsolutePath.ToString(); string facFunc = (string)Session["FacFunc"]; Emp_Employee emp_Employee = new Emp_Employee(); if (Employee_Id != null) { emp_Employee = db.Emp_Employee.Find(Employee_Id); } long StudentId = Convert.ToInt64(TempData["StudentId"] ?? Student_Id); Acd_Yudisium acd_Yudisium = db.Acd_Yudisium.Find(StudentId); acd_Yudisium.Sk_Date = tglS ?? acd_Yudisium.Sk_Date; if (acd_Yudisium.Faculty_Functionary == null) { acd_Yudisium.Faculty_Functionary = namaJab ?? facFunc; } acd_Yudisium.Faculty_Functionary_Name = emp_Employee.Full_Name ?? acd_Yudisium.Faculty_Functionary_Name; acd_Yudisium.Faculty_Functionary_Nik = emp_Employee.Nik ?? acd_Yudisium.Faculty_Functionary_Nik; //View Data var acd_Student = new Acd_Student(); acd_Student = db.Acd_Student.Where(s => s.Student_Id == StudentId).FirstOrDefault(); ViewBag.Nim = acd_Student.Nim; ViewBag.Name = acd_Student.Full_Name; ViewBag.Department_Id = acd_Student.Department_Id; return(View(acd_Yudisium)); }