public System.Data.DataView readFromDatabase(int salesleadsID) { DBLink.openConnection(); string sqlcomments = "SELECT * FROM `salesleads`.`comment` WHERE `SalesLeadsID`='" + salesleadsID + "';"; DBLink.closeConnection(); return(DBLink.executeTableQuarry(sqlcomments)); }
//Chamil public List <String> getPredecessorList(int permission) { DBLink.openConnection(); string query = "SELECT * FROM `salesleads`.`user` WHERE `Permissions`>'" + permission + "';"; System.Data.DataTable predecessorTable = DBLink.executeTableQuarry(query).Table; List <String> predecessorList = new List <String>(); for (int i = 0; i < predecessorTable.Rows.Count; i++) { predecessorList.Add((String)predecessorTable.Rows[i].ItemArray[0]); } DBLink.closeConnection(); return(predecessorList); }