public static RPRecording RPRecordingFromRecording(Recording mcrec)
{
RPRecording rprec = new RPRecording();
rprec.Id = mcrec.Id;
if (mcrec.ScheduleEntry != null)
{
rprec.TVProgrammeID = mcrec.ScheduleEntry.Id;
}
if (mcrec.Request != null)
{
// Get the request that generated this - NB currently, this isn't ideal: there may be multiple - e.g. series and oneTime
Request mcreq = mcrec.Request;
rprec.RPRequestID = mcreq.Id;
if (mcreq is SeriesRequest)
{
SeriesRequest sr = (SeriesRequest)mcreq;
// Series?
SeriesInfo si = sr.Series;
if (si != null)
{
rprec.SeriesID = si.Id;
}
}
if (mcreq is ManualRequest)
{
ManualRequest mr = (ManualRequest)mcreq;
rprec.ManualRecordingDuration = mr.Duration.TotalSeconds;
try
{ rprec.ManualRecordingServiceID = mr.Channel.Service.Id; }
catch { }
rprec.ManualRecordingStartTime = mr.StartTime;
}
// Helpers
rprec.RequestType = RPRequestTypeForRequest(mcreq);
if (!string.IsNullOrWhiteSpace(mcreq.Title))
{
rprec.Title = string.Copy(mcreq.Title);
}
}
rprec.State = (RPRecordingStates)Enum.Parse(typeof(RPRecordingStates), mcrec.State.ToString());
rprec.KeepUntil = (int)mcrec.KeepLength;
rprec.Partial = mcrec.IsPartial;
rprec.Quality = mcrec.Quality;
return(rprec);
}
public IList <ManualesModel> ConsultarManuales(ManualRequest manualModel)
{
List <ManualesModel> listDatos = new List <ManualesModel>();
try
{
SqlCommand command = new SqlCommand
{
CommandText = ConstStoredProcedures.SpObtieneDatosManualesFlex
};
command.Parameters.Add("@Cliente", SqlDbType.BigInt).Value = manualModel.Cliente;
command.Parameters.Add("@Producto", SqlDbType.BigInt).Value = manualModel.Producto;
command.Parameters.Add("@Categoria", SqlDbType.BigInt).Value = manualModel.Categoria;
command.Parameters.Add("@Texto", SqlDbType.VarChar).Value = manualModel.Texto;
command.Parameters.Add("@todo", SqlDbType.Int).Value = manualModel.Todo;
SqlDataReader datosStored = iGenericDataAccess.StoredProcedure(command);
if (datosStored.HasRows)
{
while (datosStored.Read())
{
listDatos.Add(new ManualesModel
{
Id = Convert.ToInt32(datosStored["Id"]),
Nombre = Convert.ToString(datosStored["Nombre"]),
Url = Convert.ToString(datosStored["Url"]),
Descripcion = Convert.ToString(datosStored["Descripcion"]),
Usuario = Convert.ToString(datosStored["Usuario"]),
Fecha = Convert.ToDateTime(datosStored["Fecha"]),
ClienteId = Convert.ToInt32(datosStored["ClienteId"]),
ProductoID = Convert.ToInt32(datosStored["ProductoID"]),
IdCategoria = Convert.ToInt32(datosStored["IdCategoria"])
});
}
iGenericDataAccess.CloseConnection();
}
}
catch (Exception e)
{
iGenericDataAccess.CloseConnection();
throw new DalException(Codes.ERR_00_01, e);
}
return(listDatos);
}
public SingleResponse <IList <ManualesModel> > ConsultarManuale(ManualRequest manualModel)
{
SingleResponse <IList <ManualesModel> > response = new SingleResponse <IList <ManualesModel> >();
try
{
IList <ManualesModel> listManuales = iManualDataAccess.ConsultarManuales(manualModel);
response.Done(listManuales, string.Empty);
}
catch (Exception e)
{
//Agregar menjase de error
response.Error(new DomainException(e.Message));
}
return(response);
}
public ActionResult Index([Bind(Include = "")] ManualRequest manualRequest, string query, int?pageNum)
{
int numOfPage = (pageNum ?? 1);
if (manualRequest == null)
{
manualRequest = new ManualRequest();
manualRequest.SelectResult = new List <IDictionary <string, object> >().ToPagedList(numOfPage, PageSize);
}
manualRequest.Query = query;
if (manualRequest.SelectResult == null)
{
manualRequest.SelectResult = new List <IDictionary <string, object> >().ToPagedList(numOfPage, PageSize);
}
if (!string.IsNullOrEmpty(manualRequest.Query))
{
try
{
var result = _manualRequestHelper.DynamicListFromSql(manualRequest.Query);
manualRequest.SelectResult = result.ToPagedList(numOfPage, PageSize);
manualRequest.RecordsAffected = _manualRequestHelper.RecordsAffected;
manualRequest.ColumnNames = _manualRequestHelper.ColumnNames;
}
catch (Exception e)
{
manualRequest.ErrorMessage = e.Message;
return(View(manualRequest));
}
}
return(View(manualRequest));
}
public SingleResponse <IList <ManualesModel> > ConsultarManuales(ManualRequest manualModel)
{
return(iManualesBussines.ConsultarManuale(manualModel));
}
