public void Upd_ByCode(HttpContext context, int NUM_LANG) { int ret = -1; String jSonString = ""; try { if (NUM_LANG < 1) { NUM_LANG = 1; } List<CategoryLevel1> aListCategoryLevel1 = new List<CategoryLevel1>(); CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO(); String Code = context.Request.Form["txtCode"]; aListCategoryLevel1 = aCategoryLevel1BO.Sel_ByCode(Code); int LoopUpdate = 0; if (aListCategoryLevel1.Count <= NUM_LANG) { LoopUpdate = aListCategoryLevel1.Count; for (int i = 0; i < LoopUpdate; i++) { aListCategoryLevel1[i].ID = aListCategoryLevel1[i].ID; aListCategoryLevel1[i].Code = aListCategoryLevel1[i].Code; aListCategoryLevel1[i].IDLang = aListCategoryLevel1[i].IDLang; aListCategoryLevel1[i].Type = !String.IsNullOrEmpty(context.Request.Form["cbbType"]) ? Convert.ToInt32(context.Request.Form["cbbType"]) : aListCategoryLevel1[i].Type; aListCategoryLevel1[i].ViewCount = !String.IsNullOrEmpty(context.Request.Form["txtViewCount"]) ? Convert.ToInt64(context.Request.Form["txtViewCount"]) : 0; aListCategoryLevel1[i].Status = !String.IsNullOrEmpty(context.Request.Form["cbbStatus"]) ? Convert.ToInt32(context.Request.Form["cbbStatus"]) : aListCategoryLevel1[i].Status; aListCategoryLevel1[i].Disable = !String.IsNullOrEmpty(context.Request.Form["cbbDisable"]) ? Convert.ToBoolean(context.Request.Form["cbbDisable"]) : aListCategoryLevel1[i].Disable; aListCategoryLevel1[i].Tag = !String.IsNullOrEmpty(context.Request.Form["txtTag"]) ? Convert.ToString(context.Request.Form["txtTag"]) : aListCategoryLevel1[i].Tag; aListCategoryLevel1[i].IDAlbum = !String.IsNullOrEmpty(context.Request.Form["cbbIDAlbum"]) ? Convert.ToInt32(context.Request.Form["cbbIDAlbum"]) : aListCategoryLevel1[i].IDAlbum; aListCategoryLevel1[i].Image = !String.IsNullOrEmpty(context.Request.Form["txtImage_1"]) ? Convert.ToString(context.Request.Form["txtImage_1"]) : ""; aListCategoryLevel1[i].Image1 = !String.IsNullOrEmpty(context.Request.Form["txtImage_2"]) ? Convert.ToString(context.Request.Form["txtImage_2"]) : ""; aListCategoryLevel1[i].Image2 = !String.IsNullOrEmpty(context.Request.Form["txtImage_3"]) ? Convert.ToString(context.Request.Form["txtImage_3"]) : ""; aListCategoryLevel1[i].Image3 = !String.IsNullOrEmpty(context.Request.Form["txtImage_4"]) ? Convert.ToString(context.Request.Form["txtImage_4"]) : ""; aListCategoryLevel1[i].CategoryNameLevel1 = !String.IsNullOrEmpty(context.Request.Form["txtCategoryNameLevel1_Lang" + (i + 1)]) ? Convert.ToString(context.Request.Form["txtCategoryNameLevel1_Lang" + (i + 1)]) : aListCategoryLevel1[i].CategoryNameLevel1; aListCategoryLevel1[i].Note = !String.IsNullOrEmpty(context.Request.Form["txtNote_Lang" + (i + 1)]) ? Convert.ToString(context.Request.Form["txtNote_Lang" + (i + 1)]) : aListCategoryLevel1[i].Note; aListCategoryLevel1[i].Intro = !String.IsNullOrEmpty(context.Request.Form["txtIntro_Lang" + (i + 1)]) ? Convert.ToString(context.Request.Form["txtIntro_Lang" + (i + 1)]) : aListCategoryLevel1[i].Intro; aListCategoryLevel1[i].Info = !String.IsNullOrEmpty(context.Request.Form["txtInfo_Lang" + (i + 1)]) ? Convert.ToString(context.Request.Form["txtInfo_Lang" + (i + 1)]) : aListCategoryLevel1[i].Info; ret = aCategoryLevel1BO.Upd(aListCategoryLevel1); if (ret == 0) { jSonString = "{\"status\":\"error|" + ret.ToString() + "\"}"; break; } } if (ret != 0) { jSonString = "{\"status\": \"success\"}"; } } } catch (Exception ex) { jSonString = "{\"status\":\"error\" ,\"message\":\"" + ex.Message.ToString() + "\"}"; } finally { context.Response.Write(jSonString); } }
public void Sel_ByCode(HttpContext context) { String jSonString = ""; string Code = context.Request.QueryString["Code"]; bool Disable = !String.IsNullOrEmpty(context.Request.QueryString["Disable"]) ? Convert.ToBoolean(context.Request.QueryString["Disable"]) : false; CategoryLevel1BO aCategoryLevel1BO = new CategoryLevel1BO(); List<CategoryLevel1> obj = String.IsNullOrEmpty(context.Request.QueryString["Disable"]) ? aCategoryLevel1BO.Sel_ByCode(Code) : aCategoryLevel1BO.Sel_ByCode(Code, Disable); if (obj != null) { _converter.DateTimeFormat = "dd/MM/yyyy"; jSonString = JsonConvert.SerializeObject(obj, _converter); } jSonString = "{\"data\":" + jSonString + "}"; 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); } }