private static int SendSMSForPhone_K(classDataAccess ebankDataAccess, classDataAccess dwDataAccess, DataRow row, string creditOrDebit, string mess, string phone, string flag_sms) { try { if (string.IsNullOrEmpty(mess.Trim()) == false) { string status = (creditOrDebit == "Giao dich:" ? " " : "C");//neu la giao dich reversal thi status = "C" int flag_fpt = dwDataAccess.InsertOutBalChangeMDSMSToDW(SMS_TYPE, mess , phone , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[17].ToString() , row.ItemArray[2].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()) , row.ItemArray[9].ToString() , row.ItemArray[11].ToString() , row.ItemArray[12].ToString() , status , row.ItemArray[1].ToString() , flag_sms ); if (flag_fpt == 0) { classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can not insert DB DW"); return(1); //intert DW khong thanh cong } } return(3);//ko gui sms } catch (Exception ex) { classGDMCDebitLogWriter.WriteLog("Error SendSMSForPhone_K():" + ex.Message); return(3);//3: loi } }
private static int SendSMSForPhone(classDataAccess ebankDataAccess, classDataAccess dwDataAccess, DataRow row, string creditOrDebit, string mess, string phone, string flag_send) { try { int result = 0; if (string.IsNullOrEmpty(mess.Trim()) == false) { string status = (creditOrDebit == "Giao dich:" ? " " : "C");//neu la giao dich reversal thi status = "C" //if (flag_send == "Y") //{ if (phone == "khong co") { int flag_fpt = dwDataAccess.InsertOutBalChangeMDSMSToDW(SMS_TYPE, mess , phone , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[17].ToString() , row.ItemArray[2].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()) , row.ItemArray[9].ToString() , row.ItemArray[11].ToString() , row.ItemArray[12].ToString() , status , row.ItemArray[1].ToString() , "Y"//khong co so dt, tin nhan ko duoc gui di ); if (flag_fpt == 0) { classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can not insert DB DW"); return(1); //intert DW khong thanh cong } else //inster DW thanh cong { result = ebankDataAccess.InsertSMSMessateToEBankGW( //classDataAccess.IDALERT row.ItemArray[16].ToString() , phone , mess , 'Y' //Y: (se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); if (result == 0) { classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can not insert Ebanking GW"); return(2); //2: inster EB khong thanh cong } else { return(0); //thanh cong } } } else //so phone hop le { int flag_fpt = dwDataAccess.InsertOutBalChangeMDSMSToDW( SMS_TYPE , mess , phone , DateTime.Parse(row.ItemArray[0].ToString()) , row.ItemArray[17].ToString() , row.ItemArray[2].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()) , row.ItemArray[9].ToString() , row.ItemArray[11].ToString() , row.ItemArray[12].ToString() , status , row.ItemArray[1].ToString() , "N"//normal: insert DW thanh cong ); if (flag_fpt == 0) { classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can't insert DB DW"); return(1); //intert DW khong thanh cong } else //inster DW thanh cong { result = ebankDataAccess.InsertSMSMessateToEBankGW( //classDataAccess.IDALERT row.ItemArray[16].ToString() , phone , mess , 'N' //Y: (se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); if (result == 0) { int flag = dwDataAccess.Update_Status_SMS( //update status sms ve loi ko gui qua EW row.ItemArray[17].ToString(), row.ItemArray[5].ToString(), row.ItemArray[11].ToString(), "E" ); classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can not insert Ebanking GW"); return(2); //2: inster EB khong thanh cong } else { return(0); //thanh cong } } } //} //else// flag = N, khong nhan sms //{ // int flag_fpt = dwDataAccess.InsertOutBalChangeMDSMSToDW(SMS_TYPE, mess // , phone // , DateTime.Parse(row.ItemArray[0].ToString()) // //, row.ItemArray[4].ToString() // , row.ItemArray[17].ToString() // , row.ItemArray[2].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()) // , row.ItemArray[9].ToString() // , row.ItemArray[11].ToString() // , row.ItemArray[12].ToString() // , status // , row.ItemArray[1].ToString() // , "K"//the ko dk nhan sms // ); // if (flag_fpt == 0) // { // dwDataAccess.InsertOutBalChangeMDSMSToDW(SMS_TYPE, mess // , phone // , DateTime.Parse(row.ItemArray[0].ToString()) // //, row.ItemArray[4].ToString() // , row.ItemArray[17].ToString() // , row.ItemArray[2].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()) // , row.ItemArray[9].ToString() // , row.ItemArray[11].ToString() // , row.ItemArray[12].ToString() // , status // , row.ItemArray[1].ToString() // , "K"//insert lan 2: loi do ko insert duoc DW lan 1 // ); // classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can't insert DB DW"); // return 1; // } //} } return(3);//ko gui sms } catch (Exception ex) { classGDMCDebitLogWriter.WriteLog("Error SendSMSForPhone():" + ex.Message); return(3);//3: loi } }