public bool update(LoginInfomation loginInfo, string key, PubMemo item)
{
try
{
using (var conn = new WebMemoDBDataContext(getConnectionString(loginInfo)))
{
PubMemo src = (from s in conn.PubMemo
where s.id == item.id
select s).FirstOrDefault();
src.title = item.title;
src.category1 = item.category1;
src.category2 = item.category2;
src.category3 = item.category3;
src.memo = item.memo;
conn.SubmitChanges();
return(true);
}
}
catch (SqlException ex)
{
ex.ToString();
return(false);
}
}
private void menuDetail_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow.DataBoundItem != null)
{
PubMemo srcItem = dataGridView1.CurrentRow.DataBoundItem as PubMemo;
displayHTML(srcItem);
}
}
public FormRecordDetail(Mode mode, PubMemo srcItem)
{
InitializeComponent();
this.Load += (s, e) => Form_Restore.LoadPosSize(this, FORM_NAME);
this.FormClosed += (s, e) => Form_Restore.SavePosSize(this, FORM_NAME);
//this.Load += FormRecordDetail_Load;
this.mode = mode;
this.srcItem = srcItem;
}
private void displayHTML(PubMemo item)
{
StringBuilder sb = new StringBuilder();
sb.Append(Properties.Settings.Default.htmlHeaderV44);
sb.Append(item.memo);
sb.Append(Properties.Settings.Default.htmlTailV44);
HtmlDocument doc = webBrowser1.Document;
doc.Body.InnerHtml = sb.ToString();
//doc.Body.InnerHtml = string.Format(Properties.Settings.Default.htmlHeader, item.memo);
}
public bool insert(LoginInfomation loginInfo, string key, PubMemo item)
{
try
{
using (var conn = new WebMemoDBDataContext(getConnectionString(loginInfo)))
{
conn.PubMemo.InsertOnSubmit(item);
conn.SubmitChanges();
return(true);
}
}
catch (SqlException ex)
{
ex.ToString();
return(false);
}
}
private void menuDelete_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow.DataBoundItem != null)
{
PubMemo item = dataGridView1.CurrentRow.DataBoundItem as PubMemo;
string msg = "데이타를 삭제할까요?";
DialogResult result = MessageBox.Show(msg, "삭제", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result == System.Windows.Forms.DialogResult.OK)
{
dbService.delete(loginInfo, item);
showAllRecord();
}
}
else
{
MessageBox.Show("삭제할 항목을 먼저 선택해야 합니다.");
}
}
private void menuEdit_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow.DataBoundItem != null)
{
PubMemo srcItem = dataGridView1.CurrentRow.DataBoundItem as PubMemo;
FormRecordDetail formRecord = new FormRecordDetail(FormRecordDetail.Mode.EDIT, srcItem);
formRecord.ShowDialog();
if (formRecord.formResult == true)
{
dbService.update(loginInfo, loginInfo.password, formRecord.srcItem);
showAllRecord();
}
}
else
{
MessageBox.Show("수정할 항목을 먼저 선택해야 합니다.");
}
}
private void btnOK_Click(object sender, EventArgs e)
{
switch (mode)
{
case Mode.INSERT:
srcItem = new PubMemo();
updateDataFromUI();
break;
case Mode.EDIT:
updateDataFromUI();
break;
case Mode.SHOW:
break;
}
formResult = true;
this.Close();
}
public bool delete(LoginInfomation loginInfo, PubMemo item)
{
try
{
using (var conn = new WebMemoDBDataContext(getConnectionString(loginInfo)))
{
PubMemo src = (from s in conn.PubMemo
where s.id == item.id
select s).FirstOrDefault();
conn.PubMemo.DeleteOnSubmit(src);
conn.SubmitChanges();
return(true);
}
}
catch (SqlException ex)
{
ex.ToString();
return(false);
}
}
