private void BindRepeater()
{
try
{
EnquiryData edata = new EnquiryData();
DataSet ds = edata.getEnquiryData("select * from enquiry ");
RpViewEnquiry.DataSource = ds;
RpViewEnquiry.DataBind();
}
catch (Exception ex) { }
}
protected void btnEnquirySubmit_Click(object sender, EventArgs e)
{
EnquiryData edata = new EnquiryData();
edata.Name = txtName.Text;
edata.Mobile = txtmobile.Text;
edata.Email = txtEmail.Text;
edata.Courses = ddlCourses.SelectedValue;
edata.Save();
Reset();
}
public void FillDropDownCheckBoxes()
{
string VisitUser = ddlCategory.SelectedValue.ToString();
DropDownCheckBoxes.Items.Clear();
if (VisitUser == "Visitor")
{
EnquiryData rdata = new EnquiryData();
DataSet ds = rdata.getEnquiryData("Select * from enquiry");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListItem item = new ListItem();
item.Text = ds.Tables[0].Rows[i]["name"].ToString();
item.Value = ds.Tables[0].Rows[i]["id"].ToString();
item.Selected = false;
DropDownCheckBoxes.Items.Add(item);
}
DropDownCheckBoxes.Items.Insert(0, new ListItem("All", "0"));
}
else
{
DropDownCheckBoxes.Items.Clear();
if (VisitUser == "Users")
{
UsersData rrdata = new UsersData();
DataSet ds = rrdata.getUsersData("Select * from users");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListItem item = new ListItem();
item.Text = ds.Tables[0].Rows[i]["name"].ToString();
item.Value = ds.Tables[0].Rows[i]["id"].ToString();
item.Selected = false;
DropDownCheckBoxes.Items.Add(item);
}
DropDownCheckBoxes.Items.Insert(0, new ListItem("All", "0"));
}
else
{
}
}
}
protected void btnSendSms_Click(object sender, EventArgs e)
{
foreach (ListItem item in DropDownCheckBoxes.Items)
{
if (item.Selected)
{
VisitUserId = int.Parse(item.Value.ToString());
string VisitUser = ddlCategory.SelectedValue.ToString();
if (VisitUser == "Visitor")
{
string index = DropDownCheckBoxes.SelectedIndex.ToString();
DataSet dsu;
if (DropDownCheckBoxes.SelectedIndex == 0)
{
for (int j = 1; j < DropDownCheckBoxes.Items.Count; j++)
{
DropDownCheckBoxes.Items[j].Enabled = false;
}
EnquiryData edata = new EnquiryData();
dsu = edata.getEnquiryData("select * from enquiry");
}
else
{
EnquiryData edata = new EnquiryData();
dsu = edata.getEnquiryData("select * from enquiry where id=" + VisitUserId);
}
string msg = txtMessege.Text;
for (int i = 0; i < dsu.Tables[0].Rows.Count; i++)
{
string name = dsu.Tables[0].Rows[i][1].ToString();
string mobile = dsu.Tables[0].Rows[i][2].ToString();
string cont = "Dear" + " name = " + name + "\n" + msg;
// sendMessage(cont, mobile);
}
Reset();
}
else
{
DataSet dsu;
if (DropDownCheckBoxes.SelectedIndex == 0)
{
UsersData udata = new UsersData();
dsu = udata.getUsersData("select * from users");
}
else
{
UsersData udata = new UsersData();
dsu = udata.getUsersData("select * from users where id = " + VisitUserId);
}
string msg = txtMessege.Text;
for (int i = 0; i < dsu.Tables[0].Rows.Count; i++)
{
string name = dsu.Tables[0].Rows[i][1].ToString();
string mobile = dsu.Tables[0].Rows[i][2].ToString();
string cont = "Dear" + " name = " + name + "\n" + msg;
//sendMessage(cont, mobile);
}
Reset();
}
}
else
{
}
}
}
