private void BtnSearch_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
var payload = "action=GetUsers";
if (TxtBadgeNumber.TextLength > 0)
{
payload += "&badgeNumber=" + TxtBadgeNumber.Text;
}
else if (TxtID.TextLength > 0)
{
payload += "&id=" + TxtID.Text;
}
else if (TxtLastName.TextLength > 0)
{
payload += "&whereField=LastName&whereTerm=" + TxtLastName.Text + "&whereSimilar=true";
}
else if (TxtEmail.TextLength > 0)
{
payload += "&whereField=Email&whereTerm=" + TxtLastName.Text + "&whereSimilar=true";
}
var data = Encoding.ASCII.GetBytes(payload);
var request = WebRequest.Create(Program.URL + "/functions/userQuery.php");
request.ContentLength = data.Length;
request.ContentType = "application/x-www-form-urlencoded";
request.Method = "POST";
using (var stream = request.GetRequestStream())
stream.Write(data, 0, data.Length);
var response = (HttpWebResponse)request.GetResponse();
var results = new StreamReader(response.GetResponseStream()).ReadToEnd();
var users = JsonConvert.DeserializeObject <List <Person> >(results);
LstPeople.BeginUpdate();
LstPeople.Items.Clear();
foreach (var user in users)
{
var item = new ListViewItem {
Text = user.PeopleID.ToString()
};
item.SubItems.Add(user.FirstName);
item.SubItems.Add(user.LastName);
item.SubItems.Add(user.Email);
if (user.Phone1 != null)
{
item.SubItems.Add(user.Phone1 + " (" + user.Phone1Type + ")");
}
else
{
item.SubItems.Add("");
}
item.Tag = user;
LstPeople.Items.Add(item);
}
LstPeople.EndUpdate();
Cursor = Cursors.Default;
}
private void BtnSearch_Click(object sender, EventArgs e)
{
var payload = "action=GetPeopleForPickup&year=" + Program.Year.ToString();
if (TxtID.TextLength > 0)
{
payload += "&id=" + TxtID.Text;
}
else if (TxtLastName.TextLength > 0)
{
payload += "&lastName=" + HttpUtility.UrlEncode(TxtLastName.Text);
}
var data = Encoding.ASCII.GetBytes(payload);
var request = WebRequest.Create(Program.URL + "/functions/artQuery.php");
request.ContentLength = data.Length;
request.ContentType = "application/x-www-form-urlencoded";
request.Method = "POST";
using (var stream = request.GetRequestStream())
stream.Write(data, 0, data.Length);
var response = (HttpWebResponse)request.GetResponse();
var results = new StreamReader(response.GetResponseStream()).ReadToEnd();
var people = JsonConvert.DeserializeObject <List <PersonPickup> >(results);
LstPeople.BeginUpdate();
LstPeople.Items.Clear();
foreach (var person in people)
{
var item = new ListViewItem {
Text = person.BadgeNumber.ToString()
};
item.SubItems.Add(person.FirstName);
item.SubItems.Add(person.LastName);
item.SubItems.Add(person.TotalPieces.ToString());
item.SubItems.Add(person.TotalDue.ToString("C"));
item.Tag = person;
LstPeople.Items.Add(item);
}
LstPeople.ListViewItemSorter = new ListViewItemComparer(SortColumn, SortAscend);
LstPeople.Sort();
LstPeople.EndUpdate();
}
private void BtnSearch_Click(object sender, EventArgs e)
{
if (People == null)
{
var data = Encoding.ASCII.GetBytes("action=GetUsers");
var request = WebRequest.Create(Program.URL + "/functions/artQuery.php");
request.ContentLength = data.Length;
request.ContentType = "application/x-www-form-urlencoded";
request.Method = "POST";
using (var stream = request.GetRequestStream())
stream.Write(data, 0, data.Length);
var response = (HttpWebResponse)request.GetResponse();
var results = new StreamReader(response.GetResponseStream()).ReadToEnd();
People = JsonConvert.DeserializeObject <List <Person> >(results);
}
LstPeople.BeginUpdate();
LstPeople.Items.Clear();
var badgeNumber = 0;
int.TryParse(TxtLastName.Text.Trim(), out badgeNumber);
var toAdd = badgeNumber != 0 ?
People.FindAll(b => b.BadgeNumber == badgeNumber).ToList() :
(TxtLastName.Text.Length > 0 ?
People.FindAll(b => b.LastName.ToLower().StartsWith(TxtLastName.Text.ToLower())).ToList() :
People);
foreach (var person in toAdd)
{
var item = new ListViewItem
{
Text = person.FirstName
};
item.SubItems.Add(person.LastName);
item.SubItems.Add(person.Email);
item.SubItems.Add(person.BadgeName);
item.Tag = person;
LstPeople.Items.Add(item);
}
LstPeople.ListViewItemSorter = new ListViewItemComparer(SortColumn, SortAscend);
LstPeople.Sort();
LstPeople.EndUpdate();
}
private void BtnNewAccount_Click(object sender, EventArgs e)
{
var dialog = new FrmNewPerson();
if (dialog.ShowDialog() == DialogResult.OK)
{
var person = dialog.Person;
person.Save();
var data = Encoding.ASCII.GetBytes("action=ModifyPermission&id=" + person.PeopleID + "&modification=Add");
var request = WebRequest.Create(Program.URL + "/functions/artQuery.php");
request.ContentLength = data.Length;
request.ContentType = "application/x-www-form-urlencoded";
request.Method = "POST";
using (var stream = request.GetRequestStream())
stream.Write(data, 0, data.Length);
var response = (HttpWebResponse)request.GetResponse();
var results = new StreamReader(response.GetResponseStream()).ReadToEnd();
LstPeople.SelectedItems.Clear();
var item = new ListViewItem {
Text = person.PeopleID.ToString()
};
item.SubItems.Add(person.FirstName);
item.SubItems.Add(person.LastName);
item.SubItems.Add(person.Email);
if (!string.IsNullOrEmpty(person.Phone1))
{
item.SubItems.Add(person.Phone1 + " (" + person.Phone1Type + ")");
}
else
{
item.SubItems.Add("");
}
item.Tag = person;
item.Selected = true;
LstPeople.Items.Add(item);
LstPeople.ListViewItemSorter = new ListViewItemComparer(SortColumn, SortAscend);
LstPeople.Sort();
item.Focused = true;
}
}
private void LstPeople_ColumnClick(object sender, ColumnClickEventArgs e)
{
if (Math.Abs(SortColumn) == Math.Abs(e.Column))
{
SortAscend = !SortAscend;
LstPeople.Columns[e.Column].ImageIndex = SortAscend ? 0 : 1;
}
else
{
LstPeople.Columns[SortColumn].ImageIndex = -1;
LstPeople.Columns[SortColumn].TextAlign = LstPeople.Columns[SortColumn].TextAlign;
SortAscend = true;
SortColumn = e.Column;
LstPeople.Columns[e.Column].ImageIndex = 0;
}
LstPeople.BeginUpdate();
LstPeople.ListViewItemSorter = new ListViewItemComparer(e.Column, SortAscend);
LstPeople.Sort();
LstPeople.EndUpdate();
}
private void BtnSearch_Click(object sender, EventArgs e)
{
var payload = "action=GetArtists";
if (TxtDisplayName.TextLength > 0)
{
payload += "&whereField=DisplayName&whereTerm=" + TxtDisplayName.Text + "&whereSimilar=true";
}
else if (TxtLastName.TextLength > 0)
{
payload += "&whereField=LastName&whereTerm=" + TxtLastName.Text + "&whereSimilar=true";
}
else if (TxtEmail.TextLength > 0)
{
payload += "&whereField=Email&whereTerm=" + TxtEmail.Text + "&whereSimilar=true";
}
var data = Encoding.ASCII.GetBytes(payload);
var request = WebRequest.Create(Program.URL + "/functions/artQuery.php");
request.ContentLength = data.Length;
request.ContentType = "application/x-www-form-urlencoded";
request.Method = "POST";
using (var stream = request.GetRequestStream())
stream.Write(data, 0, data.Length);
var response = (HttpWebResponse)request.GetResponse();
var results = new StreamReader(response.GetResponseStream()).ReadToEnd();
var users = JsonConvert.DeserializeObject <List <Person> >(results);
LstPeople.BeginUpdate();
LstPeople.Items.Clear();
foreach (var user in users)
{
var item = new ListViewItem {
Text = user.PeopleID.ToString()
};
if (user.DisplayName != null && user.DisplayName != "")
{
item.SubItems.Add(user.DisplayName);
}
else
{
item.SubItems.Add(user.Name);
}
item.SubItems.Add(user.FirstName);
item.SubItems.Add(user.LastName);
item.SubItems.Add(user.Email);
if (!string.IsNullOrEmpty(user.Phone1))
{
item.SubItems.Add(user.Phone1 + " (" + user.Phone1Type + ")");
}
else
{
item.SubItems.Add("");
}
item.Tag = user;
if (user.IsCharity)
{
item.BackColor = Color.LightGreen;
}
LstPeople.Items.Add(item);
}
LstPeople.ListViewItemSorter = new ListViewItemComparer(SortColumn, SortAscend);
LstPeople.Sort();
LstPeople.EndUpdate();
}
