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";
}
}
}
