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