public bool Update(District district) { //Method 1 //Student std = db.Students.Where(c => c.ID == student.ID).FirstOrDefault(); //Student std = db.Students.FirstOrDefault(c => c.ID == student.ID); //if (student != null) //{ // student.Name = student.Name; //} //Method 2 db.Entry(district).State = EntityState.Modified; int rowAffected = db.SaveChanges(); if (rowAffected > 0) { return(true); } return(false); }
public bool Update(Student student) { int isExecuted = 0; //Method 1 //Student aStudent = db.Students.FirstOrDefault(c => c.ID == student.ID); //if (aStudent != null) //{ // aStudent.Name = student.Name; // isExecuted = db.SaveChanges(); //} //Method 2 db.Entry(student).State = EntityState.Modified; isExecuted = db.SaveChanges(); if (isExecuted > 0) { return(true); } return(false); }
private void ShowValues() { using (StudentDbContext db = new StudentDbContext()) { foreach (Student student in db.Students) { db.Attach(student); db.Entry(student).Collection(s => s.Presences).Load(); string[] arr = new string[presenceList.Columns.Count]; arr[0] = student.Name; int present = GetPresenceCount(student, PresenceType.Present); int absent = GetPresenceCount(student, PresenceType.Absent); int excused = GetPresenceCount(student, PresenceType.Excused); int totalAbsence = absent + excused; arr[1] = present.ToString(); arr[2] = absent.ToString(); arr[3] = excused.ToString(); arr[4] = totalAbsence.ToString(); presenceList.Items.Add(new ListViewItem(arr)); lines.Add(arr); } } }
public async Task <IActionResult> PutStudentTask(int id, StudentTaskDTO studentTaskDTO) { var user = await _userManager.FindByNameAsync(User.Identity.Name); StudentTask taskToUpdate = await _context.StudentTasks.FindAsync(id); if (id != taskToUpdate.StudentTaskId) { return(BadRequest("Task Id does not match any task.")); } taskToUpdate.Priority = studentTaskDTO.Priority; taskToUpdate.StudentTaskName = studentTaskDTO.StudentTaskName; taskToUpdate.TaskDueDate = studentTaskDTO.TaskDueDate; taskToUpdate.UserId = user.Id; // Added UserId _context.Entry(taskToUpdate).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentTaskExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutDbStudent(int id, DbStudent dbStudent) { dbStudent.Id = id; _context.Entry(dbStudent).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DbStudentExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void Update(Course course) { db.Entry(course).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }
public void Update(Comment item) { dataBaseContext.Entry(item).State = EntityState.Modified; }
public JsonResult Update(Student entity) { db.Entry <Student>(entity).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(Json("OK", JsonRequestBehavior.AllowGet)); }
public int Update(Student student) { db.Entry(student).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); }
public virtual void Update(TEntity entityToUpdate) { dbSet.Attach(entityToUpdate); context.Entry(entityToUpdate).State = EntityState.Modified; }
public void EditStudent(Student student) { context.Entry(student).State = EntityState.Modified; }
public int Update(Course course) { db.Entry(course).State = System.Data.Entity.EntityState.Modified; return(db.SaveChanges()); }
public async Task <IActionResult> UpdateWithTracking(int id, Student student) { var existingStudent = await _context.Students.FindAsync(id); if (id != student.StudentId) { return(BadRequest()); } var existingStudentData = new Student() { FirstName = existingStudent.FirstName, LastName = existingStudent.LastName, StudentAge = existingStudent.StudentAge, DOB = existingStudent.DOB }; var trackRecordData = new TrackRecord() { UpdatedColumn = "", OldValue = "", UpdatedValue = "", UpdatedTime = new TimeSpan() }; if (existingStudentData.FirstName != student.FirstName) { student.IsUpdated = true; trackRecordData.UpdatedColumn = "FirstName"; trackRecordData.OldValue = existingStudentData.FirstName; trackRecordData.UpdatedValue = student.FirstName; trackRecordData.UpdatedTime = DateTime.Now.TimeOfDay; } else if (existingStudentData.LastName != student.LastName) { student.IsUpdated = true; trackRecordData.UpdatedColumn = "LastName"; trackRecordData.OldValue = existingStudentData.LastName; trackRecordData.UpdatedValue = student.LastName; trackRecordData.UpdatedTime = DateTime.Now.TimeOfDay; } else if (existingStudentData.StudentAge != student.StudentAge) { student.IsUpdated = true; trackRecordData.UpdatedColumn = "StudentAge"; trackRecordData.OldValue = Convert.ToString(existingStudentData.StudentAge); trackRecordData.UpdatedValue = Convert.ToString(student.StudentAge); trackRecordData.UpdatedTime = DateTime.Now.TimeOfDay; } else if (existingStudentData.DOB != student.DOB) { student.IsUpdated = true; trackRecordData.UpdatedColumn = "DOB"; trackRecordData.OldValue = Convert.ToString(existingStudentData.DOB); trackRecordData.UpdatedValue = Convert.ToString(student.DOB); trackRecordData.UpdatedTime = DateTime.Now.TimeOfDay; } _context.TrackRecords.Add(trackRecordData); _context.Entry(existingStudent).State = EntityState.Detached; _context.Entry(student).State = EntityState.Modified; _context.SaveChanges(); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentExists(id)) { return(NotFound()); } else { throw; } } return(Ok()); }
public ActionResult Edit(Student student) { db.Entry(student).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "Home")); }
// GET: Core/Staffs/Delete/5 public async Task <ActionResult> Delete(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //if (staff == null) //{ // return HttpNotFound(); //} using (StudentDbContext db = new StudentDbContext()) { Staff staff = await db.Staffs.FindAsync(id); if (staff != null) { staff.Is_Deleted = true; db.Entry(staff).CurrentValues.SetValues(staff); db.Entry(staff).State = EntityState.Modified; await db.SaveChangesAsync(); } } using (StudentDbContext db = new StudentDbContext()) { Staff_Educational_Details staffEducationalDetails = await db.Staff_Educational_Details.FindAsync(id); if (staffEducationalDetails != null) { staffEducationalDetails.Is_Deleted = true; db.Entry(staffEducationalDetails).CurrentValues.SetValues(staffEducationalDetails); db.Entry(staffEducationalDetails).State = EntityState.Modified; await db.SaveChangesAsync(); } } using (StudentDbContext db = new StudentDbContext()) { Staff_Salary_Detail staffSalaryDetail = await db.Staff_Salary_Details.FindAsync(id); if (staffSalaryDetail != null) { staffSalaryDetail.Is_Deleted = true; db.Entry(staffSalaryDetail).CurrentValues.SetValues(staffSalaryDetail); db.Entry(staffSalaryDetail).State = EntityState.Modified; await db.SaveChangesAsync(); } } using (StudentDbContext db = new StudentDbContext()) { Staff_Exp_Details stafExpDetails = await db.Staff_Exp_Details.FindAsync(id); if (stafExpDetails != null) { stafExpDetails.Is_Deleted = true; db.Entry(stafExpDetails).CurrentValues.SetValues(stafExpDetails); db.Entry(stafExpDetails).State = EntityState.Modified; await db.SaveChangesAsync(); } } return(RedirectToAction("Index")); }