///Description: Method used to Sync SQL to vessel after verification from JIT End,Vessel List and Query is sent from JIT
public string SyncBuildQuery(DataTable vesselID, string strSQLQuery)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
//Select Single Vessel ID and pass to it in loop
DataRow[] drs = vesselID.Select("Vessel_ID is not null");
foreach (DataRow row in drs)
{
objVessel.SYNC_SQlQueryToVessels("", "", "", Convert.ToInt32(row["Vessel_ID"]), strSQLQuery, "", "");
}
return("true");
}
/// <summary>
/// get the execution log and store in CRM DB
/// </summary>
/// <param name="Vessel_ID"></param>
/// <returns></returns>
public DataTable GetDeltaDllAcknowledgement(int Vessel_ID)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.Get_JibeDeltaDllAcknowledgement(Vessel_ID));
}
// update jibesync DB LIB_VESSELS's Autosync flag to 1
public int UpdJiBeDeltaAutoSyncFlag(int Vessel_ID, string SyncConn_String)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.Upd_JiBeDeltaAutoSyncFlag(Vessel_ID, SyncConn_String));
}
// Update JIBESync DB Installation flag to 1 for sending/reciveing data to or from vessel
public int UpdJiBeDeltaSyncFlag(int Vessel_ID)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.Upd_JiBeDeltaSyncFlag(Vessel_ID));
}
// Get license request details from Jibe Main DB
public DataTable GetDeltaLicenseRequest(int Vessel_Owner)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.Get_JiBeDeltaLicenseKeyRequest(Vessel_Owner));
}
///Description: Method used to Get details of SQL which are executed at Vessel side.
public DataTable GET_Delta_DLL_Log(int Vessel_ID, int LastID)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.GET_Delta_DLL_Log(Vessel_ID, LastID));
}
// Get incremental SQL script log for a vessel pass the previous sql script version from JIT
public DataTable GET_Delta_SQL_Script_Log(int Vessel_ID, int SqlVersion)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.GET_Delta_SQL_Script_Log(Vessel_ID, SqlVersion));
}
///Description: Method used to Get details of SQL which are executed at Vessel side.
public DataTable GET_SQL_Script_Log()
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.GET_SQL_Script_Log());
}
public DataSet SyncBuildAssemblies()
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.Get_JiBeBuildAssemblies());
}
/// <summary>
/// Generate the License key based on autorizedkey
// Insert record in DATA_Log table and send generated licensekey to calling app
/// </summary>
/// <param name="Vessel_ID"></param>
/// <param name="AutorizedKey"> autroized key</param>
/// <returns>license key </returns>
public string GetNewDeltaLicenseKey(int Vessel_ID, string AutorizedKey)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.Upd_JiBeDeltaLicenseKey(Vessel_ID, AutorizedKey));
}
/// <summary>
/// save file byte data at passed location
/// </summary>
/// <param name="FileName"> path to save the file </param>
/// <param name="fileData"> byte data of a file</param>
/// <returns>flag</returns>
public Boolean PutVesselReleaseFileToJibe(string FileName, byte[] fileData)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.Put_VesselReleaseFileToJibe(FileName, fileData));
}
/// <summary>
///
/// </summary>
/// <param name="Vessel_ID"></param>
/// <param name="SetupCreationDate"></param>
/// <returns></returns>
public Boolean CreateDeltaData(int Vessel_ID, DateTime SetupCreationDate)
{
BLL_Build_Service objVessel = new BLL_Build_Service();
return(objVessel.Upd_JibeDeltaData(Vessel_ID, SetupCreationDate));;
}
