public static int CountCommentsByActor(int actorId)
{
DALManager DM = new DALManager();
var number = DM.CountCommentsByActor(actorId);
return(number);
}
private static void SaveFilmToDataBase(Film film)
{
using (var dal = new DALManager("name=FilmDB"))
{
dal.AddFilm(film);
}
}
public static void UpdateAlbum(Album album)
{
var existing = _albums.SingleOrDefault(a => a == album);
if (existing != null && existing.Id != album.Id)
{
// Undo change => Restore album from storage
album = DALManager.Read <Album>(album.Id, album.AncestorsIds);
throw new DuplicateObjectException();
}
if (!album.IsMain && MainAlbum == null)
{
// Undo IsMain change
album.IsMain = true;
throw new RequiredConstraintViolationException();
}
if (album.IsMain && _albums.Where(a => a.IsMain).Count() > 1)
{
UnsetPreviousMainAlbum(album);
}
album.Save();
}
public static FullActorDTO GetActorById(int id)
{
FullActorDTO ActorDTO = new FullActorDTO();
Actor ActorDAL = new Actor();
DALManager dm = new DALManager();
ActorDAL = dm.GetActorById(id);
if (ActorDAL == null)
{
return(null);
}
else
{
ActorDTO.ActorId = ActorDAL.ActorID;
ActorDTO.Name = ActorDAL.Name;
ActorDTO.Firstname = ActorDAL.Firstname;
foreach (Movie m in ActorDAL.Movies)
{
ActorDTO.Movies.Add(new LightMovieDTO(m.MovieID, m.Title, m.Voteaverage));
}
return(ActorDTO);
}
}
public List <User> GetAllUserList(ref int CodError, ref string ErrorMessage)
{
DALManager DAL = new DALManager();
DAL.openDatabase();
ArrayList list = new ArrayList();
//SqlParameter p1 = new SqlParameter();
//p1.DbType = DbType.Int16;
//p1.Direction = ParameterDirection.Input;
//p1.ParameterName = "@Id_User";
//p1.SqlDbType = SqlDbType.Int;
//p1.Value = 1;
//list.Add(p1);
object ret = DAL.execSP("User_SEL_ALL", ref CodError, ref ErrorMessage);
if (CodError < 0)
{
return(null);
}
var j = (DataSet)ret;
int rows = j.Tables[0].Rows.Count;
List <User> userList = Utils.loadObjects <User>(j.Tables[0]);
return(userList);
}
public object GetAllUser()
{
DALManager DAL = new DALManager();
DAL.openDatabase();
ArrayList list = new ArrayList();
SqlParameter p1 = new SqlParameter();
p1.DbType = DbType.Int16;
p1.Direction = ParameterDirection.Input;
p1.ParameterName = "@Id_User";
p1.SqlDbType = SqlDbType.Int;
p1.Value = 1;
int CodError = 0;
string ErrorMessage = "";
list.Add(p1);
object ret = DAL.execSP("User_SEL_ALL", ref CodError, ref ErrorMessage);
if (CodError != 0)
{
return(null);
}
return(ret);
}
public static Boolean InsertCommentOnActorId(int actorId, CommentDTO commentDTO)
{
Comment comment = new Comment(commentDTO.Content, commentDTO.Rate, commentDTO.Avatar, commentDTO.Date);
DALManager dm = new DALManager();
return(dm.InsertCommentOnActorId(actorId, comment));
}
public void ResourceTest()
{
using (DALManager dm = new DALManager())
{
var repo = dm.Resources;
var set = repo.GetAll();
Assert.IsTrue(set.Any());
}
}
internal virtual void Save()
{
if (Id == default(uint))
{
Id = _nextId++;
}
DALManager.Write(This, Id, AncestorsIds);
}
internal static void Verwijderen(Ronde ronde, Locatie locatie)
{
var dalObj = DALManager.Get <DAL.RondeLocatie>(GetWhere(ronde, locatie));
if (dalObj.RondeLocatieID > 0)
{
dalObj.Delete();
}
}
internal static void Verwijderen(Evenement evenement, Deelnemer deelnemer)
{
var dalObj = DALManager.Get <DAL.EvenementDeelnemer>(GetWhere(evenement, deelnemer));
if (dalObj.EvenementDeelnemerID > 0)
{
dalObj.Delete();
}
}
public static ICollection <CommentDTO> GetXCommentsFromYByActorId(int actorId, int X, int Y)
{
DALManager DM = new DALManager();
var listCommentDTO = new List <CommentDTO>();
var listComment = DM.GetXCommentsFromYByActorId(actorId, X, Y);
foreach (Comment c in listComment)
{
listCommentDTO.Add(new CommentDTO(c.Content, c.Rate, c.Avatar, c.Date));
}
return(listCommentDTO);
}
public void AddResourceTest()
{
using (DALManager dm = new DALManager())
{
var repo = dm.Resources;
Resource resource = new Resource
{
FirstName = "Test", LastName = "Reti", IsActive = true
};
repo.Add(resource);
}
}
public static ICollection <ActorDTO> GetXActorsByName(string name, int X)
{
DALManager manager = new DALManager();
var Actors = manager.GetXActorsByName(name, X);
var ActorsDTO = new List <ActorDTO>();
foreach (Actor a in Actors)
{
ActorsDTO.Add(new ActorDTO(a.ActorID, a.Name, a.Firstname));
}
return(ActorsDTO);
}
internal static void Verwijderen(Ronde ronde)
{
var dalObjecten = DALManager.GetCollection <DAL.RondeLocatie>(DALFuncties.Format("RondeID = {0}", ronde.ID));
foreach (var dalObj in dalObjecten)
{
if (dalObj.RondeLocatieID > 0)
{
dalObj.Delete();
}
}
}
public static ICollection <ActorDTO> GetXActorsFromY(int X, int Y)
{
DALManager manager = new DALManager();
var Actors = manager.GetXActorsFromY(X, Y);
var ActorsDTO = new List <ActorDTO>();
foreach (Actor a in Actors)
{
ActorsDTO.Add(new ActorDTO(a.ActorID, a.Name, a.Firstname));
}
return(ActorsDTO);
}
internal static void Toevoegen(Ronde ronde, Locatie locatie)
{
var dalObj = DALManager.Get <DAL.RondeLocatie>(GetWhere(ronde, locatie));
if (dalObj.RondeLocatieID != 0)
{
return;
}
dalObj.RondeID = ronde.ID;
dalObj.LocatieID = locatie.ID;
dalObj.Save();
}
internal static void Toevoegen(Evenement evenement, Deelnemer deelnemer)
{
var dalObj = DALManager.Get <DAL.EvenementDeelnemer>(GetWhere(evenement, deelnemer));
if (dalObj.EvenementDeelnemerID != 0)
{
return;
}
dalObj.EvenementID = evenement.ID;
dalObj.DeelnemerID = deelnemer.ID;
dalObj.Save();
}
public static string Convert(IFormCollection newFileValues)
{
string type = newFileValues["type"];
string name = newFileValues["name"];
string fileName = newFileValues.Files[0].FileName;
if (newFileValues.Files[0].Length > 0)
{
string id = DALManager.Save(fileName, name, type);
string tempZipPath = Directory.GetCurrentDirectory() + "\\Videos\\" + type + "\\" + name + ".zip";
string filePath = DALManager.createDirectory(type, id);
string zipPath = DALManager.createDirectory(type + "\\Resluts", id);
DALManager.CopyFile(newFileValues.Files[0], fileName, filePath);
var inputFile = new MediaFile()
{
Filename = filePath + "\\" + fileName
};
var outputFile = new MediaFile();
switch (type)
{
case "H264":
DALManager.ConvertH264Files(inputFile, outputFile, filePath, name);
break;
case "Thumbnail":
DALManager.ConvertThumbnails(inputFile, outputFile, filePath, name);
break;
case "HLS":
DALManager.ConvertHls(inputFile, outputFile, filePath, name);
break;
default:
break;
}
DALManager.BuildZipFile(fileName, name, tempZipPath, filePath, zipPath);
return(zipPath + "\\" + name + ".zip");
}
return(null);
}
public IEnumerable <Product> GetallProducts()
{
DALManager dal = new DALManager();
DataSet ds = dal.GetAllProduct();
foreach (DataRow dr in ds.Tables[0].Rows)
{
Product product = new Product {
Id = int.Parse(dr["ID"].ToString()), Name = dr["Name"].ToString(), Category = dr["Category"].ToString(), Price = Convert.ToDecimal(dr["Price"])
};
products.Add(product);
}
return(products);
}
public string InsertUser(UserInsert MyUser, ref int errorCode, ref string errorMessage)
{
try
{
string idUSer = Guid.NewGuid().ToString();
DALManager DAL = new DALManager();
DAL.openDatabase();
ArrayList Parameters = new ArrayList();
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@IdPerfil", SqlDbType = SqlDbType.Int, Value = MyUser.idPerfil
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Identification", SqlDbType = SqlDbType.NVarChar, Value = MyUser.identification
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Name", SqlDbType = SqlDbType.NVarChar, Value = MyUser.name
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@LastName", SqlDbType = SqlDbType.NVarChar, Value = MyUser.lastName
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Address", SqlDbType = SqlDbType.NVarChar, Value = MyUser.address
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@NickName", SqlDbType = SqlDbType.NVarChar, Value = MyUser.nickName
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Password", SqlDbType = SqlDbType.NVarChar, Value = MyUser.password
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Email", SqlDbType = SqlDbType.NVarChar, Value = MyUser.email
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Phone", SqlDbType = SqlDbType.NVarChar, Value = MyUser.phone
});
object ret = DAL.execSP("User_INS", ref errorCode, ref errorMessage, Parameters);
if (errorCode != 0)
{
return(null);
}
return(idUSer);
}
catch (Exception)
{
return(null);
}
}
private void OnDeserialized(StreamingContext context)
{
if (_dateCreatedSerialized != 0)
{
DateCreated = DateTimeOffset.FromFileTime(_dateCreatedSerialized);
}
if (_lastEditedSerialized != 0)
{
LastEdited = DateTimeOffset.FromFileTime(_lastEditedSerialized);
}
_photos = new Collection <Photo>(DALManager.ReadCollection <Photo>(Id.ToString()));
Photos = new ReadOnlyCollection <Photo>(_photos);
EndBatchUpdate(doSave: false);
}
public bool UpdateUser(string IdUser, UserUpdate MyUser, ref int errorCode, ref string errorMessage)
{
try
{
DALManager DAL = new DALManager();
DAL.openDatabase();
ArrayList Parameters = new ArrayList();
Parameters.Add(new SqlParameter {
DbType = DbType.Int32, Direction = ParameterDirection.Input, ParameterName = "@idUser", SqlDbType = SqlDbType.NVarChar, Value = IdUser
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Identification", SqlDbType = SqlDbType.NVarChar, Value = MyUser.identification
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Name", SqlDbType = SqlDbType.NVarChar, Value = MyUser.name
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@LastName", SqlDbType = SqlDbType.NVarChar, Value = MyUser.lastName
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Address", SqlDbType = SqlDbType.NVarChar, Value = MyUser.address
});
//Parameters.Add(new SqlParameter { DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@NickName", SqlDbType = SqlDbType.NVarChar, Value = MyUser.nickName });
//Parameters.Add(new SqlParameter { DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Password", SqlDbType = SqlDbType.NVarChar, Value = MyUser.password });
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Email", SqlDbType = SqlDbType.NVarChar, Value = MyUser.email
});
Parameters.Add(new SqlParameter {
DbType = DbType.String, Direction = ParameterDirection.Input, ParameterName = "@Phone", SqlDbType = SqlDbType.NVarChar, Value = MyUser.phone
});
Parameters.Add(new SqlParameter {
DbType = DbType.Boolean, Direction = ParameterDirection.Input, ParameterName = "@IsActive", SqlDbType = SqlDbType.Bit, Value = MyUser.isActive
});
object ret = DAL.execSP("User_UPD", ref errorCode, ref errorMessage, Parameters);
if (errorCode != 0)
{
return(false);
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static ICollection <CharacterDTO> GetCharacterByIdActorAndIdFilm(int actorId, int MovieId)
{
ICollection <CharacterDTO> listCharacterDTO = new List <CharacterDTO>();
ICollection <Character> listCharacterDAL = new List <Character>();
DALManager manager = new DALManager();
//rech de tout les Characters
listCharacterDAL = manager.GetCharacterByIdActorAndIdMovie(actorId, MovieId);
//conversion DAL vers DTO
foreach (Character c in listCharacterDAL)
{
var characterDTO = new CharacterDTO(c.CharacterID, c.Charactername);
listCharacterDTO.Add(characterDTO);
}
return(listCharacterDTO);
}
public static ICollection <LightMovieDTO> GetFavoriteFilms()
{
ICollection <LightMovieDTO> listLightMovieDTO = new List <LightMovieDTO>();
ICollection <Movie> listMovieDAL = new List <Movie>();
DALManager dm = new DALManager();
listMovieDAL = dm.Get10FavoriteMovies();
if (listMovieDAL == null)
{
return(null);
}
foreach (Movie m in listMovieDAL)
{
listLightMovieDTO.Add(new LightMovieDTO(m.MovieID, m.Title, m.Voteaverage));
}
return(listLightMovieDTO);
}
public IHttpActionResult getProduct(int id)
{
DALManager dal = new DALManager();
DataSet ds = dal.GetAllProduct();
foreach (DataRow dr in ds.Tables[0].Rows)
{
Product prod = new Product {
Id = int.Parse(dr["ID"].ToString()), Name = dr["Name"].ToString(), Category = dr["Category"].ToString(), Price = Convert.ToDecimal(dr["Price"])
};
products.Add(prod);
}
var product = products.FirstOrDefault((p) => p.Id == id);
if (product == null)
{
return(NotFound());
}
return(Ok(product));
}
public static ICollection <MovieDTO> GetMovieByIdActor(int idActor)
{
ICollection <MovieDTO> listMovieDTO = new List <MovieDTO>();
ICollection <Movie> listMovieDAL = new List <Movie>();
DALManager dm = new DALManager();
//recherche de tout les movies
listMovieDAL = dm.GetListMoviesByIdActor(idActor);
if (listMovieDAL == null)
{
return(null);
}
//conversion movieDAL en movieDTO
foreach (Movie m in listMovieDAL)
{
listMovieDTO.Add(new MovieDTO(m.MovieID, m.Title, m.Releasedate, m.Voteaverage, m.Runtime, m.Posterpath));
}
return(listMovieDTO);
}
public static ICollection <MovieDTO> FindXMoviesByPartialActorName(string name, int nbElm)
{
ICollection <MovieDTO> listFilmDTO = new List <MovieDTO>();
ICollection <Movie> listMovieDAL = new List <Movie>();
DALManager dm = new DALManager();
listMovieDAL = dm.FindXMoviesByPartialActorName(name, nbElm);
if (listMovieDAL == null)
{
return(null);
}
foreach (Movie m in listMovieDAL)
{
listFilmDTO.Add(new MovieDTO(m.MovieID, m.Title, m.Releasedate, m.Voteaverage, m.Runtime, m.Posterpath));
}
return(listFilmDTO);
}
public static int getRateCommentbyActorID(int actorId)
{
DALManager dm = new DALManager();
int moyenne = 0;
var comments = dm.GetCommentsByActorId(actorId);
if (comments.Count != 0)
{
foreach (Comment c in comments)
{
moyenne += c.Rate;
}
moyenne = moyenne / comments.Count;
}
else
{
moyenne = -1;
}
return(moyenne);
}
// Loads entities from DAL
private void LoadEntities()
{
// If data was loaded up to 5 seconds ago - don't load again
if (_loadEntitiesStopwatch.Elapsed.TotalSeconds > 0 &&
_loadEntitiesStopwatch.Elapsed.TotalSeconds < 5)
{
return;
}
if (_entities != null)
{
UnsubscribeFromEntitiesEvents();
}
_entities = DALManager.Load <T>();
SubscribeToEntitiesEvents();
_loadEntitiesStopwatch.Restart();
}
