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