Ejemplos de SSITrainingEntities.sp_CACompetency_GetAllEmployeeCompetencies en C# (CSharp)

Ejemplo n.º 1

        public string GetAllEmployeeCompetencies(int EmployeeID)
        {
            var jsonSerialiser = new JavaScriptSerializer();

            try {
                using (var db = new SSITrainingEntities())
                {
                    var snapshotEmployees = db.sp_CACompetency_GetAllEmployeeCompetencies(EmployeeID).ToList();

                    var json = jsonSerialiser.Serialize(snapshotEmployees);
                    return(json);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                return("");
            }
        }