public bool SalvaVideoNelDatabase(string Filename, string ConnectedUser) { VideoDS ds = new VideoDS(); using (VideoBusiness bVideo = new VideoBusiness()) { try { bVideo.FillRW_VIDEO(ds); if (ds.RW_VIDEO.Where(x => x.NOMEVIDEO == Filename && x.PATHVIDEO == @"~\Video").Count() == 0) { VideoDS.RW_VIDEORow VideoB = ds.RW_VIDEO.NewRW_VIDEORow(); VideoB.NOMEVIDEO = Filename; VideoB.PATHVIDEO = @"~\Video"; VideoB.UTENTE = ConnectedUser; VideoB.DATAINSERIMENTO = DateTime.Now; ds.RW_VIDEO.AddRW_VIDEORow(VideoB); bVideo.UpdateVideoDS(ds.RW_VIDEO.TableName, ds); } return(true); } catch //(Exception ex) { bVideo.Rollback(); throw; } } }
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); } } }