public DataTable ArticleCategoryForEditSelectAll(
string ArticleCategoryID
)
{
try
{
var dt = new DataTable();
var scon = new SqlConnection(connectionString);
var cmd = new SqlCommand("usp_ArticleCategoryForEdit_SelectAll", scon);
cmd.Parameters.AddWithValue("@ArticleCategoryID", string.IsNullOrEmpty(ArticleCategoryID) ? dbNULL : (object)ArticleCategoryID);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter errorCodeParam = new SqlParameter("@ErrorCode", null);
errorCodeParam.Size = 4;
errorCodeParam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(errorCodeParam);
var sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
if (errorCodeParam.Value.ToString() != "0")
throw new Exception("Stored Procedure 'usp_ArticleCategoryForEdit_SelectAll' reported the ErrorCode : " + errorCodeParam.Value.ToString());
Common oCommon = new Common();
oCommon.RecursiveFillTree(dt, 0, "ParentID", "ArticleCategoryName", "ArticleCategoryID", "-");
return oCommon.Tree;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public string ArticleCategoryMenuSelectAll(string href, string queryStringName, string parentID, int increaseLevelCount, bool useForeignLanguage, string rootHmtlTag, bool showImage, string imageFolderPath)
{
try
{
var dt = new DataTable();
var scon = new SqlConnection(connectionString);
var cmd = new SqlCommand("usp_ArticleCategory_SelectAll", scon);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter errorCodeParam = new SqlParameter("@ErrorCode", null);
errorCodeParam.Size = 4;
errorCodeParam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(errorCodeParam);
var sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
if (errorCodeParam.Value.ToString() != "0")
throw new Exception("Stored Procedure 'usp_ArticleCategory_SelectAll' reported the ErrorCode : " + errorCodeParam.Value.ToString());
Common oCommon = new Common();
oCommon.RecursiveFillMenuTree(
href,
queryStringName,
dt,
parentID,
"ParentID",
!useForeignLanguage ? "ArticleCategoryName" : "ArticleCategoryNameEn",
"ArticleCategoryID",
increaseLevelCount,
rootHmtlTag,
showImage,
imageFolderPath,
"ImageName"
);
return oCommon.Menu;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public string MenuGenerator(string MenuPositionID, string ParentID, int IncreaseLevelCount, string DisplayFieldName, string LinkFieldName, string ImageFieldName)
{
try
{
var dt = new DataTable();
var scon = new SqlConnection(connectionString);
var cmd = new SqlCommand("usp_Menu_SelectAll", scon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MenuPositionID", string.IsNullOrEmpty(MenuPositionID) ? dbNULL : (object)MenuPositionID);
cmd.Parameters.AddWithValue("@IsAvailable", "True");
SqlParameter errorCodeParam = new SqlParameter("@ErrorCode", null);
errorCodeParam.Size = 4;
errorCodeParam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(errorCodeParam);
var sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
if (errorCodeParam.Value.ToString() != "0")
throw new Exception("Stored Procedure 'usp_Menu_SelectAll' reported the ErrorCode : " + errorCodeParam.Value.ToString());
Common oCommon = new Common();
oCommon.BuilMenu(dt, ParentID, "ParentID", DisplayFieldName, LinkFieldName, ImageFieldName, IncreaseLevelCount);
return oCommon.Menu;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable ArticleCategorySelectAll(int parentID, int increaseLevelCount, string IsShowOnMenu, string IsShowOnHomePage)
{
try
{
var dt = new DataTable();
var scon = new SqlConnection(connectionString);
var cmd = new SqlCommand("usp_ArticleCategory_SelectAll", scon);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter errorCodeParam = new SqlParameter("@ErrorCode", null);
errorCodeParam.Size = 4;
errorCodeParam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(errorCodeParam);
var sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
if (errorCodeParam.Value.ToString() != "0")
throw new Exception("Stored Procedure 'usp_ArticleCategory_SelectAll' reported the ErrorCode : " + errorCodeParam.Value.ToString());
Common oCommon = new Common();
oCommon.RecursiveFillTree(dt, parentID, "ParentID", "ArticleCategoryName", "ArticleCategoryID", increaseLevelCount, IsShowOnMenu, IsShowOnHomePage);
return oCommon.Tree;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable MenuSelectAll(string MenuPositionID, string IsAvailable, string SeparatorCharacter)
{
try
{
var dt = new DataTable();
var scon = new SqlConnection(connectionString);
var cmd = new SqlCommand("usp_Menu_SelectAll", scon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MenuPositionID", string.IsNullOrEmpty(MenuPositionID) ? dbNULL : (object)MenuPositionID);
cmd.Parameters.AddWithValue("@IsAvailable", string.IsNullOrEmpty(IsAvailable) ? dbNULL : (object)IsAvailable);
SqlParameter errorCodeParam = new SqlParameter("@ErrorCode", null);
errorCodeParam.Size = 4;
errorCodeParam.Direction = ParameterDirection.Output;
cmd.Parameters.Add(errorCodeParam);
var sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
if (errorCodeParam.Value.ToString() != "0")
throw new Exception("Stored Procedure 'usp_Menu_SelectAll' reported the ErrorCode : " + errorCodeParam.Value.ToString());
Common oCommon = new Common();
oCommon.RecursiveFillTree(dt, 0, "ParentID", "MenuTitle", "MenuID", SeparatorCharacter);
return oCommon.Tree;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}