public void SendSmsVoid(object data) { ISmsWebService smsWebService = new ISmsWebService(); SmsData smsData = (SmsData)data; smsWebService.SendSms(smsData.body, smsData.phoneNumber); }
public void Execute(IJobExecutionContext contect) { var timeFormat = new DateTimeFormatInfo { ShortTimePattern = CultureInfo.CurrentCulture.DateTimeFormat.ShortTimePattern, AMDesignator = "AM", PMDesignator = "PM" }; IList <NegotioationSms> list = new List <NegotioationSms>(); var con = ConfigurationManager.ConnectionStrings["SamanCnn"].ToString(); using (var myConnection = new SqlConnection(con)) { string query = "Select t1.ADSLPhone,t1.FirstName,t1.LastName,t2.NegotiationTime,t3.Title,t4.Mobile,t4.EmployeeID from Cus.Customer t1 Inner Join Lead.Negotiation t2 on t1.CustomerID=t2.CustomerID inner join Lead.LeadTitleTemplate t3 on t2.LeadTitleTemplateID=t3.LeadTitleTemplateID inner join emp.employee t4 on t2.ReferedEmployeeID=t4.EmployeeID where t2.RememberTime='" + DateTime.Now.ToString("t", timeFormat) + "' and t2.NegotiationDate='" + PersianDateTime.Now.Substring(0, 10) + "' and SendSms=1"; var oCmd = new SqlCommand(query, myConnection); myConnection.Open(); using (SqlDataReader drd = oCmd.ExecuteReader()) { while (drd.Read()) { list.Add(new NegotioationSms() { ADSLPhone = drd["ADSLPhone"].ToString(), EmployeeID = Guid.Parse(drd["EmployeeID"].ToString()), FirstName = drd["FirstName"].ToString(), LastName = drd["LastName"].ToString(), Mobile = drd["Mobile"].ToString(), NegotationTime = drd["NegotiationTime"].ToString(), Title = drd["Title"].ToString() }); } } ISmsWebService smsService = new ISmsWebService(); foreach (var item in list) { var i = smsService.SendSms( string.Format("همکار گرامی , کاربر شماره {0} در ساعت {1} منتظر تماس و پیگیری شماست", item.ADSLPhone, item.NegotationTime), item.Mobile); //string path = System.Web.Hosting.HostingEnvironment.MapPath("~/Data/Log.txt"); //using (StreamWriter sw = new StreamWriter(path, true)) //{ // sw.WriteLine(item.NegotationTime + DateTime.Now.ToString("t", timeFormat) + " " + item.Mobile + " " + i); //} } } }
public void Execute(IJobExecutionContext contect) { var timeFormat = new DateTimeFormatInfo { ShortTimePattern = CultureInfo.CurrentCulture.DateTimeFormat.ShortTimePattern, AMDesignator = "AM", PMDesignator = "PM" }; var con = ConfigurationManager.ConnectionStrings["SamanCnn"].ToString(); using (var myConnection = new SqlConnection(con)) { string query = "select t1.ToDoTitle,t1.t2.Mobile, from cus.Task where "; var oCmd = new SqlCommand(query, myConnection); myConnection.Open(); using (SqlDataReader drd = oCmd.ExecuteReader()) { while (drd.Read()) { ISmsWebService smsService = new ISmsWebService(); } } } }