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