public static ViSport_S2_Registered_UsersInfo initInfo(DataRow row) { ViSport_S2_Registered_UsersInfo info = new ViSport_S2_Registered_UsersInfo(); try { info.ID = ConvertUtility.ToInt32(row["ID"]); info.User_ID = row["User_ID"].ToString().Trim(); info.Request_ID = ConvertUtility.ToString(row["Request_ID"]).Trim(); info.Service_ID = ConvertUtility.ToString(row["Service_ID"]).Trim(); info.Command_Code = ConvertUtility.ToString(row["Command_Code"]).Trim(); info.Service_Type = ConvertUtility.ToInt32(row["Service_Type"]); info.Request_ID = ConvertUtility.ToString(row["Request_ID"]).Trim(); info.Charging_Count = ConvertUtility.ToInt32(row["Charging_Count"]); info.FailedChargingTimes = Convert.ToInt32(row["FailedChargingTimes"]); info.RegisteredTime = ConvertUtility.ToDateTime(row["RegisteredTime"]); info.ExpiredTime = ConvertUtility.ToDateTime(row["ExpiredTime"]); info.Registration_Channel = ConvertUtility.ToString(row["Registration_Channel"]); info.Status = ConvertUtility.ToInt32(row["Status"]); info.Operator = ConvertUtility.ToString(row["Operator"]); info.IsLock = ConvertUtility.ToInt32(row["IsLock"]); info.Vote_PersonId = ConvertUtility.ToInt32(row["Vote_PersonId"]); info.isDislike = ConvertUtility.ToInt32(row["IsDislike"]); } catch (Exception ex) { _logger.Info(string.Format("error! init info user_id = {0}, Request_ID = {1}, Reason = {2}", row["User_ID"].ToString().Trim(), row["Request_ID"].ToString().Trim(), ex.StackTrace) + Environment.NewLine); return(null); } return(info); }
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 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); }