public string SetCompStatus(int compID, string statusCode) { var msg = "Competency Deleted Successfully!"; using (var context = new SSITrainingEntities()) { try { context.sp_CACompetency_SetStatus(compID, statusCode); } catch (Exception ex) { msg = "Error Delete Competency. Please Contact IT with the following message: " + ex.Message; } } return(msg); }