void getMember_Callback(SQLDataRequest sdr, DataTable dt) { if (this.InvokeRequired) { var m = new RequestCallbackHandler(getMember_Callback); this.Invoke(m, new object[2] { sdr, dt }); return; } if (dt.Rows.Count == 1) { var row = (DataRow)dt.Rows[0]; txtFirstName.Text = (string)row["FirstName"]; txtLastName.Text = (string)row["LastName"]; txtPhone.Text = (string)row["Phone"]; txtTotalPoints.Text = row["TotalPoints"] is DBNull ? "0" : (string)row["TotalPoints"]; recentTrans.Items.Clear(); row = null; //var mem = new Member((DataRow)dt.Rows[0]); } }
/// <summary> /// This initialize will instantiate a timer that can be used to fire update /// requests at a specified interval. Set 'UpdateInterval' to start timer. /// </summary> /// <param name="command">The SQLCommand to execute</param> /// <param name="callback">The method to be called upon completion</param> /// <param name="handler">Abstraction of the method used to queue the command</param> public SQLDataRequest(SqlCommand command, RequestCallbackHandler callback, RequestEnqueuHandler handler) { Command = command; NotifyRequestComplete = callback; NotifyEnqueueRequest = handler; tmrRefresh.Elapsed += SQLDataRequest_Elapsed; }
public void CreateMember(Member memberdata, RequestCallbackHandler callback) { var cmd = DataCollector.BuildNewSQLCommand("InsertMember"); cmd.Parameters.AddWithValue("FirstName", memberdata.FirstName); cmd.Parameters.AddWithValue("LastName", memberdata.LastName); DataCollector.QueueRequest(new SQLDataRequest(cmd, callback)); cmd = null; }
public void GetMember(List <MemberFilter> filters, RequestCallbackHandler callback) { var cmd = DataCollector.BuildNewSQLCommand("GetMember"); foreach (MemberFilter filter in filters) { addFilter(filter, cmd); } DataCollector.QueueRequest(new SQLDataRequest(cmd, callback)); cmd = null; }
void getTag_Callback(SQLDataRequest sdr, DataTable dt) { if (this.InvokeRequired) { var m = new RequestCallbackHandler(getTag_Callback); this.Invoke(m, new object[2] { sdr, dt }); return; } if (dt.Rows.Count == 1) { var row = (DataRow)dt.Rows[0]; } }
public void UpdateMember(Member memberdata, RequestCallbackHandler callback) { // Check if a key is supplied if (-1 == memberdata.MemberID) { throw new NullKeyException(); } var cmd = DataCollector.BuildNewSQLCommand("UpdateMember"); // Add required parameters cmd.Parameters.AddWithValue("MemberID", memberdata.MemberID); // Add optional parameters if (null != memberdata.FirstName) { cmd.Parameters.AddWithValue("FirstName", memberdata.FirstName); } if (null != memberdata.LastName) { cmd.Parameters.AddWithValue("LastName", memberdata.LastName); } if (null != memberdata.PhoneNum) { cmd.Parameters.AddWithValue("PhoneNum", memberdata.PhoneNum); } if (null != memberdata.ActiveTag) { cmd.Parameters.AddWithValue("TagNum", memberdata.ActiveTag.TagNum); } DataCollector.QueueRequest(new SQLDataRequest(cmd, callback)); cmd = null; }
public SQLDataRequest(SqlCommand command, RequestCallbackHandler callback) { Command = command; NotifyRequestComplete = callback; }