private static void Process_Update_Phone(DataTable table) { classDataAccess dwDataAccess = new classDataAccess(); dwDataAccess.OpenConnection("CW_DW"); int result = 0; int resu_aud1 = 0; int resu_aud2 = 0; int count = 0; int count_err = 0; string phone_p = ""; foreach (DataRow row in table.Rows) { result = 0; if (dwDataAccess.Check_Exist_Card(row.ItemArray[1].ToString()) == "1") //cif co tren cw { phone_p = dwDataAccess.Get_Inf_Cus(row.ItemArray[1].ToString()); //phone from CW //if (phone_p != "") { resu_aud1 = dwDataAccess.Insert_UPD_INF_AUD(UPDATE_TYPE, row.ItemArray[1].ToString(), phone_p, row.ItemArray[0].ToString(), 1); resu_aud2 = dwDataAccess.Insert_UPD_INF_AUD(UPDATE_TYPE, row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), row.ItemArray[0].ToString(), 2); } result = dwDataAccess.Update_CIF(row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), row.ItemArray[3].ToString(), row.ItemArray[0].ToString()); if (result == 1) //update cif thanh cong { int flag_in_dw = dwDataAccess.Insert_Update_InfDW(UPDATE_TYPE, row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), //row.ItemArray[3].ToString(), row.ItemArray[0].ToString(), "S"); if (flag_in_dw != 0) //insert DW thanh cong { count++; } } else { classUpdatePhoneLogWriter.WriteLog("cif: " + row.ItemArray[1].ToString() + " can't update from FCC"); count_err++; } } else { dwDataAccess.Insert_Update_InfDW(UPDATE_TYPE, row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), //row.ItemArray[3].ToString(), row.ItemArray[0].ToString(), "D"); //D: cif don't have on CW } } dwDataAccess.CloseConnection(); classUpdatePhoneLogWriter.WriteLog("so cif da update thanh cong: " + count); classUpdatePhoneLogWriter.WriteLog("so cif update loi: " + count_err); }