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 { } } }