public void SendMtThanhNu(string userId, string mtMessage, string serviceId, string commandCode, string requestId)
{
var objSentMt = new ServiceProviderService();
if (AppEnv.GetSetting("TestFlag") == "0")
{
int result = objSentMt.sendMT(userId, mtMessage, serviceId, commandCode, "1", requestId, "1", "1", "0", "0");
log.Debug("Send MT result : " + result);
log.Debug("userId : " + userId);
log.Debug("Noi dung MT : " + mtMessage);
log.Debug("ServiceId : " + serviceId);
log.Debug("commandCode : " + commandCode);
log.Debug("requestId : " + requestId);
}
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = userId;
objMt.Message = mtMessage;
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";
ViSport_S2_SMS_MTController.InsertThanhNuMt(objMt);
}
public int Execute(int jobID)
{
try
{
#region SEND MT MDT
DataTable dt = ViSport_S2_Registered_UsersController.ThanhNuAllUserForSendMt();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string userId = dr["User_Id"].ToString();
string message = "Ban da gia han thanh cong goi dich vu Big promotion cua Vietnamobile. Ban duoc them " + dr["Total"] + " MDT la: " + dr["Code"];
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 -------------------------");
_log.Debug("User_ID: " + userId);
_log.Debug("Message: " + message);
_log.Debug(" ");
_log.Debug(" ");
}
}
#endregion
}
catch (Exception ex)
{
_log.Error("BIG PROMOTION Loi lay tap User : " + ex);
return(0);
}
return(1);
}
public void SendMtVnptMedia(string userId, string mtMessage, string serviceId, string commandCode, string requestId)
{
var objSentMt = new ServiceProviderService();
const int msgType = (int)Constant.MessageType.NoCharge;
//if (AppEnv.GetSetting("TestFlag") == "0")
//{
int result = objSentMt.sendMT(userId, mtMessage, serviceId, commandCode, msgType.ToString(), requestId, "1", "1", "0", "0");
_log.Debug("***** VNPT_Media Send MT *****");
_log.Debug("Send MT result : " + result);
_log.Debug("userId : " + userId);
_log.Debug("Noi dung MT : " + mtMessage);
_log.Debug("ServiceId : " + serviceId);
_log.Debug("commandCode : " + commandCode);
_log.Debug("requestId : " + requestId);
_log.Debug("*****");
//}
const int isQuestion = 0; // = 1 : CAU HOI GUI TU WinService
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = userId;
objMt.Message = mtMessage;
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 = "VNM";
objMt.IsQuestion = isQuestion;
ViSport_S2_SMS_MTController.VnptInsertMt(objMt);
}
private void EnQueue(DataTable tbl)
{
int step = 1;
if (tbl != null && tbl.Rows.Count > 0 && MSMProccess.MT_PROC_QUE.Count < 100)
{
_logger.Info(" ");
_logger.Info(" ");
_logger.Info(" ");
_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);
}
}
ViSport_S2_SMS_MTController.UpdateStatus(0); //UPDATE JobStatus Sau Khi Gui MT Xong;
}
}
public static void SentMtInfo(ViSport_S2_Registered_UsersInfo info)
{
DataTable dt = ViSport_S2_SMS_MTController.GetMtContent();
//if(dt != null && dt.Rows.Count > 0)
//{
// if(!string.IsNullOrEmpty(dt.Rows[0]["MT"].ToString()))
// {
try
{
string day = DateTime.Now.ToString("yyyyMMdd");
DataTable dtMt = ViSport_S2_SMS_MTController.CheckAlreadySendMt(info.User_ID, 0, day);
if (dtMt != null && dtMt.Rows.Count > 0)
{
_logger.Info("Da gui MT cho so : " + info.User_ID + "| day : " + day);
}
else
{
string message = string.Empty;
string isMt = dt.Rows[0]["IsMt"].ToString();
if (isMt == "1")
{
message = GetSetting("MessageTue");
}
else if (isMt == "2")
{
message = GetSetting("MessageThu");
}
else if (isMt == "3")
{
message = GetSetting("MessageSat");
}
_logger.Info(string.Format("Started Send MT User_ID= {0}, Request_ID = {1}, ID = {2}, Message = {3}", info.User_ID, info.Request_ID, info.ID, message));
//#region Gui MT cho khach hang
//var objSentMt = new ServiceProviderService();
//string serviceId = info.Service_ID;
//string commandCode = info.Command_Code;
//string requestId = info.Request_ID;
//objSentMt.sendMT(info.User_ID, message, serviceId, commandCode, "1", requestId, "1", "1", "0", "0");
//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 = "Xzone";
//objMt.Operator = "VClip_MT";
//ViSport_S2_SMS_MTController.InsertVClip(objMt);
//#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 SentMtInfo(ViSport_S2_Registered_UsersInfo info)
{
DataTable dt = ViSport_S2_SMS_MTController.GetMtContent(info.Sub_Code.ToUpper());
if (dt != null && dt.Rows.Count > 0)
{
//if(!string.IsNullOrEmpty(dt.Rows[0]["MT"].ToString()))
//{
try
{
int hour = ConvertUtility.ToInt32(dt.Rows[0]["Hour"].ToString());
string day = dt.Rows[0]["Day"].ToString();
//DataTable dtMt = ViSport_S2_SMS_MTController.CheckAlreadySendMt(info.User_ID,hour,day,info.Sub_Code);
//_logger.Info("Tham So Check CheckAlreadySendMt : " + info.User_ID + "| hour : " + hour + "| day : " + day);
//if (dtMt != null && dtMt.Rows[0]["RETURN_ID"].ToString() == "1")
//{
// _logger.Info("Da gui MT cho so : " + info.User_ID + "| hour : " + hour + "| day : " + day);
//}
//else
//{
//string message = dt.Rows[0]["MT"].ToString(); //Message lay tu DB;
//string messageKd = UnicodeUtility.UnicodeToKoDau(message); //Loai bo dau;
#region Gui MT cho khach hang
var objSentMt = new ServiceProviderService();
string serviceId = info.Service_ID;
string commandCode = info.Command_Code;
string requestId = info.Request_ID;
//for (int i = 0; i < 3;i++ )
//{
const int mtOrder = 1;
string mtContent = string.Empty;
if (!string.IsNullOrEmpty(dt.Rows[0]["MT1"].ToString()))
{
mtContent = dt.Rows[0]["MT1"].ToString();
}
else if (!string.IsNullOrEmpty(dt.Rows[0]["MT2"].ToString()))
{
mtContent = dt.Rows[0]["MT2"].ToString();
}
else if (!string.IsNullOrEmpty(dt.Rows[0]["MT3"].ToString()))
{
mtContent = dt.Rows[0]["MT3"].ToString();
}
//if(i==0)
//{
// mtOrder = 1;
// mtContent = dt.Rows[0]["MT1"].ToString();
//}
//else if(i == 1)
//{
// mtOrder = 2;
// mtContent = dt.Rows[0]["MT2"].ToString();
//}
//else
//{
// mtOrder = 3;
// mtContent = dt.Rows[0]["MT3"].ToString();
//}
DataTable dtMt = ViSport_S2_SMS_MTController.CheckAlreadySendMt(info.User_ID, hour, day, info.Sub_Code, mtOrder);
_logger.Info("Tham So Check CheckAlreadySendMt : " + info.User_ID + " | hour : " + hour + " | day : " + day + " | sub_code :" + info.Sub_Code + " | mt_order :" + mtOrder);
if (dtMt != null && dtMt.Rows.Count > 0)
{
_logger.Info("Da gui MT cho so : " + info.User_ID + " | hour : " + hour + " | day : " + day + " | sub_code :" + info.Sub_Code + " | mt_order :" + mtOrder);
}
else
{
_logger.Info(string.Format("Started Send MT User_ID= {0}, Request_ID = {1}, ID = {2}, Message = {3}", info.User_ID, info.Request_ID, info.ID, mtContent));
if (!string.IsNullOrEmpty(mtContent))
{
int sentMt = objSentMt.sendMT(info.User_ID, mtContent, serviceId, commandCode, "1", requestId, "1", "1", "0", "0");
_logger.Info("SentMt return: " + sentMt);
}
#region Log Sms MT
var objMt = new ViSport_S2_SMS_MTInfo();
objMt.User_ID = info.User_ID;
objMt.Message = mtContent;
objMt.Service_ID = serviceId;
objMt.Command_Code = commandCode;
objMt.Sub_Code = info.Sub_Code;
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 = "ViSport_MT";
objMt.MtOrder = mtOrder;
ViSport_S2_SMS_MTController.InsertMtSpamSmsUser(objMt);
#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 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")
{
#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 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 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");
}
private static bool UpdateJobStatus(int status)
{
return(ViSport_S2_SMS_MTController.UpdateStatus(status));
}
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";
}
