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