public List <cust_mast> InquiryCustomerByText(CustomerAutoCompleteSearchView model)
{
using (var ctx = new ConXContext())
{
string sql = "select top 20 * from cust_mast";
if (model.type == "name")
{
sql += " where cust_name like @txt_name";
sql += " order by cust_name asc";
}
else
{
sql += " where tel like @txt_tel";
sql += " order by tel asc";
}
List <cust_mast> customer = ctx.Database.SqlQuery <cust_mast>(sql,
new SqlParameter("@txt_name", "%" + model.txt + "%"),
new SqlParameter("@txt_tel", "%" + model.txt + "%")
).ToList();
return(customer);
}
}
public HttpResponseMessage postInquiryCustomerByText(CustomerAutoCompleteSearchView model)
{
try
{
var res = customerService.InquiryCustomerByText(model);
return(Request.CreateResponse(HttpStatusCode.OK, res));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString()));
}
}