private bool sendDataToCabangMultipleFiles(int branchID, string ipServerBranch = "")
{
Data_Access DS_BRANCH = new Data_Access();
bool result = false;
// CONNECT TO BRANCH
if (DS_BRANCH.Branch_mySQLConnect(branchID, ipServerBranch))
{
result = syncLocalDataToServerMultipleFiles(DS_BRANCH, Data_Access.BRANCH_SERVER);
// CLOSE BRANCH CONNECTION
DS_BRANCH.Branch_mySqlClose();
}
return(result);
}
private bool clearDataCabang(string tableName, int branchID, string ipServerBranch = "")
{
Data_Access DS_BRANCH = new Data_Access();
bool result = false;
string sqlCommand = "";
MySqlException internalEX = null;
// CONNECT TO BRANCH
if (DS_BRANCH.Branch_mySQLConnect(branchID, ipServerBranch))
{
DS_BRANCH.beginTransaction(Data_Access.BRANCH_SERVER);
try
{
sqlCommand = "DELETE FROM " + tableName;
if (!DS_BRANCH.executeNonQueryCommand(sqlCommand))
{
throw internalEX;
}
DS_BRANCH.commit();
result = true;
}
catch (Exception ex)
{
gUtil.saveSystemDebugLog(0, "[SYNC CABANG] FAILED TO CLEAR DATA CABANG [" + ex.Message + "]");
}
// CLOSE BRANCH CONNECTION
DS_BRANCH.Branch_mySqlClose();
}
else
{
gUtil.saveSystemDebugLog(0, "[SYNC CABANG] FAILED TO CONNECT TO CABANG");
}
return(result);
}
private string createUpdateQueryDataCabang(int branchID, string tableName, string PKField, List <string> fieldToBackup, string ipServerBranch = "")
{
Data_Access DS_BRANCH = new Data_Access();
//bool result = false;
string sqlCommand = "";
MySqlDataReader rdr;
string fieldName;
object DBValue = null;
int rdrFieldIndex = 0;
int startIndex = 0;
StreamWriter sw = null;
string fileName = "";
string commandStatement = "";
string valueStatement = "";
string fieldValueForPK = "";
fileName = "EXPORT_" + branchID + "_DATA_" + tableName + ".sql";
if (!File.Exists(fileName))
{
sw = File.CreateText(fileName);
}
else
{
File.Delete(fileName);
sw = File.CreateText(fileName);
}
// CONNECT TO BRANCH
if (DS_BRANCH.Branch_mySQLConnect(branchID, ipServerBranch))
{
sqlCommand = "SELECT * FROM " + tableName;
using (rdr = DS_BRANCH.getData(sqlCommand, false, true))
{
if (rdr.HasRows)
{
while (rdr.Read())
{
commandStatement = "UPDATE " + tableName + " SET ";
valueStatement = "";
for (rdrFieldIndex = startIndex; rdrFieldIndex < rdr.FieldCount; rdrFieldIndex++)
{
DBValue = rdr.GetValue(rdrFieldIndex);
if (DBValue.ToString().Length > 0)
{
fieldName = rdr.GetName(rdrFieldIndex);
if (!fieldToSkip.Contains(fieldName) && fieldName != PKField)
{
continue;
}
if (fieldName != PKField)
{
valueStatement = valueStatement + fieldName + " = " + "'" + Convert.ToString(rdr.GetValue(rdrFieldIndex)) + "', ";
}
else
{
fieldValueForPK = Convert.ToString(rdr.GetValue(rdrFieldIndex));
}
}
}
valueStatement = valueStatement.Substring(0, valueStatement.Length - 2);
commandStatement = commandStatement + valueStatement;
commandStatement = commandStatement + " WHERE " + PKField + " = '" + fieldValueForPK + "';";
sw.WriteLine(commandStatement);
}
}
}
rdr.Close();
// CLOSE BRANCH CONNECTION
DS_BRANCH.Branch_mySqlClose();
//result = true;
}
else
{
gUtil.saveSystemDebugLog(0, "[SYNC CABANG] FAILED TO CONNECT TO CABANG");
}
sw.Close();
return(fileName);
}