protected void Button1_Click(object sender, EventArgs e) { if (Literal1.Text == "") { data1 dc = new data1(); var data = from tmp in dc.SystemTables where tmp.id == 1 select tmp; wedding_booking obj = new wedding_booking(); obj.booking_id = Convert.ToInt32(data.First().BookingId); obj.bridename = TextBox2.Text; obj.groomname = TextBox3.Text; obj.date = TextBox6.Text; obj.email = TextBox5.Text; obj.mobile = TextBox4.Text; obj.wedding_id = HiddenField1.Value; obj.time = DropDownList1.SelectedValue; obj.Status = "Booked"; dc.wedding_bookings.InsertOnSubmit(obj); data.First().BookingId = data.First().BookingId + 1; dc.SubmitChanges(); Session["bid"] = obj.booking_id; Session["amnt"] = Label2.Text; Session["date"] = TextBox6.Text; Session["time"] = DropDownList1.SelectedValue; Response.Redirect("~/Payment For.aspx"); } }
private void Print_Load(object sender, EventArgs e) { data1 ds = new data1(); SqlDataAdapter da = new SqlDataAdapter("select * from x", Program.cnx); CrystalReport1 cr = new CrystalReport1(); da.Fill(ds.x); cr.SetDataSource(ds); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh(); SqlDataAdapter sa = new SqlDataAdapter("select * from client", Program.cnx); DataTable dt = new DataTable(); sa.Fill(dt); foreach (DataRow item in dt.Rows) { clientx x = new clientx(); x.code = int.Parse(item[0].ToString()); x.nom = item[1].ToString(); comboBox1.Items.Add($"{x.code} {x.nom}"); walid.Add(x); } /* * Ds_stagiaire ods = new Ds_stagiaire(); * Cr_1stagiaire cr = new Cr_1stagiaire(); * da.Fill(ods, "Stagiaire"); * cr.SetDataSource(ods); * CRV_stagiaire.ReportSource = cr; * CRV_stagiaire.Refresh(); */ }
protected void Button2_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = -1; data1 dc = new data1(); var data = from tmp in dc.room_bookings where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select tmp; if (data.Count() != 0) { data.First().Status = "Cancelled"; dc.SubmitChanges(); goto z; } var data1 = from tmp in dc.spa_bookings where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select tmp; if (data1.Count() != 0) { data1.First().Status = "Cancelled"; dc.SubmitChanges(); goto z; } var data2 = from tmp in dc.ResturantBookingTables where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select tmp; if (data2.Count() != 0) { data2.First().Status = "Cancelled"; dc.SubmitChanges(); goto z; } var data3 = from tmp in dc.wedding_bookings where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select tmp; if (data3.Count() != 0) { data3.First().Status = "Cancelled"; dc.SubmitChanges(); goto z; } var data4 = from tmp in dc.MeetingBookingTables where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select tmp; if (data4.Count() != 0) { data4.First().Status = "Cancelled"; dc.SubmitChanges(); goto z; } var data5 = from tmp in dc.PackageBookingTables where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select tmp; if (data5.Count() != 0) { data5.First().Status = "Cancelled"; dc.SubmitChanges(); goto z; } Literal1.Text = "Please Check Your Booking No"; goto x; z : dc.SubmitChanges(); MultiView1.ActiveViewIndex = 1; x : TextBox1.Focus(); }
protected void Button1_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = -1; data1 dc = new data1(); var data = from tmp in dc.RoomViews where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select new { tmp.booking_id, tmp.roomtype, tmp.roomrent, tmp.noofrooms, tmp.date, tmp.name, tmp.mobile, tmp.email_id, tmp.Status }; if (data.Count() != 0) { GridView1.DataSource = data; MultiView1.ActiveViewIndex = 0; goto z; } var data1 = from tmp in dc.SPAViews where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select new { tmp.booking_id, tmp.spatype, tmp.priceofspa, tmp.date, tmp.name, tmp.mobile, tmp.email, tmp.Status }; if (data1.Count() != 0) { GridView1.DataSource = data1; MultiView1.ActiveViewIndex = 0; goto z; } var data2 = from tmp in dc.ResturantViews where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select new { tmp.booking_id, tmp.ResturantType, tmp.Price, tmp.date, tmp.name, tmp.mobile, tmp.email, tmp.Status }; if (data2.Count() != 0) { GridView1.DataSource = data2; MultiView1.ActiveViewIndex = 0; goto z; } var data3 = from tmp in dc.WeddingViews where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select new { tmp.booking_id, tmp.weddingtype, tmp.priceforveg, tmp.date, tmp.groomname, tmp.mobile, tmp.email, tmp.Status }; if (data3.Count() != 0) { GridView1.DataSource = data3; MultiView1.ActiveViewIndex = 0; goto z; } var data4 = from tmp in dc.MeetingViews where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select new { tmp.booking_id, tmp.event_type, tmp.Price, tmp.date, tmp.name, tmp.mobile, tmp.email, tmp.Status };; if (data4.Count() != 0) { GridView1.DataSource = data4; MultiView1.ActiveViewIndex = 0; goto z; } var data5 = from tmp in dc.PackageViews where tmp.booking_id == Convert.ToInt64(TextBox1.Text) select new { tmp.booking_id, tmp.PackageType, tmp.Price, tmp.date, tmp.name, tmp.mobile, tmp.email, tmp.Status };; if (data5.Count() != 0) { GridView1.DataSource = data5; MultiView1.ActiveViewIndex = 0; goto z; } Literal1.Text = "Please Check Your Booking No"; goto x; z : GridView1.DataBind(); Literal1.Text = ""; x : TextBox1.Focus(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { data1 ds = new data1(); SqlDataAdapter da = new SqlDataAdapter($"select * from x where Nom='{walid[comboBox1.SelectedIndex].nom}'", Program.cnx); CrystalReport1 cr = new CrystalReport1(); da.Fill(ds.x); cr.SetDataSource(ds); crystalReportViewer1.ReportSource = cr; crystalReportViewer1.Refresh(); }
protected void Page_Load(object sender, EventArgs e) { data1 dc = new data1(); var dat = from tmp in dc.wedding_types where tmp.weddingid == Convert.ToInt32(Request.QueryString["i"].ToString()) select tmp; if (dat.Count() != 0) { Label1.Text = dat.First().weddingtype; Label2.Text = dat.First().pricefornonveg; HiddenField1.Value = dat.First().weddingid.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { data1 dc = new data1(); var dat = from tmp in dc.ResturantTables where tmp.id == Convert.ToInt32(Request.QueryString["i"].ToString()) select tmp; if (dat.Count() != 0) { Label1.Text = dat.First().ResturantType; Label2.Text = dat.First().Price.ToString(); HiddenField1.Value = dat.First().id.ToString(); } }
public MH2O(char[] magic, byte[] size, byte[] content) : base(magic, size) { using (BinaryReader reader = new BinaryReader(new MemoryStream(content))) { for (int x = 0; x < 256; x++) { MH2O_Header hdr = new MH2O_Header(); hdr.Offset_attributes = reader.ReadUInt32(); hdr.Layer_count = reader.ReadUInt32(); hdr.Offset_instances = reader.ReadUInt32(); mH2O_Headers.Add(hdr); if (hdr.Layer_count > 0) { entriesWithLiquid++; } } for (int x = 0; x < entriesWithLiquid; x++) { data1 data = new data1(); data.Flags = reader.ReadUInt16(); data.Type = reader.ReadUInt16(); data.Height1 = reader.ReadSingle(); data.Height2 = reader.ReadSingle(); data.Xoff = reader.ReadByte(); data.Yoff = reader.ReadByte(); data.W = reader.ReadByte(); data.H = reader.ReadByte(); data.Of2a = reader.ReadUInt32(); data.Of2b = reader.ReadUInt32(); data1s.Add(data); } for (int x = 0; x < entriesWithLiquid; x++) { data2 data = new data2(); data.A = reader.ReadBytes(8); data.B = reader.ReadBytes(8); data2s.Add(data); } while (reader.BaseStream.Position < reader.BaseStream.Length) { rest.Add(reader.ReadByte()); //The remaining bytes we just leave bytes. I don't understand them and don't have to change them, lul. } } }
protected void Button1_Click(object sender, EventArgs e) { data1 dc = new data1(); var data = from tmp in dc.SystemTables where tmp.id == 1 select tmp; room_gallery_table obj = new room_gallery_table(); obj.roomid = Convert.ToInt16(DropDownList1.SelectedValue); obj.image = "~/Images/Room/" + data.First().ImageId + ".jpg"; obj.caption = TextBox3.Text; dc.room_gallery_tables.InsertOnSubmit(obj); data.First().ImageId = data.First().ImageId + 1; FileUpload1.SaveAs(Server.MapPath(obj.image)); dc.SubmitChanges(); }
protected void Page_Load(object sender, EventArgs e) { data1 dc = new data1(); var data = from tmp in dc.Meetings where tmp.id == Convert.ToInt16(Request.QueryString["i"]) select tmp; if (data.Count() != 0) { Image1.ImageUrl = data.First().image1; Image2.ImageUrl = data.First().image2; Image3.ImageUrl = data.First().image3; Image4.ImageUrl = data.First().image4; Image5.ImageUrl = data.First().image5; } }
protected void Button1_Click(object sender, EventArgs e) { data1 dc = new data1(); var data = from tmp in dc.SystemTables where tmp.id == 1 select tmp; spagallery obj = new spagallery(); obj.spaid = Convert.ToInt16(DropDownList1.Text); obj.image = "~/images/spa/" + data.First().ImageId + ".jpj"; obj.caption = TextBox1.Text; dc.spagalleries.InsertOnSubmit(obj); data.First().ImageId = data.First().ImageId + 1; FileUpload1.SaveAs(Server.MapPath(obj.image)); dc.SubmitChanges(); }
protected void Page_Load(object sender, EventArgs e) { string path = ""; if (!IsPostBack) { if (Session["amount"] == null) { path = Session["response"] + "?response=sessionErrorOccured"; Response.Write("<script>redirectz('" + path + "');</script>"); } } else { //name,cardNo, cvv, amount, paymentToName, paymentToaccountNo,response string pwds = pwd.Text; string name = Session["name"].ToString(); string cardNo = Session["cardNo"].ToString(); string cvv = Session["cvv"].ToString(); string amount = Session["amount"].ToString(); string paymentToaccountNo = Session["paymentToaccountNo"].ToString(); string remarkss = remarks.Text; data1 cs = new data1(); DataTable resultRow1 = cs.datatable("select * from tbl_accountDetails where transactionPassword='******' and name='" + name + "' and cardNo = '" + cardNo + "' and cvv = '" + cvv + "'"); if (resultRow1.Rows.Count > 0) { cs.execute("update tbl_accountDetails set balance= (balance - '" + amount + "') where transactionPassword='******' and name='" + name + "' and cardNo = '" + cardNo + "' and cvv = '" + cvv + "'"); cs.execute("update tbl_accountDetails set balance= (balance + '" + amount + "') where accountNo = '" + paymentToaccountNo + "'"); cs.execute("insert into tbl_transaction (fromAccountNo,toAccountNo,amount,remarks) values ((select accountNo from tbl_accountDetails where cardNo = '" + cardNo + "'),'" + paymentToaccountNo + "','" + amount + "','" + remarkss + "')"); Response.Write("<script>alert('Processing Payment')</script>"); Response.Redirect("bank2.aspx?status=paid"); } else { hfcount.Value = (int.Parse(hfcount.Value) - 1).ToString(); if (hfcount.Value == "0") { Response.Write("<script>alert('Incorrect Password: Maximum Tries over')</script>"); path = Session["response"] + "?response=incorrectCredentials"; Response.Write("<script>redirectz('" + path + "');</script>"); } else { Response.Write("<script>alert('Incorrect Password: You have " + hfcount.Value + " Chances Reamining')</script>"); } } } }
protected void Button1_Click(object sender, EventArgs e) { data1 dc = new data1(); var data = from tmp in dc.SystemTables where tmp.id == 1 select tmp; room_table obj = new room_table(); obj.roomtype = TextBox5.Text; obj.description = TextBox3.Text; obj.image = "~/Images/Room/" + data.First().ImageId + ".jpg"; obj.roomrent = TextBox4.Text; dc.room_tables.InsertOnSubmit(obj); data.First().ImageId = data.First().ImageId + 1; FileUpload1.SaveAs(Server.MapPath(obj.image)); dc.SubmitChanges(); }
protected void Button1_Click(object sender, EventArgs e) { data1 dc = new data1(); var data = from tmp in dc.SystemTables where tmp.id == 1 select tmp; spatharapy obj = new spatharapy(); obj.spatype = TextBox1.Text; obj.description = TextBox2.Text; obj.priceofspa = TextBox4.Text; obj.image = "~/images/spa/" + data.First().ImageId + ".jpj"; data.First().ImageId = data.First().ImageId + 1; dc.spatharapies.InsertOnSubmit(obj); FileUpload1.SaveAs(Server.MapPath(obj.image)); dc.SubmitChanges(); }
protected void Page_Load(object sender, EventArgs e) { data1 dc = new data1(); var data = from tmp in dc.wedding_galleries where tmp.Weddingid == Convert.ToInt16(Request.QueryString["i"]) select tmp; Queue ob = new Queue(); foreach (var d in data) { ob.Enqueue(d.image); } Image1.ImageUrl = ob.Dequeue().ToString(); Image2.ImageUrl = ob.Dequeue().ToString(); Image3.ImageUrl = ob.Dequeue().ToString(); Image4.ImageUrl = ob.Dequeue().ToString(); Image5.ImageUrl = ob.Dequeue().ToString(); }
protected void Button1_Click(object sender, EventArgs e) { data1 dc = new data1(); var data = from tmp in dc.SystemTables where tmp.id == 1 select tmp; wedding_type obj = new wedding_type(); obj.weddingtype = TextBox1.Text; obj.description1 = TextBox2.Text; obj.description2 = TextBox3.Text; obj.priceforveg = TextBox4.Text; obj.pricefornonveg = TextBox5.Text; obj.pricewithalcohol = TextBox6.Text; obj.image = "~/Images/Wedding/" + data.First().ImageId + ".jpg"; dc.wedding_types.InsertOnSubmit(obj); data.First().ImageId = data.First().ImageId + 1; dc.SubmitChanges(); }
protected void Button1_Click(object sender, EventArgs e) { if (Literal1.Text == "") { data1 dc = new data1(); payment obj = new payment(); obj.amount = Convert.ToInt32(Label2.Text); obj.booking_id = Convert.ToInt32(Label1.Text); obj.cardnumber = Convert.ToDecimal(TextBox1.Text); obj.cardtype = DropDownList1.SelectedValue; obj.expdate = TextBox3.Text; obj.nameoncard = TextBox2.Text; dc.payments.InsertOnSubmit(obj); dc.SubmitChanges(); MultiView1.ActiveViewIndex = 1; Label3.Text = Session["bid"].ToString(); Label4.Text = Session["date"].ToString(); Label5.Text = Session["time"].ToString(); } }
protected void Button1_Click(object sender, EventArgs e) { if (Literal1.Text == "") { data1 dc = new data1(); var data1 = from tmp in dc.room_bookings where tmp.date == TextBox1.Text select tmp; if (data1.Count() <= 20) { var data = from tmp in dc.SystemTables where tmp.id == 1 select tmp; room_booking obj = new room_booking(); obj.booking_id = Convert.ToInt32(data.First().BookingId); obj.age = Convert.ToInt16(TextBox5.Text); obj.city = TextBox6.Text; obj.date = TextBox1.Text; obj.email_id = TextBox4.Text; obj.gender = RadioButtonList1.SelectedValue; obj.mobile = Convert.ToDecimal(TextBox3.Text); obj.name = TextBox2.Text; obj.noofperson = Convert.ToInt16(DropDownList2.Text); obj.noofrooms = Convert.ToInt16(DropDownList1.SelectedValue); obj.room_id = Convert.ToInt32(HiddenField1.Value); obj.time = DropDownList3.SelectedValue; obj.idproof = "~/IdProof/" + obj.booking_id + ".jpg"; obj.Status = "Booked"; dc.room_bookings.InsertOnSubmit(obj); data.First().BookingId = data.First().BookingId + 1; FileUpload1.SaveAs(Server.MapPath(obj.idproof)); dc.SubmitChanges(); Session["bid"] = obj.booking_id; Session["amnt"] = Label4.Text; Session["date"] = TextBox1.Text; Session["time"] = DropDownList3.SelectedValue; Response.Redirect("~/Payment For.aspx"); } else { Literal1.Text = "Booking Full For The Selected Date, Kindly Choose Another Date"; } } }