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);
}
}
