public List <SupplierListOutModel> GetSupplierList(SupplierListInModel paramIn) { if (paramIn != null) { List <SupplierListOutModel> supp_lst = new List <SupplierListOutModel>(); SupplierExt supplier_ext = new SupplierExt(); supp_lst = supplier_ext.ext_GetSupplierList(paramIn); } return(null); }
public HttpResponseMessage ListSupplier(HttpRequestMessage request, SupplierListInModel paramIn) { if (ModelState.IsValid) { ISupplierServices _supplierService = new SupplierServices(); var suppliers_rslt = _supplierService.GetSupplierList(paramIn); if (suppliers_rslt != null) { return(request.CreateResponse(HttpStatusCode.OK, suppliers_rslt)); } return(Request.CreateResponse(HttpStatusCode.NotFound, "No data")); } return(Request.CreateResponse(HttpStatusCode.NotAcceptable, "Model Binding Error")); }
public List <SupplierListOutModel> ext_GetSupplierList(SupplierListInModel paramIn) { List <SupplierListOutModel> suppliersLst = new List <SupplierListOutModel>(); suppliersLst = null; var datacontext = new BillingAppEntities(); SqlParameter[] procedureParameters = new SqlParameter[] { new SqlParameter { ParameterName = "@shopID", Value = paramIn.ShopID == null? (object)DBNull.Value: paramIn.ShopID }, new SqlParameter { ParameterName = "@searchSupplierName", Value = string.IsNullOrEmpty(paramIn.SearchSupplierName) ? (Object)DBNull.Value : paramIn.SearchSupplierName }, new SqlParameter { ParameterName = "@pageNo", Value = paramIn.pagination.CurrentPage == null? (Object)DBNull.Value: paramIn.pagination.CurrentPage }, new SqlParameter { ParameterName = "@recordsPerPage", Value = paramIn.pagination.RecordsPerPage == null? (object)DBNull.Value: paramIn.pagination.RecordsPerPage }, new SqlParameter { ParameterName = "@purchaseDate", Value = paramIn.PurchaseDate == DateTime.MinValue || paramIn.PurchaseDate == null ? (object)DBNull.Value : paramIn.PurchaseDate }, new SqlParameter { ParameterName = "@purchaseAmount", Value = paramIn.purchaseAmount == null ? (Object)DBNull.Value : paramIn.purchaseAmount } }; suppliersLst = datacontext.Database.SqlQuery <SupplierListOutModel>("exec usp_list_suppliers @shopID, @searchSupplierName, @pageNo, @recordsPerPage, @purchaseDate, @purchaseAmount", procedureParameters).ToList(); if (suppliersLst != null) { return(suppliersLst); } return(null); }