public static void InsertLog(ViSport_S2_Charged_Users_LogInfo _viSport_S2_Charged_Users_LogInfo)
{
SqlConnection dbConn = new SqlConnection(SMS.Default.cnn);
SqlCommand dbCmd = new SqlCommand("ViSport_S2_Charged_Users_Log_Insert_New", dbConn);
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.AddWithValue("@ID", _viSport_S2_Charged_Users_LogInfo.ID);
dbCmd.Parameters.AddWithValue("@User_ID", _viSport_S2_Charged_Users_LogInfo.User_ID);
dbCmd.Parameters.AddWithValue("@Request_ID", _viSport_S2_Charged_Users_LogInfo.Request_ID);
dbCmd.Parameters.AddWithValue("@Service_ID", _viSport_S2_Charged_Users_LogInfo.Service_ID);
dbCmd.Parameters.AddWithValue("@Command_Code", _viSport_S2_Charged_Users_LogInfo.Command_Code);
dbCmd.Parameters.AddWithValue("@Service_Type", _viSport_S2_Charged_Users_LogInfo.Service_Type);
dbCmd.Parameters.AddWithValue("@Charging_Count", _viSport_S2_Charged_Users_LogInfo.Charging_Count);
dbCmd.Parameters.AddWithValue("@FailedChargingTimes", _viSport_S2_Charged_Users_LogInfo.FailedChargingTimes);
dbCmd.Parameters.AddWithValue("@RegisteredTime", _viSport_S2_Charged_Users_LogInfo.RegisteredTime);
dbCmd.Parameters.AddWithValue("@ExpiredTime", _viSport_S2_Charged_Users_LogInfo.ExpiredTime);
dbCmd.Parameters.AddWithValue("@Registration_Channel", _viSport_S2_Charged_Users_LogInfo.Registration_Channel);
dbCmd.Parameters.AddWithValue("@Status", _viSport_S2_Charged_Users_LogInfo.Status);
dbCmd.Parameters.AddWithValue("@Operator", _viSport_S2_Charged_Users_LogInfo.Operator);
dbCmd.Parameters.AddWithValue("@Reason", _viSport_S2_Charged_Users_LogInfo.Reason);
dbCmd.Parameters.AddWithValue("@Price", _viSport_S2_Charged_Users_LogInfo.Price);
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
}
finally
{
dbConn.Close();
}
}
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);
}
