public int Upd(Contents_CategoryLevel1 aContents_CategoryLevel1) { try { aDatabaseDA.Contents_CategoryLevel1.AddOrUpdate(aContents_CategoryLevel1); return aDatabaseDA.SaveChanges(); } catch (Exception ex) { throw new Exception(String.Format("Contents_CategoryLevel1BO.Upd: {0}", ex.Message)); } }
public int Del(Contents_CategoryLevel1 aItem) { this.aDatabaseDA.Contents_CategoryLevel1.Remove(aItem); return aDatabaseDA.SaveChanges(); }
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); } }