public void InsertDataPropertyUrls(string URL, string CampaignName)
{
//URL = "http://zillow.com/homedetails/";
string InsertQuery = "Insert into PropertyUrls (PropertyUrls, CampaignName,IsUsed) values('" + URL + "','" + CampaignName + "','" + "0" + "')";
DataBaseHandler.PerformQuery(InsertQuery, "PropertyUrls");
}
public void deleteFromAllDataByCampaignName(string campaignName)
{
string DeleteQuery = "Delete from Campaign where CampaignName='" + campaignName + "'";
DataBaseHandler.PerformQuery(DeleteQuery, "Campaign");
DeleteQuery = "Delete from PropertyUrls where CampaignName='" + campaignName + "'";
DataBaseHandler.PerformQuery(DeleteQuery, "PropertyUrls");
DeleteQuery = "Delete from UrlStore where CampaignName='" + campaignName + "'";
DataBaseHandler.PerformQuery(DeleteQuery, "UrlStore");
DeleteQuery = "Delete from propertyinfo where CampaignName='" + campaignName + "'";
DataBaseHandler.PerformQuery(DeleteQuery, "propertyinfo");
}
public void AddLikeUrl(string likeUrl, string LikeTarget, string CompleteTarget, string Status)
{
string InsertQuery = "insert into Tb_Url (LikeUrl,LikeTarget,CompleteTarget,Status,Date) values('" + likeUrl + "','" + LikeTarget + "','" + CompleteTarget + "','" + Status + "','" + System.DateTime.Now.ToString() + "')";
DataBaseHandler.PerformQuery(InsertQuery, "Tb_Url");
}
public void DeleteSelectedAccount(string Username, string Password)
{
string SelectQuery = "Delete from Tb_Accounts where [Username]='" + Username + "' AND [Password]='" + Password + "'";
DataBaseHandler.PerformQuery(SelectQuery, "Tb_Accounts");
}
public void InsertPropertInfo(string Url, string StreetName, string City, string Zip, string Beds, string Baths, string Sqft, string Lot, string Type, string YearOfBuilt, string LastSold, string Parking, string Cooling, string Heating, string Fireplace, string DaysOnZillow, string MLSNumber, string AdditionalFeatures, string CountyName, string CoveredParkingSpaces, string LegalDescription, string NearTransportation, string Over55ActiveCommunity, string ParcelNumber, string RoofType, string RoomCount, string RoomTypes, string RVParking, string SecuritySystem, string NoOfStories, string StructureType, string UnitCount, int itemId, string CampaignName, string Zestimate, string ZestimateForRent) // Zestimate, ZestimateForRent
{
string InsertQuery = "Insert into propertyinfo (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,CampaignName,Zestimate,ZestimateForRent) values('" + Url + "','" + StreetName + "','" + 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 + "'," + itemId + ",'" + CampaignName + "','" + Zestimate + "','" + ZestimateForRent + "')";
DataBaseHandler.PerformQuery(InsertQuery, "propertyinfo");
}
public void DeleteUserAccount(string User)
{
string DeleteQuery = "delete from User_tb where User_name = '" + User + "'";
DataBaseHandler.PerformQuery(DeleteQuery, "User_tb");
}
public void UpdatePropertyUrls(string url)
{
string UpdateQuery = "UPDATE PropertyUrls SET IsUsed = 1";
DataBaseHandler.PerformQuery(UpdateQuery, "PropertyUrls");
}
public void UpdateUrlLikeCount(string likeurl, string target)
{
string UpdateQuery = "UPDATE Tb_Url SET CompleteTarget ='" + target + "'where LikeUrl='" + likeurl + "'";
DataBaseHandler.PerformQuery(UpdateQuery, "Tb_Url");
}
public void UpdatePostUrlAccountUrlData(string username, string Password, string url, string PostUrl)
{
string UpdateQuery = "UPDATE Tb_AccountUrl SET PostUrl ='" + PostUrl + "' where User='******' And Password='******'And Url='" + url + "'";
DataBaseHandler.PerformQuery(UpdateQuery, "Tb_AccountUrl");
}
public void UpdateAccountDataStatus(string username, string Password, string status)
{
string UpdateQuery = "UPDATE Tb_Accounts SET Status ='" + status + "'where Username='******' And Password='******'";
DataBaseHandler.PerformQuery(UpdateQuery, "Tb_Accounts");
}
public void UpdateAccountData(string username, string Password, string Ipaddress, string ProxyPort, string ProxyUsername, string ProxyPassword)
{
string UpdateQuery = "UPDATE RedditAccount SET ProxyAddress ='" + Ipaddress + "',ProxyPort='" + ProxyPort + "',ProxyUserName='******',ProxyUserPassword='******' where Username='******' And Password='******'";
DataBaseHandler.PerformQuery(UpdateQuery, "Tb_Accounts");
}
public void DeleteProxyAccount()
{
string SelectQuery = "UPDATE RedditAccount SET ProxyAddress ='" + "" + "',ProxyPort='" + "" + "',ProxyUserName='******',ProxyUserPassword='******'";
DataBaseHandler.PerformQuery(SelectQuery, "RedditAccount");
}
public void DeleteSelectedAccountUrl(string Username, string Password, string url)
{
string SelectQuery = "Delete from Tb_AccountUrl where [User]='" + Username + "' AND [Password]='" + Password + "' AND [Url]='" + url + "'";
DataBaseHandler.PerformQuery(SelectQuery, "Tb_AccountUrl");
}
public void DeleteUrls()
{
string SelectQuery = "Delete from Tb_Url";
DataBaseHandler.PerformQuery(SelectQuery, "Tb_Url");
}
public void AddAccountData(string username, string Password, string Ipaddress, string ProxyPort, string ProxyUsername, string ProxyPassword)
{
string InsertQuery = "insert into Tb_Accounts (Username,Password,ProxyIPAddress,ProxyPort,ProxyUsername,ProxyPassword) values('" + username + "','" + Password + "','" + Ipaddress + "','" + ProxyPort + "','" + ProxyUsername + "','" + ProxyPassword + "')";
DataBaseHandler.PerformQuery(InsertQuery, "Tb_Accounts");
}
public void DeleteUrls(string url)
{
string SelectQuery = "Delete from Tb_Url where LikeUrl='" + url + "'";
DataBaseHandler.PerformQuery(SelectQuery, "Tb_Url");
}
public void AddCampaigndata(string CampaignName, string Date)
{
string InsertQuery = "insert into Tb_Campaign(CampaignName,Date) values('" + CampaignName + "','" + Date + "')";
DataBaseHandler.PerformQuery(InsertQuery, "Tb_Campaign");
}
public void AddUser(string User, string UserPassword)
{
string InsertQuery = "insert into User_tb (User_name,User_Password,Date) values('" + User + "','" + UserPassword + "','" + System.DateTime.Now.ToShortDateString().ToString() + "')";
DataBaseHandler.PerformQuery(InsertQuery, "User_tb");
}
public void DeleteCampaign(string CampId)
{
string DelectQuery = "Delete from propertyinfo where CampaignName='" + CampId + "'";
DataBaseHandler.PerformQuery(DelectQuery, "propertyinfo");
}
public void InsertCampaign(string campaignName)
{
string InsertQuery = "Insert into Campaign (CampaignName) values('" + campaignName + "')";
DataBaseHandler.PerformQuery(InsertQuery, "Campaign");
}
public void DeleteCampaign()
{
string SelectQuery = "Delete from Tb_Campaign";
DataBaseHandler.PerformQuery(SelectQuery, "Tb_Campaign");
}
public void InsertProxyData(string Address, string Port, string UserName, string Password, string Type)
{
string InsertQuery = "Insert into ProxyData (Address,Port,UserName,Password,Type) values('" + Address + "','" + Port + "','" + UserName + "','" + Password + "','" + Type + "')";
DataBaseHandler.PerformQuery(InsertQuery, "ProxyData");
}
public void InsertDataUrlStore(string URL, int CategoryId, string DateOfParsing, int Status, int StateUrlId, string CampaignName)
{
string InsertQuery = "Insert into UrlStore (url, CategoryId, DateOfParsing, Status, StateId, CampaignName) values('" + URL + "'," + CategoryId + ",'" + DateOfParsing + "'," + Status + "," + StateUrlId + ",'" + CampaignName + "')";
DataBaseHandler.PerformQuery(InsertQuery, "UrlStore");
}
public void AddUrlAccountData(string User, string Password, string Url)
{
string InsertQuery = "insert into Tb_AccountUrl(User,Password,Url) values('" + User + "','" + Password + "','" + Url + "')";
DataBaseHandler.PerformQuery(InsertQuery, "Tb_AccountUrl");
}
public void DeleteAccount()
{
string SelectQuery = "Delete from Tb_Accounts";
DataBaseHandler.PerformQuery(SelectQuery, "Tb_Accounts");
}