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(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;
}