public JsonResult <List <OCRD> > Get()
{
using (var context = new NHPApi.Models.SAPAPIContext())
{
var ocrds = context.OCRDs.SqlQuery("SELECT * FROM OCRD").ToList();
return(Json(ocrds));
}
}
public JsonResult <List <CustomerVm> > GetCustomerByEmail(string email)
{
using (var context = new NHPApi.Models.SAPAPIContext())
{
var ocrds = context.OCRDs.SqlQuery("SELECT * FROM OCRD where E_Mail = '" + email + "' AND CardType= 'C' ").ToList();
var org = Mapper.Map <List <OCRD>, List <CustomerVm> >(ocrds);
return(Json(org));
}
}