string sendNationalOTP(string mobile, string otp) { //Smsjust Provider //GlobalFuns.SendSMSOnAdd(mobile, otp + " is your one time password(OTP). Please enter the OTP to proceed. Thank you," + System.Environment.NewLine + "Team ROW"); GlobalFuns.SendSMSOnAdd(mobile, @"<%23> " + otp + " is your one time password(OTP). Please enter your OTP to proceed." + System.Environment.NewLine + "Thank you, Team chakiat" + System.Environment.NewLine + "G2sqeNpT3wC"); //MVaayoo Provider //GlobalFuns.SendAlertSMS(mobile, otp + " is your one time password(OTP). Please enter the OTP to proceed. Thank you, Team ROW"); return("true"); }
public static int SendSMSAndMailToNonSubmitedReports(ClubMonthlyReport_Input Obj) { try { MySqlParameter[] param = new MySqlParameter[3]; param[0] = new MySqlParameter("?p_groupId", Obj.groupId); param[1] = new MySqlParameter("?p_month", Obj.month); param[2] = new MySqlParameter("?p_type", Obj.type); DataSet Result = MySqlHelper.ExecuteDataset(GlobalVar.strAppConn, CommandType.StoredProcedure, "USP_API_SendSMSAndMailToNonSubmitedReports", param); int smsEmailflag = 0; string month = CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(Convert.ToInt32(Obj.month.Substring(0, 2))); string Year = Obj.month.Substring(3, 4); #region SMS sending if (Obj.type == "1") { DataTable dtMobile = Result.Tables[0]; if (dtMobile.Rows.Count > 0) { int TotalMobileNumberCount = 0; int CurrentSMScount = GetBalanceSMS(Obj.groupId.ToString()); string MobileNumberIndia = ""; int MobileNumberCount = 0; foreach (DataRow row in dtMobile.Rows) { string[] values = row["member_mobile_no"].ToString().Split(','); TotalMobileNumberCount = TotalMobileNumberCount + values.Length; } if (TotalMobileNumberCount < CurrentSMScount) { foreach (DataRow row in dtMobile.Rows) { string[] values = row["member_mobile_no"].ToString().Split(','); if (row["country_code"].ToString() == "+91" && row["member_mobile_no"].ToString() != "")//for India { MobileNumberIndia += row["member_mobile_no"].ToString() + ","; MobileNumberCount = MobileNumberCount + values.Length; } else//for International SMS { if (row["member_mobile_no"].ToString() != "")//for India { if ((GlobalFuns.SendSMSInternational(row["member_mobile_no"].ToString(), "Dear Rtn," + Environment.NewLine + "The monthly report for your club for the month of " + month + " " + Year + " has not been submitted.", row["country_code"].ToString())) == "SMS Send SuccessFully") { UpdateInternationalSMSCount(Obj.groupId.ToString()); smsEmailflag = 1; } } } } if (MobileNumberIndia != "") { MobileNumberIndia = MobileNumberIndia.TrimEnd(','); if ((GlobalFuns.SendSMSOnAdd(MobileNumberIndia + ",9763128181,9821130855", "Dear Club leader," + Environment.NewLine + "The monthly report of your club for " + month + " " + Year + " has not been submitted. Please submit it through www.rosteronwheels.com" + Environment.NewLine + " District Governor.")) == true) { UpdateAllSMSCount(Obj.groupId.ToString(), MobileNumberCount); smsEmailflag = 1; } } } } } #endregion #region send email if (Obj.type == "2") { DataTable dtEmail = Result.Tables[0]; if (dtEmail.Rows.Count > 0) { if (dtEmail.Rows.Count > 0) { string MailList = dtEmail.Rows[0]["member_email_id"].ToString(); if (MailList == "") { MailList += "[email protected],[email protected]";// } else { MailList += ",[email protected],[email protected]";//,[email protected] } if (MailList != "") { MailList = MailList.TrimEnd(','); GlobalFuns.SendEmail(ConfigurationManager.AppSettings["frommail"].ToString(), MailList.Trim().ToString(), "Club Monthly Report not Submitted", msgbody(month + " " + Year)); } } } } #endregion return(smsEmailflag); } catch (Exception ex) { throw ex; } }