private static void Process_Update_Phone(DataTable table) { classDataAccess dwDataAccess = new classDataAccess(); dwDataAccess.OpenConnection("CW_DW"); int result = 0; int resu_aud1 = 0; int resu_aud2 = 0; int count = 0; int count_err = 0; string phone_p = ""; foreach (DataRow row in table.Rows) { result = 0; if (dwDataAccess.Check_Exist_Card(row.ItemArray[1].ToString()) == "1") //cif co tren cw { phone_p = dwDataAccess.Get_Inf_Cus(row.ItemArray[1].ToString()); //phone from CW //if (phone_p != "") { resu_aud1 = dwDataAccess.Insert_UPD_INF_AUD(UPDATE_TYPE, row.ItemArray[1].ToString(), phone_p, row.ItemArray[0].ToString(), 1); resu_aud2 = dwDataAccess.Insert_UPD_INF_AUD(UPDATE_TYPE, row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), row.ItemArray[0].ToString(), 2); } result = dwDataAccess.Update_CIF(row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), row.ItemArray[3].ToString(), row.ItemArray[0].ToString()); if (result == 1) //update cif thanh cong { int flag_in_dw = dwDataAccess.Insert_Update_InfDW(UPDATE_TYPE, row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), //row.ItemArray[3].ToString(), row.ItemArray[0].ToString(), "S"); if (flag_in_dw != 0) //insert DW thanh cong { count++; } } else { classUpdatePhoneLogWriter.WriteLog("cif: " + row.ItemArray[1].ToString() + " can't update from FCC"); count_err++; } } else { dwDataAccess.Insert_Update_InfDW(UPDATE_TYPE, row.ItemArray[1].ToString(), row.ItemArray[2].ToString(), //row.ItemArray[3].ToString(), row.ItemArray[0].ToString(), "D"); //D: cif don't have on CW } } dwDataAccess.CloseConnection(); classUpdatePhoneLogWriter.WriteLog("so cif da update thanh cong: " + count); classUpdatePhoneLogWriter.WriteLog("so cif update loi: " + count_err); }
private static void SendSMSForCrea_Card(string mobile, string sms) { try { string SMS_TYPE = "SMSME"; classDataAccess ebankDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); ebankDataAccess.InsertSMSMessateToEBankGW_2(classDataAccess.IDALERT , mobile //classUtilities.GetRandomMobile() , sms , 'N' //Y: (se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); ebankDataAccess.CloseConnection(); } catch (Exception ex) { classCheckDueDateLogWriter.WriteLog("Error SendSMSForCrea_Card():" + ex.Message); } }
private static void SendSMSForGW_EB(string mobile, int err) { try { classDataAccess ebankDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); string SMS_TYPE = "SMSME"; string message = "pls check connect to Ebanking GW," + err + " SMS can't insert data for ThuNoTatToanIPP."; ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , mobile //classUtilities.GetRandomMobile() , message , 'N' //Y: (se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); ebankDataAccess.CloseConnection(); } catch (Exception ex) { classThuNoTatToanIPPLogWriter.WriteLog("Error SendSMSForGW_EB():" + ex.Message); } }
private static void SendSMSForDW_FPT(string mobile, int err) { try { classDataAccess ebankDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); string SMS_TYPE = "SMSME"; string message = "pls check table FPT.smsmastercard, " + err + " SMS can't insert DB DW for MC Debit."; ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , mobile //classUtilities.GetRandomMobile() , message , 'N' //Y: (se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); ebankDataAccess.CloseConnection(); } catch (Exception ex) { classGDMCDebitLogWriter.WriteLog("Error SendSMSForDW_FPT():" + ex.Message); } }
private static void SendSMSForDueDate(string mobile) { try { classDataAccess ebankDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); string SMS_TYPE = "SMSME"; string message = "today is due date! pls run instruction file!"; ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , mobile //classUtilities.GetRandomMobile() , message , 'N' //Y: (se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); ebankDataAccess.CloseConnection(); } catch (Exception ex) { classCheckDueDateLogWriter.WriteLog("Error SendSMSForDueDate():" + ex.Message); } }
private static void SendSMSForLossMapCard(string mobile, int loss) { try { classDataAccess ebankDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); string SMS_TYPE = "SMSME"; string message = "pls check table IM.ir_pan_map," + loss + " card loss on this table."; ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , mobile //classUtilities.GetRandomMobile() , message , 'N' //Y: (se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); ebankDataAccess.CloseConnection(); } catch (Exception ex) { classGDMCDebitLogWriter.WriteLog("Error SendSMSForLossMapCard():" + ex.Message); } }
private static void SendSMSForSpaceDisk(string mobile) { try { classDataAccess ebankDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); string SMS_TYPE = "SMSME"; string message = "tomorrow will backup log switch at: /disk2/CW/CSWT/CWLOG/PREVLOGS. pls check space of disk2 on sever 76.11!"; ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , mobile //classUtilities.GetRandomMobile() , message , 'N' //Y: (se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); ebankDataAccess.CloseConnection(); } catch (Exception ex) { classCheckDueDateLogWriter.WriteLog("Error SendSMSForSpaceDisk():" + ex.Message); } }
private static void Insert_SMSMessage(DataTable table, int flag_send_sms) { try { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); string mobile = classUtilities.GetStringValueFromConfig("MyPhone1"); string mobile2 = classUtilities.GetStringValueFromConfig("MyPhone2"); string mobile3 = classUtilities.GetStringValueFromConfig("MyPhone3"); //string mobile4 = classUtilities.GetStringValueFromConfig("MyPhone4"); string mobile7 = classUtilities.GetStringValueFromConfig("MyPhone7"); int countSend = 0; int countReversalSend = 0; int flag_sendSMS = -1; int flag_sendSMSRe = -1; int err_DW = 0; int err_EB = 0; int err_mapcard = 0; int tol_err_EB = 0; int tol_err_DW = 0; foreach (DataRow row in table.Rows) { if (string.IsNullOrEmpty(row.ItemArray[13].ToString().Trim()) == false) // la giao dich reversal(status <> "") { if (IsExistedSMSOnDW( //row.ItemArray[4].ToString() row.ItemArray[17].ToString() , row.ItemArray[7].ToString() , row.ItemArray[11].ToString(), row.ItemArray[5].ToString()) == false) // chua gui tin nhan giao dich thuan { //flag_sendSMS=SendOneSMS(ebankDataAccess, dwDataAccess, row, "Giao dich:", flag_send_sms); SendOneSMS(ebankDataAccess, dwDataAccess, row, "Giao dich:", flag_send_sms, err_DW, err_EB); countSend++; } //flag_sendSMSRe=SendOneSMS(ebankDataAccess, dwDataAccess, row, "Hoan tra:", flag_send_sms); SendOneSMS(ebankDataAccess, dwDataAccess, row, "Hoan tra:", flag_send_sms, err_DW, err_EB); countReversalSend++; } else// la giao dich thuan { //flag_sendSMS=SendOneSMS(ebankDataAccess, dwDataAccess, row, "Giao dich:", flag_send_sms); SendOneSMS(ebankDataAccess, dwDataAccess, row, "Giao dich:", flag_send_sms, err_DW, err_EB); countSend++; } //if (flag_sendSMS == 1 || flag_sendSMSRe == 1) // err_DW++; //if (flag_sendSMS == 2 || flag_sendSMSRe == 2) // err_EB++; //if (flag_sendSMS == 4 || flag_sendSMSRe == 4) // err_mapcard++; tol_err_DW = +err_DW; tol_err_EB = +err_EB; } if (tol_err_DW > 0) { SendSMSForDW_FPT(mobile, err_DW); SendSMSForDW_FPT(mobile2, err_DW); SendSMSForDW_FPT(mobile3, err_DW); //SendSMSForDW_FPT(mobile4, err_DW); SendSMSForDW_FPT(mobile7, err_DW); } if (tol_err_EB > 0) { SendSMSForGW_EB(mobile, err_EB); SendSMSForGW_EB(mobile2, err_EB); SendSMSForGW_EB(mobile3, err_EB); //SendSMSForGW_EB(mobile4, err_EB); SendSMSForGW_EB(mobile7, err_EB); } //if (err_mapcard > 0) //{ // SendSMSForLossMapCard(mobile, err_mapcard); // SendSMSForLossMapCard(mobile2, err_mapcard); // SendSMSForLossMapCard(mobile3, err_mapcard); // SendSMSForLossMapCard(mobile4, err_mapcard); // SendSMSForLossMapCard(mobile7, err_mapcard); //} ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classGDMCDebitLogWriter.WriteLog("Message giao dich thuan da duoc Insert vao EbankGW thanh cong: " + countSend); classGDMCDebitLogWriter.WriteLog("Message giao dich reversal da duoc Insert vao EbankGW thanh cong: " + countReversalSend); return; } catch (Exception ex) { classGDMCDebitLogWriter.WriteLog("Error Insert_SMSMessage() " + ex.Message); } }
private static void Insert_SMSMessage(DataTable table) { 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 count_err = 0; //OracleCommand cmd = ebankDataAccess.AddProcedureParameterToEBankGW(); l foreach (DataRow row in table.Rows) { result = 0; message = CreateSMSMessage(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[16].ToString(), row.ItemArray[17].ToString()); ///////// //string month = System.DateTime.Today.ToString("yyyyMM"); //message = CreateSMSMessage_new(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), // row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), // row.ItemArray[8].ToString(), row.ItemArray[16].ToString(), row.ItemArray[17].ToString(), month); if (string.IsNullOrEmpty(message) == false) { //string mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[4].ToString(), row.ItemArray[10].ToString()); string mobile = row.ItemArray[10].ToString(); if (row.ItemArray[10].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , mobile , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , mobile , message , 'N' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } if (result == 1) { if (row.ItemArray[10].ToString() == "khong co") { count += dwDataAccess.InsertGDTangTienSMSToDW( SMS_TYPE , message , mobile // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "Y" ); } else { count += dwDataAccess.InsertGDTangTienSMSToDW( SMS_TYPE , message , mobile // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "N" ); } } else { count_err += dwDataAccess.InsertGDTangTienSMSToDW( SMS_TYPE , message , mobile // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "E" ); } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classGDTangTienLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + count); classGDTangTienLogWriter.WriteLog("Message loi khong Insert vao EbankGW: " + count_err); return; }
private static void Insert_SMSMessage(DataTable table) { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); string message = ""; int result = 0; int succ_eb = 0; int err_eb = 0; int succ_dw = 0; int err_dw = 0; //OracleCommand cmd = ebankDataAccess.AddProcedureParameterToEBankGW(); l foreach (DataRow row in table.Rows) { result = 0; //message = CreateSMSMessage(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), // row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), // row.ItemArray[8].ToString(), row.ItemArray[9].ToString(), // row.ItemArray[16].ToString(), row.ItemArray[17].ToString() // ,row.ItemArray[19].ToString() // ); message = CreateSMSMessage_160(row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), row.ItemArray[8].ToString(), row.ItemArray[9].ToString(), row.ItemArray[16].ToString(), row.ItemArray[17].ToString() , row.ItemArray[19].ToString() ); if (string.IsNullOrEmpty(message) == false) { if (row.ItemArray[18].ToString().Trim() == "")//giao dich cua the chinh, phone the phu se khong co { //string mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[15].ToString(), row.ItemArray[10].ToString()); if (row.ItemArray[10].ToString() == "khong co") { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW( SMS_TYPE , message , row.ItemArray[10].ToString() , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "Y" ); if (flag_fpt == 0) { classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , row.ItemArray[10].ToString() , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); if (result == 0) { err_eb++; classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB EB"); } else { succ_eb++; } } } else // so phone hop le { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW( SMS_TYPE , message , row.ItemArray[10].ToString() , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "N" //hhhh ); if (flag_fpt == 0) { classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , row.ItemArray[10].ToString() , message , 'N' //hhhh Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); if (result == 0) { dwDataAccess.Update_Status_SMS(//update status sms ve loi ko gui qua EW row.ItemArray[15].ToString(), row.ItemArray[5].ToString(), row.ItemArray[11].ToString(), "E" ); classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB EB"); err_eb++; } else { succ_eb++; } } } } else // giao dich the phu { string mobile = classUtilities.GetMobileFromCardNoOfSpecialList2(row.ItemArray[15].ToString()); if (mobile == "000") //the phu khong thuoc ds dac biet { if (row.ItemArray[18].ToString() == "khong co") //phone the phu { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW( SMS_TYPE , message , row.ItemArray[18].ToString() , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "Y" ); if (flag_fpt == 0) { classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , row.ItemArray[18].ToString() , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); if (result == 0) { err_eb++; classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB EB"); } else { succ_eb++; } } } else // so phone hop le { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW( SMS_TYPE , message , row.ItemArray[18].ToString() , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "N" //hhhh ); if (flag_fpt == 0) { classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , row.ItemArray[18].ToString() , message , 'N' //hhhh Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); if (result == 0) { dwDataAccess.Update_Status_SMS(//update status sms ve loi ko gui qua EW row.ItemArray[15].ToString(), row.ItemArray[5].ToString(), row.ItemArray[11].ToString(), "E" ); classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB EB"); err_eb++; } else { succ_eb++; } } } if (row.ItemArray[10].ToString() == "khong co") //phone the chinh { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW( SMS_TYPE , message , row.ItemArray[10].ToString() , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "Y" ); if (flag_fpt == 0) { classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[18].ToString() , row.ItemArray[10].ToString() , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); if (result == 0) { err_eb++; classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB EB"); } else { succ_eb++; } } } else // so phone hop le { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW( SMS_TYPE , message , row.ItemArray[10].ToString() , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "N" //hhhh ); if (flag_fpt == 0) { classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , row.ItemArray[10].ToString() , message , 'N' //hhhh Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); if (result == 0) { dwDataAccess.Update_Status_SMS(//update status sms ve loi ko gui qua EW row.ItemArray[15].ToString(), row.ItemArray[5].ToString(), row.ItemArray[11].ToString(), "E" ); classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB EB"); err_eb++; } else { succ_eb++; } } } } else // the phu thuoc ds dac biet { if (row.ItemArray[10].ToString() == "khong co") { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW( SMS_TYPE , message , mobile // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "Y" ); if (flag_fpt == 0) { classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , mobile , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); if (result == 0) { err_eb++; classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB EB"); } else { succ_eb++; } } } else // so phone hop le { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW( SMS_TYPE , message , mobile // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[4].ToString() , row.ItemArray[15].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() , row.ItemArray[1].ToString() , "N" //hhhh ); if (flag_fpt == 0) { classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[14].ToString() , mobile , message , 'N' //hhhh Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); if (result == 0) { dwDataAccess.Update_Status_SMS(//update status sms ve loi ko gui qua EW row.ItemArray[15].ToString(), row.ItemArray[5].ToString(), row.ItemArray[11].ToString(), "E" ); classDKIPPLogWriter.WriteLog("err: card no " + row.ItemArray[15].ToString() + " can't insert DB EB"); err_eb++; } else { succ_eb++; } } } } } // } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classDKIPPLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + succ_eb); classDKIPPLogWriter.WriteLog("Message loi khong Insert vao EbankGW: " + err_eb); classDKIPPLogWriter.WriteLog("Message da duoc Insert vao DW thanh cong: " + succ_dw); classDKIPPLogWriter.WriteLog("Message loi khong Insert vao DW: " + err_dw); return; }
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; }
private static void Insert_SMSMessage(DataTable table) { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW");//hhhh dwDataAccess.OpenConnection("CW_DW"); string message = ""; int result = 0; int succ_eb = 0; int err_eb = 0; int succ_dw = 0; int err_dw = 0; //OracleCommand cmd = ebankDataAccess.AddProcedureParameterToEBankGW(); l foreach (DataRow row in table.Rows) { result = 0; message = CreateSMSMessage(row.ItemArray[2].ToString(), row.ItemArray[3].ToString(), row.ItemArray[4].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[10].ToString(), row.ItemArray[11].ToString(), row.ItemArray[12].ToString(), row.ItemArray[13].ToString()); if (string.IsNullOrEmpty(message) == false) { //string mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[15].ToString(), row.ItemArray[10].ToString()); if (row.ItemArray[10].ToString() == "khong co") { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW(SMS_TYPE, message, row.ItemArray[7].ToString(), DateTime.Parse(row.ItemArray[0].ToString()), row.ItemArray[9].ToString() , row.ItemArray[2].ToString(), "", row.ItemArray[4].ToString(), row.ItemArray[5].ToString() , double.Parse(row.ItemArray[6].ToString()), "", "", "", "", row.ItemArray[1].ToString(), "Y"); if (flag_fpt == 0) { classCapPhepGDLogWriter.WriteLog("err: card no " + row.ItemArray[9].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(row.ItemArray[8].ToString(), row.ItemArray[7].ToString(), message, 'Y' , SMS_TYPE); if (result == 0) { err_eb++; classCapPhepGDLogWriter.WriteLog("err: card no " + row.ItemArray[9].ToString() + " can't insert DB EB"); } else { succ_eb++; } } } else // so phone hop le { int flag_fpt = dwDataAccess.InsertGD_SMS_ToDW(SMS_TYPE, message, row.ItemArray[7].ToString(), DateTime.Parse(row.ItemArray[0].ToString()), row.ItemArray[9].ToString() , row.ItemArray[2].ToString(), "", row.ItemArray[4].ToString(), row.ItemArray[5].ToString() , double.Parse(row.ItemArray[6].ToString()), "", "", "", "", row.ItemArray[1].ToString(), "N"); if (flag_fpt == 0) { classCapPhepGDLogWriter.WriteLog("err: card no " + row.ItemArray[9].ToString() + " can't insert DB DW"); err_dw++; } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(row.ItemArray[8].ToString(), row.ItemArray[7].ToString(), message, 'N' , SMS_TYPE); if (result == 0) { dwDataAccess.Update_Status_SMS_CPGD( //update status sms ve loi ko gui qua EW row.ItemArray[9].ToString(), row.ItemArray[4].ToString(), row.ItemArray[1].ToString(), "E" ); classCapPhepGDLogWriter.WriteLog("err: card no " + row.ItemArray[9].ToString() + " can't insert DB EB"); err_eb++; } else { succ_eb++; } } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classCapPhepGDLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + succ_eb); classCapPhepGDLogWriter.WriteLog("Message loi khong Insert vao EbankGW: " + err_eb); classCapPhepGDLogWriter.WriteLog("Message da duoc Insert vao DW thanh cong: " + succ_dw); classCapPhepGDLogWriter.WriteLog("Message loi khong Insert vao DW: " + err_dw); return; }
private static void Insert_SMSMessage(DataTable table) { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); string message = ""; int result = 0; int count = 0; //OracleCommand cmd = ebankDataAccess.AddProcedureParameterToEBankGW(); foreach (DataRow row in table.Rows) { result = 0; message = CreateSMSMessage(row.ItemArray[5].ToString(), row.ItemArray[0].ToString() , row.ItemArray[1].ToString(), row.ItemArray[2].ToString()); if (string.IsNullOrEmpty(message) == false) { if (row.ItemArray[3].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , row.ItemArray[3].ToString() //classDataAccess.MYPHONE , message , 'Y' //Sent (se ko gui tin nhan) , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , row.ItemArray[3].ToString() //classDataAccess.MYPHONE , message , 'N' //Sent (se ko gui tin nhan) , SMS_TYPE); } if (result == 1) { if (row.ItemArray[3].ToString() == "khong co") { count += dwDataAccess.InsertRewardPointToDW(SMS_TYPE, message , row.ItemArray[3].ToString()// ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[6].ToString()) , row.ItemArray[0].ToString() , row.ItemArray[5].ToString() , row.ItemArray[4].ToString() , row.ItemArray[2].ToString()// , long.Parse(row.ItemArray[5].ToString()) , row.ItemArray[1].ToString() , "Y" ); } else { count += dwDataAccess.InsertRewardPointToDW(SMS_TYPE, message , row.ItemArray[3].ToString()// ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[6].ToString()) , row.ItemArray[0].ToString() , row.ItemArray[5].ToString() , row.ItemArray[4].ToString() , row.ItemArray[2].ToString()// , long.Parse(row.ItemArray[5].ToString()) , row.ItemArray[1].ToString() , "N" ); } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classAccumulativeRewardPointLogWriter.WriteLog("So luong message da duoc Insert vao EbankGW thanh cong: " + count); return; }
private static void Insert_SMSMessage(DataTable table) { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); string message = ""; int count_succ = 0; int count_err_dw = 0; int count_err_eb = 0; string mobile = classUtilities.GetStringValueFromConfig("MyPhone1"); string mobile2 = classUtilities.GetStringValueFromConfig("MyPhone2"); string mobile3 = classUtilities.GetStringValueFromConfig("MyPhone3"); //string mobile4 = classUtilities.GetStringValueFromConfig("MyPhone4"); string mobile7 = classUtilities.GetStringValueFromConfig("MyPhone7"); foreach (DataRow row in table.Rows) { string available = ""; if (double.Parse(row.ItemArray[12].ToString()) < double.Parse(row.ItemArray[13].ToString())) { available = row.ItemArray[12].ToString(); } else { available = row.ItemArray[13].ToString(); } message = CreateSMSMessage(row.ItemArray[4].ToString(), row.ItemArray[2].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), available, row.ItemArray[15].ToString(), row.ItemArray[16].ToString()); if (string.IsNullOrEmpty(message) == false) { int flag_fpt = 0; int flag_eb = 0; string phone = ""; if (row.ItemArray[17].ToString() != "") // la the phu(crn the phu khac null) { if (row.ItemArray[18].ToString() == "1") //the phu co gui sms cho the chinh { phone = row.ItemArray[1].ToString(); //gui cho the chinh } else { phone = row.ItemArray[19].ToString();//gui cho the phu } } else { phone = row.ItemArray[1].ToString(); } //if (row.ItemArray[1].ToString() == "khong co") if (phone == "khong co" || phone == "") { flag_fpt = dwDataAccess.InsertPaymnetManualSMSToDW(SMS_TYPE, message , row.ItemArray[1].ToString() // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[2].ToString() , row.ItemArray[11].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()) , row.ItemArray[21].ToString() // , long.Parse(row.ItemArray[7].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , int.Parse(row.ItemArray[8].ToString()) , row.ItemArray[9].ToString() , "Y" , row.ItemArray[14].ToString() , row.ItemArray[22].ToString() , row.ItemArray[23].ToString() , row.ItemArray[24].ToString() , row.ItemArray[20].ToString() , row.ItemArray[13].ToString() , row.ItemArray[12].ToString() ); } else // so phone hop le { flag_fpt = dwDataAccess.InsertPaymnetManualSMSToDW(SMS_TYPE, message , phone , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[2].ToString() , row.ItemArray[11].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()) , row.ItemArray[21].ToString() // , long.Parse(row.ItemArray[7].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , int.Parse(row.ItemArray[8].ToString()) , row.ItemArray[9].ToString() , "N" , row.ItemArray[14].ToString() , row.ItemArray[22].ToString() , row.ItemArray[23].ToString() , row.ItemArray[24].ToString() , row.ItemArray[20].ToString() , row.ItemArray[13].ToString() , row.ItemArray[12].ToString() ); } if (flag_fpt == 0) { classOutstandingBalancePaymentManualLogWriter.WriteLog("card no " + row.ItemArray[11].ToString() + " can't insert DB DW"); count_err_dw++; } else// insert DW thanh cong { //if (row.ItemArray[1].ToString() == "khong co") if (phone == "khong co" || phone == "") { flag_eb = ebankDataAccess.InsertSMSMessateToEBankGW(//classDataAccess.IDALERT row.ItemArray[10].ToString() , phone , message , 'Y' //Y: se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); } else { flag_eb = ebankDataAccess.InsertSMSMessateToEBankGW(//classDataAccess.IDALERT row.ItemArray[10].ToString() , phone , message , 'N' //hhhh Y: se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); } if (flag_eb == 0) { classOutstandingBalancePaymentManualLogWriter.WriteLog("mobile no " + row.ItemArray[1].ToString() + " can't insert DB EB"); dwDataAccess.Update_Status_SMS(//update status sms ve loi ko gui qua EW row.ItemArray[11].ToString(), row.ItemArray[5].ToString(), row.ItemArray[14].ToString(), "E" ); count_err_eb++; } else { count_succ++; } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); if (count_err_dw > 0) { SendSMSForDW_FPT(mobile, count_err_dw); SendSMSForDW_FPT(mobile2, count_err_dw); SendSMSForDW_FPT(mobile3, count_err_dw); //SendSMSForDW_FPT(mobile4, count_err_dw); SendSMSForDW_FPT(mobile7, count_err_dw); } if (count_err_eb > 0) { SendSMSForGW_EB(mobile, count_err_eb); SendSMSForGW_EB(mobile2, count_err_eb); SendSMSForGW_EB(mobile3, count_err_eb); //SendSMSForGW_EB(mobile4, count_err_eb); SendSMSForGW_EB(mobile7, count_err_eb); } classOutstandingBalancePaymentManualLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + count_succ); classOutstandingBalancePaymentManualLogWriter.WriteLog("Message loi khong duoc Insert vao EbankGW: " + count_err_eb); classOutstandingBalancePaymentManualLogWriter.WriteLog("Message loi khong duoc Insert vao DW: " + count_err_dw); return; }
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()); } }
private static void Insert_SMSMessage(DataTable table) { 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(), row.ItemArray[11].ToString(), row.ItemArray[12].ToString() , row.ItemArray[13].ToString()); if (string.IsNullOrEmpty(message) == false) { //mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[2].ToString(), row.ItemArray[1].ToString()); if (row.ItemArray[1].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(classDataAccess.IDALERT , row.ItemArray[1].ToString() // classDataAccess.MYPHONE , message , 'Y' //Sent (Y se ko gui tin nhan) , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(classDataAccess.IDALERT , row.ItemArray[1].ToString() // classDataAccess.MYPHONE , message , 'N' //hhhh Sent (N se gui tin nhan, Y se ko gui tin nhan) , SMS_TYPE); } if (result == 1) { if (row.ItemArray[1].ToString() == "khong co") { count += dwDataAccess.InsertReminderPayment_2SMSToDW(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()) , 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_2SMSToDW(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()) , row.ItemArray[7].ToString() // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "N" //hhhh (N se gui tin nhan, Y se ko gui tin nhan) ); } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classReminderPayment2LogWriter.WriteLog("So luong message da duoc Insert vao EbankGW thanh cong: " + count); return; }
private static void Insert_SMSMessage(DataTable table) { 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()); if (string.IsNullOrEmpty(message) == false) { if (row.ItemArray[1].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , row.ItemArray[1].ToString() //classDataAccess.MYPHONE , message , 'Y' //Sent (se ko gui tin nhan) , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW(classDataAccess.IDALERT , row.ItemArray[1].ToString() //classDataAccess.MYPHONE , message , 'N' //Sent (se ko gui tin nhan) , SMS_TYPE); } if (result == 1) { if (row.ItemArray[1].ToString() == "khong co") { count += dwDataAccess.InsertPaymnetAutoSMSToDW(SMS_TYPE, message , row.ItemArray[1].ToString()// ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) , row.ItemArray[2].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()) , row.ItemArray[8].ToString() // , long.Parse(row.ItemArray[7].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , int.Parse(row.ItemArray[8].ToString()) , row.ItemArray[9].ToString() , "Y" ); } else { count += dwDataAccess.InsertPaymnetAutoSMSToDW(SMS_TYPE, message , row.ItemArray[1].ToString()// ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) , row.ItemArray[2].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()) , row.ItemArray[8].ToString() // , long.Parse(row.ItemArray[7].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , int.Parse(row.ItemArray[8].ToString()) , row.ItemArray[9].ToString() , "N" ); } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classOutstandingBalancePaymentAutoLogWriter.WriteLog("So luong message da duoc Insert vao EbankGW thanh cong: " + count); return; }
private static void Insert_SMSMessage(DataTable table) { classDataAccess ebankDataAccess = new classDataAccess(); classDataAccess dwDataAccess = new classDataAccess(); ebankDataAccess.OpenConnection("EBANK_GW"); dwDataAccess.OpenConnection("CW_DW"); string message = ""; int count_succ = 0; int count_err_dw = 0; int count_err_eb = 0; string mobile = classUtilities.GetStringValueFromConfig("MyPhone1"); string mobile2 = classUtilities.GetStringValueFromConfig("MyPhone2"); string mobile3 = classUtilities.GetStringValueFromConfig("MyPhone3"); string mobile4 = classUtilities.GetStringValueFromConfig("MyPhone4"); string mobile7 = classUtilities.GetStringValueFromConfig("MyPhone7"); foreach (DataRow row in table.Rows) { string available = ""; if (double.Parse(row.ItemArray[12].ToString()) < double.Parse(row.ItemArray[13].ToString())) { available = row.ItemArray[12].ToString(); } else { available = row.ItemArray[13].ToString(); } if (row.ItemArray[15].ToString() == "ThanhToan")//hhhh //message = CreateSMSMessageThuNo(row.ItemArray[4].ToString(), row.ItemArray[2].ToString(), row.ItemArray[5].ToString(), // row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), available, row.ItemArray[17].ToString(), row.ItemArray[14].ToString(), row.ItemArray[19].ToString()); { message = CreateSMSMessageThuNo_160(row.ItemArray[4].ToString(), row.ItemArray[2].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[7].ToString(), available, row.ItemArray[17].ToString(), row.ItemArray[14].ToString(), row.ItemArray[19].ToString()); } else { message = CreateSMSMessageTatToan(row.ItemArray[4].ToString(), row.ItemArray[2].ToString(), row.ItemArray[5].ToString(), row.ItemArray[6].ToString(), row.ItemArray[18].ToString(), available, row.ItemArray[17].ToString(), row.ItemArray[14].ToString(), row.ItemArray[19].ToString()); } if (string.IsNullOrEmpty(message) == false) { int flag_fpt = 0; int flag_eb = 0; if (row.ItemArray[1].ToString() == "khong co") { flag_fpt = dwDataAccess.InsertThuNoTatToanIPPSMSToDW(SMS_TYPE, message , row.ItemArray[1].ToString() // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[2].ToString() , row.ItemArray[11].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()) , row.ItemArray[8].ToString() // , long.Parse(row.ItemArray[7].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , int.Parse(row.ItemArray[8].ToString()) , row.ItemArray[9].ToString() , "Y" , row.ItemArray[16].ToString() ); } else { flag_fpt = dwDataAccess.InsertThuNoTatToanIPPSMSToDW(SMS_TYPE, message , row.ItemArray[1].ToString() // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Parse(row.ItemArray[0].ToString()) //, row.ItemArray[2].ToString() , row.ItemArray[11].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()) , row.ItemArray[8].ToString() // , long.Parse(row.ItemArray[7].ToString()) , double.Parse(row.ItemArray[7].ToString()) // , int.Parse(row.ItemArray[8].ToString()) , row.ItemArray[9].ToString() , "N" , row.ItemArray[16].ToString() ); } if (flag_fpt == 0) { classThuNoTatToanIPPLogWriter.WriteLog("card no " + row.ItemArray[11].ToString() + " can't insert DB DW"); count_err_dw++; } else { //mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[2].ToString(), row.ItemArray[1].ToString()); if (row.ItemArray[1].ToString() == "khong co") { flag_eb = ebankDataAccess.InsertSMSMessateToEBankGW( //classDataAccess.IDALERT row.ItemArray[10].ToString() , row.ItemArray[1].ToString() //classUtilities.GetRandomMobile() , message , 'Y' //Y: se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); } else { string mobile_spe = classUtilities.GetMobileFromCardNoOfSpecialList2(row.ItemArray[11].ToString()); if (mobile_spe == "000") // the phu khong thuoc ds dac biet { flag_eb = ebankDataAccess.InsertSMSMessateToEBankGW( //classDataAccess.IDALERT row.ItemArray[10].ToString() , row.ItemArray[1].ToString() //classUtilities.GetRandomMobile() , message , 'N' //Y: se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); } else //the phu thuoc ds dac biet { flag_eb = ebankDataAccess.InsertSMSMessateToEBankGW(//classDataAccess.IDALERT row.ItemArray[10].ToString() , mobile_spe , message , 'N' //Y: se ko gui tin nhan),//N: se gui tin nhan , SMS_TYPE); } } if (flag_eb == 0) { classThuNoTatToanIPPLogWriter.WriteLog("mobi no " + row.ItemArray[1].ToString() + " can't insert DB EB"); classThuNoTatToanIPPLogWriter.WriteLog("card no " + row.ItemArray[11].ToString() + " can't insert DB EB"); dwDataAccess.Update_Status_SMS(//update status sms ve loi ko gui qua EW row.ItemArray[11].ToString(), row.ItemArray[5].ToString(), row.ItemArray[16].ToString(), "E" ); count_err_eb++; } else { count_succ++; } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); if (count_err_dw > 0) { SendSMSForDW_FPT(mobile, count_err_dw); SendSMSForDW_FPT(mobile2, count_err_dw); SendSMSForDW_FPT(mobile3, count_err_dw); SendSMSForDW_FPT(mobile4, count_err_dw); SendSMSForDW_FPT(mobile7, count_err_dw); } if (count_err_eb > 0) { SendSMSForGW_EB(mobile, count_err_eb); SendSMSForGW_EB(mobile2, count_err_eb); SendSMSForGW_EB(mobile3, count_err_eb); SendSMSForGW_EB(mobile4, count_err_eb); SendSMSForGW_EB(mobile7, count_err_eb); } classThuNoTatToanIPPLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + count_succ); classThuNoTatToanIPPLogWriter.WriteLog("Message loi khong duoc Insert vao EbankGW: " + count_err_eb); classThuNoTatToanIPPLogWriter.WriteLog("Message loi khong duoc Insert vao DW: " + count_err_dw); return; }
private static void Insert_SMSMessage(DataTable table) { 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 count_err = 0; //OracleCommand cmd = ebankDataAccess.AddProcedureParameterToEBankGW(); l foreach (DataRow row in table.Rows) { result = 0; message = CreateSMSMessage(row.ItemArray[5].ToString(), row.ItemArray[1].ToString(), row.ItemArray[3].ToString(), row.ItemArray[2].ToString(), row.ItemArray[4].ToString(), row.ItemArray[11].ToString(), row.ItemArray[12].ToString()); if (string.IsNullOrEmpty(message) == false) { //string mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[10].ToString(), row.ItemArray[7].ToString()); string count_act = _dataAccess.Get_First_Activate(row.ItemArray[10].ToString()); string count_rep = _dataAccess.Get_Reply_Card(row.ItemArray[10].ToString()); if (count_act == "1" && count_rep == "0" && row.ItemArray[13].ToString() == row.ItemArray[3].ToString())//count_rep=0: the chua thay the, count_act=1: active lan dau, ngay active=ngay thu phi { classAnnual_FeeLogWriter.WriteLog("khong gui sms cho lan thu phi dau: card=" + row.ItemArray[10].ToString()); } else { if (row.ItemArray[7].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[9].ToString() //, mobile , row.ItemArray[7].ToString() , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2(//classDataAccess.IDALERT row.ItemArray[9].ToString() //, mobile , row.ItemArray[7].ToString() , message , 'N' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } if (result == 1) { if (row.ItemArray[10].ToString() == "khong co") { count += dwDataAccess.InsertAnnualFeeSMSToDW( SMS_TYPE , message //, mobile// ,long.Parse(row.ItemArray[10].ToString()) , row.ItemArray[7].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()) , double.Parse(row.ItemArray[4].ToString()) // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "Y" ); } else { count += dwDataAccess.InsertAnnualFeeSMSToDW( SMS_TYPE , message //, mobile// ,long.Parse(row.ItemArray[10].ToString()) , row.ItemArray[7].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()) , double.Parse(row.ItemArray[4].ToString()) // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "N" ); } } else { count_err += dwDataAccess.InsertAnnualFeeSMSToDW( SMS_TYPE , message //, mobile// ,long.Parse(row.ItemArray[10].ToString()) , row.ItemArray[7].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()) , double.Parse(row.ItemArray[4].ToString()) // , long.Parse(row.ItemArray[7].ToString()) , row.ItemArray[8].ToString() // , int.Parse(row.ItemArray[8].ToString()) , "E" ); } } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classAnnual_FeeLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + count); classAnnual_FeeLogWriter.WriteLog("Message loi khong Insert vao EbankGW: " + count_err); return; }
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); }
private static void Insert_SMSMessage(DataTable table, string month) { 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 count_err = 0; //string expiredDate_P = DateTime.Today.Month.ToString()+"/"+DateTime.Today.Year.ToString(); foreach (DataRow row in table.Rows) { result = 0; message = CreateSMSMessage(row.ItemArray[4].ToString(), row.ItemArray[0].ToString(), row.ItemArray[1].ToString(), month); if (string.IsNullOrEmpty(message) == false) { string mobile = classUtilities.GetMobileFromCardNoOfSpecialList(row.ItemArray[0].ToString(), row.ItemArray[2].ToString()); if (row.ItemArray[2].ToString() == "khong co") { result = ebankDataAccess.InsertSMSMessateToEBankGW_2( //classDataAccess.IDALERT row.ItemArray[7].ToString() , mobile //row.ItemArray[2].ToString() //classDataAccess.MYPHONE , message , 'Y' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } else { result = ebankDataAccess.InsertSMSMessateToEBankGW_2( //classDataAccess.IDALERT row.ItemArray[7].ToString() , mobile //row.ItemArray[2].ToString() //classDataAccess.MYPHONE , message , 'N' //Y se ko gui tin nhan, N se gui tin nhan , SMS_TYPE); } if (result == 1) { if (row.ItemArray[2].ToString() == "khong co") { count += dwDataAccess.InsertThuNoFailToDW(SMS_TYPE, message , row.ItemArray[2].ToString() // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Now //, row.ItemArray[0].ToString() , row.ItemArray[8].ToString() , row.ItemArray[4].ToString() , row.ItemArray[3].ToString() , row.ItemArray[1].ToString() , "Y" , row.ItemArray[9].ToString() ); } else { count += dwDataAccess.InsertThuNoFailToDW(SMS_TYPE, message , row.ItemArray[2].ToString() // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Now //, row.ItemArray[0].ToString() , row.ItemArray[8].ToString() , row.ItemArray[4].ToString() , row.ItemArray[3].ToString() , row.ItemArray[1].ToString() , "N" , row.ItemArray[9].ToString() ); } } else { count_err += dwDataAccess.InsertThuNoFailToDW(SMS_TYPE, message , row.ItemArray[2].ToString() // ,long.Parse(row.ItemArray[10].ToString()) , DateTime.Now //, row.ItemArray[0].ToString() , row.ItemArray[8].ToString() , row.ItemArray[4].ToString() , row.ItemArray[3].ToString() , row.ItemArray[1].ToString() , "E" , row.ItemArray[9].ToString() ); } } } ebankDataAccess.CloseConnection(); dwDataAccess.CloseConnection(); classThuNoFailLogWriter.WriteLog("Message da duoc Insert vao EbankGW thanh cong: " + count); classThuNoFailLogWriter.WriteLog("Message loi khong Insert vao EbankGW: " + count_err); return; }
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; }