protected void btnClearMaintenance_Click(object sender, EventArgs e)
{
DataTable ds = new DataTable();
ds = null;
GridViewMaintenanceSearches.DataSource = ds;
GridViewMaintenanceSearches.DataBind();
//lblMessage.Text = string.Empty;
}
private void MaintenanceSearch()
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Expenses"].ConnectionString);
cn.Open();
SqlCommand cmdGetExpenses = new SqlCommand("spMaintenanceSearch", cn);
cmdGetExpenses.CommandType = CommandType.StoredProcedure;
DateTime startDate = Convert.ToDateTime(String.IsNullOrEmpty(tbStartDate.Text) ? null : tbStartDate.Text);
string start = String.Format("{0:MM/dd/yyyy}", startDate);
DateTime endDate = Convert.ToDateTime(String.IsNullOrEmpty(tbEndDate.Text) ? null : tbEndDate.Text);;
string end = String.Format("{0:MM/dd/yyyy}", endDate);
if (tbMaintenanceType.Text == "0")
{
MaintenanceTypeId = 0;
}
else
{
MaintenanceTypeId = Convert.ToInt16(ddlMaintenance.SelectedItem.Value);
}
cmdGetExpenses.Parameters.AddWithValue("MaintenanceTypeId", MaintenanceTypeId);
cmdGetExpenses.Parameters.AddWithValue("StartDate", String.IsNullOrEmpty(tbStartDateMaintenance.Text) ? (object)DBNull.Value : start);
cmdGetExpenses.Parameters.AddWithValue("EndDate", String.IsNullOrEmpty(tbEndDateMaintenance.Text) ? (object)DBNull.Value : end);
GridViewMaintenanceSearches.Visible = true;
SqlDataReader rdrS = cmdGetExpenses.ExecuteReader();
GridViewMaintenanceSearches.DataSource = rdrS;
GridViewMaintenanceSearches.DataBind();
cn.Close();
}
