/// <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);
}
