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