private void SetUpClient() { var builder = new WebHostBuilder() .UseStartup <Startup>() .ConfigureServices(services => { var context = new TestProjectContext(new DbContextOptionsBuilder <TestProjectContext>() .UseSqlite("DataSource=:memory:") .EnableSensitiveDataLogging() .Options); services.RemoveAll(typeof(TestProjectContext)); services.AddSingleton(context); context.Database.OpenConnection(); context.Database.EnsureCreated(); context.SaveChanges(); // Clear local context cache foreach (var entity in context.ChangeTracker.Entries().ToList()) { entity.State = EntityState.Detached; } }); _server = new TestServer(builder); Client = _server.CreateClient(); }
// PUT: api/Shedule/5 public void Put(Schedule value) { if (value != null && value.Id != 0) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Schedules.Load(); var r = context.Schedules.Find(value.Id); if (r != null) { r.TeacherId = value.TeacherId; r.Data = value.Data; r.DisciplineId = value.DisciplineId; r.EndTime = value.EndTime; r.StartTime = value.StartTime; r.GroupId = value.GroupId; context.SaveChanges(); } } } } }
// POST: api/User public void Post([FromBody] User value) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Users.Load(); if (value != null) { context.Users.Add(value); context.SaveChanges(); } } } }
// DELETE: api/User/5 public void Delete(int id) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { var temp = context.Users.Find(id); if (temp != null) { context.Users.Load(); context.Users.Remove(temp); context.SaveChanges(); } } } }
// PUT: api/Group/5 public void Put(Group value) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Groups.Load(); var r = context.Groups.Find(value.Id); if (r != null) { r.GroupName = value.GroupName; r.StartDate = value.StartDate; r.EndDate = value.EndDate; context.SaveChanges(); } } } }
public async Task <IActionResult> Create([Bind("BookID,Title,Isbn,Summary")] Book book, int id) { if (ModelState.IsValid) { _context.Add(book); _context.SaveChanges(); _context.Add(new Composition { AuthorID = id, BookID = book.BookID }); await _context.SaveChangesAsync(); return(RedirectToRoute(new { controller = "Authors", action = "Details", id = id })); } return(View(book)); }
// PUT: api/User/5 public void Put(User value) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Users.Load(); var r = context.Users.Find(value.Id); if (r != null) { r.FullName = value.FullName; r.Login = value.Login; r.Password = value.Password; r.GroupId = value.GroupId; context.SaveChanges(); } } } }
public JsonResult CreateContact([FromBody] Contact model) { try { TestProjectContext db = new TestProjectContext(); var contact = new Contact(); contact.FirstName = model.FirstName; contact.LastName = model.LastName; contact.Birthdate = model.Birthdate; contact.Nid = model.Nid; db.Contact.Add(contact); db.SaveChanges(); return(Json(true)); } catch (Exception ex) { return(Json(ex)); } }
// PUT: api/Discipline/5 public void Put(Discipline value) { if (value != null && value.DisciplineId != 0) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Disciplines.Load(); var r = context.Disciplines.Find(value.DisciplineId); if (r != null) { r.DisciplineName = value.DisciplineName; r.TeacherId = value.TeacherId; context.SaveChanges(); } } } } }
// PUT: api/Teacher/5 public void Put(Teacher value) { if (value != null && value.Id != 0) { using (var connection = ConnectToDataBase.GetConnection()) { connection.Open(); using (var context = new TestProjectContext()) { context.Teachers.Load(); var r = context.Teachers.Find(value.Id); if (r != null) { r.FullName = value.FullName; r.Phone = value.Phone; context.SaveChanges(); } } } } }
public JsonResult UpdateContact([FromBody] Contact model) { try { TestProjectContext db = new TestProjectContext(); var contact = db.Contact.Find(model.Id); if (contact != null) { contact.FirstName = model.FirstName; contact.LastName = model.LastName; contact.Nid = model.Nid; contact.Birthdate = model.Birthdate; db.SaveChanges(); } return(Json(contact)); } catch (Exception ex) { return(Json(ex)); } }
public void AddTransaction(TransactionData t) { _context.TransactionData.Add(t); _context.SaveChanges(); }