//Si includeStatus = 1 se construye la query con el status = 1, las pelis disponibles
//includeStatus = 0 se construye la query con el status = 0, las pelis NO disponibles
//includeStatus = 2 se construye la query sin considerar status, las pelis disponibles y No disponibles
public static void ShowMoviesInTableAccordingAge(SQLDBConnection myDB, Client cToCompare, int includeStatus = 2)
{
DataTable dTable;
Console.WriteLine($"\nMOSTRANDO CATALOGO DISPONIBLE\n");
HpVarious.ShowProgressBar(5, 100);
var table = new ConsoleTable("ID", "Title", "Synopsis");
if (includeStatus == 2)
{
dTable = RUDI.Read(myDB, "Movies", $"ID_Movie, Title, Synopsis", $"RecommendedAge <= {HpVarious.GetAges(cToCompare.Birthdate)}");
}
else if (includeStatus == 1)
{
dTable = RUDI.Read(myDB, "Movies", $"ID_Movie, Title, Synopsis", $"State = 1 AND RecommendedAge <= {HpVarious.GetAges(cToCompare.Birthdate)}");
}
else
{
dTable = RUDI.Read(myDB, "Movies", $"ID_Movie, Title, Synopsis", $"State = 0 AND RecommendedAge <= {HpVarious.GetAges(cToCompare.Birthdate)}");
}
if (dTable != null && dTable.Rows.Count > 0)
{
foreach (DataRow dataRow in dTable.Rows)
{
string[] strInfoToPrint = new string[3];
int i = 0;
foreach (var item in dataRow.ItemArray)
{
strInfoToPrint[i++] = item.ToString();
}
table.AddRow(strInfoToPrint);
}
}
Console.ResetColor();
table.Write();
}
// Si la pelicula existe, esta disponible y el cliente tiene la edad suficiente devolverá true
public static bool CanCLientRentTheMovie(SQLDBConnection myDB, int ID_Movie, Client cWillRent)
{
DataTable dTable;
if (MovieExist(myDB, ID_Movie))
{
dTable = RUDI.Read(myDB, "Movies", "ID_Movie", $"ID_Movie = {ID_Movie} AND State = 1 AND RecommendedAge <= {HpVarious.GetAges(cWillRent.Birthdate)}"); //SELECT ClientID FROM Clients WHERE DNI = strDNI
if (dTable != null && dTable.Rows.Count > 0)
{
return(true);
}
}
return(false);
}
