//Build List of Available GLCodes (Receiver Side)
public bool BuildReceiverGLCodes()
{
bool bIsDoneReceiverGLCodes = false;
string sIP = aTechnicalInfo[2].ToString();
string sPastelConn = aTechnicalInfo[6].ToString().Trim();
//Create Instance of Web Service
localhost.TransferManager wsTransferMan = new Solsage_Process_Management_System.localhost.TransferManager();
string[] bIsFetchGLCodesSuccess = new string[2];
//Test Connection/Webservice
string sWebServiceURL = "http://" + sIP + "//liquid//TransferManager.asmx";
if (IsAddressAvailable(sWebServiceURL))
{
try
{
//Set Server Address & Request Data
wsTransferMan.Url = sWebServiceURL;
bIsFetchGLCodesSuccess = wsTransferMan.GenerateGLCodes(sPastelConn);
//Determine Request Outcome + Handle
if (bIsFetchGLCodesSuccess[0] == "success")
{
//Assign Values
sReceiverGLCodes = bIsFetchGLCodesSuccess[1].ToString();
bIsDoneReceiverGLCodes = true;
}
else
{
bIsDoneReceiverGLCodes = false;
}
}
catch (Exception ex)
{
string sErrorMsg = ex.Message;
bIsDoneReceiverGLCodes = false;
}
}
else
{
//Handle Webservice Error/Unavailable
bIsDoneReceiverGLCodes = false;
}
return bIsDoneReceiverGLCodes;
}
private void ExecuteDocTransfer()
{
localhost.TransferManager wsTransferMan = new Solsage_Process_Management_System.localhost.TransferManager();
string[] bIsTransferSuccess = new string[2];
string[] bIsTransferTMPWriteSuccess = new string[2];
bool bActive = true;
string sSelectedIP = "";
foreach (DataGridViewRow dgRow in dgvTransferDetails.Rows) //All Data to Send - Row by Row
{
//Shift Selected Row
dgRow.Selected = true;
//Assign Variables' Values
string sDocNum = dgRow.Cells["clDocNum"].Value.ToString();
string sDocType = dgRow.Cells["clDocTypeNum"].Value.ToString();
//Determine DocType to Transfer
string sDocTypeToTransfer = "";
if (sDocType == "103" || sDocType == "3")
sDocTypeToTransfer = "106";
else if (sDocType == "104" || sDocType == "4")
sDocTypeToTransfer = "109";
string sHistHeader = dgRow.Cells["clHistHeader"].Value.ToString();
string sHistLines = dgRow.Cells["clHistLines"].Value.ToString();
string sIP = dgRow.Cells["clIP"].Value.ToString();
string sDatapath = dgRow.Cells["clDatapath"].Value.ToString();
string sSuppRef = dgRow.Cells["clSuppRef"].Value.ToString();
string sSOLPMSConn = dgRow.Cells["clSOLPMS_Conn"].Value.ToString();
//Test Connection/Webservice
string sWebServiceURL = "http://" + sIP + "//liquid//TransferManager.asmx";
Application.DoEvents();
if (sIP != sSelectedIP)
{
sSelectedIP = sIP;
bActive = true;
}
if (bActive)
{
if (IsAddressAvailable(sWebServiceURL))
{
Application.DoEvents();
//Set Server Address & Transfer Data
wsTransferMan.Url = sWebServiceURL;
try
{
bIsTransferTMPWriteSuccess = wsTransferMan.ProcessTransfer(sDocNum, sDocTypeToTransfer, sHistHeader, sHistLines, sDatapath, sSuppRef, sSOLPMSConn, Global.sLogedInUserCode, Global.sLogedInUserName);
//Write to TEMP Holding Table Completed
if (bIsTransferTMPWriteSuccess[0] == "success")
{
//Poll DB via WebService - pass TransNumber
bool isDone = false;
TimeSpan tsTimeout = new TimeSpan(0, 2, 0);
DateTime dtEndTime = DateTime.Now + tsTimeout;
while (!isDone)
{
if (DateTime.Now < dtEndTime)
{
//Call Webservice
bIsTransferSuccess = wsTransferMan.PollDBTransfer(bIsTransferTMPWriteSuccess[1].ToString());
//Do Tests
if (Convert.ToInt32(bIsTransferSuccess[0]) == 1)
{
isDone = true;
//TRANFER SUCCESSFUL - Capture in Completed Table
using (PsqlConnection oTCompConn = new PsqlConnection(Connect.sConnStr))
{
oTCompConn.Open();
string sTCompSql = "INSERT INTO SOLTCOMP (sSentDocNum,sTransToIP,sTransToDataPath,dtTimeCompleted,sReceivedDocNum,sUserCode,sUserName) VALUES";
sTCompSql += "(";
sTCompSql += "'" + sDocNum + "',";
sTCompSql += "'" + sIP + "',";
sTCompSql += "'" + sDatapath + "',";
sTCompSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sTCompSql += "'" + bIsTransferSuccess[1].ToString() + "',";
sTCompSql += "'" + Global.sLogedInUserCode + "',";
sTCompSql += "'" + Global.sLogedInUserName + "')";
int iCompletedRet = Connect.getDataCommand(sTCompSql, oTCompConn).ExecuteNonQuery();
//DELETE FROM ERROR TABLE - if completed
string sDelTErrSql = "DELETE FROM SOLTERR WHERE sDocNum = '" + sDocNum + "'";
int iDeletedRet = Connect.getDataCommand(sDelTErrSql, oTCompConn).ExecuteNonQuery();
}
//Mark Row - SUCCESSFUL
dgRow.DefaultCellStyle.BackColor = Color.Green;
}
if (Convert.ToInt32(bIsTransferSuccess[0]) == 2)
{
isDone = true;
using (PsqlConnection oTErrConn = new PsqlConnection(Connect.sConnStr))
{
oTErrConn.Open();
string sTErrSql = "INSERT INTO SOLTERR (sDocNum,sTransToIP,sTransToDataPath,dtTimeFailed,sErrorInfo,sUserCode,sUserName) VALUES";
sTErrSql += "(";
sTErrSql += "'" + sDocNum + "',";
sTErrSql += "'" + sIP + "',";
sTErrSql += "'" + sDatapath + "',";
sTErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sTErrSql += "'" + bIsTransferSuccess[1].ToString() + "',";
sTErrSql += "'" + Global.sLogedInUserCode + "',";
sTErrSql += "'" + Global.sLogedInUserName + "')";
int iTErrRet = Connect.getDataCommand(sTErrSql, oTErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
else //TIMEOUT
{
isDone = true;
using (PsqlConnection oTErrConn = new PsqlConnection(Connect.sConnStr))
{
oTErrConn.Open();
string sTErrSql = "INSERT INTO SOLTERR (sDocNum,sTransToIP,sTransToDataPath,dtTimeFailed,sErrorInfo,sUserCode,sUserName) VALUES";
sTErrSql += "(";
sTErrSql += "'" + sDocNum + "',";
sTErrSql += "'" + sIP + "',";
sTErrSql += "'" + sDatapath + "',";
sTErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sTErrSql += "'Timeout Occured in DB Polling',";
sTErrSql += "'" + Global.sLogedInUserCode + "',";
sTErrSql += "'" + Global.sLogedInUserName + "')";
int iTErrRet = Connect.getDataCommand(sTErrSql, oTErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
}
else
{
//TRANFER FAILED - Capture in Error Table
using (PsqlConnection oTErrConn = new PsqlConnection(Connect.sConnStr))
{
oTErrConn.Open();
string sTErrSql = "INSERT INTO SOLTERR (sDocNum,sTransToIP,sTransToDataPath,dtTimeFailed,sErrorInfo,sUserCode,sUserName) VALUES";
sTErrSql += "(";
sTErrSql += "'" + sDocNum + "',";
sTErrSql += "'" + sIP + "',";
sTErrSql += "'" + sDatapath + "',";
sTErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sTErrSql += "'" + bIsTransferTMPWriteSuccess[1].ToString() + "',";
sTErrSql += "'" + Global.sLogedInUserCode + "',";
sTErrSql += "'" + Global.sLogedInUserName + "')";
int iTErrRet = Connect.getDataCommand(sTErrSql, oTErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
catch (Exception ex)
{
//WEB SERVICE OR OTHER ERROR
using (PsqlConnection oErrorConn = new PsqlConnection(Connect.sConnStr))
{
string sErrSql = "INSERT INTO SOLTERR (sDocNum,sTransToIP,sTransToDataPath,dtTimeFailed,sErrorInfo,sUserCode,sUserName) VALUES";
sErrSql += "(";
sErrSql += "'" + sDocNum + "',";
sErrSql += "'" + sIP + "',";
sErrSql += "'" + sDatapath + "',";
sErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sErrSql += "'" + ex.Message.Replace("'"," ") + "',";
sErrSql += "'" + Global.sLogedInUserCode + "',";
sErrSql += "'" + Global.sLogedInUserName + "')";
int iErrRet = Connect.getDataCommand(sErrSql, oErrorConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
else
{
bActive = false;
//WEB SERVICE UNAVAILABLE - Capture in Error Table
using (PsqlConnection oErrorConn = new PsqlConnection(Connect.sConnStr))
{
string sErrSql = "INSERT INTO SOLTERR (sDocNum,sTransToIP,sTransToDataPath,dtTimeFailed,sErrorInfo,sUserCode,sUserName) VALUES";
sErrSql += "(";
sErrSql += "'" + sDocNum + "',";
sErrSql += "'" + sIP + "',";
sErrSql += "'" + sDatapath + "',";
sErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sErrSql += "'Connection to Web Service Failed. Web Service unavailable',";
sErrSql += "'" + Global.sLogedInUserCode + "',";
sErrSql += "'" + Global.sLogedInUserName + "')";
int iErrRet = Connect.getDataCommand(sErrSql, oErrorConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
else
{
//WEB SERVICE UNAVAILABLE - Capture in Error Table
using (PsqlConnection oErrorConn = new PsqlConnection(Connect.sConnStr))
{
string sErrSql = "INSERT INTO SOLTERR (sDocNum,sTransToIP,sTransToDataPath,dtTimeFailed,sErrorInfo,sUserCode,sUserName) VALUES";
sErrSql += "(";
sErrSql += "'" + sDocNum + "',";
sErrSql += "'" + sIP + "',";
sErrSql += "'" + sDatapath + "',";
sErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sErrSql += "'Connection to Web Service Failed. Web Service unavailable',";
sErrSql += "'" + Global.sLogedInUserCode + "',";
sErrSql += "'" + Global.sLogedInUserName + "')";
int iErrRet = Connect.getDataCommand(sErrSql, oErrorConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
btnRefreshTransfers.Enabled = true;
btnTransfer.Enabled = false;
btnTestConnection.Enabled = false;
}
private void ExecuteGLCodeSync()
{
localhost.TransferManager wsSyncMan = new Solsage_Process_Management_System.localhost.TransferManager();
string[] bIsSyncSuccess = new string[2];
foreach (DataGridViewRow dgRow in dgvSyncDetails.Rows) //All Data to Sync - Row by Row
{
if (dgRow.Cells["clIncludeInSync"].Value != null && dgRow.Cells["clIncludeInSync"].Value.ToString() == "True")
{
//Shift Selected Row
dgRow.Selected = true;
//Assign Variables' Values
string sGLCode = dgRow.Cells["clGLCode"].Value.ToString();
string sReceiverIP = dgRow.Cells["clIP"].Value.ToString();
string sReceiverAlias = dgRow.Cells["clReceiverAlias"].Value.ToString();
string sReceiverRef = dgRow.Cells["clReceiverRef"].Value.ToString();
string sDataPath = dgRow.Cells["clDataPath"].Value.ToString();
string sSourceRef = dgRow.Cells["clSourceRef"].Value.ToString();
string sLiquidConn = dgRow.Cells["clSOLPMSConn"].Value.ToString();
string sPastelConn = dgRow.Cells["clPastelConn"].Value.ToString();
string sInsertString = dgRow.Cells["clInsertLine"].Value.ToString();
//Test Connection/Webservice
string sWebServiceURL = "http://" + sReceiverIP + "//liquid//TransferManager.asmx";
if (IsAddressAvailable(sWebServiceURL))
{
//Set Server Address & Transfer Data
wsSyncMan.Url = sWebServiceURL;
try
{
bIsSyncSuccess = wsSyncMan.ProcessSync(sGLCode, sInsertString, sDataPath, sSourceRef, sLiquidConn, sPastelConn, Global.sLogedInUserCode, Global.sLogedInUserName);
//Determine Transfer Outcome + Handle
if (bIsSyncSuccess[0] == "success")
{
//SYNC SUCCESSFUL - Capture in Completed Table
using (PsqlConnection oSCompConn = new PsqlConnection(Connect.sConnStr))
{
oSCompConn.Open();
string sSCompSql = "INSERT INTO SOLSCOMP (sSentGLCode,sReceiverIP,sReceiverDataPath,dtDateTimeCompleted,sLiquidUserCode,sLiquidUserName) VALUES";
sSCompSql += "(";
sSCompSql += "'" + sGLCode + "',";
sSCompSql += "'" + sReceiverIP + "',";
sSCompSql += "'" + sDataPath + "',";
sSCompSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSCompSql += "'" + Global.sLogedInUserCode + "',";
sSCompSql += "'" + Global.sLogedInUserName + "')";
int iCompletedRet = Connect.getDataCommand(sSCompSql, oSCompConn).ExecuteNonQuery();
//DELETE FROM ERROR TABLE - if completed
string sDelSErrSql = "DELETE FROM SOLSERR WHERE sSentGLCode = '" + sGLCode + "'";
int iDeletedRet = Connect.getDataCommand(sDelSErrSql, oSCompConn).ExecuteNonQuery();
}
//Mark Row - SUCCESSFUL
dgRow.DefaultCellStyle.BackColor = Color.Green;
}
else
{
//SYNC FAILED - Capture in Error Table
using (PsqlConnection oSErrConn = new PsqlConnection(Connect.sConnStr))
{
oSErrConn.Open();
string sSErrSql = "INSERT INTO SOLSERR (sSentGLCode,sReceiverIP,sReceiverDataPath,dtDateTimeFailed,sErrorInfo,sLiquidUserCode,sLiquidUserName) VALUES";
sSErrSql += "(";
sSErrSql += "'" + sGLCode + "',";
sSErrSql += "'" + sReceiverIP + "',";
sSErrSql += "'" + sDataPath + "',";
sSErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSErrSql += "'" + bIsSyncSuccess[1].ToString() + "',";
sSErrSql += "'" + Global.sLogedInUserCode + "',";
sSErrSql += "'" + Global.sLogedInUserName + "')";
int iSErrRet = Connect.getDataCommand(sSErrSql, oSErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
catch (Exception ex)
{
//WEB SERVICE OR OTHER ERROR
using (PsqlConnection oSErrConn = new PsqlConnection(Connect.sConnStr))
{
oSErrConn.Open();
string sSErrSql = "INSERT INTO SOLSERR (sSentGLCode,sReceiverIP,sReceiverDataPath,dtDateTimeFailed,sErrorInfo,sLiquidUserCode,sLiquidUserName) VALUES";
sSErrSql += "(";
sSErrSql += "'" + sGLCode + "',";
sSErrSql += "'" + sReceiverIP + "',";
sSErrSql += "'" + sDataPath + "',";
sSErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSErrSql += "'" + ex.Message.ToString() + "',";
sSErrSql += "'" + Global.sLogedInUserCode + "',";
sSErrSql += "'" + Global.sLogedInUserName + "')";
int iSErrRet = Connect.getDataCommand(sSErrSql, oSErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
else
{
//WEB SERVICE UNAVAILABLE - Capture in Error Table
using (PsqlConnection oErrorConn = new PsqlConnection(Connect.sConnStr))
{
string sSErrSql = "INSERT INTO SOLSERR (sSentGLCode,sReceiverIP,sReceiverDataPath,dtDateTimeFailed,sErrorInfo,sLiquidUserCode,sLiquidUserName) VALUES";
sSErrSql += "(";
sSErrSql += "'" + sGLCode + "',";
sSErrSql += "'" + sReceiverIP + "',";
sSErrSql += "'" + sDataPath + "',";
sSErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSErrSql += "'Connection to Web Service Failed. Web Service unavailable',";
sSErrSql += "'" + Global.sLogedInUserCode + "',";
sSErrSql += "'" + Global.sLogedInUserName + "')";
int iErrRet = Connect.getDataCommand(sSErrSql, oErrorConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
}
//Enable Controls
btnRefreshSync.Enabled = true;
btnSync.Enabled = false;
chkAll.Enabled = false;
txtGLCode.Enabled = false;
}
private void ExecuteInvCodeSync()
{
localhost.TransferManager wsSyncMan = new Solsage_Process_Management_System.localhost.TransferManager();
string[] bIsSyncTMPWriteSuccess = new string[2];
string[] bIsSyncSuccess = new string[2];
foreach (DataGridViewRow dgRow in dgvSyncDetails.Rows) //All Data to Sync - Row by Row
{
if (dgRow.Cells["clIncludeInSync"].Value != null && dgRow.Cells["clIncludeInSync"].Value.ToString() == "True")
{
//Shift Selected Row
dgRow.Selected = true;
//Assign Variables' Values
string sInvCode = dgRow.Cells["clInventoryCode"].Value.ToString();
string sReceiverIP = dgRow.Cells["clIP"].Value.ToString();
string sReceiverAlias = dgRow.Cells["clReceiverAlias"].Value.ToString();
string sReceiverRef = dgRow.Cells["clReceiverRef"].Value.ToString();
string sDataPath = dgRow.Cells["clDataPath"].Value.ToString();
string sSourceRef = dgRow.Cells["clSourceRef"].Value.ToString();
string sLiquidConn = dgRow.Cells["clSOLPMSConn"].Value.ToString();
string sPastelConn = dgRow.Cells["clPastelConn"].Value.ToString();
string sInsertString = dgRow.Cells["clInsertLine"].Value.ToString();
//Test Connection/Webservice
string sWebServiceURL = "http://" + sReceiverIP + "//liquid//TransferManager.asmx";
if (IsAddressAvailable(sWebServiceURL))
{
//Set Server Address & Transfer Data
wsSyncMan.Url = sWebServiceURL;
try
{
bIsSyncTMPWriteSuccess = wsSyncMan.ProcessInvSync(sInvCode, sInsertString, sDataPath, sSourceRef, sLiquidConn, sPastelConn, Global.sLogedInUserCode, Global.sLogedInUserName);
//Write to TEMP Holding Table Completed
if (bIsSyncTMPWriteSuccess[0] == "success")
{
//Poll DB via WebService - pass TransNumber
bool isDone = false;
TimeSpan tsTimeout = new TimeSpan(0, 2, 0);
DateTime dtEndTime = DateTime.Now + tsTimeout;
while (!isDone)
{
if (DateTime.Now < dtEndTime)
{
//Call Webservice
bIsSyncSuccess = wsSyncMan.PollDBInvoice(bIsSyncTMPWriteSuccess[1].ToString());
//Do Tests
if (Convert.ToInt32(bIsSyncSuccess[0]) == 1)
{
isDone = true;
//SYNC SUCCESSFUL - Capture in Completed Table
using (PsqlConnection oSCompConn = new PsqlConnection(Connect.sConnStr))
{
oSCompConn.Open();
string sSCompSql = "INSERT INTO SOLINVSCOMP (sSentInvCode,sReceiverIP,sReceiverDataPath,dtDateTimeCompleted,sLiquidUserCode,sLiquidUserName) VALUES";
sSCompSql += "(";
sSCompSql += "'" + sInvCode + "',";
sSCompSql += "'" + sReceiverIP + "',";
sSCompSql += "'" + sDataPath + "',";
sSCompSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSCompSql += "'" + Global.sLogedInUserCode + "',";
sSCompSql += "'" + Global.sLogedInUserName + "')";
int iCompletedRet = Connect.getDataCommand(sSCompSql, oSCompConn).ExecuteNonQuery();
//DELETE FROM ERROR TABLE - if completed
string sDelSErrSql = "DELETE FROM SOLINVSERR WHERE sSentInvCode = '" + sInvCode + "'";
int iDeletedRet = Connect.getDataCommand(sDelSErrSql, oSCompConn).ExecuteNonQuery();
}
//Mark Row - SUCCESSFUL
dgRow.DefaultCellStyle.BackColor = Color.Green;
}
if (Convert.ToInt32(bIsSyncSuccess[0]) == 2)
{
isDone = true;
//ERROR
using (PsqlConnection oSErrConn = new PsqlConnection(Connect.sConnStr))
{
oSErrConn.Open();
string sSErrSql = "INSERT INTO SOLINVSERR (sSentInvCode,sReceiverIP,sReceiverDataPath,dtDateTimeFailed,sErrorInfo,sLiquidUserCode,sLiquidUserName) VALUES";
sSErrSql += "(";
sSErrSql += "'" + sInvCode + "',";
sSErrSql += "'" + sReceiverIP + "',";
sSErrSql += "'" + sDataPath + "',";
sSErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSErrSql += "'" + bIsSyncSuccess[1].ToString() + "',";
sSErrSql += "'" + Global.sLogedInUserCode + "',";
sSErrSql += "'" + Global.sLogedInUserName + "')";
int iSErrRet = Connect.getDataCommand(sSErrSql, oSErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
else //TIMEOUT
{
isDone = true;
//ERROR
using (PsqlConnection oSErrConn = new PsqlConnection(Connect.sConnStr))
{
oSErrConn.Open();
string sSErrSql = "INSERT INTO SOLINVSERR (sSentInvCode,sReceiverIP,sReceiverDataPath,dtDateTimeFailed,sErrorInfo,sLiquidUserCode,sLiquidUserName) VALUES";
sSErrSql += "(";
sSErrSql += "'" + sInvCode + "',";
sSErrSql += "'" + sReceiverIP + "',";
sSErrSql += "'" + sDataPath + "',";
sSErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSErrSql += "'Timeout Occured in DB Polling',";
sSErrSql += "'" + Global.sLogedInUserCode + "',";
sSErrSql += "'" + Global.sLogedInUserName + "')";
int iSErrRet = Connect.getDataCommand(sSErrSql, oSErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
}
else
{
//SYNC TEMP WRITE FAILED - Capture in Error Table
using (PsqlConnection oSErrConn = new PsqlConnection(Connect.sConnStr))
{
oSErrConn.Open();
string sSErrSql = "INSERT INTO SOLINVSERR (sSentInvCode,sReceiverIP,sReceiverDataPath,dtDateTimeFailed,sErrorInfo,sLiquidUserCode,sLiquidUserName) VALUES";
sSErrSql += "(";
sSErrSql += "'" + sInvCode + "',";
sSErrSql += "'" + sReceiverIP + "',";
sSErrSql += "'" + sDataPath + "',";
sSErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSErrSql += "'" + bIsSyncTMPWriteSuccess[1].Replace("'","").ToString() + "',";
sSErrSql += "'" + Global.sLogedInUserCode + "',";
sSErrSql += "'" + Global.sLogedInUserName + "')";
int iSErrRet = Connect.getDataCommand(sSErrSql, oSErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
catch (Exception ex)
{
//WEB SERVICE OR OTHER ERROR
using (PsqlConnection oSErrConn = new PsqlConnection(Connect.sConnStr))
{
oSErrConn.Open();
string sSErrSql = "INSERT INTO SOLINVSERR (sSentInvCode,sReceiverIP,sReceiverDataPath,dtDateTimeFailed,sErrorInfo,sLiquidUserCode,sLiquidUserName) VALUES";
sSErrSql += "(";
sSErrSql += "'" + sInvCode + "',";
sSErrSql += "'" + sReceiverIP + "',";
sSErrSql += "'" + sDataPath + "',";
sSErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSErrSql += "'" + ex.Message.ToString() + "',";
sSErrSql += "'" + Global.sLogedInUserCode + "',";
sSErrSql += "'" + Global.sLogedInUserName + "')";
int iSErrRet = Connect.getDataCommand(sSErrSql, oSErrConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
else
{
//WEB SERVICE UNAVAILABLE - Capture in Error Table
using (PsqlConnection oErrorConn = new PsqlConnection(Connect.sConnStr))
{
string sSErrSql = "INSERT INTO SOLINVSERR (sSentInvCode,sReceiverIP,sReceiverDataPath,dtDateTimeFailed,sErrorInfo,sLiquidUserCode,sLiquidUserName) VALUES";
sSErrSql += "(";
sSErrSql += "'" + sInvCode + "',";
sSErrSql += "'" + sReceiverIP + "',";
sSErrSql += "'" + sDataPath + "',";
sSErrSql += "'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "',";
sSErrSql += "'Connection to Web Service Failed. Web Service unavailable',";
sSErrSql += "'" + Global.sLogedInUserCode + "',";
sSErrSql += "'" + Global.sLogedInUserName + "')";
int iErrRet = Connect.getDataCommand(sSErrSql, oErrorConn).ExecuteNonQuery();
}
//Mark Row - ERROR
dgRow.DefaultCellStyle.BackColor = Color.Red;
}
}
}
//Done
btnRefreshSync.Enabled = true;
btnSync.Enabled = false;
txtInvCode.Enabled = false;
}
