public int DeleteDorm(String Id) { using (var db = new SDMSEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { Dorm dorm = db.Dorm.Find(Id); if (dorm != null) { if (dorm.UsedNum == 0) { db.Dorm.Remove(dorm); db.SaveChanges(); return(1);//完成 } else { return(3);//寝室有学生使用,请更换学生寝室 } } return(0);//寝室号不存在 } catch (Exception) { dbContextTransaction.Rollback(); return(2);//数据库添加异常 } } } }
public int DeleteStudent(string Id) { using (var db = new SDMSEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { Student dbstudent = db.Student.Find(Id); if (dbstudent != null) { Dorm dorm = db.Dorm.Find(dbstudent.DormNum); dorm.UsedNum--; dorm.AllowNum++; db.Student.Remove(dbstudent); db.SaveChanges(); return(1); //完成 } return(0); //用户不存在 } catch (Exception) { dbContextTransaction.Rollback(); return(2);//数据库添加异常 } } } }
public int EditDorm(Dorm dorm) { using (var db = new SDMSEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { Dorm dbdorm = db.Dorm.Find(dorm.DormNum); if (dbdorm == null) { db.Dorm.Add(dorm); db.SaveChanges(); dbContextTransaction.Commit(); return(1);//寝室不存在 新增 } else { dbdorm.DormNum = dorm.DormNum; dbdorm.AllowNum = dorm.AllowNum; dbdorm.LouNum = dorm.LouNum; dbdorm.UsedNum = dorm.UsedNum; db.SaveChanges(); dbContextTransaction.Commit(); return(0);//寝室号已存在,修改 } } catch (Exception) { dbContextTransaction.Rollback(); return(2);//数据库添加异常 } } } }
public DormDetail SearchDorm(string dormNum) { Dorm dorm = db.Dorm.Find(dormNum); IEnumerable <WaterAndElectricity> waterAndElectricity = db.WaterAndElectricity.Where(e => e.DormNum == dorm.DormNum); IEnumerable <Student> students = db.Student.Where(e => e.DormNum == dorm.DormNum); IEnumerable <DormHygiene> dormHygienes = db.DormHygiene.Where(e => e.DormNum == dorm.DormNum); return(new DormDetail { dorm = dorm, waterAndElectricity = waterAndElectricity, students = students, dormHygienes = dormHygienes }); }