public static bool UpdateNode(int NodeID, string NodeText)
{
clsDbGeneral db = new clsDbGeneral();
string query = "Update [HRMIS_tblDepartment] set Department_Name=N'" + NodeText + "' where Department_Code=" + NodeID;
db.ExecuteQuery(query);
return(true);
}
public static bool AddChildNode(int ParentNodeID, string NodeText)
{
clsDbGeneral db = new clsDbGeneral();
int NodeID = db.GetMaxID("Department_Code", "HRMIS_tblDepartment");
string query = "INSERT INTO [HRMIS_tblDepartment](Department_Code, Department_Name, Parent_Department_Code) VALUES(" + NodeID + ",N'" + NodeText + "' ," + ParentNodeID + ")";
db.ExecuteQuery(query);
return(true);
}