/// <summary> /// On page load dispaly all the tables which are open for order /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { st = "select tablenumber,order_id from tbl_orders where isClosed=0 "; db.fill_rptr_ret_sqlda(st, rpt_tables); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { st = "select tablenumber,order_id,amount from tbl_orders where isClosed=0 "; db.fill_rptr_ret_sqlda(st, rpt_tables); st = "exec [dbo].[CreatePlayList]"; DataTable dt = db.get_datatable(st); rpt_playlist.DataSource = dt; rpt_playlist.DataBind(); } }
protected void LinkButton1_Click(object sender, EventArgs e) { st = "Select * from TimeSlots"; db.fill_rptr_ret_sqlda(st, rpt); foreach (RepeaterItem item in rpt.Items) { LinkButton lnkTime = (LinkButton)item.FindControl("lnkTime"); //string datetime = txtDate.Text + " " + lnkTime.Text; HtmlGenericControl divslot = (HtmlGenericControl)item.FindControl("divslot"); st = "Select * from Appointment where date='" + txt_date.Text + "' and Time='" + lnkTime.Text + "' and DoctId=" + docid + " "; dr = db.readall(st); if (dr.Read()) { lnkTime.Enabled = false; lnkTime.ForeColor = System.Drawing.Color.White; divslot.Attributes.Add("class", "divslotBooked"); dr.Dispose(); } else { lnkTime.Enabled = true; lnkTime.ForeColor = System.Drawing.Color.White; divslot.Attributes.Add("class", "divslotBook"); dr.Dispose(); } } }
/// <summary> /// Selects all the themes from table /// </summary> private void fill_data() { st = "select * from tbl_themes"; db.fill_rptr_ret_sqlda(st, rpt_items); st = "select theme_id,theme_name,is_active from tbl_themes"; DataTable dt = new DataTable(); dt = db.get_datatable(st); ddl_themes.DataSource = dt; ddl_themes.DataTextField = "theme_name"; ddl_themes.DataValueField = "theme_id"; ddl_themes.DataBind(); bool isThemeSet = false; foreach (DataRow dr in dt.Rows) { if (dr["is_active"].ToString() == "True" || dr["is_active"].ToString() == "1") { ddl_themes.SelectedValue = dr["theme_id"].ToString(); isThemeSet = true; break; } } if (!isThemeSet) { ddl_themes.Items.Insert(0, "Select theme"); ddl_themes.SelectedIndex = 0; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Customer"] != null) { id = Convert.ToInt16(Request.QueryString["id"].ToString()); st = "select * from hall where id=" + id + ""; dt = db.get_datatable(st); if (dt.Rows.Count > 0) { cat = dt.Rows[0]["area"].ToString(); } db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } string s = "select * from hall inner join booking on hall.id=booking.hall_id where hall.id=" + id + ""; db.fill_rptr_ret_sqlda(s, dd_rpt); if (dd_rpt.Items.Count > 0) { panel2.Visible = true; } else { panel2.Visible = false; } if (!IsPostBack) { fill(); } } else { Response.Redirect("../Login.aspx"); } }
/// <summary> /// Select all items from database and show in repeater control /// </summary> private void fill_data() { st = @"SELECT [item_id],[item_name],[price], [item_image],[item_desc],[qty],tbl_items.[added_by], case tbl_items.is_active when 1 then 'true' else 'false' End is_active, category_name FROM [dbo].[tbl_items] inner join tbl_category on tbl_items.category_id = tbl_category.category_id"; db.fill_rptr_ret_sqlda(st, rpt_items); }
protected void fill_repeater() { st = "select * from SelectedRessume"; db.fill_rptr_ret_sqlda(st, rpt_student); if (rpt_student.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } }
protected void fill_repeater() { st = "select student_id,fullname from student where dept='" + dd_dept.Text + "' and sem='" + dd_sem.Text + "'"; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } }
protected void fill_repeater() { st = "Select * from Appointment where DoctId=" + Session["Doctor"] + ""; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { owner_pnl.Visible = true; } else { owner_pnl.Visible = false; } }
protected void fill_repeater() { st = "select * from Subjects where dept='" + dd_dept.Text + "' and sem=" + dd_sem.Text + ""; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } }
protected void fill_repeater() { st = "select * from treatment where p_id=" + Session["Patient"] + ""; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { owner_pnl.Visible = true; } else { owner_pnl.Visible = false; } }
protected void fill_repeater() { st = "select * from Faculty"; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } }
public void fill_repeater() { st = "select * from booking where customer_id=" + Session["customer"] + ""; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } }
public void fill_repeater() { st = "select * from placement"; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } }
protected void fill_repeater() { st = "select * from hall"; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { owner_pnl.Visible = true; } else { owner_pnl.Visible = false; } }
protected void fill_repeater() { st = "select * from assignment where dept='" + Session["dept"] + "' and subject=" + sub + " and sem=" + Session["sem"] + ""; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["student"] == null) { Response.Redirect("../Default.aspx"); } else { st = "select * from subjects where sem=" + Session["sem"] + " and dept='" + Session["dept"] + "'"; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["owner"] == null) { Response.Redirect("../Login.aspx"); } else { st = "select * from hall where owner_id=" + Session["owner"] + ""; db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } } }
/// <summary> /// Page Load Event /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { st = "select top(1) image_url from tbl_themes where is_active = 1"; background = db.read_val(st); if (Request.Cookies["tableNumber"] != null) { st = "select order_id,amount from tbl_orders where tableNumber=" + Request.Cookies["tableNumber"].Value + " and isClosed=0"; SqlDataReader dr = db.readall(st); if (dr.Read()) { hf_orderid.Value = dr[0].ToString(); lnk_cart.Text = dr[1].ToString(); pnl_neworder.Visible = false; pnl_page.Visible = true; } else { ScriptManager.RegisterStartupScript(UpdatePanel3, UpdatePanel3.GetType(), "", "$('#processing-modal').modal('show');", true); pnl_neworder.Visible = true; pnl_page.Visible = false; } pnl_table.Visible = false; dr.Close(); } else { pnl_page.Visible = false; pnl_table.Visible = true; btn_neworder.Visible = false; } st = "select category_id,category_name from tbl_category where is_active=1"; db.fill_rptr_ret_sqlda(st, rpt_category); st = "SELECT [Combo_id],[title],[description],[price],[combo_picture] FROM [dbo].[tbl_combos]"; db.fill_rptr_ret_sqlda(st, rpt_combos); st = @"SELECT tbl_player.song_id,tbl_songs.song_name,tbl_songs.song_url,case is_playing when 1 then 'playing' else '' end as is_playing, case when is_requested =1 or is_playing = 1 then 'display:none' else '' end as is_requested from tbl_player inner join tbl_songs on tbl_player.song_id = tbl_songs.song_id where is_played = 0 and is_played=0 order by order_number,requested_time"; db.fill_rptr_ret_sqlda(st, rpt_playlist); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["Customer"] != null) { add = Request.QueryString["location"].ToString(); cat = Request.QueryString["category"].ToString(); st = "select * from hall where area = " + add + " and category =" + cat + ""; /* dt = db.get_datatable(st); * if (dt.Rows.Count > 0) * { * string ur = "~/Image/"; * Image1.ImageUrl = ur + dt.Rows[0]["image"].ToString(); * name.Text = dt.Rows[0]["hall_name"].ToString(); * Label1.Text = dt.Rows[0]["owner_name"].ToString(); * Label2.Text = dt.Rows[0]["address"].ToString(); * * } * else * { * Label3.Text = "Such Hall Not Found"; * }*/ db.fill_rptr_ret_sqlda(st, Repeater1); if (Repeater1.Items.Count > 0) { pnl_rpt.Visible = true; } else { pnl_rpt.Visible = false; } } else { Response.Redirect("../Login.aspx"); } }
/// <summary> /// Select all the songs from database and display in repeater /// </summary> private void fill_data() { st = "select * from tbl_songs"; db.fill_rptr_ret_sqlda(st, rpt_items); }
/// <summary> /// Selects the categories and display with the status /// </summary> private void fill_data() { st = "SELECT [category_id],[category_name],[category_image],[description],[added_by],case is_active when 1 then 'Active' else 'Inactive' End is_active FROM [tbl_category]"; db.fill_rptr_ret_sqlda(st, rpt_categories); }
/// <summary> /// Method to select combos added and display in Repeater control /// </summary> private void fill_data() { st = "select * from tbl_combos"; db.fill_rptr_ret_sqlda(st, rpt_combos); }
public void fill_repeater() { st = "select * from feature where hall_id= " + Request.QueryString["id"] + ""; db.fill_rptr_ret_sqlda(st, Repeater4); }