public JsonResult Put(int id, [FromBody] Maxim maxim)
{
if (!ModelState.IsValid)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new { Message = "실패", ModelState = ModelState }));
}
if (id != maxim.Id)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new { Message = "실패", ModelState = ModelState }));
}
try
{
// 데이터 수정
repo.UpdateMaxim(maxim);
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.NotFound;
return(Json(
new { Message = $"실패: {ex}", ModelState = ModelState }));
}
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(maxim));
}
//수정
public Maxim UpdateMaxim(Maxim model)
{
string sql = "Update Maxims Set Name = @Name, Content = @Content Where Id= @Id";
this.db.Execute(sql, model);
return(model);
}
public ActionResult DeleteConfirmed(int id)
{
Maxim maxim = db.Maxims.Find(id);
db.Maxims.Remove(maxim);
db.SaveChanges();
return(RedirectToAction("Index", "Maxims"));
}
public ActionResult Edit([Bind(Include = "Id,Name,Content")] Maxim maxim)
{
if (ModelState.IsValid)
{
db.Entry(maxim).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Maxims"));
}
return(View(maxim));
}
//입력
public Maxim AddMaxim(Maxim model)
{
string sql = @"Insert Into Maxims(Name,Content) Values(@Name, @Content);
Select Cast(SCOPE_IDENTITY() As Int);";
var id = this.db.Query <int>(sql, model).Single();
model.Id = id;
return(model);
}
private void DisplayData()
{
int id = Convert.ToInt32(Request.QueryString["Id"]);
MaximServiceRepository repo = new MaximServiceRepository();
Maxim maxim = repo.GetMaximById(id);
this.lblId.Text = id.ToString();
this.txtName.Text = maxim.Name;
this.txtContent.Text = maxim.Content;
}
//GET: api/MaximService/5
public Maxim Get(int id)
{
//데이터 조회
Maxim maxim = repo.GetMaximById(id);
if (maxim == null)
{
throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(maxim);
}
public Maxim GetById(int id)
{
// 데이터 조회
Maxim maxim = repo.GetMaximById(id);
if (maxim == null)
{
Response.StatusCode = (int)HttpStatusCode.NotFound;
return(null);
}
return(maxim);
}
protected void btnWrite_Click(object sender, EventArgs e)
{
Maxim maxim = new Maxim();
maxim.Name = txtName.Text;
maxim.Content = txtContent.Text;
MaximServiceRepository repo = new MaximServiceRepository();
maxim.Id = repo.AddMaxim(maxim).Id;
lblDisplay.Text = maxim.Id.ToString() + "번 데이터가 입력되었습니다.";
}
public ActionResult Create([Bind(Include = "Id,Name,Content")] Maxim maxim)
{
if (ModelState.IsValid)
{
maxim.CreationDate = DateTime.Now; // # 날짜 추가
db.Maxims.Add(maxim);
db.SaveChanges();
return(RedirectToAction("Index", "Maxims"));
}
return(View(maxim));
}
// GET: Maxims/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Maxim maxim = db.Maxims.Find(id);
if (maxim == null)
{
return(HttpNotFound());
}
return(View(maxim));
}
// DELETE: api/MaximService/5
public HttpResponseMessage Delete(int id)
{
Maxim maxim = repo.GetMaximById(id);
if (maxim == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
// 데이터 삭제
repo.RemoveMaxim(id);
return(Request.CreateResponse(HttpStatusCode.OK, maxim));
}
private void DisplayData()
{
int id = Convert.ToInt32(Request.QueryString["Id"]);
MaximServiceRepository repo = new MaximServiceRepository();
Maxim maxim = repo.GetMaximById(id);
this.lblId.Text = id.ToString();
this.lblName.Text = maxim.Name;
this.lblContent.Text = maxim.Content;
this.btnModify.NavigateUrl = "FrmMaximModify.aspx?Id=" + id;
this.btnDelete.NavigateUrl = "FrmMaximDelete.aspx?Id=" + id;
}
//PUT: api/MaximService/5
public HttpResponseMessage Put(int id, [FromBody] Maxim maxim)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
if (id != maxim.Id)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest)); //400
}
//데이터 수정
repo.UpdateMaxim(maxim);
return(Request.CreateResponse(HttpStatusCode.OK));
}
public JsonResult Post([FromBody] Maxim maxim)
{
if (ModelState.IsValid)
{
// 데이터 입력
repo.AddMaxim(maxim);
Response.StatusCode = (int)HttpStatusCode.Created;
return(Json(maxim));
}
else
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Json(new { Message = "실패", ModelState = ModelState }));
}
}
//POST: api/MaximService
public HttpResponseMessage Post([FromBody] Maxim maxim)
{
if (ModelState.IsValid)
{
//데이터 입력
repo.AddMaxim(maxim);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, maxim); //상태코드와 데이터가 포함된 HTTP응답 메시지
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = maxim.Id })); //지정된 경로에 대한 링크 반환
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); //400(모델 상태의 오류)
}
}
protected void btnModify_Click(object sender, EventArgs e)
{
Maxim maxim = new Maxim();
//Id를 채워서 넘겨줌.
maxim.Id = Convert.ToInt32(Request.QueryString["Id"]);
maxim.Name = txtName.Text;
maxim.Content = txtContent.Text;
MaximServiceRepository repo = new MaximServiceRepository();
maxim = repo.UpdateMaxim(maxim);
lblDisplay.Text = maxim.Id.ToString() + "번 데이터가 수정되었습니다.";
DisplayData();
}
public IActionResult GetById(int id)
{
try
{
// 데이터 조회
Maxim maxim = repo.GetMaximById(id);
if (maxim == null)
{
// 에러에 대한 정보를 전달
return(NotFound($"{id}에 해당하는 값을 찾을 수 없습니다."));
}
return(Ok(maxim));
}
catch
{
return(BadRequest());
}
}
// DELETE: api/MaximService/5
public HttpResponseMessage Delete(int id)
{
Maxim maxim = repo.GetMaximById(id);
if (maxim == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
try
{
// 데이터 삭제
repo.RemoveMaxim(id);
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK, maxim));
}
///// <summary>
///// 상세 보기 전용 Web API 코드 샘플
///// </summary>
//public HttpResponseMessage Get(string boardName, int boardNum)
//{
// var model = _repository.GetById(boardName, boardNum);
// if (model == null)
// {
// return Request.CreateErrorResponse(
// HttpStatusCode.NotFound, "항목이 없습니다.");
// }
// return Request.CreateResponse(HttpStatusCode.OK, model);
//}
// POST: api/MaximService
public HttpResponseMessage Post([FromBody] Maxim maxim)
{
if (ModelState.IsValid)
{
// 데이터 입력
repo.AddMaxim(maxim);
HttpResponseMessage response =
Request.CreateResponse(HttpStatusCode.Created, maxim);
response.Headers.Location =
new Uri(Url.Link("DefaultApi", new { id = maxim.Id }));
//new Uri(Request.RequestUri + maxim.Id.ToString());
return(response);
}
else
{
return(Request.CreateErrorResponse(
HttpStatusCode.BadRequest, ModelState));
}
}
// GET: api/MaximService/5
public Maxim Get(int id)
{
// 데이터 조회
Maxim maxim = repo.GetMaximById(id);
if (maxim == null)
{
throw new HttpResponseException(
Request.CreateResponse(HttpStatusCode.NotFound));
// 또 다른 표현 방법
//return Request.CreateErrorResponse(
// HttpStatusCode.NotFound, "항목이 없습니다.");
}
//else
//{
// // 반환값을 HttpResponseMessage로 설정했을 때에는 아래 방법도 가능
// Request.CreateResponse<Maxim>(HttpStatusCode.OK, maxim);
//}
return(maxim);
}
// PUT: api/MaximService/5
public HttpResponseMessage Put(int id, [FromBody] Maxim maxim)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(
HttpStatusCode.BadRequest, ModelState));
}
if (id != maxim.Id)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
try
{
// 데이터 수정
repo.UpdateMaxim(maxim);
}
catch (DbUpdateConcurrencyException ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
public JsonResult Delete(int id)
{
Maxim maxim = repo.GetMaximById(id);
if (maxim == null)
{
Response.StatusCode = (int)HttpStatusCode.NotFound;
return(Json(new { Message = "실패", ModelState = ModelState }));
}
try
{
// 데이터 삭제
repo.RemoveMaxim(id);
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.NotFound;
return(Json(
new { Message = $"실패: {ex}", ModelState = ModelState }));
}
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(maxim));
}
public ActionResult Create(Maxim model)
{
repo.AddMaxim(model);
return(RedirectToAction("Index", "Maxim"));
}
