public ActionResult DownloadDelete(int trxid) { Trx_Comm_Plan trz = db.Trx_Comm_Plans.Find(trxid); string jeneng = trz.File; string actualPath = Server.MapPath("~/Files/") + jeneng; if (System.IO.File.Exists(actualPath)) { System.IO.File.Delete(actualPath); } trz.File = ""; db.Entry(trz).State = EntityState.Modified; db.SaveChanges(); return(Content("Success")); }
public ActionResult commplan(FormCollection form) { //var task = db.Tbl_Tasks.Max(ax => ax.TaskId)+1; int usrid = Convert.ToInt32(Session["loginuserid"]); var data = db.Mst_Users.Include(rl => rl.Mst_Role).Where(ui => ui.UserId == usrid).Single(); var tsfo = db.Mst_Users.Where(us => us.UserId == data.DirectReportId).Single(); string penerima = tsfo.Email; Tbl_Task tsk = new Tbl_Task(); string ActionDesc; int kondisi = db.Tbl_Tasks.Count(); string periode = form["periode"]; tsk.Periode = periode; tsk.TaskName = "Commitment Plan"; int reportid = Convert.ToInt32(data.DirectReportId); tsk.TaskFor = reportid; tsk.TaskMaker = data.UserId; int cek = Convert.ToInt32(form["check"]); if (cek == 1) { ActionDesc = "Save"; tsk.Description = data.FullName + " has saved Commitment Plan for Periode " + periode; tsk.IsAction = false; } else { ActionDesc = "Submit"; tsk.Description = data.FullName + " has submitted Commitment Plan for Periode " + periode; tsk.IsAction = false; } tsk.ActionDesc = ActionDesc; if (kondisi == null || kondisi == 0) { tskawal = 1; } else { tskawal = db.Tbl_Tasks.Max(ax => ax.TaskId) + 1; } tsk.TaskId = tskawal; tsk.SubmitDate = DateTime.Now.Date; string linknya = "http://localhost:53400/Task/TrxCommPlan/" + tsk.TaskId; string deskripsi = "hi, " + tsfo.FullName + "<br>" + tsk.Description + "<a href=" + linknya + "><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); db.Tbl_Tasks.Add(tsk); db.SaveChanges(); //DateTime submitDate = DateTime.Now.Date; int i = 0; for (i = 0; i <= form.Count; i++) { string hitung = i.ToString(); if (form["detail_" + hitung] != null) { 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]; 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 = tskawal; trx.CommPlanid = Convert.ToInt16(com); trx.DescriptionPlan = dtku; trx.IsAchievable = hasil; trx.SubmitBy = usrid; trx.Periode = periode; trx.File = a; //trx.SubmitDate = submitDate; db.Trx_Comm_Plans.Add(trx); db.SaveChanges(); } } return(RedirectToAction("Index", "Task")); //return Json(form, JsonRequestBehavior.AllowGet); }
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); }