public int Execute(int jobID)
{
WebServiceCharging3g webServiceCharging3G = new WebServiceCharging3g();
string userName = "******";
string userPass = "******";
string cpId = "1928";
string price;
try
{
DataTable dt = ViSport_S2_Registered_UsersController.VClipGetMTByStatus(false);
if (dt != null && dt.Rows.Count > 0)
{
string message = string.Empty;
string returnValue = string.Empty;
string notEnoughMoney = "Result:12,Detail:Not enough money.";
string serviceType = "Charged Sub VClip";
string serviceName = "VClip";
string reasonLog = string.Empty;
string status = "1";
foreach (DataRow dr in dt.Rows)
{
string userId = dr["User_ID"].ToString();
price = "2000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(userId, price, serviceType, serviceName, userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "1000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(userId, price, serviceType, serviceName, userName, userPass, cpId);
}
if (returnValue == "1")//CHARGED THANH CONG
{
#region Log Doanh Thu
var logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = ConvertUtility.ToInt32(dr["Id"].ToString());
logInfo.User_ID = userId;
logInfo.Request_ID = dr["Request_ID"].ToString();
logInfo.Service_ID = dr["Service_ID"].ToString();
logInfo.Command_Code = dr["Command_Code"].ToString();
logInfo.Service_Type = ConvertUtility.ToInt32(dr["Service_Type"].ToString());
logInfo.Charging_Count = ConvertUtility.ToInt32(dr["Charging_Count"].ToString());
logInfo.FailedChargingTimes = ConvertUtility.ToInt32(dr["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = ConvertUtility.ToDateTime(dr["RegisteredTime"].ToString());
logInfo.ExpiredTime = DateTime.Now;
logInfo.Registration_Channel = dr["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(dr["Status"].ToString());
logInfo.Operator = dr["Operator"].ToString();
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Reason = "Succ";
ViSport_S2_Registered_UsersController.VClipInsertLog(logInfo);
#endregion
}
else
{
#region Log Doanh Thu
var logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = ConvertUtility.ToInt32(dr["Id"].ToString());
logInfo.User_ID = userId;
logInfo.Request_ID = dr["Request_ID"].ToString();
logInfo.Service_ID = dr["Service_ID"].ToString();
logInfo.Command_Code = dr["Command_Code"].ToString();
logInfo.Service_Type = ConvertUtility.ToInt32(dr["Service_Type"].ToString());
logInfo.Charging_Count = ConvertUtility.ToInt32(dr["Charging_Count"].ToString());
logInfo.FailedChargingTimes = ConvertUtility.ToInt32(dr["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = ConvertUtility.ToDateTime(dr["RegisteredTime"].ToString());
logInfo.ExpiredTime = DateTime.Now;
logInfo.Registration_Channel = dr["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(dr["Status"].ToString());
logInfo.Operator = dr["Operator"].ToString();
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Reason = returnValue;
ViSport_S2_Registered_UsersController.VClipInsertLog(logInfo);
#endregion
}
if (returnValue == "1")//CHARGED THANH CONG
{
#region Gui MT cho khach hang thong bao gia han thanh cong
var objSentMt = new ServiceProviderService();
const int msgType = (int)Constant.MessageType.NoCharge;
message = "(092)Quy khach da gia han thanh cong DV VMclip cua Vietnamobile. Moi ban truy cap: http://kho-clip.com/" + userId + ".aspx de xem cac video HOT cap nhat 24/24 MIEN PHI. De huy DK, soan CLIP OFF gui 949. HT 19001255";
string serviceId = dr["Service_ID"].ToString();
string commandCode = dr["Command_Code"].ToString();
string requestId = dr["Request_ID"].ToString();
int value = objSentMt.sendMT(userId, message, serviceId, commandCode, msgType.ToString(), requestId, "1", "1", "0", "0");
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = userId;
objMt.Message = message;
objMt.Service_ID = serviceId;
objMt.Command_Code = commandCode;
objMt.Message_Type = 1;
objMt.Request_ID = requestId;
objMt.Total_Message = 1;
objMt.Message_Index = 0;
objMt.IsMore = 0;
objMt.Content_Type = 0;
objMt.ServiceType = 0;
objMt.ResponseTime = DateTime.Now;
objMt.isLock = false;
objMt.PartnerID = "Xzone";
objMt.Operator = "vnmobile";
ViSport_S2_SMS_MTController.InsertVClip(objMt);
log.Info(" ");
log.Info("***** LOG SEND MT VCLIP *****");
log.Info("User_ID : " + userId);
log.Info("Message : " + message);
log.Info("Service_ID : " + serviceId);
log.Info("Command_Code : " + commandCode);
log.Info("Send_MT : " + value);
log.Info("****************************************");
log.Info(" ");
#endregion
}
}
}
}
catch (Exception ex)
{
log.Info(" ");
log.Info("***** VClip Charged Error *****");
log.Info("Error : " + ex);
log.Info(" ");
return(0);
}
return(1);
}
public int Execute(int jobID)
{
try
{
#region SEND MT REMIND
DataTable dtRemind = ViSport_S2_Registered_UsersController.ThanhNuAllUserForSendMtRemind(5);
if (dtRemind != null && dtRemind.Rows.Count > 0)
{
foreach (DataRow dr in dtRemind.Rows)
{
string userId = dr["User_Id"].ToString();
const string message = "QKhach da duoc trai nghiem dich vu gia tri gia tang trong 5 ngay. He thong se huy dich vu tu dong sau 15 ngay hoac qkhach dung dvu ngay lap tuc bang cach soan: HUY GOI gui 949";
AppEnv.SendMtVmgPortal(userId, "949", "GOI", message);
ViSport_S2_Registered_UsersController.ThanhNuCodeTempDelete(userId);
#region LOG MT Send
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = userId;
objMt.Message = message;
objMt.Service_ID = "949";
objMt.Command_Code = "GOI";
objMt.Message_Type = 1;
objMt.Request_ID = "0";
objMt.Total_Message = 1;
objMt.Message_Index = 0;
objMt.IsMore = 0;
objMt.Content_Type = 0;
objMt.ServiceType = 0;
objMt.ResponseTime = DateTime.Now;
objMt.isLock = false;
objMt.PartnerID = "VNM";
objMt.Operator = "vnmobile";
ViSport_S2_SMS_MTController.InsertThanhNuMt(objMt);
#endregion
_log.Debug(" ");
_log.Debug(" ");
_log.Debug("-------------------- BIG PROMOTION SendMt to VMG-Portal REMIND 5 DAY -------------------------");
_log.Debug("User_ID: " + userId);
_log.Debug("Message: " + message);
_log.Debug(" ");
_log.Debug(" ");
}
}
DataTable dtDel = ViSport_S2_Registered_UsersController.ThanhNuAllUserForSendMtRemind(20);
if (dtDel != null && dtDel.Rows.Count > 0)
{
foreach (DataRow dr in dtDel.Rows)
{
string userId = dr["User_Id"].ToString();
#region HUY DICH VU
_log.Debug(" ");
_log.Debug(" ");
_log.Debug("-------------------- BIG PROMOTION DELETE AFTER 15 DAY -------------------------");
_log.Debug("User_ID: " + userId);
_log.Debug(" ");
_log.Debug(" ");
//string message;
DataTable dt = ViSport_S2_Registered_UsersController.ThanhNuRegisterUserStatusUpdate(userId, 0);
if (dt.Rows[0]["RETURN_ID"].ToString() == "1")
{
//message = "Quy khach da huy thanh cong goi dich vu ( bao gom game portal, shot and print, nhac chuong). Ma du thuong cua Qkhach se khong duoc tham gia quay thuong. De dang ky lai dich vu soan GOI gui 949";
#region HUY VMGAME
var vmgame = new Service_RegisS2();
string vmRes = vmgame.BigPromotionDelete(userId, "BigPro123!@#Tqscd");
_log.Debug(" ");
_log.Debug(" ");
_log.Debug("-------------------- BIG PROMOTION VmGameResult DELETE AFTER 15 DAY -------------------------");
_log.Debug("User_ID: " + userId);
_log.Debug("vmGameResult: " + vmRes);
_log.Debug(" ");
_log.Debug(" ");
#endregion
#region HUY SHOT and PRINT
var shot = new S2Process();
string shotRes = shot.BPCancel(userId, "4", "HUY GOI 949");
_log.Debug(" ");
_log.Debug(" ");
_log.Debug("-------------------- BIG PROMOTION shotResult DELETE AFTER 15 DAY -------------------------");
_log.Debug("User_ID: " + userId);
_log.Debug("shotResult: " + shotRes);
_log.Debug(" ");
_log.Debug(" ");
#endregion
#region HUY NC1
var ringTone = new NC1_Handler();
string ringToneRest = ringTone.SyncSubscriptionData("949", "DK", userId, "DK GOI", "0", "472", "0", "0", "HUY GOI");
_log.Debug(" ");
_log.Debug(" ");
_log.Debug("-------------------- BIG PROMOTION ringToneRes DELETE AFTER 15 DAY -------------------------");
_log.Debug("User_ID: " + userId);
_log.Debug("ringToneRest: " + ringToneRest);
_log.Debug(" ");
_log.Debug(" ");
#endregion
//SendMtThanhNu(userId, message, "949", "GOI", RandomActiveCode.Generate(10));
}
#endregion
}
}
#endregion
}
catch (Exception ex)
{
_log.Error("BIG PROMOTION Loi lay tap User : " + ex);
return(0);
}
return(1);
}
public string NotifyChargingInfo(string registeredId, string userId, string requestId, string serviceId, string serviceType, string chargingValue, string chargingAccount, string chargingTime, string chargingResponse)
{
log.Info(" ");
log.Info("***** LOG VClip CHARGED NOTIFICATION From ANDY *****");
log.Info("User_ID : " + userId);
log.Info("chargingValue : " + chargingValue);
log.Info("chargingAccount : " + chargingAccount);
log.Info("chargingTime : " + chargingTime);
log.Info("chargingResponse : " + chargingResponse);
log.Info("****************************************");
log.Info(" ");
if (chargingResponse.Trim() == "1")//CHARGED THANH CONG
{
#region Log Doanh Thu
var logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = ConvertUtility.ToInt32(registeredId);
logInfo.User_ID = userId;
logInfo.Request_ID = requestId;
logInfo.Service_ID = serviceId;
logInfo.Command_Code = "CLIP";
logInfo.Service_Type = ConvertUtility.ToInt32(serviceType);
logInfo.Charging_Count = 0;
logInfo.FailedChargingTimes = 0;
logInfo.RegisteredTime = DateTime.Now;
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = "SMS";
logInfo.Status = 1;
logInfo.Operator = "vnmobile";
logInfo.Price = ConvertUtility.ToInt32(chargingValue);
logInfo.Reason = "Succ";
ViSport_S2_Registered_UsersController.VClipInsertLog(logInfo);
#endregion
}
else //CHARGED THAT BAI
{
#region Log Doanh Thu
var logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = ConvertUtility.ToInt32(registeredId);
logInfo.User_ID = userId;
logInfo.Request_ID = requestId;
logInfo.Service_ID = serviceId;
logInfo.Command_Code = "CLIP";
logInfo.Service_Type = ConvertUtility.ToInt32(serviceType);
logInfo.Charging_Count = 0;
logInfo.FailedChargingTimes = 0;
logInfo.RegisteredTime = DateTime.Now;
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = "SMS";
logInfo.Status = 1;
logInfo.Operator = "vnmobile";
logInfo.Price = ConvertUtility.ToInt32(chargingValue);
logInfo.Reason = chargingResponse;
ViSport_S2_Registered_UsersController.VClipInsertLog(logInfo);
#endregion
}
if (chargingResponse.Trim() == "1")
{
return("1");
#region Gui MT cho khach hang thong bao gia han thanh cong
var objSentMt = new ServiceProviderService();
const int msgType = (int)Constant.MessageType.NoCharge;
string message = "(092)Quy khach da gia han thanh cong DV VMclip cua Vietnamobile. Moi ban truy cap: http://kho-clip.com/" + userId + ".aspx de xem cac video HOT cap nhat 24/24 MIEN PHI. De huy DK, soan CLIP OFF gui 949. HT 19001255";
const string commandCode = "CLIP";
int value = objSentMt.sendMT(userId, message, "949", commandCode, msgType.ToString(), requestId, "1", "1", "0", "0");
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = userId;
objMt.Message = message;
objMt.Service_ID = serviceId;
objMt.Command_Code = commandCode;
objMt.Message_Type = 1;
objMt.Request_ID = requestId;
objMt.Total_Message = 1;
objMt.Message_Index = 0;
objMt.IsMore = 0;
objMt.Content_Type = 0;
objMt.ServiceType = 0;
objMt.ResponseTime = DateTime.Now;
objMt.isLock = false;
objMt.PartnerID = "Xzone";
objMt.Operator = "vnmobile";
ViSport_S2_SMS_MTController.InsertVClip(objMt);
log.Info(" ");
log.Info("***** LOG SEND MT VCLIP *****");
log.Info("User_ID : " + userId);
log.Info("Message : " + message);
log.Info("Service_ID : " + serviceId);
log.Info("Command_Code : " + commandCode);
log.Info("Send_MT : " + value);
log.Info("****************************************");
log.Info(" ");
#endregion
}
return("1");
}
public static void ChargeUser(ViSport_S2_Registered_SpamSms_UserInfo info)
{
int reval = -1;
try
{
_logger.Info(string.Format("Started charging User_ID= {0}, Request_ID = {1}, ID = {2}, IsTest = {3}", info.User_Id, info.Request_Id, info.Id, SMS.Default.IsTest));
//if (info == null)
//{
// return;
//}
#region charging here
string userName = SMS.Default.UserName;
string userPass = SMS.Default.Password;
string cpId = SMS.Default.CpID;
string price = string.Empty;
string serviceType = "Charge Sub Sport Game ";
string serviceName = "ViSport_Hero";
string notEnoughMoney = "Result:12,Detail:Not enough money.";
string status = "1";
string returnValue;
if (SMS.Default.IsTest == "1")
{
returnValue = "1";
}
else
{
if (info.FailedChargingTimes <= ConvertUtility.ToInt32(SMS.Default.FailCharge))
{
price = "4000";
returnValue = objCharge.PaymentVnmWithAccount(info.User_Id, price, serviceType, serviceName, userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "3000";
returnValue = objCharge.PaymentVnmWithAccount(info.User_Id, price, serviceType, serviceName, userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "2000";
returnValue = objCharge.PaymentVnmWithAccount(info.User_Id, price, serviceType, serviceName, userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
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
var logInfo = new ViSport_S2_Registered_SpamSms_UserInfo();
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 = info.RegisteredTime;
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);
if (reval > 0)
{
_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";
if (SMS.Default.IsTest == "0")
{
#region Gui MT cho khach hang thong bao gia han thanh cong
ServiceProviderService objSentMT = new ServiceProviderService();
string message = string.Empty;
DataTable dtQuestion = SMS_MTDB_SQL.GetQuestionInfoSportGameHero();
if (dtQuestion != null && dtQuestion.Rows.Count > 0)
{
message = dtQuestion.Rows[0]["Question"].ToString();
int questionIdnew = ConvertUtility.ToInt32(dtQuestion.Rows[0]["Id"].ToString());
string answer = dtQuestion.Rows[0]["Answer"].ToString();
SMS_MTDB_SQL.InsertSportGameHeroAnswerLog(info.User_Id, questionIdnew, message, answer, DateTime.Now, 0); // LUU LOG Question
string serviceId = info.Service_Id;
string commandCode = info.Command_Code;
string requestId = info.Request_Id;
DataTable dtMt = SMS_MTDB_SQL.CheckExistSendMt(info.User_Id);
if (dtMt != null && dtMt.Rows.Count > 0)
{
_logger.Info("Da gui MT cho so : " + info.User_Id);
}
else
{
if (!string.IsNullOrEmpty(message))
{
int sentMt = objSentMT.sendMT(logInfo.User_Id, message, serviceId, commandCode, "1", requestId, "1", "1", "0", "0");
_logger.Info("SentMt return: " + sentMt + "| UserId:" + logInfo.User_Id);
}
#region LOG SEND MT
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = info.User_Id;
objMt.Message = message;
objMt.Service_ID = serviceId;
objMt.Command_Code = commandCode;
objMt.Message_Type = 1;
objMt.Request_ID = requestId;
objMt.Total_Message = 1;
objMt.Message_Index = 0;
objMt.IsMore = 0;
objMt.Content_Type = 0;
objMt.ServiceType = 0;
objMt.ResponseTime = DateTime.Now;
objMt.isLock = false;
objMt.PartnerID = "VNM";
objMt.Operator = "vnmobile";
objMt.IsQuestion = 1;
SMS_MTDB_SQL.InsertSportGameHeroMt(objMt);
#endregion
}
}
#endregion
}
SMS_MTDB_SQL.InsertLog(logInfo); //LOG DOANH THU
}
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 = returnValue;
}
if (SMS.Default.IsTest == "0")
{
SMS_MTDB_SQL.InsertLog(logInfo); //LOG DOANH THU
}
}
#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 string NotifyChargingInfo(string registeredId, string userId, string requestId, string serviceId, string serviceType, string chargingValue, string chargingAccount, string chargingTime, string chargingResponse)
{
log.Info(" ");
log.Info("***** LOG VClip CHARGED NOTIFICATION From ANDY *****");
log.Info("User_ID : " + userId);
log.Info("chargingValue : " + chargingValue);
log.Info("chargingAccount : " + chargingAccount);
log.Info("chargingTime : " + chargingTime);
log.Info("chargingResponse : " + chargingResponse);
log.Info("****************************************");
log.Info(" ");
if (chargingResponse.Trim() == "1")//CHARGED THANH CONG
{
#region Log Doanh Thu
var logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = ConvertUtility.ToInt32(registeredId);
logInfo.User_ID = userId;
logInfo.Request_ID = requestId;
logInfo.Service_ID = serviceId;
logInfo.Command_Code = "CLIP";
logInfo.Service_Type = ConvertUtility.ToInt32(serviceType);
logInfo.Charging_Count = 0;
logInfo.FailedChargingTimes = 0;
logInfo.RegisteredTime = DateTime.Now;
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = "SMS";
logInfo.Status = 1;
logInfo.Operator = "vnmobile";
logInfo.Price = ConvertUtility.ToInt32(chargingValue);
logInfo.Reason = "Succ";
ViSport_S2_Registered_UsersController.VClipInsertLog(logInfo);
#endregion
}
else //CHARGED THAT BAI
{
#region Log Doanh Thu
var logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = ConvertUtility.ToInt32(registeredId);
logInfo.User_ID = userId;
logInfo.Request_ID = requestId;
logInfo.Service_ID = serviceId;
logInfo.Command_Code = "CLIP";
logInfo.Service_Type = ConvertUtility.ToInt32(serviceType);
logInfo.Charging_Count = 0;
logInfo.FailedChargingTimes = 0;
logInfo.RegisteredTime = DateTime.Now;
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = "SMS";
logInfo.Status = 1;
logInfo.Operator = "vnmobile";
logInfo.Price = ConvertUtility.ToInt32(chargingValue);
logInfo.Reason = chargingResponse;
ViSport_S2_Registered_UsersController.VClipInsertLog(logInfo);
#region Check charging price
//if (DateTime.Now.Hour <= 22)
//{
// const string userName = "******";
// const string userPass = "******";
// const string cpId = "1928";
// try
// {
// DataTable dt = ViSport_S2_Registered_UsersController.VClipGetInfo_UserCharg(userId);
// if (dt != null && dt.Rows.Count > 0)
// {
// ViSport_S2_Registered_UsersController.Insert_CharingComand_Retry(
// ConvertUtility.ToInt32(dt.Rows[0]["Id"].ToString()),
// dt.Rows[0]["User_ID"].ToString(),
// dt.Rows[0]["Request_Id"].ToString(),
// ConvertUtility.ToInt32(dt.Rows[0]["Service_ID"].ToString()),
// 999,
// 1000,
// cpId,
// userName,
// userPass,
// "http://sv167.vmgmedia.vn:8000/JobSubs/VClip/VclipNotification.asmx"
// );
// }
// }
// catch (Exception ex)
// {
// log.Error("Lỗi charg retry user_ID :" + userId + "--error--" + ex.ToString());
// }
//}
#endregion
#endregion
}
if (chargingResponse.Trim() == "1")
{
return("1");
#region Gui MT cho khach hang thong bao gia han thanh cong
var objSentMt = new ServiceProviderService();
const int msgType = (int)Constant.MessageType.NoCharge;
string message = "(092)Quy khach da gia han thanh cong DV VMclip cua Vietnamobile. Moi ban truy cap: http://kho-clip.com/" + userId + ".aspx de xem cac video HOT cap nhat 24/24 MIEN PHI. De huy DK, soan CLIP OFF gui 949. HT 19001255";
const string commandCode = "CLIP";
int value = objSentMt.sendMT(userId, message, "949", commandCode, msgType.ToString(), requestId, "1", "1", "0", "0");
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = userId;
objMt.Message = message;
objMt.Service_ID = serviceId;
objMt.Command_Code = commandCode;
objMt.Message_Type = 1;
objMt.Request_ID = requestId;
objMt.Total_Message = 1;
objMt.Message_Index = 0;
objMt.IsMore = 0;
objMt.Content_Type = 0;
objMt.ServiceType = 0;
objMt.ResponseTime = DateTime.Now;
objMt.isLock = false;
objMt.PartnerID = "Xzone";
objMt.Operator = "vnmobile";
ViSport_S2_SMS_MTController.InsertVClip(objMt);
log.Info(" ");
log.Info("***** LOG SEND MT VCLIP *****");
log.Info("User_ID : " + userId);
log.Info("Message : " + message);
log.Info("Service_ID : " + serviceId);
log.Info("Command_Code : " + commandCode);
log.Info("Send_MT : " + value);
log.Info("****************************************");
log.Info(" ");
#endregion
}
return("1");
}
public string SynchronizeUser(string Shortcode, string RequestID, string Msisdn, string Commandcode, string Message, int SyncType, string content, int chargedDay)
{
string retVal = "0|Unidentified";
var objSentMt = new ServiceProviderService();
try
{
// Add
if (SyncType == 1)
{
#region Dang Ky USER (Kich ban moi)
var regObject = new ViSport_S2_Registered_UsersInfo();
regObject.User_ID = Msisdn;
regObject.Request_ID = RequestID;
regObject.Service_ID = Shortcode;
regObject.Command_Code = Commandcode;
regObject.Service_Type = 0;
regObject.Charging_Count = 0;
regObject.FailedChargingTimes = 0;
regObject.RegisteredTime = DateTime.Now;
regObject.ExpiredTime = DateTime.Now.AddDays(1);
regObject.Registration_Channel = "wap";
regObject.Status = 1;
regObject.Operator = "vnmobile";
regObject.CountTo_Cancel = chargedDay + 1;
DataTable dt = ViSport_S2_Registered_UsersController.ImportVClip(regObject);
#region SEND_MT
objSentMt.sendMT(Msisdn, content, Shortcode, Commandcode, "0", RequestID, "1", "1", "0", "0");
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = Msisdn;
objMt.Message = content;
objMt.Service_ID = Shortcode;
objMt.Command_Code = Commandcode;
objMt.Message_Type = 1;
objMt.Request_ID = RequestID;
objMt.Total_Message = 1;
objMt.Message_Index = 0;
objMt.IsMore = 0;
objMt.Content_Type = 0;
objMt.ServiceType = 0;
objMt.ResponseTime = DateTime.Now;
objMt.isLock = false;
objMt.PartnerID = "Xzone";
objMt.Operator = GetTelco(Msisdn);
ViSport_S2_SMS_MTController.InsertVClip(objMt);
#endregion
#endregion
retVal = "1";
}
else if (SyncType == 0) // Delete
{
var objCancel = new SMS_CancelInfo();
objCancel.User_ID = Msisdn;
objCancel.Service_ID = Shortcode;
objCancel.Command_Code = Commandcode;
objCancel.Service_Type = 0;
objCancel.Message = Message;
objCancel.Request_ID = RequestID;
objCancel.Operator = "vnmobile";
SMS_MODB.CancelInsert(objCancel);
retVal = "1";
}
}
catch (Exception ex)
{
log.Error(ex.ToString());
retVal = "0|" + ex.Message;
}
return(retVal);
}
public string SyncSubscriptionData(string Service_ID, string Command_Code, string User_ID, string Message, string Request_ID, string ServiceID, string RefID, string UpdateType, string UpdateDescription)
{
string message = "";
Message = Message.ToUpper();
string subcode = "";
if (Message.Trim().Length > Command_Code.Trim().Length)
{
subcode = Message.ToUpper().Substring(Command_Code.Length).Replace(" ", "");
}
#region VCLIP
try
{
log.Debug(" ");
log.Debug(" ");
log.Debug("-------------------VCLIP--------------------------");
log.Debug("User_ID: " + User_ID);
log.Debug("Service_ID: " + Service_ID);
log.Debug("Command_Code: " + Command_Code);
log.Debug("Message: " + Message.ToUpper());
log.Debug("Request_ID: " + Request_ID);
log.Debug(" ");
log.Debug(" ");
#region Log MO Message Into Database (SMS_MO_Log)
var moInfo = new SMS_MOInfo();
moInfo.User_ID = User_ID;
moInfo.Service_ID = Service_ID;
moInfo.Command_Code = Command_Code;
moInfo.Message = Message;
moInfo.Request_ID = Request_ID;
moInfo.Operator = GetTelco(User_ID);
SMS_MODB.InsertVClip(moInfo);
#endregion
#region Execute MT
if (Message.StartsWith("HUY"))
{
//return "-5";
#region Huy DK USER
var objCancel = new SMS_CancelInfo();
objCancel.User_ID = User_ID;
objCancel.Service_ID = Service_ID;
objCancel.Command_Code = Command_Code;
objCancel.Service_Type = GetServiceTypeVClip(subcode);
objCancel.Message = Message;
objCancel.Request_ID = Request_ID;
objCancel.Operator = GetTelco(User_ID);
SMS_MODB.CancelInsert(objCancel);
var regObject = new ViSport_S2_Registered_UsersInfo();
regObject.User_ID = User_ID;
regObject.Status = 0;
regObject.Service_Type = objCancel.Service_Type;
DataTable dt = ViSport_S2_Registered_UsersController.UpdateVClip(regObject);
var objSentMt = new ServiceProviderService();
if (dt.Rows[0]["RETURN_ID"].ToString() == "1")
{
message = AppEnv.GetSetting("alert_cancel_success_vclip");
objSentMt.sendMT(User_ID, message, Service_ID, Command_Code, "1", Request_ID, "1", "1", "0", "0");
//return "-5";
}
else
{
message = "Ban chua dk dich vu nay. Xin cam on";
objSentMt.sendMT(User_ID, message, Service_ID, Command_Code, "1", Request_ID, "1", "1", "0", "0");
//return "-6";
}
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = User_ID;
objMt.Message = message;
objMt.Service_ID = Service_ID;
objMt.Command_Code = Command_Code;
objMt.Message_Type = 1;
objMt.Request_ID = Request_ID;
objMt.Total_Message = 1;
objMt.Message_Index = 0;
objMt.IsMore = 0;
objMt.Content_Type = 0;
objMt.ServiceType = 0;
objMt.ResponseTime = DateTime.Now;
objMt.isLock = false;
objMt.PartnerID = "Xzone";
objMt.Operator = GetTelco(User_ID);
ViSport_S2_SMS_MTController.InsertVClip(objMt);
#endregion
}
else
{
var objSentMt = new ServiceProviderService();
if (AppEnv.GetSetting("VClip_New") == "1")
{
//Đăng ký kịch bản mới
#region Dang Ky USER (Kich ban moi)
var regObject = new ViSport_S2_Registered_UsersInfo();
regObject.User_ID = User_ID;
regObject.Request_ID = Request_ID;
regObject.Service_ID = Service_ID;
regObject.Command_Code = Command_Code;
regObject.Service_Type = GetServiceTypeVClip(Command_Code);
regObject.Charging_Count = 0;
regObject.FailedChargingTimes = 0;
regObject.RegisteredTime = DateTime.Now;
regObject.ExpiredTime = DateTime.Now.AddDays(1);
regObject.Registration_Channel = "SMS";
regObject.Status = 1;
regObject.Operator = moInfo.Operator;
DataTable dt = ViSport_S2_Registered_UsersController.InsertVClipNew(regObject);
if (dt.Rows[0]["RETURN_ID"].ToString() == "0")
{
//Đăng ký lần đầu
message = "Chuc mung! Quy khach da Dky thanh cong DV VClip. QK duoc mien phi ngay dau tien trong lan dau dang ky. Moi QK truy cap http://kho-clip.com/ de su dung dvu (2.000d/ngay),dvu duoc tu dong gia han. De huy DK, soan:HUY VCLIP gui 949. HT: 19001255.";
}
else if (dt.Rows[0]["RETURN_ID"].ToString() == "1")
{
//Double đăng ký
message = "Quy Khach da dang ky dich vu VClip truoc do. Moi QK truy cap http://kho-clip.com/ de su dung dvu.. HT: 19001255";
}
else if (dt.Rows[0]["RETURN_ID"].ToString() == "2")
{
//Hủy đi đăng ký lại
message = "Chuc mung! Quy khach da Dky thanh cong DV VClip. Moi QK truy cap http://kho-clip.com/ de su dung dvu (2.000d/ngay),dvu duoc tu dong gia han. De huy DK, soan:HUY VCLIP gui 949. HT: 19001255.";
}
#region SEND_MT
objSentMt.sendMT(User_ID, message, Service_ID, Command_Code, "0", Request_ID, "1", "1", "0", "0");
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = User_ID;
objMt.Message = message;
objMt.Service_ID = Service_ID;
objMt.Command_Code = Command_Code;
objMt.Message_Type = 1;
objMt.Request_ID = Request_ID;
objMt.Total_Message = 1;
objMt.Message_Index = 0;
objMt.IsMore = 0;
objMt.Content_Type = 0;
objMt.ServiceType = 0;
objMt.ResponseTime = DateTime.Now;
objMt.isLock = false;
objMt.PartnerID = "Xzone";
objMt.Operator = GetTelco(User_ID);
ViSport_S2_SMS_MTController.InsertVClip(objMt);
#endregion
#endregion
}
}
#endregion
return("-10");
}
catch (Exception ex)
{
log.Debug("---------------Error sentMT----------------------");
log.Debug("Get Error : " + ex.Message);
return("-20");
}
#endregion
//return "-1";
}
