public ActionResult CreateLanguage(languages model) { dbDataContext db = new dbDataContext(); db.languages.InsertOnSubmit(model); db.SubmitChanges(); return RedirectToAction("LangugeList"); }
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"); }
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"); }
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"); }
public ActionResult CreateRegion(Flats.Views.Manage.Region model) { dbDataContext db = new dbDataContext(); db.Region.InsertOnSubmit(model); db.SubmitChanges(); return RedirectToAction("RegionList"); }
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"); }
public ActionResult CreateLiveCondition(LiveConditions model) { dbDataContext db = new dbDataContext(); db.LiveConditions.InsertOnSubmit(model); db.SubmitChanges(); return RedirectToAction("LiveConditionsList"); }
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"); }
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"); }
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"); }
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"); }
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"); }
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"); }
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"); }
public ActionResult CreateSetting(Settings model) { dbDataContext db = new dbDataContext(); db.Settings.InsertOnSubmit(model); db.SubmitChanges(); return RedirectToAction("Index"); }
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"); }
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"); }
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"); }
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"); }
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"); }
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"); }
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"); }
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"); }
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"); }
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 }); }
public ActionResult CreatePhrase(Phrase model) { dbDataContext db = new dbDataContext(); db.Phrase.InsertOnSubmit(model); db.SubmitChanges(); return RedirectToAction("PhrasesList"); }