public dynamic Update(ExtratimeActive data) { using (var dbContextTransaction = entity.Database.BeginTransaction()) { try { var model2 = entity.Attendances.Where(p => p.ActiveCode == data.PID).ToList(); entity.Attendances.RemoveRange(model2); entity.SaveChanges(); dynamic xa = JsonConvert.DeserializeObject(data.Participant); var a = xa[0].Value; var n = xa.Count; List <Attendance> listAttendance = new List <Attendance>(); for (int i = 0; i < n; i++) { Attendance attendance = new Attendance(); attendance.TeacherCode = xa[i].Value; attendance.ActiveCode = data.PID; listAttendance.Add(attendance); } entity.Attendances.AddRange(listAttendance); entity.ExtratimeActives.Add(data); entity.Entry(data).State = System.Data.Entity.EntityState.Modified; entity.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); return(false); } } }
public dynamic Save(ExtratimeActive data) { using (var dbContextTransaction = entity.Database.BeginTransaction()) { dynamic xa = JsonConvert.DeserializeObject(data.Participant); var a = xa[0].Value; var n = xa.Count; // List<string> teacherCode = new List<string>(); try { entity.ExtratimeActives.Add(data); entity.SaveChanges(); List <Attendance> listAttendance = new List <Attendance>(); for (int i = 0; i < n; i++) { Attendance attendance = new Attendance(); attendance.TeacherCode = xa[i].Value; attendance.ActiveCode = data.PID; listAttendance.Add(attendance); } entity.Attendances.AddRange(listAttendance); entity.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); return(false); } } }