public static int Update_Terminal(DataTable table, string dest)
{
int count_ATM = 0;
int count_POS = 0;
try
{
foreach (DataRow row in table.Rows)
{
if (dataAccess.Check_Exist_Ter(row.ItemArray[0].ToString()) == 1)//terminal da ton tai
{
if (row.ItemArray[4].ToString() == "ATM")
{
bool temp = dataAccess.Update_Terminal(row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), "FCC", row.ItemArray[5].ToString());
if (temp == true)
{
count_ATM++;
dataAccess.Insert_Terminal_FromFCC(row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), row.ItemArray[4].ToString()
, row.ItemArray[5].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[6].ToString());
classUpdateTerminalLogWriter.WriteLog("Update ATM: " + dest + " " + row.ItemArray[0].ToString() + " " + DateTime.Now.ToString());
}
}
if (row.ItemArray[4].ToString() == "POS")
{
bool temp = false;
string acc_no = dataAccess.GET_INF_ACC(row.ItemArray[9].ToString());
if (row.ItemArray[10].ToString() == "C")
{
string acc_temp = "''" + acc_no + "''";
temp = dataAccess.Update_Terminal(row.ItemArray[0].ToString(), acc_temp, "CLOSED", row.ItemArray[5].ToString());
if (temp == true)
{
count_POS++;
dataAccess.Insert_Terminal_FromFCC(row.ItemArray[0].ToString(), acc_no, row.ItemArray[4].ToString()
, row.ItemArray[5].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[6].ToString());
classUpdateTerminalLogWriter.WriteLog("Close POS: " + dest + " " + row.ItemArray[0].ToString() + " " + DateTime.Now.ToString());
}
}
else
{
temp = dataAccess.Update_Terminal(row.ItemArray[0].ToString(), acc_no, "FCC", row.ItemArray[5].ToString());
if (temp == true)
{
count_POS++;
dataAccess.Insert_Terminal_FromFCC(row.ItemArray[0].ToString(), acc_no, row.ItemArray[4].ToString()
, row.ItemArray[5].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[6].ToString());
classUpdateTerminalLogWriter.WriteLog("Update POS: " + dest + " " + row.ItemArray[0].ToString() + " " + DateTime.Now.ToString());
}
}
}
}
else//teminal chua ton tai
{
if (row.ItemArray[4].ToString() == "ATM")
{
bool temp2 = dataAccess.Insert_Terminal(row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString());
if (temp2 == true)
{
count_ATM++;
dataAccess.Insert_Terminal_FromFCC(row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), row.ItemArray[4].ToString()
, row.ItemArray[5].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[6].ToString());
classUpdateTerminalLogWriter.WriteLog("Insert ATM: " + dest + " " + row.ItemArray[0].ToString() + " " + DateTime.Now.ToString());
}
}
if (row.ItemArray[4].ToString() == "POS")
{
string acc_no = dataAccess.GET_INF_ACC(row.ItemArray[9].ToString());
string type_P = "CMS";
bool temp2 = dataAccess.Insert_Terminal(row.ItemArray[0].ToString(), acc_no, type_P, row.ItemArray[5].ToString());
if (temp2 == true)
{
count_POS++;
dataAccess.Insert_Terminal_FromFCC(row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), row.ItemArray[4].ToString()
, row.ItemArray[5].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[6].ToString());
classUpdateTerminalLogWriter.WriteLog("Insert POS: " + dest + " " + row.ItemArray[0].ToString() + " " + DateTime.Now.ToString());
}
}
}
}
//if(count_ATM > 0)
//classUpdateTerminalLogWriter.WriteLog("Update " + count_ATM + " ATM :" + DateTime.Now.ToString() );
//if (count_POS > 0)
//classUpdateTerminalLogWriter.WriteLog("Update " + count_POS + " POS :" + DateTime.Now.ToString());
}
catch (Exception ex)
{
classUpdateTerminalLogWriter.WriteLog("Error Update_Terminal(), " + ex.Message);
return(0);
}
return(count_POS + count_ATM);
}