public int Execute(int jobID) { try { DataTable dt = PublicController.LuckyfoneGetLuckyUser(); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { #region SEND MT var mtInfo = new MTInfo(); var random = new Random(); mtInfo.User_ID = dr["User_Id"].ToString(); mtInfo.Service_ID = dr["Service_Id"].ToString(); mtInfo.Command_Code = dr["Command_Code"].ToString(); mtInfo.Message_Type = 0; mtInfo.Request_ID = random.Next(100000000, 999999999).ToString(); mtInfo.Total_Message = 1; mtInfo.Message_Index = 0; mtInfo.IsMore = 0; mtInfo.Content_Type = 0; string msisdn = dr["True_User_Id"].ToString(); if (msisdn.Length > 10) { msisdn = msisdn.Substring(0, msisdn.Length - 2) + "xx"; } else { msisdn = msisdn.Substring(0, msisdn.Length - 1) + "x"; } mtInfo.Message = "Chuc mung thue bao " + msisdn + " da nhan duoc LOC may man dau nam cua 997 tri gia 200.000d. Soan: XS <ma tinh> gui 997 de tiep tuc nhan co hoi may man"; PublicController.SmsMtInsertNew(mtInfo); PublicController.LuckyfoneMtInsert(dr["User_Id"].ToString(), mtInfo.Request_ID, dr["Service_Id"].ToString(), dr["Command_Code"].ToString(), mtInfo.Message, dr["Mobile_Operator"].ToString()); #endregion } } } catch (Exception ex) { _log.Debug("Exception GetLuckyUser : " + ex); } return(1); }
public static void SmsMtInsertNew(MTInfo obj) { SqlHelper.ExecuteNonQuery(AppEnv.ConnectionString, "SMS_MT_Insert", obj.User_ID, obj.Message, obj.Service_ID, obj.Command_Code, obj.Message_Type, obj.Request_ID, obj.Total_Message, obj.Message_Index, obj.IsMore, obj.Content_Type, obj.ServiceType, obj.PartnerID, obj.Operator); }