public ResponseBase <DistrictListResponse> GetList()
{
ResponseBase <DistrictListResponse> response;
try
{
var query = _context.TBL_SLI_DISTRICT.Where(x => x.BIT_STATE == true).Select(x => new DistrictListResponse
{
INT_DISTRICTID = x.INT_DISTRICTID,
VCH_DISTRICTNAME = x.VCH_NAME,
VCH_PROVINCENAME = x.TBL_SLI_PROVINCE.VCH_NAME,
}).OrderBy(x => x.VCH_DISTRICTNAME);
response = new UtilityResponse <DistrictListResponse>().SetResponseBaseForList(query);
return(response);
}
catch (Exception ex)
{
response = new UtilityResponse <DistrictListResponse>().SetResponseBaseForException(ex);
return(response);
}
finally
{
response = null;
_context.Database.Connection.Close();
}
}
public ResponseBase <CityListResponse> GetList()
{
ResponseBase <CityListResponse> response;
try
{
var query = _context.TBL_SLI_CITY.Where(x => x.BIT_STATE == true).Select(x => new CityListResponse
{
INT_CITYID = x.INT_CITYID,
VCH_CITYNAME = x.VCH_NAME,
VCH_COUNTRYNAME = x.TBL_SLI_COUNTRY.VCH_NAME
}).OrderBy(x => x.VCH_COUNTRYNAME);
response = new UtilityResponse <CityListResponse>().SetResponseBaseForList(query);
return(response);
}
catch (Exception ex)
{
response = new UtilityResponse <CityListResponse>().SetResponseBaseForException(ex);
return(response);
}
finally
{
response = null;
_context.Database.Connection.Close();
}
}
public ResponseBase <ManifestResponse> FindData(ManifestRequest request)
{
ManifestValidator validator;
ValidationResult results;
ResponseBase <ManifestResponse> response;
ManifestResponse manifestResponse;
try
{
//throw new Exception("webeo");
validator = new ManifestValidator();
results = validator.Validate(request);
manifestResponse = new ManifestResponse();
if (results.IsValid)
{
var queryResult = _context.TBL_MAN_MANIFEST.Where(x =>
(x.VCH_DIRECTMASTERGUIDE == request.VCH_DIRECTMASTERGUIDE || request.VCH_DIRECTMASTERGUIDE == null) &&
(x.DAT_DEPARTUREDATE >= request.DAT_STARTDATE || request.DAT_STARTDATE == null) && (x.DAT_DEPARTUREDATE <= request.DAT_ENDDATE || request.DAT_ENDDATE == null) &&
(x.VCH_CONSIGNEE.Contains(request.VCH_CONSIGNEE) || request.VCH_CONSIGNEE == null) && (x.VCH_SHIPPER.Contains(request.VCH_SHIPPER) || request.VCH_SHIPPER == null) &&
(x.VCH_DESCRIPTION.Contains(request.VCH_DESCRIPTION) || request.VCH_DESCRIPTION == null) && (x.VCH_AIRLINE.Contains(request.VCH_AIRLINE) || request.VCH_AIRLINE == null) &&
(x.VCH_DESTINATION == request.VCH_DESTINATION || request.VCH_DESTINATION == null) &&
((x.DAT_DEPARTUREDATE.Value.Year == request.INT_YEAR && x.INT_WEEK >= request.INT_STARTWEEK && x.INT_WEEK <= request.INT_ENDWEEK) ||
(request.INT_YEAR == null || request.INT_STARTWEEK == null || request.INT_ENDWEEK == null))).OrderByDescending(x => x.DAT_DEPARTUREDATE);
int pageCount = queryResult.Count();
var listManifests = queryResult.Skip((request.INT_CURRENTPAGE - 1) * request.INT_LIMITPAGES).Take(request.INT_LIMITPAGES == 1000 ? pageCount : request.INT_LIMITPAGES).ToList();
manifestResponse.INT_TOTALREGISTERS = pageCount;
manifestResponse.INT_CURRENTPAGE = request.INT_CURRENTPAGE;
manifestResponse.Manifests = listManifests;
response = new UtilityResponse <ManifestResponse>().SetResponseBaseForObj(manifestResponse);
}
else
{
response = new UtilityResponse <ManifestResponse>().SetResponseBaseFunctionalErrors(results);
}
return(response);
}
catch (Exception ex)
{
response = new UtilityResponse <ManifestResponse>().SetResponseBaseForException(ex);
return(response);
}
finally
{
response = null;
validator = null;
results = null;
_context.Database.Connection.Close();
}
}
public ResponseBase <List <NotaResponse> > listarNotas(int?idAlumno)
{
ResponseBase <List <NotaResponse> > listResponse = new ResponseBase <List <NotaResponse> >();
List <NotaResponse> notaResponse = new List <NotaResponse>();
try
{
var queryUsuario = _Context.TBL_ALUMNO.Where(x => x.INT_ALUMNOID == idAlumno).Select(x => x.INT_ALUMNOID).FirstOrDefault();
if (queryUsuario != 0)
{
var queryResult = _Context.TBL_NOTA.
Join(_Context.TBL_CURSO, x => x.INT_CURSO_ID, y => y.INT_CURSOID, (x, y) => new { x, y }).
Join(_Context.TBL_ALUMNO, z => z.x.INT_ALUMNOID, zo => zo.INT_ALUMNOID, (z, zo) => new { z, zo }).
Where(a => (a.z.x.INT_ALUMNOID == idAlumno)
).OrderBy(x => x.z.x.INT_ALUMNOID).
Select(b => new NotaResponse
{
VCH_ALUMNO = b.zo.VCH_NOMBRE + " " + b.zo.VCH_APELLIDO_PAT + " " + b.zo.VCH_APELLIDO_MAT,
VCH_CURSO = b.z.y.VCH_NOMBRE,
DEC_NOTA = b.z.x.DEC_NOTA
});
if (queryResult.Count() > 0)
{
notaResponse = queryResult.ToList();
listResponse = new UtilityResponse <List <NotaResponse> >().SetResponseBaseForObj(notaResponse);
}
else
{
listResponse = new UtilityResponse <List <NotaResponse> >().SetResponseBaseForValidationNoteString(notaResponse);
}
}
else
{
listResponse = new UtilityResponse <List <NotaResponse> >().SetResponseBaseForValidationAlumnString(notaResponse);
}
}
catch (Exception ex)
{
listResponse = new UtilityResponse <List <NotaResponse> >().SetResponseBaseForException(ex);
}
return(listResponse);
}
public async Task <LiveTvServiceStatusInfo> GetStatusInfoAsync(CancellationToken cancellationToken)
{
EnsureSetup();
bool upgradeAvailable = false;
string serverVersion = string.Empty;
var conInfoTask = _httpClient.Get(GetOptions(cancellationToken, "/Myth/GetConnectionInfo")).ConfigureAwait(false);
var tunersTask = _httpClient.Get(GetOptions(cancellationToken, "/Dvr/GetEncoderList")).ConfigureAwait(false);
var encodersTask = _httpClient.Get(GetOptions(cancellationToken, "/Capture/GetCaptureCardList")).ConfigureAwait(false);
EncoderList tuners = null;
CaptureCardList encoders = null;
using (var stream = await tunersTask)
{
tuners = DvrResponse.ParseEncoderList(stream, _jsonSerializer, _logger);
}
using (var stream = await encodersTask)
{
encoders = CaptureResponse.ParseCaptureCardList(stream, _jsonSerializer, _logger);
}
using (var stream = await conInfoTask)
{
var conInfo = UtilityResponse.GetConnectionInfo(stream, _jsonSerializer, _logger);
serverVersion = conInfo.Version.Ver;
}
//Tuner information
List <LiveTvTunerInfo> tvTunerInfos = new List <LiveTvTunerInfo>();
foreach (var tuner in tuners.Encoders)
{
LiveTvTunerInfo info = new LiveTvTunerInfo()
{
Id = tuner.Id.ToString(),
Status = (LiveTvTunerStatus)tuner.State
};
switch (tuner.State)
{
case 0:
info.Status = LiveTvTunerStatus.Available;
break;
case 7:
info.Status = LiveTvTunerStatus.RecordingTv;
break;
}
if (!string.IsNullOrWhiteSpace(tuner.Recording.Title))
{
info.RecordingId = tuner.Recording.ProgramId;
info.ProgramName = string.Format("{0} : {1}", tuner.Recording.Title, tuner.Recording.SubTitle);
}
foreach (var enc in encoders.CaptureCards)
{
if (enc.CardId == tuner.Id)
{
info.Name = string.Format("{0} {1}", enc.CardType, enc.VideoDevice);
info.SourceType = enc.CardType;
break;
}
}
tvTunerInfos.Add(info);
}
return(new LiveTvServiceStatusInfo
{
HasUpdateAvailable = upgradeAvailable,
Version = serverVersion,
Tuners = tvTunerInfos
});
}
