public DataSet GetNews(BannerControlSchema objBannerControlSchema) { SqlConnection objConn = SQLHelper.OpenConnection(); try { SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@NewsCount", SqlDbType.Int); param[0].Value = objBannerControlSchema.NewsCount; param[1] = new SqlParameter("@LangId", SqlDbType.Int); param[1].Value = objBannerControlSchema.LangId; using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "UspNewsControl", param)) { return(ds); } } catch (Exception ex) { return(null); } finally { SQLHelper.CloseConnection(objConn); } }
public DataSet GetKeyPersonDetails(BannerControlSchema objBannerControlSchema) { SqlConnection objConn = SQLHelper.OpenConnection(); try { SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@FileType", SqlDbType.VarChar); param[0].Value = objBannerControlSchema.FileType; param[1] = new SqlParameter("@LangType", SqlDbType.VarChar); param[1].Value = objBannerControlSchema.LangType; using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "UspKeyPerson", param)) { return(ds); } } catch (Exception ex) { return(null); } finally { SQLHelper.CloseConnection(objConn); } }
public DataSet GetLastReviewDate(BannerControlSchema objBannerControlSchema) { SqlConnection objConn = SQLHelper.OpenConnection(); try { SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@ContentID", SqlDbType.Int); param[0].Value = objBannerControlSchema.ContentID; param[1] = new SqlParameter("@MenuID", SqlDbType.Int); param[1].Value = objBannerControlSchema.MenuID; using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_LastReviewDateControl", param)) { return(ds); } } catch (Exception ex) { return(null); } finally { SQLHelper.CloseConnection(objConn); } }
public DataSet GetMarquee(BannerControlSchema objBannerControlSchema) { try { ds = objBannerDAL.GetMarquee(objBannerControlSchema); return(ds); } catch (Exception e) { return(null); } finally { ds = null; } }
public DataSet GetKeyPersonDetails(BannerControlSchema objBannerControlSchema) { try { ds = objBannerDAL.GetKeyPersonDetails(objBannerControlSchema); return(ds); } catch (Exception e) { return(null); } finally { ds = null; } }
public DataSet GetUCBreadCrumDataforQuickMenu(BannerControlSchema objBannerControlSchema) { try { ds = objBannerDAL.GetUCBreadCrumDataforQuickMenu(objBannerControlSchema); return(ds); } catch (Exception e) { return(null); } finally { ds = null; } }
public DataSet GetVisitorCount(BannerControlSchema objBannerControlSchema) { SqlConnection objConn = SQLHelper.OpenConnection(); try { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@UserName", SqlDbType.NVarChar); param[0].Value = objBannerControlSchema.UserName; using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "SP_VISITORCOUNT", param)) { return(ds); } } catch (Exception ex) { return(null); } finally { SQLHelper.CloseConnection(objConn); } }
public DataSet GetUCBreadCrumDataforQuickMenu(BannerControlSchema objBannerControlSchema) { SqlConnection objConn = SQLHelper.OpenConnection(); try { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@MenuID", SqlDbType.Int); param[0].Value = objBannerControlSchema.MenuID; using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "procGetBreadCrumofQuickMenuData", param)) { return(ds); } } catch (Exception ex) { return(null); } finally { SQLHelper.CloseConnection(objConn); } }