public int GetId(string ItemName, string ItemValue)
{
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery("prcGetId");
dquery.AddVarcharParam("@ItemName", 15, ItemName);
dquery.AddVarcharParam("@ItemValue", 50, ItemValue);
return(Convert.ToInt32(dquery.GetScalar()));
}
public void UpdateMUSTRecord(string mn, string yr)
{
string ProcName = "[exp].[sp_UpdateShipsoft]";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddVarcharParam("@mn", 2, mn);
dquery.AddVarcharParam("@yr", 4, yr);
dquery.RunActionQuery();
}
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 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 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 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 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 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 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 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 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 void DeleteGeneral(string formName, int pk_tableID)
{
string ProcName = "prcDeleteGeneral";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@pk_tableID", pk_tableID);
dquery.AddVarcharParam("@formName", 20, formName);
dquery.RunActionQuery();
}
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 int AddEditLine(int userID, int pk_NVOCCId, string NVOCCName, int DefaultFreeDays, string ContAgentCode, decimal ImpCommsn, decimal ExpCommsn, char ExpBook, decimal rBuffer, string logoPath, bool isEdit)
{
string ProcName = "admin.prcAddEditLine";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@userID", userID);
dquery.AddIntegerParam("@pk_NVOCCId", pk_NVOCCId);
dquery.AddVarcharParam("@NVOCCName", 50, NVOCCName);
dquery.AddIntegerParam("@DefaultFreeDays", DefaultFreeDays);
dquery.AddVarcharParam("@ContAgentCode", 10, ContAgentCode);
dquery.AddDecimalParam("@ImportCommission", 6, 2, ImpCommsn);
dquery.AddDecimalParam("@ExportCommission", 6, 2, ExpCommsn);
dquery.AddDecimalParam("@RBuffer", 6, 2, rBuffer);
dquery.AddCharParam("@ExportBooking", 1, ExpBook);
dquery.AddVarcharParam("@logoPath", 150, logoPath);
dquery.AddBooleanParam("@isEdit", isEdit);
return(dquery.RunActionQuery());
}
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 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 int AddEditPort(int userID, int pk_PortId, string PortName, string PortCode, bool ICDIndicator, string PortAddressee, string Address2, string Address3, string ExportPort, bool isEdit)
{
string ProcName = "admin.prcAddEditPort";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@userID", userID);
dquery.AddIntegerParam("@pk_PortId", pk_PortId);
dquery.AddVarcharParam("@PortName", 200, PortName);
dquery.AddVarcharParam("@PortCode", 6, PortCode);
dquery.AddBooleanParam("@ICDIndicator", ICDIndicator);
dquery.AddVarcharParam("@PortAddressee", 50, PortAddressee);
dquery.AddVarcharParam("@Address2", 50, Address2);
dquery.AddVarcharParam("@Address3", 50, Address3);
dquery.AddVarcharParam("@ExportPort", 3, ExportPort);
dquery.AddBooleanParam("@isEdit", isEdit);
return(dquery.RunActionQuery());
}
public int AddEditVoyage(int userID, bool isEdit, EMS.Entity.VoyageEntity voyage)
{
string ProcName = "prcAddEditVoyage";
DAL.DbManager.DbQuery dquery = new DAL.DbManager.DbQuery(ProcName);
dquery.AddIntegerParam("@userID", userID);
dquery.AddBooleanParam("@isEdit", isEdit);
dquery.AddIntegerParam("@pk_VoyageID", voyage.pk_VoyageID);
dquery.AddIntegerParam("@fk_VesselID", voyage.fk_VesselID);
dquery.AddIntegerParam("@fl_TerminalID", voyage.fl_TerminalID);
dquery.AddVarcharParam("@VoyageNo", 10, voyage.VoyageNo);
dquery.AddDecimalParam("@ImpXChangeRate", 6, 2, voyage.ImpXChangeRate);
dquery.AddVarcharParam("@IGMNo", 10, voyage.IGMNo);
//dquery.AddVarcharParam("@CallSign", 14, voyage.CallSign);
dquery.AddDateTimeParam("@IGMDate", voyage.IGMDate);
dquery.AddDateTimeParam("@LandingDate", voyage.LandingDate);
dquery.AddDateTimeParam("@ETADate", voyage.ETADate);
dquery.AddDateTimeParam("@AddLandingDate", voyage.AddLandingDate);
dquery.AddDateTimeParam("@PCCDate", voyage.PCCDate);
dquery.AddVarcharParam("@PCCNo", 14, voyage.PCCNo);
dquery.AddVarcharParam("@VoyageType", 1, "I");
dquery.AddIntegerParam("@fk_LPortID", voyage.fk_LPortID);
dquery.AddIntegerParam("@fk_LPortID1", voyage.fk_LPortID1);
dquery.AddIntegerParam("@fk_LPortID2", voyage.fk_LPortID2);
dquery.AddVarcharParam("@LGNo", 40, voyage.LGNo);
dquery.AddVarcharParam("@AltLGNo", 40, voyage.AltLGNo);
dquery.AddVarcharParam("@VesselType", 1, voyage.VesselType);
dquery.AddVarcharParam("@MotherDaughterDtl", 500, voyage.MotherDaughterDtl);
dquery.AddVarcharParam("@TotalLines", 5, voyage.TotalLines);
dquery.AddVarcharParam("@CargoDesc", 50, voyage.CargoDesc);
dquery.AddVarcharParam("@VIANo", 10, voyage.VIANo);
dquery.AddVarcharParam("@VCN", 14, voyage.VCN);
dquery.AddVarcharParam("@ETATime", 7, voyage.ETATime);
dquery.AddIntegerParam("@LightHouseDue", voyage.LightHouseDue);
dquery.AddBooleanParam("@SameButtonCargo", voyage.SameButtonCargo == "1" ? true : false);
dquery.AddBooleanParam("@ShipStoreSubmitted", voyage.ShipStoreSubmitted == "1" ? true : false);
dquery.AddBooleanParam("@CrewList", voyage.CrewList == "1" ? true : false);
dquery.AddBooleanParam("@PassengerList", voyage.PassengerList == "1" ? true : false);
dquery.AddBooleanParam("@CrewEffectList", voyage.CrewEffectList == "1" ? true : false);
dquery.AddBooleanParam("@MaritimeList", voyage.MaritimeList == "1" ? true : false);
dquery.AddIntegerParam("@LocId", voyage.locid);
dquery.AddIntegerParam("@fk_pod", voyage.fk_Pod);
return(dquery.RunActionQuery());
}