public async Task <IHttpActionResult> SelectChilds(string Tname, long parentId)
{
var meta = await db.META_BO.Where(x => x.BO_DB_NAME == Tname).FirstOrDefaultAsync();
if (meta == null)
{
return(BadRequest());
}
/* ACCESS RIGHTS */
try
{
UserRoleManager.Instance.VerifyRead(meta.BO_DB_NAME);
}
catch (UnauthorizedAccessException ex)
{
return(Content(HttpStatusCode.Forbidden, ex.Message));
}
/* FIN ACCESS RIGHTS */
var s = new SGBD();
var Gen = new BORepositoryGenerator();
var dt = s.Cmd(Gen.GenSelectChilds(meta.BO_DB_NAME, parentId));
return(Ok(dt));
}
public async Task <IHttpActionResult> GetOne(long id, long param)
{
var meta = await db.META_BO.FindAsync(id);
/* ACCESS RIGHTS */
try
{
UserRoleManager.Instance.VerifyRead(meta.BO_DB_NAME);
}
catch (UnauthorizedAccessException ex)
{
return(Content(HttpStatusCode.Forbidden, ex.Message));
}
/* FIN ACCESS RIGHTS */
var s = new SGBD();
var Gen = new BORepositoryGenerator();
Dictionary <string, object> bind = new Dictionary <string, object>();
bind.Add("BO_ID", param);
var dt = s.Cmd(Gen.GenSelectOne(meta.BO_DB_NAME), bind);
return(Ok(dt));
}
public async Task <IHttpActionResult> FilterIncludeSubForm(FilterModel model)
{
var meta = await db.META_BO.FindAsync(model.MetaBoID);
/* ACCESS RIGHTS */
try
{
UserRoleManager.Instance.VerifyRead(meta.BO_DB_NAME);
}
catch (UnauthorizedAccessException ex)
{
return(Content(HttpStatusCode.Forbidden, ex.Message));
}
/* FIN ACCESS RIGHTS */
if (meta == null)
{
return(BadRequest());
}
var s = new SGBD();
var Gen = new BORepositoryGenerator();
string reqSelect = Gen.GenSelectIncludeSubForm(meta, db.GetSubForm((int)meta.META_BO_ID).FirstOrDefault()) + " where 1=1 " + model.Format();
var dt = s.Cmd(reqSelect, model.mapping);
return(Ok(dt));
//return Ok();
}
public ActionResult Img(string bo, string field, string id)
{
var s = new SGBD();
var Gen = new BORepositoryGenerator();
var dt = s.Cmd(Gen.GenSelectFields(bo, new List <string> {
field
}, " where c.BO_ID=" + id));
ImageBase64 img = System.Web.Helpers.Json.Decode <ImageBase64>(dt.Rows[0][field].ToString());
return(base.File(Convert.FromBase64String(img.Base64.Split(new string[] { "base64," }, StringSplitOptions.None)[1]), "image/jpeg"));
}
