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