public DataSet GetPageUrl(MenuSchema objmenuschema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@MenuType", SqlDbType.VarChar);
param[0].Value = "GetPageUrl";
param[1] = new SqlParameter("@RowID", SqlDbType.Int);
param[1].Value = objmenuschema.Rowid;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "UspGetMenuDetails", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataSet GetMenuListDetails(MenuSchema objmenuschema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@ActionType", SqlDbType.VarChar);
param[0].Value = objmenuschema.ActionType;
param[1] = new SqlParameter("@MenuID", SqlDbType.Int);
param[1].Value = objmenuschema.Menuid;
param[2] = new SqlParameter("@MenuCategory", SqlDbType.VarChar);
param[2].Value = objmenuschema.MenuCategory;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "UspGetMenuListDetails", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public int DMLMenuListDetails(MenuSchema objmenuschema)
{
try
{
result = objMenuDAL.DMLMenuListDetails(objmenuschema);
return(result);
}
catch (Exception ex)
{
return(0);
}
}
public int SaveMenuDeatails(MenuSchema objmenuschema)
{
try
{
result = objMenuDAL.SaveMenuDeatails(objmenuschema);
return(result);
}
catch (Exception ex)
{
return(0);
}
}
public DataSet GetMenuId(MenuSchema objmenuschema)
{
try
{
ds = objMenuDAL.GetMenuId(objmenuschema);
return(ds);
}
catch (Exception e)
{
return(null);
}
finally
{
ds = null;
}
}
public int DMLMenuListDetails(MenuSchema objmenuschema)
{
try
{
using (SqlConnection objConn = SQLHelper.OpenConnection())
{
using (SqlTransaction objTran = objConn.BeginTransaction())
{
try
{
var param = new SqlParameter[]
{
new SqlParameter("@Menuid", objmenuschema.Menuid == 0 ? 0 : objmenuschema.Menuid),
};
int result = SQLHelper.ExecuteNonQuery(objConn, objTran, CommandType.StoredProcedure, "Usp_DMLMenuListDetails", param);
if (result == 1)
{
objTran.Commit();
return(result);
}
else
{
objTran.Rollback();
return(0);
}
}
catch (Exception ex)
{
objTran.Rollback();
return(0);
}
}
}
}
catch (Exception ee)
{
return(0);
}
finally
{
}
}
public static NavigationInfo FromMenu(MenuSchema menuItem, bool includeState = false)
{
var navigationInfo = new NavigationInfo
{
Type = SafeParse(menuItem.Type),
IncludeState = includeState
};
if (navigationInfo.Type == NavigationType.Page)
{
navigationInfo.TargetPage = menuItem.Target;
}
else
{
navigationInfo.TargetUri = new Uri(menuItem.Target, UriKind.Absolute);
}
return(navigationInfo);
}
public static void MenuIlkDegerleriniDoldur()
{
MenuSchema menuSchema = new MenuSchema();
List <MenuSchemaMenu> menuItemList = new List <MenuSchemaMenu>
{
new MenuSchemaMenu()
{
MenuAdi = "Steakhouse", Fiyati = 18.25M
},
new MenuSchemaMenu()
{
MenuAdi = "Big king", Fiyati = 4M
},
new MenuSchemaMenu()
{
MenuAdi = "King Chicken", Fiyati = 5M
},
};
menuSchema.menu = menuItemList.ToArray();
XmlSerializer xs = new XmlSerializer(typeof(MenuSchema));
string xml = "";
using (StringWriter sw = new StringWriter())
{
using (XmlWriter writer = XmlWriter.Create(sw))
{
xs.Serialize(writer, menuSchema);
xml = sw.ToString();
}
}
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(xml);
xmlDoc.Save(MenuPath);
}
public static NavInfo FromMenu(MenuSchema menuItem)
{
if (menuItem == null)
{
return(null);
}
var NavInfo = new NavInfo
{
NavigationType = SafeParse(menuItem.MenuType)
};
if (NavInfo.NavigationType == NavType.Page)
{
NavInfo.TargetPage = menuItem.Target;
}
else
{
NavInfo.TargetUri = new Uri(menuItem.Target, UriKind.Absolute);
}
return(NavInfo);
}
public static NavigationInfo ToNavigationInfo(this MenuSchema menuItem, bool includeState = false)
{
if (menuItem == null)
{
return(null);
}
var navigationInfo = new NavigationInfo
{
NavigationType = SafeParse(menuItem.MenuType),
IncludeState = includeState
};
if (navigationInfo.NavigationType == NavigationType.Page)
{
navigationInfo.TargetPage = menuItem.Target;
}
else
{
navigationInfo.TargetUri = new Uri(menuItem.Target, UriKind.Absolute);
}
return(navigationInfo);
}
public int SaveMenuDeatails(MenuSchema objmenuschema)
{
try
{
using (SqlConnection objConn = SQLHelper.OpenConnection())
{
using (SqlTransaction objTran = objConn.BeginTransaction())
{
try
{
SqlParameter imageParameter = new SqlParameter("@MenuImage", SqlDbType.Image);
imageParameter.Value = objmenuschema.MenuImage;
//param.Parameters.Add(imageParameter);
var param = new SqlParameter[]
{
new SqlParameter("@MenuName", objmenuschema.MenuName == null ? (object)DBNull.Value : objmenuschema.MenuName),
new SqlParameter("@MenuName_LL", objmenuschema.MenuName_LL == null ? (object)DBNull.Value : objmenuschema.MenuName_LL),
new SqlParameter("@MenuName_UL", objmenuschema.MenuName_UL == null ? (object)DBNull.Value : objmenuschema.MenuName_UL),
new SqlParameter("@IsNewFlag", objmenuschema.IsNewflag == false ? Convert.ToBoolean(0) : objmenuschema.IsNewflag),
new SqlParameter("@Active", objmenuschema.Active == false ? Convert.ToBoolean(0) : objmenuschema.Active),
new SqlParameter("@IsExternalLink", objmenuschema.IsEternalLink == false ? (Convert.ToBoolean(0)): objmenuschema.IsEternalLink),
new SqlParameter("@MetaDescription", objmenuschema.MetaDescription == null ? (object)DBNull.Value : objmenuschema.MetaDescription),
new SqlParameter("@MetaDescription_LL", objmenuschema.MetaDescription_LL == null ? (object)DBNull.Value : objmenuschema.MetaDescription_LL),
new SqlParameter("@MetaDescription_UL", objmenuschema.MetaDescription_UL == null ? (object)DBNull.Value : objmenuschema.MetaDescription_UL),
new SqlParameter("@MetaKeywords", objmenuschema.MetaKeywords == null ? (object)DBNull.Value : objmenuschema.MetaKeywords),
new SqlParameter("@MetaKeywords_LL", objmenuschema.MetaKeywords_LL == null ? (object)DBNull.Value : objmenuschema.MetaKeywords_LL),
new SqlParameter("@MetaKeywords_UL", objmenuschema.MetaKeywords_UL == null ? (object)DBNull.Value : objmenuschema.MetaKeywords_UL),
//new SqlParameter("@MenuImage",objmenuschema.MenuImage == null ? (object)DBNull.Value : objmenuschema.MenuImage),
new SqlParameter("@MenuImage", imageParameter.Value),
new SqlParameter("@SequenceNo", objmenuschema.SequenceNo == 0 ? 0 : objmenuschema.SequenceNo),
new SqlParameter("@MenuCategory", objmenuschema.MenuCategory == null ? (object)DBNull.Value : objmenuschema.MenuCategory),
new SqlParameter("@MenuType", objmenuschema.MenuType == 0 ? 0 : objmenuschema.MenuType),
new SqlParameter("@MenuTypeValue", objmenuschema.MenuTypeValue == null ? (object)DBNull.Value : objmenuschema.MenuTypeValue),
new SqlParameter("@ParentID", objmenuschema.Parentid == 0 ? 0 : objmenuschema.Parentid),
new SqlParameter("@RoleID", objmenuschema.Role_id == null ? (object)DBNull.Value : objmenuschema.Role_id),
new SqlParameter("@CreatedBy", objmenuschema.Createdby == 0 ? 0 : objmenuschema.Createdby),
new SqlParameter("@PageHeading", objmenuschema.PageHeading == null ? (object)DBNull.Value : objmenuschema.PageHeading),
new SqlParameter("@PageHeading_LL", objmenuschema.PageHeading_LL == null ? (object)DBNull.Value : objmenuschema.PageHeading_LL),
new SqlParameter("@PageHeading_UL", objmenuschema.PageHeading_UL == null ? (object)DBNull.Value : objmenuschema.PageHeading_UL),
new SqlParameter("@PageTitle", objmenuschema.PageTitle == null ? (object)DBNull.Value : objmenuschema.PageTitle),
new SqlParameter("@PageTitle_LL", objmenuschema.PageTitle_LL == null ? (object)DBNull.Value : objmenuschema.PageTitle_LL),
new SqlParameter("@PageTitle_UL", objmenuschema.PageTitle_UL == null ? (object)DBNull.Value : objmenuschema.PageTitle_UL),
new SqlParameter("@ForMobileVersion", objmenuschema.ForMobileVersion == false ? Convert.ToBoolean(0) : objmenuschema.ForMobileVersion),
new SqlParameter("@MenuID", objmenuschema.Menuid == 0 ? 0 : objmenuschema.Menuid),
new SqlParameter("@FileExt", objmenuschema.FileExt == null ? (object)DBNull.Value : objmenuschema.FileExt),
new SqlParameter("@ActionType", objmenuschema.ActionType == null ? (object)DBNull.Value : objmenuschema.ActionType)
};
int result = SQLHelper.ExecuteNonQuery(objConn, objTran, CommandType.StoredProcedure, "UspDMLMenuMaster", param);
if (result == 1)
{
objTran.Commit();
return(result);
}
else
{
objTran.Rollback();
return(0);
}
}
catch (Exception ex)
{
objTran.Rollback();
return(0);
}
}
}
}
catch (Exception ee)
{
return(0);
}
finally
{
}
}
