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."));
}
}
