/// <summary> /// 수정 /// </summary> /// <param name="model"></param> /// <returns></returns> public BadWordModel Update(BadWordModel model) { string sql = "Update BadWords Set Word = @Word Where Id = @Id"; this.con.Execute(sql, model); return(model); }
/// <summary> /// 입력 후 관련 Identity 값 반환 /// </summary> /// <param name="word"></param> /// <returns></returns> public BadWordModel AddBadWordUpgrade(BadWordModel word) { string sql = @" Insert Into BadWords (Word) Values (@Word); Select Cast(SCOPE_IDENTITY() As Int); "; var id = this.con.Query <int>(sql, word).Single(); word.Id = id; return(word); }
protected void btnAdd_Click(object sender, EventArgs e) { string word = txtWord.Text; var model = new BadWordModel(); model.Word = word; model = (new BadWordRepository()).AddBadWordUpgrade(model); this.lblDisplay.Text = String.Format("{0}번 레코드가 저장됨", model.Id); }
protected void btnAddBadWord_Click(object sender, EventArgs e) { var badWord = new BadWordModel(); badWord.Word = txtBadWord.Text.Trim(); var repo = (new BadWordRepository()); repo.AddBadWord(badWord); Response.Redirect("BadWordList.aspx"); }
protected void btnModify_Click(object sender, EventArgs e) { BadWordModel model = new BadWordModel(); model.Id = Convert.ToInt32(Request["Id"]); model.Word = txtWord.Text; BadWordRepository repository = new BadWordRepository(); repository.Update(model); strDisplay.Text = "업데이트 완료"; }
private void ReadData() { int id = Convert.ToInt32(Request["Id"]); var model = new BadWordModel(); var repo = new BadWordRepository(); model = repo.Find(id); if (model != null) { txtWord.Text = model.Word; } else { string strJs = "<script>window.alert('데이터가 없습니다.');</script>"; Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "noData", strJs); } }
/// <summary> /// 입력 /// </summary> /// <param name="word"></param> public void AddBadWord(BadWordModel model) { string sql = "Insert Into BadWords (Word) Values (@Word);"; this.con.Execute(sql, model); }