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