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