private void SaveComments(int id, int commentby, string comment, string action)
{
Tbl_Comment Tbl_Comment = new Tbl_Comment();
Tbl_Comment.TaskId = id;
Tbl_Comment.CommentMaker = commentby;
Tbl_Comment.CommentText = comment;
Tbl_Comment.Action = action;
db.Tbl_Comments.Add(Tbl_Comment);
db.SaveChanges();
}
// GET: AdminComment/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tbl_Comment cat = db.Tbl_Comment.Find(id);
db.Tbl_Comment.Remove(cat);
db.SaveChanges();
if (cat == null)
{
return(HttpNotFound());
}
return(RedirectToAction("Index"));
}
public ActionResult Comment(Tbl_Comment category)
{
try
{
if (ModelState.IsValid)
{
category.CommentDate = DateTime.Now;
category.BId = (int)Session["BId"];
category.BLogId = (int)(Session["ID"]);
db.Tbl_Comment.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// TODO: Add insert logic here
return(View(category));
}
catch
{
return(View());
}
}
public JsonResult SendComment(Tbl_Comment comment)
{
db.Tbl_Comment.Add(comment);
db.SaveChanges();
return(Json(new { result = true, message = "دیدگاه با موفقیت ثبت شد" }));
}
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 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());
}
}
