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