/// <summary>
/// Description: Method to load data based on selected vessel and date range
/// </summary>
private void LoadData()
{
try
{
hdnVessel_IDs.Value = null;
string Qtr = "";
string sStartDate = txtStartDate.Text;
string sEndDate = txtEndDate.Text;
if (sStartDate != "" && sEndDate != "")
{
DateTime StartDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtStartDate.Text)); //ConvertToDefaultDt() method is used to change the user selected date format to the default format, the format in which date is saved in database.
DateTime EndDate = Convert.ToDateTime(UDFLib.ConvertToDefaultDt(txtEndDate.Text));
//hdnLastMonth.Value = lastMonth;
DataSet ds = objKPI.Get_Vetting_KPI_ByCompany(Qtr, 0, StartDate, EndDate);
DataTable dt = ds.Tables[0];
string[] Pkey_cols = new string[] { "KPI_ID" };
string[] Hide_cols = new string[] { "ID", "Qtr_Start", "Qtr_End", "Code" };
DataTable dt1 = objKPI.PivotTable("Qtr", "KPI_Value", "", Pkey_cols, Hide_cols, dt);
gvCompanyKPI.DataSource = dt1;
gvCompanyKPI.DataBind();
IntializeControls();
string jsMethodName = null;
jsMethodName = "$(document).ready(function () {searchInitialize();});";
ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "uniqueKey", jsMethodName, true);
}
}
catch (Exception ex)
{
UDFLib.WriteExceptionLog(ex);
}
}
