/*
* Create By 付文欣
* 根据专业号修改专业名称
* 成功添加返回1，失败返回0，异常返回-1
*/
public int changeNameById(int id,String newName)
{
try
{
MajorDBContext majorDBContext = new MajorDBContext();
Major major = majorDBContext.majors.Where(m => m.id == id).ToList()[0];
major.name = newName;
return majorDBContext.SaveChanges();
}
catch (Exception e)
{
//throw e;
//LogUtil.writeLogToFile(e);
return -1;
}
}
/*
* Create By 高晔
* 创建和初始化本地数据库
*/
public static void initLocalDB()
{
StudentDBContext studentDB = new StudentDBContext();
studentDB.students.Find("");
AdminDBContext adminDB = new AdminDBContext();
adminDB.admins.Find("");
DeanDBContext deanDB = new DeanDBContext();
deanDB.deans.Find("");
ProfessorDBContext professorDB = new ProfessorDBContext();
professorDB.professors.Find("");
SettingDBContext settingDBContext = new SettingDBContext();
//settingDBContext.settings.Find("");
MajorDBContext majorDBContext = new MajorDBContext();
majorDBContext.majors.Find(0);
}
/*
* Create By 付文欣
* 根据专业号删除专业
* 成功删除返回1，失败返回0，异常返回-1
*/
public int deleteMajorById(int id)
{
try
{
Major major = null;
MajorDBContext majorDBContext = new MajorDBContext();
if ((major = majorDBContext.majors.Find(id)) != null)
{
majorDBContext.majors.Remove(major);
return majorDBContext.SaveChanges();
}
else
return 0;
}
catch (Exception e)
{
//throw e;
//LogUtil.writeLogToFile(e);
return -1;
}
}
/*
* Create By 付文欣
* 添加一个专业
* 成功添加返回1，失败返回0，异常返回-1
*/
public int addMajor(string name)
{
try
{
MajorDBContext majorDBContext = new MajorDBContext();
if(majorDBContext.majors.Where(m=> m.name == name).Count() > 0)
{
return 0;
}
Major major = new Major();
major.name = name;
majorDBContext.majors.Add(major);
return majorDBContext.SaveChanges();
}
catch (Exception e)
{
//throw e;
//LogUtil.writeLogToFile(e);
return -1;
}
}
/*
* Create By 付文欣
* 根据专业号删除多个专业
* 成功删除返回大于0的数，失败返回0，异常返回-1
*/
public int deleteMajorsByIds(List<String> ids)
{
try
{
Major major;
MajorDBContext majorDBContext = new MajorDBContext();
foreach (var id in ids)
{
if ((major = majorDBContext.majors.Find(id)) != null)
{
majorDBContext.majors.Remove(major);
}
else
return 0;
}
return majorDBContext.SaveChanges();
}
catch (Exception e)
{
//throw e;
//LogUtil.writeLogToFile(e);
return -1;
}
}
/*
* Create by 付文欣
* 通过专业号获取专业
*/
public Major getMajorById(int id)
{
MajorDBContext majorDBContext = new MajorDBContext();
Major major = majorDBContext.majors.Find(id);
return major;
}
