private static void Insert_SMSMessage_S(DataTable table) { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); string message = ""; int resultDW = 0; int resultGW = 0; int countDW = 0; int count_errDW = 0; int countGW = 0; int count_errGW = 0; //OracleCommand cmd = ebankDataAccess.AddProcedureParameterToEBankGW(); l foreach (DataRow row in table.Rows) { resultDW = 0; resultGW = 0; message = "";//reset //message = CreateSMSMessageS(row.ItemArray[5].ToString(), row.ItemArray[1].ToString(), row.ItemArray[3].ToString(), // row.ItemArray[2].ToString(), row.ItemArray[4].ToString()); message = CreateSMSMessageFailAnnualFee(row.ItemArray[5].ToString(), row.ItemArray[1].ToString(), row.ItemArray[3].ToString(), row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[16].ToString(), row.ItemArray[17].ToString()); if (string.IsNullOrEmpty(message) == false) { //string mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[10].ToString(), row.ItemArray[7].ToString()); string mobile = row.ItemArray[7].ToString(); if (row.ItemArray[10].ToString() == "khong co") { resultDW = dwDataAccess.InsertBlockAndFailAnnualFeeSMSToDW( SMS_TYPE , message , mobile // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[10].ToString() , row.ItemArray[5].ToString() , row.ItemArray[6].ToString() , row.ItemArray[3].ToString() // , long.Parse(row.ItemArray[5].ToString()) , row.ItemArray[2].ToString() // , long.Parse(row.ItemArray[6].ToString()) , row.ItemArray[4].ToString() // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "Y" ); } else { resultDW = dwDataAccess.InsertBlockAndFailAnnualFeeSMSToDW( SMS_TYPE , message , mobile // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[10].ToString() , row.ItemArray[5].ToString() , row.ItemArray[6].ToString() , row.ItemArray[3].ToString() // , long.Parse(row.ItemArray[5].ToString()) , row.ItemArray[2].ToString() // , long.Parse(row.ItemArray[6].ToString()) , row.ItemArray[4].ToString() // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "N" ); } if (resultDW == 1) { countDW++; if (row.ItemArray[7].ToString() == "khong co") { resultGW = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[9].ToString() , mobile , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } else { resultGW = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[9].ToString() , mobile , message , 'N' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } if (resultGW == 1) { countGW++; } else { count_errGW++; } } else { count_errDW++; } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classBlockAndFailAnnualFeeLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + countGW); classBlockAndFailAnnualFeeLogWriter.WriteLog("Message loi khong Insert vao EbankGW: " + count_errGW); classBlockAndFailAnnualFeeLogWriter.WriteLog("Message da duoc Insert vao DW thanh cong: " + countDW); classBlockAndFailAnnualFeeLogWriter.WriteLog("Message loi khong Insert vao DW: " + count_errDW); return; }