public async Task <IHttpActionResult> Putstudent_class(int id, student_class student_class)
{
if (!ModelState.IsValid)
{
return((IHttpActionResult)Helper.JsonConverter.Error(410, "数据访问出错"));
}
if (id != student_class.course_id)
{
return((IHttpActionResult)Helper.JsonConverter.Error(420, "查无此班级"));
}
db.Entry(student_class).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!student_classExists(id))
{
return((IHttpActionResult)Helper.JsonConverter.Error(420, "查无此人"));
}
else
{
throw;
}
}
return((IHttpActionResult)Helper.JsonConverter.BuildResult("成功"));
}
public async Task <IHttpActionResult> Putdepartment(int id, department department)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != department.dep_id)
{
return(BadRequest());
}
db.Entry(department).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!departmentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <Object> Putteacher(int id, teacher teacher)
{
if (!ModelState.IsValid)
{
return(Helper.JsonConverter.Error(410, "数据访问出错"));
}
if (id != teacher.t_id)
{
return(Helper.JsonConverter.Error(420, "用户已存在"));
}
db.Entry(teacher).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!teacherExists(id))
{
return(Helper.JsonConverter.Error(420, "查无此人"));
}
else
{
throw;
}
}
return(Helper.JsonConverter.BuildResult("成功"));
}
public static object ChangePassword(object json)
{
try
{
Dictionary <string, string> body = JsonConverter.Decode(json);
var Id = int.Parse(body["Id"]);
var oldPassword = body["oldPassword"];
var newPassword = body["newPassword"];
using (var context = new SMSModel())
{
var a_user = context.user.Find(Id);
if (a_user.password == oldPassword)
{
a_user.password = newPassword;
context.SaveChangesAsync();
return(Helper.JsonConverter.BuildResult("成功"));
}
else
{
return(Helper.JsonConverter.Error(410, "密码不正确"));
}
}
}
catch (Exception e)
{
Console.Write(e);
return(Helper.JsonConverter.Error(410, "数据库中可能存在不一致现象，请检查"));
}
}
public static object PostClass(object json)
{
Dictionary <string, string> body = JsonConverter.Decode(json);
var course_name = body["course_name"];
var dep_id = int.Parse(body["dep_id"]);
var t_id = int.Parse(body["t_id"]);
var credits = int.Parse(body["credits"]);
try
{
using (var context = new SMSModel())
{
course course = new course();
course.course_name = course_name;
course.dep_id = dep_id;
course.t_id = t_id;
course.credits = credits;
course.broadCast = "";
context.course.Add(course);
context.SaveChangesAsync();
return(Helper.JsonConverter.BuildResult("成功"));
}
}
catch (Exception e)
{
Console.Write(e);
return(Helper.JsonConverter.Error(410, "数据库中可能存在不一致现象，请检查"));
}
}
public static object GiveScore(object json)
{
try
{
Dictionary <string, string> body = JsonConverter.Decode(json);
var s_id = int.Parse(body["s_id"]);
var course_id = int.Parse(body["course_id"]);
var grade = int.Parse(body["grade"]);
using (var context = new SMSModel())
{
var a_user = context.student_class.Find(course_id, s_id);
a_user.grade = grade;
context.SaveChangesAsync();
return(Helper.JsonConverter.BuildResult("成功"));
}
}
catch (Exception e)
{
Console.Write(e);
return(Helper.JsonConverter.Error(410, "数据库中可能存在不一致现象，请检查"));
}
}
public static object ChangeBroadCast(object json)
{
try
{
Dictionary <string, string> body = JsonConverter.Decode(json);
var course_id = int.Parse(body["course_id"]);
var broadCast = body["broadCast"];
using (var context = new SMSModel())
{
var a_course = context.course.Find(course_id);
if (a_course == null)
{
return(Helper.JsonConverter.Error(410, "查无此班级"));
}
else
{
a_course.broadCast = broadCast;
context.SaveChangesAsync();
return(Helper.JsonConverter.BuildResult("成功"));
}
}
}
catch (Exception e)
{
Console.Write(e);
return(Helper.JsonConverter.Error(410, "数据库中可能存在不一致现象，请检查"));
}
}
public static object PostStudent(object json)
{
Dictionary <string, string> body = JsonConverter.Decode(json);
var Id = int.Parse(body["Id"]);
var name = body["name"];
var email = body["email"];
var tel = body["tel"];
var password = body["password"];
var dep_id = int.Parse(body["dep_id"]);
var grade = int.Parse(body["grade"]);
try
{
using (var context = new SMSModel())
{
user user = new user();
user.Id = Id;
user.name = name;
user.email = email;
user.tel = tel;
user.dep_id = dep_id;
user.password = password;
user.role = "student";
student student = new student();
student.s_id = Id;
student.grade = grade;
context.user.Add(user);
context.student.Add(student);
context.SaveChangesAsync();
return(Helper.JsonConverter.BuildResult("成功"));
}
}
catch (Exception e)
{
Console.Write(e);
return(Helper.JsonConverter.Error(410, "数据库中可能存在不一致现象，请检查"));
}
}
public static object PostStudentClass(object json)
{
Dictionary <string, string> body = JsonConverter.Decode(json);
var course_id = int.Parse(body["course_id"]);
var s_id = int.Parse(body["s_id"]);
try
{
using (var context = new SMSModel())
{
student_class stuclass = new student_class();
stuclass.course_id = course_id;
stuclass.s_id = s_id;
context.student_class.Add(stuclass);
context.SaveChangesAsync();
return(Helper.JsonConverter.BuildResult("成功"));
}
}
catch (Exception e)
{
Console.Write(e);
return(Helper.JsonConverter.Error(410, "数据库中可能存在不一致现象，请检查"));
}
}
