public List <VD_About> getListAbout()
{
List <VD_About> lst = new List <VD_About>();
_DBAccess = new DBController();
DataSet ds = new DataSet();
ds = _DBAccess.GetEntityList("WEB_VD_GET_LIST_ABOUT");
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
lst.Add(new VD_About
{
ID = Convert.ToInt64(row["ID"]),
Name = Convert.ToString(row["Name"]),
URL = Convert.ToString(row["URL"]),
ShortDescription = Convert.ToString(row["ShortDescription"]),
MetaDescription = Convert.ToString(row["MetaDescription"]),
MetaKeywords = Convert.ToString(row["MetaKeywords"]),
MetaTitle = Convert.ToString(row["MetaTitle"]),
IsActive = Convert.ToBoolean(row["IsActive"]),
CreatedDate = Convert.ToDateTime(row["CreatedDate"])
});
}
}
}
return(lst);
}
public List <VD_MainMenu> getListMainMenu()
{
List <VD_MainMenu> lst = new List <VD_MainMenu>();
_DBAccess = new DBController();
DataSet ds = new DataSet();
ds = _DBAccess.GetEntityList("WEB_VD_GETLIST_MAINMENU");
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
lst.Add(new VD_MainMenu
{
MainMenuID = Convert.ToString(row["MainMenuID"]),
MainMenuName = Convert.ToString(row["MainMenuName"]),
MetaDescription = Convert.ToString(row["MetaDescription"]),
MetaKeywords = Convert.ToString(row["MetaKeywords"]),
MetaTitle = Convert.ToString(row["MetaTitle"]),
IsActive = Convert.ToBoolean(row["IsActive"]),
zIndex = Convert.ToInt32(row["zIndex"]),
lstSubMenu = getDetailsMainMenu(row["MainMenuID"].ToString()).lstSubMenu
});
}
}
}
return(lst);
}
public List <VD_COURSE> getListCourse()
{
List <VD_COURSE> lstCourse = new List <VD_COURSE>();
_DBAccess = new DBController();
DataSet ds = new DataSet();
ds = _DBAccess.GetEntityList("WEB_VD_GETLIST_COURSE");
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
lstCourse.Add(new VD_COURSE
{
ID = Convert.ToInt64(row["ID"]),
Name = Convert.ToString(row["Name"]),
Descriptions = Convert.ToString(row["Descriptions"]),
CourseType = Convert.ToInt32(row["CourseType"]),
CourseTypeName = Convert.ToString(row["CourseTypeName"]),
FromDate = Convert.ToDateTime(row["FromDate"]),
ToDate = Convert.ToDateTime(row["ToDate"]),
IsActive = Convert.ToBoolean(row["IsActive"]),
zIndex = Convert.ToInt32(row["zIndex"])
});
}
}
}
return(lstCourse);
}
public List <VD_AREAS> getListAreas()
{
List <VD_AREAS> lstAreas = new List <VD_AREAS>();
_DBAccess = new DBController();
DataSet ds = new DataSet();
ds = _DBAccess.GetEntityList("WEB_VD_GETLIST_AREAS");
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
lstAreas.Add(new VD_AREAS
{
ID = Convert.ToInt64(row["ID"]),
Name = Convert.ToString(row["Name"]),
Descriptions = Convert.ToString(row["Descriptions"]),
Quantity = Convert.ToInt32(row["Quantity"]),
PersonRegister = _DBAccess.countPersonOnAreas("WEB_VD_COUNT_PERSON_AREAS", Convert.ToInt64(row["ID"])),
IsActive = Convert.ToBoolean(row["IsActive"]),
zIndex = Convert.ToInt32(row["zIndex"])
});
}
}
}
return(lstAreas);
}
public List <VD_Category> getListCategory()
{
List <VD_Category> lst = new List <VD_Category>();
_DBAccess = new DBController();
DataSet ds = new DataSet();
ds = _DBAccess.GetEntityList("WEB_VD_GETLIST_CATEGORY");
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
lst.Add(new VD_Category
{
CategoryID = Convert.ToString(row["CategoryID"]),
CategoryName = Convert.ToString(row["CategoryName"]),
MetaDescription = Convert.ToString(row["MetaDescription"]),
MetaKeywords = Convert.ToString(row["MetaKeywords"]),
MetaTitle = Convert.ToString(row["MetaTitle"]),
IsActive = Convert.ToBoolean(row["IsActive"]),
zIndex = Convert.ToInt32(row["zIndex"]),
IsHomeIndex = Convert.ToBoolean(row["IsHomeIndex"])
});
}
}
}
return(lst);
}
public List <VD_POST> getListPost()
{
List <VD_POST> lst = new List <VD_POST>();
_DBAccess = new DBController();
DataSet ds = new DataSet();
ds = _DBAccess.GetEntityList("WEB_VD_GETLIST_POST");
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
lst.Add(new VD_POST
{
ID = Convert.ToInt64(row["ID"]),
CategoryID = Convert.ToString(row["CategoryID"]),
CategoryName = Convert.ToString(row["CategoryName"]),
MetaTitleCategory = Convert.ToString(row["MetaTitleCategory"]),
MainMenuID = Convert.ToString(row["MainMenuID"]),
MainMenuName = Convert.ToString(row["MainMenuName"]),
MetaTitleMainMenu = Convert.ToString(row["MetaTitleMainMenu"]),
SubMenuID = Convert.ToString(row["SubMenuID"]),
SubMenuName = Convert.ToString(row["SubMenuName"]),
MetaTitleSubMenu = Convert.ToString(row["MetaTitleSubMenu"]),
TitlePost = Convert.ToString(row["TitlePost"]),
ContentPost = Convert.ToString(row["ContentPost"]),
CreatedBy = Convert.ToString(row["CreatedBy"]),
CreatedDate = Convert.ToDateTime(row["CreatedDate"]),
ChangeBy = Convert.ToString(row["ChangeBy"]),
ChangeDate = Convert.ToDateTime(row["ChangeDate"]),
IsPublish = Convert.ToBoolean(row["IsPublish"]),
IsSlide = Convert.ToBoolean(row["IsSlide"]),
IsHome = Convert.ToBoolean(row["IsHome"]),
IsActive = Convert.ToBoolean(row["IsActive"]),
Comment = Convert.ToString(row["Comment"]),
ImagesDisplay = Convert.ToString(row["ImagesDisplay"]),
ShortDescription = Convert.ToString(row["ShortDescription"]),
MetaDescription = Convert.ToString(row["MetaDescription"]),
MetaKeywords = Convert.ToString(row["MetaKeywords"]),
MetaTitle = Convert.ToString(row["MetaTitle"]),
AdminComment = Convert.ToString(row["AdminComment"])
});
}
}
}
return(lst);
}
public List <VD_HOCVIEN> getListHocVien()
{
List <VD_HOCVIEN> lst = new List <VD_HOCVIEN>();
_DBAccess = new DBController();
DataSet ds = new DataSet();
ds = _DBAccess.GetEntityList("WEB_VD_GETLIST_HOCVIEN");
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
lst.Add(new VD_HOCVIEN
{
ID = Convert.ToInt64(row["ID"]),
FullName = Convert.ToString(row["FullName"]),
CMND = Convert.ToString(row["CMND"]),
PhapDanh = Convert.ToString(row["PhapDanh"]),
Birthday = Convert.ToDateTime(row["Birthday"]),
Phone1 = Convert.ToString(row["Phone1"]),
Phone2 = Convert.ToString(row["Phone2"]),
Address = Convert.ToString(row["Address"]),
zIndex = Convert.ToInt32(row["zIndex"]),
AreasID = Convert.ToInt64(row["AreasID"]),
AreasName = Convert.ToString(row["AreasName"]),
CourseID = Convert.ToInt64(row["CourseID"]),
CourseName = Convert.ToString(row["CourseName"]),
UserTypeID = Convert.ToString(row["UserTypeID"]),
UserTypeName = Convert.ToString(row["UserTypeName"]),
CreatedDate = Convert.ToDateTime(row["CreatedDate"]),
IsApproval = Convert.ToBoolean(row["IsApproval"])
});
}
}
}
return(lst);
}