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)); }