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