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();
 }
Example #3
0
        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);
            }
        }