public static DataTable GetLoadPort(int VoyageID)
{
string strExecution = "[exp].[GetLoadingPortListByVoyage]";
DataTable dt = new DataTable();
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(strExecution);
dquery.AddIntegerParam("@VoyageId", VoyageID);
return(dquery.GetTable());
}
public static DataTable GetPortWithServices(int ServiceID, Int32 Lineid)
{
string ProcName = "[exp].[spGetPortWithServices]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@ServiceID", ServiceID);
dquery.AddIntegerParam("@LineID", Lineid);
return(dquery.GetTable());
//return dquery.GetTables();
}
public static DataTable GetItemNoForEDI(int VoyageID, int VesselID, int POD)
{
string ProcName = "[dbo].[prcGetItemNoFrEDI]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@VoyageID", VoyageID);
dquery.AddIntegerParam("@VesselID", VesselID);
dquery.AddIntegerParam("@POD", POD);
return(dquery.GetTable());
}