public void syncDataCabang(string tableName, string PKField = "", string keyword = "")
{
string sqlCommand = "";
List <int> branchIDList = new List <int>();
MySqlDataReader rdr;
// EXPORT DATA TO FILE
string localDate = "";
string fileName = "";
localDate = String.Format(culture, "{0:ddMMyyyy}", DateTime.Now);
fileName = "EXPORT_SS_DATA_" + tableName + "_" + localDate + ".sql";
// EXPORT LOCAL DATA
exportData(fileName, tableName, PKField, keyword, "", true, true);
sqlCommand = "SELECT BRANCH_ID FROM MASTER_BRANCH WHERE BRANCH_ACTIVE = 1";
using (rdr = DS.getData(sqlCommand))
{
if (rdr.HasRows)
{
while (rdr.Read())
{
branchIDList.Add(rdr.GetInt32("BRANCH_ID"));
}
}
}
rdr.Close();
string HQ_IP_ADDRESS = DS.getHQ_IPServer();
// START CONNECTION TO PABRIK
clearDataCabang(tableName, 0, HQ_IP_ADDRESS);
sendDataToCabang(fileName, 0, HQ_IP_ADDRESS);
// START CONNECTION TO EACH BRANCH
for (int i = 0; i < branchIDList.Count; i++)
{
clearDataCabang(tableName, branchIDList[i]);
sendDataToCabang(fileName, branchIDList[i]);
}
}