protected void lnkbtnSearch_Click(object sender, EventArgs e)
{
grdSearchRecords.Visible = true;
objClaimFrmDAL = new ClaimToDAL();
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
DateTime? DateFrom = null; DateTime?DateTo = null;
DateFrom = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateFrom.Text));
DateTo = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDivDateTo.Text));
Int64 Location = string.IsNullOrEmpty(Convert.ToString(ddlFromCity.SelectedValue)) ? 0 : Convert.ToInt64(ddlFromCity.SelectedValue);
Int64 PartyIdno = string.IsNullOrEmpty(Convert.ToString(ddlDivPrtyName.SelectedValue)) ? 0 : Convert.ToInt64(ddlDivPrtyName.SelectedValue);
string ClaimNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim())) + "" + (string.IsNullOrEmpty(Convert.ToString(txtPrefixNo.Text.Trim())) ? "" : Convert.ToString(txtPrefixNo.Text.Trim()));
Int64 Value = 1;
if (rdoAgnReceived.Checked)
{
Value = 2;
}
else
{
Value = 1;
}
if (Value == 2)
{
var lst = objClaimFrmDAL.SelectForSearchRecvd(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid);
objClaimFrmDAL = null;
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string BillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"));
string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"));
string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "CBillDate")).ToString("dd-MM-yyyy"));
string SbillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "N/A" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
hidid.Value = SbillIdNo;
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId, SbillNo);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ddlCompanyName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "CompIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "CompIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
else
{
var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, ClaimNo, PartyIdno, Location, intyearid);
objClaimFrmDAL = null;
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
string SerialIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialIdno"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialIdno")));
string SerialNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SerialNo"))) ? "" : Convert.ToString((DataBinder.Eval(lst[i], "SerialNo")));
string PrefNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PrefNo"));
string ClaimNumber = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimNo"));
string ClaimHeadIdno = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "ClaimHeadIdno"));
string CBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "CBillDate")).ToString("dd-MM-yyyy"));
string SbillNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"))) ? "N/A" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string CityName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "CityName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "CityName"));
string PartyName = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyName"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "PartyName"));
string PartyId = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"))) ? "0" : Convert.ToString(DataBinder.Eval(lst[i], "PartyIdno"));
ApplicationFunction.DatatableAddRow(dt, i + 1, SerialIdno, SerialNo, ClaimHeadIdno, PrefNo + "" + ClaimNumber, ApplicationFunction.mmddyyyy(CBillDate), CityName, PartyName, PartyId, SbillNo);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ddlCompanyName.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "CompIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "CompIdno")));
HidClaimHeadIdno.Value = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "ClaimHeadIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "ClaimHeadIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
