public void AddEntryToDatabase(AStuddyBuddy entry)
{
//load list
string cn_string = Properties.Settings.Default.StuddyBuddyDBConnectionString;
//Database
SqlConnection cn_connection = new SqlConnection(cn_string);
if (cn_connection.State != ConnectionState.Open)
{
cn_connection.Open();
}
string newBuddyNick = entry.Nickname;
string newBuddyLink = entry.Link;
string newBuddyFaculty = entry.Faculty;
string newBuddyStudies = entry.Studies;
int newBuddyStatus = (int)Level.Starter;
int newBuddyPoints = 0;
string sql_Text = "INSERT INTO StuddyBuddy ([Nickname],[Facebook],[Faculty],[Studies],[Status],[Points]) VALUES('"
+ newBuddyNick + "','" +
newBuddyLink + "','" +
newBuddyFaculty + "','" +
newBuddyStudies + "','" +
newBuddyStatus + "','" +
newBuddyPoints + "')";
SqlCommand cmd_Command = new SqlCommand(sql_Text, cn_connection);
cmd_Command.ExecuteNonQuery();
}
public bool FindExistingPerson(AStuddyBuddy person)
{
DataTable table = LoadData();
foreach (DataRow row in table.Rows)
{
AStuddyBuddy tableBuddy = new AStuddyBuddy(row.Field <string>("Nickname"),
row.Field <string>("Facebook"),
row.Field <string>("Faculty"),
row.Field <string>("Studies"));
if (person.Equals(tableBuddy))
{
return(true);
}
}
return(false);
}
public void DisplayData(DataTable table, ListView listView, string selectedFaculty)
{
List <AStuddyBuddy> studdyBuddyList = new List <AStuddyBuddy>();
AStuddyBuddy studdyBuddy;
foreach (DataRow row in table.Rows)
{
if (row.Field <string>("Faculty") == selectedFaculty)
{
studdyBuddy = new AStuddyBuddy(row.Field <string>("Nickname"),
row.Field <string>("Facebook"),
row.Field <string>("Faculty"),
row.Field <string>("Studies"))
{
Status = row.Field <int>("Status"),
Points = row.Field <int>("Points")
};
studdyBuddyList.Add(studdyBuddy);
}
}
studdyBuddyList.Sort();
studdyBuddyList.Reverse();
foreach (AStuddyBuddy buddy in studdyBuddyList)
{
ListViewItem item = new ListViewItem(buddy.Nickname);
for (int j = 2; j < table.Columns.Count; j++)
{
item.SubItems.Add(buddy.Link);
item.SubItems.Add(buddy.Faculty);
item.SubItems.Add(buddy.Studies);
item.SubItems.Add(Enum.GetName(typeof(Level), buddy.Status));
item.SubItems.Add(buddy.Points.ToString());
}
listView.Items.Add(item);
}
}
