/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Fetch the details of the event when it is triggered at scheduled time. if (Request.QueryString["id"] != null) { st = "SELECT tbl_events.event_title title, tbl_events.Message description, tbl_events.event_id, tbl_eventpictures.picture_url combo_picture FROM tbl_events INNER JOIN tbl_eventpictures ON tbl_events.event_id = tbl_eventpictures.event_id where tbl_events.event_id =" + Request.QueryString["id"].ToString(); DataTable dt = db.get_datatable(st); Repeater1.DataSource = dt; Repeater1.DataBind(); Repeater2.DataSource = dt; Repeater2.DataBind(); isevent.Value = "True"; } else { //Display yhe combo pictures from database and display in the hotel screen st = "SELECT [Combo_id] ,[title],[description],[price],'project_files/combos/'+[combo_picture] as combo_picture FROM tbl_combos"; DataTable dt = db.get_datatable(st); Repeater1.DataSource = dt; Repeater1.DataBind(); Repeater2.DataSource = dt; Repeater2.DataBind(); } } }
/// <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"); } }
public void details() { st = "Select * from hall where id=" + Request.QueryString["id"] + ""; dt = db.get_datatable(st); if (dt.Rows.Count > 0) { name.Text = dt.Rows[0]["owner_name"].ToString(); H_name.Text = dt.Rows[0]["hall_name"].ToString(); own_mob.Text = dt.Rows[0]["mobile"].ToString(); Hall_cat.Text = dt.Rows[0]["category"].ToString(); own_id = Convert.ToInt32(dt.Rows[0]["owner_id"].ToString()); } /*st = "select email from owner inner join hall on hall.owner_id=owner.id where hall.Id=" + Request.QueryString["id"] + " "; * db.get_datatable(st); * if (dt.Rows.Count > 0) * { * emailid = dt.Rows[0]["email"].ToString(); * }*/ }
public void fill_details() { st = "select * from patient where id=" + Request.QueryString["pid"].ToString() + ""; dt = db.get_datatable(st); if (dt.Rows.Count > 0) { txt_name.Text = dt.Rows[0]["name"].ToString(); txt_emailid.Text = dt.Rows[0]["email"].ToString(); txt_mobile.Text = dt.Rows[0]["mobile"].ToString(); txt_qual.Text = dt.Rows[0]["gender"].ToString(); } }
/// <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 Page_Load(object sender, EventArgs e) { add.Visible = false; pnl_up.Visible = false; if (Session["owner"] == null) { Response.Redirect("../login.aspx"); } else if (Request.QueryString["id"] != null) { string st = "select * from hall where id=" + Request.QueryString["id"] + ""; dt = db.get_datatable(st); if (dt.Rows.Count > 0) { search.Text = "Update"; txt_name.Text = dt.Rows[0]["hall_name"].ToString(); txt_owner.Text = dt.Rows[0]["owner_name"].ToString(); txt_address.Text = dt.Rows[0]["address"].ToString(); txt_area.Text = dt.Rows[0]["area"].ToString(); txt_desc.Text = dt.Rows[0]["desc"].ToString(); txt_mobile.Text = dt.Rows[0]["mobile"].ToString(); txt_price.Text = dt.Rows[0]["price"].ToString(); /* dd_ac.Text = dt.Rows[0]["ac"].ToString(); * dd_cat.Text = dt.Rows[0]["cat"].ToString(); * dd_decor.Text=dt.Rows[0]["decoration"].ToString(); * dd_food.Text = dt.Rows[0]["foodtype"].ToString(); * dd_hall.Text = dt.Rows[0]["category"].ToString(); * dd_photo.Text = dt.Rows[0]["photo"].ToString(); * dd_pro.Text = dt.Rows[0]["projector"].ToString(); * dd_range.Text = dt.Rows[0]["range"].ToString(); * dd_sound.Text = dt.Rows[0]["sound"].ToString();*/ fill_repeater(); pnl_up.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["student"] == null) { Response.Redirect("../Default.aspx"); } else { string str = "select Reg_number from Answers where Reg_number=" + Session["student"] + ""; dt = db.get_datatable(str); if (dt.Rows.Count > 0) { string j = dt.Rows[0]["Reg_number"].ToString(); string b = Session["student"].ToString(); if (j == b) { Response.Write("<script>alert('You have already attended Exam..');window.location.href ='dashboard.aspx' </script>"); } } } if (!Page.IsPostBack) { Session["timer"] = DateTime.Now.AddHours(1).ToString(); SqlConnection con = new System.Data.SqlClient.SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Admin\Documents\StudentIA.mdf;Integrated Security=True;Connect Timeout=30"); con.Open(); comm.Connection = con; comm.CommandText = "select distinct(dept) from questions"; SqlDataReader dr = comm.ExecuteReader(); DropDownList2.DataSource = dr; DropDownList2.DataTextField = "dept"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, new ListItem("--Select--", "0")); dr.Close(); comm.Connection = con; comm.CommandText = "select distinct(subject) from questions"; SqlDataReader drs = comm.ExecuteReader(); DropDownList1.DataSource = drs; DropDownList1.DataTextField = "subject"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, new ListItem("--Select--", "0")); /* btnTryAgain.Visible = false; * btnBackToHomePage.Visible = false;*/ } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lnk_login_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); st = "select admin_id,profile_pic,is_superadmin,offers_combos,inform_before_activate,item_details,admin_name from tbl_admin where emailid='" + txt_emailid.Text + "' and admin_password='******'"; dt = db.get_datatable(st); if (dt.Rows.Count > 0) { Session["admin_id"] = dt.Rows[0][0].ToString(); Adminlogin_details objAdminlogin_details = new Adminlogin_details(); objAdminlogin_details.inform_before_activate = Boolean.Parse(dt.Rows[0]["inform_before_activate"].ToString()); objAdminlogin_details.is_superadmin = Boolean.Parse(dt.Rows[0]["is_superadmin"].ToString()); objAdminlogin_details.item_details = Boolean.Parse(dt.Rows[0]["item_details"].ToString()); objAdminlogin_details.offers_combos = Boolean.Parse(dt.Rows[0]["offers_combos"].ToString()); objAdminlogin_details.profile_pic = dt.Rows[0]["profile_pic"].ToString(); objAdminlogin_details.fullname = dt.Rows[0]["admin_name"].ToString(); Session["Adminlogin_details"] = objAdminlogin_details; if (chk_remember.Checked) { Response.Cookies["OTA_emailid"].Value = txt_emailid.Text; Response.Cookies["QTA_password"].Value = txt_pwd.Text; Response.Cookies["OTA_emailid"].Expires = DateTime.Now.AddDays(30); Response.Cookies["QTA_password"].Expires = DateTime.Now.AddDays(30); } else { Response.Cookies["OTA_emailid"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["QTA_password"].Expires = DateTime.Now.AddDays(-1); } Response.Redirect("dashboard.aspx"); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "", "showalert('error','Login failed');", true); } }