public void FillGridViewAfterSearch(int VesselID)
{
DataTable dtFilters = new DataTable();
dtFilters.Columns.Add("VesselManager", typeof(int));
dtFilters.Columns.Add("Fleet", typeof(int));
dtFilters.Columns.Add("Vessel", typeof(int));
dtFilters.Columns.Add("RankID", typeof(int));
dtFilters.Columns.Add("Nationality", typeof(int));
dtFilters.Columns.Add("Status", typeof(int));
dtFilters.Columns.Add("CalculatedStatus", typeof(int));
dtFilters.Columns.Add("ManningOfficeID", typeof(int));
dtFilters.Columns.Add("EOCDueIn", typeof(int));
dtFilters.Columns.Add("JoiningDateFrom", typeof(String));
dtFilters.Columns.Add("JoiningDateTo", typeof(String));
dtFilters.Columns.Add("SearchText", typeof(String));
DateTime dtFrom = DateTime.Parse(UDFLib.ConvertUserDateFormat(Convert.ToString("1900/01/01")));
DateTime dtTo = DateTime.Parse(UDFLib.ConvertUserDateFormat(Convert.ToString("2900/01/01")));
int MainStatusId = 0;
DataTable dtMainStatus = objCrewAdmin.Get_CrewMainStatus();
dtMainStatus.DefaultView.RowFilter = "Value='Onboard'";
if (dtMainStatus.DefaultView.Count > 0)
{
MainStatusId = int.Parse(dtMainStatus.DefaultView[0]["Id"].ToString());
}
dtFilters.Rows.Add(0, 0, VesselID, 0, 0, MainStatusId, 0, 0, 0, dtFrom.ToString(UDFLib.ConvertUserDateFormat(Convert.ToString("yyyy/MM/dd"))), dtTo.ToString(UDFLib.ConvertUserDateFormat(Convert.ToString("yyyy/MM/dd"))), "");
int PAGE_SIZE = 100;
int PAGE_INDEX = 1;
int SelectRecordCount = 0;
DataTable dt = BLL_Crew_CrewList.Get_Crewlist_Index(dtFilters, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount);
GridView1.DataSource = dt;
GridView1.DataBind();
ltCrewCount.Text = "Total number of crew on board : " + dt.Rows.Count.ToString();
DataSet ds = BLL_Crew_CrewList.Get_Crewlist_IconView(VesselID, GetSessionUserID());
ds.Relations.Add(new DataRelation("NestedCat", ds.Tables[0].Columns["rank_category"], ds.Tables[1].Columns["rank_category"]));
ds.Tables[1].TableName = "Members";
rpt1.DataSource = ds;
rpt1.DataBind();
}
public void FillGridViewAfterSearch()
{
DataTable dtFilters = GetSearchDataTable();
int PAGE_SIZE = ucCustomPager_CrewList.PageSize;
int PAGE_INDEX = ucCustomPager_CrewList.CurrentPageIndex;
int SelectRecordCount = ucCustomPager_CrewList.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
//Passing selected Vessel type for filter
int i = 1;
DataTable dtVesselTypes = new DataTable();
dtVesselTypes.Columns.Add("PID");
dtVesselTypes.Columns.Add("VALUE");
foreach (DataRow dr in ddlVesselType.SelectedValues.Rows)
{
DataRow dr1 = dtVesselTypes.NewRow();
dr1["PID"] = i;
dr1["VALUE"] = dr[0];
dtVesselTypes.Rows.Add(dr1);
i++;
}
DataTable dt = BLL_Crew_CrewList.Get_Crewlist_Index(dtFilters, dtVesselTypes, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount, sortbycoloumn, sortdirection);
GridView1.DataSource = dt;
GridView1.DataBind();
if (ucCustomPager_CrewList.isCountRecord == 1)
{
ucCustomPager_CrewList.CountTotalRec = SelectRecordCount.ToString();
ucCustomPager_CrewList.BuildPager();
}
string js = "Timer();";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Timer", js, true);
}
public void FillGridViewAfterSearch(int VesselID)
{
DataTable dtFilters = new DataTable();
dtFilters.Columns.Add("VesselManager", typeof(int));
dtFilters.Columns.Add("Fleet", typeof(int));
dtFilters.Columns.Add("Vessel", typeof(int));
dtFilters.Columns.Add("RankID", typeof(int));
dtFilters.Columns.Add("Nationality", typeof(int));
dtFilters.Columns.Add("Status", typeof(int));
dtFilters.Columns.Add("CalculatedStatus", typeof(int));
dtFilters.Columns.Add("ManningOfficeID", typeof(int));
dtFilters.Columns.Add("EOCDueIn", typeof(int));
dtFilters.Columns.Add("JoiningDateFrom", typeof(String));
dtFilters.Columns.Add("JoiningDateTo", typeof(String));
dtFilters.Columns.Add("SearchText", typeof(String));
DateTime dtFrom = DateTime.Parse("1900/01/01");
DateTime dtTo = DateTime.Parse("2900/01/01");
int MainStatusId = 0;
DataTable dtMainStatus = objCrewAdmin.Get_CrewMainStatus();
dtMainStatus.DefaultView.RowFilter = "Value='Onboard'";
if (dtMainStatus.DefaultView.Count > 0)
{
MainStatusId = int.Parse(dtMainStatus.DefaultView[0]["Id"].ToString());
}
dtFilters.Rows.Add(0, 0, VesselID, 0, 0, MainStatusId, 0, 0, 0, UDFLib.ConvertUserDateFormat(Convert.ToString(dtFrom.ToString())), UDFLib.ConvertUserDateFormat(Convert.ToString(dtTo.ToString())), "");
int PAGE_SIZE = 100;
int PAGE_INDEX = 1;
int SelectRecordCount = 0;
DataTable dt = BLL_Crew_CrewList.Get_Crewlist_Index(dtFilters, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
BLL_Crew_CrewDetails objCrew = new BLL_Crew_CrewDetails();
int Vessel_ID = 1;
if (Request.QueryString["vid"] != null)
{
Vessel_ID = UDFLib.ConvertToInteger(Request.QueryString["vid"].ToString());
}
int SelectRecordCount = 1;
DataTable dtFilters = new DataTable();
dtFilters.Columns.Add("VesselManager", typeof(int));
dtFilters.Columns.Add("Fleet", typeof(int));
dtFilters.Columns.Add("Vessel", typeof(int));
dtFilters.Columns.Add("RankID", typeof(int));
dtFilters.Columns.Add("Nationality", typeof(int));
dtFilters.Columns.Add("Status", typeof(String));
dtFilters.Columns.Add("ManningOfficeID", typeof(int));
dtFilters.Columns.Add("EOCDueIn", typeof(int));
dtFilters.Columns.Add("JoiningDateFrom", typeof(String));
dtFilters.Columns.Add("JoiningDateTo", typeof(String));
dtFilters.Columns.Add("SearchText", typeof(String));
DateTime dtFrom = DateTime.Parse("1900/01/01");
DateTime dtTo = DateTime.Parse("2900/01/01");
dtFilters.Rows.Add(1, 0, Vessel_ID, 0, 0, "CURRENT", 0, 0, dtFrom.ToString("yyyy/MM/dd"), dtTo.ToString("yyyy/MM/dd"), "");
DataTable dt = BLL_Crew_CrewList.Get_Crewlist_Index(dtFilters, GetSessionUserID(), 2000, 1, ref SelectRecordCount);
//RepeaterRSS.DataSource = dt;
//RepeaterRSS.DataBind();
GenerateRSS(dt);
}
public void FillGridViewAfterSearch()
{
int FleetID = 0;
int VesselID = 0;
int Nationality = 0;
int RankID = 0;
string SearchText = "";
int Status = 0;
int CalculatedStatus = 0;
int ManningOfficeID = 0;
int COCDueIn = 0;
string JoiningFrom = "";
string JoiningTo = "";
VesselID = UDFLib.ConvertToInteger(Request.QueryString["vid"]);
FleetID = UDFLib.ConvertToInteger(Request.QueryString["flt"]);
Nationality = UDFLib.ConvertToInteger(Request.QueryString["nat"]);
RankID = UDFLib.ConvertToInteger(Request.QueryString["rank"]);
SearchText = Request.QueryString["search"];
Status = UDFLib.ConvertToInteger(Request.QueryString["st"]);
CalculatedStatus = UDFLib.ConvertToInteger(Request.QueryString["cst"]);
ManningOfficeID = UDFLib.ConvertToInteger(Request.QueryString["mo"]);
COCDueIn = UDFLib.ConvertToInteger(Request.QueryString["coc"]);
JoiningFrom = Request.QueryString["jFrom"];
JoiningTo = Request.QueryString["jTo"];
int VesselOwnerID = 0;
DataTable dtFilters = new DataTable();
dtFilters.Columns.Add("VesselManager", typeof(int));
dtFilters.Columns.Add("Fleet", typeof(int));
dtFilters.Columns.Add("Vessel", typeof(int));
dtFilters.Columns.Add("RankID", typeof(int));
dtFilters.Columns.Add("Nationality", typeof(int));
dtFilters.Columns.Add("Status", typeof(int));
dtFilters.Columns.Add("CalculatedStatus", typeof(int));
dtFilters.Columns.Add("ManningOfficeID", typeof(int));
dtFilters.Columns.Add("EOCDueIn", typeof(int));
dtFilters.Columns.Add("JoiningDateFrom", typeof(String));
dtFilters.Columns.Add("JoiningDateTo", typeof(String));
dtFilters.Columns.Add("SearchText", typeof(String));
DateTime dtFrom = DateTime.Parse("1900/01/01");
DateTime dtTo = DateTime.Parse("2900/01/01");
dtFilters.Rows.Add(VesselOwnerID, FleetID, VesselID, RankID, Nationality, Status, CalculatedStatus, ManningOfficeID, COCDueIn, dtFrom.ToString("yyyy/MM/dd"), dtTo.ToString("yyyy/MM/dd"), SearchText);
int PAGE_SIZE = ucCustomPager_CrewList.PageSize;
int PAGE_INDEX = ucCustomPager_CrewList.CurrentPageIndex;
int SelectRecordCount = ucCustomPager_CrewList.isCountRecord;
DataTable dt = BLL_Crew_CrewList.Get_Crewlist_Index(dtFilters, GetSessionUserID(), PAGE_SIZE, PAGE_INDEX, ref SelectRecordCount);
if (ucCustomPager_CrewList.isCountRecord == 1)
{
ucCustomPager_CrewList.CountTotalRec = SelectRecordCount.ToString();
ucCustomPager_CrewList.BuildPager();
}
GridView_CrewList.DataSource = dt;
GridView_CrewList.DataBind();
}
