public async Task <IQueryable <vwRequisitionModel> > searchRequisition(filterRequisition objFilter)
{
try
{
string sql = string.Format("exec req_search {0} , {1} , '{2}' ,'{3}' ,'{4}','{5}' , {6} "
, objFilter.requisition_id == null ? "null" : objFilter.requisition_id.ToString()
, objFilter.route_id == null ? "null" : objFilter.route_id.ToString()
, objFilter.route_name
, objFilter.document_date == null
? ""
: string.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(objFilter.document_date))
, objFilter.requisition_type
, objFilter.status
, objFilter.round == null ? "null" : objFilter.round.ToString()
);
RequisitionDataModel objData = new RequisitionDataModel();
return(UnitOfWork.Context.Query <vwRequisitionModel>().FromSql(sql));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
}
public async Task <RequisitionDataModel> getAll(filterRequisition objFilter)
{
try
{
string sql = string.Format("exec stk_trn_search {0} , '{1}' , {2} ",
objFilter.requisition_id == null ? "null" : objFilter.requisition_id.ToString(),
objFilter.product_name, objFilter.route_id == null ? "null" : objFilter.route_id.ToString());
int i = Convert.ToInt32(objFilter.requisition_id ?? 0);
RequisitionDataModel objData = new RequisitionDataModel();
objData._master = UnitOfWork.Context.Set <RequisitionModel>().Where(w => w.requisition_id.Equals(i))
.FirstOrDefault();
objData._lstProducts = UnitOfWork.Context.Set <RequisitionProductModel>()
.Where(w => w.requisition_id.Equals(i)).ToList();
objData._lstPackages = UnitOfWork.Context.Set <RequisitionPackageModel>()
.Where(w => w.requisition_id.Equals(i)).ToList();
return(objData);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
}
public async Task <IActionResult> GetSearchRequisitionPackage([FromBody] filterRequisition objFilter)
{
try
{
return(Ok(_objModule.searchRequisitionPackage(objFilter)));
}
catch (Exception e)
{
return(BadRequest(e.Message.ConvertExceptionToErrorInfo()));
}
}
public async Task <IActionResult> GetView(int id)
{
try
{
filterRequisition objFilter = new filterRequisition();
objFilter.product_id = id;
return(Ok(await _objModule.getAll(objFilter)));
}
catch (Exception e)
{
return(BadRequest(e.Message.ConvertExceptionToErrorInfo()));
}
}
public async Task <IQueryable <vwRequisitionPackageModel> > searchRequisitionPackage(filterRequisition objFilter)
{
try
{
string sql = string.Format("exec req_search_package {0} , '{1}'"
, objFilter.requisition_id == null ? "null" : objFilter.requisition_id.ToString()
, objFilter.status
);
return(UnitOfWork.Context.Query <vwRequisitionPackageModel>().FromSql(sql));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
}
}