public static ResultBOL <DataSet> Get() { string query = "select top(1) * from SiteVisitors"; var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAllSub(int id) { string query = string.Format("select * from vw_Menu where ParentId = {0}", id); var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> Get(int id) { string query = string.Format("select * from vw_Projects where Id = {0}", id); var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAll(int menuId) { string query = string.Format("select * from vw_Projects where MenuId = {0}", menuId); ResultBOL <DataSet> result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAll() { string tag = "[VacanciesDAL]" + "[GetAll]"; string query = "select * from vw_Vacancies"; var result = DataAccessHelpers.ExecuteQuery(query); try { DataRow row = result.Data.Tables[0].NewRow(); row["Name_VN"] = "--- Chọn vị trí ---"; row["Name_EN"] = "--- Select One ---"; if (result.Data.Tables.Count == 0) { DataTable table = new DataTable(); result.Data.Tables.Add(table); } result.Data.Tables[0].Rows.InsertAt(row, 0); } catch (Exception ex) { LogHelpers.WriteError(tag, ex.ToString()); } return(result); }
public static ResultBOL <DataSet> GetAll() { string query = "select * from vw_Projects"; ResultBOL <DataSet> result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAll() { string query = "select * from OtherType select * from Other where IsGroup = 1"; ResultBOL <DataSet> result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAllSort() { string query = "select * from vw_OtherType where Name_VN <> 'Banner'"; var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAll() { string query = "select Top(1) * from vw_About"; var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAllBanners() { string query = "select * from vw_Banners_Get_All"; var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAll(int otherTypeId) { string query = string.Format("select * from vw_Other where OtherType = {0}", otherTypeId); var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAll(string type, int menuId = 0) { #if DEBUG _log.Debug("type: {0} - menuId: {1}", type, menuId); #endif string query = ""; if (menuId > 0) { query = string.Format("select * from News where ParentId = '{0}' and Type like '{1}'", menuId, type); } else { query = string.Format("select * from News where Type like '{0}'", type); } var result = DataAccessHelpers.ExecuteQuery(query); if (result.Code < 0) { _log.Error(result.ErrorMessage); } return(result); }
public static ResultBOL <DataSet> GetTopNews(int top) { string query = string.Format("select top {0} * from vw_News_Menu_TopNew", top); var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> Get(int menuId) { string query = string.Format("select Top 1 * from vw_Menu where Id = {0}", menuId); var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAllSubMenuProjects() { object obj = new { Type = "DuAn" }; string query = "select * from vw_Menu where Type = @Type and ParentId > 0"; var result = DataAccessHelpers.ExecuteQuery(query, obj); return(result); }
public static ResultBOL <DataSet> GetAll(bool hasBanner) { string query = "select * from vw_OtherType"; if (!hasBanner) { query += " where Name_EN <> 'Banner'"; } var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultData <List <Menu> > GetAll() { LogHelpers.LogHandler.Info("Start"); try { string query = "select * from vw_Menu"; var result = DataAccessHelpers.ExecuteQuery(query); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); return(new ResultData <List <Menu> >() { Code = result.Code, ErrorMessage = result.ErrorMessage }); } if (result.Data == null || result.Data.Tables.Count == 0 || result.Data.Tables[0].Rows.Count == 0) { return(new ResultData <List <Menu> >() { Code = result.Code, Data = new List <Menu>() }); } List <Menu> list = new List <Menu>(); foreach (DataRow row in result.Data.Tables[0].Rows) { Menu menu = new Menu(row); list.Add(menu); } return(new ResultData <List <Menu> >() { Code = result.Code, Data = list }); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <List <Menu> >() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultBOL <DataSet> GetTopProjects(int top, int menuId) { string query = string.Format("select top({0}) * from vw_Menu_Projects", top); if (menuId > 0) { query = string.Format("select top({0}) * from vw_Menu_Projects where menuId = {1}", top, menuId); } var result = DataAccessHelpers.ExecuteQuery(query); return(result); }
public static ResultBOL <DataSet> GetAllGroup(int menuId) { #if DEBUG _log.Debug("menuId: {0}", menuId); #endif string query = "select * from Other where IsGroup = 1"; if (menuId > 0) { query += " and ParentId = " + menuId.ToString(); } ResultBOL <DataSet> result = DataAccessHelpers.ExecuteQuery(query); if (result.Code < 0) { _log.Error(result.ErrorMessage); } return(result); }
public static ResultData <List <UserProfile> > GetAll() { LogHelpers.LogHandler.Info("Start"); try { string query = "select * from vw_Users"; var result = DataAccessHelpers.ExecuteQuery(query); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); return(new ResultData <List <UserProfile> >() { Code = result.Code, ErrorMessage = result.ErrorMessage }); } List <UserProfile> list = new List <UserProfile>(); foreach (DataRow row in result.Data.Tables[0].Rows) { UserProfile user = new UserProfile(row); list.Add(user); } return(new ResultData <List <UserProfile> >() { Code = 0, Data = list }); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <List <UserProfile> >() { Code = ex.HResult, ErrorMessage = ex.Message }); } }
public static ResultData <Menu> Get(int id) { LogHelpers.LogHandler.Info("Start"); try { string query = "select top 1 * from vw_Menu where Id = @Id"; object obj = new { Id = id }; var result = DataAccessHelpers.ExecuteQuery(query, obj); if (result.Code < 0) { LogHelpers.LogHandler.Error(result.ErrorMessage); return(new ResultData <Menu>() { Code = result.Code, ErrorMessage = result.ErrorMessage }); } Menu menu = new Menu(result.Data.Tables[0].Rows[0]); return(new ResultData <Menu>() { Code = 0, Data = menu }); } catch (Exception ex) { LogHelpers.LogHandler.Error(ex.ToString()); return(new ResultData <Menu>() { Code = ex.HResult, ErrorMessage = ex.Message }); } }