/// <summary>
/// Bind all records of vetting
/// </summary>
public void Bind_VettingIndex()
{
try
{
BLL_VET_Index objBLLIndx = new BLL_VET_Index();
DataSet ds = new DataSet();
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
int IsValid = 0;
DataTable dtEXInspector = new DataTable();
dtEXInspector.Columns.Add("ID");
DataTable dtInspector = new DataTable();
dtInspector.Columns.Add("ID");
foreach (DataRow dr in DDLInspector.SelectedValues.Rows)
{
if (dr[0].ToString().Split('_')[1] == "In")
{
dtInspector.Rows.Add(dr[0].ToString().Split('_')[0]);
}
if (dr[0].ToString().Split('_')[1] == "Ex")
{
dtEXInspector.Rows.Add(dr[0].ToString().Split('_')[0]);
}
}
DateTime?VetFromDate, VetToDate;
VetFromDate = txtLVetFromDate.Text.Trim() == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtLVetFromDate.Text));
VetToDate = txtLVetToDate.Text.Trim() == "" ? null : UDFLib.ConvertDateToNull(UDFLib.ConvertToDate(txtLVetToDate.Text));
if (rbtnValid.Checked == true)
{
IsValid = 1;
}
ds = objBLLIndx.VET_Get_VettingIndex(DDLVessel.SelectedValues, DDLVetType.SelectedValues, DDLStatus.SelectedValues, txtDueDays.Text == "0" ? UDFLib.ConvertToInteger(txtDueDays.Text.Trim()) : UDFLib.ConvertIntegerToNull(txtDueDays.Text.Trim()), IsValid, UDFLib.ConvertToInteger(rbtnObservation.SelectedValue), DDLOilMajor.SelectedValues, dtInspector, dtEXInspector, VetFromDate, VetToDate, DDLJobStatus.SelectedValues, txtVessel.Text != "" ? txtVessel.Text.Trim() : null, sortbycoloumn, sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ds.Tables.Count > 0)
{
ViewState["dtObservationCount"] = ds.Tables[1];
ViewState["dtNotesCount"] = ds.Tables[2];
ViewState["dtResponse"] = ds.Tables[3];
ViewState["dtJobsCount"] = ds.Tables[4];
}
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
gvVettingIndex.DataSource = ds.Tables[0];
gvVettingIndex.DataBind();
if (ds.Tables[0].Rows.Count > 0)
{
btnExport.Enabled = true;
}
else
{
btnExport.Enabled = false;
}
UpdPnlGrid.Update();
UpdPnlFilter.Update();
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
string js = "alert('" + UDFLib.GetException("SystemError/ GeneralMessage") + "');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
}
}
