//--------------//
public void Sel_ByCodeContents_ByIDLang(HttpContext context)
{
String jSonString = "";
Contents_CategoryLevel1BO aContents_CategoryLevel1BO = new Contents_CategoryLevel1BO();
int IDLang = string.IsNullOrEmpty(context.Request.QueryString["IDLang"]) ? CORE_Language.sys_CUR_LANG : int.Parse(context.Request.QueryString["IDLang"]);
string CodeContents = string.IsNullOrEmpty(context.Request.QueryString["CodeContents"]) ? "000" : context.Request.QueryString["CodeContents"].ToString() ;
List<Contents_CategoryLevel1> obj = aContents_CategoryLevel1BO.Sel_ByCodeContents_ByIDLang(CodeContents,IDLang).ToList();
if (obj != null)
{
_converter.DateTimeFormat = "dd/MM/yyyy";
jSonString = JsonConvert.SerializeObject(obj, _converter);
}
jSonString = "{\"data\":" + jSonString + "}";
context.Response.Write(jSonString);
}
//TODO: hàm này có vấn đề
public void Upd_ByCode(HttpContext context, int NUM_LANG)
{
string jSonString = string.Empty;
try{
if (NUM_LANG < 1) NUM_LANG = 1;
ContentsBO aContentsBO = new ContentsBO();
String code = context.Request.Form["txtCode"];
var aListContents = aContentsBO.Sel_ByCode(code);
if (aListContents.Count <= NUM_LANG){
for (int i = 0; i < aListContents.Count; i++){
aListContents[i].UpdateBy = aCurrentSystemUsers.Username;
aListContents[i].Type = !String.IsNullOrEmpty(context.Request.Form["txtType"])
? Convert.ToInt32(context.Request.Form["txtType"])
: aListContents[i].Type;
aListContents[i].Title = !String.IsNullOrEmpty(context.Request.Form["txtTitle_Lang" + (i + 1)])
? Convert.ToString(context.Request.Form["txtTitle_Lang" + (i + 1)])
: aListContents[i].Title;
aListContents[i].Info = !String.IsNullOrEmpty(context.Request.Form["txtInfo_Lang" + (i + 1)])
? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtInfo_Lang" + (i + 1)]))
: aListContents[i].Info;
aListContents[i].Intro = !String.IsNullOrEmpty(context.Request.Form["txtIntro_Lang" + (i + 1)])
? Convert.ToString(HttpUtility.HtmlDecode(context.Request.Form["txtIntro_Lang" + (i + 1)]))
: aListContents[i].Intro;
aListContents[i].Status = !String.IsNullOrEmpty(context.Request.Form["ddlStatus"])
? Convert.ToInt32(context.Request.Form["ddlStatus"])
: aListContents[i].Status;
aListContents[i].CreatedBy = !String.IsNullOrEmpty(context.Request.Form["txtCreatedBy"])
? Convert.ToString(context.Request.Form["txtCreatedBy"])
: aListContents[i].CreatedBy;
aListContents[i].Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"])
? Convert.ToBoolean(context.Request.Form["cbbDisable"])
: aListContents[i].Disable;
aListContents[i].Tag = !String.IsNullOrEmpty(context.Request.Form["txtTag"])
? Convert.ToString(context.Request.Form["txtTag"])
: aListContents[i].Tag;
aListContents[i].DateCreated = !String.IsNullOrEmpty(context.Request.Form["dtpDateCreated"])
? DateTime.ParseExact(context.Request.Form["dtpDateCreated"], "dd/MM/yyyy", culture)
: aListContents[i].DateCreated;
aListContents[i].DateEdited = !String.IsNullOrEmpty(context.Request.Form["dtpDateEdited"])
? DateTime.ParseExact(context.Request.Form["dtpDateEdited"], "dd/MM/yyyy", culture)
: aListContents[i].DateEdited;
aListContents[i].PublishDate = !String.IsNullOrEmpty(context.Request.Form["dtpPublishDate"])
? DateTime.ParseExact(context.Request.Form["dtpPublishDate"], "dd/MM/yyyy", culture)
: aListContents[i].PublishDate;
aListContents[i].ExpireDate = !String.IsNullOrEmpty(context.Request.Form["dtpExpireDate"])
? DateTime.ParseExact(context.Request.Form["dtpExpireDate"], "dd/MM/yyyy", culture)
: aListContents[i].ExpireDate;
aListContents[i].Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"])
? Convert.ToString(context.Request.Form["txtImage_1"])
: "";
aListContents[i].Image1 = !String.IsNullOrEmpty(context.Request.Form["txtImage_2"])
? Convert.ToString(context.Request.Form["txtImage_2"])
: "";
aListContents[i].Image2 = !String.IsNullOrEmpty(context.Request.Form["txtImage_3"])
? Convert.ToString(context.Request.Form["txtImage_3"])
: "";
aListContents[i].Image3 = !String.IsNullOrEmpty(context.Request.Form["txtImage_4"])
? Convert.ToString(context.Request.Form["txtImage_4"])
: "";
aListContents[i].IDAlbum = !String.IsNullOrEmpty(context.Request.Form["txtIDAlbum"])
? Convert.ToInt32(context.Request.Form["txtIDAlbum"])
: aListContents[i].IDAlbum;
aListContents[i].IDLang =
!String.IsNullOrEmpty(context.Request.Form["IDLanguage_Lang" + (i + 1)])
? Convert.ToInt32(context.Request.Form["IDLanguage_Lang" + (i + 1)])
: aListContents[i].IDLang;
aListContents[i].Code = !String.IsNullOrEmpty(context.Request.Form["txtCode"])
? Convert.ToString(context.Request.Form["txtCode"])
: aListContents[i].Code;
aListContents[i].ExtendProperties1 =
!String.IsNullOrEmpty(context.Request.Form["txtExtendProperties1_Lang" + (i + 1)])
? Convert.ToString(context.Request.Form["txtExtendProperties1_Lang" + (i + 1)])
: aListContents[i].ExtendProperties1;
aListContents[i].ExtendProperties2 =
!String.IsNullOrEmpty(context.Request.Form["txtExtendProperties2_Lang" + (i + 1)])
? Convert.ToString(context.Request.Form["txtExtendProperties2_Lang" + (i + 1)])
: aListContents[i].ExtendProperties2;
aListContents[i].ExtendProperties3 =
!String.IsNullOrEmpty(context.Request.Form["txtExtendProperties3_Lang" + (i + 1)])
? Convert.ToString(context.Request.Form["txtExtendProperties3_Lang" + (i + 1)])
: aListContents[i].ExtendProperties3;
aListContents[i].ViewCount = !String.IsNullOrEmpty(context.Request.Form["txtViewCount"])
? Convert.ToInt64(context.Request.Form["txtViewCount"])
: 0;
}
var ret1 = aContentsBO.Upd(aListContents);
if (!(ret1 >= 0 && ret1 <= NUM_LANG)){
jSonString = "{\"status\":\"error\" ,\"message\":Ret1= " + ret1 + "\"}";
context.Response.Write(jSonString);
return;
}
//TODO: delete all record with CodeContents = content.Code
string listTempt = Convert.ToString(context.Request.Form["ckbCodeCategoryLevel1[]"]);
if (!string.IsNullOrEmpty(listTempt)){
List<string> listString = listTempt.Split(',').ToList();
Contents_CategoryLevel1BO aContents_CategoryLevel1BO = new Contents_CategoryLevel1BO();
List<Contents_CategoryLevel1> listTemp =
aContents_CategoryLevel1BO.Sel_ByCodeContents(aListContents[0].Code);
aContents_CategoryLevel1BO.Del(listTemp);
listTemp.Clear();
listTemp.AddRange(from content in aListContents
from s in listString
select new Contents_CategoryLevel1{
Disable = content.Disable, Status = content.Status, Type = content.Type, CodeContents = content.Code, CodeCategoryLevel1 = s, IDLang = content.IDLang
});
//List<Contents_CategoryLevel1> list = Contents_CategoryLevel1BO.Sel_ByCodeContents()
var ret2 = aContents_CategoryLevel1BO.Upd(listTemp);
jSonString = "{\"status\": \"success\"}";
if (ret2 != listTemp.Count) {
jSonString = "{\"status\":\"error\" ,\"message\":Ret2= " + ret2 + "\"}";
}
}
else{
jSonString = "{\"status\":\"error\" ,\"message\": listTempt is Empty \"}";
}
}
}
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<Contents> aListContents = new List<Contents>();
ContentsBO aContentsBO = new ContentsBO();
Contents aContents = new Contents();
TimeSpan Codespan = new TimeSpan(DateTime.Now.Ticks);
string Code = Math.Floor(Codespan.TotalSeconds).ToString();
for (int i = 1; i <= NUM_LANG; i++) {
aContents = new Contents();
aContents.Code = Code;
aContents.Data = null;
aContents.Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"]) ? Convert.ToInt32(context.Request.Form["cbbType"]) : 0;
aContents.Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"]) ? Convert.ToInt32(context.Request.Form["cbbStatus"]) : 0;
aContents.CreatedBy = aCurrentSystemUsers.Username;
aContents.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.Form["txtDateCreated"]) ? 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;
aContents.Image1 = !String.IsNullOrEmpty(context.Request.Form["txtImage_2"]) ? Convert.ToString(context.Request.Form["txtImage_2"]) : "";
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"]) : "";
aContents.IDLang = !String.IsNullOrEmpty(context.Request.Form["IDLang_" + i]) ? Convert.ToInt32(context.Request.Form["IDLang_" + i]) : 0;
aListContents.Add(aContents);
}
int Ret1 = -1;
Ret1 = aContentsBO.Ins(ref aListContents);
if (Ret1 < aListContents.Count) {
jSonString = "{\"status\":\"error\" ,\"message\":\"" + Ret1.ToString() + "\"}";
aContentsBO.Del(aListContents);
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);
}
}