예제 #1
0
        public ActionResult CreateLanguage(languages model)
        {
            dbDataContext db = new dbDataContext();

            db.languages.InsertOnSubmit(model);
            db.SubmitChanges();

            return RedirectToAction("LangugeList");
        }
예제 #2
0
        public ActionResult CreateAttribute(FormCollection coll)
        {
            dbDataContext db = new dbDataContext();

            Attributes attr = new Attributes();
            attr.attr_key = Request["attr_key"];

            HttpPostedFileBase file = Request.Files[0];
            MemoryStream ms = new MemoryStream();
            Image img = Image.FromStream(file.InputStream);
            img.Save(ms, img.RawFormat);
            Binary bin = new Binary(ms.ToArray());
            attr.picture = bin;

            db.Attributes.InsertOnSubmit(attr);
            db.SubmitChanges();

            return RedirectToAction("AttributesList");
        }
예제 #3
0
        public ActionResult EditLanguage(languages model)
        {
            dbDataContext db = new dbDataContext();

            languages lang = db.languages.SingleOrDefault(c => c.id == model.id);
            if (lang == null)
            {
                return RedirectToAction("LangugeList");
            }
            lang.language = model.language;
            lang.short_code = model.short_code;

            db.SubmitChanges();

            return RedirectToAction("LangugeList");
        }
예제 #4
0
        public ActionResult EditAttribute(FormCollection coll)
        {
            int id;
            try
            {
                id = Int32.Parse(coll["id"]);
            }
            catch
            {
                return RedirectToAction("AttributesList");
            }
            dbDataContext db = new dbDataContext();

            Attributes attr = db.Attributes.SingleOrDefault(c => c.id == id);
            attr.attr_key = Request["attr_key"];

            HttpPostedFileBase file = Request.Files[0];
            MemoryStream ms = new MemoryStream();
            Image img = Image.FromStream(file.InputStream);
            img.Save(ms, img.RawFormat);
            Binary bin = new Binary(ms.ToArray());
            attr.picture = bin;

            db.SubmitChanges();

            return RedirectToAction("AttributesList");
        }
예제 #5
0
        public ActionResult CreateRegion(Flats.Views.Manage.Region model)
        {
            dbDataContext db = new dbDataContext();

            db.Region.InsertOnSubmit(model);
            db.SubmitChanges();

            return RedirectToAction("RegionList");
        }
예제 #6
0
        public ActionResult EditTranslate(Translate model)
        {
            dbDataContext db = new dbDataContext();

            Translate rec = db.Translate.SingleOrDefault(c => c.ID == model.ID);
            if (rec == null)
                return RedirectToAction("TranslateList");

            rec.LanguageID = Int32.Parse(Request["Lang"]);
            rec.PhraseID = Int32.Parse(Request["Phrase"]);
            rec.Translation = model.Translation;

            db.SubmitChanges();

            return RedirectToAction("TranslateList");
        }
예제 #7
0
        public ActionResult CreateLiveCondition(LiveConditions model)
        {
            dbDataContext db = new dbDataContext();

            db.LiveConditions.InsertOnSubmit(model);
            db.SubmitChanges();

            return RedirectToAction("LiveConditionsList");
        }
예제 #8
0
        public ActionResult EditPhrase(Phrase model)
        {
            dbDataContext db = new dbDataContext();

            Phrase ph = db.Phrase.SingleOrDefault(c => c.id == model.id);
            if (ph == null)
            {
                return RedirectToAction("PhrasesList");
            }
            ph.phrase_key = model.phrase_key;

            db.SubmitChanges();

            return RedirectToAction("PhrasesList");
        }
예제 #9
0
 public ActionResult DeletePage(int id)
 {
     dbDataContext db = new dbDataContext();
     Pages sett = db.Pages.SingleOrDefault(c => c.id == id);
     if (sett != null)
     {
         db.Pages.DeleteOnSubmit(sett);
         db.SubmitChanges();
     }
     return RedirectToAction("PagesList");
 }
