public async Task <IActionResult> PostServer_Info([FromBody] server Server_Info) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.servers.Add(Server_Info); // await _context.SaveChangesAsync(); _context.SaveChanges(); return(CreatedAtAction("GetServer_Info", new { id = Server_Info.Server_ID }, Server_Info)); //return Ok(Server_Info); }
public async Task <IActionResult> PostArchivalreq([FromBody] Archivalreq[] archivalreq) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } for (int i = 0; i < archivalreq.Length; i++) { _context.Archivalreqs.Add(archivalreq[i]); } //await _context.SaveChangesAsync(); _context.SaveChanges(); return(CreatedAtAction("GetArchivalreq", new { id = archivalreq[0].Request_ID }, archivalreq)); }
public ActionResult Edit(Osoba model) { if (model != null && ModelState.IsValid) { using (var db = new db_context()) { Osoba o = db.Osoby.Find(model.ID); if (o != null) { foreach (var p in o.GetType().GetProperties()) { if (!o.HasPropertyAttribute(p.Name, typeof(KeyAttribute))) { p.SetValue(o, model.GetType().GetProperty(p.Name).GetValue(model)); } } } db.SaveChanges(); } return(RedirectToAction("Index")); } else { return(View(model)); } }
public void Start() { using (var db = new db_context()) { db.Osoby.Add(new Osoba("Pawel", "Kajka", 25)); db.SaveChanges(); } }
public ActionResult Add(Nieruchomosc model) { using (var db = new db_context()) { db.Nieruchomosci.Add(model); db.SaveChanges(); return(RedirectToAction("Index", "Osoby")); } }
public ActionResult Remove(MailAdress model) { using (var db = new db_context()) { db.Adresy.Attach(model); db.Adresy.Remove(model); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Import(HttpPostedFileBase file) { if (file != null) { string filename = file.FileName; string targetpath = Server.MapPath("~/App_Data/"); file.SaveAs(targetpath + filename); string pathToExcelFile = targetpath + filename; string connectionString = ""; if (file.FileName.EndsWith(".xls")) { connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile); } else if (file.FileName.EndsWith(".xlsx")) { connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile); } else { return(RedirectToAction("Index")); } var adapter = new OleDbDataAdapter("Select * FROM [Arkusz1$]", connectionString); var ds = new DataSet(); adapter.Fill(ds, "ExcelTable"); DataTable dtable = ds.Tables["ExcelTable"]; using (var db = new db_context()) { foreach (DataRow dr in dtable.Rows) { Osoba o = new Osoba(); o.Imie = dr[0].ToString(); o.Nazwisko = dr[1].ToString(); o.Wiek = Int32.Parse(dr[2].ToString()); o.Zdjecie = dr[3].ToString(); db.Osoby.Add(o); } db.SaveChanges(); } if ((System.IO.File.Exists(pathToExcelFile))) { System.IO.File.Delete(pathToExcelFile); } } return(RedirectToAction("Index")); }
protected void Application_BeginRequest() { using (var db = new db_context()) { db.HistoriaTable.Add(new Historia() { Date = DateTime.Now, Action = HttpContext.Current.Request.Url.OriginalString }); db.SaveChanges(); } }
public void AdicionaTransacao(TransacaoModel transacao) { try { using (var context = new db_context()) { context.TransacaoModels.Add(transacao); context.SaveChanges(); } } catch (Exception) { throw; } }
public async Task <IActionResult> PostSAPPurgeTable([FromBody] SAPPurgeTable[] sAPPurgeTable) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } for (int i = 0; i < sAPPurgeTable.Length; i++) { _context.SAPPurgeTables.Add(sAPPurgeTable[i]); } //await _context.SaveChangesAsync(); _context.SaveChanges(); return(CreatedAtAction("GetSAPPurgeTable", new { id = sAPPurgeTable[0].TableID }, sAPPurgeTable)); }
public ActionResult Add(Osoba model) { if (ModelState.IsValid) { using (var db = new db_context()) { db.Osoby.Add(model); db.SaveChanges(); } return(RedirectToAction("Index")); } else { return(View(model)); } }
public PartialViewResult Mails(MailAdress model) { using (var db = new db_context()) { if (model != null) { try { System.Net.Mail.MailAddress m = new System.Net.Mail.MailAddress(model.Adres); db.Adresy.Add(model); db.SaveChanges(); } catch (FormatException) { } } var maile = db.Adresy.ToList(); return(PartialView(maile)); } }
public async Task <IActionResult> PoststgSAPPurgeTableList([FromBody] stgSAPPurgeTableList[] stgSAPPurgeTableList) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } for (int i = 0; i < stgSAPPurgeTableList.Length; i++) { _context.stgSAPPurgeTableList.Add(stgSAPPurgeTableList[i]); } //await _context.SaveChangesAsync(); _context.SaveChanges(); CustomConnection obj = new CustomConnection(); //hard coded the server id IEnumerable <JobInfo> result = obj.DeployAll(); return(CreatedAtAction("GetstgSAPPurgeTableList", new { id = stgSAPPurgeTableList[0].TableID }, stgSAPPurgeTableList)); }
public ActionResult Remove(Osoba model) { using (var db = new db_context()) { if (model != null) { db.Osoby.Attach(model); //podlacz model do bazy na sile db.Osoby.Remove(model); var nieruchmosci = db.Nieruchomosci.Where(x => x.IDOsoby == model.ID); foreach (var n in nieruchmosci) { db.Nieruchomosci.Remove(n); } db.SaveChanges(); } return(RedirectToAction("Index")); } }
public void repo_test() { using (var db = new db_context()) { db.Database.EnsureCreated(); Assert.IsTrue(db.UserTest == db.Set <UserTest>(), "error1"); var model = new UserTest() { Name = Lib.helper.Com.GetUUID() }; Assert.IsTrue(db.Entry(model).State == EntityState.Detached); db.Set <UserTest>().Attach(model); Assert.IsTrue(db.Entry(model).State == EntityState.Added); model.Name = "fa"; Assert.IsTrue(db.Entry(model).State == EntityState.Added); db.Set <UserTest>().Remove(model); Assert.IsTrue(db.Entry(model).State == EntityState.Detached); db.UserTest.Add(model); Assert.IsTrue(db.Entry(model).State == EntityState.Added); db.SaveChanges(); Assert.IsTrue(db.Entry(model).State == EntityState.Unchanged); model.Name = "xx"; Assert.IsTrue(db.Entry(model).State == EntityState.Modified); db.SaveChanges(); Assert.IsTrue(db.Entry(model).State == EntityState.Unchanged); db.UserTest.Remove(model); Assert.IsTrue(db.Entry(model).State == EntityState.Deleted); db.SaveChanges(); Assert.IsTrue(db.Entry(model).State == EntityState.Detached); var new_user = db.Set <UserTest>().AsNoTrackingQueryable().FirstOrDefault(x => x.Name == "xx"); Assert.IsTrue(db.Entry(new_user).State == EntityState.Detached); new_user = db.Set <UserTest>().AsTracking().FirstOrDefault(x => x.Name == "xx"); Assert.IsTrue(db.Entry(new_user).State == EntityState.Unchanged); } var collection = new ServiceCollection(); collection.AddTransient(typeof(IEFRepository <>), typeof(Repo <>)); var provider = collection.BuildServiceProvider().SetAsRootServiceProvider(); using (var user_repo = provider.Resolve_ <IEFRepository <UserTest> >()) { user_repo.Insert(new UserTest() { Name = "xx" }); user_repo.Insert(new UserTest() { Name = "xx" }); user_repo.Insert(new UserTest() { Name = "xx" }); user_repo.Insert(new UserTest() { Name = "xx" }); var m = user_repo.QueryOne(x => x.Name == "xx"); m.Name += "-dd"; var effected = user_repo.Update(m); Assert.IsTrue(effected > 0); } }