private void btn_modify_Click(object sender, EventArgs e)
{
if (ck_modify.Checked)
{
DateTime startDate = DateTime.ParseExact(Todo_startDate.Value.ToString("MM-dd-yyyy") + " " + Todo_StartHour.Text + ":" + Todo_StartMinute.Text + ":00", "MM-dd-yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
DateTime todoDeadLine = DateTime.ParseExact(Todo_EndDate.Value.ToString("MM-dd-yyyy") + " " + Todo_EndHour.Text + ":" + Todo_EndMinute.Text + ":00", "MM-dd-yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
TodolistVO todolist = new TodolistVO(Todo_contents.Text, startDate, todoDeadLine, loginUser);
todolist.TodoNo = Convert.ToInt32(Todo_contents.Name);
if (todoListDao.UpdateTodolist(todolist))
{
DialogResult = DialogResult.OK;
}
}
else
{
MessageBox.Show("동의에 체크해 주세요 ");
}
}
public bool InsertTodoList(TodolistVO todolist)
{
DataSet ds = new DataSet();
string query = string.Empty;
try
{
query = @"
INSERT INTO root2.TODO_T(
TOD_CONTENTS
,TOD_START_DATE
,TOD_DEADLINE_DATE
,US_EMAIL
,TOD_REGDATE
)
VALUES(
'#TOD_CONTENTS'
,TO_DATE('#TOD_START_DATE','YYYY-MM-DD HH24:MI:SS')
,TO_DATE('#TOD_DEADLINE_DATE','YYYY-MM-DD HH24:MI:SS')
,'#US_EMAIL'
,sysdate
)";
query = query.Replace("#TOD_CONTENTS", todolist.TodoContent);
query = query.Replace("#TOD_START_DATE", "" + todolist.TodoStartDate.ToString("yyyy-MM-dd HH:mm:ss"));
query = query.Replace("#TOD_DEADLINE_DATE", ""+ todolist.TodoDeadLine.ToString("yyyy-MM-dd HH:mm:ss"));
query = query.Replace("#US_EMAIL", todolist.Email);
int result = db.ExecuteNonQuery(query);
if (result > 0)
{
return true;
}
return false;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
}
public bool UpdateTodolist(TodolistVO todolist)
{
DataSet ds = new DataSet();
string query = string.Empty;
try
{
query = @"
UPDATE root2.TODO_T
SET
TOD_CONTENTS ='#TOD_CONTENTS'
,TOD_START_DATE = TO_DATE('#TOD_START_DATE','YYYY-MM-DD HH24:MI:SS')
,TOD_DEADLINE_DATE = TO_DATE('#TOD_DEADLINE_DATE','YYYY-MM-DD HH24:MI:SS')
,TOD_REGDATE = sysdate
WHERE
TOD_NO = '#TOD_NO'
";
query = query.Replace("#TOD_NO", ""+todolist.TodoNo);
query = query.Replace("#TOD_CONTENTS", todolist.TodoContent);
query = query.Replace("#TOD_START_DATE", "" + todolist.TodoStartDate.ToString("yyyy-MM-dd HH:mm:ss"));
query = query.Replace("#TOD_DEADLINE_DATE", "" + todolist.TodoDeadLine.ToString("yyyy-MM-dd HH:mm:ss"));
int result = db.ExecuteNonQuery(query);
if (result > 0)
{
return true;
}
return false;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
}