예제 #10
0
        public ActionResult DeleteObject(int id)
        {
            dbDataContext db = new dbDataContext();
            Objects ft = db.Objects.SingleOrDefault(c => c.ID == id);
            if (ft != null)
            {
                db.Objects.DeleteOnSubmit(ft);

                List<Objects_LiveConditions> olc_list = db.Objects_LiveConditions.Select(p => p).Where(p => p.object_id == id).ToList<Objects_LiveConditions>();
                foreach (Objects_LiveConditions olc in olc_list)
                {
                    db.Objects_LiveConditions.DeleteOnSubmit(olc);
                }

                List<Objects_Attributes> oattr_list = db.Objects_Attributes.Select(p => p).Where(p => p.object_id == id).ToList<Objects_Attributes>();
                foreach (Objects_Attributes olc in oattr_list)
                {
                    db.Objects_Attributes.DeleteOnSubmit(olc);
                }

                db.SubmitChanges();
            }
            return RedirectToAction("ObjectsList");
        }
예제 #11
0
 public ActionResult DeleteLiveCondition(int id)
 {
     dbDataContext db = new dbDataContext();
     LiveConditions lc = db.LiveConditions.SingleOrDefault(c => c.id == id);
     if (lc != null)
     {
         db.LiveConditions.DeleteOnSubmit(lc);
         db.SubmitChanges();
     }
     return RedirectToAction("LiveConditionsList");
 }
예제 #12
0
        public ActionResult DeleteLanguage(int id)
        {
            dbDataContext db = new dbDataContext();
            languages rec = db.languages.SingleOrDefault(c => c.id == id);
            if (rec==null)
                return RedirectToAction("LangugeList");

            db.languages.DeleteOnSubmit(rec);
            db.SubmitChanges();
            return RedirectToAction("LangugeList");
        }
예제 #13
0
 public ActionResult DeleteAttribute(int id)
 {
     dbDataContext db = new dbDataContext();
     Attributes item = db.Attributes.SingleOrDefault(c => c.id == id);
     if (item != null)
     {
         db.Attributes.DeleteOnSubmit(item);
         db.SubmitChanges();
     }
     return RedirectToAction("AttributesList");
 }
예제 #14
0
        public ActionResult CreateTranslate(Translate model)
        {
            dbDataContext db = new dbDataContext();

            Translate rec = new Translate();
            rec.LanguageID = Int32.Parse(Request["languages"]);
            rec.PhraseID = Int32.Parse(Request["phrases"]);
            rec.Translation = model.Translation;

            db.Translate.InsertOnSubmit(rec);
            db.SubmitChanges();

            return RedirectToAction("TranslateList");
        }
예제 #15
0
        public ActionResult CreateSetting(Settings model)
        {
            dbDataContext db = new dbDataContext();

            db.Settings.InsertOnSubmit(model);
            db.SubmitChanges();

            return RedirectToAction("Index");
        }
예제 #16
0
        public ActionResult EditLiveCondition(LiveConditions model)
        {
            dbDataContext db = new dbDataContext();
            LiveConditions lc = db.LiveConditions.SingleOrDefault(c => c.id == model.id);
            if (lc == null)
            {
                return RedirectToAction("LiveConditionsList");
            }

            lc.lc_key = model.lc_key;
            lc.lc_value = model.lc_value;

            db.SubmitChanges();
            return RedirectToAction("LiveConditionsList");
        }
