public static string likeStatus(string id, string username)
{
string status = string.Empty;
DataSet ds = new DataSet();
try
{
string selectQuery = "select Status from " + tableLikeInfo + " where UseName='" + username + "' and PhotoId='" + id + "'";
ds = DBHandler.SelectQuery(selectQuery, tableLikeInfo);
if (ds.Tables[0].Rows.Count > 0)
{
int cnt = Convert.ToInt32(ds.Tables[0].Rows[0].ItemArray[0]);
if (cnt == 1)
{
status = "Liked";
}
else if (cnt == 2)
{
status = "Unliked";
}
}
}
catch { }
return(status);
}
/// <summary>
/// LikeInfo Insert,Update,Select
/// </summary>
/// <returns></returns>
public DataSet getLikeInfo()
{
string SelectQuery = "select LikePhotoId from LikeInfo where Status=0";
DataSet ds = DBHandler.SelectQuery(SelectQuery, "LikeInfo");
return(ds);
}
public static DataSet getFollowInfo(string accountHolder)
{
DataSet ds = new DataSet();
try
{
string selectQuery = "Select FollowingUser,FollowTime from " + tableFollowInfo + " where AccountHolder='" + accountHolder + "'";
ds = DBHandler.SelectQuery(selectQuery, tableFollowInfo);
}
catch { }
return(ds);
}
public DataSet getAccount()
{
DataSet ds = new DataSet();
try
{
string selectQuery = "Select Username,Password,proxyAddress,proxyPort,proxyUsername,proxyPassword,Path,LogInStatus,Posts,Followers,Followings,Authorized,Status from " + tableAccountInfo;
ds = DBHandler.SelectQuery(selectQuery, tableAccountInfo);
}
catch { }
return(ds);
}
public DataSet getAccount()
{
DataSet ds = new DataSet();
try
{
//string selectQuery = "Select UserName,Password,Niches,ProxyAddress,ProxyPort,ProxyUserName,ProxyPassword,UserAgent,Follower,Following,BOARDS,BoardsName,ScreenName from " + tb_emails;
string selectQuery = "Select UserName,Password,Niches,ProxyAddress,ProxyPort,ProxyUserName,ProxyPassword,Follower,Following,ScreenName,LoginStatus from " + tb_emails;
ds = DBHandler.SelectQuery(selectQuery, tb_emails);
}
catch { }
return(ds);
}
public DataSet getFollower(string screen_Name)
{
DataSet DS = new DataSet();
try
{
string selectquery = "Select * from tb_FollowerName where UserName='******'";
DS = DBHandler.SelectQuery(selectquery, "tb_FollowerName");
}
catch (Exception ex)
{
}
return(DS);
}
public static string getFollowStatus1(string user, string followingUser)
{
string status = string.Empty;
DataSet ds = new DataSet();
try
{
string selectQuery = "Select FollowStatus from " + tableFollowInfo + " where AccountHolder='" + user + "' and FollowingUser='******'";
//Select FollowStatus from FollowInfo where AccountHolder='jolandamanlio929' and FollowingUser ='******'
ds = DBHandler.SelectQuery(selectQuery, tableFollowInfo);
}
catch { }
if (ds.Tables[0].Rows.Count > 0)
{
try
{
status = ds.Tables[0].Rows[0].ItemArray[0].ToString();
}
catch { }
}
return(status);
}