private static void Insert_SMSMessage(DataTable table) { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); classDataAccess IMDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); IMDataAccess.OpenConnection("CW_IM"); string link_km = classUtilities.GetStringValueFromConfig("SCB_KM"); string link_HDSD = classUtilities.GetStringValueFromConfig("SCB_HDSD"); string message = ""; string message_encode = ""; int result = 0; int count = 0; int count_err = 0; foreach (DataRow row in table.Rows) { string card_no = classUtilities.GetCardFromSMS_Pin_List(row.ItemArray[9].ToString()); if (card_no == "")//nhan pin giay { string count_act = IMDataAccess.Get_First_Activate(row.ItemArray[9].ToString()); if (count_act == "1")//1: active lan dau { string count_rep = IMDataAccess.Get_Reply_Card(row.ItemArray[9].ToString()); if (count_rep == "0")//0: the chua thay the { message = CreateSMSMessage_act_first(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km, link_HDSD); } else { message = CreateSMSMessage(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km); } } else { message = CreateSMSMessage(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km); } //message = CreateSMSMessage(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km); if (string.IsNullOrEmpty(message) == false) { string mobile = row.ItemArray[7].ToString(); if (row.ItemArray[7].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW(//classDataAccess.IDALERT row.ItemArray[8].ToString() , mobile , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW(//classDataAccess.IDALERT row.ItemArray[8].ToString() , mobile , message , 'N' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } if (result == 1) { if (row.ItemArray[7].ToString() == "khong co") { count += dwDataAccess.InsertKichHoatTheSMSToDW( SMS_TYPE , message , mobile , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[9].ToString() , row.ItemArray[2].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() , row.ItemArray[6].ToString() , row.ItemArray[1].ToString() , "Y" ); } else { count += dwDataAccess.InsertKichHoatTheSMSToDW( SMS_TYPE , message , mobile , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[9].ToString() , row.ItemArray[2].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() , row.ItemArray[6].ToString() , row.ItemArray[1].ToString() , "N" ); } } else { count_err += dwDataAccess.InsertKichHoatTheSMSToDW( SMS_TYPE , message , mobile , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[9].ToString() , row.ItemArray[2].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() , row.ItemArray[6].ToString() , row.ItemArray[1].ToString() , "E" ); } } else //gen mess loi { classKichHoatTheLogWriter.WriteLog("err when create mess: " + row.ItemArray[9].ToString()); } } else //nhan pin sms { result = 0; string loc_pan = row.ItemArray[10].ToString() + row.ItemArray[4].ToString().Substring(12, 4); //if (row.ItemArray[11].ToString() == "P")//P: the chinh //{ // string count_act = IMDataAccess.Get_First_Activate(row.ItemArray[9].ToString()); // if (row.ItemArray[14].ToString() == "")//the ko thuoc CBNV // { // if (count_act == "1")//1: active lan dau // { // string count_rep = IMDataAccess.Get_Reply_Card(row.ItemArray[9].ToString()); // if (count_rep == "0")//0: the chua thay the // { // message = CreateSMSMessage_phi(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), row.ItemArray[7].ToString(), loc_pan); // } // else // message = CreateSMSMessage_QC(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km, row.ItemArray[7].ToString(), loc_pan); // } // else // { // message = CreateSMSMessage_QC(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km, row.ItemArray[7].ToString(), loc_pan); // } // } // else // message = CreateSMSMessage_QC(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km, row.ItemArray[7].ToString(), loc_pan); //} //else//the phu //{ // //message = CreateSMSMessage(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(),row.ItemArray[13].ToString()); // message = CreateSMSMessage_QC(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km, row.ItemArray[7].ToString(), loc_pan); //} string pin = Gen_PIN(row.ItemArray[7].ToString(), loc_pan); if (pin != null) { message = CreateSMSMessage_QC(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km, row.ItemArray[7].ToString(), loc_pan, pin); message_encode = CreateSMSMessage_EC(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString(), link_km, row.ItemArray[7].ToString(), loc_pan, pin); } else //gen PIN Loi { classKichHoatTheLogWriter.WriteLog("gen PIN loi for LOC: " + row.ItemArray[10].ToString()); } if (string.IsNullOrEmpty(message) == false) { string mobile = row.ItemArray[7].ToString(); if (row.ItemArray[7].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW(//classDataAccess.IDALERT row.ItemArray[8].ToString() , mobile , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW(//classDataAccess.IDALERT row.ItemArray[8].ToString() , mobile , message , 'N' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } if (result == 1) { if (row.ItemArray[7].ToString() == "khong co") { count += dwDataAccess.InsertKichHoatTheSMSToDW( SMS_TYPE , message_encode , mobile , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[9].ToString() , row.ItemArray[2].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() , row.ItemArray[6].ToString() , row.ItemArray[1].ToString() , "Y" ); } else { count += dwDataAccess.InsertKichHoatTheSMSToDW( SMS_TYPE , message_encode , mobile , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[9].ToString() , row.ItemArray[2].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() , row.ItemArray[6].ToString() , row.ItemArray[1].ToString() , "N" ); } } else { count_err += dwDataAccess.InsertKichHoatTheSMSToDW( SMS_TYPE , message_encode , mobile , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[9].ToString() , row.ItemArray[2].ToString() , row.ItemArray[3].ToString() , row.ItemArray[5].ToString() , row.ItemArray[6].ToString() , row.ItemArray[1].ToString() , "E" ); } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classKichHoatTheLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + count); classKichHoatTheLogWriter.WriteLog("Message loi khong Insert vao EbankGW: " + count_err); }