예제 #17
0
        public ActionResult EditObjects(FormCollection coll)
        {
            dbDataContext db = new dbDataContext();
            int obj_id;
            try
            {
                obj_id = Int32.Parse(coll["obj_id"]);
            }
            catch
            {
                return RedirectToAction("ObjectsList");
            }

            Objects obj = db.Objects.SingleOrDefault(c=>c.ID==obj_id);
            if (obj == null)
            {
                return RedirectToAction("ObjectsList");
            }

            obj.type = Int32.Parse(coll["FlatType"]);
            obj.region_id = Int32.Parse(coll["Region"]);
            obj.header = coll["header"];
            obj.address = coll["address"];
            if (coll["rooms_count"] != String.Empty)
                obj.rooms_count = Int32.Parse(coll["rooms_count"]);
            else
                obj.rooms_count = 0;
            if (coll["guests_count"] != String.Empty)
                obj.guests_count = Int32.Parse(coll["guests_count"]);
            else
                obj.guests_count = 0;

            if (coll["price1"] != String.Empty)
                obj.price1 = Decimal.Parse(coll["price1"]);
            else obj.price1 = 0;

            if (coll["price2"] != String.Empty)
                obj.price2 = Decimal.Parse(coll["price2"]);
            else
                obj.price2 = 0;

            if (coll["price5"] != String.Empty)
                obj.price5 = Decimal.Parse(coll["price5"]);
            else obj.price5 = 0;
            if (coll["price14"] != String.Empty)
                obj.price14 = Decimal.Parse(coll["price14"]);
            else
                obj.price14 = 0;

            obj.desc_body = coll["desc"];

            //Записываем картинки

            HttpPostedFileBase file = Request.Files["large_foto1"];
            MemoryStream ms;
            Image img;
            Binary bin;

            if (file.ContentLength != 0)
            {
                ms = new MemoryStream();
                img = Image.FromStream(file.InputStream);
                img.Save(ms, img.RawFormat);
                bin = new Binary(ms.ToArray());
                obj.pic1large = bin;
            }

            file = Request.Files["large_foto2"];
            if (file.ContentLength != 0)
            {
                ms = new MemoryStream();
                img = Image.FromStream(file.InputStream);
                img.Save(ms, img.RawFormat);
                bin = new Binary(ms.ToArray());
                obj.pic2large = bin;
            }

            file = Request.Files["foto1"];
            if (file.ContentLength != 0)
            {
                ms = new MemoryStream();
                img = Image.FromStream(file.InputStream);
                img.Save(ms, img.RawFormat);
                bin = new Binary(ms.ToArray());
                obj.pic1 = bin;
            }

            file = Request.Files["foto2"];
            if (file.ContentLength != 0)
            {
                ms = new MemoryStream();
                img = Image.FromStream(file.InputStream);
                img.Save(ms, img.RawFormat);
                bin = new Binary(ms.ToArray());
                obj.pic2 = bin;
            }

            file = Request.Files["foto3"];
            if (file.ContentLength != 0)
            {
                ms = new MemoryStream();
                img = Image.FromStream(file.InputStream);
                img.Save(ms, img.RawFormat);
                bin = new Binary(ms.ToArray());
                obj.pic3 = bin;
            }

            file = Request.Files["foto4"];
            if (file.ContentLength != 0)
            {
                ms = new MemoryStream();
                img = Image.FromStream(file.InputStream);
                img.Save(ms, img.RawFormat);
                bin = new Binary(ms.ToArray());
                obj.pic4 = bin;
            }//--Записываем картинки

            db.SubmitChanges();

            //Чистим таблицы- связки
            List<Objects_LiveConditions> olc_list = db.Objects_LiveConditions.Select(p => p).Where(p => p.object_id == obj.ID).ToList<Objects_LiveConditions>();
            foreach (Objects_LiveConditions olc in olc_list)
            {
                db.Objects_LiveConditions.DeleteOnSubmit(olc);
            }
            List<Objects_Attributes> oattr_list = db.Objects_Attributes.Select(p => p).Where(p => p.object_id == obj.ID).ToList<Objects_Attributes>();
            foreach (Objects_Attributes olc in oattr_list)
            {
                db.Objects_Attributes.DeleteOnSubmit(olc);
            }

            db.SubmitChanges();

            //Записываем жизненные условия
            var lcs = coll.AllKeys.Where(c => (c.StartsWith("lc_") & (!c.Contains("val"))));

            foreach (var attr in lcs)
            {
                string temp_key = attr.Replace("lc_", "lc_val_");
                string temp_value = coll[temp_key];
                Objects_LiveConditions olc = new Objects_LiveConditions();
                olc.lc_id = Int32.Parse(attr.Replace("lc_", ""));
                olc.object_id = obj.ID;
                olc._value = temp_value;
                db.Objects_LiveConditions.InsertOnSubmit(olc);
            }

            var attrs = coll.AllKeys.Where(c => (c.StartsWith("attr_")));

            foreach (var attr in attrs)
            {
                string temp_id = attr.Replace("attr_", "");
                Objects_Attributes oattr = new Objects_Attributes();
                oattr.attribute_id = Int32.Parse(temp_id);
                oattr.object_id = obj.ID;
                db.Objects_Attributes.InsertOnSubmit(oattr);
            }

            db.SubmitChanges();

            return RedirectToAction("ObjectsList");
        }
