private static int SendSMSForPhone_K(classDataAccess ebankDataAccess, classDataAccess dwDataAccess, DataRow row, string creditOrDebit, string mess, string phone, string flag_sms)
{
try
{
if (string.IsNullOrEmpty(mess.Trim()) == false)
{
string status = (creditOrDebit == "Giao dich:" ? " " : "C");//neu la giao dich reversal thi status = "C"
int flag_fpt = dwDataAccess.InsertOutBalChangeMDSMSToDW(SMS_TYPE, mess
, phone
, DateTime.Parse(row.ItemArray[0].ToString())
//, row.ItemArray[4].ToString()
, row.ItemArray[17].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()
, status
, row.ItemArray[1].ToString()
, flag_sms
);
if (flag_fpt == 0)
{
classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can not insert DB DW");
return(1); //intert DW khong thanh cong
}
}
return(3);//ko gui sms
}
catch (Exception ex)
{
classGDMCDebitLogWriter.WriteLog("Error SendSMSForPhone_K():" + ex.Message);
return(3);//3: loi
}
}
private static int SendSMSForPhone(classDataAccess ebankDataAccess, classDataAccess dwDataAccess, DataRow row, string creditOrDebit, string mess, string phone, string flag_send)
{
try
{
int result = 0;
if (string.IsNullOrEmpty(mess.Trim()) == false)
{
string status = (creditOrDebit == "Giao dich:" ? " " : "C");//neu la giao dich reversal thi status = "C"
//if (flag_send == "Y")
//{
if (phone == "khong co")
{
int flag_fpt = dwDataAccess.InsertOutBalChangeMDSMSToDW(SMS_TYPE, mess
, phone
, DateTime.Parse(row.ItemArray[0].ToString())
//, row.ItemArray[4].ToString()
, row.ItemArray[17].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()
, status
, row.ItemArray[1].ToString()
, "Y"//khong co so dt, tin nhan ko duoc gui di
);
if (flag_fpt == 0)
{
classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can not insert DB DW");
return(1); //intert DW khong thanh cong
}
else //inster DW thanh cong
{
result = ebankDataAccess.InsertSMSMessateToEBankGW(
//classDataAccess.IDALERT
row.ItemArray[16].ToString()
, phone
, mess
, 'Y' //Y: (se ko gui tin nhan),//N: se gui tin nhan
, SMS_TYPE);
if (result == 0)
{
classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can not insert Ebanking GW");
return(2); //2: inster EB khong thanh cong
}
else
{
return(0); //thanh cong
}
}
}
else //so phone hop le
{
int flag_fpt = dwDataAccess.InsertOutBalChangeMDSMSToDW(
SMS_TYPE
, mess
, phone
, DateTime.Parse(row.ItemArray[0].ToString())
, row.ItemArray[17].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()
, status
, row.ItemArray[1].ToString()
, "N"//normal: insert DW thanh cong
);
if (flag_fpt == 0)
{
classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can't insert DB DW");
return(1); //intert DW khong thanh cong
}
else //inster DW thanh cong
{
result = ebankDataAccess.InsertSMSMessateToEBankGW(
//classDataAccess.IDALERT
row.ItemArray[16].ToString()
, phone
, mess
, 'N' //Y: (se ko gui tin nhan),//N: se gui tin nhan
, SMS_TYPE);
if (result == 0)
{
int flag = dwDataAccess.Update_Status_SMS( //update status sms ve loi ko gui qua EW
row.ItemArray[17].ToString(),
row.ItemArray[5].ToString(),
row.ItemArray[11].ToString(),
"E"
);
classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can not insert Ebanking GW");
return(2); //2: inster EB khong thanh cong
}
else
{
return(0); //thanh cong
}
}
}
//}
//else// flag = N, khong nhan sms
//{
// int flag_fpt = dwDataAccess.InsertOutBalChangeMDSMSToDW(SMS_TYPE, mess
// , phone
// , DateTime.Parse(row.ItemArray[0].ToString())
// //, row.ItemArray[4].ToString()
// , row.ItemArray[17].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()
// , status
// , row.ItemArray[1].ToString()
// , "K"//the ko dk nhan sms
// );
// if (flag_fpt == 0)
// {
// dwDataAccess.InsertOutBalChangeMDSMSToDW(SMS_TYPE, mess
// , phone
// , DateTime.Parse(row.ItemArray[0].ToString())
// //, row.ItemArray[4].ToString()
// , row.ItemArray[17].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()
// , status
// , row.ItemArray[1].ToString()
// , "K"//insert lan 2: loi do ko insert duoc DW lan 1
// );
// classGDMCDebitLogWriter.WriteLog("card no " + row.ItemArray[17].ToString() + " can't insert DB DW");
// return 1;
// }
//}
}
return(3);//ko gui sms
}
catch (Exception ex)
{
classGDMCDebitLogWriter.WriteLog("Error SendSMSForPhone():" + ex.Message);
return(3);//3: loi
}
}
