public async Task <HttpResponseMessage> Remove(int cOBiodataID)
{
var context = new tblPRCOBiodataAdapter();
await context.DeleteAsync(cOBiodataID);
var response = Request.CreateResponse(HttpStatusCode.Accepted, new { success = true, status = "OK" });
return(response);
}
public async Task <object> Get(int cOBiodataID)
{
var context = new tblPRCOBiodataAdapter();
var item = await context.LoadOneAsync(cOBiodataID);
if (null == item)
{
return new { success = false, status = "NotFound", statusCode = 404, url = "/api/docs/404", message = "item not found" }
}
;
return(new { success = true, status = "OK", item });
}
public async Task <object> List(string filter = null, int page = 1, int size = 40, bool includeTotal = false, string orderby = null)
{
if (size > 200)
{
throw new ArgumentException("Your are not allowed to do more than 200", "size");
}
var translator = new OdataSqlTranslator <tblPRCOBiodata>(null, "tblPRCOBiodata")
{
Schema = "dbo"
};
var sql = translator.Select(string.IsNullOrWhiteSpace(filter) ? "COBiodataID gt 0" : filter, orderby);
var count = 0;
var context = new tblPRCOBiodataAdapter();
var nextPageToken = string.Empty;
var lo = await context.LoadAsync(sql, page, size);
if (includeTotal || page > 1)
{
var translator2 = new OdataSqlTranslator <tblPRCOBiodata>(null, "tblPRCOBiodata")
{
Schema = "dbo"
};
var countSql = translator2.Count(filter);
count = await context.ExecuteScalarAsync <int>(countSql);
if (count >= lo.ItemCollection.Count())
{
nextPageToken = string.Format(
"/api/dbo/tblprcobiodata/?filter={0}&includeTotal=true&page={1}&size={2}", filter, page + 1, size);
}
}
string previousPageToken = string.Format("/api/dbo/tblprcobiodata/?filter={0}&includeTotal=true&page={1}&size={2}", filter, page - 1, size);
if (page == 1)
{
previousPageToken = null;
}
var json = new
{
count,
page,
nextPageToken,
previousPageToken,
size,
results = lo.ItemCollection.ToArray()
};
return(json);
}
public async Task <HttpResponseMessage> Insert([FromBody] tblPRCOBiodata item)
{
if (null == item)
{
throw new ArgumentNullException("item");
}
var context = new tblPRCOBiodataAdapter();
await context.InsertAsync(item);
var response = Request.CreateResponse(HttpStatusCode.Accepted, new { success = true, status = "OK", item });
return(response);
}
