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 PostAddVieResult()
{
try
{
var id = System.Web.HttpContext.Current.Request.Params["image_id"];
var vie1 = System.Web.HttpContext.Current.Request.Params["vie_1"];
var vie2 = System.Web.HttpContext.Current.Request.Params["vie_2"];
var vie3 = System.Web.HttpContext.Current.Request.Params["vie_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.VieResults
where im.vieId == id
select im;
if (result.Count() == 0)
{
VieResult newResult = new VieResult
{
vieId = id,
vie1 = vie1,
vie2 = vie2,
vie3 = vie3,
active = true
};
db.VieResults.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("vie_id", newResult.vieId);
response.data.Add("vie_1", newResult.vie1);
response.data.Add("vie_2", newResult.vie2);
response.data.Add("vie_3", newResult.vie3);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
else
{
result.First().vie1 = vie1;
result.First().vie2 = vie2;
result.First().vie3 = vie3;
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("vie_id", result.First().vieId);
response.data.Add("vie_1", result.First().vie1);
response.data.Add("vie_2", result.First().vie2);
response.data.Add("vie_3", result.First().vie3);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
}
catch (Exception ex)
{
return(ErrorResponseMessage("Có lỗi xảy ra. Vui lòng thử lại sau."));
}
}
