public ActionResult TrxCommPlan(int id) { var trx = db.Trx_Comm_Plans.Include(t => t.Mst_CommPlan).Include(s => s.Mst_User).Where(ts => ts.TaskId == id); int usrid = Convert.ToInt32(Session["loginuserid"]); var user = db.Trx_Comm_Plans.Include(us => us.Mst_User).Include(rl => rl.Mst_User.Mst_Role).Where(tx => tx.TaskId == id).FirstOrDefault(); int htt = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.TaskName == "Commitment Plan" && ts.ActionDesc != "Request").Count(); if (htt == 0) { return(RedirectToAction("Error", "Error")); } ViewBag.user = user.Mst_User.FullName; ViewBag.role = user.Mst_User.Mst_Role.RoleName; var act = db.Tbl_Tasks.Where(ts => ts.TaskId == user.TaskId).OrderByDescending(asx => asx.Id).First(); ViewBag.ActionDesc = act.ActionDesc; var report = db.Mst_Users.Where(us => us.UserId == user.Mst_User.DirectReportId).Single(); string cekperiode = CekPeriode.CheckPeriode(); int cekhitung = db.Tbl_Tasks.Where(ts => ts.TaskFor == user.Mst_User.UserId || ts.TaskMaker == user.Mst_User.UserId && ts.Periode == cekperiode && ts.TaskName == "Commitment Plan" && ts.ActionDesc == "Save").Count(); ViewBag.cek = cekhitung; ViewBag.report = report.FullName; ViewBag.periode = cekperiode; string level = Session["level"].ToString(); int pmoteamlead = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.ActionDesc == "Submit" && ts.IsAction == false && ts.Periode == cekperiode && ts.TaskName == "Commitment Plan").Count(); int management = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.ActionDesc == "Approve" && ts.IsAction == false && ts.Periode == cekperiode && ts.TaskName == "Commitment Plan").Count(); if (level == "Management" && report.UserId == usrid) { management = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.ActionDesc == "Submit" || ts.ActionDesc == "Approve" && ts.IsAction == false && ts.Periode == cekperiode && ts.TaskName == "Commitment Plan").Count(); } ViewBag.pmoteamlead = pmoteamlead; ViewBag.management = management; int hitungisi = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.ActionDesc == "Submit" || ts.ActionDesc == "Save" && ts.Periode == cekperiode).Count(); if (hitungisi != 0) { var taskmaker = db.Tbl_Tasks.OrderByDescending(ts => ts.Id).Where(ts => ts.TaskId == id && ts.ActionDesc == "Submit" || ts.ActionDesc == "Save" && ts.Periode == cekperiode).FirstOrDefault(); if (taskmaker.TaskMaker == usrid || taskmaker.TaskFor == usrid || level == "Management") { return(View(trx.ToList())); } } return(RedirectToAction("Index", "Task")); }
public ActionResult TrxCommPlanEdit(int id) { int htt = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.TaskName == "Commitment Plan" && ts.ActionDesc != "Request").Count(); if (htt == 0) { return(RedirectToAction("Error", "Error")); } var trx = db.Trx_Comm_Plans.Include(t => t.Mst_CommPlan).Include(s => s.Mst_User).Where(ts => ts.TaskId == id); int usrid = Convert.ToInt32(Session["loginuserid"]); var user = db.Trx_Comm_Plans.Include(us => us.Mst_User).Include(rl => rl.Mst_User.Mst_Role).Where(tx => tx.TaskId == id).FirstOrDefault(); ViewBag.user = user.Mst_User.FullName; ViewBag.role = user.Mst_User.Mst_Role.RoleName; string cekperiode = CekPeriode.CheckPeriode(); ViewBag.periode = cekperiode; var report = db.Mst_Users.Where(us => us.UserId == user.Mst_User.DirectReportId).Single(); ViewBag.report = report.FullName; ViewBag.level = Session["level"].ToString(); int cekhitung = db.Tbl_Tasks.Where(ts => ts.TaskFor == usrid && ts.Periode == cekperiode && ts.TaskName == "Commitment Plan" && ts.ActionDesc == "Revise" && ts.IsAction == false).Count(); ViewBag.cek = cekhitung; int ceksave = db.Tbl_Tasks.Where(ts => ts.TaskId == user.TaskId && ts.Periode == cekperiode && ts.TaskName == "Commitment Plan" && ts.ActionDesc == "Save" && ts.IsAction == false).Count(); ViewBag.ceksave = ceksave; int hitungkomentar = db.Tbl_Comments.Where(r => r.TaskId == id && r.Action == "Revise").Count(); if (hitungkomentar != 0) { string komentar = db.Tbl_Comments.Where(r => r.TaskId == id && r.Action == "Revise").OrderByDescending(r => r.Id).FirstOrDefault().CommentText; ViewBag.komentar = komentar; } if (user.Mst_User.UserId != usrid) { return(RedirectToAction("index")); } return(View(trx.ToList())); }
public ActionResult commplan() { int id = Convert.ToInt32(Session["loginuserid"]); var user = db.Mst_Users.Include(rl => rl.Mst_Role).Where(us => us.UserId == id).Single(); var report = db.Mst_Users.Where(us => us.UserId == user.DirectReportId).Single(); ViewBag.role = user.Mst_Role.RoleName; ViewBag.roleid = user.RoleId; ViewBag.report = report.FullName; var commplan = db.Mst_CommPlan_Details.Include(cm => cm.Mst_CommPlan).Where(cd => cd.RoleId == user.RoleId); int count = commplan.Count(); ViewBag.hitung = count; string cek = CekPeriode.CheckPeriode(); int ceksubmit = db.Trx_Comm_Plans.Include(ts => ts.Tbl_Task).Where(ts => ts.SubmitBy == id && ts.Periode == cek).Count(); ViewBag.ceksubmit = ceksubmit; ViewBag.cek = cek; ViewBag.isopen = user.CommPlanOpen; return(View(commplan)); }
// GET: Mst_Performance_Review public ActionResult Index() { int userId = Convert.ToInt32(Session["loginuserid"]); bool isPerfReviewOpen = Convert.ToBoolean(Session["performance"]); ViewBag.periode = CekPeriode.CheckPeriode(); ViewBag.isopen = isPerfReviewOpen; Mst_User mst_User = new Mst_User(); string role = db.Mst_Users.Include(r => r.Mst_Role).Where(r => r.UserId == userId).FirstOrDefault().Mst_Role.RoleName; if (role == "PMO") { ViewBag.UserId = new SelectList(db.Mst_Users.Include(r => r.Mst_Role).Where(r => r.Mst_Role.RoleName != "Management" && r.Mst_Role.RoleName != "PMO" && r.Mst_Role.RoleName != "Head of PMO" && r.Mst_Role.RoleName != "Head of Delivery"), "UserId", "FullName"); } else if (role == "Team Leader") { ViewBag.UserId = new SelectList(db.Mst_Users.Where(r => r.DirectReportId == userId), "UserId", "FullName"); } else if (role == "Head of PMO" || role == "Head of Delivery") { ViewBag.UserId = new SelectList(db.Mst_Users.Include(r => r.Mst_Role).Where(r => r.Mst_Role.RoleName != "Management" && r.Mst_Role.RoleName != "Head of PMO" && r.Mst_Role.RoleName != "Head of Delivery"), "UserId", "FullName"); } else if (role == "Management") { ViewBag.UserId = new SelectList(db.Mst_Users.Include(r => r.Mst_Role).Where(r => r.Mst_Role.RoleName != "Management"), "UserId", "FullName"); } if (Request.QueryString["UserId"] != null) { if (Request.QueryString["UserId"] != "0") { string nama_r = ""; var req = Request.QueryString["UserId"]; int id = Convert.ToInt32(req); var datasemua = db.Mst_Users.Include(r => r.Mst_Role).Include(r => r.Mst_RoleMap).Where(r => r.UserId == id).Single(); var data_r = db.Mst_Users.Where(r => r.UserId == datasemua.DirectReportId).SingleOrDefault(); if (data_r != null) { nama_r = data_r.FullName.ToString(); } else { nama_r = ""; } string periode = CekPeriode.CheckPeriode(); bool exist = ExistReview(userId, id, periode); Debug.WriteLine("periode = " + periode + " , exist = " + exist); //string periodePotong = periode.Remove(periode.Length - 5); return(Json(new { datasemua, nama_r, exist, periode }, JsonRequestBehavior.AllowGet)); } } if (Request.QueryString["ReviewId"] != null) { if (Request.QueryString["ReviewId"] != "0") { var req = Request.QueryString["ReviewId"]; int id = Convert.ToInt32(req); var data2 = db.Mst_Perform_Details.Include(r => r.Mst_Perform).Include(r => r.Mst_Perform.Mst_RoleMap).Where(r => r.Mst_Perform.Mst_RoleMap.RoleMapId == id).OrderBy(r => r.Mst_Perform.PerformId); return(Json(data2, JsonRequestBehavior.AllowGet)); } } return(View()); }
public ActionResult TrxCommPlanEdit(FormCollection form, int id) { int usrid = Convert.ToInt32(Session["loginuserid"]); var data = db.Mst_Users.Where(ui => ui.UserId == usrid).Single(); var task = db.Trx_Comm_Plans.Where(ts => ts.TaskId == id).First(); int taskid = task.TaskId; var atasan = db.Mst_Users.Where(us => us.UserId == data.DirectReportId).FirstOrDefault(); string penerima = atasan.Email; string cekperiode = CekPeriode.CheckPeriode(); //string periode = form["periode"] + " " + DateTime.Now.Year; Tbl_Task tsk = new Tbl_Task(); int reportid = Convert.ToInt32(data.DirectReportId); tsk.TaskFor = reportid; tsk.TaskMaker = data.UserId; tsk.TaskName = "Commitment Plan"; tsk.Description = data.FullName + " has submitted Commitment Plan for Periode " + cekperiode; tsk.Periode = cekperiode; int kondisi = db.Tbl_Tasks.Count(); tsk.ActionDesc = "Submit"; tsk.TaskId = taskid; int cektgl = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.Periode == cekperiode && ts.ActionDesc == "Submit" && ts.TaskName == "Commitment Plan").Count(); if (cektgl != 0) { var cektanggalsubmit = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.Periode == cekperiode && ts.ActionDesc == "Submit" && ts.TaskName == "Commitment Plan").FirstOrDefault(); tsk.SubmitDate = cektanggalsubmit.SubmitDate; } else { tsk.SubmitDate = DateTime.Now; } db.Tbl_Tasks.Add(tsk); db.SaveChanges(); int hit = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Revise" && ts.IsAction == false).Count(); if (hit != 0) { var rm = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Revise" && ts.IsAction == false).First(); rm.IsAction = true; db.SaveChanges(); } int ceksave = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Save" && ts.IsAction == false).Count(); if (ceksave != 0) { var rm = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Save" && ts.IsAction == false).First(); rm.IsAction = true; db.SaveChanges(); } string linknya = "http://localhost:53400/Task/TrxCommPlan/" + tsk.TaskId; string deskripsi = "Hi, " + atasan.FullName + "<br><br>" + tsk.Description + "<a href=" + linknya + "><br><br>Click Here to Review</a><br><br><p>Regards,</p><p>e-PRMS Admin</p>"; //return Json(tsk, JsonRequestBehavior.AllowGet); SendEmail email = new SendEmail(); email.Send(penerima, tsk.Description, deskripsi); var trxc = db.Trx_Comm_Plans.Where(tr => tr.TaskId == taskid); db.Trx_Comm_Plans.RemoveRange(trxc); int i = 0; while (true) { string hitung = i.ToString(); if (form["detail_" + hitung] == null) { break; } string[] detail = form["detail_" + hitung].Split(char.Parse(",")); string[] results = form["resultan_" + hitung].Split(char.Parse(",")); string[] complaid = form["complainid_" + hitung].Split(char.Parse(",")); HttpPostedFileBase file = Request.Files["file_" + hitung]; if (file == null) { filed = form["files_" + hitung].Split(char.Parse(",")); files = filed[0]; } string a = UploadFiles(file); string dtku = detail[0]; string hasil = results[0]; string com = complaid[0]; Trx_Comm_Plan trx = new Trx_Comm_Plan(); trx.TaskId = taskid; trx.CommPlanid = Convert.ToInt16(com); trx.DescriptionPlan = dtku; trx.IsAchievable = hasil; trx.SubmitBy = usrid; trx.Periode = cekperiode; if (file != null) { trx.File = a; } else { trx.File = files; } db.Trx_Comm_Plans.Add(trx); db.SaveChanges(); i++; } return(RedirectToAction("Index", "Task")); //return Json(tsk, JsonRequestBehavior.AllowGet); }
public ActionResult TrxCommPlan(FormCollection form, int id) { int usrid = Convert.ToInt32(Session["loginuserid"]); var data = db.Mst_Users.Where(ui => ui.UserId == usrid).Single(); var task = db.Trx_Comm_Plans.Include(us => us.Mst_User).Include(rl => rl.Mst_User.Mst_Role).Where(tt => tt.TaskId == id).FirstOrDefault(); string periodecek = CekPeriode.CheckPeriode(); var submit = db.Tbl_Tasks.Where(ts => ts.TaskId == id && ts.ActionDesc == "Submit" && ts.Periode == periodecek).FirstOrDefault(); DateTime submitDate = submit.SubmitDate.Date; string penerima = task.Mst_User.Email; int taskid = task.TaskId; string nama = task.Mst_User.FullName; int userid = task.Mst_User.UserId; var tsfo = db.Mst_Users.Where(us => us.UserId == task.Mst_User.DirectReportId).Single(); string atasan = tsfo.Email; var act = db.Tbl_Tasks.Where(ts => ts.TaskId == task.TaskId).OrderByDescending(asx => asx.Id).First(); ViewBag.ActionDesc = act.ActionDesc; var management = db.Mst_Users.Include(rl => rl.Mst_Role).Where(ll => ll.Mst_Role.RoleName == "Management").First(); int managementid = management.UserId; Tbl_Task tsk = new Tbl_Task(); tsk.SubmitDate = submitDate; int kondisi = db.Tbl_Tasks.Count(); string level = Session["level"].ToString(); //string periode = form["periode"] + " " + DateTime.Now.Year; string periode = CekPeriode.CheckPeriode(); int aksi = Convert.ToInt32(form["check"]); string komentar = form["komentar"]; Tbl_Comment comment = new Tbl_Comment(); var date = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Submit").FirstOrDefault(); tsk.SubmitDate = date.SubmitDate; int apprev = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Submit" && ts.Periode == periode && ts.IsAction == false || ts.TaskId == taskid && ts.ActionDesc == "Revise" && ts.Periode == periode && ts.IsAction == false || ts.TaskId == taskid && ts.ActionDesc == "Approve" && ts.Periode == periode && ts.IsAction == false).Count(); /*--------------------------------------------------------FOR USER---------------------------------------------------------------*/ if (level == "Senior Developer" || level == "Middle Developer" || level == "Junior Developer") { tsk.Periode = periode; tsk.TaskId = taskid; tsk.TaskName = "Commitment Plan"; int reportid = Convert.ToInt32(data.DirectReportId); tsk.TaskFor = reportid; tsk.TaskMaker = data.UserId; tsk.ActionDesc = "Submit"; tsk.Description = data.FullName + " has submitted Commitment Plan for Periode " + periode; string linknya = "http://localhost:53400/Task/TrxCommPlan/" + tsk.TaskId; string deskripsi = "Hi, " + tsfo.FullName + "<br><br>" + tsk.Description + "<a href=" + linknya + "><br><br>Click Here to Review</a><br><p>Regards</p><p>e-PRMS Admin</p>"; var app = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Save").FirstOrDefault(); kirim.Send(atasan, tsk.Description, deskripsi); app.IsAction = true; db.Tbl_Tasks.Add(tsk); db.SaveChanges(); if (apprev != 0) { var edit = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Submit" && ts.Periode == periode && ts.IsAction == false || ts.TaskId == taskid && ts.ActionDesc == "Revise" && ts.Periode == periode && ts.IsAction == false || ts.TaskId == taskid && ts.ActionDesc == "Save" && ts.Periode == periode && ts.IsAction == false).FirstOrDefault(); edit.IsAction = true; db.SaveChanges(); } } /*--------------------------------------------------------FOR MANAGEMENT----------------------------------------------------------*/ if (level == "Management") { tsk.TaskId = taskid; tsk.TaskName = "Commitment Plan"; tsk.TaskFor = task.Mst_User.UserId; tsk.TaskMaker = usrid; tsk.Periode = periode; if (aksi == 1) { tsk.ActionDesc = "Complete"; tsk.Description = "Your commitment plan has been approved by " + data.FullName; string linknya = "http://localhost:53400/Task/TrxCommPlan/" + tsk.TaskId; string deskripsi = "Hi, " + task.Mst_User.FullName + "<br><br>" + tsk.Description + "<br><br>Komentar : " + komentar + "<br>" + "<a href=" + linknya + "><br>Click Here to Review</a><br><p>Regards</p><p>e-PRMS Admin</p>"; tsk.IsAction = true; string role = task.Mst_User.Mst_Role.RoleName; if (role != "Head of PMO" && role != "Head of Delivery") { string subject_atasan = data.FullName + " has approved commitment plan from " + task.Mst_User.FullName + " for Periode " + periode; string body_atasan = "Hi, " + tsfo.FullName + "<br><br>" + subject_atasan + "<a href=" + linknya + "><br><br>Click Here to Review</a><br><p>Regards</p><p>e-PRMS Admin</p>"; kirim.Send(tsfo.Email, subject_atasan, body_atasan); } kirim.Send(task.Mst_User.Email, tsk.Description, deskripsi); } else { tsk.ActionDesc = "Revise"; tsk.Description = data.FullName + " ask for revision from your commitment plan for " + periodecek; string linknya = "http://localhost:53400/Task/TrxCommPlanEdit/" + tsk.TaskId; string deskripsi = "Hi, " + task.Mst_User.FullName + "<br><br>" + tsk.Description + "<br><br>Komentar : " + komentar + "<br>" + "<a href=" + linknya + "><br>Click Here to Review</a><br><p>Regards</p><p>e-PRMS Admin</p>"; tsk.IsAction = false; string role = task.Mst_User.Mst_Role.RoleName; if (role != "Head of PMO" && role != "Head of Delivery") { string subject_atasan = data.FullName + " ask for Revision from Commitment Plan of " + task.Mst_User.FullName + " for Periode " + periode; string body_atasan = "Hi, " + tsfo.FullName + "<br><br>" + subject_atasan + "<a href=" + linknya + "><br><br>Click Here to Review</a><br><p>Regards</p><p>e-PRMS Admin</p>"; kirim.Send(tsfo.Email, subject_atasan, body_atasan); } kirim.Send(task.Mst_User.Email, tsk.Description, deskripsi); } if (apprev != 0) { var edit = db.Tbl_Tasks.OrderByDescending(ts => ts.Id).Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Approve" || ts.ActionDesc == "Submit" && ts.Periode == periode && ts.IsAction == false).FirstOrDefault(); edit.IsAction = true; db.SaveChanges(); } db.Tbl_Tasks.Add(tsk); db.SaveChanges(); } if (level == "PMO" || level == "Team Leader") { /*--------------------------------------------------------FOR PMO/TEAM LEAD--------------------------------------------------------*/ tsk.TaskId = taskid; tsk.TaskName = "Commitment Plan"; tsk.TaskMaker = usrid; tsk.Periode = periode; if (aksi == 1) { tsk.TaskFor = managementid; tsk.ActionDesc = "Approve"; string subject_user = "******" + data.FullName; tsk.Description = data.FullName + " forwarded commitment plan from " + task.Mst_User.FullName + " for " + periode; string linknya = "http://localhost:53400/Task/TrxCommPlan/" + tsk.TaskId; string deskripsi_user = "******" + task.Mst_User.FullName + "<br><br>" + subject_user + "<br><br>Komentar : " + komentar + "<br>" + "<a href=" + linknya + "><br>Click Here to Review</a><br><p>Regards</p><p>e-PRMS Admin</p>"; tsk.IsAction = false; string subject_management = tsk.Description; string isi_email_manager = "Hi, " + management.FullName + "<br><br>" + subject_management + "<a href=" + linknya + "><br><br>Click Here to Review</a><br><p>Regards</p><p>e-PRMS Admin</p>"; kirim.Send(management.Email, subject_management, isi_email_manager); kirim.Send(task.Mst_User.Email, subject_user, deskripsi_user); } else { tsk.TaskFor = task.Mst_User.UserId; tsk.ActionDesc = "Revise"; tsk.Description = data.FullName + " ask for revision from your commitment plan for " + periodecek; tsk.IsAction = false; string linknya = "http://localhost:53400/Task/TrxCommPlanEdit/" + tsk.TaskId; string deskripsi = "Hi, " + task.Mst_User.FullName + "<br><br>" + tsk.Description + "<br><br>Komentar : " + komentar + "<br>" + "<a href=" + linknya + "><br>Click Here to Review</a><br><p>Regards</p><p>e-PRMS Admin</p>"; kirim.Send(task.Mst_User.Email, tsk.Description, deskripsi); } db.Tbl_Tasks.Add(tsk); db.SaveChanges(); if (apprev != 0) { var edit = db.Tbl_Tasks.Where(ts => ts.TaskId == taskid && ts.ActionDesc == "Submit" && ts.Periode == periode && ts.IsAction == false || ts.TaskId == taskid && ts.ActionDesc == "Revise" && ts.Periode == periode && ts.IsAction == false || ts.TaskId == taskid && ts.ActionDesc == "Save" && ts.Periode == periode && ts.IsAction == false).FirstOrDefault(); edit.IsAction = true; db.SaveChanges(); } } comment.TaskId = taskid; comment.CommentMaker = userid; comment.CommentText = komentar; comment.Action = tsk.ActionDesc; db.Tbl_Comments.Add(comment); db.SaveChanges(); return(RedirectToAction("Index", "Task")); }
public ActionResult Create(Request_Ticket req) { try { Request_Ticket tiket = new Request_Ticket(); int hitung = db.Tbl_Tasks.Count(); int userid = Convert.ToInt32(Session["loginuserid"]); tiket.UserId = userid; tiket.Reason = req.Reason; tiket.Date = DateTime.Now.Date; tiket.RequestType = req.RequestType; if (hitung != 0) { tiket.TaskId = db.Tbl_Tasks.Max(ax => ax.TaskId) + 1; } else { tiket.TaskId = 1; } //return Json(tiket, JsonRequestBehavior.AllowGet); db.Request_Tickets.Add(tiket); db.SaveChanges(); var user = db.Mst_Users.Include(rl => rl.Mst_Role).Where(rl => rl.Mst_Role.RoleName == "Admin").FirstOrDefault(); var loginuser = db.Mst_Users.Where(us => us.UserId == userid).FirstOrDefault(); string cekperiode = CekPeriode.CheckPeriode(); Tbl_Task tsk = new Tbl_Task(); tsk.TaskId = tiket.TaskId; tsk.TaskMaker = userid; tsk.TaskFor = user.UserId; tsk.ActionDesc = "Request"; tsk.IsAction = false; if (req.RequestType == "Commitment Plan") { tsk.Description = loginuser.FullName + " has request Commitment Plan ticket for Periode " + cekperiode; tsk.TaskName = "Commitment Plan"; } else { tsk.Description = loginuser.FullName + " has request Performance Review ticket for Periode " + cekperiode; tsk.TaskName = "Performance Review"; } tsk.SubmitDate = DateTime.Now; tsk.Periode = cekperiode; db.Tbl_Tasks.Add(tsk); db.SaveChanges(); string tujuan = user.Email; string deskripsi = "Hi, " + user.FullName + "." + "<br>" + tsk.Description + "<br><br>" + "Reason :" + tiket.Reason + "<br><br>" + "<a href='http://localhost:53400/Request/Detail/" + tiket.TaskId + "'>Click here to take action</a>" + "<br><br>" + "Regards,<br>" + loginuser.FullName; string subjek = tsk.Description; send.Send(tujuan, subjek, deskripsi); return(RedirectToAction("Index", "Task")); } catch { return(View()); } }
public ActionResult Detail(int id, FormCollection collection) { try { string aksi = collection["aksi"]; //return Json(collection, JsonRequestBehavior.AllowGet); string cekperiode = CekPeriode.CheckPeriode(); var req = db.Request_Tickets.Where(rq => rq.TaskId == id).FirstOrDefault(); var user = db.Mst_Users.Include(rl => rl.Mst_Role).Where(rl => rl.Mst_Role.RoleName == "Admin").FirstOrDefault(); int userid = Convert.ToInt32(Session["loginuserid"]); var userreq = db.Mst_Users.Find(req.UserId); string request = req.RequestType; string komentar = collection["komentar"]; var edit = db.Mst_Users.Where(us => us.UserId == req.UserId).FirstOrDefault(); if (request == "Commitment Plan" && aksi == "Approve") { edit.CommPlanOpen = true; string tujuan = userreq.Email; string deskripsi = "Hi, " + userreq.FullName + "." + "<br>Your request to open commitment plan has been approved by admin." + "<br><br>" + "Comments :" + komentar + "<br><br>" + "Regards,<br>e-PRMS Admin"; string subjek = "Your Request to Open Commitment Plan Has Been Approved"; send.Send(tujuan, subjek, deskripsi); } else if (request == "Performance Review" && aksi == "Approve") { edit.PerfReviewOpen = true; string tujuan = userreq.Email; string deskripsi = "Hi, " + userreq.FullName + "." + "<br>Your request to open performance review has been approved by admin." + "<br><br>" + "Comments :" + komentar + "<br><br>" + "Regards,<br>e-PRMS Admin"; string subjek = "Your Request to Open Performance Review Has Been Approved"; send.Send(tujuan, subjek, deskripsi); } db.SaveChanges(); var task = db.Tbl_Tasks.Where(ts => ts.TaskMaker == edit.UserId && ts.Periode == cekperiode && ts.ActionDesc == "Request" && ts.IsAction == false && ts.TaskName == request).FirstOrDefault(); //return Json(user, JsonRequestBehavior.AllowGet); task.IsAction = true; db.SaveChanges(); Tbl_Comment komen = new Tbl_Comment(); komen.TaskId = req.TaskId; komen.CommentMaker = userid; komen.CommentText = komentar; komen.Action = aksi; db.Tbl_Comments.Add(komen); if (request == "Commitment Plan" && aksi == "Reject") { var editreject = db.Tbl_Tasks.Where(ts => ts.TaskId == req.TaskId).FirstOrDefault(); editreject.IsAction = true; string tujuan = userreq.Email; string deskripsi = "Hi, " + userreq.FullName + "." + "<br>Your request to open commitment plan has been rejected by admin." + "<br><br>" + "Comments :" + komentar + "<br><br>" + "Regards,<br>e-PRMS Admin"; string subjek = "Your Request to Open Commitment Plan Has Been Rejected"; send.Send(tujuan, subjek, deskripsi); } else if (request == "Performance Review" && aksi == "Reject") { var editreject = db.Tbl_Tasks.Where(ts => ts.TaskId == req.TaskId).FirstOrDefault(); editreject.IsAction = true; string tujuan = userreq.Email; string deskripsi = "Hi, " + userreq.FullName + "." + "<br>Your request to open performance review has been rejected by admin." + "<br><br>" + "Comments :" + komentar + "<br><br>" + "Regards,<br>e-PRMS Admin"; string subjek = "Your Request to Open Performance Review Has Been Rejected"; send.Send(tujuan, subjek, deskripsi); } db.SaveChanges(); return(RedirectToAction("Index", "Task")); } catch { return(View()); } }