C# (CSharp) NHPApi.Models SAPAPIContext Examples

Example #1

File: BusinessPartnersController.cs Project: oriolaakeem/DIServerApi

 public JsonResult <List <OCRD> > Get()
 {
     using (var context = new NHPApi.Models.SAPAPIContext())
     {
         var ocrds = context.OCRDs.SqlQuery("SELECT * FROM OCRD").ToList();
         return(Json(ocrds));
     }
 }

Example #2

File: BusinessPartnersController.cs Project: oriolaakeem/DIServerApi

 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));
     }
 }