public int Execute(int jobID)
{
try
{
//string filePath1 = @"C:\test.csv";
//string delimiter = ",";
//string[][] output = new string[][]{
// new string[]{"Col 1 Row 1", "Col 2 Row 1", "Col 3 Row 1"},
// new string[]{"Col1 Row 2", "Col2 Row 2", "Col3 Row 2"}
//};
//int length = output.GetLength(0);
//StringBuilder sb = new StringBuilder();
//for (int index = 0; index < length; index++)
// sb.AppendLine(string.Join(delimiter, output[index]));
//File.WriteAllText(filePath1, sb.ToString());
DataTable dtPartner = ViSport_S2_Registered_UsersController.PartnerGetAll();
if (dtPartner != null && dtPartner.Rows.Count > 0)
{
foreach (DataRow drPartner in dtPartner.Rows)
{
int partnerId = ConvertUtility.ToInt32(drPartner["PartnerId"].ToString());
string folderName = drPartner["FolderName"].ToString();
if (!Directory.Exists(Server.MapPath(folderName)))
{
Directory.CreateDirectory(Server.MapPath(folderName));
}
var csv = new StringBuilder();
DateTime dataDate = DateTime.Today.AddDays(-1);
string filePath = Server.MapPath(folderName + "/vmg_dn_vn_" + dataDate.Year + "" + dataDate.Month + "" + dataDate.Day + ".csv");
csv.AppendLine("Type"
+ "," + "TelcoCode"
+ "," + "ServiceName"
+ "," + "ShortCode"
+ "," + "Msisdn"
+ "," + "Unique_id"
+ "," + "Price"
+ "," + "ChargedStatus"
+ "," + "Detail"
+ "," + " Created");
#region GPC
DataTable dtGpc = ViSport_S2_Registered_UsersController.CdrGpc(partnerId);
if (dtGpc != null && dtGpc.Rows.Count > 0)
{
foreach (DataRow dr in dtGpc.Rows)
{
//Type,TelcoCode,ServiceName,ShortCode,Msisdn,Unique_id,Price,ChargedStatus,Detail,Created
csv.AppendLine("SUB"
+ "," + "Gpc"
+ "," + dr["Service_Name"]
+ "," + dr["shortCode"]
+ "," + dr["msisdn"]
+ "," + " "
+ "," + dr["cost"]
+ "," + "1"
+ "," + "Succ"
+ "," + dr["TimeStamp"]);
}
}
#endregion
#region VMS
DataTable dtVms = ViSport_S2_Registered_UsersController.CdrPartnerGetServiceId(partnerId);
if (dtVms != null && dtVms.Rows.Count > 0)
{
foreach (DataRow drSv in dtVms.Rows)
{
string serviceName = drSv["Service_Name"].ToString();
string serviceId = drSv["Service_Id"].ToString();
const string shortCode = "8979";
DataTable dtUsers = ViSport_S2_Registered_UsersController.SamVmsGetCdrByServiceId(serviceId);
if (dtUsers != null && dtUsers.Rows.Count > 0)
{
foreach (DataRow dr in dtUsers.Rows)
{
//Type,TelcoCode,ServiceName,ShortCode,Msisdn,Unique_id,Price,ChargedStatus,Detail,Created
csv.AppendLine("SUB"
+ "," + "Vms"
+ "," + serviceName
+ "," + shortCode
+ "," + dr["msisdn"]
+ "," + " "
+ "," + dr["cost"]
+ "," + dr["ChargeResult"]
+ "," + " "
+ "," + dr["TimeStamp"]);
}
File.WriteAllText(filePath, csv.ToString());
}
}
}
#endregion
#region VNM
DataTable dtVnm = ViSport_S2_Registered_UsersController.CdrVnm(partnerId);
if (dtVnm != null && dtVnm.Rows.Count > 0)
{
foreach (DataRow dr in dtVnm.Rows)
{
csv.AppendLine("SUB"
+ "," + "Vnm"
+ "," + dr["Product_Name"]
+ "," + dr["shortCode"]
+ "," + dr["User_Id"]
+ "," + " "
+ "," + dr["Charging_Price"]
+ "," + dr["Charging_Status"]
+ "," + dr["Charging_Response"]
+ "," + ConvertUtility.ToDateTime(dr["Charging_Time"]));
}
File.WriteAllText(filePath, csv.ToString());
}
#endregion
#region VNM 1119
DataTable dtVnm1119 = ViSport_S2_Registered_UsersController.CdrVnm1119(partnerId);
if (dtVnm1119 != null && dtVnm1119.Rows.Count > 0)
{
foreach (DataRow dr in dtVnm1119.Rows)
{
csv.AppendLine("SUB"
+ "," + "Vnm"
+ "," + dr["Product_Name"]
+ "," + dr["shortCode"]
+ "," + dr["User_Id"]
+ "," + " "
+ "," + dr["Charging_Price"]
+ "," + dr["Charging_Status"]
+ "," + dr["Charging_Response"]
+ "," + ConvertUtility.ToDateTime(dr["Charging_Time"]));
}
File.WriteAllText(filePath, csv.ToString());
}
#endregion
}
}
}
catch (Exception ex)
{
_log.Error("CDR Loi lay Tap User : " + ex);
return(0);
}
return(1);
}
public int Execute(int jobID)
{
try
{
try
{
#region GET USER
DataTable dtUsers = ViSport_S2_Registered_UsersController.GetSportGameUserByTypeTp(false);
if (dtUsers != null && dtUsers.Rows.Count > 0)
{
string userName = AppEnv.GetSetting("userName_3g_visport");
string userPass = AppEnv.GetSetting("password_3g_visport");
string cpId = AppEnv.GetSetting("cpId_3g_visport");
foreach (DataRow dr in dtUsers.Rows)
{
ViSport_S2_Registered_UsersController.WorldCupUserInsertToAndy(
ConvertUtility.ToInt32(dr["Id"].ToString()),
dr["User_ID"].ToString(),
dr["Request_Id"].ToString(),
ConvertUtility.ToInt32(dr["Service_ID"].ToString()),
999,
5000,
cpId,
userName,
userPass,
"http://123.29.67.167:8000/JobSubs/Sport/Notification.asmx"
);
}
}
#endregion
}
catch (Exception)
{
//Retry lai khi co loi
#region GET USER
DataTable dtUsers = ViSport_S2_Registered_UsersController.GetSportGameUserByTypeTp(false);
if (dtUsers != null && dtUsers.Rows.Count > 0)
{
string userName = AppEnv.GetSetting("userName_3g_visport");
string userPass = AppEnv.GetSetting("password_3g_visport");
string cpId = AppEnv.GetSetting("cpId_3g_visport");
foreach (DataRow dr in dtUsers.Rows)
{
ViSport_S2_Registered_UsersController.WorldCupUserInsertToAndy(
ConvertUtility.ToInt32(dr["Id"].ToString()),
dr["User_ID"].ToString(),
dr["Request_Id"].ToString(),
ConvertUtility.ToInt32(dr["Service_ID"].ToString()),
999,
5000,
cpId,
userName,
userPass,
"http://123.29.67.167:8000/JobSubs/Sport/Notification.asmx"
);
}
}
#endregion
//Gui Email Alert
DoSendMail("*****@*****.**", "", "LOI CHARGED VISPORT", "Visport xuat hien loi charged he thong da retry lai. Vui long kiem tra lai doanh thu");
}
}
catch (Exception ex)
{
_log.Error("Visport Loi lay tap User : " + ex);
return(0);
}
return(1);
}
public string MOreceiver_VoiceChat(String Command_Code, String Service_ID, String User_ID, String Message, String Request_ID, String Channel)
{
string messageReturn = "";
string responseValue = "";
Message = Message.ToUpper();
string subcode = "";
if (Message.Trim().Length > Command_Code.Trim().Length)
{
subcode = Message.ToUpper().Substring(Command_Code.Length).Replace(" ", "");
}
Command_Code = Command_Code.ToUpper();
Message = Message.ToUpper();
try
{
log.Debug(" ");
log.Debug(" ");
log.Debug("-------------------- TRIEU PHU BONG DA -------------------------");
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)
if (AppEnv.GetSetting("TestFlag") == "0")
{
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.InsertSportGameHeroMo(moInfo);
}
if (Command_Code == "TP" && subcode == "" && Service_ID == "979") //DK DICH VU TRIEU_PHU_BONG_DA
{
#region DK DICH VU
var entity = new ViSport_S2_Registered_UsersInfo();
entity.User_ID = User_ID;
entity.Request_ID = Request_ID;
entity.Service_ID = Service_ID;
entity.Command_Code = Command_Code;
entity.Service_Type = 1;
entity.Charging_Count = 0;
entity.FailedChargingTimes = 0;
entity.RegisteredTime = DateTime.Now;
entity.ExpiredTime = DateTime.Now.AddDays(1);
entity.Registration_Channel = Channel;
entity.Status = 1;
entity.Operator = GetTelco(User_ID);
entity.Point = 2;
string passWord = RandomActiveCode.RandomStringNumber(6);
entity.Password = passWord;
DataTable value = ViSport_S2_Registered_UsersController.InsertSportGameHeroRegisterUser(entity);
if (value.Rows[0]["RETURN_ID"].ToString() == "0")//DK DICH VU LAN DAU
{
#region DK DV LAN DAU TIEN
messageReturn = "Chuc mung ban da tham gia CTKM Trieu phu bong da cua Vietnamobile. ";
if (DateTime.Now > Convert.ToDateTime(AppEnv.GetSetting("StartKM")) && DateTime.Now < Convert.ToDateTime(AppEnv.GetSetting("EndKM")))
{
messageReturn = messageReturn + "Ban co 5.000 diem voi co hoi trung thuong 1 dien thoai Samsung Galaxy A5. ";
}
messageReturn = messageReturn + "Moi ngay ban se nhan duoc nhung tin tuc the thao nong hoi (5000d/ngay). " +
"Truy cap: http://visport.vn de su dung dich vu. " +
"De huy dvu soan: HUY TP gui 979, xem diem va so diem cao nhat hien tai soan TOP gui 979 HT: 19001255";
SendMtSportGameHero(User_ID, messageReturn, Service_ID, Command_Code, Request_ID, 0);
responseValue = "1|Success";
#endregion
}
else if (value.Rows[0]["RETURN_ID"].ToString() == "2")
{
#region DA DK DV ROI XONG HUY DK LAI ==> TRA MT WELCOME
messageReturn = "Chuc mung ban da tham gia CTKM Trieu phu bong da cua Vietnamobile.";
if (DateTime.Now > Convert.ToDateTime(AppEnv.GetSetting("StartKM")) && DateTime.Now < Convert.ToDateTime(AppEnv.GetSetting("EndKM")))
{
messageReturn = messageReturn + " Ban co 5.000 diem voi co hoi trung thuong 1 dien thoai Samsung Galaxy A5.";
}
messageReturn = messageReturn + "Moi ngay ban se nhan duoc nhung tin tuc the thao nong hoi. Truy cap: http://visport.vn de su dung dvu. De huy dvu soan: HUY TP gui 979. HT: 19001255";
SendMtSportGameHero(User_ID, messageReturn, Service_ID, Command_Code, Request_ID, 0); //SEND MT LAN 1
responseValue = "1|Success";
#endregion
}
else if (value.Rows[0]["RETURN_ID"].ToString() == "1")//DA DK DICH VU
{
#region THUE BAO DANG ACTIVE DV
messageReturn = "Ban da tham gia CTKM Trieu phu bong da cua Vietnamobile.";
if (DateTime.Now > Convert.ToDateTime(AppEnv.GetSetting("StartKM")) && DateTime.Now < Convert.ToDateTime(AppEnv.GetSetting("EndKM")))
{
messageReturn = messageReturn + " Ban co 5.000 diem voi co hoi trung thuong 1 dien thoai Samsung Galaxy A5.";
}
messageReturn = messageReturn + "Moi ngay ban se nhan duoc nhung tin tuc the thao nong hoi. Truy cap: http://visport.vn de su dung dvu. De huy dvu soan: HUY TP gui 979. HT: 19001255";
SendMtSportGameHero(User_ID, messageReturn, Service_ID, Command_Code, Request_ID, 0);
responseValue = "0|DoubleRegister";
#endregion
}
#endregion
}
else
{
messageReturn = "Tin nhan sai cu phap.";
SendMtSportGameHero(User_ID, messageReturn, Service_ID, Command_Code, Request_ID, 0);
responseValue = "-1|WrongSyntax";
}
#endregion
}
catch (Exception ex)
{
log.Error(ex.ToString());
responseValue = "-2|System busy";
}
return(responseValue);
}
public void ProcessRequest(HttpContext context)
{
//context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string serviceCode = context.Request.QueryString["serviceCode"];
if (!string.IsNullOrEmpty(serviceCode))
{
serviceCode = serviceCode.ToUpper();
}
string msisdn = context.Request.QueryString["msisdn"];
string type = context.Request.QueryString["Type"];
string serviceId = "8979";
const string reType = "text";
string reContent = string.Empty;
log4net.ILog log = log4net.LogManager.GetLogger("File");
log.Debug(" ");
log.Debug(" ");
log.Debug("--------------------VOTE MOBI FROM Mr.T-------------------------");
log.Debug("User_ID: " + msisdn);
log.Debug("Command_Code: " + serviceCode);
log.Debug("Type: " + type);
log.Debug(" ");
log.Debug(" ");
if (serviceCode == "V1" || serviceCode == "V2" || serviceCode == "G1" || serviceCode == "G2")//DV VOTE1 & VOTE2
{
int votePersonId = 1;
string personName = "Mai Tho";
string commandCode = "VOTE1";
int dislikePersonId = 0;
if (serviceCode == "V2")
{
votePersonId = 2;
personName = "Linh Miu";
commandCode = "VOTE2";
}
else if (serviceCode == "G1")
{
votePersonId = 2;
dislikePersonId = 1;
personName = "Mai Tho";
commandCode = "GACH1";
}
else if (serviceCode == "G2")
{
votePersonId = 1;
dislikePersonId = 2;
personName = "Linh Miu";
commandCode = "GACH2";
}
if (type == "1")//DK DV LAN DAU
{
var entity = new VoteRegisteredInfo();
entity.User_ID = msisdn;
entity.Request_ID = "0";
entity.Service_ID = serviceId;
entity.Command_Code = commandCode;
entity.Service_Type = 1;
entity.Charging_Count = 0;
entity.FailedChargingTime = 0;
entity.RegisteredTime = DateTime.Now;
entity.ExpiredTime = DateTime.Now.AddDays(1);
entity.Registration_Channel = "SMS";
entity.Status = 1;
entity.Operator = "vms";
entity.Vote_Count = 1;
entity.Vote_PersonId = votePersonId;
entity.IsDislike = dislikePersonId;
if (serviceCode == "V1" || serviceCode == "V2")
{
DataTable dt = VoteRegisterController.NewVoteRegisterInsert(entity);
if (dt.Rows[0]["RETURN_ID"].ToString() == "0")//CHUA DK USER
{
reContent = AppEnv.GetSetting("Vote_Sms_RegisterSucess_Mt2_Like_Mobi").Replace("VoteCount", "1").Replace("VoteTop", "100");
}
else if (dt.Rows[0]["RETURN_ID"].ToString() == "1")
{
int voteCount = ConvertUtility.ToInt32(dt.Rows[0]["VOTE_SUM"]);
string voteTop = GetTopVote(voteCount);
reContent = AppEnv.GetSetting("Vote_Sms_RegisterSucess_Mt2_Like_Mobi").Replace("VoteCount", voteCount.ToString()).Replace("VoteTop", voteTop);
}
#region LOG DOANH THU
NewVoteLogDoanhThu(msisdn, "0", serviceId, "VOTE1");
#endregion
}
//else
//{
// DataTable dt = VoteRegisterController.VoteRegisterInsert(entity);
// DataTable dtDislike = VoteRegisterController.VoteRegisterDislikeInsert(entity);
// if (dt.Rows[0]["RETURN_ID"].ToString() == "0")//DK DICH VU LAN DAU
// {
// reContent = AppEnv.GetSetting("Vote_Sms_RegisterSucess_Mt2_Like_Mobi").Replace("PersonName", personName);
// }
// else if (dt.Rows[0]["RETURN_ID"].ToString() == "1")
// {
// reContent = AppEnv.GetSetting("Vote_Sms_AlreadyRegister_Mobi");
// }
//}
}
else if (type == "2")//UPDATE LUOT VOTE (SUB HANG NGAY)
{
DataTable info = VoteRegisterController.NewVoteGetUserInfo(msisdn);
if (info != null && info.Rows.Count > 0)
{
var logInfo = new ViSport_S2_Charged_Users_LogInfo();
logInfo.ID = ConvertUtility.ToInt32(info.Rows[0]["ID"].ToString());
logInfo.User_ID = msisdn;
logInfo.Request_ID = info.Rows[0]["Request_ID"].ToString();
logInfo.Service_ID = info.Rows[0]["Service_ID"].ToString();
logInfo.Command_Code = info.Rows[0]["Command_Code"].ToString();
logInfo.Service_Type = 0;//Charged Sub Service_Type
logInfo.Charging_Count = ConvertUtility.ToInt32(info.Rows[0]["Charging_Count"].ToString());
logInfo.FailedChargingTimes = ConvertUtility.ToInt32(info.Rows[0]["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = DateTime.Now;
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = info.Rows[0]["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(info.Rows[0]["Status"].ToString());
logInfo.Operator = info.Rows[0]["Operator"].ToString();
logInfo.Price = 2000;
logInfo.Vote_PersonId = ConvertUtility.ToInt32(info.Rows[0]["Vote_PersonId"].ToString());
logInfo.Reason = "Succ";
if (serviceCode == "V1" || serviceCode == "V2")
{
VoteRegisterController.NewInsertLogLike(logInfo);
DataTable dt = VoteRegisterController.NewVoteGetUserInfo(msisdn);
int voteCount = ConvertUtility.ToInt32(dt.Rows[0]["Vote_Count"]);
string voteTop = GetTopVote(voteCount);
reContent = AppEnv.GetSetting("Vote_Sms_RegisterSucess_Mt2_Like_Mobi").Replace("VoteCount", voteCount.ToString()).Replace("VoteTop", voteTop);
//DataTable dt = VoteRegisterController.GetVoteAccountInfo(msisdn, info.Rows[0]["Command_Code"].ToString());
//reContent = AppEnv.GetSetting("Vote_Sms_ChargedSubSucess_Like").Replace("PersonName", dt.Rows[0]["Name"].ToString());
//reContent = reContent.Replace("VoteCount", dt.Rows[0]["Count"].ToString());
//reContent = reContent.Replace("VoteTop", dt.Rows[0]["Top"].ToString());
}
//else if(serviceCode == "G1" || serviceCode == "G2")
//{
// if (info.Rows[0]["Vote_PersonId"].ToString() == "1")
// {
// logInfo.Vote_PersonId = 2;
// }
// else if (info.Rows[0]["Vote_PersonId"].ToString() == "2")
// {
// logInfo.Vote_PersonId = 1;
// }
// VoteRegisterController.InsertLogDisLike(logInfo);
// DataTable dt = VoteRegisterController.GetVoteAccountInfo(msisdn, info.Rows[0]["Command_Code"].ToString());
// reContent = AppEnv.GetSetting("Vote_Sms_ChargedSubSucess_UnLike").Replace("PersonName", dt.Rows[0]["Name"].ToString());
// reContent = reContent.Replace("DislikeCount", dt.Rows[0]["Count"].ToString());
// reContent = reContent.Replace("DislikeTop", dt.Rows[0]["Top"].ToString());
//}
}
}
else if (type == "3")//HUY DICH VU
{
DataTable dt = VoteRegisterController.NewVoteRegisterUserLock(msisdn);
if (dt.Rows[0]["RETURN_ID"].ToString() == "0")//CHUA DK USER
{
reContent = AppEnv.GetSetting("Vote_Sms_LockUserError_Mobi");
}
else if (dt.Rows[0]["RETURN_ID"].ToString() == "1")
{
reContent = AppEnv.GetSetting("Vote_Sms_LockUserSuccess_Mobi");
}
//DataTable dt = VoteRegisterController.VoteRegisterUserLock(msisdn, 1);
//if (dt.Rows[0]["RETURN_ID"].ToString() == "0")//CHUA DK USER
//{
// reContent = AppEnv.GetSetting("Vote_Sms_LockUserError_Mobi");
//}
//else if (dt.Rows[0]["RETURN_ID"].ToString() == "1")
//{
// reContent = AppEnv.GetSetting("Vote_Sms_LockUserSuccess_Mobi");
//}
}
}
if (serviceCode == "T1") //DV GAME THANH_NU
{
if (type == "1") //DK DV LAN DAU
{
var entity = new ThanhNuRegisteredUsers();
entity.UserId = msisdn;
entity.RequestId = "0";
entity.ServiceId = "2288";
entity.CommandCode = "DK";
entity.ServiceType = 1;
entity.ChargingCount = 0;
entity.FailedChargingTimes = 0;
entity.RegisteredTime = DateTime.Now;
entity.ExpiredTime = DateTime.Now.AddDays(1);
entity.RegistrationChannel = "SMS";
entity.Status = 1;
entity.Operator = GetTelco(msisdn);
#region GOI HAM DK BEN DOI TAC
string partnerResult = AppEnv.ThanhNuDangKy(msisdn);
log.Debug(" ");
log.Debug("**********");
log.Debug("Partner_Thanh_Nu_smsKichHoat : " + partnerResult);
log.Debug("**********");
log.Debug(" ");
string[] arrValue = partnerResult.Split('|');
if (arrValue[0].Trim() == "1")
{
ViSport_S2_Registered_UsersController.ThanhNuRegisterUserStatusUpdate(msisdn, 1);
reContent = "Ban da la thanh vien cua Game Thanh Nu. Click vao link sau de dang nhap Game " + arrValue[1];
}
else if (arrValue[0].Trim() == "0")
{
DataTable value = ViSport_S2_Registered_UsersController.ThanhNuRegisterUserInsert(entity);
if (value.Rows[0]["RETURN_ID"].ToString() == "0")
{
reContent = "Chuc mung Quy Khach da dang ky thanh cong Game Thanh Nu Gia cuoc 1000d-ngay, Goi dich vu se duoc tu dong gia han hang ngay.Kich hoat tai khoan " + arrValue[1] + " .De huy dang ky, Quy Khach soan HUY TN gui 2288.";
}
else if (value.Rows[0]["RETURN_ID"].ToString() == "1")
{
ViSport_S2_Registered_UsersController.ThanhNuRegisterUserStatusUpdate(msisdn, 1);
reContent = "Ban da la thanh vien cua Game Thanh Nu. Click vao link sau de dang nhap Game " + arrValue[1];
}
}
#endregion
}
else if (type == "2")//CHARGED SUB
{
var partnerService = new vn.thanhnu.Service();
DataTable dtUser = ViSport_S2_Registered_UsersController.ThanhNuGetUserInfo(msisdn);
if (dtUser != null && dtUser.Rows.Count > 0)
{
string partnerResult = partnerService.smsGiaHan(msisdn, "1");
if (partnerResult.Trim() == "1")
{
reContent = "Goi dich vu Game Thanh Nu cua Quy Khach da duoc gia han thanh cong. Quy khach duoc cong 110 G_Coin vao tk. Cam on Quy Khach da su dung goi dich vu .";
}
#region LOG DOANH THU
//LOG DOANH THU
var e = new ThanhNuChargedUserLogInfo();
e.ID = ConvertUtility.ToInt32(dtUser.Rows[0]["ID"].ToString());
e.User_ID = msisdn;
e.Request_ID = "0";
e.Service_ID = serviceId;
e.Command_Code = "DK";
e.Service_Type = 0;
e.Charging_Count = 0;
e.FailedChargingTime = 0;
e.RegisteredTime = DateTime.Now;
e.ExpiredTime = DateTime.Now.AddDays(1);
e.Registration_Channel = "SMS";
e.Status = 1;
e.Operator = GetTelco(msisdn);
e.Reason = "Succ";
e.Price = 1000;
e.PartnerResult = partnerResult;
ViSport_S2_Registered_UsersController.ThanhNuChargedUserLog(e);
#endregion
}
}
else if (type == "3")//HUY DICH VU
{
#region GOI HAM HUY BEN DOI TAC
string partnerResult = AppEnv.ThanhNuHuy(msisdn);
if (partnerResult.Trim() == "1")
{
DataTable value = ViSport_S2_Registered_UsersController.ThanhNuRegisterUserStatusUpdate(msisdn, 0);
if (value.Rows[0]["RETURN_ID"].ToString() == "1")
{
reContent = "Toan bo tai khoan Game Thanh Nu cua Quy khach se bi huy.De dang ki lai Qk vui long soan tin DK TN gui 2288";
}
}
#endregion
}
}
var aSerializer = new JavaScriptSerializer();
var obj = new MT();
var ct1 = new ContentInfo();
obj.List = new ContentInfo[1];
ct1.Type = reType;
ct1.Content = reContent;
obj.List[0] = ct1;
string strReturn = aSerializer.Serialize(obj);
log.Debug(" ");
log.Debug(" ");
log.Debug("strReturn: " + strReturn);
log.Debug(" ");
log.Debug(" ");
context.Response.ContentType = "text/html";
context.Response.Write(strReturn);
}
public int Execute(int jobID)
{
WebServiceCharging3g webServiceCharging3G = new WebServiceCharging3g();
string userName = "******";
string userPass = "******";
string cpId = "1930";
string price;
try
{
DataTable dtUsers = ViSport_S2_Registered_UsersController.GetSportGameUserByTypeTp(false);
if (dtUsers != null && dtUsers.Rows.Count > 0)
{
string message = string.Empty;
string returnValue = string.Empty;
string notEnoughMoney = AppEnv.GetSetting("NotEnoughMoney");
string serviceType = "Charge Hero";
string serviceName = "ViSport_Hero";
string reasonLog = string.Empty;
int count = 0;
for (int i = 0; i < dtUsers.Rows.Count; i++)
{
if (count >= 3)
{
Thread.Sleep(1000);
count = 0;
}
try
{
string msisdn = dtUsers.Rows[i]["User_ID"].ToString();
#region TIEN HANH CHARGED
price = "5000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Trieu phu bong da ", "Trieuphu_Sub", userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "3000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Trieu phu bong da", "Trieuphu_Sub", userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "2000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Trieu phu bong da", "Trieuphu_Sub", userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "1000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Trieu phu bong da", "Trieuphu_Sub", userName, userPass, cpId);
}
}
}
if (returnValue == "1")
{
#region Sinh MDT
string code1 = RandomActiveCode.Generate(8);
string code2 = RandomActiveCode.Generate(8);
ViSport_S2_Registered_UsersController.SportGameHeroLotteryCodeInsert(msisdn, code1);
ViSport_S2_Registered_UsersController.SportGameHeroLotteryCodeInsert(msisdn, code2);
#endregion
#region LOG DOANH THU
var logInfo = new SportGameHeroChargedUserLogInfo();
logInfo.ID = ConvertUtility.ToInt32(dtUsers.Rows[i]["ID"].ToString());
logInfo.User_ID = dtUsers.Rows[i]["User_ID"].ToString();
logInfo.Request_ID = dtUsers.Rows[i]["Request_ID"].ToString();
logInfo.Service_ID = dtUsers.Rows[i]["Service_ID"].ToString();
logInfo.Command_Code = dtUsers.Rows[i]["Command_Code"].ToString();
logInfo.Service_Type = ConvertUtility.ToInt32(dtUsers.Rows[i]["Service_Type"].ToString());
logInfo.Charging_Count = ConvertUtility.ToInt32(dtUsers.Rows[i]["Charging_Count"].ToString());
logInfo.FailedChargingTime = ConvertUtility.ToInt32(dtUsers.Rows[i]["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = ConvertUtility.ToDateTime(dtUsers.Rows[i]["RegisteredTime"].ToString());
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = dtUsers.Rows[i]["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(dtUsers.Rows[i]["Status"].ToString());
logInfo.Operator = dtUsers.Rows[i]["Operator"].ToString();
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Reason = "Succ";
ViSport_S2_Registered_UsersController.InsertSportGameHeroChargedUserLogForSub(logInfo);
#endregion
}
else
{
#region LOG DOANH THU
var logInfo = new SportGameHeroChargedUserLogInfo();
logInfo.ID = ConvertUtility.ToInt32(dtUsers.Rows[i]["ID"].ToString());
logInfo.User_ID = dtUsers.Rows[i]["User_ID"].ToString();
logInfo.Request_ID = dtUsers.Rows[i]["Request_ID"].ToString();
logInfo.Service_ID = dtUsers.Rows[i]["Service_ID"].ToString();
logInfo.Command_Code = dtUsers.Rows[i]["Command_Code"].ToString();
logInfo.Service_Type = ConvertUtility.ToInt32(dtUsers.Rows[i]["Service_Type"].ToString());
logInfo.Charging_Count = ConvertUtility.ToInt32(dtUsers.Rows[i]["Charging_Count"].ToString());
logInfo.FailedChargingTime = ConvertUtility.ToInt32(dtUsers.Rows[i]["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = ConvertUtility.ToDateTime(dtUsers.Rows[i]["RegisteredTime"].ToString());
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = dtUsers.Rows[i]["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(dtUsers.Rows[i]["Status"].ToString());
logInfo.Operator = dtUsers.Rows[i]["Operator"].ToString();
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Reason = returnValue;
ViSport_S2_Registered_UsersController.InsertSportGameHeroChargedUserLogForSub(logInfo);
#endregion
}
if (returnValue == "1")//CHARGED THANH CONG
{
string today = DateTime.Now.DayOfWeek.ToString();
string serviceId = dtUsers.Rows[i]["Service_ID"].ToString();
string commandCode = dtUsers.Rows[i]["Command_Code"].ToString();
string requestId = dtUsers.Rows[i]["Request_ID"].ToString();
if (CheckDayOfWeek(today)) //Tra MT vao cac ngay 3,5,7
{
#region SEND MT THONG_TIN_TRAN_DAU
DataTable dtMtFootball = ViSport_S2_Registered_UsersController.SportGameHeroMatchGetByDay();
if (dtMtFootball != null && dtMtFootball.Rows.Count > 0)
{
string teamA = UnicodeUtility.UnicodeToKoDau(dtMtFootball.Rows[0]["Team_A_Name"].ToString());
string teamB = UnicodeUtility.UnicodeToKoDau(dtMtFootball.Rows[0]["Team_B_Name"].ToString());
string message1 = "Tran dau du doan ngay hom nay la: " + teamA + " va " + teamB + ". De du doan " + teamA + " thang soan KQ 1, du doan " + teamB + " thang soan KQ 3, du doan 2 doi hoa soan KQ 2 gui 979";
SendMtSportGame(dtUsers.Rows[i]["User_ID"].ToString(), message1, serviceId, commandCode, requestId); //MT1
string message2 = "De du doan tong so ban thang soan BT G gui 979 (voi G la tong so ban thang 2 doi ghi trong thoi gian thi dau chinh thuc)";
SendMtSportGame(dtUsers.Rows[i]["User_ID"].ToString(), message2, serviceId, commandCode, requestId); //MT2
string message3 = "De du doan ti so trong thoi gian chinh thuc soan TS A B gui 979 trong do A la so ban thang doi " + teamA + " ghi duoc, B la so ban thang doi " + teamB + " ghi duoc.";
SendMtSportGame(dtUsers.Rows[i]["User_ID"].ToString(), message3, serviceId, commandCode, requestId); //MT3
string message4 = "De du doan " + teamA + " co ti le giu bong nhieu hon soan GB 1, du doan " + teamB + " co ti le giu bong nhieu hon soan GB 3, hai doi co ti le giu bong ngang nhau soan GB 2 gui 979";
SendMtSportGame(dtUsers.Rows[i]["User_ID"].ToString(), message4, serviceId, commandCode, requestId); //MT4
string message5 = "De du doan tong so the vang soan TV C gui 979 trong do C la tong so the vang trong tai rut ra cho 2 doi trong thoi gian thi dau chinh thuc ";
SendMtSportGame(dtUsers.Rows[i]["User_ID"].ToString(), message5, serviceId, commandCode, requestId); //MT5
}
#endregion
}
else //Tra Cau hoi vao cac ngay 2,4,6,CN
{
#region SEND MT CAU_HOI_BONG_DA
//SEND MT CHO KHACH HANG
DataTable dtQuestion = ViSport_S2_Registered_UsersController.GetQuestionInfoSportGameHero();
if (dtQuestion != null && dtQuestion.Rows.Count > 0)
{
message = dtQuestion.Rows[0]["Question"].ToString();
message = message.Replace("P1", "1").Replace("P2", "2");
int questionIdnew = ConvertUtility.ToInt32(dtQuestion.Rows[0]["Id"].ToString());
string answer = dtQuestion.Rows[0]["Answer"].ToString();
answer = answer.Replace("P1", "1").Replace("P2", "2");
ViSport_S2_Registered_UsersController.InsertSportGameHeroAnswerLog(dtUsers.Rows[i]["User_ID"].ToString(), questionIdnew, message, answer, DateTime.Now, 0); // LUU LOG Question
SendMtSportGame(dtUsers.Rows[i]["User_ID"].ToString(), message, serviceId, commandCode, requestId);
}
//END SEND MT CHO KHACH HANG
#endregion
}
}
#endregion
count = count + 1;
}
catch (Exception ex)
{
log.Error("Trieu phu bong da Loi charged : " + ex);
}
}
}
return(1);
}
catch (Exception ex)
{
log.Error("Trieu phu bong da Loi lay tap User : " + ex);
return(0);
}
}
public int Execute(int jobId)
{
try
{
int PartnerID = 89;
DataTable dtPartner = ViSport_S2_Registered_UsersController.PartnerInfo(PartnerID);
if (dtPartner != null && dtPartner.Rows.Count > 0)
{
int SubViettel_PartnerID = ConvertUtility.ToInt32(dtPartner.Rows[0]["SubViettel_PartnerID"].ToString());
//int partnerId = ConvertUtility.ToInt32(dtPartner.Rows[0]["PartnerId"].ToString());
string folderName = dtPartner.Rows[0]["FolderName"].ToString();
//folderName = "~/Sam_Cdr"; //Forder for re push CDR
if (!Directory.Exists(Server.MapPath(folderName)))
{
Directory.CreateDirectory(Server.MapPath(folderName));
}
var csv = new StringBuilder();
DateTime dataDate = DateTime.Today.AddDays(-1);
string filePath = Server.MapPath(folderName + "/vmg_dn_vn_" + dataDate.Year + "" + dataDate.Month + "" + dataDate.Day + ".csv");
csv.AppendLine("Type"
+ "," + "TelcoCode"
+ "," + "ServiceName"
+ "," + "ShortCode"
+ "," + "Msisdn"
+ "," + "Unique_id"
+ "," + "Price"
+ "," + "ChargedStatus"
+ "," + "Detail"
+ "," + " Created");
#region GPC
DataTable dtGpc = ViSport_S2_Registered_UsersController.CdrGpc_ByPartnerID(PartnerID);
if (dtGpc != null && dtGpc.Rows.Count > 0)
{
foreach (DataRow dr in dtGpc.Rows)
{
//var contentId = !string.IsNullOrEmpty(dr["Unique_Id"].ToString()) ? dr["Unique_Id"].ToString()
// : ViSport_S2_Registered_UsersController.SamGetContentId(dr["Register_Syntax"].ToString());
//string contentId = "";
//DataTable dtContent = ViSport_S2_Registered_UsersController.CdrGpcSam_GetContentId_ByUserID(dr["msisdn"].ToString());
//if (dtContent != null && dtContent.Rows.Count > 0)
//{
// contentId = dtContent.Rows[0]["ContentId"].ToString();
//}
string contentId = string.Empty;
csv.AppendLine("SUB"
+ "," + "Gpc"
+ "," + dr["Service_Name"]
+ "," + dr["shortCode"]
+ "," + dr["msisdn"]
+ "," + contentId
+ "," + dr["cost"]
+ "," + "1"
+ "," + "Succ"
+ "," + dr["TimeStamp"]);
}
}
#endregion
#region VMS
DataTable dtVms = ViSport_S2_Registered_UsersController.CdrVms_ByPartnerID(PartnerID);
if (dtVms != null && dtVms.Rows.Count > 0)
{
const string shortCode = "8979";
foreach (DataRow dr in dtVms.Rows)
{
//var contentId = !string.IsNullOrEmpty(dr["Unique_Id"].ToString()) ? dr["Unique_Id"].ToString()
// : ViSport_S2_Registered_UsersController.SamGetContentId(dr["Register_Systax"].ToString());
//string contentId = "";
//DataTable dtContent = ViSport_S2_Registered_UsersController.CdrGpcSam_GetContentId_ByUserID(dr["msisdn"].ToString());
//if (dtContent != null && dtContent.Rows.Count > 0)
//{
// contentId = dtContent.Rows[0]["ContentId"].ToString();
//}
string contentId = string.Empty;
csv.AppendLine("SUB"
+ "," + "Vms"
+ "," + dr["Service_Name"]
+ "," + shortCode
+ "," + dr["msisdn"]
+ "," + contentId
+ "," + dr["cost"]
+ "," + dr["ChargeResult"]
+ "," + " "
+ "," + dr["TimeStamp"]);
}
File.WriteAllText(filePath, csv.ToString());
}
#endregion
#region VNM
DataTable dtVnm = ViSport_S2_Registered_UsersController.CdrVnm(PartnerID);
if (dtVnm != null && dtVnm.Rows.Count > 0)
{
foreach (DataRow dr in dtVnm.Rows)
{
//string contentId = ViSport_S2_Registered_UsersController.SamGetContentId(dr["Register_Syntax"].ToString());
string contentId = "";
DataTable dtContent = ViSport_S2_Registered_UsersController.CdrGpcSam_GetContentId_ByUserID(dr["User_Id"].ToString());
if (dtContent != null && dtContent.Rows.Count > 0)
{
contentId = dtContent.Rows[0]["ContentId"].ToString();
}
csv.AppendLine("SUB"
+ "," + "Vnm"
+ "," + dr["Product_Name"]
+ "," + dr["shortCode"]
+ "," + dr["User_Id"]
+ "," + contentId
+ "," + dr["Charging_Price"]
+ "," + dr["Charging_Status"]
+ "," + dr["Charging_Response"]
+ "," + ConvertUtility.ToDateTime(dr["Charging_Time"]));
}
File.WriteAllText(filePath, csv.ToString());
}
#endregion
#region VNM 1119
DataTable dtVnm1119 = ViSport_S2_Registered_UsersController.CdrVnm1119(PartnerID);
if (dtVnm1119 != null && dtVnm1119.Rows.Count > 0)
{
foreach (DataRow dr in dtVnm1119.Rows)
{
//string contentId =ViSport_S2_Registered_UsersController.SamGetContentId(dr["SubscriptionKeyword"].ToString());
string contentId = "";
DataTable dtContent = ViSport_S2_Registered_UsersController.CdrGpcSam_GetContentId_ByUserID(dr["User_Id"].ToString());
if (dtContent != null && dtContent.Rows.Count > 0)
{
contentId = dtContent.Rows[0]["ContentId"].ToString();
}
csv.AppendLine("SUB"
+ "," + "Vnm"
+ "," + dr["Product_Name"]
+ "," + dr["shortCode"]
+ "," + dr["User_Id"]
+ "," + contentId
+ "," + dr["Charging_Price"]
+ "," + dr["Charging_Status"]
+ "," + dr["Charging_Response"]
+ "," + ConvertUtility.ToDateTime(dr["Charging_Time"]));
}
File.WriteAllText(filePath, csv.ToString());
}
#endregion
#region VIETTEL SUB 9029
DataTable dtViettel = ViSport_S2_Registered_UsersController.CdrViettel9029(SubViettel_PartnerID);
if (dtViettel != null && dtViettel.Rows.Count > 0)
{
foreach (DataRow dr in dtViettel.Rows)
{
//string contentId = ViSport_S2_Registered_UsersController.SamGetContentId(dr["Register_Syntax"].ToString());
string contentId = "";
//DataTable dtContent = ViSport_S2_Registered_UsersController.CdrGpcSam_GetContentId_ByUserID(dr["User_Id"].ToString());
//if (dtContent != null && dtContent.Rows.Count > 0)
//{
// contentId = dtContent.Rows[0]["ContentId"].ToString();
//}
csv.AppendLine("SUB"
+ "," + "Viettel"
+ "," + dr["Product_Name"]
+ "," + dr["shortCode"]
+ "," + dr["User_Id"]
+ "," + contentId
+ "," + dr["Charging_Price"]
+ "," + dr["Charging_Status"]
+ "," + dr["Charging_Response"]
+ "," + ConvertUtility.ToDateTime(dr["Charging_Time"]));
}
File.WriteAllText(filePath, csv.ToString());
}
#endregion
_log.Debug("Imobi CDR - jobID :" + jobId);
}
}
catch (Exception ex)
{
_log.Error("Imobi CDR Error : " + ex);
return(0);
}
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 int Execute(int jobID)
{
//log.Error(" ");
//log.Error("****Game Thanh Nu Sub Error******");
//log.Error("LOG Start");
//log.Error("**********");
//log.Error(" ");
//return 1;
WebServiceCharging3g webServiceCharging3G = new WebServiceCharging3g();
vn.thanhnu.Service partnerService = new vn.thanhnu.Service();
string userName = "******";
string passWord = "******";
string cpId = "1937";
try
{
DataTable dtUser = ViSport_S2_Registered_UsersController.ThanhNuGameGetUserByType();
if (dtUser != null && dtUser.Rows.Count > 0)
{
string message = string.Empty;
string partnerResult = string.Empty;
int price = 1000;
foreach (DataRow dr in dtUser.Rows)
{
string vnmChargedResult = webServiceCharging3G.PaymentVnmWithAccount(dr["User_ID"].ToString(), "1000", "Charged Sub Thanh Nu", "Thanh_Nu_Sub", userName, passWord, cpId);
if (vnmChargedResult == "1")//CHARGED THANH CONG
{
partnerResult = partnerService.smsGiaHan(dr["User_ID"].ToString(), "1");
if (partnerResult.Trim() == "1")
{
message = "Goi dich vu Game Thanh Nu cua Quy Khach da duoc gia han thanh cong. Quy khach duoc cong 110 G_Coin vao tk. Cam on Quy Khach da su dung goi dich vu .";
SendMtThanhNu(dr["User_ID"].ToString(), message, dr["Service_ID"].ToString(), dr["Command_Code"].ToString(), dr["Request_ID"].ToString());
}
}
else
{
partnerResult = partnerService.smsGiaHan(dr["User_ID"].ToString(), "0");
if (partnerResult == "1")// CHARGED G_Coint thanh cong
{
message = "Quy Khach da gia han thanh cong Game Thanh Nu";
price = 0;
vnmChargedResult = "1";
}
else if (partnerResult == "0")
{
message = "Tk cua Quy Khach khong du de gia han Game Thanh Nu ";
}
SendMtThanhNu(dr["User_ID"].ToString(), message, dr["Service_ID"].ToString(), dr["Command_Code"].ToString(), dr["Request_ID"].ToString());
}
//LOG DOANH THU
var e = new ThanhNuChargedUserLogInfo();
e.ID = ConvertUtility.ToInt32(dr["ID"].ToString());
e.User_ID = dr["User_ID"].ToString();
e.Request_ID = dr["Request_ID"].ToString();
e.Service_ID = dr["Service_ID"].ToString();
e.Command_Code = dr["Command_Code"].ToString();
e.Service_Type = 0;
e.Charging_Count = 0;
e.FailedChargingTime = 0;
e.RegisteredTime = DateTime.Now;
e.ExpiredTime = DateTime.Now.AddDays(1);
e.Registration_Channel = "SMS";
e.Status = 1;
e.Operator = "vnmobile";
if (vnmChargedResult == "1")
{
e.Reason = "Succ";
}
else
{
e.Reason = vnmChargedResult;
}
e.Price = price;
e.PartnerResult = partnerResult;
ViSport_S2_Registered_UsersController.ThanhNuChargedUserLog(e);
}
}
return(1);
}
catch (Exception ex)
{
log.Error(" ");
log.Error("****Game Thanh Nu Sub Error******");
log.Error(ex.ToString());
log.Error("**********");
log.Error(" ");
return(0);
}
}
public string SyncSubscriptionData(string ShortCode, string CommandCode, string UserID, string Message, string RequestID, string ServiceID, string RefID, string UpdateType, string UpdateDescription)
{
try
{
#region HUY DICH VU
log.Debug(" ");
log.Debug(" ");
log.Debug("-------------------- BIG PROMOTION DELETE-------------------------");
log.Debug("User_ID: " + UserID);
log.Debug("Service_ID: " + ServiceID);
log.Debug("Command_Code: " + CommandCode);
log.Debug("Message: " + Message.ToUpper());
log.Debug("Request_ID: " + RequestID);
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 -------------------------");
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 -------------------------");
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, Message.ToUpper(), "0", "472", "0", "0", "HUY GOI");
log.Debug(" ");
log.Debug(" ");
log.Debug("-------------------- BIG PROMOTION ringToneRes DELETE -------------------------");
log.Debug("User_ID: " + UserID);
log.Debug("ringToneRest: " + ringToneRest);
log.Debug(" ");
log.Debug(" ");
#endregion
SendMtThanhNu(UserID, message, "949", CommandCode, RequestID);
}
else if (dt.Rows[0]["RETURN_ID"].ToString() == "0")
{
message = "Ban chua dang ky dich vu nay. De dang ky dich vu soan tin GOI gui 949";
SendMtThanhNu(UserID, message, ServiceID, CommandCode, RequestID);
}
#endregion
}
catch (Exception ex)
{
log.Error("Loi Huy GOI 949 : " + ex);
return("-1");
}
return("-1");
}
public int Execute(int jobID)
{
WebServiceCharging3g webServiceCharging3G = new WebServiceCharging3g();
string userName = "******";
string userPass = "******";
string cpId = "1930";
string price;
try
{
DataTable dtUsers = ViSport_S2_Registered_UsersController.GetSportGameHeroUserInfo("841864925596");
if (dtUsers != null && dtUsers.Rows.Count > 0)
{
string message = string.Empty;
string returnValue = string.Empty;
string notEnoughMoney = AppEnv.GetSetting("NotEnoughMoney");
string serviceType = "Charge Hero";
string serviceName = "ViSport_Hero";
string reasonLog = string.Empty;
for (int i = 0; i < dtUsers.Rows.Count; i++)
{
try
{
#region TIEN HANH CHARGED
price = "5000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Anh Tai", "Anh_Tai_Sub", userName, userPass, cpId);
if (returnValue == "1")
{
#region LOG DOANH THU
var logInfo = new SportGameHeroChargedUserLogInfo();
logInfo.ID = ConvertUtility.ToInt32(dtUsers.Rows[i]["ID"].ToString());
logInfo.User_ID = dtUsers.Rows[i]["User_ID"].ToString();
logInfo.Request_ID = dtUsers.Rows[i]["Request_ID"].ToString();
logInfo.Service_ID = dtUsers.Rows[i]["Service_ID"].ToString();
logInfo.Command_Code = dtUsers.Rows[i]["Command_Code"].ToString();
logInfo.Service_Type = ConvertUtility.ToInt32(dtUsers.Rows[i]["Service_Type"].ToString());
logInfo.Charging_Count = ConvertUtility.ToInt32(dtUsers.Rows[i]["Charging_Count"].ToString());
logInfo.FailedChargingTime = ConvertUtility.ToInt32(dtUsers.Rows[i]["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = ConvertUtility.ToDateTime(dtUsers.Rows[i]["RegisteredTime"].ToString());
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = dtUsers.Rows[i]["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(dtUsers.Rows[i]["Status"].ToString());
logInfo.Operator = dtUsers.Rows[i]["Operator"].ToString();
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Reason = "Succ";
ViSport_S2_Registered_UsersController.InsertSportGameHeroChargedUserLogForSub(logInfo);
#endregion
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Anh Tai", "Anh_Tai_Sub", userName, userPass, cpId);
if (returnValue == "1")
{
#region LOG DOANH THU
var logInfo1 = new SportGameHeroChargedUserLogInfo();
logInfo1.ID = ConvertUtility.ToInt32(dtUsers.Rows[i]["ID"].ToString());
logInfo1.User_ID = dtUsers.Rows[i]["User_ID"].ToString();
logInfo1.Request_ID = dtUsers.Rows[i]["Request_ID"].ToString();
logInfo1.Service_ID = dtUsers.Rows[i]["Service_ID"].ToString();
logInfo1.Command_Code = dtUsers.Rows[i]["Command_Code"].ToString();
logInfo1.Service_Type = ConvertUtility.ToInt32(dtUsers.Rows[i]["Service_Type"].ToString());
logInfo1.Charging_Count = ConvertUtility.ToInt32(dtUsers.Rows[i]["Charging_Count"].ToString());
logInfo1.FailedChargingTime = ConvertUtility.ToInt32(dtUsers.Rows[i]["FailedChargingTimes"].ToString());
logInfo1.RegisteredTime = ConvertUtility.ToDateTime(dtUsers.Rows[i]["RegisteredTime"].ToString());
logInfo1.ExpiredTime = DateTime.Now.AddDays(1);
logInfo1.Registration_Channel = dtUsers.Rows[i]["Registration_Channel"].ToString();
logInfo1.Status = ConvertUtility.ToInt32(dtUsers.Rows[i]["Status"].ToString());
logInfo1.Operator = dtUsers.Rows[i]["Operator"].ToString();
logInfo1.Price = ConvertUtility.ToInt32(price);
logInfo1.Reason = "Succ";
ViSport_S2_Registered_UsersController.InsertSportGameHeroChargedUserLogForSub(logInfo1);
#endregion
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Anh Tai", "Anh_Tai_Sub", userName, userPass, cpId);
if (returnValue == "1")
{
#region LOG DOANH THU
var logInfo2 = new SportGameHeroChargedUserLogInfo();
logInfo2.ID = ConvertUtility.ToInt32(dtUsers.Rows[i]["ID"].ToString());
logInfo2.User_ID = dtUsers.Rows[i]["User_ID"].ToString();
logInfo2.Request_ID = dtUsers.Rows[i]["Request_ID"].ToString();
logInfo2.Service_ID = dtUsers.Rows[i]["Service_ID"].ToString();
logInfo2.Command_Code = dtUsers.Rows[i]["Command_Code"].ToString();
logInfo2.Service_Type = ConvertUtility.ToInt32(dtUsers.Rows[i]["Service_Type"].ToString());
logInfo2.Charging_Count = ConvertUtility.ToInt32(dtUsers.Rows[i]["Charging_Count"].ToString());
logInfo2.FailedChargingTime = ConvertUtility.ToInt32(dtUsers.Rows[i]["FailedChargingTimes"].ToString());
logInfo2.RegisteredTime = ConvertUtility.ToDateTime(dtUsers.Rows[i]["RegisteredTime"].ToString());
logInfo2.ExpiredTime = DateTime.Now.AddDays(1);
logInfo2.Registration_Channel = dtUsers.Rows[i]["Registration_Channel"].ToString();
logInfo2.Status = ConvertUtility.ToInt32(dtUsers.Rows[i]["Status"].ToString());
logInfo2.Operator = dtUsers.Rows[i]["Operator"].ToString();
logInfo2.Price = ConvertUtility.ToInt32(price);
logInfo2.Reason = "Succ";
ViSport_S2_Registered_UsersController.InsertSportGameHeroChargedUserLogForSub(logInfo2);
#endregion
}
}
}
if (returnValue != "1")
{
#region LOG DOANH THU
var logInfo = new SportGameHeroChargedUserLogInfo();
logInfo.ID = ConvertUtility.ToInt32(dtUsers.Rows[i]["ID"].ToString());
logInfo.User_ID = dtUsers.Rows[i]["User_ID"].ToString();
logInfo.Request_ID = dtUsers.Rows[i]["Request_ID"].ToString();
logInfo.Service_ID = dtUsers.Rows[i]["Service_ID"].ToString();
logInfo.Command_Code = dtUsers.Rows[i]["Command_Code"].ToString();
logInfo.Service_Type = ConvertUtility.ToInt32(dtUsers.Rows[i]["Service_Type"].ToString());
logInfo.Charging_Count = ConvertUtility.ToInt32(dtUsers.Rows[i]["Charging_Count"].ToString());
logInfo.FailedChargingTime = ConvertUtility.ToInt32(dtUsers.Rows[i]["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = ConvertUtility.ToDateTime(dtUsers.Rows[i]["RegisteredTime"].ToString());
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = dtUsers.Rows[i]["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(dtUsers.Rows[i]["Status"].ToString());
logInfo.Operator = dtUsers.Rows[i]["Operator"].ToString();
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Reason = returnValue;
ViSport_S2_Registered_UsersController.InsertSportGameHeroChargedUserLogForSub(logInfo);
#endregion
}
if (returnValue == "1")//CHARGED THANH CONG
{
//reasonLog = "Succ";
//SEND MT CHO KHACH HANG
//DataTable dtQuestion = ViSport_S2_Registered_UsersController.GetQuestionInfoSportGameHero();
//if (dtQuestion != null && dtQuestion.Rows.Count > 0)
//{
message = "Ban da duoc cong 960 diem cho game show Anh tai bong da.Soan DIEM gui 979 de xem so diem hien tai.";
string serviceId = dtUsers.Rows[i]["Service_ID"].ToString();
string commandCode = dtUsers.Rows[i]["Command_Code"].ToString();
string requestId = dtUsers.Rows[i]["Request_ID"].ToString();
SendMtSportGame(dtUsers.Rows[i]["User_ID"].ToString(), message, serviceId, commandCode, requestId);
//}
//END SEND MT CHO KHACH HANG
}
//else
//{
// reasonLog = returnValue;
//}
#endregion
}
catch (Exception ex)
{
log.Error("Anh tai bong da Loi charged : " + ex);
continue;
}
//DataTable dt = new DataTable();
//dt = ViSport_S2_Registered_UsersController.SportGameHeroCheckUserChargedByDay(dtUsers.Rows[i]["User_ID"].ToString());
//if (dt.Rows[0]["RETURN_ID"].ToString().Trim() == "0")
//{
//}
}
}
return(1);
}
catch (Exception ex)
{
log.Error("Anh tai bong da Loi lay tap User : " + ex);
return(0);
}
}
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";
}
public int Execute(int jobId)
{
WebServiceCharging3g webServiceCharging3G = new WebServiceCharging3g();
string userName = "******";
string userPass = "******";
string cpId = "1930";
string price = "4000";
try
{
DataTable dtUsers = ViSport_S2_Registered_UsersController.GetSportGameUserByType(false);
if (dtUsers != null && dtUsers.Rows.Count > 0)
{
string message = string.Empty;
string returnValue = string.Empty;
string notEnoughMoney = AppEnv.GetSetting("NotEnoughMoney");
string serviceType = "Charge Hero";
string serviceName = "ViSport_Hero";
string reasonLog = string.Empty;
for (int i = 0; i < dtUsers.Rows.Count; i++)
{
try
{
#region TIEN HANH CHARGED
price = "5000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Anh Tai", "Anh_Tai_Sub", userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "3000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Anh Tai", "Anh_Tai_Sub", userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "2000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Anh Tai", "Anh_Tai_Sub", userName, userPass, cpId);
if (returnValue.Trim() == notEnoughMoney)
{
price = "1000";
returnValue = webServiceCharging3G.PaymentVnmWithAccount(dtUsers.Rows[i]["User_ID"].ToString(), price, "Charged Sub Anh Tai", "Anh_Tai_Sub", userName, userPass, cpId);
}
}
}
if (returnValue == "1")
{
#region LOG DOANH THU
var logInfo = new SportGameHeroChargedUserLogInfo();
logInfo.ID = ConvertUtility.ToInt32(dtUsers.Rows[i]["ID"].ToString());
logInfo.User_ID = dtUsers.Rows[i]["User_ID"].ToString();
logInfo.Request_ID = dtUsers.Rows[i]["Request_ID"].ToString();
logInfo.Service_ID = dtUsers.Rows[i]["Service_ID"].ToString();
logInfo.Command_Code = dtUsers.Rows[i]["Command_Code"].ToString();
logInfo.Service_Type = ConvertUtility.ToInt32(dtUsers.Rows[i]["Service_Type"].ToString());
logInfo.Charging_Count = ConvertUtility.ToInt32(dtUsers.Rows[i]["Charging_Count"].ToString());
logInfo.FailedChargingTime = ConvertUtility.ToInt32(dtUsers.Rows[i]["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = ConvertUtility.ToDateTime(dtUsers.Rows[i]["RegisteredTime"].ToString());
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = dtUsers.Rows[i]["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(dtUsers.Rows[i]["Status"].ToString());
logInfo.Operator = dtUsers.Rows[i]["Operator"].ToString();
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Reason = "Succ";
ViSport_S2_Registered_UsersController.InsertSportGameHeroChargedUserLogForSub(logInfo);
#endregion
}
else
{
#region LOG DOANH THU
var logInfo = new SportGameHeroChargedUserLogInfo();
logInfo.ID = ConvertUtility.ToInt32(dtUsers.Rows[i]["ID"].ToString());
logInfo.User_ID = dtUsers.Rows[i]["User_ID"].ToString();
logInfo.Request_ID = dtUsers.Rows[i]["Request_ID"].ToString();
logInfo.Service_ID = dtUsers.Rows[i]["Service_ID"].ToString();
logInfo.Command_Code = dtUsers.Rows[i]["Command_Code"].ToString();
logInfo.Service_Type = ConvertUtility.ToInt32(dtUsers.Rows[i]["Service_Type"].ToString());
logInfo.Charging_Count = ConvertUtility.ToInt32(dtUsers.Rows[i]["Charging_Count"].ToString());
logInfo.FailedChargingTime = ConvertUtility.ToInt32(dtUsers.Rows[i]["FailedChargingTimes"].ToString());
logInfo.RegisteredTime = ConvertUtility.ToDateTime(dtUsers.Rows[i]["RegisteredTime"].ToString());
logInfo.ExpiredTime = DateTime.Now.AddDays(1);
logInfo.Registration_Channel = dtUsers.Rows[i]["Registration_Channel"].ToString();
logInfo.Status = ConvertUtility.ToInt32(dtUsers.Rows[i]["Status"].ToString());
logInfo.Operator = dtUsers.Rows[i]["Operator"].ToString();
logInfo.Price = ConvertUtility.ToInt32(price);
logInfo.Reason = returnValue;
ViSport_S2_Registered_UsersController.InsertSportGameHeroChargedUserLogForSub(logInfo);
#endregion
}
if (returnValue == "1")//CHARGED THANH CONG
{
#region SEND MT CHO USER
//SEND MT CHO KHACH HANG
DataTable dtQuestion = ViSport_S2_Registered_UsersController.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();
string serviceId = dtUsers.Rows[i]["Service_ID"].ToString();
string commandCode = dtUsers.Rows[i]["Command_Code"].ToString();
string requestId = dtUsers.Rows[i]["Request_ID"].ToString();
ViSport_S2_Registered_UsersController.InsertSportGameHeroAnswerLog(dtUsers.Rows[i]["User_ID"].ToString(), questionIdnew, message, answer, DateTime.Now, 0); // LUU LOG Question
SendMtSportGame(dtUsers.Rows[i]["User_ID"].ToString(), message, serviceId, commandCode, requestId);
}
//END SEND MT CHO KHACH HANG
#endregion
}
#endregion
}
catch (Exception ex)
{
log.Error("Anh tai bong da Loi charged : " + ex);
continue;
}
}
}
return(1);
}
catch (Exception ex)
{
log.Error("Anh tai bong da Loi lay tap User : " + ex);
return(0);
}
}