public HttpResponseMessage getObject(DTOGetObjectRequest request)
{
using (var db = new CRMEntities())
{
var filter = request.getFilter();
var querySql = filter.getFilterSQL();
var res = new List <idName>();
if (filter.tableName == "block")
{
res.AddRange(db.block.SqlQuery(querySql).Select(b => new idName {
id = b.blockid, name = b.blockname
}));
}
else if (filter.tableName == "site")
{
res.AddRange(db.site.SqlQuery(querySql).Select(s => new idName {
id = s.siteid, name = s.sitename
}));
}
else if (filter.tableName == "customer")
{
res.AddRange(db.customer.SqlQuery(querySql).Select(c => new idName {
id = c.customerid, name = $"{c.customername} {c.customersurname}"
}).Take(10));
}
else
{
res.AddRange(db.personel.SqlQuery(querySql).Select(p => new idName {
id = p.personelid, name = p.personelname
}));
}
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()), "application/json"));
}
}
public HttpResponseMessage getObject(DTOGetObjectRequest request)
{
using (var db = new KOCSAMADLSEntities())
{
var filter = request.getFilter();
var querySql = filter.getFilterSQL();
var res = new List <idName>();
res.AddRange(db.personel.SqlQuery(querySql).Select(p => new idName {
id = p.personelid, name = p.personelname
}));
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(r => r.toDTO()), "application/json"));
}
}
