public IHttpActionResult ReviewerOwned(int approver_uni_key)
 {
     try
     {
         TransferActivityRepository ta = new TransferActivityRepository(db);
         return(Ok(ta.ItemsByReviewer(approver_uni_key)));
     }
     catch (Exception exError)
     {
         return(BadRequest((new Error(0, exError.Message, "ReviewerOwned").ToString())));
     }
 }
 public IHttpActionResult Item(int transfer_activity_key)
 {
     try
     {
         TransferActivityRepository ta = new TransferActivityRepository(db);
         return(Ok(ta.Item(transfer_activity_key)));
     }
     catch (Exception exError)
     {
         return(BadRequest((new Error(0, exError.Message, "GetItem").ToString())));
     }
 }
 public IHttpActionResult CreateItem(TransferActivityDTO transfer_activity)
 {
     try
     {
         TransferActivityRepository ta = new TransferActivityRepository(db);
         return(Ok(ta.Create(transfer_activity)));
     }
     catch (Exception exError)
     {
         return(BadRequest((new Error(0, exError.Message, "Create Item").ToString())));
     }
 }
        public IHttpActionResult UserAssignedApprovals(int transfer_activity_key, int uni_key)
        {
            try
            {
                TransferActivityRepository ta = new TransferActivityRepository(db);

                return(Ok(ta.GetUserAssignedApprovals(transfer_activity_key, uni_key)));
            }
            catch (Exception exError)
            {
                return(BadRequest((new Error(0, exError.Message, "InitializeApprovals").ToString())));
            }
        }
        public IHttpActionResult SetApprovals(int btr_key, int approval_level)
        {
            try
            {
                TransferActivityRepository ta = new TransferActivityRepository(db);
                ta.SetApprovalLevels(btr_key, approval_level);

                return(Ok());
            }
            catch (Exception exError)
            {
                return(BadRequest((new Error(0, exError.Message, "SetApprovals").ToString())));
            }
        }
        public IHttpActionResult GetCurrentApprovalLevel(int transfer_activity_key)
        {
            try
            {
                //IEnumerable<KeyValuePair<string, string>> queryString = Request.GetQueryNameValuePairs();

                //int transfer_activity_key = HttpUtils.QSIntValue(queryString, "transfer_activity_key");

                TransferActivityRepository ta = new TransferActivityRepository(db);

                return(Ok(ta.GetCurrentApprovalLevel(transfer_activity_key)));
            }
            catch (Exception exError)
            {
                return(BadRequest((new Error(0, exError.Message, "GetCurrentApprovalLevel").ToString())));
            }
        }
        public IHttpActionResult AssignReviewers()
        {
            try
            {
                IEnumerable <KeyValuePair <string, string> > queryString = Request.GetQueryNameValuePairs();

                int  transfer_activity_key = HttpUtils.QSIntValue(queryString, "transfer_activity_key");
                int  approval_level        = HttpUtils.QSIntValue(queryString, "approval_level");
                Guid workflow_guid         = HttpUtils.QSGuidValue(queryString, "workflow_guid");

                TransferActivityRepository ta = new TransferActivityRepository(db);

                return(Ok(ta.AssignReviewers(transfer_activity_key, approval_level, workflow_guid)));
            }
            catch (Exception exError)
            {
                return(BadRequest((new Error(0, exError.Message, "GetCurrentApprovalLevel").ToString())));
            }
        }
        public IHttpActionResult InitializeApprovals()
        {
            try
            {
                IEnumerable <KeyValuePair <string, string> > queryString = Request.GetQueryNameValuePairs();

                int btr_key        = HttpUtils.QSIntValue(queryString, "btr_key");
                int approval_level = HttpUtils.QSIntValue(queryString, "approval_level");

                TransferActivityRepository ta = new TransferActivityRepository(db);
                ta.SetApprovalLevels(btr_key, approval_level);

                return(Ok());
            }
            catch (Exception exError)
            {
                return(BadRequest((new Error(0, exError.Message, "InitializeApprovals").ToString())));
            }
        }
        public IHttpActionResult BatchSave(TransferActivityBatchDTO[] transferactivities)
        {
            TransferActivityRepository ta = new TransferActivityRepository(db);

            foreach (TransferActivityBatchDTO taItem in transferactivities)
            {
                switch (taItem.action.ToUpper())
                {
                case "CREATE":
                    ta.Create(taItem.transfer_activity);
                    break;

                case "UPDATE":
                    ta.Update(taItem.transfer_activity);
                    break;

                case "DELETE":
                    ta.Delete(taItem.transfer_activity.transfer_activity_key);
                    break;
                }
            }

            return(Ok());
        }