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