public async Task <IActionResult> GetSearch([FromBody] filterIceBucket objFilter)
{
try
{
return(Ok(_objModule.search(objFilter)));
}
catch (Exception e)
{
return(BadRequest(e.Message.ConvertExceptionToErrorInfo()));
}
}
public async Task <IActionResult> GetView(int id)
{
try
{
filterIceBucket objFilter = new filterIceBucket();
objFilter.bucketID = id;
return(Ok(await _objModule.getAll(objFilter)));
}
catch (Exception e)
{
return(BadRequest(e.Message.ConvertExceptionToErrorInfo()));
}
}
public async Task <IQueryable <vwIceBucketModel> > search(filterIceBucket objFilter)
{
try
{
string sql = string.Format("exec icebucket_search {0} , N'{1}' , {2} ,{3}, '{4}' "
, objFilter.bucketID == null ? "null" : objFilter.bucketID.ToString()
, objFilter.bucket_no
, objFilter.route_id == null ? "null" : objFilter.route_id.ToString()
, objFilter.customer_id == null ? "null" : objFilter.customer_id.ToString()
, objFilter.status
);
return(UnitOfWork.Context.Query <vwIceBucketModel>().FromSql(sql));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
}
public async Task <IQueryable <IceBucketModel> > getAll(filterIceBucket objFilter)
{
try
{
string sql = string.Format("exec stk_trn_search {0} , '{1}' , {2} ", objFilter.bucketID == null ? "null" : objFilter.bucketID.ToString(), objFilter.route_name, objFilter.route_id == null ? "null" : objFilter.route_id.ToString());
int i = Convert.ToInt32(objFilter.bucketID ?? 0);
//IceBucketModel objData = new IceBucketModel();
var objData = UnitOfWork.Context.Set <IceBucketModel>().Where(w => w.bucketID.Equals(i));
//objData._lstProducts = UnitOfWork.Context.Set<IceBucketModel>().Where(w => w.id.Equals(i)).ToList();
//objData._lstPackages = UnitOfWork.Context.Set<IceBucketModel>().Where(w => w.id.Equals(i)).ToList();
return(objData);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
}
