public void GetInsuranceTitles()
    {
        objInsurance = new clsInsuranceDetails();
        DataSet dsInsurance = objInsurance.GetInsuranceTitles();

        if (dsInsurance.Tables[0].Rows.Count > 0)
        {
            ddlSchemeName.DataTextField  = "Title";
            ddlSchemeName.DataValueField = "InsuranceId";
            ddlSchemeName.DataSource     = dsInsurance.Tables[0];
            ddlSchemeName.DataBind();
            ddlSchemeName.Items.Insert(0, "Select Insurance Name");
        }
    }
    public void InsertInsuranceDetails()
    {
        objInsurance                = new clsInsuranceDetails();
        objInsurance.Title          = txtTitle.Text.Trim();
        objInsurance.Type           = txtType.Text.Trim();
        objInsurance.Objective      = txtObjective.Text;
        objInsurance.Eligibility    = txtEligibility.Text;
        objInsurance.ApplyProcedure = txtProcedure.Text;
        objInsurance.DateOfStart    = txtDate.Text;
        objInsurance.Others         = txtOthers.Text;
        objInsurance.Address        = txtAddress.Text;
        int i = objInsurance.InsertInsuranceDetails();

        if (i > 0)
        {
            Page.RegisterClientScriptBlock("admin", "<script>alert('Fertilizer Details Stored')</script>");
        }
        else
        {
            Page.RegisterClientScriptBlock("Admin", "<script>alert('Bad Server Request')</script>");
        }
    }
    public void GetInsuranceDetailsById()
    {
        objInsurance = new clsInsuranceDetails();
        objInsurance.InsruranceId = Convert.ToInt32(ddlSchemeName.SelectedItem.Value);
        DataSet dsInsurance = objInsurance.GetInsuraceDetailsById();

        if (dsInsurance.Tables[0].Rows.Count > 0)
        {
            Field2.Visible        = true;
            lblInsuranceName.Text = dsInsurance.Tables[0].Rows[0]["Title"].ToString();
            lblType.Text          = dsInsurance.Tables[0].Rows[0]["Type"].ToString();
            lblObjective.Text     = dsInsurance.Tables[0].Rows[0]["Objective"].ToString();
            lblEligibility.Text   = dsInsurance.Tables[0].Rows[0]["Eligibility"].ToString();
            lblApply.Text         = dsInsurance.Tables[0].Rows[0]["ApplyProcedure"].ToString();
            lblDateOfStart.Text   = dsInsurance.Tables[0].Rows[0]["DateOfStart"].ToString();
            lblOthers.Text        = dsInsurance.Tables[0].Rows[0]["Others"].ToString();
            lblAddress.Text       = dsInsurance.Tables[0].Rows[0]["AddressForContact"].ToString();
        }
        else
        {
            lblMsg.Text    = "No Data Found";
            Field2.Visible = false;
        }
    }