public static BAYMYO.UI.Data.HierarchicalCollection GetHierarchical(string modulID, bool rootNode)
{
BAYMYO.UI.Data.HierarchicalCollection rvKategori = new BAYMYO.UI.Data.HierarchicalCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT * FROM Kategori WHERE ModulID=@ModulID ORDER BY ID ASC", conneciton))
{
cmd.Parameters.Add("ModulID", modulID, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
if (rootNode)
{
rvKategori.Add(new BAYMYO.UI.Data.Hierarchical("0", "", "Yeni Kategori"));
}
while (IDR.Read())
{
rvKategori.Add(new BAYMYO.UI.Data.Hierarchical(MConvert.NullToString(IDR["ID"]), MConvert.NullToString(IDR["ParentID"]), MConvert.NullToString(IDR["Adi"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvKategori);
}
public static BAYMYO.UI.Data.HierarchicalCollection GetHierarchical(string modulid, bool rootNode)
{
BAYMYO.UI.Data.HierarchicalCollection rvKategori = new BAYMYO.UI.Data.HierarchicalCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from kategori where modulid=?modulid order by id asc", conneciton))
{
cmd.Parameters.Add("modulid", modulid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
if (rootNode)
{
rvKategori.Add(new BAYMYO.UI.Data.Hierarchical("0", "", "Yeni Kategori"));
}
while (IDR.Read())
{
rvKategori.Add(new BAYMYO.UI.Data.Hierarchical(MConvert.NullToString(IDR["id"]), MConvert.NullToString(IDR["parentid"]), MConvert.NullToString(IDR["adi"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvKategori);
}
