public JsonResult GetWOAppointmentPossionDetailsByApptId(int ApptId)
 {
     System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
     System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
     log.Debug("Start: " + methodBase.Name);
     try
     {
         var result = new AppoinmentofficersInfo();
         int checkSession = UserLogin.AuthenticateRequest();
         if (checkSession == 0)
         {
             return Json(checkSession);
         }
         else
         {
             result = Appoinmentofficers.GetWOApptOfficersPossionDetails(ApptId);
         }
         return Json(result.DirectorsList);
     }
     catch (Exception ex)
     {
         log.Error("Error: " + ex);
         return Json("");
     }
     finally
     {
         log.Debug("End: " + methodBase.Name);
     }
 }
        /// <summary>
        /// Created By   : Sudheer
        /// Created Date : 21 Nov 2014
        /// Modified By  :
        /// Modified Date:
        /// Description  : Get Cessionofficers Details by WOID
        /// </summary>
        /// <returns></returns>
        public static AppoinmentofficersInfo GetWOApptOfficersPossionDetails(int ApptId)
        {
            var GetWOCessionData = new AppoinmentofficersInfo();

            System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
            System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
            log.Debug("Start: " + methodBase.Name);
            try
            {
                SqlParameter[] sqlParams = new SqlParameter[1];
                sqlParams[0] = new SqlParameter("@ApptId", ApptId);
                var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SpGetAppointmentOfficerPossionDetails", sqlParams);
                var safe = new SafeDataReader(reader);
                while (reader.Read())
                {
                    var Details = new Appoinmentofficers();
                    Details.FetchPositionDetails(Details, safe);
                    GetWOCessionData.DirectorsList.Add(Details);
                }
                return GetWOCessionData;
            }
            catch (Exception ex)
            {
                log.Error("Error: " + ex);
                return GetWOCessionData;
            }
            finally
            {
                log.Debug("End: " + methodBase.Name);
            }
        }