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(); }