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();
}
