public DataSet SelectUnSetProxyAccountData()
{
string SelectQuery = "select * from RedditAccount where ProxyAddress='" + "" + "' AND ProxyPort='" + "" + "'";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "RedditAccount");
return(ds);
}
public DataSet SelectUrlfromPropertyUrls(string CampaignName)
{
string SelectQuery = "select id, PropertyUrls from PropertyUrls where CampaignName='" + CampaignName + "' and IsUsed = 0";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "PropertyUrls");
return(ds);
}
public DataSet SelectSecondaryCategoryId(string name)
{
string SelectQuery = "select id, PrimaryCategory from SecondaryCategory where CategoryName='" + name + "'";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "SecondaryCategory");
return(ds);
}
public DataSet SelectStateCodeId(string name)
{
string SelectQuery = "select id from State where StateCode='" + name + "'";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "State");
return(ds);
}
public DataSet SelectUserDeatails()
{
string SelectQuery = "select * from User_tb";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "User_tb");
return(ds);
}
public DataSet SelectPrivateProxyDeatails()
{
string SelectQuery = "SELECT * FROM Tb_ProxyDetails WHERE IsPublic = 1";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "Tb_ProxyDetails");
return(ds);
}
public DataSet SelectLikeUrlByStatus(string status)
{
string SelectQuery = "select LikeUrl,LikeTarget,CompleteTarget,Status from Tb_Url where Status='" + status + "'";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "Tb_Url");
return(ds);
}
public DataSet SelectUrlData()
{
string SelectQuery = "select StateName from State";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "State");
return(ds);
}
public DataSet SelectUrl(string CampaignName)
{
string SelectQuery = "select url from UrlStore where CampaignName='" + CampaignName + "'";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "UrlStore");
return(ds);
}
public DataSet SelectCampaignIDbyCampaign(string campname)
{
string SelectQuery = "select Campaign_id from Tb_Campaign where Campaign_name='" + campname + "'";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "Tb_Campaign");
return(ds);
}
public DataSet SelectCampaignData()
{
string SelectQuery = "select * from Tb_Campaign";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "Tb_Campaign");
return(ds);
}
public DataSet SelectAccountData()
{
string SelectQuery = "select * from Tb_Accounts";
DataSet ds = DataBaseHandler.SelectQuery(SelectQuery, "Tb_Accounts");
return(ds);
}
public DataSet SelectUrlStore(string CampaignName)
{
DataSet ds = new DataSet();
string SelectQuery = "Select url,CategoryId,StateId from UrlStore Where CampaignName ='" + CampaignName + "'";
ds = DataBaseHandler.SelectQuery(SelectQuery, "UrlStore");
return(ds);
}
public DataSet getUrlStoreInfo(string campaignName)
{
DataSet ds = new DataSet();
string selectQuery = "Select url from UrlStore where CampaignName='" + campaignName + "'";
ds = DataBaseHandler.SelectQuery(selectQuery, "UrlStore");
return(ds);
}
public DataSet SelectSecondaryCategory(int CategoryId)
{
DataSet ds = new DataSet();
string SelectQuery = "Select CategoryName from SecondaryCategory where id=" + CategoryId + "";
ds = DataBaseHandler.SelectQuery(SelectQuery, "SecondaryCategory");
return(ds);
}
public DataSet SelectCampaignUnique(string campaignName)
{
DataSet ds = new DataSet();
string SelectQuery = "Select CampaignName from Campaign where CampaignName='" + campaignName + "'";
ds = DataBaseHandler.SelectQuery(SelectQuery, "Campaign");
return(ds);
}
public DataSet SelectCampaign()
{
DataSet ds = new DataSet();
string SelectQuery = "Select CampaignName from Campaign";
ds = DataBaseHandler.SelectQuery(SelectQuery, "Campaign");
return(ds);
}
public DataSet getPropertyUrlsInfo(string campaignName)
{
DataSet ds = new DataSet();
string selectQuery = "Select * from PropertyUrls where CampaignName='" + campaignName + "'";
ds = DataBaseHandler.SelectQuery(selectQuery, "PropertyUrls");
return(ds);
}
public DataSet SelectState(int StateId)
{
DataSet ds = new DataSet();
string SelectQuery = "Select StateName from State where id=" + StateId + "";
ds = DataBaseHandler.SelectQuery(SelectQuery, "State");
return(ds);
}
public DataSet SelectProxyData()
{
DataSet ds = new DataSet();
string SelectQuery = "Select Address,Port,UserName,Password from ProxyData";
ds = DataBaseHandler.SelectQuery(SelectQuery, "ProxyData");
return(ds);
}
public DataSet getAllPropertyInfo(string campaignName)
{
DataSet ds = new DataSet();
string selectQuery = "Select Url,Address,City,Zip,Beds,Baths,Sqft,Lot,Type,YearOfBuilt,LastSold,Parking,Cooling,Heating,Fireplace,DaysOnZillow,MLSNumber,AdditionalFeatures,CountyName,CoveredParkingSpaces,LegalDescription,NearTransportation,Over55ActiveCommunity,ParcelNumber,RoofType,RoomCount,RoomTypes,RVParking,SecuritySystem,NoOfStories,StructureType,UnitCount,PropertyInfoId,Zestimate,ZestimateForRent from propertyinfo where CampaignName='" + campaignName + "'";
ds = DataBaseHandler.SelectQuery(selectQuery, "propertyinfo");
return(ds);
}
public DataSet getProxyCount()
{
DataSet ds = new DataSet();
try
{
string SelectQuery = "Select Address,Port from ProxyData";
ds = DataBaseHandler.SelectQuery(SelectQuery, "ProxyData");
return(ds);
}
catch (Exception ex)
{
return(ds);
}
}