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