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; } }