static void IsSigned(bool isSigned)
{
RLM.ViewBands();
Console.WriteLine("Which band?");
int bandId;
var isInt = int.TryParse(Console.ReadLine(), out bandId);
var isInDb = RLM.Db.Bands.Any(p => p.Id == bandId);
while (!isInt || !isInDb)
{
if (!isInt)
{
Console.WriteLine("That is not a number. Try again.");
}
else if (!isInDb)
{
Console.WriteLine("That Id is not in the database. Try again.");
}
isInt = int.TryParse(Console.ReadLine(), out bandId);
isInDb = RLM.Db.Bands.Any(p => p.Id == bandId);
}
RLM.IsSignedDbUpdate(isSigned, bandId);
Console.WriteLine("Press any key to continue...");
Console.ReadKey();
}
static void ViewSongs()
{
RLM.ViewAllAlbums();
Console.WriteLine("Which Album?");
int albumId;
var isInt = int.TryParse(Console.ReadLine(), out albumId);
var isInDb = RLM.Db.Albums.Any(a => a.Id == albumId);
while (!isInt || !isInDb)
{
if (!isInt)
{
Console.WriteLine("That is not a number. Try again.");
}
else if (!isInDb)
{
Console.WriteLine("That Id is not in the database. Try again.");
}
isInt = int.TryParse(Console.ReadLine(), out albumId);
isInDb = RLM.Db.Bands.Any(p => p.Id == albumId);
}
RLM.GetSongsByAlbumId(albumId);
Console.WriteLine("Press any key to continue...");
Console.ReadKey();
}
static void AddBand()
{
// Ask for Name
Console.WriteLine("What is the Band name?");
var name = Console.ReadLine().ToLower();
// Ask for COO
Console.WriteLine("What is their Country of Origin?");
var countryOfOrigin = Console.ReadLine().ToLower();
//Ask for number of members
Console.WriteLine("How many members are in the band?");
int numberOfMembers;
var isInt = int.TryParse(Console.ReadLine(), out numberOfMembers);
while (!isInt)
{
Console.WriteLine("That is not a number. Try again.");
isInt = int.TryParse(Console.ReadLine(), out numberOfMembers);
}
// Ask for Website
Console.WriteLine("What is their website?");
var website = Console.ReadLine().ToLower();
//Ask isSigned
Console.WriteLine("Are they signed?");
bool isSigned;
var isBool = bool.TryParse(Console.ReadLine(), out isSigned);
while (!isBool)
{
Console.WriteLine("That is not a valid answer. Try again.");
isBool = bool.TryParse(Console.ReadLine(), out isSigned);
}
// Ask for Person of Contact
Console.WriteLine("What is the person of contact?");
var personOfContact = Console.ReadLine().ToLower();
// Ask for contact Phone Number
Console.WriteLine("What is their Phone Number?");
var contactPhoneNumber = Console.ReadLine().ToLower();
RLM.AddBandToDb(name, countryOfOrigin, numberOfMembers, website, isSigned, personOfContact, contactPhoneNumber);
Console.WriteLine("Press any key to continue...");
Console.ReadKey();
}
public static bool Validate()
{
IntPtr handle = RLM.rlm_init(LicenseManager.LicenseDir, ".", null);
int stat = RLM.rlm_stat(handle);
if (stat != 0)
{
Console.WriteLine("rlm_init returns " + stat);
}
else
{
Console.WriteLine("rlm_init successful");
// Check out a license
IntPtr license = LicenseManager.Checkout(handle,
LicenseManager.Product,
LicenseManager.Version,
LicenseManager.Count);
stat = RLM.rlm_license_stat(license);
Dictionary <string, string> licenseAttributes = new Dictionary <string, string>();
licenseAttributes["Product"] = LicenseManager.Product;
licenseAttributes["Version"] = LicenseManager.Version;
licenseAttributes["Expiry"] = RLM.marshalToString(RLM.rlm_license_exp(license));
licenseAttributes["Days Until Expiry"] = RLM.rlm_license_exp_days(license).ToString();
// Check it back in
RLM.rlm_checkin(license);
if (stat == 0)
{
LicenseManager.Valid = true;
LicenseManager.showLicenseInfo(licenseAttributes);
return(true);
}
else
{
LicenseManager.Valid = false;
}
}
return(false);
}
public static String GetMacAddress()
{
IntPtr handle = RLM.rlm_init(LicenseManager.LicenseDir, ".", null);
int stat = RLM.rlm_stat(handle);
if (stat == 0)
{
// Get the hostid of this system
byte[] hostID = new byte[RLM.RLM_MAX_HOSTID_STRING];
RLM.rlm_hostid(handle, RLM.RLM_HOSTID_ETHER, hostID);
System.Text.ASCIIEncoding enc = new System.Text.ASCIIEncoding();
String str = enc.GetString(hostID);
return(str);
}
return(null);
}
static void CreateMenu(string[] args)
{
var subMenu = new ConsoleMenu(args, level: 1)
.Add("View all albums for a band", () => ViewAlbums())
.Add("View all the albums, ordered by ReleaseDate", () => RLM.ViewAllAlbums())
.Add("View an Album's songs", () => ViewSongs())
.Add("View All bands that are signed", () => RLM.ViewBandBasedOnIsSigned(true))
.Add("View all bands that are not signed", () => RLM.ViewBandBasedOnIsSigned(false))
.Add("Sub_Close", ConsoleMenu.Close)
.Add("Sub_Exit", () => Environment.Exit(0))
.Configure(config =>
{
config.Selector = "--> ";
config.EnableFilter = false;
config.Title = "Submenu";
config.EnableBreadcrumb = true;
config.WriteBreadcrumbAction = titles => Console.WriteLine(string.Join(" / ", titles));
config.WriteItemAction = item => Console.Write("{0}", item.Name);
});
var menu = new ConsoleMenu(args, level: 0)
.Add("Sign a band", () => AddBand())
.Add("Produce an album", () => AddAlbum())
.Add("Let go a band", () => IsSigned(false))
.Add("Resign a band", () => IsSigned(true))
.Add("View", subMenu.Show)
.Add("Exit", () => Environment.Exit(0))
.Configure(config =>
{
config.Selector = "--> ";
config.EnableFilter = false;
config.Title = "Main menu";
config.EnableWriteTitle = true;
config.EnableBreadcrumb = true;
config.WriteItemAction = item => Console.Write("{0}", item.Name);
});
menu.Show();
}
private static IntPtr Checkout(IntPtr handle, String prod, String ver, int count)
{
IntPtr license = RLM.rlm_checkout(handle, prod, ver, count);
return(license);
}
static void AddAlbum()
{
// 1. Get a Band
RLM.ViewBands();
Console.WriteLine("Which band?");
int bandId;
var isInt = int.TryParse(Console.ReadLine(), out bandId);
var isInDb = RLM.Db.Bands.Any(p => p.Id == bandId);
while (!isInt || !isInDb)
{
if (!isInt)
{
Console.WriteLine("That is not a number. Try again.");
}
else if (!isInDb)
{
Console.WriteLine("That Id is not in the database. Try again.");
}
isInt = int.TryParse(Console.ReadLine(), out bandId);
isInDb = RLM.Db.Bands.Any(p => p.Id == bandId);
}
// 2. Get Album Info
// Ask for Name
Console.WriteLine("What is the title?");
var title = Console.ReadLine().ToLower();
//Ask isSigned
Console.WriteLine("Is it explicit?");
bool isExplicit;
var isBool = bool.TryParse(Console.ReadLine(), out isExplicit);
while (!isBool)
{
Console.WriteLine("That is not a valid answer. Try again.");
isBool = bool.TryParse(Console.ReadLine(), out isExplicit);
}
// Ask for The last time it was watered
Console.WriteLine("Release Date?");
DateTime releaseDate;
var isDate = DateTime.TryParse(Console.ReadLine(), out releaseDate);
while (!isDate)
{
Console.WriteLine("That is not a valid date. Try again.");
isDate = DateTime.TryParse(Console.ReadLine(), out releaseDate);
}
// 3. Add Album to database and return new albumId
var albumId = RLM.AddAlbumToDB(bandId, title, isExplicit, releaseDate);
Console.WriteLine("Please enter info about songs:");
while (UserInput != "q")
{
// 4. Get Song Info
// Ask for Name
Console.WriteLine("What is the title?");
var songTitle = Console.ReadLine().ToLower();
// Ask for Lyrics
Console.WriteLine("What are the lyrics?");
var songLryics = Console.ReadLine().ToLower();
// Ask for how long
Console.WriteLine("How long is the song?");
var songLength = Console.ReadLine().ToLower();
// 5. Add song to database and return the new song Id
var songId = RLM.AddSongToDB(albumId, songTitle, songLryics, songLength);
Console.WriteLine("Please enter songs genres:");
// this will be poplated with a key par songid and genreid
var songGenres = new List <SongGenre>();
while (UserInput != "q")
{
// 6. Get Genre Info
Console.WriteLine("What Genre?");
var genreName = Console.ReadLine().ToLower();
// check if the genre exists in the db
if (!RLM.Db.Genres.Any())
{
var newGenre = new Genre()
{
Name = genreName
};
RLM.Db.Genres.Add(newGenre);
RLM.Db.SaveChanges();
}
var isGenre = RLM.Db.Genres.Any(g => g.Name == genreName);
int genreId;
// 7. If !isGenre add genre to Genres Table and return new genreId
if (isGenre)
{
genreId = RLM.Db.Genres.First(g => g.Name == genreName).Id;
}
else
{
var newGenre = new Genre()
{
Name = genreName
};
RLM.Db.Genres.Add(newGenre);
RLM.Db.SaveChanges();
genreId = RLM.Db.Genres.First(g => g.Name == genreName).Id;
}
// 8. create a SongGenre object with the genreId and songId
var songGenreToAdd = new SongGenre()
{
GenreId = genreId,
SongId = songId
};
//9. Add to list
songGenres.Add(songGenreToAdd);
Console.WriteLine("Add a genre press enter, 'q' to quit");
UserInput = Console.ReadLine();
ValidateInput("", "q");
}
// 10. Add List of SongGenres to specified song
RLM.Db.Songs.First(s => s.Id == songId).SongGenres = songGenres;
RLM.Db.SaveChanges();
Console.WriteLine("Add a song press enter, 'q' to quit");
UserInput = Console.ReadLine();
ValidateInput("", "q");
}
Console.WriteLine("Press any key to continue...");
Console.ReadKey();
}