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