protected void lnkbtnSearch_OnClick(object sender, EventArgs e)
{
ClaimFrmDAL objClaimFrmDAL = new ClaimFrmDAL();
if (RDbSaleBill.Checked == true)
{
if (txtSBillNo.Text == "" && ddlDivPrtyName.SelectedValue == "0")
{
DivErrorMsg.Visible = true; lblDivErrorMsg.InnerText = "* Please Select Sale Bill Number or Party."; ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true); return;
}
else
{
grdSearchRecords.Visible = true;
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 SbillNo = (string.IsNullOrEmpty(Convert.ToString(txtSBillNo.Text.Trim())) ? "" : Convert.ToString(txtSBillNo.Text.Trim()));
var lst = objClaimFrmDAL.SelectForSearch(DateFrom, DateTo, SbillNo, PartyIdno, Location, intyearid);
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], "SbillNo"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillNo"));
string SbillIdNo = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno"))) ? "" : Convert.ToString(DataBinder.Eval(lst[i], "SbillHeadIdno"));
string SBillDate = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[i], "SBillDate"))) ? "" : Convert.ToString(Convert.ToDateTime(DataBinder.Eval(lst[i], "SBillDate")).ToString("dd-MM-yyyy"));
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, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
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
{
grdSearchRecords.Visible = true;
DataTable dt = CreateDivDt();
Int32 intyearid = Convert.ToInt32(ddlDateRange.SelectedValue);
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);
var lst = objClaimFrmDAL.SearchByParty(PartyIdno, Location, intyearid);
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 BillNo = "0"; string SbillIdNo = "0"; string SBillDate = "";
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, SbillIdNo, PrefNo + "" + BillNo, ApplicationFunction.mmddyyyy(SBillDate), CityName, PartyName, PartyId);
}
ddlParty.SelectedValue = string.IsNullOrEmpty(Convert.ToString(DataBinder.Eval(lst[0], "PartyIdno"))) ? "0" : Convert.ToString((DataBinder.Eval(lst[0], "PartyIdno")));
ViewState["dtDivGrid"] = dt;
dt.Dispose();
this.BindDivGrid();
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
else
{
DivErrorMsg.Visible = false;
lblDivErrorMsg.InnerText = "";
}
objClaimFrmDAL = null;
ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop1", "openGridDetail();", true);
}
}
