/// <summary> /// 标记 /// </summary> /// <param name="targrt">被标记目标id</param> /// <param name="user">用户id</param> /// <param name="type">1想看电影,2看过电影,3喜欢电影,4收藏影人,5赞资源,6同求资源,7关注专辑</param> public static void Create(string targrt, string user, int type) { //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) using (MRDataEntities _db = new MRDataEntities()) { if (MarkManager.Validate(targrt, user, type)) { return; } var mark = new tbl_Mark(); string guid; do { guid = Guid.NewGuid().ToString("N").ToUpper(); } while (_db.tbl_Mark.Where(p => p.mark_Id == guid).Count() != 0); mark.mark_Id = guid; mark.mark_Target = targrt; mark.mark_User = user; mark.mark_Type = (byte)type; //_db.tbl_Mark.InsertOnSubmit(mark); //_db.SubmitChanges(); //_db.SetMarkMovieTime(mark.mark_Id); _db.tbl_Mark.Add(mark); _db.SaveChanges(); } }
public async Task <IActionResult> Add([FromBody] Mark request) { try { if (request == null) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "invalid payload." })); } if (request.StudentID <= 0) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "`StudentID` is mandatory." })); } if (request.SubjectID <= 0) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "`SubjectID` is mandatory." })); } if (!await _DbContext.tbl_Marks.AnyAsync(x => x.StudentID == request.StudentID)) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "`StudentID` is invalid." })); } if (!await _DbContext.tbl_Marks.AnyAsync(x => x.SubjectID == request.SubjectID)) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "`SubjectID` is invalid." })); } var newRecord = new tbl_Mark { StudentID = request.StudentID, SubjectID = request.SubjectID, StudentMark = request.StudentMark }; await _DbContext.tbl_Marks.AddAsync(newRecord); await _DbContext.SaveChangesAsync(); return(StatusCode(StatusCodes.Status200OK, new ApiResponse { success = true, message = "success", data = newRecord })); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, new ApiResponse { message = "unexpected error", data = ex.Message })); } }
public async Task <IActionResult> Update([FromBody] tbl_Mark request) { try { if (request == null) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "invalid payload." })); } if (request.ID <= 0) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "`ID` is mandatory." })); } if (request.StudentID <= 0) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "`StudentID` is mandatory." })); } if (request.SubjectID <= 0) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "`SubjectID` is mandatory." })); } var markDetail = await _DbContext.tbl_Marks.Where(x => x.ID == request.ID).FirstOrDefaultAsync(); if (markDetail == null) { return(StatusCode(StatusCodes.Status400BadRequest, new ApiResponse { message = "`ID` is invalid." })); } markDetail.StudentID = request.StudentID; markDetail.SubjectID = request.SubjectID; markDetail.StudentMark = request.StudentMark; await _DbContext.SaveChangesAsync(); return(StatusCode(StatusCodes.Status200OK, new ApiResponse { success = true, message = "success", data = markDetail })); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, new ApiResponse { message = "unexpected error", data = ex.Message })); } }