Пример #1
0
        public static DateTime TranshipmentStatus(int ExpBLId, ref bool VoyageStatus, ref int CountID)
        {
            DateTime Result;
            string   TempString;
            bool     ClsVoyage = false;
            int      Count     = 0;
            string   ProcName  = "[exp].[prcTranshipmentStatus]";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);

            dquery.AddIntegerParam("@ExpBLId", ExpBLId);
            dquery.AddDateTimeParam("@RESULT", null, QueryParameterDirection.Output);
            dquery.AddBooleanParam("@closeVoyage", ClsVoyage, QueryParameterDirection.Output);
            dquery.AddIntegerParam("@CountID", Count, QueryParameterDirection.Output);

            dquery.RunActionQuery();
            TempString = Convert.ToString(dquery.GetParaValue("@Result"));
            if (TempString == null || TempString == "")
            {
                Result = default(DateTime);
            }
            else
            {
                Result = Convert.ToDateTime(dquery.GetParaValue("@Result"));
            }
            //Result = Convert.ToDateTime(dquery.GetParaValue("@SailDate"));
            VoyageStatus = Convert.ToBoolean(dquery.GetParaValue("@CloseVoyage"));
            CountID      = Convert.ToInt32(dquery.GetParaValue("@CountID"));
            return(Result);
        }
Пример #2
0
        public static int AddEditMLVoyage(string voyageId, string vesselId, string MLvoyageNo, int _userId, bool isEdit)
        {
            int intvesselId = 0;

            int.TryParse(vesselId, out intvesselId);

            int intVoyageId = 0;

            int.TryParse(voyageId, out intVoyageId);

            //dtActivity = dtActivity == "" ? DateTime.Now.ToShortDateString() : dtActivity;
            //DateTime dt = Convert.ToDateTime(dtActivity);
            string ProcName = "prcAddEditMLVoyage";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);

            dquery.AddIntegerParam("@UserId", _userId);
            dquery.AddIntegerParam("@VoyageId", intVoyageId);
            dquery.AddIntegerParam("@vesselId", intvesselId);
            dquery.AddVarcharParam("@MLvoyageNo", 15, MLvoyageNo);
            //dquery.AddDateTimeParam("@ActivityDate", dt);
            //dquery.AddIntegerParam("@fk_PortID", fk_PortID);
            dquery.AddBooleanParam("@isEdit", isEdit);

            return(dquery.RunActionQuery());
        }
Пример #3
0
        public int AddEditVessel(int userID, bool isEdit, EMS.Entity.Vessel vessel)
        {
            string ProcName = "prcAddEditVessel";
            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@userID", userID);
            dquery.AddBooleanParam("@isEdit", isEdit);

            dquery.AddIntegerParam("@pk_VesselId", vessel.VesselID);
            dquery.AddVarcharParam("@AgentCode", 10, vessel.AgentCode);
            // dquery.AddVarcharParam("@CallSign", 14, vessel.CallSign);
            dquery.AddVarcharParam("@IMONumber", 14, vessel.IMONumber);
            // dquery.AddIntegerParam("@LastPortCalled", vessel.LastPortCalled);
            dquery.AddVarcharParam("@MasterName", 60, vessel.MasterName);
            dquery.AddVarcharParam("@PANNo", 15, vessel.PANNo);
            dquery.AddVarcharParam("@ShippingLineCode", 10, vessel.ShippingLineCode);
            dquery.AddIntegerParam("@VesselFlag", vessel.VesselFlag);
            dquery.AddVarcharParam("@VesselName", 60, vessel.VesselName);
            dquery.AddIntegerParam("@VesselPrefix", vessel.VesselPrefix);
            dquery.AddVarcharParam("@CallSign", 14, vessel.CallSign);
            dquery.AddVarcharParam("@VesselAbbr", 2, vessel.VesselAbbr);


            return dquery.RunActionQuery();

        }
Пример #4
0
        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();
        }
Пример #5
0
        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());
        }
Пример #6
0
        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());
        }
Пример #7
0
        public static DataSet GetExportVoyages(int Vessel, int LocationID)
        {
            string ProcName = "[exp].[spGetVoyageByVesselID]";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);

            dquery.AddIntegerParam("@Vessel", Vessel);
            dquery.AddIntegerParam("@LocationID", LocationID);

            return(dquery.GetTables());
        }
Пример #8
0
        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());
        }
Пример #9
0
        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());
        }
Пример #10
0
        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());
        }
Пример #11
0
        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());
        }
Пример #12
0
        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();
        }
Пример #13
0
        public static DataSet GetTerminalOperator(int VoyageID, int VesselID, int POD)
        {
            string ProcName = "prcGetTerminalOperator";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);

            dquery.AddIntegerParam("@VoyageID", VoyageID);
            dquery.AddIntegerParam("@VesselID", VesselID);
            dquery.AddIntegerParam("@POD", POD);


            return(dquery.GetTables());
        }
Пример #14
0
        public int AddEditSlotOperator(int userID, int pk_SlotOperatorId, string SlotOperatorName, bool isEdit)
        {
            string ProcName = "exp.prcAddEditSlotOperator";
            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@userID", userID);
            dquery.AddIntegerParam("@pk_SlotOperatorId", pk_SlotOperatorId);
            dquery.AddVarcharParam("@SlotOperatorName", 50, SlotOperatorName);
            dquery.AddIntegerParam("@fk_CompanyID", 1);
            dquery.AddBooleanParam("@isEdit", isEdit);

            return dquery.RunActionQuery();

        }
