public DataSet GetCMSMoreDetails(CMSSchema objCMSSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@MenuID", SqlDbType.Int);
param[0].Value = objCMSSchema.MenuID;
param[1] = new SqlParameter("@LangType", SqlDbType.VarChar);
param[1].Value = objCMSSchema.LangType;
param[2] = new SqlParameter("@isQuickMenu", SqlDbType.Bit);
param[2].Value = objCMSSchema.IsQuickMenu;
param[3] = new SqlParameter("@MenuContentID", SqlDbType.Int);
param[3].Value = objCMSSchema.MenucontentID;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetCMSMoreControl", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataSet GetLeftMenuDetails(CMSSchema objCMSSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@MenuID", SqlDbType.Int);
param[0].Value = objCMSSchema.MenuID;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetLeftMenu", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}
public DataSet GetLeftMenuDetails(CMSSchema objCMSSchema)
{
try
{
ds = objCMSDAL.GetLeftMenuDetails(objCMSSchema);
return(ds);
}
catch (Exception e)
{
return(null);
}
finally
{
ds = null;
}
}
