public JsonResult CancelSignOff(long?id)
{
object s = new { type = "failed", message = "Saving failed!" };
if (id == null)
{
return(Json(s, JsonRequestBehavior.AllowGet));
}
try
{
OSC_TeamScorecard_Current ts = db.TeamScorecards.Find(id);
if (ModelState.IsValid)
{
ts.ManagerSignOff = "";
ts.SignOffDate = null;
ts.SignOffBy = null;
ts.IsSignedOff = false;
db.Entry(ts).State = EntityState.Modified;
db.SaveChanges();
}
s = new { type = "success", message = "Sign-off cancelled!" };
}
catch (Exception ex)
{
s = new { type = "failed", message = "Saving failed!\nError occured:\n" + ex.Message.ToString() };
}
return(Json(s, JsonRequestBehavior.AllowGet));
}
public JsonResult SignOff(long?id, string comment)
{
object s = new { type = "failed", message = "Saving failed!" };
if (id == null)
{
return(Json(s, JsonRequestBehavior.AllowGet));
}
try
{
OSC_TeamScorecard_Current ts = db.TeamScorecards.Find(id);
if (ModelState.IsValid)
{
ts.ManagerSignOff = comment;
ts.SignOffDate = DateTime.Now;
ts.SignOffBy = (string)Session["logon_user"];
ts.IsSignedOff = true;
db.Entry(ts).State = EntityState.Modified;
db.SaveChanges();
}
s = new { type = "success", message = "Successfully signed-off!" };
}
catch (Exception ex)
{
s = new { type = "failed", message = "Saving failed!\nError occured:\n" + ex.Message.ToString() };
}
return(Json(s, JsonRequestBehavior.AllowGet));
}
public PartialViewResult ManagerSignoff()
{
long teamId;
int month, year;
teamId = (long)Session["TS_Team"];
month = (int)Session["TS_Month"];
year = (int)Session["TS_Year"];
ViewBag.Month = db.months.Where(m => m.Value == Convert.ToString(month)).First().Text;
ViewBag.Year = year;
OSC_TeamScorecard_Current obj = db.TeamScorecards.Where(t => t.TeamId == teamId && t.Month == month && t.Year == year).FirstOrDefault();
ViewBag.Id = obj.TeamScorecardId;
if (obj.IsSignedOff)
{
ViewBag.ManagerSignOff = obj.ManagerSignOff;
ViewBag.SignOffDate = obj.SignOffDate;
ViewBag.SignOffBy = obj.SignOffBy;
ViewBag.IsSignedOff = obj.IsSignedOff;
}
else
{
ViewBag.ManagerSignOff = "";
ViewBag.SignOffDate = DateTime.Now;
ViewBag.SignOffBy = (string)Session["logon_user"];
ViewBag.IsSignedOff = obj.IsSignedOff;
}
return(PartialView());
}
public JsonResult SaveStatusSummaryComment(long?id, string comment)
{
object s = new { type = "failed", message = "Saving failed!" };
if (id == null)
{
return(Json(s, JsonRequestBehavior.AllowGet));
}
try
{
OSC_TeamScorecard_Current ts = db.TeamScorecards.Find(id);
if (ModelState.IsValid)
{
ts.StatusSummaryComments = comment;
db.Entry(ts).State = EntityState.Modified;
db.SaveChanges();
}
s = new { type = "success", message = "Successfully saved!" };
}
catch (Exception ex)
{
s = new { type = "failed", message = "Saving failed!\nError occured:\n" + ex.Message.ToString() };
}
return(Json(s, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveTeamGoals(long?id, List <OSC_TeamScorecard_Current> objects)
{
object s = new { type = "failed", message = "Saving failed!" };
if (id == null)
{
return(Json(s, JsonRequestBehavior.AllowGet));
}
try
{
foreach (OSC_TeamScorecard_Current obj in objects)
{
if (ModelState.IsValid)
{
OSC_TeamScorecard_Current ts = db.TeamScorecards.Find(obj.TeamScorecardId);
ts.ProductivityGoal = obj.ProductivityGoal;
ts.QualityGoal = obj.QualityGoal;
ts.EfficiencyGoal = obj.EfficiencyGoal;
ts.UtilizationGoal = obj.UtilizationGoal;
db.Entry(ts).State = EntityState.Modified;
db.SaveChanges();
}
}
s = new { type = "success", message = "Successfully saved!" };
}
catch (Exception ex)
{
s = new { type = "failed", message = "Saving failed!\nError occured:\n" + ex.Message.ToString() };
}
return(Json(s, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAppendixList()
{
long teamId;
int month, year;
teamId = (long)Session["TS_Team"];
month = (int)Session["TS_Month"];
year = (int)Session["TS_Year"];
OSC_TeamScorecard_Current obj = db.TeamScorecards.Where(t => t.TeamId == teamId && t.Month == month && t.Year == year).FirstOrDefault();
var result = db.Appendix.Where(t => t.TeamScorecardId == obj.TeamScorecardId).ToList();
return(Json(result, JsonRequestBehavior.AllowGet));
}
public PartialViewResult Appendix()
{
long teamId;
int month, year;
teamId = (long)Session["TS_Team"];
month = (int)Session["TS_Month"];
year = (int)Session["TS_Year"];
ViewBag.Month = db.months.Where(m => m.Value == Convert.ToString(month)).First().Text;
ViewBag.Year = year;
OSC_TeamScorecard_Current obj = db.TeamScorecards.Where(t => t.TeamId == teamId && t.Month == month && t.Year == year).FirstOrDefault();
ViewBag.Id = obj.TeamScorecardId;
return(PartialView());
}
