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);
}
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());
}
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();
}
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 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 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 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());
}
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 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 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 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 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 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());
}
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();
}
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();
}
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());
}
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();
}
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();
}
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());
}
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());
}
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());
}
public void DeleteMLVoyage(int VoyageId)
{
string ProcName = "prcDeleteMLVoyage";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_mainLineVoyageID", VoyageId);
dquery.RunActionQuery();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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();
}
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());
}
