protected void btnClearInsurance_Click(object sender, EventArgs e)
{
DataTable ds = new DataTable();
ds = null;
GridViewInsuranceSearches.DataSource = ds;
GridViewInsuranceSearches.DataBind();
lblMessage.Text = string.Empty;
}
private void InsuranceSearch()
{
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Expenses"].ConnectionString);
cn.Open();
SqlCommand cmdGetExpenses = new SqlCommand("spInsuranceSearch", 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);
string insurance = tbInsuranceTypeDescription.Text;
switch (insurance)
{
case "Medical":
InsuranceTypeId = 1;
break;
case "Life":
InsuranceTypeId = 2;
break;
case "Car":
InsuranceTypeId = 3;
break;
case "House":
InsuranceTypeId = 4;
break;
case "Content":
InsuranceTypeId = 5;
break;
}
cmdGetExpenses.Parameters.AddWithValue("InsuranceTypeId", InsuranceTypeId);
cmdGetExpenses.Parameters.AddWithValue("StartDate", String.IsNullOrEmpty(tbStartDate.Text) ? (object)DBNull.Value : start);
cmdGetExpenses.Parameters.AddWithValue("EndDate", String.IsNullOrEmpty(tbEndDate.Text) ? (object)DBNull.Value : end);
GridViewInsuranceSearches.Visible = true;
SqlDataReader rdrS = cmdGetExpenses.ExecuteReader();
GridViewInsuranceSearches.DataSource = rdrS;
GridViewInsuranceSearches.DataBind();
cn.Close();
}
