private void Upd_Disable_ByID(HttpContext context)
{
String jSonString = "";
try {
ConfigsBO configsBo = new ConfigsBO();
int id = Convert.ToInt32(context.Request.QueryString["ID"]);
bool disable = Convert.ToBoolean(context.Request.QueryString["Disable"]);
int ret = configsBo.Upd_Disable(id, disable);
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);
}
}
private void Del_ByID(HttpContext context)
{
String jSonString = "";
try {
int idConfigs = Convert.ToInt32(context.Request.QueryString["ID"]);
ConfigsBO configsBO = new ConfigsBO();
int ret = configsBO.Del(idConfigs);
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);
}
}
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);
}
}
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);
}
}
private void Sel(HttpContext context)
{
string jSonString = string.Empty;
ConfigsBO configsBO = new ConfigsBO();
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()
: configsBO.Sel(disable);
if (listConfigs.Any())
{
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(listConfigs, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
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_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);
}
//
//-------- 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 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_StaticDataLanguage_Page(HttpContext Context, 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);
}
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 + "\\FRAMEWORK\\StaticLanguage.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.CurrentPage.Session[key_LANG_DATA] = List_ItemLang; // Ngôn ngữ dành cho trang ASPX
return(jSonString);
}
