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; } }