public List <PrnChill> PrnChill_ReturnSQLList(string Command = "")
{
_Database.SQL sql = new _Database.SQL();
if (Command == "")
{
Command = "Select * From PrnChill_TableName()";
}
SqlConnection Conn = PrnChill_Conn();
DataTable ReturnTable = sql.GetDataTable(Conn, Command);
List <PrnChill> ReturnList = new List <PrnChill>();
if (ReturnTable != null)
{
foreach (DataRow ret in ReturnTable.Rows)
{
PrnChill returnObject = new PrnChill();
returnObject.PostName = ret["PostName"].ToString();
returnObject.PostURL = ret["PostURL"].ToString();
returnObject.Links = ret["Links"].ToString();
returnObject.DateAdded = ret["DateAdded"].ToString();
returnObject.LinkCheckDate = ret["LinkCheckDate"].ToString();
returnObject.InCollection = ret["InCollection"].ToString();
returnObject.ImageDir = ret["ImageDir"].ToString();
ReturnList.Add(returnObject);
}
}
return(ReturnList);
}
// Generate SQL Table
public bool PrnChill_CreateSQLTable()
{
SqlConnection Conn = PrnChill_Conn();
string CreateTableLine = "CREATE TABLE [PrnChill](";
CreateTableLine = CreateTableLine + "[PostName] [int] IDENTITY(1,1) NOT NULL,";
CreateTableLine = CreateTableLine + "[PostURL] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[Links] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[DateAdded] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[LinkCheckDate] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[InCollection] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[ImageDir] [varchar](max) NOT NULL";
CreateTableLine = CreateTableLine + ") ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]";
_Database.SQL sql = new _Database.SQL();
return(sql.WriteDataRecord(Conn, CreateTableLine));
}
// Generate SQL Table
public bool ReleaseBBMovies_CreateSQLTable()
{
SqlConnection Conn = ReleaseBBMovies_Conn();
string CreateTableLine = "CREATE TABLE [ReleaseBBMovies](";
CreateTableLine = CreateTableLine + "[MovieName] [int] IDENTITY(1,1) NOT NULL,";
CreateTableLine = CreateTableLine + "[IMDbID] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[Year] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[PostTitle] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[PostURL] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[ImageURL] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[RapidGator] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[LinksChecked] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[InCollection] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[DateAdded] [varchar](max) NOT NULL,";
CreateTableLine = CreateTableLine + "[Cateogry] [varchar](max) NOT NULL";
CreateTableLine = CreateTableLine + ") ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]";
_Database.SQL sql = new _Database.SQL();
return(sql.WriteDataRecord(Conn, CreateTableLine));
}
public PrnChill PrnChill_ReturnSQL(string PostURL)
{
_Database.SQL sql = new _Database.SQL();
SqlConnection Conn = PrnChill_Conn();
string SelectLine = "Select [PostName],[PostURL],[Links],[DateAdded],[LinkCheckDate],[InCollection],[ImageDir] From " + PrnChill_TableName() + " WHERE PostURL = '" + PostURL + "'";
DataTable ReturnTable = sql.GetDataTable(Conn, SelectLine);
PrnChill returnObject = new PrnChill();
if (ReturnTable != null)
{
foreach (DataRow ret in ReturnTable.Rows)
{
returnObject.PostName = ret["PostName"].ToString();
returnObject.PostURL = ret["PostURL"].ToString();
returnObject.Links = ret["Links"].ToString();
returnObject.DateAdded = ret["DateAdded"].ToString();
returnObject.LinkCheckDate = ret["LinkCheckDate"].ToString();
returnObject.InCollection = ret["InCollection"].ToString();
returnObject.ImageDir = ret["ImageDir"].ToString();
return(returnObject);
}
}
return(returnObject);
}
