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