public static DataSet GetTranshipmentList(SearchCriteria searchCriteria)
{
string ProcName = "[exp].[prcTranshipmentList]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
//if(searchCriteria.tra != 0)
// dquery.AddIntegerParam("@pk_TranShipID", TranshipmentId);
if (!string.IsNullOrEmpty(searchCriteria.ContainerNo))
{
dquery.AddVarcharParam("@SchContainerNo", 11, searchCriteria.ContainerNo);
}
if (!string.IsNullOrEmpty(searchCriteria.BookingNo))
{
dquery.AddVarcharParam("@SchBookingNo", 10, searchCriteria.BookingNo);
}
if (!string.IsNullOrEmpty(searchCriteria.BLNo))
{
dquery.AddVarcharParam("@SchEDGEBLNo", 30, searchCriteria.BLNo);
}
if (!string.IsNullOrEmpty(searchCriteria.StringOption1))
{
dquery.AddVarcharParam("@SchRefBookingNo", 30, searchCriteria.StringOption1);
}
dquery.AddVarcharParam("@SortExpression", 30, searchCriteria.SortExpression);
dquery.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection);
return(dquery.GetTables());
}
public DataSet PopulateDDLDS(string tableName, string textField, string valuefield)
{
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("Select [" + textField + "] ListItemValue, [" + valuefield + "] ListItemText from dbo." + tableName+" order by ListItemText", true);
return dquery.GetTables();
}
public DataSet PopulateDDLDS(string tableName, string textField, string valuefield, string WhereClause, bool isDSR)
{
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("Select [" + textField + "] ListItemValue, [" + valuefield + "] ListItemText from " + tableName + " " + WhereClause + ") order by ListItemText", true);
return dquery.GetTables();
}
public static DataSet GetCompanyDetails(Int32 companyId)
{
string ProcName = "[dbo].[PrcRptCompanyDetails]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@CompanyId", companyId);
return(dquery.GetTables());
}
public static DataSet GetBooking(string Initial)
{
string ProcName = "[exp].[prcGetBooking]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddVarcharParam("@initial", 250, Initial);
return(dquery.GetTables());
}
public DataSet GetServiceForLine(int pk_NVOCCID)
{
string ProcName = "[exp].[prcGetServicesListForLine]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@LineID", pk_NVOCCID);
return dquery.GetTables();
}
public static DataSet GetCustomHouse()
{
string ProcName = "prcGetCustomHouse";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
return(dquery.GetTables());
}
public DataSet GetActiveOperator()
{
string ProcName = "[exp].[prcGetSlotOperatorList]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddVarcharParam("@SortExpression", 30, "");
dquery.AddVarcharParam("@SortDirection", 4, "");
return dquery.GetTables();
}
public DataSet GetFwdCurrency()
{
string ProcName = "fwd.prcGetCurrency";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
//dquery.AddIntegerParam("@pk_NVOCCID", pk_FlineID);
//dquery.AddVarcharParam("@NVOCCName", 6, LineName);
return dquery.GetTables();
}
public DataSet GetNVOCCLine(int pk_NVOCCID, string NVOCCName)
{
string ProcName = "admin.prcGetNVOCCLine";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_NVOCCID", pk_NVOCCID);
dquery.AddVarcharParam("@NVOCCName", 6, NVOCCName);
return dquery.GetTables();
}
public static DataSet GetBookingTranshipment(int BookingId)
{
string ProcName = "[exp].[prcGetBookingTranshipmentByBookingId]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@BookingId", BookingId);
return(dquery.GetTables());
}
public DataSet GetMovType()
{
string ProcName = "exp.prcGetMovementType";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
//dquery.AddIntegerParam("@pk_NVOCCID", pk_NVOCCID);
//dquery.AddVarcharParam("@NVOCCName", 6, NVOCCName);
return dquery.GetTables();
}
public DataSet GetSTaxDate(DateTime? Startdt)
{
string ProcName = "admin.prcGetSTaxDate";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddDateTimeParam("@StartDate", Startdt);
return dquery.GetTables();
}
public static DataSet GetLoadingPort(Int64 VoyageId)
{
string ProcName = "[exp].[uspGetLoadingPort]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddBigIntegerParam("@VoyageID", VoyageId);
return(dquery.GetTables());
}
public static DataSet GetSalesman(int SalesmanID)
{
string ProcName = "[exp].[prcGetSalesman]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@fk_CustID", SalesmanID);
return(dquery.GetTables());
}
public static DataSet GetExportMLVoyages(int Vessel)
{
string ProcName = "[exp].[spGetMLVoyageByVesselID]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@Vessel", Vessel);
return(dquery.GetTables());
}
public DataSet GetImportEDIforCustom(int VoyageId, int VesselID)
{
string ProcName = "prcGetEDICustom";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_VoyageID", VoyageId);
dquery.AddIntegerParam("@pk_VesselID", VesselID);
return dquery.GetTables();
}
public DataSet GetSTax(int pk_StaxID, DateTime? StartDate)
{
string ProcName = "admin.prcGetSTax";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_StaxID", pk_StaxID);
dquery.AddDateTimeParam("@StartDate", StartDate);
return dquery.GetTables();
}
public static DataSet GetEDIContainerInfo(int VesselID, int VoyageId)
{
string ProcName = "prcGetContainEDI";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@VoyageID", VoyageId);
dquery.AddIntegerParam("@VesselID", VesselID);
return(dquery.GetTables());
}
public static DataSet GetExportServices(int Line, Int32 fpod)
{
string ProcName = "[exp].[spGetServiceByLineFPOD]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@Line", Line);
dquery.AddBigIntegerParam("@FPOD", fpod);
return(dquery.GetTables());
}
public static DataSet GetExportVoyagesWithPOL(int Vessel, int POLID)
{
string ProcName = "[exp].[spGetVoyageByVesselnPOL]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@Vessel", Vessel);
dquery.AddIntegerParam("@POL", POLID);
return(dquery.GetTables());
}
public static DataSet GetTranshipmentHeader(int ExpBLId, int CountID)
{
string ProcName = "[exp].[prcGetTranshipmentDetailsByBLNo]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@ExpBLId", ExpBLId);
dquery.AddIntegerParam("@CountID", CountID);
return(dquery.GetTables());
}
public DataSet GetCountry(params object[] sqlParam)
{
string ProcName = "admin.prcGetCountry";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_countryId", Convert.ToInt32(sqlParam[0]));
dquery.AddVarcharParam("@CountryName", 200, Convert.ToString(sqlParam[1]));
dquery.AddVarcharParam("@CountryAbbr", 2, Convert.ToString(sqlParam[2]));
return dquery.GetTables();
}
public static DataSet GetPOD(Int32 VesselID, Int32 VoyageID, Int32 LineID)
{
string ProcName = "[exp].[PODWithVesselVoyage]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@VesselId", VesselID);
dquery.AddIntegerParam("@VoyageId", VoyageID);
dquery.AddIntegerParam("@LineId", LineID);
return(dquery.GetTables());
}
public static DataSet GetContainerTranshipment(int PortId, int ExpBLId, int BookingId)
{
string ProcName = "[exp].[prcGetcontainerTranshipment]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@PortId", PortId);
dquery.AddIntegerParam("@ExpBLId", ExpBLId);
dquery.AddIntegerParam("@BookingId", BookingId);
return(dquery.GetTables());
}
public DataSet GetMLVoyage(int VoyageId, string voyageType, string VesselName, string voyageNo)
{
string ProcName = "prcGetMLVoyage";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_VoyageID", VoyageId);
dquery.AddCharParam("@VoyageType", 1, voyageType.ToCharArray()[0]);
dquery.AddVarcharParam("@vesselName", 70, VesselName);
dquery.AddVarcharParam("@VoyageNo", 10, voyageNo);
return dquery.GetTables();
}
public DataSet GetFreeDays(int FreeID, string Location, string Line, SearchCriteria searchCriteria)
{
string ProcName = "[admin].[prcGetFreeDaysList]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_LinkId", FreeID);
dquery.AddVarcharParam("@SchLocationName", 70, Location);
dquery.AddVarcharParam("@SchLineName", 70, Line);
dquery.AddVarcharParam("@SortExpression", 20, searchCriteria.SortExpression);
dquery.AddVarcharParam("@SortDirection", 4, searchCriteria.SortDirection);
return dquery.GetTables();
}
public static DataSet GetEDICargoInfo(int VesselID, int VoyageId, int pod)
{
string ProcName = "GetEDICargoInfo";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@VoyageID", VoyageId);
dquery.AddIntegerParam("@VesselID", VesselID);
dquery.AddIntegerParam("@pod", pod);
return(dquery.GetTables());
}
public DataSet GetPort(int pk_PortId, string PortCode, string PortName)
{
string ProcName = "admin.prcGetPort";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_PortId", pk_PortId);
dquery.AddVarcharParam("@PortCode", 6, PortCode);
dquery.AddVarcharParam("@PortName", 30, PortName);
return dquery.GetTables();
}
public DataSet GetVessel(int vesselId, int vesselPrefix, string vesselName, int vesselFlag)
{
string ProcName = "prcGetVessel";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_vesselId", vesselId);
dquery.AddIntegerParam("@fk_VesselPrefixID", vesselPrefix);
dquery.AddVarcharParam("@vesselName", 70, vesselName);
dquery.AddIntegerParam("@vesselFlag", vesselFlag);
return dquery.GetTables();
}