private void AddData()
{
try
{
m_Log.Trace("AddData({0})", textBoxShow.Text);
using (TodoListEntities context = new TodoListEntities())
{
TodoList todoList = new TodoList();
{
todoList.Name = textBoxShow.Text;
todoList.TodoDate = Convert.ToDateTime(dateTimePickerDate.Text);
// TODO: dodac obsluge godziny
//TodoDate = Convert.ToDateTime(string.Format("{0} {1}", dateTimePickerDate.Text, dateTimePickerTime.Text)),
todoList.Descpription = richTextBoxRecipes.Text;
};
m_Log.Trace("AddData({0})", todoList);
context.TodoLists.Add(todoList);
context.SaveChanges();
}
}
catch (Exception ex)
{
m_Log.Error(ex);
}
}
private void DeleteData()
{
m_Log.Trace("DeleteData({0})", FormInfo.TextBoxShowValue);
using (TodoListEntities contextt = new TodoListEntities())
{
TodoList todoList = contextt.TodoLists.FirstOrDefault(r => r.Name == FormInfo.TextBoxShowValue);
if (todoList != null)
{
contextt.TodoLists.Remove(todoList);
contextt.SaveChanges();
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
m_Log.Trace("Form1_Load()");
using (TodoListEntities context = new TodoListEntities())
{
m_Log.Trace("App Connection string: {0}", context.Database.Connection.ConnectionString);
}
SelectData();
groupBox1.Visible = true;
// TODO: dodac obsluge godziny
dateTimePickerTime.Visible = false;
}
private void EditData()
{
m_Log.Trace("EditData()");
using (TodoListEntities contextt = new TodoListEntities())
{
TodoList todoList = contextt.TodoLists.FirstOrDefault(r => r.Name == FormInfo.TextBoxShowValue);
if (todoList != null)
{
todoList.Name = textBoxShow.Text;
todoList.TodoDate = Convert.ToDateTime(dateTimePickerDate.Text);
todoList.Descpription = richTextBoxRecipes.Text;
}
contextt.SaveChanges();
}
}
//private void dateTimePickerFilter_ValueChanged(object sender, EventArgs e)
//{
// m_Log.Trace("dateTimePickerFilter_ValueChanged()");
// labelTodoItemsDate.Text = dateTimePickerFilter.Text;
// DataTable dt = new DataTable();
// SqlConnection conn = new SqlConnection();
// conn.ConnectionString =
// ConfigurationManager.ConnectionStrings[FormInfo.ConnectionStringName]
// .ConnectionString;
// DateTime dateTimePickerFilterDate = Convert.ToDateTime(dateTimePickerFilter.Text);
// try
// {
// conn.Open();
// SqlCommand myCmd = new SqlCommand("SelectTodo", conn);
// myCmd.CommandType = CommandType.StoredProcedure;
// //myCmd.Parameters.AddWithValue("@TodoDate", "%" + dateTimePickerFilterDate.ToString(FormInfo.DateFormatDate) + "%");
// //myCmd.Parameters.Add("@TodoDate", SqlDbType.NVarChar).Value = "%" + dateTimePickerFilterDate.ToString(FormInfo.DateFormatDate) + "%";
// myCmd.Parameters.Add("@TodoDate", SqlDbType.NVarChar).Value = dateTimePickerFilterDate.ToString(FormInfo.DateFormatDate);
// m_Log.Trace("dateTimePickerFilterDate.ToString(FormInfo.DateFormatDate): {0}", dateTimePickerFilterDate.ToString(FormInfo.DateFormatDate));
// SqlDataAdapter da = new SqlDataAdapter(myCmd);
// da.Fill(dt);
// dataGridViewRecipes.DataSource = dt;
// }
// catch (Exception ex)
// {
// m_Log.Error(ex);
// }
// finally
// {
// conn.Close();
// }
//}
private void dateTimePickerFilter_ValueChanged(object sender, EventArgs e)
{
m_Log.Trace("dateTimePickerFilter_ValueChanged()");
labelTodoItemsDate.Text = dateTimePickerFilter.Text;
{
try
{
DateTime dt = Convert.ToDateTime(dateTimePickerFilter.Text);
using (TodoListEntities contextt = new TodoListEntities())
{
var todoList = contextt.TodoLists
.Where(t => t.TodoDate == dt).ToArray();
dataGridViewRecipes.DataSource = todoList;
}
}
catch (Exception ex)
{
m_Log.Error(ex);
}
}
}
private void SelectData()
{
m_Log.Trace("SelectData() - ladowanie contentu do tabeli...");
labelFilterDate.Text = Resources.txtTimeItemsFrom;
labelTodoItemsDate.Text = Resources.txtAllTimeItems;
try
{
using (TodoListEntities contextt = new TodoListEntities())
{
var todoList = (from b in contextt.TodoLists
orderby b.TodoDate descending
select b).ToArray();
dataGridViewRecipes.DataSource = todoList;
}
}
catch (Exception ex)
{
m_Log.Error(ex);
MessageBox.Show(string.Format("{0}", ex));
}
}