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 static void INIT(string SystemKey)
{
CORE.SYSTEM.SystemKey = SystemKey;
ConfigsBO aConfigsBO = new ConfigsBO();
CORE.SYSTEM.ListConfig = aConfigsBO.Select_All().Where(p => p.Group == CORE.SYSTEM.SystemKey.ToString()).ToList();
CORE.CONSTANTS.LoadAllConstant();
}
private void frmUpd_Configs_Load(object sender, EventArgs e)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
Configs aConfigs = aConfigsBO.Select_ByID(ID);
txtAccessKey.Text = aConfigs.AccessKey;
txtValue.Text = aConfigs.Value;
cboStatus.Text = aConfigs.Status.ToString();
cboType.Text = aConfigs.Type.ToString();
cboGroup.Text = aConfigs.Group.ToString();
}
catch (Exception ex)
{
MessageBox.Show("frmUpd_Configs.frmUpd_Configs_Load\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
int ID = Convert.ToInt32(viewConfigs.GetFocusedRowCellValue("ID"));
DialogResult result = MessageBox.Show("Bạn có chắc chắn muốn xóa ???", "Câu hỏi", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (DialogResult.Yes == result)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
aConfigsBO.Delete(ID);
MessageBox.Show("Bạn đã xóa dữ liệu thành công .", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("frmLst_Configs.btnDelete_ButtonClick\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
LoadDataConfigs(AccessKey);
}
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));
}
}
private void btnAddNew_Click(object sender, EventArgs e)
{
try
{
string accessKey = txtAccessKey.Text;
string value = txtValue.Text;
if (accessKey.Length > 250)
{
txtAccessKey.Focus();
MessageBox.Show("AccessKey chỉ được phép nhập tối đa 250 ký tự .", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (value.Length > 250)
{
txtValue.Focus();
MessageBox.Show("Giá trị chỉ được phép nhập tối đa 250 ký tự .", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
ConfigsBO aConfigBO = new ConfigsBO();
Configs aConfigs = new Configs();
aConfigs.AccessKey = accessKey;
aConfigs.Value = value;
aConfigs.Status = cboStatus.SelectedIndex + 1;
aConfigs.Type = cboType.SelectedIndex + 1;
aConfigs.Group = (cboGroup.SelectedIndex + 1).ToString();
aConfigBO.Insert(aConfigs);
MessageBox.Show("Thêm mới thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
if(this.afrmLst_Configs !=null)
{
this.afrmLst_Configs.LoadDataConfigs(AccessKey);
}
}
}
catch (Exception ex)
{
MessageBox.Show("frmIns_Configs.btnAddNew_Click\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
ConfigsBO aConfigsBO = new ConfigsBO();
Configs aConfigs = new Configs();
aConfigs.ID = ID;
aConfigs.AccessKey = txtAccessKey.Text;
aConfigs.Value = txtValue.Text;
aConfigs.Status = cboStatus.SelectedIndex + 1;
aConfigs.Type = cboType.SelectedIndex + 1;
aConfigs.Group = (cboGroup.SelectedIndex + 1).ToString();
aConfigsBO.Update(aConfigs);
MessageBox.Show("Cập nhật dữ liệu thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
this.afrmLst_Configs.LoadDataConfigs(AccessKey);
}
catch(Exception ex)
{
MessageBox.Show("frmUpd_Configs.btnSave_Click\n" + ex.ToString(), "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void LoadDataConfigs(string AccessKey)
{
try
{
ConfigsBO aConfigBO = new ConfigsBO();
List<Configs> aListConfigs = new List<Configs>();
if (AccessKey == null)
{
aListConfigs = aConfigBO.Select_All();
}
else
{
aListConfigs = aConfigBO.SearchListConfigs_ByAccessKey(AccessKey);
}
dgvConfigs.DataSource = aListConfigs;
}
catch (Exception ex)
{
MessageBox.Show("frmLst_Configs.LoadDataConfigs\n" + ex.ToString());
}
}
private void Sel_ByType_ByStatus(HttpContext context)
{
String jSonString = "";
ConfigsBO configsBO = new ConfigsBO();
int type = Convert.ToInt32(context.Request.QueryString["Type"]);
int status = Convert.ToInt32(context.Request.QueryString["Status"]);
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_ByType_ByStatus(type, status)
: configsBO.Sel_ByType_ByStatus(type, status, disable);
if (listConfigs.Any()) {
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(listConfigs, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
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_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));
}
}
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 void Sel_ByCodeCategoryLevel2(HttpContext context, int IDLang)
{
ConfigsBO aConfigsBO = new ConfigsBO();
String jSonString = "";
string CodeCategoryLevel2 = "";
CodeCategoryLevel2 = context.Request.QueryString["CodeCat2"];
CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
//List<CategoryLevel1> obj = aCategoryLevel1BO.Sel_ByIDLang(IDLang).Where(p => !p.CodeCategoryLevel2.Contains(CodeCategoryLevel2)).ToList<CategoryLevel1>();
List<vw_CategoryLevel1ViewAll> obj = aCategoryLevel1BO.Sel_Ext_ByCodeCategoryLevel2(CodeCategoryLevel2).ToList();
if (obj != null)
{
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(obj, _converter);
}
jSonString = "{\"CategoryLevel1s\":" + 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));
}
}
//
//-------- 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);
}
}
private void Sel_ByID(HttpContext context)
{
string jSonString = string.Empty;
ConfigsBO configsBO = new ConfigsBO();
int id = Convert.ToInt32(context.Request.QueryString["ID"]);
bool disable = !String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? Convert.ToBoolean(context.Request.QueryString["Disable"])
: false;
Configs configs = String.IsNullOrEmpty(Convert.ToString(context.Request.QueryString["Disable"]))
? configsBO.Sel_ByID(id)
: configsBO.Sel_ByID(id, disable);
if (configs != null) {
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(configs, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
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);
}
private void Ins(HttpContext context)
{
String jSonString = "";
try {
Configs aConfigs = new Configs {
AccessKey =
!String.IsNullOrEmpty(context.Request.Form["txtAccessKey"])
? Convert.ToString(context.Request.Form["txtAccessKey"])
: "",
Value =
!String.IsNullOrEmpty(context.Request.Form["txtValue"])
? Convert.ToString(context.Request.Form["txtValue"])
: "",
Status =
!String.IsNullOrEmpty(context.Request.Form["cbbStatus"])
? Convert.ToInt32(context.Request.Form["cbbStatus"])
: 0,
Type =
!String.IsNullOrEmpty(context.Request.Form["cbbType"])
? Convert.ToInt32(context.Request.Form["cbbType"])
: 0,
Group =
!String.IsNullOrEmpty(context.Request.Form["cbbGroup"])
? Convert.ToInt32(context.Request.Form["cbbGroup"])
: 0,
Note =
!String.IsNullOrEmpty(context.Request.Form["txtNote"])
? Convert.ToString(context.Request.Form["txtNote"])
: "",
Image =
!String.IsNullOrEmpty(context.Request.Form["txtImage_1"])
? Convert.ToString(context.Request.Form["txtImage_1"])
: "",
Disable =
!String.IsNullOrEmpty(context.Request.Form["cbbDisable"])
? Convert.ToBoolean(context.Request.Form["cbbDisable"])
: false,
};
ConfigsBO configsBO = new ConfigsBO();
int ret = configsBO.Ins(aConfigs);
if (ret != 0) jSonString = "{\"status\": \"success\"}";
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
public void Ins(HttpContext context, int NUM_LANG)
{
ConfigsBO aConfigsBO = new ConfigsBO();
//CodeCategoryLevel1 = Convert.ToString(context.Request.Form["txtCodeCategoryLevel1"]);
String jSonString = "";
try
{
List<ExtendProperties> aListExtendProperties = new List<ExtendProperties>();
ExtendPropertiesBO aExtendPropertiesBO = new ExtendPropertiesBO();
ExtendProperties aExtendProperties = new ExtendProperties();
TimeSpan Codespan = new TimeSpan(DateTime.Now.Ticks);
string Code = Math.Floor(Codespan.TotalSeconds).ToString();
for (int i = 1; i <= NUM_LANG; i++)
{
aExtendProperties = new ExtendProperties();
aExtendProperties.Code = Code;
//aContents.Data = null;
aExtendProperties.Name = !String.IsNullOrEmpty(context.Request.Form["txtName"]) ? Convert.ToString(context.Request.Form["txtName"]) : "";
aExtendProperties.Value = !String.IsNullOrEmpty(context.Request.Form["txtValue"]) ? Convert.ToString(context.Request.Form["txtValue"]) : "";
aExtendProperties.ValueType = !String.IsNullOrEmpty(context.Request.Form["cbbValueType"]) ? Convert.ToInt32(context.Request.Form["cbbValueType"]) : 0;
aExtendProperties.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage"]) ? Convert.ToString(context.Request.Form["txtImage"]) : "";
aExtendProperties.Code = Code;
aExtendProperties.IDObject = !String.IsNullOrEmpty(context.Request.Form["cbbIDObject"]) ? Convert.ToInt32(context.Request.Form["cbbIDObject"]) : 0;
aExtendProperties.ObjectType = !String.IsNullOrEmpty(context.Request.Form["cbbObjectType"]) ? Convert.ToInt32(context.Request.Form["cbbObjectType"]) : 0;
aExtendProperties.IDLang = !String.IsNullOrEmpty(context.Request.Form["IDLang_" + i]) ? Convert.ToInt32(context.Request.Form["IDLang_" + i]) : 0;
aExtendProperties.Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"]) ? Convert.ToInt32(context.Request.Form["cbbType"]) : 0;
aExtendProperties.Group = !String.IsNullOrEmpty(context.Request.Form["cbbGroup"]) ? Convert.ToInt32(context.Request.Form["cbbGroup"]) : 0;
aExtendProperties.Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"]) ? Convert.ToInt32(context.Request.Form["cbbStatus"]) : 0;
aExtendProperties.CodeObject = !String.IsNullOrEmpty(context.Request.Form["cbbCodeObject"]) ? Convert.ToInt32(context.Request.Form["cbbCodeObject"]) : 0;
//aContents.CreatedBy = aCurrentSystemUsers.Username;
aExtendProperties.Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"]) ? Convert.ToBoolean(context.Request.Form["cbbDisable"]) : false;
//aContents.Tag = !String.IsNullOrEmpty(context.Request.Form["txtTag"]) ? Convert.ToString(context.Request.Form["txtTag"]) : "";
//aContents.DateCreated = !String.IsNullOrEmpty(context.Request.FormCodeObjecttxtDateCreated"]) ? DateTime.ParseExact(context.Request.Form["txtDateCreated"], "dd/MM/yyyy", culture) : DateTime.Now;
//aContents.DateEdited = !String.IsNullOrEmpty(context.Request.Form["txtDateEdited"]) ? DateTime.ParseExact(context.Request.Form["txtDateEdited"], "dd/MM/yyyy", culture) : DateTime.Now;
//aContents.UpdateBy = !String.IsNullOrEmpty(context.Request.Form["txtUpdateBy"]) ? Convert.ToString(context.Request.Form["txtUpdateBy"]) : "";
//aContents.PublishDate = !String.IsNullOrEmpty(context.Request.Form["txtPublishDate"]) ? DateTime.ParseExact(context.Request.Form["txtPublishDate"], "dd/MM/yyyy", culture) : DateTime.Now;
//aContents.ExpireDate = !String.IsNullOrEmpty(context.Request.Form["txtExpireDate"]) ? DateTime.ParseExact(context.Request.Form["txtExpireDate"], "dd/MM/yyyy", culture) : DateTime.Now;
//aContents.IDAlbum = !String.IsNullOrEmpty(context.Request.Form["txtIDAlbum"]) ? Convert.ToInt32(context.Request.Form["txtIDAlbum"]) : 0;
//aContents.ViewCount = !String.IsNullOrEmpty(context.Request.Form["txtViewCount"]) ? Convert.ToInt64(context.Request.Form["txtViewCount"]) : 0;
aExtendProperties.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage"]) ? Convert.ToString(context.Request.Form["txtImage"]) : "";
//aContents.Image2 = !String.IsNullOrEmpty(context.Request.Form["txtImage_3"]) ? Convert.ToString(context.Request.Form["txtImage_3"]) : "";
//aContents.Image3 = !String.IsNullOrEmpty(context.Request.Form["txtImage_4"]) ? Convert.ToString(context.Request.Form["txtImage_4"]) : "";
//aContents.Title = !String.IsNullOrEmpty(context.Request.Form["txtTitle_Lang" + i]) ? Convert.ToString(context.Request.Form["txtTitle_Lang" + i]) : "";
//aContents.Intro = !String.IsNullOrEmpty(context.Request.Form["txtIntro_Lang" + i]) ? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtIntro_Lang" + i])) : "";
//aContents.Info = !String.IsNullOrEmpty(context.Request.Form["txtInfo_Lang" + i]) ? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtInfo_Lang" + i])) : "";
//aContents.ExtendProperties1 = !String.IsNullOrEmpty(context.Request.Form["txtExtendProperties1_Lang" + i]) ? Convert.ToString(context.Request.Form["txtExtendProperties1_Lang" + i]) : "";
//aContents.ExtendProperties2 = !String.IsNullOrEmpty(context.Request.Form["txtExtendProperties2_Lang" + i]) ? Convert.ToString(context.Request.Form["txtExtendProperties2_Lang" + i]) : "";
//aContents.ExtendProperties3 = !String.IsNullOrEmpty(context.Request.Form["txtExtendProperties3_Lang" + i]) ? Convert.ToString(context.Request.Form["txtExtendProperties3_Lang" + i]) : "";
//aContents.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"]) ? Convert.ToString(context.Request.Form["txtImage_1"]) : "";
aListExtendProperties.Add(aExtendProperties);
}
int Ret1 = -1;
Ret1 = aExtendPropertiesBO.Ins(ref aListExtendProperties);
//if (Ret1 < aListExtendProperties.Count)
//{
// jSonString = "{\"status\":\"error\" ,\"message\":\"" + Ret1.ToString() + "\"}";
// aExtendPropertiesBO.Del(aListExtendProperties);
// return;
//}
//else
//{
// string ListTempt = !String.IsNullOrEmpty(context.Request.Form["ckbCodeCategoryLevel1[]"]) ? Convert.ToString(context.Request.Form["ckbCodeCategoryLevel1[]"]) : "";
// if (string.IsNullOrEmpty(ListTempt) == true)
// {
// CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO();
// List<CategoryLevel1> aListItem = aCategoryLevel1BO.Sel_ByCode("000");
// if (aListItem.Count > 0)
// {
// ListTempt = aListItem[0].Code;
// }
// else
// {
// this.CreateCategoryLevel1Default(context, "[Default]", NUM_LANG);
// ListTempt = "000";
// }
// }
// //else if (string.IsNullOrEmpty(ListTempt) == false)
// //{
// List<string> ListCodeCategoryLevel1 = ListTempt.Split(',').ToList();
// List<Contents_CategoryLevel1> aListContents_CategoryLevel1 = new List<Contents_CategoryLevel1>();
// Contents_CategoryLevel1 aContents_CategoryLevel1 = new Contents_CategoryLevel1();
// for (int ii = 0; ii < aListContents.Count; ii++)
// {
// for (int iii = 0; iii < ListCodeCategoryLevel1.Count; iii++)
// {
// aContents_CategoryLevel1 = new Contents_CategoryLevel1();
// aContents_CategoryLevel1.CodeCategoryLevel1 = ListCodeCategoryLevel1[iii].ToString();
// aContents_CategoryLevel1.CodeContents = aListContents[ii].Code.ToString();
// aContents_CategoryLevel1.Disable = aListContents[ii].Disable;
// aContents_CategoryLevel1.IDLang = aListContents[ii].IDLang;
// aContents_CategoryLevel1.Status = aListContents[ii].Status;
// aContents_CategoryLevel1.Type = aListContents[ii].Type;
// aListContents_CategoryLevel1.Add(aContents_CategoryLevel1);
// }
// }
// Contents_CategoryLevel1BO aContents_CategoryLevel1BO = new Contents_CategoryLevel1BO();
// int Ret2 = -1;
// Ret2 = aContents_CategoryLevel1BO.Ins(ref aListContents_CategoryLevel1);
// if (Ret2 < aListContents_CategoryLevel1.Count)
// {
// aContents_CategoryLevel1BO.Del(aListContents_CategoryLevel1);
// aContentsBO.Del(aListContents);
// jSonString = "{\"status\":\"error\" ,\"message\":\"" + Ret2.ToString() + "\"}";
// return;
// }
// //}
//}
jSonString = "{\"status\": \"success\"}";
}
catch (Exception ex)
{
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message.ToString() + "\"}";
}
finally
{
context.Response.Write(jSonString);
}
}
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;
}
private void Upd_ByID(HttpContext context)
{
String jSonString = "";
try {
int idConfigs = Convert.ToInt32(context.Request.Form["txtID"]);
ConfigsBO configsBO = new ConfigsBO();
Configs aConfigs = configsBO.Sel_ByID(idConfigs);
aConfigs.ID = idConfigs;
aConfigs.AccessKey = !String.IsNullOrEmpty(context.Request.Form["txtAccessKey"])
? Convert.ToString(context.Request.Form["txtAccessKey"])
: aConfigs.AccessKey;
aConfigs.Value = !String.IsNullOrEmpty(context.Request.Form["txtValue"])
? Convert.ToString(context.Request.Form["txtValue"])
: aConfigs.Value;
aConfigs.Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"])
? Convert.ToInt32(context.Request.Form["cbbStatus"])
: aConfigs.Status;
aConfigs.Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"])
? Convert.ToInt32(context.Request.Form["cbbType"])
: aConfigs.Type;
aConfigs.Group = !String.IsNullOrEmpty(context.Request.Form["cbbGroup"])
? Convert.ToInt32(context.Request.Form["cbbGroup"])
: aConfigs.Group;
aConfigs.Note = !String.IsNullOrEmpty(context.Request.Form["txtNote"])
? Convert.ToString(context.Request.Form["txtNote"])
: aConfigs.Note;
aConfigs.Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"])
? Convert.ToBoolean(context.Request.Form["cbbDisable"])
: aConfigs.Disable;
aConfigs.Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"])
? Convert.ToString(context.Request.Form["txtImage_1"])
: aConfigs.Image;
int ret = configsBO.Upd(aConfigs);
if (ret != 0) jSonString = "{\"status\": \"success\"}";
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
//===================================================================================================
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));
}
}
private void Upd_Type_ByID(HttpContext context)
{
String jSonString = "";
try {
ConfigsBO configsBo = new ConfigsBO();
int id = Convert.ToInt32(context.Request.QueryString["ID"]);
int type = Convert.ToInt32(context.Request.QueryString["Type"]);
int ret = configsBo.Upd_Type(id, type);
if (ret == 0) jSonString = "{\"status\":\"error|" + ret + "\"}";
if (ret != 0) jSonString = "{\"status\": \"success\"}";
}
catch (Exception ex) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message + "\"}";
}
finally {
context.Response.Write(jSonString);
}
}
