//--------------// 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); } }