public static long Insert(Genre genre)
{
try
{
long count = 0;
count = AccessDatabase.CountFunction(FunctionRepository.CountGenreName, "@GenreName", genre.GenreName);
if (count > 0)
{
throw new Exception(Messages.AlreadyExistGenreName);
}
long genreID = 0;
genreID = AccessDatabase.Insert(QueryRepository.Genre_Insert,
"@GenreName", genre.GenreName,
"@IsMain", Genre.DetectIsMain(genre.GenreName));
if (genreID <= 0)
{
throw new Exception(Messages.DatabaseError);
}
return(genreID);
}
catch (Exception ex)
{
throw ex;
}
}
public static long Insert(Language language)
{
try
{
long count = 0;
count = AccessDatabase.CountFunction(FunctionRepository.CountLanguageName, "@LanguageName", language.LanguageName);
if (count > 0)
{
throw new Exception(Messages.AlreadyExistLanguageName);
}
long languageID = 0;
languageID = AccessDatabase.Insert(QueryRepository.Language_Insert, "@LanguageName", language.LanguageName);
if (languageID <= 0)
{
throw new Exception(Messages.DatabaseError);
}
return(languageID);
}
catch (Exception ex)
{
throw ex;
}
}
public static long Insert(Users user)
{
try
{
long count = 0;
count = AccessDatabase.CountFunction(FunctionRepository.CountUsername, "@Username", user.Username);
if (count > 0)
{
throw new Exception(Messages.UnavailableUsername);
}
long userID = 0;
userID = AccessDatabase.Insert(QueryRepository.Users_Insert,
"@Username", user.Username,
"@PasswordHash", user.PasswordHash, "@FName", user.FName,
"@LName", user.LName, "@Email", user.Email);
if (userID <= 0)
{
throw new Exception(Messages.DatabaseError);
}
return(userID);
}
catch (Exception ex)
{
throw ex;
}
}
