//public long CheckCloseVoyage(IexpVoyage voyage) //{ // long ErrVal = 0; // ErrVal = expVoyageDAL.CheckCloseVoyage(voyage); // return ErrVal; //} public long CloseVoyage(IexpVoyage voyage) { long ErrVal = 0; ErrVal = expVoyageDAL.CloseVoyage(voyage); return(ErrVal); }
public long SaveVoyage(IexpVoyage voyage, bool isedit) { long voyageid = 0; voyageid = expVoyageDAL.SaveVoyage(voyage, isedit); return(voyageid); }
//public static long CheckCloseVoyage(IexpVoyage voyage) //{ // string strExecution = "[exp].[prcCheckCloseVoyage]"; // long ErrVal = 0; // using (DbQuery oDq = new DbQuery(strExecution)) // { // oDq.AddBigIntegerParam("@userID", voyage.UserAdded); // oDq.AddBigIntegerParam("@pk_VoyageID", voyage.VoyageID); // oDq.AddBigIntegerParam("@fk_VesselID", voyage.VesselID); // oDq.AddIntegerParam("@fk_LocationID", voyage.LocationID); // oDq.AddBigIntegerParam("@fk_LoadPortID", voyage.POL); // oDq.AddIntegerParam("@Result", 0, QueryParameterDirection.Output); // oDq.RunActionQuery(); // ErrVal = Convert.ToInt32(oDq.GetParaValue("@RESULT")); // //voyageid = Convert.ToInt64(oDq.GetScalar()); // } // return ErrVal; //} public static long CloseVoyage(IexpVoyage voyage) { string strExecution = "[exp].[prcCloseVoyage]"; long ErrVal = 0; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddBigIntegerParam("@userID", voyage.UserAdded); oDq.AddBigIntegerParam("@pk_VoyageID", voyage.VoyageID); oDq.AddIntegerParam("@Result", 0, QueryParameterDirection.Output); oDq.RunActionQuery(); ErrVal = Convert.ToInt32(oDq.GetParaValue("@Result")); //voyageid = Convert.ToInt64(oDq.GetScalar()); } return(ErrVal); }
public static IexpVoyage GetVogageById(long voyageId) { string strExecution = "[exp].[usp_Voyage_GetVoyageById]"; IexpVoyage voyage = null; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddBigIntegerParam("@voyageID", voyageId); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { voyage = new expVoyageEntity(reader); } reader.Close(); } return(voyage); }
private void BuildInvoiceEntity(IexpVoyage voyage) { if (ViewState["VoyageID"] == null) { voyage.VoyageID = 0; } else { voyage.VoyageID = Convert.ToInt64(ViewState["VoyageID"]); } //voyage.GatewayPort =Convert.ToInt32(hdnGateWayPort.Value); voyage.VesselID = Convert.ToInt32(ddlVessel.SelectedValue); //voyage.POD = Convert.ToInt32(hdnPOD.Value); voyage.VoyageNo = Convert.ToString(txtVoyageNo.Text); voyage.AgentCode = Convert.ToString(txtAgentcode.Text); voyage.POL = Convert.ToInt32(hdnPOL.Value); voyage.LineCode = Convert.ToString(txtLinecode.Text); voyage.ETD = string.IsNullOrEmpty(txtETD.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtETD.Text); voyage.PCCNo = Convert.ToString(txtPCCNo.Text); voyage.TerminalID = Convert.ToInt32(ddlTerminalID.SelectedValue); voyage.LocationID = Convert.ToInt32(ddlLocation.SelectedValue); voyage.PCCDate = string.IsNullOrEmpty(txtPCCDate.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtPCCDate.Text); voyage.NextPortID = Convert.ToInt32(hdnNextPortCall.Value); voyage.ETA = string.IsNullOrEmpty(txtETA.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtETA.Text); voyage.VIA = Convert.ToString(txtVIA.Text); voyage.ETANextPort = string.IsNullOrEmpty(txtETANextPort.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtETANextPort.Text); voyage.VCNNo = Convert.ToString(txtVCNNo.Text); voyage.RotationNo = Convert.ToString(txtRotationNo.Text); voyage.SailDate = string.IsNullOrEmpty(txtSailingDateTime.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtSailingDateTime.Text); voyage.RotationDate = string.IsNullOrEmpty(txtRotationDate.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtRotationDate.Text); voyage.VesselCutOffDate = string.IsNullOrEmpty(txtVesselcutoffDate.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtVesselcutoffDate.Text); voyage.DocsCutOffDate = string.IsNullOrEmpty(txtlstsiDockscutoffDate.Text.Trim()) ? (Nullable <DateTime>)null : Convert.ToDateTime(txtlstsiDockscutoffDate.Text); voyage.dtAdded = DateTime.Now; voyage.dtEdited = DateTime.Now; voyage.UserEdited = _userId; voyage.UserAdded = _userId; }
public static long SaveVoyage(IexpVoyage voyage, bool isedit) { string strExecution = "[exp].[prcAddEditVoyage]"; long voyageid = 0; using (DbQuery oDq = new DbQuery(strExecution)) { oDq.AddBigIntegerParam("@userID", voyage.UserAdded); oDq.AddBooleanParam("@isedit", isedit); //false for insert and true for update oDq.AddBigIntegerParam("@pk_VoyageID", voyage.VoyageID); oDq.AddBigIntegerParam("@fk_VesselID", voyage.VesselID); oDq.AddIntegerParam("@fk_LocationID", voyage.LocationID); oDq.AddIntegerParam("@fk_TerminalID", voyage.TerminalID); oDq.AddVarcharParam("@VoyageNo", 10, voyage.VoyageNo); oDq.AddDateTimeParam("@SailingDate", voyage.SailDate); oDq.AddDateTimeParam("@PCCDate", voyage.PCCDate); oDq.AddVarcharParam("@PCCNo", 14, voyage.PCCNo); oDq.AddVarcharParam("@AgentCode", 50, voyage.AgentCode); oDq.AddVarcharParam("@LineCode", 50, voyage.LineCode); oDq.AddVarcharParam("@VCNNo", 14, voyage.VCNNo); oDq.AddVarcharParam("@VIA", 10, voyage.VIA); oDq.AddVarcharParam("@RotationNo", 50, voyage.RotationNo); oDq.AddDateTimeParam("@RotationDate", voyage.RotationDate); oDq.AddBigIntegerParam("@fk_LoadPortID", voyage.POL); oDq.AddBigIntegerParam("@fk_DestPortID", voyage.POD); oDq.AddBigIntegerParam("@fk_NextPortID", voyage.NextPortID); oDq.AddDateTimeParam("@ETD", voyage.ETD); oDq.AddDateTimeParam("@ETA", voyage.ETA); oDq.AddDateTimeParam("@ETANextPort", voyage.ETANextPort); oDq.AddDateTimeParam("@VslCutoff", voyage.VesselCutOffDate); oDq.AddDateTimeParam("@DocCutOff", voyage.DocsCutOffDate); voyageid = Convert.ToInt64(oDq.GetScalar()); } return(voyageid); }