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