protected void btnSearch_Click(object sender, EventArgs e)
{
int GroupId = Convert.ToInt32(ddlGroup.SelectedValue);
int Month = Convert.ToInt32(ddlMonth.SelectedValue);
int Year = Convert.ToInt32(ddlYear.SelectedValue);
BusinessLayer.SMS.DoctorsSMSTrigger objDoc = new BusinessLayer.SMS.DoctorsSMSTrigger();
DataTable dtdoc = new DataTable();
dtdoc = objDoc.GetAll(GroupId, Month, Year);
if (dtdoc != null)
{
dlReport.DataSource = dtdoc;
dlReport.DataBind();
}
}
private void SendSMS()
{
BusinessLayer.SMS.ApiConfiguration ObjApi = new BusinessLayer.SMS.ApiConfiguration();
DataTable dt = ObjApi.GetAll();
DataView DV = new DataView(dt);
DV.RowFilter = "IsActive = 1";
string API = string.Empty;
API_INDEX = Convert.ToString(DV[0]["SMSAPIId"]);
try
{
string mobiles = "";
string message = "";
string strUrl;
string dataString;
message = txtMsg.Text.Trim();
mobiles = txtMobNo.Text.Trim();
int MobNoCount = 0;
if (mobiles.Length > 0)
{
string[] Arrmob = mobiles.Trim().Split(',');
MobNoCount = Arrmob.Length;//How many nos are sending for SMS
mobiles = "";
for (int index = 0; index < Arrmob.Length; index++)
{
if (Arrmob[index].Length == 10)
{
mobiles += "91" + Arrmob[index].Trim() + ";";
}
else if (Arrmob[index].Length == 12)
{
mobiles += Arrmob[index].Trim() + ";";
}
}
mobiles = mobiles.Trim().Substring(0, mobiles.Length - 1).Trim();
}
//------------------------------------
if (message.Length > 0)
{
if (mobiles.Length == 0)//Then fetch mobile numbers from Database
{
DataTable dtDB = getMobileNumbers(Convert.ToInt32(ddlGroup.SelectedValue));
MobNoCount = dtDB.Rows.Count;//How many nos are sending for SMS
int counter = 0;
foreach (DataRow dr in dtDB.Rows)
{
mobiles += "91" + dr["MobileNo"].ToString() + ";";
counter++;
if (counter == MobNoCount)
{
mobiles = mobiles.Trim().Substring(0, mobiles.Length - 1);
counter = 0;
}
}
}
int Credit = Convert.ToInt32(txtCredit.Text);
int TotalCredit = Credit * MobNoCount;
strUrl = GetHTTPAPI(mobiles, message);
WebRequest request1 = HttpWebRequest.Create(strUrl);
HttpWebResponse response1 = (HttpWebResponse)request1.GetResponse();
Stream s1 = (Stream)response1.GetResponseStream();
StreamReader readStream1 = new StreamReader(s1);
dataString = readStream1.ReadToEnd();
response1.Close();
s1.Close();
readStream1.Close();
BusinessLayer.SMS.DoctorsSMSTrigger ObjDocSMSTrigger = new BusinessLayer.SMS.DoctorsSMSTrigger();
Entity.SMS.DoctorsSMSTrigger docEntity = new Entity.SMS.DoctorsSMSTrigger();
if (MobNoCount > 0)
{
docEntity.DoctorsSMSTriggerId = 0;
docEntity.Username = Session["UserId"].ToString();
docEntity.GroupId = Convert.ToInt32(ddlGroup.SelectedValue);
docEntity.NoofTrigger = TotalCredit;
docEntity.MessageBody = txtMsg.Text.ToString();
ObjDocSMSTrigger.Save(docEntity);
lblMsg.Text = "<h2>Message send successfully</h2>";
Hidden1.Value = "1";
btnSendSMS.Style.Add("display", "none");
}
}
}
catch (Exception ex)
{
lblMsg.Text = "<h2>Error: " + ex.Message + "</h2>";
}
}
