private void BindRepeater() { try { EnquiryData edata = new EnquiryData(); DataSet ds = edata.getEnquiryData("select * from enquiry "); RpViewEnquiry.DataSource = ds; RpViewEnquiry.DataBind(); } catch (Exception ex) { } }
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 { } } }