Пример #15
0
        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();
        }
Пример #16
0
        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());
        }
Пример #17
0
        public DataSet GetVoyage(int VoyageId, string voyageType, string VesselName, string voyageNo, string igmNo, int UserLocation)
        {
            string ProcName = "prcGetVoyage";
            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);
            dquery.AddVarcharParam("@IGMNo", 10, igmNo);
            dquery.AddIntegerParam("@LocationID", UserLocation);

            return dquery.GetTables();
        }
Пример #18
0
        public int AddEditFreeDays(int userID, int pk_LinkID, int DefaultFreeDays, int Location, int NVOCC, bool isEdit)
        {
            string ProcName = "[admin].[prcAddEditFreeDays]";
            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@userID", userID);
            dquery.AddIntegerParam("@pk_LinkID", pk_LinkID);
            dquery.AddIntegerParam("@fk_LocationID", Location);
            dquery.AddIntegerParam("@fk_NVOCCID", NVOCC);
            dquery.AddIntegerParam("@DefaultFreeDays", DefaultFreeDays);
            dquery.AddBooleanParam("@isEdit", isEdit);

            return dquery.RunActionQuery();

        }
Пример #19
0
        public static int VoyageLandingDateEntry(int vesselId, int voyageId, int Pod, DateTime?LandingDate, DateTime?OldLandingDate, int UserId)
        {
            string ProcName = "prcVoyageLandingDateEntry";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);

            dquery.AddIntegerParam("@UserId", UserId);
            dquery.AddIntegerParam("@vesselId", vesselId);
            dquery.AddIntegerParam("@voyageId", voyageId);
            dquery.AddDateTimeParam("@LandingDate", LandingDate);
            dquery.AddDateTimeParam("@OldLandingDate", OldLandingDate);
            dquery.AddIntegerParam("@Pod", Pod);

            return(dquery.RunActionQuery());
        }
Пример #20
0
        public int AddEditCountry(int userID, int pk_CountryID, string CountryName, string CountryAbbr, string GMT, string ISD, string Sector, bool isEdit)
        {
            string ProcName = "admin.prcAddEditCountry";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@userID", userID);
            dquery.AddIntegerParam("@pk_CountryId", pk_CountryID);
            dquery.AddVarcharParam("@CountryName", 200, CountryName);
            dquery.AddVarcharParam("@CountryAbbr", 5, CountryAbbr);
            dquery.AddVarcharParam("@GMT", 10, GMT);
            dquery.AddVarcharParam("@ISD", 10, ISD);
            dquery.AddVarcharParam("@Sector", 50, Sector);
            dquery.AddBooleanParam("@isEdit", isEdit);

            return(dquery.RunActionQuery());
        }
Пример #21
0
        public int AddEditSTax(int userID, int pk_StaxID, DateTime?StartDate, decimal TaxAddCess, decimal TaxCess, decimal TaxPer, bool TaxStatus, bool isEdit)
        {
            string ProcName = "admin.prcAddEditSTax";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@userID", userID);
            dquery.AddIntegerParam("@pk_StaxID", pk_StaxID);
            dquery.AddDateTimeParam("@StartDate", StartDate);
            dquery.AddDecimalParam("@TaxAddCess", 6, 2, TaxAddCess);
            dquery.AddDecimalParam("@TaxCess", 6, 2, TaxCess);
            dquery.AddDecimalParam("@TaxPer", 6, 2, TaxPer);
            dquery.AddBooleanParam("@TaxStatus", TaxStatus);
            dquery.AddBooleanParam("@isEdit", isEdit);

            return(dquery.RunActionQuery());
        }
Пример #22
0
 public void DeleteMLVoyage(int VoyageId)
 {
     string ProcName = "prcDeleteMLVoyage";
     DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
     dquery.AddIntegerParam("@pk_mainLineVoyageID", VoyageId);
     dquery.RunActionQuery();
 }
Пример #23
0
        public void DeleteSlotOperator(int pk_SlotOperatorId)
        {
            string ProcName = "exp.prcDeleteSlotOperator";
            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@pk_SlotOperatorID", pk_SlotOperatorId);
            dquery.RunActionQuery();

        }
Пример #24
0
        public void DeleteVoyage(int voyageID)
        {
            string ProcName = "[admin].[prcDeleteVoyage]";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@pk_voyageID", voyageID);
            dquery.RunActionQuery();
        }
Пример #25
0
        public void DeleteVessel(int vesselId)
        {
            string ProcName = "[admin].[prcDeleteVessel]";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@pk_vesselId", vesselId);
            dquery.RunActionQuery();
        }
Пример #26
0
        public void DeleteLine(int pk_NVOCCId)
        {
            string ProcName = "admin.prcDeleteLine";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@pk_NVOCCId", pk_NVOCCId);
            dquery.RunActionQuery();
        }
Пример #27
0
        public void DeletePort(int PortId)
        {
            string ProcName = "admin.prcDeletePort";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@pk_PortID", PortId);
            dquery.RunActionQuery();
        }
Пример #28
0
        public void DeleteFreeDays(int pk_LinkID)
        {
            string ProcName = "[admin].[prcDeleteFreeDays]";
            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@pk_LinkID", pk_LinkID);
            dquery.RunActionQuery();

        }
Пример #29
0
        public void DeleteCountry(int countryId)
        {
            string ProcName = "admin.prcDeleteCountry";

            DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
            dquery.AddIntegerParam("@pk_countryId", countryId);
            dquery.RunActionQuery();
        }
Пример #30
0
        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());
        }