public HttpResponseMessage UpdateProcedureResult(String id, Entities.TrnProcedureResult objProcedureResult)
        {
            try
            {
                var currentUser = from d in db.MstUsers
                                  where d.AspNetUserId == User.Identity.GetUserId()
                                  select d;

                var currentUserId     = currentUser.FirstOrDefault().Id;
                var currentUserTypeId = currentUser.FirstOrDefault().UserTypeId;

                if (currentUserTypeId == 2)
                {
                    var procedureResult = from d in db.TrnProcedureResults
                                          where d.Id == Convert.ToInt32(id)
                                          select d;

                    if (procedureResult.Any())
                    {
                        var updateProcedureResult = procedureResult.FirstOrDefault();
                        updateProcedureResult.ProcedureId         = objProcedureResult.ProcedureId;
                        updateProcedureResult.ModalityProcedureId = objProcedureResult.ModalityProcedureId;
                        updateProcedureResult.Result         = objProcedureResult.Result;
                        updateProcedureResult.DoctorId       = currentUserId;
                        updateProcedureResult.DoctorDateTime = DateTime.Now;

                        db.SubmitChanges();

                        return(Request.CreateResponse(HttpStatusCode.OK));
                    }
                    else
                    {
                        return(Request.CreateResponse(HttpStatusCode.NotFound));
                    }
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest));
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError));
            }
        }
        public HttpResponseMessage AddProcedureResult(Entities.TrnProcedureResult objProcedureResult)
        {
            try
            {
                var currentUser = from d in db.MstUsers
                                  where d.AspNetUserId == User.Identity.GetUserId()
                                  select d;

                var currentUserId     = currentUser.FirstOrDefault().Id;
                var currentUserTypeId = currentUser.FirstOrDefault().UserTypeId;

                if (currentUserTypeId == 2)
                {
                    Data.TrnProcedureResult newProcedureResult = new Data.TrnProcedureResult
                    {
                        ProcedureId         = objProcedureResult.ProcedureId,
                        ModalityProcedureId = objProcedureResult.ModalityProcedureId,
                        Result         = objProcedureResult.Result,
                        DoctorId       = currentUserId,
                        DoctorDateTime = DateTime.Now
                    };

                    db.TrnProcedureResults.InsertOnSubmit(newProcedureResult);
                    db.SubmitChanges();

                    return(Request.CreateResponse(HttpStatusCode.OK));
                }
                else
                {
                    return(Request.CreateResponse(HttpStatusCode.BadRequest));
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(Request.CreateResponse(HttpStatusCode.InternalServerError));
            }
        }