public static bool AddUser(User u)
{
User users = GetUserByEmail(u.UserEmail);
if (users != null)
{
throw new Exception("Email is already in use!");
}
string sql = string.Format("insert into users (user_name, user_password, user_email, user_birthday, user_album_count, is_admin) values('{0}', '{1}', '{2}', #{3}#, {4} ,{5})", u.UserName, u.UserPassword, u.UserEmail, u.UserBirthday, u.UserAlbumCount, u.IsAdmin);
return(DBF.ChangeTable(sql) == 1);
}
public static bool AddImage(Img i)
{
// Get all images with the same name and check if their album is identical.
List <Img> images_to_check = GetImagesByName(i.ImageName);
if (images_to_check != null)
{
foreach (Img img in images_to_check)
{
if (img.ImageAlbumId == i.ImageAlbumId)
{
// Code will stop if it reaces this becuase we throw exception.
throw new Exception("An Image with the same name already exists in this album!");
}
}
}
string sql = string.Format("insert into images (image_album_id, image_owner_id, image_name, image_creation_time, image_file_path) values({0}, {1}, '{2}', #{3}#, '{4}')", i.ImageAlbumId, i.ImageOwnerId, i.ImageName, i.ImageCreationTime, i.ImageFilePath);
return(DBF.ChangeTable(sql) == 1);
}
public static bool AddAlbum(Album a)
{
// Get all albums with the same name and check if their owner is identical.
List <Album> albums_to_check = GetAlbumsByName(a.AlbumName);
if (albums_to_check != null)
{
foreach (Album al in albums_to_check)
{
if (al.AlbumOwnerId == a.AlbumOwnerId)
{
// Code will stop if it reaces this becuase we throw exception.
throw new Exception("An Album with the same name already belongs to this user!");
}
}
}
string sql = string.Format("insert into albums (album_owner_id, album_name, album_creation_time, album_size) values({0}, '{1}', #{2}#, {3})", a.AlbumOwnerId, a.AlbumName, a.AlbumCreationTime, a.AlbumSize);
return(DBF.ChangeTable(sql) == 1);
}
