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