private string GetMenu(MenuItem _item)
{
IList<MenuItem> colMenus = MenuItemManager.GetAll().Where(t => t.ID == _item.MenuID).ToList();
if (colMenus.Count == 0)
return _builder.ToString();
for (int i = colMenus.Count - 1; i >= 0; i--)
{
_builder.Insert(0, "<a href='" + ResolveUrl("~/Userpages/Menudetails.aspx?MenuID=") + colMenus[i].ID + "'>" + colMenus[i].Name + ">>");
_builder.Insert(0, "</a>");
if (null != colMenus[i])
GetMenu(colMenus[i]);
}
return _builder.ToString();
}
public void PopulateMenuItem(SqlDataReader _dtr, MenuItem obj)
{
int columnIndex = 0;
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.ID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_NAME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Name = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_DESCRIPTION);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Description = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_DETAILS);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Details = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_TYPE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Type = (TG.ExpressCMS.DataLayer.Enums.RootEnums.MenuItemURLtype)_dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_CATEGORYID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CategoryId = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_URL);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Url = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_ORDERNUMBER);
if (!_dtr.IsDBNull(columnIndex))
{
obj.OrderNumber = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_MENUID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.MenuID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_IMAGE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.Image = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_CREATIONDATE);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CreationDate = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_CREATEDBY);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CreatedBy = Convert.ToInt32(_dtr.GetString((columnIndex)));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_CREATIONTIME);
if (!_dtr.IsDBNull(columnIndex))
{
obj.CreationTime = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_PUBLISHFROM);
if (!_dtr.IsDBNull(columnIndex))
{
obj.PublishFrom = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_PUBLISHTO);
if (!_dtr.IsDBNull(columnIndex))
{
obj.PublishTo = _dtr.GetString((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_ISDELETED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsDeleted = _dtr.GetBoolean((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.CN_LANG_ID);
if (!_dtr.IsDBNull(columnIndex))
{
obj.LangID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.PN_REF_LANG);
if (!_dtr.IsDBNull(columnIndex))
{
obj.RefLangID = _dtr.GetInt32((columnIndex));
}
columnIndex = _dtr.GetOrdinal(MenuItemDataMapper.PN_IS_PUBLISHED);
if (!_dtr.IsDBNull(columnIndex))
{
obj.IsPublished = _dtr.GetBoolean((columnIndex));
}
}
public static void Update(MenuItem obj)
{
MenuItemDataMapper objCaller = new MenuItemDataMapper();
objCaller.Update(obj);
}
public static int Add(MenuItem obj)
{
MenuItemDataMapper objCaller = new MenuItemDataMapper();
return objCaller.Add(obj);
}
public MenuItem GetMenuItem(SqlDataReader _dtr, IList<MenuItem> colobj)
{
MenuItem obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault();
if (null == obj)
{
obj = new MenuItem();
colobj.Add(obj);
}
return obj;
}
public IList<MenuItem> Search(string keyword)
{
MenuItem obj = new MenuItem();
IList<MenuItem> colobj = new List<MenuItem>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = "[usp_SelectMenuItemsSearch]";
#region [Parameters]
SqlParameter parameterID = new SqlParameter("KEYWORD", SqlDbType.NVarChar);
parameterID.Value = keyword;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
while (_dtreader.Read())
{
obj = GetMenuItem(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
public int Add(MenuItem obj)
{
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = INSERTMenuItem;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = obj.ID;
parameterID.Direction = ParameterDirection.Output;
_command.Parameters.Add(parameterID);
SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar);
parameterName.Value = obj.Name;
parameterName.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterName);
SqlParameter parameterDescription = new SqlParameter(PN_DESCRIPTION, SqlDbType.NVarChar);
parameterDescription.Value = obj.Description;
parameterDescription.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterDescription);
SqlParameter parameterDetails = new SqlParameter(PN_DETAILS, SqlDbType.NVarChar);
parameterDetails.Value = obj.Details;
parameterDetails.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterDetails);
SqlParameter parameterType = new SqlParameter(PN_TYPE, SqlDbType.Int);
parameterType.Value = obj.Type;
parameterType.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterType);
SqlParameter parameterCategoryId = new SqlParameter(PN_CATEGORYID, SqlDbType.Int);
parameterCategoryId.Value = obj.CategoryId;
parameterCategoryId.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterCategoryId);
SqlParameter parameterUrl = new SqlParameter(PN_URL, SqlDbType.NVarChar);
parameterUrl.Value = obj.Url;
parameterUrl.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterUrl);
SqlParameter parameterOrderNumber = new SqlParameter(PN_ORDERNUMBER, SqlDbType.Int);
parameterOrderNumber.Value = obj.OrderNumber;
parameterOrderNumber.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterOrderNumber);
SqlParameter parameterMenuID = new SqlParameter(PN_MENUID, SqlDbType.Int);
parameterMenuID.Value = obj.MenuID;
parameterMenuID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterMenuID);
SqlParameter parameterImage = new SqlParameter(PN_IMAGE, SqlDbType.NVarChar);
parameterImage.Value = obj.Image;
parameterImage.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterImage);
SqlParameter parameterCreationDate = new SqlParameter(PN_CREATIONDATE, SqlDbType.NVarChar);
parameterCreationDate.Value = obj.CreationDate;
parameterCreationDate.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterCreationDate);
SqlParameter parameterCreatedBy = new SqlParameter(PN_CREATEDBY, SqlDbType.Int);
parameterCreatedBy.Value = obj.CreatedBy;
parameterCreatedBy.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterCreatedBy);
SqlParameter parameterCreationTime = new SqlParameter(PN_CREATIONTIME, SqlDbType.NVarChar);
parameterCreationTime.Value = obj.CreationTime;
parameterCreationTime.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterCreationTime);
SqlParameter parameterPublishFrom = new SqlParameter(PN_PUBLISHFROM, SqlDbType.NVarChar);
parameterPublishFrom.Value = "1/1/1900";
parameterPublishFrom.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterPublishFrom);
SqlParameter parameterPublishTo = new SqlParameter(PN_PUBLISHTO, SqlDbType.NVarChar);
parameterPublishTo.Value = "1/1/1900"; ;
parameterPublishTo.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterPublishTo);
SqlParameter parameterIsDeleted = new SqlParameter(PN_ISDELETED, SqlDbType.Int);
parameterIsDeleted.Value = obj.IsDeleted;
parameterIsDeleted.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterIsDeleted);
SqlParameter paramLangId = new SqlParameter(PN_LANG_ID, SqlDbType.Int);
paramLangId.Value = obj.LangID;
paramLangId.Direction = ParameterDirection.Input;
_command.Parameters.Add(paramLangId);
SqlParameter RefLangID = new SqlParameter(PN_REF_LANG, SqlDbType.Int);
RefLangID.Value = obj.RefLangID;
RefLangID.Direction = ParameterDirection.Input;
_command.Parameters.Add(RefLangID);
SqlParameter pIsPublished = new SqlParameter(PN_IS_PUBLISHED, SqlDbType.Bit);
pIsPublished.Value = obj.IsPublished;
pIsPublished.Direction = ParameterDirection.Input;
_command.Parameters.Add(pIsPublished);
#endregion;
_connection.Open();
_command.ExecuteNonQuery();
_connection.Close();
obj.ID = Convert.ToInt32(parameterID.Value);
return obj.ID;
}
public IList<MenuItem> GetAllByCategoryandLang(string hash, int langid)
{
MenuItem obj = new MenuItem();
IList<MenuItem> colobj = new List<MenuItem>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = "[usp_SelectMenuItemByLangandHash]";
#region [Parameters]
SqlParameter paramhash = new SqlParameter(CategoryDataMapper.PN_HASH, SqlDbType.NVarChar);
paramhash.Value = hash;
paramhash.Direction = ParameterDirection.Input;
_command.Parameters.Add(paramhash);
SqlParameter paramLangID = new SqlParameter(CategoryDataMapper.PN_LANGUAGE_ID, SqlDbType.Int);
paramLangID.Value = langid;
paramLangID.Direction = ParameterDirection.Input;
_command.Parameters.Add(paramLangID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
while (_dtreader.Read())
{
obj = GetMenuItem(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
public IList<MenuItem> GetAllPaging(int from, int to, ref int totalRows, string keyword)
{
MenuItem obj = new MenuItem();
IList<MenuItem> colobj = new List<MenuItem>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = "[DBO].[usp_SelectMenuItemsSearchPaging]";
#region Paramters
SqlParameter pTotalRows = new SqlParameter("TotalRows", SqlDbType.Int);
pTotalRows.Value = totalRows;
pTotalRows.Direction = ParameterDirection.Output;
_command.Parameters.Add(pTotalRows);
SqlParameter pFrom = new SqlParameter("From", SqlDbType.Int);
pFrom.Value = from;
pFrom.Direction = ParameterDirection.Input;
_command.Parameters.Add(pFrom);
SqlParameter pTo = new SqlParameter("To", SqlDbType.Int);
pTo.Value = to;
pTo.Direction = ParameterDirection.Input;
_command.Parameters.Add(pTo);
SqlParameter pKeyword = new SqlParameter("@Keyword", SqlDbType.NVarChar);
pKeyword.Value = keyword;
pKeyword.Direction = ParameterDirection.Input;
_command.Parameters.Add(pKeyword);
#endregion
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
while (_dtreader.Read())
{
obj = GetMenuItem(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
totalRows = Convert.ToInt32(pTotalRows.Value);
_dtreader.Close();
_connection.Close();
}
return colobj;
}
public IList<MenuItem> GetAllPublishedSearchforAdmin(string keyword, int catid, int menuID)
{
MenuItem obj = new MenuItem();
IList<MenuItem> colobj = new List<MenuItem>();
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = "MenuGetallSearchforAdmin";
#region [Parameters]
SqlParameter parametercatID = new SqlParameter(PN_CATEGORYID, SqlDbType.Int);
parametercatID.Value = catid;
parametercatID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parametercatID);
SqlParameter pkeyword = new SqlParameter("KEYWORD", SqlDbType.NVarChar);
pkeyword.Value = keyword;
pkeyword.Direction = ParameterDirection.Input;
_command.Parameters.Add(pkeyword);
SqlParameter pMenuID = new SqlParameter(PN_MENUID, SqlDbType.Int);
pMenuID.Value = menuID;
pMenuID.Direction = ParameterDirection.Input;
_command.Parameters.Add(pMenuID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
while (_dtreader.Read())
{
obj = GetMenuItem(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
public IList<MenuItem> GetAllforLang()
{
MenuItem obj = new MenuItem();
IList<MenuItem> colobj = new List<MenuItem>();
_connection.ConnectionString = ConfigManager.GetConnectionSecondary();
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTALLMenuItem;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
while (_dtreader.Read())
{
obj = GetMenuItem(_dtreader, colobj);
GetEntityFromReader(_dtreader, obj);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return colobj;
}
private void GetEntityFromReader(SqlDataReader _dtr, MenuItem obj)
{
PopulateMenuItem(_dtr, obj);
}
public MenuItem GetByID(int ID)
{
MenuItem obj = null;
_connection.ConnectionString = _ConnectionString;
_command.Connection = _connection;
_command.CommandType = CommandType.StoredProcedure;
_command.CommandText = SELECTMenuItem;
#region [Parameters]
SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int);
parameterID.Value = ID;
parameterID.Direction = ParameterDirection.Input;
_command.Parameters.Add(parameterID);
#endregion;
_connection.Open();
try
{
using (_dtreader = _command.ExecuteReader())
{
if (_dtreader != null && _dtreader.HasRows)
{
obj = new MenuItem();
if (_dtreader.Read())
GetEntityFromReader(_dtreader, obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_dtreader.Close();
_connection.Close();
}
return obj;
}