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); }
protected void btnSave_Click1(object sender, EventArgs e) { VoyageId = GeneralFunctions.DecryptQueryString(Request.QueryString["id"]); bool isedit = VoyageId != "-1" ? true : false; Entity.VoyageEntity voyage = AssignVoyageProp(VoyageId); if (ddlLoc.SelectedIndex == 0) { GeneralFunctions.RegisterAlertScript(this, "Please select any location"); return; } if (voyage.fk_LPortID == 0) { GeneralFunctions.RegisterAlertScript(this, "Please provide Last_Port_Called"); return; } if (voyage.fk_Pod == 0) { GeneralFunctions.RegisterAlertScript(this, "Please provide PoD"); return; } //if (isedit && OldLandingDate!=txtdtLand.Text && OldLandingDate != System.Convert.DBNull) //{ // //GeneralFunctions.RegisterAlertScript(this, "All Container transaction will be deleted"); // // "javascript:return confirm('All Containers of the voyage will be deleted. Confirm with Yes');"; // //if (retval!="yes") return; //} if (txtdtLand.Text != "") { string msg = EMS.BLL.VoyageBLL.CheckVoyageEntryAbilty(voyage.fk_VesselID, txtVoyageNo.Text.Trim(), voyage.fk_Pod, voyage.LandingDate, voyage.ImpXChangeRate, isedit); //int c = dbinteract.PopulateDDLDS("trnVoyage", "fk_VesselID", "VoyageNo", "where fk_VesselID=" + ddlVessel.SelectedValue + " and VoyageNo='" + txtVoyageNo.Text.Trim() + "'").Tables[0].Rows.Count; if (msg != "" && msg.ToLower() != "true") { GeneralFunctions.RegisterAlertScript(this, msg); return; } } int result = dbinteract.AddEditVoyage(_userId, isedit, voyage); int result1 = EMS.BLL.VoyageBLL.VoyageLandingDateEntry(voyage.fk_VesselID, Convert.ToInt32(VoyageId), voyage.fk_Pod, voyage.LandingDate, voyage.OLandingDate, _userId); if (result > 0) { //if (!isedit) Response.Redirect("~/MasterModule/MangeVoyage.aspx?p=" + Request.QueryString["p"]); //else if (result1 > 0) // Response.Redirect("~/MasterModule/MangeVoyage.aspx"); //else //{ // GeneralFunctions.RegisterAlertScript(this, "Error Occured"); //} } else { GeneralFunctions.RegisterAlertScript(this, "Error Occured"); } }