//update timer
public JsonResult json_updateTaskProgress()
{
var pars = Request.Params;
int task_id = Convert.ToInt32(pars["task_id"]);
var curUser = Session["user"];
int person_id = Convert.ToInt32(((Themes.Models.user)curUser).person_id);
int task_person_id = this.getCurTaskPerson(task_id, person_id).First().task_person_id;
using (Themes.Models.prjEntities ctx = new Themes.Models.prjEntities())
{
var cur_task_person =
(
from tp in ctx.task_person
where tp.task_person_id == task_person_id
select tp
).First();
/* First check if there is any open timer then update end_timestamp else create new with open end_timestamp */
var q =
(
from tpt in ctx.tp_timer
where
tpt.task_person.task_person_id == task_person_id &&
tpt.task_person.user_task_status_id != 3 &&/*Not Finalized*/
tpt.end_stamp == null /*open timer*/
select tpt
);
if (q.Count() != 0)
{
q.First().end_stamp = DateTime.Now;
q.First().is_commited = true;
q.First().task_person.user_task_status_id = 2 /*Progressing*/;
ctx.SaveChanges();
}
else
{
var newTimer = new Themes.Models.tp_timer()
{
t_p_id = task_person_id,
start_stamp = DateTime.Now,
end_stamp = null,
is_commited = false
};
ctx.tp_timer.AddObject(newTimer);
ctx.SaveChanges();
}
}
//return back current timer status after operation
return(Json(new { result = this.getTaskPersontimerStat(task_id, person_id) }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Deprecated Method for adding a new object to the tp_timer EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddTotp_timer(tp_timer tp_timer)
{
base.AddObject("tp_timer", tp_timer);
}
/// <summary>
/// Create a new tp_timer object.
/// </summary>
/// <param name="t_p_t_id">Initial value of the t_p_t_id property.</param>
public static tp_timer Createtp_timer(global::System.Int32 t_p_t_id)
{
tp_timer tp_timer = new tp_timer();
tp_timer.t_p_t_id = t_p_t_id;
return tp_timer;
}
