public string LeggiVideo(string reparto) { string Path = string.Empty; using (VideoBusiness bVideo = new VideoBusiness()) { VideoDS ds = new VideoDS(); bVideo.FillRW_VIDEO(ds); bVideo.FillRW_VIDEO_REPARTI(ds); //VideoDS.RW_VIDEO_REPARTIRow VideoR = ds.RW_VIDEO_REPARTI.NewRW_VIDEO_REPARTIRow(); VideoDS.RW_VIDEO_REPARTIRow VideoR = ds.RW_VIDEO_REPARTI.Where(x => x.REPARTO == reparto && x.DATAINIZIO <= System.DateTime.Today && x.DATAFINE >= System.DateTime.Today).FirstOrDefault(); if (VideoR != null) { //VideoDS.RW_VIDEORow Video = ds.RW_VIDEO.NewRW_VIDEORow(); VideoDS.RW_VIDEORow Video = ds.RW_VIDEO.Where(x => x.IDVIDEO == VideoR.IDVIDEO).FirstOrDefault(); if (Video != null) { Path = Video.PATHVIDEO + "\\" + Video.NOMEVIDEO; } } } return(Path); }
public void CancellaVideoReparto(decimal IDVIDEOREPARTO) { using (VideoBusiness bVideo = new VideoBusiness()) { VideoDS ds = new VideoDS(); bVideo.FillRW_VIDEO_REPARTI(ds); VideoDS.RW_VIDEO_REPARTIRow VideoB = ds.RW_VIDEO_REPARTI.NewRW_VIDEO_REPARTIRow(); VideoB = ds.RW_VIDEO_REPARTI.Where(x => x.IDVIDEOREPARTO == IDVIDEOREPARTO).FirstOrDefault(); if (VideoB != null) { VideoB.Delete(); bVideo.UpdateVideoDS(ds.RW_VIDEO_REPARTI.TableName, ds); } } }
public bool SalvaAssociazioneVideoReparto(decimal video, string reparto, string DataInizio, string DataFine, string ConnectedUser) { VideoDS ds = new VideoDS(); using (VideoBusiness bVideo = new VideoBusiness()) { try { bVideo.FillRW_VIDEO_REPARTI(ds); VideoDS.RW_VIDEO_REPARTIRow VideoB = ds.RW_VIDEO_REPARTI.NewRW_VIDEO_REPARTIRow(); VideoB.IDVIDEO = video; VideoB.REPARTO = reparto; VideoB.DATAINSERIMENTO = DateTime.Now; VideoB.UTENTE = ConnectedUser; DateTime di = DateTime.ParseExact(DataInizio + " 00:00:00", "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); DateTime df = DateTime.ParseExact(DataFine + " 23:59:59", "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); VideoB.DATAINIZIO = di; VideoB.DATAFINE = df; ds.RW_VIDEO_REPARTI.AddRW_VIDEO_REPARTIRow(VideoB); bVideo.UpdateVideoDS(ds.RW_VIDEO_REPARTI.TableName, ds); return(true); } catch { bVideo.Rollback(); return(false); } } }