public bool Add(Student student) { bool isAdded = false; _dbContext.Parents.Add(student.Parent); bool isParentAdd = _dbContext.SaveChanges() > 0; if (isParentAdd == true) { BankAccount bankAcc = new BankAccount() { BankId = student.BankAccount.BankId, AccNumber = student.BankAccount.AccNumber }; student.ParentId = student.Parent.Id; student.Parent = null; student.BankAccount = null; _dbContext.Students.Add(student); bankAcc.StudentId = student.Id; _dbContext.BankAccounts.Add(bankAcc); isAdded = _dbContext.SaveChanges() > 0; } return(isAdded); }
public bool Update(Student student) { DbContextSMS db = new DbContextSMS(); db.Parents.Attach(student.Parent); db.Entry(student.Parent).State = EntityState.Modified; bool isUpdate = db.SaveChanges() > 0; db.BankAccounts.Attach(student.BankAccount); db.Entry(student.BankAccount).State = EntityState.Modified; isUpdate = db.SaveChanges() > 0; List <Image> imgList = student.Images; student.Images = null; student.BankAccount = null; foreach (var skl in student.Skills) { DbContextSMS dbCon = new DbContextSMS(); dbCon.Skills.Attach(skl); dbCon.Entry(skl).State = EntityState.Modified; dbCon.SaveChanges(); } student.Skills = null; db.Students.Attach(student); db.Entry(student).State = EntityState.Modified; isUpdate = db.SaveChanges() > 0; //add all images if (imgList.Count > 0) { foreach (var img in imgList) { Image imgObj = new Image() { StudentId = student.Id, FileName = img.FileName }; db.Images.Add(imgObj); db.SaveChanges(); } } return(isUpdate); }
public bool Update(Department department) { DbContextSMS db = new DbContextSMS(); db.Departments.Attach(department); db.Entry(department).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public bool Update(Country country) { DbContextSMS db = new DbContextSMS(); db.Countries.Attach(country); db.Entry(country).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public bool Update(Sesion session) { DbContextSMS db = new DbContextSMS(); db.Sessions.Attach(session); db.Entry(session).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public bool Update(Bank bank) { DbContextSMS db = new DbContextSMS(); db.Banks.Attach(bank); db.Entry(bank).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public bool Update(Semister semister) { DbContextSMS db = new DbContextSMS(); db.Semisters.Attach(semister); db.Entry(semister).State = EntityState.Modified; return(db.SaveChanges() > 0); }
public bool Add(User user) { _dbContext.Users.Add(user); return(_dbContext.SaveChanges() > 0); }
public bool Add(Department department) { _dbContext.Departments.Add(department); return(_dbContext.SaveChanges() > 0); }
public bool Add(Sesion session) { _dbContext.Sessions.Add(session); return(_dbContext.SaveChanges() > 0); }
public bool Add(Bank bank) { _dbContext.Banks.Add(bank); return(_dbContext.SaveChanges() > 0); }
public bool Add(Country country) { _dbContext.Countries.Add(country); return(_dbContext.SaveChanges() > 0); }
public bool Add(City city) { _dbContext.Cities.Add(city); return(_dbContext.SaveChanges() > 0); }
public bool Add(Semister semister) { _dbContext.Semisters.Add(semister); return(_dbContext.SaveChanges() > 0); }