public IActionResult GetByNhoodAndType(uint nhoodId, DbBulletinType bulletinType)
{
var api = Api.INSTANCE;
using (var da = api.DAFactory.Get())
{
var bulletins = da.BulletinPosts.GetByNhoodId(nhoodId, 0).Where(x => x.type == bulletinType);
if (bulletins == null)
{
return(ApiResponse.Json(HttpStatusCode.NotFound, new JSONBulletinError("Bulletins not found")));
}
List <JSONBulletin> bulletinJson = new List <JSONBulletin>();
foreach (var bulletin in bulletins)
{
bulletinJson.Add(new JSONBulletin
{
bulletin_id = bulletin.bulletin_id,
neighborhood_id = bulletin.neighborhood_id,
avatar_id = bulletin.avatar_id,
title = bulletin.title,
body = bulletin.body,
date = bulletin.date,
flags = bulletin.flags,
lot_id = bulletin.lot_id,
type = bulletin.type
});
}
var bulletinsJson = new JSONBulletins();
bulletinsJson.bulletins = bulletinJson;
return(ApiResponse.Json(HttpStatusCode.OK, bulletinsJson));
}
}
public bool SetTypeFlag(uint bulletin_id, DbBulletinType type, int flags)
{
return(Context.Connection.Execute("UPDATE fso_bulletin_posts SET flags = @flags, type = @type WHERE bulletin_id = @bulletin_id",
new { bulletin_id, type = type.ToString(), flags }) > 0);
}
