protected void btnSearch_Click(object sender, EventArgs e) { dt = new DataTable(); cc = new ClaimClass(); cc.getClaimRecordsByCriteria(dt, "", txtIntimationNo.Text, ddlBranch.SelectedItem.Text, ddlClient.SelectedItem.Text, ddlInsuranceType.SelectedItem.Text, ddlgihyear.SelectedItem.Text); GridView1.DataSource = dt; GridView1.DataBind(); }
public void fillCalimStatusDropDown() { try { db = new dal(); dt = new DataTable(); cc = new ClaimClass(); ddlClaimStatus.DataValueField = "idx"; ddlClaimStatus.DataTextField = "ClaimStatus"; cc.getClaimStatus(dt); ddlClaimStatus.DataSource = dt; ddlClaimStatus.DataBind(); ddlClaimStatus.Items.Insert(0, new ListItem("Select Claim Status.")); } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }
protected void btnAdd_Click(object sender, EventArgs e) { try { cc = new ClaimClass(); dt = new DataTable(); cc.statusIdx = int.Parse(ddlClaimStatus.SelectedValue.ToString()); cc.userIdx = "Kashif"; cc.holdIdx = int.Parse(ddlClaimHold.SelectedValue.ToString()); cc.desc = txtdescription.Text; cc.Date = DateTime.Now.ToShortDateString(); cc.claimIdx = int.Parse(Session["claimIdx"].ToString()); cc.insertClaims(dt); lblMsg.Text = "Save Successfully"; txtdescription.Text = ""; ddlClaimHold.SelectedIndex = ddlClaimStatus.SelectedIndex = 0; } catch (Exception ex) { lblError.Text = ex.Message.ToString(); } }
public void fillgrid() { try { db = new dal(); dt = new DataTable(); cc = new ClaimClass(); cc.getClaimRecordDemo(dt); DataTable brdt = dt.DefaultView.ToTable(true, new String[] { "BR_CODE", "BR_DESC" }); ddlBranch.DataTextField = "BR_DESC"; ddlBranch.DataValueField = "BR_CODE"; DataRow row = brdt.NewRow(); row[0] = ""; row[1] = ""; brdt.Rows.InsertAt(row, 0); brdt.AcceptChanges(); ddlBranch.DataSource = brdt; ddlBranch.DataBind(); DataTable cldt = dt.DefaultView.ToTable(true, new String[] { "INSURED" }); row = cldt.NewRow(); row[0] = ""; cldt.Rows.InsertAt(row, 0); cldt.AcceptChanges(); ddlClient.DataTextField = "INSURED"; ddlClient.DataValueField = "INSURED"; ddlClient.DataSource = cldt; ddlClient.DataBind(); DataTable cltype = dt.DefaultView.ToTable(true, new String[] { "piydesc" }); row = cltype.NewRow(); row[0] = ""; cltype.Rows.InsertAt(row, 0); cltype.AcceptChanges(); ddlInsuranceType.DataTextField = "piydesc"; ddlInsuranceType.DataValueField = "piydesc"; ddlInsuranceType.DataSource = cltype; ddlInsuranceType.DataBind(); DataTable dtStaut = new DataTable(); dtStaut.Columns.Add("Status"); row = dtStaut.NewRow(); row[0] = "Intimated"; dtStaut.Rows.Add(row); row = dtStaut.NewRow(); row[0] = "Settlement"; dtStaut.Rows.Add(row); row = dtStaut.NewRow(); row[0] = "Settled"; dtStaut.Rows.Add(row); ddlStatus.DataTextField = "Status"; ddlStatus.DataValueField = "Status"; ddlStatus.DataSource = dtStaut; ddlStatus.DataBind(); DataTable dtYear = dt.DefaultView.ToTable(true, new String[] { "GIH_YEAR" }); row = dtYear.NewRow(); row[0] = ""; dtYear.Rows.InsertAt(row, 0); dtYear.AcceptChanges(); ddlgihyear.DataTextField = "GIH_YEAR"; ddlgihyear.DataValueField = "GIH_YEAR"; ddlgihyear.DataSource = dtYear; ddlgihyear.DataBind(); GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception ex) { lblMsg.Text = ex.Message.ToString(); } }