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