예제 #18
0
        public ActionResult DeletePhrase(int id)
        {
            dbDataContext db = new dbDataContext();
            Phrase rec = db.Phrase.SingleOrDefault(c => c.id == id);
            if (rec == null)
                return RedirectToAction("PhrasesList");

            db.Phrase.DeleteOnSubmit(rec);
            db.SubmitChanges();
            return RedirectToAction("PhrasesList");
        }
예제 #19
0
        public ActionResult EditPage(Pages model)
        {
            dbDataContext db = new dbDataContext();
            Pages page = db.Pages.SingleOrDefault(c => c.id == model.id);
            if (page == null)
            {
                return RedirectToAction("PagesList");
            }

            page.Alias = model.Alias;
            page.Naim = model.Naim;
            page.Text = model.Text;

            db.SubmitChanges();
            return RedirectToAction("PagesList");
        }
예제 #20
0
 public ActionResult DeleteRegion(int id)
 {
     dbDataContext db = new dbDataContext();
     Flats.Views.Manage.Region ft = db.Region.SingleOrDefault(c => c.ID == id);
     if (ft != null)
     {
         db.Region.DeleteOnSubmit(ft);
         db.SubmitChanges();
     }
     return RedirectToAction("RegionList");
 }
예제 #21
0
        public ActionResult EditRegion(Flats.Views.Manage.Region model)
        {
            dbDataContext db = new dbDataContext();
            Flats.Views.Manage.Region ft = db.Region.SingleOrDefault(c => c.ID == model.ID);
            if (ft == null)
            {
                return RedirectToAction("RegionList");
            }

            ft.Naim = model.Naim;

            db.SubmitChanges();
            return RedirectToAction("RegionList");
        }
예제 #22
0
 public ActionResult DeleteSetting(int id)
 {
     dbDataContext db = new dbDataContext();
     Settings sett = db.Settings.SingleOrDefault(c => c.id == id);
     if (sett != null)
     {
         db.Settings.DeleteOnSubmit(sett);
         db.SubmitChanges();
     }
     return RedirectToAction("Index");
 }
예제 #23
0
        public ActionResult EditSetting(Settings model)
        {
            dbDataContext db = new dbDataContext();
            Settings sett = db.Settings.SingleOrDefault(c => c.id == model.id);
            if (sett == null)
            {
                return RedirectToAction("Index");
            }
            sett.setting_key = model.setting_key;
            sett.setting_value = model.setting_value;

            db.SubmitChanges();
            return RedirectToAction("Index");
        }
예제 #24
0
        public ActionResult DeleteTranslate(int id)
        {
            dbDataContext db = new dbDataContext();
            Translate rec = db.Translate.SingleOrDefault(c => c.ID == id);
            if (rec == null)
                return RedirectToAction("TranslateList");

            db.Translate.DeleteOnSubmit(rec);
            db.SubmitChanges();
            return RedirectToAction("TranslateList");
        }
예제 #25
0
        public ActionResult SaveReview()
        {
            String name = Request["name"];
            String surname = Request["surname"];
            String text = Request["text"];
            String total = Request["total"];
            String region = Request["region"];
            String comfort = Request["comfort"];
            String clean = Request["clean"];
            String price = Request["price"];
            String services = Request["services"];
            int id = Int32.Parse(Request["id"]);

            dbDataContext db = new dbDataContext();

            reviews rw = new reviews();
            rw.data = DateTime.Now;
            rw.cleaness = Decimal.Parse(clean.Replace('.',','));
            rw.price = Decimal.Parse(price.Replace('.', ','));
            rw.services = Decimal.Parse(services.Replace('.', ','));
            rw.comfort = Decimal.Parse(comfort.Replace('.', ','));
            rw.region = Decimal.Parse(region.Replace('.', ','));
            rw.object_id = id;
            rw.header = name + " " + surname;
            rw.body = text;
            rw.total = Decimal.Parse(total.Replace('.', ','));
            rw.Name = name;
            rw.Surname = surname;

            db.reviews.InsertOnSubmit(rw);
            db.SubmitChanges();

            return RedirectToAction("ReViewDetails", new { id = rw.id });
        }
예제 #26
0
        public ActionResult CreatePhrase(Phrase model)
        {
            dbDataContext db = new dbDataContext();

            db.Phrase.InsertOnSubmit(model);
            db.SubmitChanges();

            return RedirectToAction("PhrasesList");
        }