public JArray DetailsBook(int id) { var arr = new JArray(); SelectSP selBook = new SelectSP("BOOK_SP_SEL_DETAILS_BOOK"); selBook.addParam("ID", id); try { selBook.Executa(); if (selBook.sDataTable.Rows.Count == 0) { return(arr); } else { foreach (DataRow dr in selBook.sDataTable.Rows) { arr.Add(new JObject( new JProperty("BkId", dr.Field <int>("BK_ID")), new JProperty("BkName", dr.Field <string>("BK_NAME")), new JProperty("BkIndication", dr.Field <string>("BK_INDICATION")), new JProperty("BkSaga", dr.Field <string>("BK_SAGA")), new JProperty("BkDate", dr.Field <DateTime?>("BK_DATE_CREATE").ToString()), new JProperty("BkFlag", dr.Field <int>("BK_FLAG")), new JProperty("AutName", dr.Field <string>("AUT_NAME")), new JProperty("AutSaga", dr.Field <string>("AUT_MAIN_SAGA")), new JProperty("AutFavBook", dr.Field <string>("AUT_FAVORITE_BOOK")), new JProperty("GenName", dr.Field <string>("GEN_NAME")), new JProperty("GenDes", dr.Field <string>("GEN_DESCRIPTION")), new JProperty("BkrResume", dr.Field <string>("BKR_RESUME")), new JProperty("BkrDateStart", dr.Field <DateTime?>("BKR_DATESTART").ToString()), new JProperty("BkrDateEnd", dr.Field <DateTime?>("BKR_DATEEND").ToString()) )); } return(arr); } } catch (Exception ex) { return(arr); } }