/// <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);
}
