void TasksLoad()
{
string find;
int priorityID;
int stateID;
DateTime?startDate = null,
endDate = null;
if (!string.IsNullOrEmpty(dpStart.Value))
{
startDate = DateTime.Parse(dpStart.Value);
}
if (!string.IsNullOrEmpty(dpEnd.Value))
{
endDate = DateTime.Parse(dpEnd.Value);
}
if (txtSearchTask.Text == string.Empty)
{
find = string.Empty;
}
else
{
find = txtSearchTask.Text;
}
priorityID = int.Parse(ddlTaskPriority.SelectedValue);
stateID = int.Parse(ddlTaskState.SelectedValue);
SqlConnection sqlConnection1 = new SqlConnection(TasksSqldataSource.ConnectionString);
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
try
{
cmd.CommandText = "[task].[sp_search_tasks]";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = sqlConnection1;
cmd.Parameters.AddWithValue("@find", find);
cmd.Parameters.AddWithValue("@user", User.Identity.Name);
cmd.Parameters.AddWithValue("@priorityID", priorityID);
cmd.Parameters.AddWithValue("@stateID", stateID);
cmd.Parameters.Add("@startDate", SqlDbType.DateTime).Value = startDate;
cmd.Parameters.Add("@endDate", SqlDbType.DateTime).Value = endDate;
cmd.Parameters.AddWithValue("@MyTasks", chkToggleButton.Checked);
da.SelectCommand = cmd;
da.Fill(dt);
TasksListView.DataSourceID = string.Empty;
TasksListView.DataSource = dt;
TasksListView.DataBind();
}
catch (Exception exp)
{
ErrorLabel.Text = "Error a ejecutar busqueda.. : " + exp.Message;
ErrorLabel.Visible = true;
}
}
