public static Lease FromListView(ListViewItem lvi, DBHandler handler) { int id = Convert.ToInt32(lvi.SubItems[0].Text); string query = "SELECT * FROM dbo.Leases WHERE dbo.Leases.Id = @id"; DBHandler.SQLParameter par = new DBHandler.SQLParameter(); par.name = "@id"; par.value = id; List <Lease> ls = handler.LeaseQuery(query, new DBHandler.SQLParameter[] { par }); if (ls.Count > 0) { return(ls[0]); } else { return(null); } }
public ListUsers(DBHandler handler) { this.db_handler = handler; InitializeComponent(); }