/// <summary>
/// Date Created: 30/09/2011
/// Created By: Charlene Remotigue
/// Descrition: Delete City
/// </summary>
public static void CityViewMasterfileDelete(string pCityId, string pModifiedBy)
{
try
{
MasterfileDAL.cityViewMasterfileDelete(pCityId, pModifiedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 30/09/2011
/// Created By: Charlene Remotigue
/// Descrition: Insert Region
/// </summary>
public static void regionAddMasterfileInsert(string regionName, string CreatedBy)
{
try
{
MasterfileDAL.regionAddMasterfileInsert(regionName, CreatedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 05/10/2011
/// Created By: Charlene Remotigue
/// Description: Select Service Provider Seaport
/// </summary>
public static DataTable PortListMaintenanceSearchAgentSeaport(string portAgentId, string CityId, Int32 startRowIndex, Int32 maximumRows)
{
try
{
return(MasterfileDAL.PortListMaintenanceSearchAgentSeaport(portAgentId, CityId, startRowIndex, maximumRows));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 07/10/2011
/// Created By: Charlene Remotigue
/// Description: Select Seaport
/// </summary>
public static DataTable PortListMaintenanceSearch(int CityId, int PortAgentId, bool loadAll)
{
try
{
return(MasterfileDAL.PortListMaintenanceSearch(CityId, PortAgentId, loadAll));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 25/01/2012
/// Created By: Gelo Oquialda
/// (description) Update Region
/// </summary>
///
public static void MasterfileRegionUpdate(int regionId, string regionName, string ModifiedBy)
{
try
{
MasterfileDAL.MasterfileRegionUpdate(regionId, regionName, ModifiedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 03/10/2011
/// Created By: Charlene Remotigue
/// Descrition: Update Country
/// </summary>
///
public static void countryAddMasterfileUpdate(int regionId, int countryId, string countryName, string countryCode, string ModifiedBy)
{
try
{
MasterfileDAL.countryAddMasterfileUpdate(regionId, countryId, countryName, countryCode, ModifiedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created:11/10/2011
/// Created By: Charlene Remotigue
/// Description: Delete Service Provider Seaport
/// </summary>
public static void portListMaintenanceDelete(int portAgentSeaportId, string ModifiedBy)
{
try
{
MasterfileDAL.portListMaintenanceDelete(portAgentSeaportId, ModifiedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created:11/10/2011
/// Created By: Charlene Remotigue
/// Description: Delete Sail Master
/// </summary>
public static void SailMasterViewDelete(string pSailMasterId, string pModifiedBy)
{
try
{
MasterfileDAL.SailMasterViewDelete(pSailMasterId, pModifiedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 03/10/2011
/// Created By: Charlene Remotigue
/// Descrition: Update City
/// </summary>
public static void cityAddMasterfileUpdate(int CountryId, int CityId, string CityName, string CityCode, string ModifiedBy)
{
try
{
MasterfileDAL.cityAddMasterfileUpdate(CountryId, CityId, CityName, CityCode, ModifiedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 30/09/2011
/// Created By: Charlene Remotigue
/// Descrition: Delete Region
/// </summary>
public static void regionAddMasterfileDelete(int regionId, string ModifiedBy)
{
try
{
MasterfileDAL.regionAddMasterfileDelete(regionId, ModifiedBy);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created:03/10/2011
/// Created By: Charlene Remotigue
/// Description: Add new city
/// </summary>
public static Int32 cityAddMasterfileInsert(int CountryId, string CityCode, string CityName, string CreatedBy)
{
try
{
Int32 CityID = 0;
CityID = MasterfileDAL.cityAddMasterfileInsert(CountryId, CityCode, CityName, CreatedBy);
return(CityID);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created: 25/01/2012
/// Created By: Gelo Oquialda
/// (description) Insert region
/// </summary>
public static Int32 MasterfileRegionInsert(string regionName, string CreatedBy)
{
try
{
Int32 RegionID = 0;
RegionID = MasterfileDAL.MasterfileRegionInsert(regionName, CreatedBy);
return(RegionID);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created:04/10/2011
/// Created By: Charlene Remotigue
/// Description: Add new Service Provider seaport
/// </summary>
public static Int32 portListMaintenanceInsert(int portAgentId, int PortId, string CreatedBy)
{
try
{
Int32 PortAgentSeaportID = 0;
PortAgentSeaportID = MasterfileDAL.PortListMaintenanceInsert(portAgentId, PortId, CreatedBy);
return(PortAgentSeaportID);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created:04/10/2011
/// Created By: Charlene Remotigue
/// Description: Save event
/// </summary>
public static Int32 EventsAddMaintenanceSave(string EventId, string EventName, DateTime DateFrom,
DateTime DateTo, string BranchId, string CityId, string UserId, string Remarks)
{
try
{
Int32 pEventID = 0;
pEventID = MasterfileDAL.EventsAddMaintenanceSave(EventId, EventName, DateFrom,
DateTo, BranchId, CityId, UserId, Remarks);
return(pEventID);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Date Created:03/10/2011
/// Created By: Charlene Remotigue
/// Description: Add new country
/// </summary>
public static Int32 countryAddMasterfileInsert(string countryCode, string CountryName, string CreatedBy)
{
Int32 CountryID = 0;
CountryID = MasterfileDAL.countryAddMasterfileInsert(countryCode, CountryName, CreatedBy);
return(CountryID);
//try
//{
// Int32 CountryID = 0;
// CountryID = MasterfileDAL.countryAddMasterfileInsert(countryCode, CountryName, CreatedBy);
// return CountryID;
//}
//catch (Exception ex)
//{
// throw ex;
//}
}
/// <summary>
/// Date Created: 03/10/2011
/// Created By: Josephine Gad
/// (description) Selecting list of reference by code
/// </summary>
/// <param name="RefCode"></param>
/// <returns></returns>
public static DataTable GetReference(string RefCode)
{
DataTable dt = null;
try
{
dt = MasterfileDAL.GetReference(RefCode);
return(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (dt != null)
{
dt.Dispose();
}
}
}
/// <summary>
/// Date Created: 04/Mar/2014
/// Created By: Josephine Gad
/// (description) Get Vessel Brand List
/// ----------------------------------------------
/// </summary>
/// <returns></returns>
public List <BrandList> GetBrandList()
{
return(MasterfileDAL.GetBrandList());
}
/// <summary>
/// Date Created: 19/Nov/2014
/// Created By: Josephine Monteza
/// (description) Get Vessel By Brand
/// ----------------------------------------------
/// </summary>
/// <returns></returns>
public List <VesselList> GetVesselList(string sBrandID)
{
return(MasterfileDAL.GetVesselList(sBrandID));
}
/// <summary>
/// Date Created: 25/Nov/2014
/// Created By: Josephine Monteza
/// (description) Get Nationality List
/// ----------------------------------------------
/// </summary>
/// <returns></returns>
public static List <NationalityList> GetNationalityList(string sFilter, string sSortedBy, int iStartRow, int iMaxRow)
{
return(MasterfileDAL.GetNationalityList(sFilter, sSortedBy, iStartRow, iMaxRow));
}
/// Date Created: 14/Nov/2013
/// Created By: Josephine Gad
/// (description) Get Seaport List
/// ----------------------------------------------
/// </summary>
/// <param name="CountryID"></param>
/// <returns></returns>
public static List <SeaportDTO> GetSeaportList(bool IsSearchByCode, string sFilter)
{
return(MasterfileDAL.GetSeaportList(IsSearchByCode, sFilter));
}
public static void SaveRegionSeaport(DataTable dt, string UserName, int RegionId,
string RegionName, string sDescription, string sFunction, string sFileName, DateTime GMTDate, DateTime Now)
{
MasterfileDAL.SaveRegionSeaport(dt, UserName, RegionId, RegionName, sDescription, sFunction, sFileName, GMTDate, Now);
}
