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