public DataSet SelectAccounts() { string SelectQuery = "select * from tb_LinkedInAccount"; DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "tb_LinkedInAccount"); return(ds); }
public List <string> SelectUnFollowedUsername_List(string useremail) { List <string> lst_Data = new List <string>(); try { //string strQuery = "SELECT * FROM tb_Follow where username='******'"; string strQuery = "SELECT * FROM Unfollow where username='******'"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "Unfollow"); DataTable dt = ds.Tables["Unfollow"]; foreach (DataRow dRow in dt.Rows) { string following_username = dRow["Unfollower_id"].ToString() + ""; lst_Data.Add(following_username); } lst_Data = lst_Data.Distinct().ToList(); } catch (Exception) { } return(lst_Data); }
public List <string> SelectUnaccomplishedPastScheduledTimeFromTBScheduler() { //try //{ // DataTable dataTable = new DataTable(); // string strQuery = "SELECT * FROM tb_Scheduler_Module where IsAccomplished='" + "0" + "'"; // DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Setting"); // DataTable dt = ds.Tables["tb_Setting"]; // foreach (DataRow dRow in dt.Rows) // { // string scheduledTime = dRow["ScheduledDateTime"].ToString(); // DateTime dt_scheduledTime = DateTime.Parse(scheduledTime); // if (DateTime.Now >= dt_scheduledTime) // { // DataRow newRow = new object[] { dRow["Module"] }; // newRow.ItemArray = new object[] { dRow["Module"] }; // dataTable.Rows.Add(newRow); // } // } // return dataTable; //} //catch { return new DataTable(); } List <string> listModules = new List <string>(); try { string strQuery = "SELECT * FROM tb_Scheduler_Module where IsAccomplished='" + "0" + "'"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Setting"); DataTable dt = ds.Tables["tb_Setting"]; foreach (DataRow dRow in dt.Rows) { string scheduledTime = dRow["ScheduledDateTime"].ToString(); DateTime dt_scheduledTime = DateTime.Parse(scheduledTime); //dt_scheduledTime = DateTime.Parse(DateTime.Now.ToString()); if (DateTime.Compare(dt_scheduledTime, DateTime.Now) <= 0) { if (DateTime.Now >= dt_scheduledTime) { listModules.Add(dRow["Module"].ToString()); } } } } catch (Exception) { } return(listModules); }
public DataSet SelectAccountreport(string modulename) { string SelectQuery = "select * from tbl_AccountReport where ModuleName ='" + modulename + "'"; DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "tbl_AccountReport"); return(ds); }
public List <string> SelectUnaccomplishedPastScheduledTimeFromTBScheduler() { List <string> listModules = new List <string>(); try { string strQuery = "SELECT * FROM tb_Scheduler_Module where IsAccomplished='" + "0" + "'"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Scheduler_Module"); DataTable dt = ds.Tables["tb_Scheduler_Module"]; foreach (DataRow dRow in dt.Rows) { string scheduledTime = dRow["ScheduledDateTime"].ToString(); DateTime dt_scheduledTime = DateTime.Parse(scheduledTime); if (dt_scheduledTime.Day == DateTime.Now.Day) { if (DateTime.Now >= dt_scheduledTime) { listModules.Add(dRow["Module"].ToString()); } } } } catch (Exception) { } return(listModules); }
public DataSet SelectAccounts() { string SelectQuery = "select * from AccountInfo"; DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "AccountInfo"); return(ds); }
public List <string> SelectAccouts() { try { List <string> lstAccount = new List <string>(); string strQuery = "SELECT * FROM tb_LinkedInAccount"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_LinkedInAccount"); DataTable dt = ds.Tables["tb_LinkedInAccount"]; foreach (DataRow row in dt.Rows) { string str = null; foreach (var item in row.ItemArray) { str = str + item.ToString() + ":"; } lstAccount.Add(str); } return(lstAccount); } catch (Exception) { return(new List <string>()); } }
public List <string> SelectFollowData_List(string useremail) { List <string> lst_Data = new List <string>(); try { string strQuery = "SELECT * FROM tb_Follow where username='******'"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Follow"); DataTable dt = ds.Tables["tb_Follow"]; foreach (DataRow dRow in dt.Rows) { try { string following_id = dRow["following_id"].ToString() + ""; string following_username = dRow["following_id"].ToString() + ""; lst_Data.Add(following_id); lst_Data.Add(following_username); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } } lst_Data = lst_Data.Distinct().ToList(); } catch (Exception ex) { GlobusLogHelper.log.Error("Error : " + ex.StackTrace); } return(lst_Data); }
public DataTable SelectAccoutsForGridView() { try { List <string> lstAccount = new List <string>(); string strQuery = string.Empty; strQuery = "SELECT * FROM tb_LinkedInAccount"; //if (Globals.IsFreeVersion) //{ // strQuery = "SELECT * FROM tb_LinkedInAccount LIMIT 5"; //} //else //{ // strQuery = "SELECT * FROM tb_LinkedInAccount"; //} DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_LinkedInAccount"); DataTable dt = ds.Tables["tb_LinkedInAccount"]; return(dt); } catch (Exception) { return(new DataTable()); } }
public DataSet SelectCampaignName(string TableName, string CampaignName) { DataSet ds = new DataSet(); try { string SelectQuery = "select CampaignName from " + TableName + " where CampaignName='" + CampaignName + "'"; ds = DataBaseHandler.SelectQuery(SelectQuery, TableName); } catch { }; return(ds); }
public void AddingBoardUrl(string BoardUrl, string PinnedonBoard, string BoardId) { try { string strQuery = "INSERT INTO tb_BoardUrlRecord (BoardUrl , PinnedOnBoard , BoardId) VALUES ('" + BoardUrl + "','" + PinnedonBoard + "' , '" + BoardId + "')"; DataBaseHandler.SelectQuery(strQuery, "tb_BoardUrlRecord"); } catch (Exception) { } }
public void AddingKeywordUrl(string Niches, string Keyword, string BoardId, string BoardName) { try { string strQuery = "INSERT INTO tb_KeywordPin (Niches, Keyword, BoardId, PinnedOnBoard) VALUES ('" + Niches + "','" + Keyword + "' , '" + BoardId + "' , '" + BoardName + "')"; DataBaseHandler.SelectQuery(strQuery, "tb_KeywordPin"); } catch (Exception) { } }
public DataSet SelectAddReport(string module) { try { string query = "Select * from tb_AccountReport where ModuleName='" + module + "'"; DataSet ds = DataBaseHandler.SelectQuery(query, "tb_AccountReport"); return(ds); } catch (Exception ex) { return(new DataSet()); } }
public DataSet getDataFromAccountsTable(string Account) { DataSet DS = new DataSet(); try { string query = "Select * from tb_LinkedInAccount Where UserName="******"'" + Account + "';"; DS = DataBaseHandler.SelectQuery(query, "tb_LinkedInAccount"); } catch { } return(DS); }
public DataSet SelectUrl(string Account) { DataSet DS = new DataSet(); try { string SelectQuery = "SELECT Url FROM tb_CampaignScraperURL WHERE Account='" + Account + "' And Status='Not Scraped';"; DS = DataBaseHandler.SelectQuery(SelectQuery, "tb_CampaignScraperURL"); } catch { } return(DS); }
public DataSet getAllCampaignScraperData() { DataSet DS = new DataSet(); try { string query = "Select CampaignName, Account, FirstName, LastName, Location, Country, AreaWiseLocation, PostalCode, Company, Keyword, Title, Industry, Relationship, Language, Groups, ExportedFileName, TitleValue, CompanyValue, within, YearsOfExperience, Function, SeniorLevel, IntrestedIn, CompanySize, Fortune1000, RecentlyJoined from tb_CampaignScraper"; DS = DataBaseHandler.SelectQuery(query, "tb_CampaignScraper"); } catch { } return(DS); }
public DataSet selectCommentedPinDetails(string Username, string pin) { DataSet DS = new DataSet(); try { string query = "Select * from tb_CommentedPinDetails where AccUsename='" + Username + "' and PinId='" + pin + "'"; DataBaseHandler.SelectQuery(query, "tb_CommentedPinDetails"); } catch (Exception ex) { } return(DS); }
public DataTable SelectUnaccomplishedFromTBScheduler() { try { string strQuery = "SELECT * FROM tb_Scheduler_Module where IsAccomplished='" + "0" + "'"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Setting"); DataTable dt = ds.Tables["tb_Setting"]; return(dt); } catch { return(new DataTable()); } }
public DataTable SelectAllFromTBScheduler() { try { string strQuery = "SELECT * FROM tb_Scheduler_Module"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Scheduler_Module"); DataTable dt = ds.Tables["tb_Scheduler_Module"]; return(dt); } catch { return(new DataTable()); } }
public DataSet SelectDataFromtb_emails() { try { string strQuery = "SELECT * FROM tb_emails"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_emails"); return(ds); } catch (Exception ex) { } return(null); }
public static DataSet SelectScheduledCampaign(string CampainName) { DataSet ds = new DataSet(); try { string SelectQuery = "Select * From Campaign_tweet Where ScheduledDaily ='1'"; ds = DataBaseHandler.SelectQuery(SelectQuery, "Campaign_tweet"); return(ds); } catch { }; return(ds); }
public DataSet SelectAllData() { try { string strQuery = "SELECT * FROM tb_FBAccount"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_FBAccount"); return(ds); } catch (Exception) { return(new DataSet()); } }
public DataSet SearchWithInvite(string Username, string Type) { DataSet ds = new DataSet(); try { string strQuery = "SELECT * FROM tb_SearchWithInvite WHERE Username = '******' and InviteDate = '" + DateTime.Today.ToString() + "'"; ds = DataBaseHandler.SelectQuery(strQuery, "tb_SearchWithInvite"); } catch (Exception ex) { } return(ds); }
public DataSet SelectCamapaignData() { DataSet ds = new DataSet(); try { string strQuery = "SELECT * FROM tb_CamapignSearcWithInvite"; ds = DataBaseHandler.SelectQuery(strQuery, "tb_CamapignSearcWithInvite"); } catch (Exception ex) { } return(ds); }
public DataSet SelectCampaignJoinGroupData() { DataSet ds = new DataSet(); try { string strQuery = "SELECT * FROM tb_CampaignJoinGroup"; ds = DataBaseHandler.SelectQuery(strQuery, "tb_CampaignJoinGroup"); } catch (Exception ex) { } return(ds); }
public DataSet SelectPrivateIPData() { try { string strQuery = "SELECT * FROM tb_IP WHERE IsPublic = 1"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_IP"); return(ds); } catch (Exception) { return(new DataSet()); } }
public DataSet SelectMessageDataForRetweet(string Username, string IdtweetData, string Type) { DataSet ds = new DataSet(); try { string strQuery = "SELECT * FROM tb_MessageRecord WHERE Type = '" + Type + "' and Username = '******' and OtherUsername='******' and DateTime = '" + DateTime.Today.ToString() + "'"; ds = DataBaseHandler.SelectQuery(strQuery, "tb_MessageRecord"); } catch (Exception ex) { } return(ds); }
public DataSet SelectPublicProxyData() { try { string strQuery = "SELECT * FROM tb_Proxies WHERE IsPublic = 0"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Proxies"); return(ds); } catch (Exception) { return(new DataSet()); } }
public DataTable SelectSettingData() { try { string strQuery = "SELECT * FROM tb_Setting"; DataSet ds = DataBaseHandler.SelectQuery(strQuery, "tb_Setting"); DataTable dt = ds.Tables["tb_Setting"]; return(dt); } catch (Exception) { return(new DataTable()); } }
public static bool CheckIfMessagePosted(string Username, string FriendID, string MessageType) { bool Result = false; DataSet DS = DataBaseHandler.SelectQuery("Select * from WallPosterUnique where Username='******' and FriendID='" + FriendID + "' and MessageType='" + MessageType + "'", "WallPosterUnique"); if (DS.Tables[0].Rows.Count > 0) { Result = true; } else { Result = false; } return(Result); }