public IHttpActionResult GetQuot_itemsList(Quotation_itemsSearch search)
{
AuthDetails authdet = LoginUserDetails();
var filters = new List <MySqlParameter>
{
datatableService.CreateSqlParameter("@pUserId", authdet.UserId, MySqlDbType.Int32)
};
var result = service.GetQuot_itemsList(search, filters);
return(Ok(result));
}
public DataTable <Quotation_itemsDatatable> GetQuot_itemsList(Quotation_itemsSearch search, List <MySqlParameter> filters)
{
try
{
using (var ctx = new AppDb())
{
var result = datatableService.GetDataTableResult <Quotation_itemsDatatable>("quotation_items_sp", search, filters);
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
