private static void Insert_SMSMessage(DataTable table, string crd_brn) { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); string message = ""; int result = 0; int count = 0; foreach (DataRow row in table.Rows) { result = 0; message = CreateSMSMessage(row.ItemArray[4].ToString(), row.ItemArray[2].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[10].ToString(), crd_brn, row.ItemArray[11].ToString(), row.ItemArray[12].ToString()); if (string.IsNullOrEmpty(message) == false) { //mobile = classUtilities.GetMobileFromCardN oOfSpecialList(row.ItemArray[2].ToString(), row.ItemArray[1].ToString()); double ipp = 0; if (row.ItemArray[10].ToString() != "") { ipp = double.Parse(row.ItemArray[10].ToString()); } if (double.Parse(row.ItemArray[6].ToString()) >= 0 || double.Parse(row.ItemArray[6].ToString()) <= -100000 || ipp > 0) { if (row.ItemArray[1].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(classDataAccess.IDALERT , row.ItemArray[1].ToString() //classDataAccess.MYPHONE , message , 'Y' // Y: se ko gui tin nhan, D: ko gui, N: gui, E:Error , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(classDataAccess.IDALERT , row.ItemArray[1].ToString() //classDataAccess.MYPHONE , message , 'N' // hhhh Y: se ko gui tin nhan, D: ko gui, N: gui, E:Error , SMS_TYPE); } } else // 0 > closing > -100000 and don't have IPP, don't send { count += dwDataAccess.InsertReminderPayment_1SMSToDW(SMS_TYPE, message , row.ItemArray[1].ToString()// ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) , row.ItemArray[9].ToString() , row.ItemArray[4].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() // , long.Parse(row.ItemArray[5].ToString()) , row.ItemArray[6].ToString() // , long.Parse(row.ItemArray[6].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "Y" ); } if (result == 1) { if (row.ItemArray[1].ToString() == "khong co") { count += dwDataAccess.InsertReminderPayment_1SMSToDW(SMS_TYPE, message , row.ItemArray[1].ToString()// ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) , row.ItemArray[9].ToString() , row.ItemArray[4].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() // , long.Parse(row.ItemArray[5].ToString()) , row.ItemArray[6].ToString() // , long.Parse(row.ItemArray[6].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "Y" ); } else { count += dwDataAccess.InsertReminderPayment_1SMSToDW(SMS_TYPE, message , row.ItemArray[1].ToString()// ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) , row.ItemArray[9].ToString() , row.ItemArray[4].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() // , long.Parse(row.ItemArray[5].ToString()) , row.ItemArray[6].ToString() // , long.Parse(row.ItemArray[6].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "N" //hhhh Y: se ko gui tin nhan, D: ko gui, N: gui, E:Error ); } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classReminderPayment1LogWriter.WriteLog("So luong message da duoc Insert vao EbankGW thanh cong: " + count); return; }