public List <vw_ContentsViewAll> Sel_Ext_ByKeyCodeCategoryLevel1(string Key, bool Disable)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
// string Code = aConfigsBO.Sel_ByAccessKey(Key).Value;
// return this.aDatabaseDA.vw_ContentsViewAll.Where(p => p.CategoryLevel1_Code == Code).Where(p => p.Contents_Disable == Disable).ToList();
List <Configs> ListConfigs = aConfigsBO.Sel_ByAccessKey(Key);
List <string> ListCode = new List <string>();
for (int i = 0; i < ListConfigs.Count; i++)
{
ListCode.Add(ListConfigs[i].Value.ToString());
}
string ListCodeTempt = String.Join(",", ListCode);
//return this.aDatabaseDA.vw_CategoryLevel1ViewAll.Where(p => p.CategoryLevel1_Code.Contains(ListCodeTempt)).Where(p => p.CategoryLevel1_CategoryLevel2_IDLang == IDLang).ToList();
return(this.aDatabaseDA.vw_ContentsViewAll.Where(p => ListCodeTempt.Contains(p.Contents_Code)).Where(p => p.Contents_Disable == Disable).ToList());
}
catch (Exception ex)
{
throw new Exception(String.Format("ContentsBO.Sel_ByKeyCodeCategoryLevel1_ByIDLang: {0}", ex.Message));
}
}
public List <vw_FilesViewAll> Sel_Ext_ByKeyCodeAlbums(string Key)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
List <Configs> ListConfig = aConfigsBO.Sel_ByAccessKey(Key);
List <string> ListCode = new List <string>();
for (int i = 0; i < ListConfig.Count; i++)
{
ListCode.Add(ListConfig[i].Value.ToString());
}
string ListCodeTempt = String.Join(",", ListCode);
return(this.aDatabaseDA.vw_FilesViewAll.Where(p => p.Files_Code.Contains(ListCodeTempt)).ToList());
}
catch (Exception ex)
{
throw new Exception(String.Format("ContentsBO.SelectContents_ByCode_002: {0}", ex.Message));
}
}
//===================================================================================================
public List<vw_CategoryLevel2ViewAll> Sel_ByKeyCodeCategoryLevel2_ByIDLang(string Key, int IDLang, bool Disable)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
CategoryLevel2BO aCategoryLevel2BO = new CategoryLevel2BO();
// string Code = aConfigsBO.Sel_ByAccessKey(Key).Value;
// return this.aDatabaseDA.vw_CategoryLevel2ViewAll.Where(p => p.Code == Code).Where(p => p.IDLang == IDLang).Where(p => p.Disable == Disable).ToList();
List<Configs> ListConfigs = aConfigsBO.Sel_ByAccessKey(Key);
List<string> ListCode = new List<string>();
for (int i = 0; i < ListConfigs.Count; i++)
{
ListCode.Add(ListConfigs[i].Value.ToString());
}
string ListCodeTempt = String.Join(",", ListCode);
return this.aDatabaseDA.vw_CategoryLevel2ViewAll.Where(p => ListCodeTempt.Contains(p.Code)).Where(p => p.IDLang == IDLang).Where(p => p.Disable == Disable).ToList();
}
catch (Exception ex)
{
throw new Exception(String.Format("CategoryLevel2BO.SelectCategoryLevel2_ByCode_002: {0}", ex.Message));
}
}
public static string Load_DynamicDataLanguage_Page(HttpContext Context, string SYSTEM)
{
string PageHTML = Context.Request["filename"].ToString();
LanguagesBO aLanguagesBO = new LanguagesBO();
ConfigsBO aConfigsBO = new ConfigsBO();
List<Configs> ListConfigsCMS = new List<Configs>();
List<string> ListCodeCMS = new List<string>();
ListConfigsCMS = aConfigsBO.Sel_ByAccessKey(key_DEF_LANG_CMS);
for (int i = 0; i < ListConfigsCMS.Count; i++)
{
ListCodeCMS.Add(ListConfigsCMS[i].Value.ToString());
}
string ListCodeTemptCMS = String.Join(",", ListCodeCMS);
List<Configs> ListConfigsWEB = new List<Configs>();
List<string> ListCodeWEB = new List<string>();
ListConfigsWEB = aConfigsBO.Sel_ByAccessKey(key_DEF_LANG_WEB);
for (int i = 0; i < ListConfigsCMS.Count; i++)
{
ListCodeWEB.Add(ListConfigsWEB[i].Value.ToString());
}
string ListCodeTemptWEB = String.Join(",", ListCodeWEB);
sys_NUM_LANG = aLanguagesBO.Sel().ToList().Count;
if (SYSTEM == "CMS")
{
sys_DEF_LANG = int.Parse(ListCodeTemptCMS);
}
else if (SYSTEM == "WEB")
{
sys_DEF_LANG = int.Parse(ListCodeTemptWEB);
}
if (!string.IsNullOrEmpty(Context.Request.QueryString["IDLang"]))
{
sys_CUR_LANG = Convert.ToInt32(Context.Request.QueryString["IDLang"]);
}
else
{
if (Context.GetSection(key_CUR_LANG) != null)
{
sys_CUR_LANG = Convert.ToInt32(Context.GetSection(key_CUR_LANG).ToString());
}
// Cuoi cung moi lay den ngon ngu mac dinh
else
{
sys_CUR_LANG = int.Parse(ListCodeTemptCMS);
}
}
string PhysicalPath = Context.Server.MapPath(@"\\Languages\\" + aLanguagesBO.Sel_ByID(sys_CUR_LANG).NameLang + "\\" + PageHTML + ".xml");
XmlDocument doc = new XmlDocument();
doc.Load(PhysicalPath);
XmlElement element = doc.DocumentElement;
XmlNodeList attr_coll = doc.SelectNodes("//item");
List<LanguagesItem> List_ItemLang = new List<LanguagesItem>();
LanguagesItem Item;
foreach (XmlNode node in attr_coll)
{
Item = new LanguagesItem();
Item.Text = node.InnerText;
Item.Key = node.Attributes["Index"].Value;
List_ItemLang.Add(Item);
}
String jSonString = "";
InfoLang aInfoLang = new InfoLang();
aInfoLang.DATA_LANG = List_ItemLang;
aInfoLang.sys_CUR_LANG = sys_CUR_LANG;
aInfoLang.sys_DEF_LANG = sys_DEF_LANG;
aInfoLang.sys_NUM_LANG = sys_NUM_LANG;
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(aInfoLang, _converter);
CORE_Language.aInfoLang.DATA_LANG = List_ItemLang; // Chỗ chứa dữ liệu cho cách thức truy cập từ trang aspx
return jSonString;
}
//
//-------- Danh cho phuong phap lay ngon ngu moi -------------
public static void Load_Language(string SYSTEM)
{
LanguagesBO aLanguagesBO = new LanguagesBO();
ConfigsBO aConfigsBO = new ConfigsBO();
List<Configs> ListConfigsCMS = new List<Configs>();
List<string> ListCodeCMS = new List<string>();
ListConfigsCMS = aConfigsBO.Sel_ByAccessKey(key_DEF_LANG_CMS);
for (int i = 0; i < ListConfigsCMS.Count; i++)
{
ListCodeCMS.Add(ListConfigsCMS[i].Value.ToString());
}
string ListCodeTemptCMS = String.Join(",", ListCodeCMS);
List<Configs> ListConfigsWEB = new List<Configs>();
List<string> ListCodeWEB = new List<string>();
ListConfigsWEB = aConfigsBO.Sel_ByAccessKey(key_DEF_LANG_WEB);
for (int i = 0; i < ListConfigsCMS.Count; i++)
{
ListCodeWEB.Add(ListConfigsWEB[i].Value.ToString());
}
string ListCodeTemptWEB = String.Join(",", ListCodeWEB);
sys_NUM_LANG = aLanguagesBO.Sel().ToList().Count;
if (SYSTEM == "CMS")
{
sys_DEF_LANG = int.Parse(ListCodeTemptCMS);
sys_CUR_LANG = int.Parse(ListCodeTemptCMS);
}
else if (SYSTEM == "WEB")
{
sys_DEF_LANG = int.Parse(ListCodeTemptWEB);
sys_CUR_LANG = int.Parse(ListCodeTemptWEB);
}
}
public List<vw_FilesViewAll> Sel_Ext_ByKeyCodeFiles_ByIDLang(string Key, int IDLang, bool Disable)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
List<Configs> ListConfig = aConfigsBO.Sel_ByAccessKey(Key);
List<string> ListCode = new List<string>();
for (int i = 0; i < ListConfig.Count; i++)
{
ListCode.Add(ListConfig[i].Value.ToString());
}
string ListCodeTempt = String.Join(",", ListCode);
return this.aDatabaseDA.vw_FilesViewAll.Where(p => p.Files_Code.Contains(ListCodeTempt)).Where(p => p.Files_IDLang == IDLang).Where(p=>p.Files_Disable==Disable).ToList();
}
catch (Exception ex)
{
throw new Exception(String.Format("ContentsBO.SelectContents_ByCode_002: {0}", ex.Message));
}
}
public List<vw_ContentsViewAll> Sel_Ext_ByKeyCodeContents_ByIDLang(string Key, int IDLang, bool Disable)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
string Code = aConfigsBO.Sel_ByAccessKey(Key).Value;
return this.aDatabaseDA.vw_ContentsViewAll.Where(p => p.Contents_Code == Code).Where(p => p.Contents_CategoryLevel1_IDLang == IDLang).Where(p => p.Contents_Disable == Disable).ToList();
}
catch (Exception ex)
{
throw new Exception(String.Format("ContentsBO.SelectContents_ByCode_002: {0}", ex.Message));
}
}
public List<vw_ContentsViewAll> Sel_Ext_ByKeyCodeCategoryLevel1(string Key)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
string Code = aConfigsBO.Sel_ByAccessKey(Key).Value;
return this.aDatabaseDA.vw_ContentsViewAll.Where(p => p.CategoryLevel1_Code == Code).ToList();
}
catch (Exception ex)
{
throw new Exception(String.Format("ContentsBO.Sel_ByKeyCodeCategoryLevel1_ByIDLang: {0}", ex.Message));
}
}
private void Sel_ByAccessKey(HttpContext context)
{
string jSonString = string.Empty;
ConfigsBO configsBO = new ConfigsBO();
string accessKey = context.Request.QueryString["AccessKey"];
bool disable = !String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
List<Configs> listConfigs = String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? configsBO.Sel_ByAccessKey(accessKey)
: configsBO.Sel_ByAccessKey(accessKey, disable);
if (listConfigs.Any()) {
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(listConfigs, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
//KhoiDT select content by code cat 1
//=============================================================================================
public List<vw_ContentsViewAll> Sel_Ext_ByKeyCodeCategoryLevel1_ByIDLang(string Key, int IDLang)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
List<Configs> ListConfigs = aConfigsBO.Sel_ByAccessKey(Key);
List<string> ListCode = new List<string>();
for (int i = 0; i < ListConfigs.Count; i++)
{
ListCode.Add(ListConfigs[i].Value.ToString());
}
string ListCodeTempt = String.Join(",", ListCode);
//return this.aDatabaseDA.vw_CategoryLevel1ViewAll.Where(p => p.CategoryLevel1_Code.Contains(ListCodeTempt)).Where(p => p.CategoryLevel1_CategoryLevel2_IDLang == IDLang).ToList();
return this.aDatabaseDA.vw_ContentsViewAll.Where(p => ListCodeTempt.Contains(p.CategoryLevel1_Code)).Where(p => p.Contents_CategoryLevel1_IDLang == IDLang).ToList();
}
catch (Exception ex)
{
throw new Exception(String.Format("ContentsBO.Sel_ByKeyCodeCategoryLevel1_ByIDLang: {0}", ex.Message));
}
}
