private void EnQueue(DataTable tbl)
{
int step = 1;
if (tbl != null && tbl.Rows.Count > 0 && MSMProccess.MT_PROC_QUE.Count < 100)
{
_logger.Info(string.Format("MT_PROC_QUE count: {0}", MSMProccess.MT_PROC_QUE.Count));
_logger.Info(string.Format("******step: {0} at {1}", step++, DateTime.Now));
_logger.Info(string.Format("******Number of User: {0}", tbl.Rows.Count));
//Get list of MT id
string lstId = "0";
for (int i = 0; i < tbl.Rows.Count; i++)
{
lstId += "," + Convert.ToString(tbl.Rows[i]["ID"]);
}
SMS_MTDB_SQL.MTUpdateByListId(lstId);
foreach (DataRow row in tbl.Rows)
{
try
{
ViSport_S2_Registered_UsersInfo info = initInfo(row);
MSMProccess.MT_PROC_QUE.Enqueue(info);
}
catch (Exception ex)
{
_logger.Error(string.Format("error! {0}", ex.Message + " -- " + ex.StackTrace) + Environment.NewLine);
}
}
}
}
public void AddSMSToQueThread()
{
int LoopTimeInMiliSecound = SMS.Default.ProccessTimeLoop;
while (isRun)
{
isRun = false;
if (MSMProccess.MT_PROC_QUE.Count < 100)
{
DataTable tbl = SMS_MTDB_SQL.GetMTByStatus(false);
EnQueue(tbl);
}
isRun = true;
Thread.Sleep(LoopTimeInMiliSecound); //1000 * 60 * 60 = 1h
}
}
public static void ChargeUser(ViSport_S2_Registered_UsersInfo info)
{
int reval = -1;
try
{
_logger.Info(string.Format("Started charging User_ID= {0}, Request_ID = {1}, ID = {2}", info.User_ID, info.Request_ID, info.ID.ToString()));
if (info == null)
{
return;
}
#region charging here
string userName = SMS.Default.UserName;
string userPass = SMS.Default.Password;
string cpId = SMS.Default.CpID;
string price = SMS.Default.PriceSC;
string serviceType = "Charge goi Vote ";
string serviceName = "Vote";
//if (info.Service_Type == 1)
//{
price = SMS.Default.PriceSM;
// serviceType += "SM";
//}
//else
//{
// serviceType += "SC";
//}
//string status = "1";
string returnValue;
if (SMS.Default.IsTest == "1")
{
returnValue = "1";
}
else
{
if (info.FailedChargingTimes < ConvertUtility.ToInt32(SMS.Default.FailCharge))
{
price = "5000";
returnValue = objCharge.PaymentVnmWithAccount(info.User_ID, price, serviceType, serviceName, userName, userPass, cpId);
if (returnValue.Trim() == "Result:12,Detail:Not enough money.")
{
price = "3000";
returnValue = objCharge.PaymentVnmWithAccount(info.User_ID, price, serviceType, serviceName, userName, userPass, cpId);
if (returnValue.Trim() == "Result:12,Detail:Not enough money.")
{
price = "2000";
returnValue = objCharge.PaymentVnmWithAccount(info.User_ID, price, serviceType, serviceName, userName, userPass, cpId);
if (returnValue.Trim() == "Result:12,Detail:Not enough money.")
{
price = "1000";
returnValue = objCharge.PaymentVnmWithAccount(info.User_ID, price, serviceType, serviceName, userName, userPass, cpId);
}
}
}
}
else
{
returnValue = "Exceed";
reval = -1;
}
}
if (returnValue == "1")
{
reval = 1;
}
#endregion
#region Ghi log vao bang ViSport_S2_Charged_Users_Log
ViSport_S2_Charged_Users_LogInfo logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = info.ID;
logInfo.User_ID = info.User_ID;
logInfo.Request_ID = info.Request_ID;
logInfo.Service_ID = info.Service_ID;
logInfo.Command_Code = info.Command_Code;
logInfo.Service_Type = 0;//Charged Sub Service_Type
logInfo.Charging_Count = info.Charging_Count;
logInfo.FailedChargingTimes = info.FailedChargingTimes;
logInfo.RegisteredTime = DateTime.Now;
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = info.Registration_Channel;
logInfo.Status = info.Status;
logInfo.Operator = info.Operator;
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Vote_PersonId = info.Vote_PersonId;
int sentMt = 0;
if (reval > 0)
{
#region Charged THANH CONG
//neu charge tien thanh cong thi tu dong gia han expiretime cho user them 7 ngay, dong thoi insert vao bang log charging, cong Charging_Count len 1, islock = 0 de lan sau charge tiep
_logger.Info(string.Format("Succ!Charging to {0} is succ with return value {1}, Request_ID = {2}", info.User_ID, reval, info.Request_ID));
logInfo.Reason = "Succ";
string messageContent = "";
//DataTable dt = SMS_MTDB_SQL.GetVoteAccountInfo(info.User_ID, info.Command_Code.ToUpper());
if (info.isDislike == 0)
{
SMS_MTDB_SQL.InsertLogLike(logInfo);
DataTable dt = SMS_MTDB_SQL.GetVoteAccountInfo(info.User_ID, info.Command_Code.ToUpper());
messageContent =
"So luot vote cua ban: " + dt.Rows[0]["Count"] + ". Ban dang thuoc top: " + dt.Rows[0]["Top"] + " nhung nguoi Vote nhieu nhat cho " + dt.Rows[0]["Name"] + ". Vote cang nhieu ban cang co co hoi la 1 trong 4 nguoi hen ho than tuong. Soan: Vote1 gui 8279 de gap go Mai Tho. Soan:Vote2 gui 8279 de gap go Linh Miu .Chi tiet truy cap: http://wap.vietnamobile.com.vn. HT: 19001255";
}
else
{
if (info.Vote_PersonId == 1)
{
logInfo.Vote_PersonId = 2;
}
else if (info.Vote_PersonId == 2)
{
logInfo.Vote_PersonId = 1;
}
SMS_MTDB_SQL.InsertLogDisLike(logInfo);
DataTable dt = SMS_MTDB_SQL.GetVoteAccountInfo(info.User_ID, info.Command_Code.ToUpper());
messageContent = "So Gach ban nem " + dt.Rows[0]["Name"] + ": " + dt.Rows[0]["Count"] + ". Ban dang thuoc top: " + dt.Rows[0]["Top"] + " nhung nguoi Nem Gach nhieu nhat. Nem Gach cang nhieu ban cang co co hoi la 1 trong 4 nguoi hen ho than tuong. Soan: Gach1 gui 8279 de gap go Linh Miu. Soan:Gach2 gui 8279 de gap go Mai Tho .Chi tiet truy cap: http://wap.vietnamobile.com.vn. HT: 19001255";
}
if (SMS.Default.IsTest == "0")
{
#region Gui MT cho khach hang thong bao gia han thanh cong
var objSentMT = new ServiceProviderService();
string Service_ID = info.Service_ID;
string Command_Code = info.Command_Code;
string Request_ID = info.Request_ID;
sentMt = objSentMT.sendMT(logInfo.User_ID, messageContent, Service_ID, Command_Code, "1", Request_ID, "1", "1", "0", "0");
#endregion
}
_logger.Info("Gui Mt cho so : " + logInfo.User_ID + " | Ket qua Mt :" + sentMt + " | ServiceId : " + info.Service_ID + " | Noi dung Mt : " + messageContent);
#endregion
}
else
{
#region Charged THAT BAI
//neu charge tien khong thanh cong thi ghi lai log loi, dong thoi tang FailedChargingTimes len 1.IsLock set = 0 de tien hanh charge lai
_logger.Info(string.Format("ERROR !Charging to {0} is fail, Request_ID = {1}", info.User_ID, info.Request_ID));
logInfo.ExpiredTime = info.ExpiredTime;
if (returnValue == "Exceed")
{
logInfo.Reason = "Exceed";
}
else
{
logInfo.Reason = returnValue;
}
string messageContent = "";
if (info.isDislike == 0)
{
SMS_MTDB_SQL.InsertLogLike(logInfo);
DataTable dt = SMS_MTDB_SQL.GetVoteAccountInfo(info.User_ID, info.Command_Code.ToUpper());
messageContent =
"So luot vote cua ban: " + dt.Rows[0]["Count"] + ". Ban dang thuoc top: " + dt.Rows[0]["Top"] + " nhung nguoi Vote nhieu nhat cho " + dt.Rows[0]["Name"] + ". Vote cang nhieu ban cang co co hoi la 1 trong 4 nguoi hen ho than tuong. Soan: Vote1 gui 8279 de gap go Mai Tho. Soan:Vote2 gui 8279 de gap go Linh Miu. Chi tiet truy cap: http://wap.vietnamobile.com.vn. HT: 19001255";
}
else
{
//SMS_MTDB_SQL.InsertLogDisLike(logInfo);
if (info.Vote_PersonId == 1)
{
logInfo.Vote_PersonId = 2;
}
else if (info.Vote_PersonId == 2)
{
logInfo.Vote_PersonId = 1;
}
SMS_MTDB_SQL.InsertLogDisLike(logInfo);
DataTable dt = SMS_MTDB_SQL.GetVoteAccountInfo(info.User_ID, info.Command_Code.ToUpper());
messageContent = "So Gach ban nem " + dt.Rows[0]["Name"] + ": " + dt.Rows[0]["Count"] + ". Ban dang thuoc top: " + dt.Rows[0]["Top"] + " nhung nguoi Nem Gach nhieu nhat. Nem Gach cang nhieu ban cang co co hoi la 1 trong 3 nguoi hen ho than tuong. Soan: Gach1 gui 8279 de gap go Linh Miu. Soan:Gach2 gui 8279 de gap go Mai Tho Chi tiet truy cap: http://wap.vietnamobile.com.vn. HT: 19001255";
}
if (SMS.Default.IsTest == "0")
{
#region Gui MT cho khach hang thong bao gia han thanh cong
var objSentMT = new ServiceProviderService();
string Service_ID = info.Service_ID;
string Command_Code = info.Command_Code;
string Request_ID = info.Request_ID;
sentMt = objSentMT.sendMT(logInfo.User_ID, messageContent, Service_ID, Command_Code, "1", Request_ID, "1", "1", "0", "0");
#endregion
}
_logger.Info("Gui Mt cho so : " + logInfo.User_ID + " | Ket qua Mt :" + sentMt + " | ServiceId : " + info.Service_ID + " | Noi dung Mt : " + messageContent);
#endregion
}
#endregion
}
catch (TimeoutException e)
{
_logger.Error(string.Concat("mySendMT - ", e.StackTrace));
_logger.Error(string.Concat("mySendMT - ", e.Message));
MT_PROC_QUE.Enqueue(info);
}
catch (Exception ex)
{
//neu phat sinh loi he thong thi Update Islock = 0, de lan sau co the charge lai
_logger.Info(string.Format("ERROR!Sending to {0} is error, Request_ID = {1}, Error mess = {2}", info.User_ID, info.Request_ID, ex.Message) + Environment.NewLine);
SMS_MTDB_SQL.MTUpdateFail(info.ID);
}
Thread.Sleep(100);
}
public static void ChargeUser(ViSport_S2_Registered_UsersInfo info)
{
int reval = -1;
try
{
_logger.Info(string.Format("Started charging User_ID= {0}, Request_ID = {1}, ID = {2}", info.User_ID, info.Request_ID, info.ID.ToString()));
if (info == null)
{
return;
}
#region charging here
string userName = SMS.Default.UserName;
string userPass = SMS.Default.Password;
string cpId = SMS.Default.CpID;
string price = SMS.Default.PriceSC;
string serviceType = "Charge goi ";
string serviceName = "ViSport";
if (info.Service_Type == 1)
{
price = SMS.Default.PriceSM;
serviceType += "SM";
}
else
{
serviceType += "SC";
}
string status = "1";
string returnValue;
if (SMS.Default.IsTest == "1")
{
returnValue = "1";
}
else
{
if (info.FailedChargingTimes <= ConvertUtility.ToInt32(SMS.Default.FailCharge))
{
returnValue = objCharge.PaymentVnmWithAccount(info.User_ID, price, serviceType, serviceName, userName, userPass, cpId);
if (returnValue.Trim() == "Result:12,Detail:Not enough money.")
{
price = "1000";
returnValue = objCharge.PaymentVnmWithAccount(info.User_ID, price, serviceType, serviceName, userName, userPass, cpId);
status = "2";
}
}
else
{
returnValue = "Exceed";
reval = -1;
}
}
if (returnValue == "1")
{
reval = 1;
}
#endregion
#region Ghi log vao bang ViSport_S2_Charged_Users_Log
ViSport_S2_Charged_Users_LogInfo logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = info.ID;
logInfo.User_ID = info.User_ID;
logInfo.Request_ID = info.Request_ID;
logInfo.Service_ID = info.Service_ID;
logInfo.Command_Code = info.Command_Code;
logInfo.Service_Type = info.Service_Type;
logInfo.Charging_Count = info.Charging_Count;
logInfo.FailedChargingTimes = info.FailedChargingTimes;
logInfo.RegisteredTime = DateTime.Now;
if (status == "1")
{
logInfo.ExpiredTime = info.ExpiredTime.AddDays(7);
}
else
{
logInfo.ExpiredTime = info.ExpiredTime.AddDays(3);
}
logInfo.Registration_Channel = info.Registration_Channel;
logInfo.Status = info.Status;
logInfo.Operator = info.Operator;
logInfo.Price = ConvertUtility.ToInt32(price);
if (reval > 0)
{
//neu charge tien thanh cong thi tu dong gia han expiretime cho user them 7 ngay, dong thoi insert vao bang log charging, cong Charging_Count len 1, islock = 0 de lan sau charge tiep
_logger.Info(string.Format("Succ!Charging to {0} is succ with return value {1}, Request_ID = {2}", info.User_ID, reval, info.Request_ID));
logInfo.Reason = "Succ";
SMS_MTDB_SQL.InsertLog(logInfo);
#region Gui MT cho khach hang thong bao gia han thanh cong
ServiceProviderService objSentMT = new ServiceProviderService();
string message = SMS.Default.Message;
if (info.Service_Type == 1)
{
message = SMS.Default.Message;
}
else
{
message = SMS.Default.MessageSC;
}
string Service_ID = info.Service_ID;
string Command_Code = info.Command_Code;
string Request_ID = info.Request_ID;
objSentMT.sendMT(logInfo.User_ID, message, Service_ID, Command_Code, "1", Request_ID, "1", "1", "0", "0");
#endregion
}
else
{
//neu charge tien khong thanh cong thi ghi lai log loi, dong thoi tang FailedChargingTimes len 1.IsLock set = 0 de tien hanh charge lai
_logger.Info(string.Format("ERROR !Charging to {0} is fail, Request_ID = {1}", info.User_ID, info.Request_ID));
logInfo.ExpiredTime = info.ExpiredTime;
if (returnValue == "Exceed")
{
logInfo.Reason = "Exceed";
}
else
{
logInfo.Reason = "Error charging: " + returnValue;
}
SMS_MTDB_SQL.InsertLog(logInfo);
}
#endregion
}
catch (TimeoutException e)
{
_logger.Error(string.Concat("mySendMT - ", e.StackTrace));
_logger.Error(string.Concat("mySendMT - ", e.Message));
MT_PROC_QUE.Enqueue(info);
}
catch (Exception ex)
{
//neu phat sinh loi he thong thi Update Islock = 0, de lan sau co the charge lai
_logger.Info(string.Format("ERROR!Sending to {0} is error, Request_ID = {1}, Error mess = {2}", info.User_ID, info.Request_ID, ex.Message) + Environment.NewLine);
SMS_MTDB_SQL.MTUpdateFail(info.ID);
}
Thread.Sleep(100);
}