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