private void AddLikes(NoteDB n, string user) { if (n.Likes == "无") { n.Likes = user; } else { n.Likes += ","; n.Likes += user; } db.Entry(n).State = EntityState.Modified; db.SaveChanges(); }
public async Task <Article> Add([FromBody] Article _Data) { Article ArticleInDB = null; if (_Data.Id != null) { ArticleInDB = context.Articles.Where(x => x.Id == _Data.Id).FirstOrDefault(); } else { _Data.Id = Guid.NewGuid(); } if (ArticleInDB != null) { ArticleInDB.Title = _Data.Title; ArticleInDB.Desc = _Data.Desc; } else { await context.Articles.AddAsync(_Data); ArticleInDB = _Data; } context.SaveChanges(); return(ArticleInDB); }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new NoteDBContext( serviceProvider.GetRequiredService <DbContextOptions <NoteDBContext> >())) { // Look for any notes if (context.Note.Any()) { return; // DB has been seeded } context.Note.AddRange( new Note { CreatedDate = DateTime.Parse("2018-9-2"), Title = "Erste Notiz", Text = "Das ist der Text der ersten Note", Importance = 5, FinishDate = DateTime.Parse("2017-9-2"), Finished = true }, new Note { CreatedDate = DateTime.Parse("2018-1-9"), Title = "Zweite Notiz", Text = "Das ist der Text der zweiten Note", Importance = 1, FinishDate = DateTime.Parse("2018-11-9") } ); context.SaveChanges(); } }
public async Task <NoteData> Add([FromBody] NoteData _Data) { _Data.Id = Guid.NewGuid(); await context.NoteDatas.AddAsync(_Data); context.SaveChanges(); return(_Data); }
public ActionResult Create([Bind(Include = "ID,Title,Subject,Text,TimeSent")] Note note) { if (ModelState.IsValid) { db.Notes.Add(note); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(note)); }
/* * Füllt die DB mit einem neuen Datensatz */ private void FillDBWithNode(int id) { Note note = Note.CreateNew(); note.ID = id; note.Title = "Titel 1.Notiz"; note.Text = "Text der 1. Notiz"; _dbContext.Add(note); _dbContext.SaveChanges(); }
public IActionResult Edit(int?id, [Bind("ID,CreatedDate,Title,Text,Importance,FinishDate,Finished")] Note note) { ViewData["CurrentStyle"] = style.getCurrent(); if (id != note.ID) { return(BadRequest()); } if (ModelState.IsValid) { try { _noteDBContext.Update(note); _noteDBContext.SaveChanges(); } catch (DbUpdateConcurrencyException) { return(BadRequest()); } catch (DbUpdateException) { return(BadRequest()); } return(RedirectToAction("Index", "Home")); } return(View(note)); }
public IActionResult Add(Note model) { if (HttpContext.Session.GetInt32("USER_LOGIN_KEY") == null) { return(RedirectToAction("Login", "Account")); } model.UserNo = Int32.Parse(HttpContext.Session.GetInt32("USER_LOGIN_KEY").ToString()); if (ModelState.IsValid) { using (var db = new NoteDBContext()) { db.Notes.Add(model); if (db.SaveChanges() > 0) { db.SaveChanges(); return(Redirect("Index")); } } ModelState.AddModelError(string.Empty, "게시물을 저장할 수 없습니다."); } return(View(model)); }
public IActionResult Register(User model) { if (ModelState.IsValid) { // Java try(sqlsession) {} catch() {} // C# using (var db = new NoteDBContext()) { db.Users.Add(model); db.SaveChanges(); } return(RedirectToAction("Index", "Home")); } return(View()); }
public void GetSeoul(DateTime today) { string url_Seoul = "http://openapi.seoul.go.kr:8088/76676170526a7268313032484a736978/xml/lostArticleInfo/" + 1 + "/" + 1000 + "/"; XmlDocument xdoc = new XmlDocument(); xdoc.Load(url_Seoul); XmlNodeList xnodeList = xdoc.DocumentElement.SelectNodes("/lostArticleInfo/row"); foreach (XmlNode xnode in xnodeList) { if (xnode["STATUS"].InnerText != "수령") { if (DateTime.Compare(today.AddDays(-7), Convert.ToDateTime(xnode["REG_DATE"].InnerText)) <= 0) { Found found_Seoul = new Found(); found_Seoul.Found_DateTime = Convert.ToDateTime(xnode["REG_DATE"].InnerText); found_Seoul.Found_BigCate = xnode["CATE"].InnerText; found_Seoul.Found_Name = xnode["GET_NAME"].InnerText; found_Seoul.Found_GetPosition = xnode["GET_POSITION"].InnerText; found_Seoul.Found_data = "서울시"; using (var db = new NoteDBContext()) { var data = db.Found .FirstOrDefault(d => d.Found_DateTime.Equals(found_Seoul.Found_DateTime) && d.Found_BigCate.Equals(found_Seoul.Found_BigCate) && d.Found_Name.Equals(found_Seoul.Found_Name) && d.Found_GetPosition.Equals(found_Seoul.Found_GetPosition) && d.Found_data.Equals(found_Seoul.Found_data) ); if (data == null) { db.Found.Add(found_Seoul); db.SaveChanges(); } } } } } }
public IActionResult Edit(Note model) { if (HttpContext.Session.GetInt32("USER_LOGIN_KEY") == null) { return(RedirectToAction("Login", "Account")); } model.UserNo = Int32.Parse(HttpContext.Session.GetInt32("USER_LOGIN_KEY").ToString()); using (var db = new NoteDBContext()) { db.Entry(model).CurrentValues.SetValues(model); db.Update(model); db.SaveChanges(); return(Redirect("Index")); } ModelState.AddModelError(string.Empty, "게시물을 저장할 수 없습니다."); return(View(model)); }
public IActionResult Delete(int noteNo) { if (HttpContext.Session.GetInt32("USER_LOGIN_KEY") == null) { return(RedirectToAction("Login", "Account")); } using (var db = new NoteDBContext()) { var note = db.Notes.FirstOrDefault(n => n.NoteNo.Equals(noteNo)); db.Notes.Remove(note); db.SaveChanges(); return(Redirect("Index")); } ModelState.AddModelError(string.Empty, "게시물을 삭제할 수 없습니다."); return(View()); }
public IActionResult Seoul_xmlToDB() { string url = "http://openapi.seoul.go.kr:8088/76676170526a7268313032484a736978/xml/lostArticleInfo/" + 1 + "/" + 1000 + "/"; XmlDocument xdoc = new XmlDocument(); xdoc.Load(url); XmlNodeList xnodeList = xdoc.DocumentElement.SelectNodes("/lostArticleInfo/row"); foreach (XmlNode xnode in xnodeList) { if (xnode["STATUS"].InnerText != "수령") { if (DateTime.Compare(Convert.ToDateTime("2020-01-01"), Convert.ToDateTime(xnode["REG_DATE"].InnerText)) <= 0) { Lost_seoul lost_Seoul = new Lost_seoul(); lost_Seoul.Lost_seoul_DateTime = xnode["REG_DATE"].InnerText; lost_Seoul.Lost_seoul_Cate = xnode["CATE"].InnerText; lost_Seoul.Lost_seoul_Name = xnode["GET_NAME"].InnerText; lost_Seoul.Lost_seoul_GetArea = xnode["GET_AREA"].InnerText; lost_Seoul.Lost_Seoul_GetPosition = xnode["GET_POSITION"].InnerText; using (var db = new NoteDBContext()) { db.Lost_seoul.Add(lost_Seoul); db.SaveChanges(); } } } } return(View()); }
public void Save() { _dbContext.SaveChanges(); }
public void GetPolice(DateTime startdate, DateTime enddate, int show_size) { int index = 0; int totalCount = 0; string url_Police = "http://apis.data.go.kr/1320000/LosfundInfoInqireService/getLosfundInfoAccToClAreaPd?serviceKey=QM218VcrO%2BoL6AOKYNgiEK9fQDAeHaoS3%2F8n8PWz3xVM84Dxv24YMuIAJbmrUFsk2b4HancEzvLVCyNBPsIIyw%3D%3D" + "&START_YMD=" + startdate.ToString("yyyyMMdd") + "&END_YMD=" + enddate.ToString("yyyyMMdd") + "&pageNo=" + index + 1 + "&numOfRows=" + show_size; XmlDocument xdoc = new XmlDocument(); xdoc.Load(url_Police); totalCount = Convert.ToInt32(xdoc.GetElementsByTagName("totalCount")[0].InnerText); while (index * show_size < totalCount) { index++; url_Police = "http://apis.data.go.kr/1320000/LosfundInfoInqireService/getLosfundInfoAccToClAreaPd?serviceKey=QM218VcrO%2BoL6AOKYNgiEK9fQDAeHaoS3%2F8n8PWz3xVM84Dxv24YMuIAJbmrUFsk2b4HancEzvLVCyNBPsIIyw%3D%3D" + "&START_YMD=" + startdate.ToString("yyyyMMdd") + "&END_YMD=" + DateTime.Now.ToString("yyyyMMdd") + "&pageNo=" + index + "&numOfRows=" + show_size; xdoc.Load(url_Police); XmlNodeList xnodeList = xdoc.DocumentElement.SelectNodes("/response/body/items/item"); foreach (XmlNode xnode in xnodeList) { Found found_police = new Found(); found_police.Found_data = "경찰청"; found_police.Found_GetPosition = xnode["depPlace"].InnerText; found_police.Found_ImageURL = xnode["fdFilePathImg"].InnerText; found_police.Found_Name = xnode["fdPrdtNm"].InnerText; found_police.Found_Description = xnode["fdSbjt"].InnerText; found_police.Found_DateTime = Convert.ToDateTime(xnode["fdYmd"].InnerText); string cate = xnode["prdtClNm"].InnerText; string[] catelist = cate.Split(" > "); found_police.Found_BigCate = catelist[0]; found_police.Found_SmallCate = catelist[1]; if (!(found_police.Found_BigCate == "기타물품" && found_police.Found_SmallCate == "기타" && found_police.Found_Name == "기타물품")) { using (var db = new NoteDBContext()) { //var data = db.Found.Where(d=> d.Found_Name.ToString().Equals(found_police.Found_Name.ToString()) && // d.Found_Description.ToString().Equals(found_police.Found_Description.ToString()) && // d.Found_DateTime.ToString().Equals(found_police.Found_DateTime.ToString()) && // d.Found_GetPosition.ToString().Equals(found_police.Found_GetPosition.ToString())) // .FirstOrDefault(); var da = from d in db.Found where d.Found_Name == found_police.Found_Name where d.Found_Description == found_police.Found_Description where d.Found_DateTime == found_police.Found_DateTime where d.Found_GetPosition == found_police.Found_GetPosition select d; if (!da.Any()) { db.Found.Add(found_police); db.SaveChanges(); } } } } index++; } }