public int Execute(int jobId)
{
try
{
DataTable dt = ViSport_S2_Registered_UsersController.GetQuestionInfoSportGameHero();
if (dt != null && dt.Rows.Count > 0)
{
var webServiceCharging3G = new WebServiceCharging3g();
string returnValue = webServiceCharging3G.PaymentVnmWithAccount("9999999", "1000", "Charged Sub Anh Tai", "Anh_Tai_Sub", "", "", "");
log.Error("****");
log.Error("****");
log.Error("163 Call 139 : Sucess");
log.Error("Call charging Service : " + returnValue);
log.Error("****");
log.Error("****");
}
}
catch (Exception ex)
{
log.Error("****");
log.Error("****");
log.Error("163 Call 139 : " + ex);
log.Error("****");
log.Error("****");
}
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.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 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 TRIEU_PHU_BONG_DA 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 Sinh MDT
string code1 = RandomActiveCode.Generate(8);
string code2 = RandomActiveCode.Generate(8);
ViSport_S2_Registered_UsersController.SportGameHeroLotteryCodeInsert(userId, code1);
ViSport_S2_Registered_UsersController.SportGameHeroLotteryCodeInsert(userId, code2);
#endregion
#region LOG DOANH THU
var logInfo = new SportGameHeroChargedUserLogInfo();
logInfo.ID = ConvertUtility.ToInt32(registeredId);
logInfo.User_ID = userId;
logInfo.Request_ID = requestId;
logInfo.Service_ID = serviceId;
logInfo.Command_Code = "TP";
logInfo.Service_Type = ConvertUtility.ToInt32(serviceType);
logInfo.Charging_Count = 0;
logInfo.FailedChargingTime = 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.InsertSportGameHeroChargedUserLogForSub(logInfo);
#endregion
}
else //CHARGED THAT BAI
{
#region LOG DOANH THU
var logInfo = new SportGameHeroChargedUserLogInfo();
logInfo.ID = ConvertUtility.ToInt32(registeredId);
logInfo.User_ID = userId;
logInfo.Request_ID = requestId;
logInfo.Service_ID = serviceId;
logInfo.Command_Code = "TP";
logInfo.Service_Type = ConvertUtility.ToInt32(serviceType);
logInfo.Charging_Count = 0;
logInfo.FailedChargingTime = 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.InsertSportGameHeroChargedUserLogForSub(logInfo);
#endregion
}
if (chargingResponse.Trim() == "1")
{
#region TRA MT
string today = DateTime.Now.DayOfWeek.ToString();
const string commandCode = "TP";
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(userId, 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(userId, 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(userId, 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(userId, 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(userId, 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)
{
string 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(userId, questionIdnew, message, answer, DateTime.Now, 0); // LUU LOG Question
SendMtSportGame(userId, message, serviceId, commandCode, requestId);
}
//END SEND MT CHO KHACH HANG
#endregion
}
#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);
}
}