public List <T> GetCartonsToDocketRePrint <T>(DocketRePrintModel model) where T : class
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[0].ToString(), Value = model.RequestNo.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[1].ToString(), Value = model.PrintedBy.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[2].ToString(), Value = model.RequestType.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[3].ToString(), Value = model.SerialNo.AsDbValue()
}
};
var result = _tcContext.Set <T>().FromSqlRaw(DocketStoredProcedure.SqlRePrint, parms.ToArray()).ToList();
if (result == null || result != null && result.Count == 0 && model.RequestType.ToLower() != RequestTypes.collection.ToString())
{
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = string.Empty,
Message = $"Unable to find docket by {model.RequestNo}"
}
});
}
return(result);
}
public bool DeleteDocketRePrint(DocketRePrintModel model)
{
List <SqlParameter> parms = new List <SqlParameter>
{
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[0].ToString(), Value = model.RequestNo.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[1].ToString(), Value = model.PrintedBy.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[2].ToString(), Value = model.RequestType.AsDbValue()
},
new SqlParameter {
ParameterName = DocketStoredProcedure.StoredProcedureParameters[3].ToString(), Value = model.SerialNo.AsDbValue()
}
};
var result = _tcContext.Set <BoolReturn>().FromSqlRaw(DocketStoredProcedure.SqlRePrintDelete, parms.ToArray()).AsEnumerable().First().Value;
if (result == false)
{
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = string.Empty,
Message = $"Unable to delete docket by {model.RequestNo} - {model.SerialNo}"
}
});
}
return(result);
}
public async Task <ActionResult> GetDocketRePrint(int serialNo, string requestNo, string requestType, string printedBy)
{
DocketRePrintModel model = new DocketRePrintModel()
{
SerialNo = serialNo, RequestNo = requestNo, RequestType = requestType, PrintedBy = printedBy
};
return(Ok(_docketPrintRepository.GetDocketRePrint(model)));
}
public object GetDocketRePrint(DocketRePrintModel model)
{
var authorizedDocket = SearchDockets("Printed", model.RequestNo, 1, 1);
if (authorizedDocket == null || authorizedDocket != null && authorizedDocket.Data.Count() == 0)
{
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = string.Empty,
Message = $"Unable to view docket by {model.RequestNo} - {model.SerialNo}"
}
});
}
var headerResult = _mapper.Map <DocketPrintResultModel>(_tcContext.ViewRequestSummaries.Where(x => x.RequestNo == model.RequestNo).FirstOrDefault());
if (headerResult == null)
{
throw new ServiceException(new ErrorMessage[]
{
new ErrorMessage()
{
Code = string.Empty,
Message = $"Unable to find docket by {model.RequestNo} - {model.SerialNo}"
}
});
}
if (model.RequestType.ToLower() == RequestTypes.empty.ToString())
{
headerResult.EmptyList = GetCartonsToDocketRePrint <DocketPrintEmptyDetailModel>(model);
}
else
{
headerResult.CartonList = GetCartonsToDocketRePrint <DocketPrintDetailModel>(model);
}
headerResult.SerialNo = (int)model.SerialNo;
return(headerResult);
}
public ActionResult DeleteRePrintedDockets(DocketRePrintModel model)
{
return(Ok(_docketPrintRepository.DeleteDocketRePrint(model)));
}
