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