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"));
}
