public HttpResponseMessage PostAddImage(JObject requestParam) { try { var obj = JsonConvert.DeserializeObject <ImageObject>(requestParam.ToString()); //var lastImage = (from im in db.Images // orderby im.imageId descending // select im.imageId).First(); var last = (from im in db.Images select im.imageId).Count(); var user = from us in db.Users where us.userName == obj.username select us; int p = last + 1; string id = "Image" + p.ToString(); if (user.Count() == 0) { return(ErrorResponseMessage("Ten dang nhap khong ton tai.")); } Image image = new Image { imageId = id, imageName = obj.name, timeShoot = obj.time, userId = user.First().userId, active = true }; EngResult eng = new EngResult { engId = id, eng1 = obj.engsub.eng_1, eng2 = obj.engsub.eng_2, eng3 = obj.engsub.eng_3, active = true, }; VieResult vie = new VieResult { vieId = id, vie1 = obj.vietsub.vie_1, vie2 = obj.vietsub.vie_2, vie3 = obj.vietsub.vie_3, active = true }; db.Images.Add(image); db.SaveChanges(); db.EngResults.Add(eng); db.VieResults.Add(vie); db.SaveChanges(); ObjectResponse response = new ObjectResponse { status = new Status(200, "Thêm vào thành công"), data = new Dictionary <string, dynamic>() }; return(Request.CreateResponse(HttpStatusCode.OK, response)); } catch (Exception ex) { return(ErrorResponseMessage("Có lỗi xảy ra. Vui lòng thử lại sau." + ex.Message)); } }
public HttpResponseMessage PostAddEngResult() { try { var id = System.Web.HttpContext.Current.Request.Params["image_id"]; var eng1 = System.Web.HttpContext.Current.Request.Params["eng_1"]; var eng2 = System.Web.HttpContext.Current.Request.Params["eng_2"]; var eng3 = System.Web.HttpContext.Current.Request.Params["eng_3"]; var image = from im in db.Images where im.imageId == id select im; if (image.Count() == 0) { return(ErrorResponseMessage("Hình ảnh không hợp lệ.")); } var result = from im in db.EngResults where im.engId == id select im; if (result.Count() == 0) { EngResult newResult = new EngResult { engId = id, eng1 = eng1, eng2 = eng2, eng3 = eng3, active = true }; db.EngResults.InsertOnSubmit(newResult); db.SubmitChanges(); ObjectResponse response = new ObjectResponse { status = new Status(200, "Thêm vào thành công"), data = new Dictionary <string, dynamic>() }; response.data.Add("eng_id", newResult.engId); response.data.Add("eng_1", newResult.eng1); response.data.Add("eng_2", newResult.eng2); response.data.Add("eng_3", newResult.eng3); return(Request.CreateResponse(HttpStatusCode.OK, response)); } else { result.First().eng1 = eng1; result.First().eng2 = eng2; result.First().eng3 = eng3; result.First().active = true; db.SubmitChanges(); ObjectResponse response = new ObjectResponse { status = new Status(200, "Ghi đè thành công"), data = new Dictionary <string, dynamic>() }; response.data.Add("eng_id", result.First().engId); response.data.Add("eng_1", result.First().eng1); response.data.Add("eng_2", result.First().eng2); response.data.Add("eng_3", result.First().eng3); return(Request.CreateResponse(HttpStatusCode.OK, response)); } } catch (Exception ex) { return(ErrorResponseMessage("Có lỗi xảy ra. Vui lòng thử lại sau.")); } }