/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lnk_setup_Click(object sender, EventArgs e) { st = "insert into tbl_hoteldetails(hotel_name,sub_title,admin_emailid,password,hotel_address) output inserted.hotel_id values('" + txt_hotelname.Text + "','" + txt_subtittle.Text + "','" + txt_emailid.Text + "','" + txt_pwd.Text + "','" + txt_address.Text + "')"; int x = db.return_affectedID(st); if (x > 0) { st = "insert into tbl_admin(emailid,admin_password,is_superadmin,is_active,created_by) output inserted.admin_id values('" + txt_emailid.Text + "','" + txt_pwd.Text + "',1,1,0)"; Session["admin_id"] = db.return_affectedID(st); Response.Redirect("default.aspx"); } }
/// <summary> /// Save the selected song to the database, songs will be saved in songs folder in project with random name /// </summary> protected void lnk_save_Click(object sender, EventArgs e) { if (fu_songs.HasFile) { string ext = Path.GetExtension(fu_songs.PostedFile.FileName).ToLower(); if (ext == ".mp3") { string filepath = ""; filepath = Guid.NewGuid().ToString() + ext; fu_songs.SaveAs(Server.MapPath("~/songs/") + filepath); st = "insert into tbl_songs (song_name,song_url) output inserted.song_id values('" + txt_name.Text + "','" + filepath + "')"; int song_id = db.return_affectedID(st); if (song_id > 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "", "showalert('success','Song added successfully.');", true); fill_data(); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "", "showalert('error','Only MP3 files allowed.');", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "", "showalert('error','Please select file to upload.');", true); } }