public IActionResult AddStudentGroup(AddStudentGroupRequest request) { //宿舍id参数校验 if (!request.StudentGroupId.HasValue) { //宿舍编号为空 return(Failure(ResultCode.PARAM_IS_INVALLD)); } //宿舍名参数校验 if (string.IsNullOrEmpty(request.StudentGroupName)) { //宿舍名为空 return(Failure(ResultCode.PARAM_NOT_COMPLETE)); } //判断宿舍id是否重复 var studentgroup = _demoContext.DB.Queryable <Student_Group>().InSingle(request.StudentGroupId.Value); if (studentgroup != null) { //宿舍编号重复 return(Failure(ResultCode.PARAM_NO_COMPLETE)); } //判断宿舍名是否重复 var studentGroupName = _demoContext.DB.Queryable <Student_Group>().InSingle(request.StudentGroupName); if (studentGroupName != null) { //宿舍名重复 return(Failure(ResultCode.PARAM_NAME_COMPLETE)); } Student_Group studentGroup = new Student_Group(); studentGroup.StudentGroupId = request.StudentGroupId.Value; studentGroup.StudentGroupName = request.StudentGroupName; studentGroup.IsDelete = 0; int count = _demoContext.DB.Insertable(studentGroup).ExecuteReturnIdentity(); //添加宿舍 return(count > 0 ? Success() : Failure(ResultCode.SYSTEM_INNER_ERROR)); }
public JsonResult AcceptRequest(int id) { int mystdid = Convert.ToInt32(Session["StudentId"]); var Stdreq = db.Student_Request.Where(p => p.Request_From_Id == id && p.Request_To_Id == mystdid).FirstOrDefault(); db.Dispose(); var std = new Student_Request() { ID = Stdreq.ID }; db = new FYPEntities(); db.Student_Request.Attach(std); std.Is_Active = false; std.Is_Accepted = true; std.Date_Accepeted = DateTime.Now; db.SaveChanges(); db.Dispose(); db = new FYPEntities(); group grp = new group(); grp.GroupName = "Group " + Stdreq.Request_From_Id + " --" + Stdreq.Request_To_Id; grp.Is_Active = true; grp.DateCreated = DateTime.Now; db.groups.Add(grp); db.SaveChanges(); int grpid = grp.Id; var stdgrp = new Student_Group(); stdgrp.Student_1_ID = Stdreq.Request_From_Id; stdgrp.Student_2_ID = Stdreq.Request_To_Id; stdgrp.Group_Id = grpid; db.Student_Group.Add(stdgrp); db.SaveChanges(); NotificationAdd(id); return(Json(new { success = true, msg = "Successfully sent" }, JsonRequestBehavior.AllowGet)); }
public IActionResult DelStudentGroup(DeleteStudentGroupRequest request) { // 参数校验 if (!request.StudentGroupId.HasValue) { return(Ok("宿舍编号必填,不可为空")); } // 判断是否存在 Student_Group studentGroup = _demoContext.DB.Queryable <Student_Group>().InSingle(request.StudentGroupId.Value); if (studentGroup == null) { return(Ok("该宿舍不存在")); } // 判断是否已删除 if (studentGroup.IsDelete == 1) { return(Ok("该宿舍已删除")); } // 若宿舍中有人员则不可删除 var number = _demoContext.DB.Queryable <Student_Group_Detail>().Where(it => it.StudentGroupId == request.StudentGroupId && it.IsDelete == 0).ToList(); if (number.Count == 0) { // 0=未删除;1已删除 studentGroup.IsDelete = 1; // 记录更新时间 // 记录操作日志 // 数据库影响行数 int command = _demoContext.DB.Updateable <Student_Group>(studentGroup).ExecuteCommand(); return(Ok(command > 0 ? "删除成功" : "删除失败")); } return(Ok("不可以删除")); }
public IActionResult UpdateStuGroup(UpdateStudentGroupRequest request) { //宿舍id参数校验 if (!request.StudentGroupId.HasValue) { //宿舍编号为空 return(Failure(ResultCode.PARAM_IS_INVALLD)); } //宿舍名参数校验 if (request.StudentGroupName == "") { //宿舍名为空 return(Failure(ResultCode.PARAM_NOT_COMPLETE)); } Student_Group studentGroup = new Student_Group(); studentGroup.StudentGroupId = request.StudentGroupId; studentGroup.StudentGroupName = request.StudentGroupName; //查询宿舍名 var studentgroupName = _demoContext.DB.Queryable <Student_Group>().InSingle(studentGroup.StudentGroupName); //判断是否可以查询到 if (studentgroupName == null) { //修改宿舍 int command = _demoContext.DB.Updateable(studentGroup).UpdateColumns(usg => new { usg.StudentGroupName }).ExecuteCommand(); //判断更新语句是否执行完成 if (command == 1) { //修改成功 return(Success()); } else { //修改失败 return(Failure(ResultCode.SYSTEM_INNER_ERROR)); } } //宿舍名重复 return(Failure(ResultCode.PARAM_NAME_COMPLETE)); }
public List <Student_Group> Get_All_Student_Group() { Connect(); List <Student_Group> GroupList = new List <Student_Group>(); Log.For(this).Info("Showing roles"); try { SqlCommand command = new SqlCommand("SELECT * FROM Student_Group", Connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Student_Group group = new Student_Group(); group.ID_Student_Group = Convert.ToInt32(reader["ID_Student_Group"]); group.Student_Group_Name = Convert.ToString(reader["Student_Group_Name"]); group.Student_Group_Number = Convert.ToInt32(reader["Student_Group_Number"]); GroupList.Add(group); } reader.Close(); } catch (Exception) { } finally { Disconnect(); } return(GroupList); }