private static void Insert_SMSMessage_Email(DataTable table) { try { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); string message = ""; int result = 0; int count = 0; int count2 = 0; int count_err = 0; foreach (DataRow row in table.Rows) { string due_date = row.ItemArray[6].ToString(); DateTime dua_date_p = new DateTime(int.Parse(due_date.Substring(0, 4)), int.Parse(due_date.Substring(4, 2)), int.Parse(due_date.Substring(6, 2))); if (System.DateTime.Today == dua_date_p.AddDays(classUtilities.GetIntValueFromConfig("date1_NoQuaHan")) || System.DateTime.Today == dua_date_p.AddDays(classUtilities.GetIntValueFromConfig("date2_NoQuaHan")) || System.DateTime.Today == dua_date_p.AddDays(classUtilities.GetIntValueFromConfig("date3_NoQuaHan")) ) //if (1 == 1) //hhhh { result = 0; //message = CreateSMSMessage(row.ItemArray[1].ToString(), row.ItemArray[0].ToString(), row.ItemArray[10].ToString(), row.ItemArray[8].ToString(), row.ItemArray[11].ToString(), row.ItemArray[14].ToString(), row.ItemArray[15].ToString()); message = CreateSMSMessage_new(row.ItemArray[1].ToString(), row.ItemArray[0].ToString(), DateTime.Parse(row.ItemArray[10].ToString()), row.ItemArray[8].ToString(), row.ItemArray[11].ToString(), row.ItemArray[14].ToString(), row.ItemArray[15].ToString()); if (string.IsNullOrEmpty(message) == false) { string mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[0].ToString(), row.ItemArray[3].ToString()); if (row.ItemArray[3].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[12].ToString() , mobile , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } else { //result = 1; result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[12].ToString() , mobile , message , 'N' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } if (result == 1) { int temp = dwDataAccess.Insert_MASTERCARD_EMAIL ( row.ItemArray[4].ToString() , row.ItemArray[2].ToString() , double.Parse(row.ItemArray[5].ToString()) , double.Parse(row.ItemArray[11].ToString()) , double.Parse(row.ItemArray[8].ToString()) , row.ItemArray[1].ToString() ); if (temp == 1) { int temp2 = 0; if (row.ItemArray[3].ToString() == "khong co") { temp2 = dwDataAccess.InsertNoQuaHanSMSToDW( SMS_TYPE , message , mobile , DateTime.Parse(row.ItemArray[10].ToString()) //, row.ItemArray[0].ToString() , row.ItemArray[13].ToString() , row.ItemArray[1].ToString() , row.ItemArray[9].ToString() , "Y" ); } else { temp2 = dwDataAccess.InsertNoQuaHanSMSToDW( SMS_TYPE , message , mobile , DateTime.Parse(row.ItemArray[10].ToString()) //, row.ItemArray[0].ToString() , row.ItemArray[13].ToString() , row.ItemArray[1].ToString() , row.ItemArray[9].ToString() , "N" ); } count++; if (temp2 == 1) { count2++; } } } else { count_err = dwDataAccess.InsertNoQuaHanSMSToDW( SMS_TYPE , message , mobile , DateTime.Parse(row.ItemArray[10].ToString()) //, row.ItemArray[0].ToString() , row.ItemArray[13].ToString() , row.ItemArray[1].ToString() , row.ItemArray[9].ToString() , "E" ); } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classNoQuaHanLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + count2); classNoQuaHanLogWriter.WriteLog("Message loi khong Insert vao EbankGW: " + count_err); classNoQuaHanLogWriter.WriteLog("Message da duoc Insert vao XMIS thanh cong: " + count); } catch (Exception e) { classNoQuaHanLogWriter.WriteLog("Err Insert_SMSMessage_Email(): " + e.ToString()); } }