Пример #1
0
        public void CloneDqMetaGroup(int currentId, List <country> listLanguage)
        {
            var index     = 0;
            var proMaster = db.metagrups.FirstOrDefault(x => x.METAGROUPNO == currentId);

            if (proMaster != null)
            {
                foreach (var itemlang in listLanguage)
                {
                    if (proMaster.CodeLanguage != itemlang.language.ToLower())
                    {
                        var check = db.metagrups.FirstOrDefault(x => x.IdCurrentItem == currentId && x.CodeLanguage == itemlang.language.ToLower());
                        if (check == null)
                        {
                            var matagroup = new metagrup
                            {
                                PARENTNO      = proMaster.PARENTNO,
                                IsActive      = proMaster.IsActive,
                                CREATED       = proMaster.CREATED,
                                METAGROUPNAME = proMaster.METAGROUPNAME,
                                METAGROUPCODE = proMaster.METAGROUPCODE,
                                CodeLanguage  = itemlang.language.ToLower(),
                                IdCurrentItem = proMaster.METAGROUPNO
                            };
                            db.metagrups.Add(matagroup);
                        }
                    }
                }
                db.SaveChanges();
            }
        }
Пример #2
0
        public JsonResult UpdateStatus(string status, string[] ids)
        {
            var  _ids    = ids.Select(t => int.Parse(t)).ToList();
            bool _status = false;
            var  msg     = "Update Success";

            try
            {
                var _items = db.metagrups.Where(x => _ids.Contains(x.METAGROUPNO));
                foreach (var item in _items)
                {
                    var list = db.metagrups.Where(x => x.IdCurrentItem == item.METAGROUPNO).ToList();
                    foreach (var item1 in list)
                    {
                        metagrup metagrup = db.metagrups.Find(item1.METAGROUPNO);
                        metagrup.IsActive        = false;
                        db.Entry(metagrup).State = EntityState.Modified;
                    }
                }
                db.SaveChanges();
                _status = true;
            }
            catch (Exception)
            {
                msg = "Update Failed";
            }
            return(Json(new { status = _status, mgs = msg }));
        }
Пример #3
0
        public ActionResult CreateMetaGroup(AllModel model, HttpPostedFileBase[] inputfile)
        {
            if (model.tblMetaGroupArray != null)
            {
                var matagroup = new metagrup();
                matagroup.PARENTNO      = model.tblMetaGroup.PARENTNO;
                matagroup.IsActive      = model.tblMetaGroup.IsActive;
                matagroup.CREATED       = DateTime.Now;
                matagroup.METAGROUPNAME = model.tblMetaGroupArray[0].METAGROUPNAME;
                matagroup.METAGROUPCODE = model.tblMetaGroupArray[0].METAGROUPCODE;
                matagroup.CodeLanguage  = "english";
                db.metagrups.Add(matagroup);
                db.SaveChanges();
                var updatematagroup = db.metagrups.Find(matagroup.METAGROUPNO);
                updatematagroup.IdCurrentItem   = matagroup.METAGROUPNO;
                db.Entry(updatematagroup).State = EntityState.Modified;
                db.SaveChanges();
                foreach (var item in model.tblMetaGroupArray.Skip(1).ToList())
                {
                    item.PARENTNO      = model.tblMetaGroup.PARENTNO;
                    item.IsActive      = model.tblMetaGroup.IsActive;
                    item.CREATED       = DateTime.Now;
                    item.IdCurrentItem = updatematagroup.IdCurrentItem;
                    db.metagrups.Add(item);
                }
                db.SaveChanges();
                if (inputfile != null)
                {
                    for (int i = 0; i < inputfile.Length; i++)
                    {
                        if (inputfile[i] != null)
                        {
                            var fname = matagroup.IdCurrentItem + "." +
                                        inputfile[i].FileName.Split('.').Last();
                            string path = Server.MapPath("~/Content/MetagroupImage");
                            if (!Directory.Exists(path))
                            {
                                Directory.CreateDirectory(path);
                            }
                            path = Path.Combine(path + "/", fname);
                            inputfile[i].SaveAs(path);
                        }
                    }
                }
            }

            return(RedirectToAction("IndexMetaGroup"));
        }
Пример #4
0
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            var list = db.metagrups.Where(x => x.IdCurrentItem == id).ToList();

            foreach (var item in list)
            {
                metagrup metagrup = db.metagrups.Find(item.METAGROUPNO);
                metagrup.IsActive        = false;
                db.Entry(metagrup).State = EntityState.Modified;
            }

            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Пример #5
0
        public ActionResult EditMetaGroup(int code)
        {
            var listMasterMetaGroup = db.metagrups.Where(x => x.PARENTNO == 0).ToList();

            listMasterMetaGroup.Insert(0, new metagrup {
                METAGROUPNO = 0, METAGROUPNAME = "Select Master Meta Group"
            });
            ViewBag.ListMasterMetaGroup = listMasterMetaGroup;
            var proMaster = db.metagrups.FirstOrDefault(x => x.METAGROUPNO == code);

            var list = db.countries.Where(x => x.status == 1 && x.islanguage == 1).ToList();

            ViewBag.ListCountry = list;
            foreach (var itemLang in list)
            {
                var pro = db.metagrups.FirstOrDefault(x => x.IdCurrentItem == code && x.CodeLanguage == itemLang.language.ToLower());
                if (pro == null)
                {
                    if (proMaster != null)
                    {
                        var tblItem = new metagrup();
                        tblItem.CREATED       = proMaster.CREATED;
                        tblItem.LASTCHANGE    = proMaster.LASTCHANGE;
                        tblItem.METAGROUPCODE = proMaster.METAGROUPCODE;
                        tblItem.METAGROUPNAME = proMaster.METAGROUPNAME;
                        tblItem.IsActive      = proMaster.IsActive;
                        tblItem.PARENTNO      = proMaster.METAGROUPNO;
                        tblItem.CodeLanguage  = itemLang.language.ToLower();
                        tblItem.IdCurrentItem = proMaster.IdCurrentItem;
                        db.metagrups.Add(tblItem);
                    }
                }
            }
            db.SaveChanges();
            var listCode = list.Select(y => y.language.ToLower()).ToList();

            var item = db.metagrups.ToList().Where(x => x.IdCurrentItem == code && listCode.Contains(x.CodeLanguage)).ToList();

            return(View(new AllModel {
                listMetaGroup = item, tblMetaGroup = proMaster
            }));
        }