private Entity.VoyageEntity AssignVoyageProp(string voyageID) { Entity.VoyageEntity voyage = new Entity.VoyageEntity(); voyage.pk_VoyageID = Convert.ToInt32(voyageID); voyage.AltLGNo = txtAltLGNo.Text.ToUpper(); voyage.CargoDesc = txtCargoDesc.Text.ToUpper(); voyage.ImpXChangeRate = txtExcRate.Text.Trim() == "" ? 0 : Convert.ToDecimal(txtExcRate.Text.Trim()); voyage.IGMNo = txtIGMNo.Text.ToUpper(); //voyage.CallSign = txtCallSign.Text.ToUpper(); voyage.LGNo = txtLGNo.Text.ToUpper(); voyage.LightHouseDue = txtLightHouse.Text.Trim() == "" ? 0 : Convert.ToInt32(txtLightHouse.Text.Trim()); voyage.MotherDaughterDtl = txtMotherDaughter.Text.ToUpper(); voyage.PCCNo = txtPCCNo.Text.ToUpper(); voyage.ETATime = txtTime.Text.ToUpper(); voyage.TotalLines = txtTotLine.Text.ToUpper(); voyage.VCN = txtVCN.Text.ToUpper(); voyage.fk_VesselID = Convert.ToInt32(ddlVessel.SelectedValue); voyage.VIANo = txtVIA.Text.ToUpper(); voyage.VoyageNo = txtVoyageNo.Text.ToUpper(); voyage.CrewEffectList = ddlCrewEffList.SelectedValue; voyage.CrewList = ddlCrewList.SelectedValue; voyage.MaritimeList = ddlMaritime.SelectedValue; voyage.PassengerList = ddlPessengerList.SelectedValue; voyage.SameButtonCargo = ddlSameButton.SelectedValue; voyage.ShipStoreSubmitted = ddlShipStoreSubmitted.SelectedValue; voyage.fl_TerminalID = Convert.ToInt32(ddlTerminalID.SelectedValue); voyage.VesselType = ddlVesselType.SelectedValue; voyage.AddLandingDate = string.IsNullOrEmpty(txtdtAddLand.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtdtAddLand.Text); voyage.ETADate = string.IsNullOrEmpty(txtdtETA.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtdtETA.Text); voyage.IGMDate = string.IsNullOrEmpty(txtDtIGM.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtDtIGM.Text); //voyage.OLandingDate = Convert.ToDateTime(hdnOldLandingDT.Value); voyage.OLandingDate = string.IsNullOrEmpty(hdnOldLandingDT.Value.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(hdnOldLandingDT.Value); voyage.LandingDate = string.IsNullOrEmpty(txtdtLand.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtdtLand.Text); voyage.PCCDate = string.IsNullOrEmpty(txtdtPCC.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtdtPCC.Text); voyage.locid = Convert.ToInt32(ddlLoc.SelectedValue); string port = ((TextBox)AutoCompletepPort1.FindControl("txtPort")).Text; port = port.Contains(',') && port.Split(',').Length >= 1 ? port.Split(',')[1].Trim() : ""; voyage.fk_LPortID = dbinteract.GetId("Port", port); if (port != "HALDIA,INHAL1") { voyage.AddLandingDate = null; } port = ((TextBox)AutoCompletepPort2.FindControl("txtPort")).Text; port = port.Contains(',') && port.Split(',').Length >= 1 ? port.Split(',')[1].Trim() : ""; voyage.fk_LPortID1 = dbinteract.GetId("Port", port); port = ((TextBox)AutoCompletepPort3.FindControl("txtPort")).Text; port = port.Contains(',') && port.Split(',').Length >= 1 ? port.Split(',')[1].Trim() : ""; voyage.fk_LPortID2 = dbinteract.GetId("Port", port); port = ((TextBox)AutoCompletepPort4.FindControl("txtPort")).Text; port = port.Contains(',') && port.Split(',').Length >= 1 ? port.Split(',')[1].Trim() : ""; voyage.fk_Pod = dbinteract.GetId("Port", port); return(voyage); }
private void LoadData(string VoyageId) { int intVoyageId = 0; if (VoyageId == "" || !Int32.TryParse(VoyageId, out intVoyageId)) { return; } BLL.DBInteraction dbinteract = new BLL.DBInteraction(); System.Data.DataSet ds = dbinteract.GetVoyage(Convert.ToInt32(VoyageId), "a", "", "", "", 0); if (!ReferenceEquals(ds, null) && ds.Tables[0].Rows.Count > 0) { ddlLoc.SelectedValue = ds.Tables[0].Rows[0]["pk_LocID"].ToString(); GeneralFunctions.PopulateDropDownList(ddlTerminalID, dbinteract.PopulateDDLDS("mstTerminal", "pk_TerminalID", "TerminalName] + '-' + [terminal", "Where fk_LocationID=" + ddlLoc.SelectedValue)); ddlTerminalID.SelectedValue = ds.Tables[0].Rows[0]["fl_TerminalID"].ToString(); txtAltLGNo.Text = ds.Tables[0].Rows[0]["AltLGNo"].ToString(); txtCargoDesc.Text = ds.Tables[0].Rows[0]["CargoDesc"].ToString(); txtExcRate.Text = ds.Tables[0].Rows[0]["ImpXChangeRate"].ToString(); txtIGMNo.Text = ds.Tables[0].Rows[0]["IGMNo"].ToString(); //txtCallSign.Text = ds.Tables[0].Rows[0]["CallSign"].ToString(); txtLGNo.Text = ds.Tables[0].Rows[0]["LGNo"].ToString(); txtLightHouse.Text = ds.Tables[0].Rows[0]["LightHouseDue"].ToString(); txtMotherDaughter.Text = ds.Tables[0].Rows[0]["MotherDaughterDtl"].ToString(); txtPCCNo.Text = ds.Tables[0].Rows[0]["PCCNo"].ToString(); txtTime.Text = ds.Tables[0].Rows[0]["ETATime"].ToString(); txtTotLine.Text = ds.Tables[0].Rows[0]["TotalLines"].ToString(); txtVCN.Text = ds.Tables[0].Rows[0]["VCN"].ToString(); ddlVessel.SelectedValue = ds.Tables[0].Rows[0]["fk_VesselID"].ToString(); txtVIA.Text = ds.Tables[0].Rows[0]["VIANo"].ToString(); txtVoyageNo.Text = ds.Tables[0].Rows[0]["VoyageNo"].ToString(); ddlCrewEffList.SelectedValue = ds.Tables[0].Rows[0]["CrewEffectList"].ToString(); ddlCrewList.SelectedValue = ds.Tables[0].Rows[0]["CrewList"].ToString(); ddlMaritime.SelectedValue = ds.Tables[0].Rows[0]["MaritimeList"].ToString(); ddlPessengerList.SelectedValue = ds.Tables[0].Rows[0]["PassengerList"].ToString(); ddlSameButton.SelectedValue = ds.Tables[0].Rows[0]["SameButtonCargo"].ToString(); ddlShipStoreSubmitted.SelectedValue = ds.Tables[0].Rows[0]["ShipStoreSubmitted"].ToString(); ddlTerminalID.SelectedValue = ds.Tables[0].Rows[0]["fl_TerminalID"].ToString(); txtdtETA.Text = ds.Tables[0].Rows[0]["ETADate"].ToString().Split(' ')[0]; txtdtLand.Text = ds.Tables[0].Rows[0]["AddLandingDate"].ToString().Split(' ')[0]; txtDtIGM.Text = ds.Tables[0].Rows[0]["IGMDate"].ToString().Split(' ')[0]; txtdtLand.Text = ds.Tables[0].Rows[0]["LandingDate"].ToString().Split(' ')[0]; hdnLandingDT.Value = ds.Tables[0].Rows[0]["LandingDate"].ToString().Split(' ')[0]; //Rajen hdnOldLandingDT.Value = ds.Tables[0].Rows[0]["LandingDate"].ToString().Split(' ')[0]; txtdtPCC.Text = ds.Tables[0].Rows[0]["PCCDate"].ToString().Split(' ')[0]; //txtdtAddLand.Text = ds.Tables[0].Rows[0]["__"].ToString(); ((TextBox)AutoCompletepPort1.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["lastport"].ToString(); ((TextBox)AutoCompletepPort2.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["lastport1"].ToString(); ((TextBox)AutoCompletepPort3.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["lastport2"].ToString(); ((TextBox)AutoCompletepPort4.FindControl("txtPort")).Text = ds.Tables[0].Rows[0]["portDischarge"].ToString(); } }