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