public bool actionCreate(Task task)
{
var conn = new MySqlConnection(TaskDAO.StringConnection);
try
{
conn.Open();
var sql = "INSERT INTO tasks (title, description, created_at, user_id) VALUES (@title, @description, @created_at, @user_id)";
var cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@title", task.Title);
cmd.Parameters.AddWithValue("@description", task.Description);
cmd.Parameters.AddWithValue("@created_at", DateTime.Now);
cmd.Parameters.AddWithValue("@user_id", task.User.Id);
cmd.ExecuteNonQuery();
return true;
} catch(Exception ex)
{
Console.WriteLine(ex.Message);
return false;
}
finally
{
conn.Close();
}
}
public List<Task> actionIndex()
{
try
{
var lst = new List<Task>();
var sql = "select * from " + this.Table;
var dataSet = new DataSet();
var query = new MySqlDataAdapter(sql, TaskDAO.StringConnection);
query.Fill(dataSet);
var users = TaskDAO.Entities.UserEntity.actionIndex();
foreach (var item in dataSet.Tables[0].AsEnumerable().ToList())
{
var task = new Task()
{
Id = Convert.ToInt16(item["Id"]),
Title = item["Title"].ToString(),
Description = item["Description"].ToString(),
CreatedAt = Convert.ToDateTime(item["Created_At"]),
User = users.FirstOrDefault(f => f.Id == Convert.ToInt16(item["User_id"]))
};
lst.Add(task);
}
return lst;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return null;
}
}
private void Insert()
{
var task = new Task()
{
Title = this.title,
Description = this.description,
User = this.UserSelected
};
TaskDAO.Entities.TaskEntity.actionCreate(task);
var t = TaskDAO.Entities.TaskEntity.actionIndex();
this.Tasks = new ObservableCollection<Task>(t);
this.view.grdTask.Items.Refresh();
}
