public static Boolean IsTwitterReady(MemberAccount account)
{
if (account == null)
{
return(false);
}
if (account.AccountType != 1)
{
return(false);
}
if (account.MemberAccountID == 0)
{
return(false);
}
if (account.MemberID == 0)
{
return(false);
}
if (String.IsNullOrEmpty(account.Password))
{
return(false);
}
if (String.IsNullOrEmpty(account.Username))
{
return(false);
}
return(true);
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of MemberAccounts
/// </summary>
public static List <MemberAccount> PopulateObject(IDataReader dr)
{
if (dr == null)
{
throw new ArgumentNullException("dr");
}
var arr = new List <MemberAccount>();
MemberAccount obj;
while (dr.Read())
{
obj = new MemberAccount();
obj.MemberAccountID = (Int32)dr["MemberAccountID"];
obj.MemberID = (Int32)dr["MemberID"];
obj.AccountType = (Int32)dr["AccountType"];
obj.Username = (String)dr["Username"];
obj.Password = (String)dr["Password"];
arr.Add(obj);
}
dr.Close();
return(arr);
}
public static Boolean IsTwitterReady(MemberAccount account)
{
if (account == null)
return false;
if (account.AccountType != 1)
return false;
if (account.MemberAccountID == 0)
return false;
if (account.MemberID == 0)
return false;
if (String.IsNullOrEmpty(account.Password))
return false;
if (String.IsNullOrEmpty(account.Username))
return false;
return true;
}
/// <summary>
/// Takes an prepopulated IDataReader and creates an array of MemberAccounts
/// </summary>
public static List<MemberAccount> PopulateObject(IDataReader dr)
{
if (dr == null)
throw new ArgumentNullException("dr");
var arr = new List<MemberAccount>();
MemberAccount obj;
while (dr.Read())
{
obj = new MemberAccount();
obj.MemberAccountID = (Int32)dr["MemberAccountID"];
obj.MemberID = (Int32)dr["MemberID"];
obj.AccountType = (Int32)dr["AccountType"];
obj.Username = (String)dr["Username"];
obj.Password = (String)dr["Password"];
arr.Add(obj);
}
dr.Close();
return arr;
}
public static void VideoAdded()
{
SqlContext.Pipe.Send("VideoAdded.");
SqlCommand command = null;
SqlDataAdapter dataAdapter = null;
DataSet ds = null;
try
{
var triggContext = SqlContext.TriggerContext;
switch (triggContext.TriggerAction)
{
case TriggerAction.Insert:
SqlContext.Pipe.Send("TriggerAction.Insert");
/* Retrieve the connection that the trigger is using. */
using (var connection = new SqlConnection(@"context connection=true"))
{
connection.Open();
command = new SqlCommand(@"SELECT * FROM INSERTED;", connection);
dataAdapter = new SqlDataAdapter(command);
ds = new DataSet();
dataAdapter.Fill(ds);
var table = ds.Tables[0];
var row = table.Rows[0];
var columns = table.Columns;
var videoId = (Int32)row["VideoID"];
var memberId = (Int32)row["MemberID"];
SqlContext.Pipe.Send(String.Format("VideoID = {0}", videoId));
SqlContext.Pipe.Send(String.Format("MemberID = {0}", memberId));
var targetAccount = MemberAccount.GetMemberAccountByMemberID(memberId, connection);
if (MemberAccount.IsTwitterReady(targetAccount))
{
var video = Video.GetVideoByVideoID(videoId, connection);
var member = Member.GetMemberByMemberID(memberId, connection);
SqlContext.Pipe.Send("Target account is Twitter ready.");
TwitterService.NotifyVideoUploaded(targetAccount.Username, targetAccount.Password, member.NickName, video.WebVideoID);
SqlContext.Pipe.Send("Twitter status updated successfully.");
}
}
break;
}
}
catch (Exception e)
{
SqlContext.Pipe.Send(String.Format("VideoAdded trigger exception: {0}", e.Message));
}
finally
{
try
{
if (command != null)
{
command.Dispose();
}
if (ds != null)
{
ds.Dispose();
}
if (dataAdapter != null)
{
dataAdapter.Dispose();
}
}
catch { }
}
}
