public Food_Reservation SelectByIdSingle(int resId) //get all reservations under an id from Reservation db and put into list { string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection myConn = new SqlConnection(DBConnect); string sqlStmt = "Select * from ReservationFood where reservationId = @paraId"; SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn); da.SelectCommand.Parameters.AddWithValue("@paraId", resId); DataSet ds = new DataSet(); da.Fill(ds); DataRow row = ds.Tables[0].Rows[0]; int id = int.Parse(row["reservationId"].ToString()); string name = row["reservationName"].ToString(); string date = row["reservationDate"].ToString(); string time = row["reservationTime"].ToString(); int pax = int.Parse(row["reservationPax"].ToString()); string state = row["reservationState"].ToString(); string qr = row["reservationQR"].ToString(); string image = row["reservationImage"].ToString(); Food_Reservation obj = new Food_Reservation(id, name, date, time, pax, state, qr, image); return(obj); }
protected void Page_Load(object sender, EventArgs e) { string resId = Request.QueryString["ResId"]; Food_Reservation ticket = new Food_Reservation(); ticket.CancelReservation(int.Parse(resId)); }
public List <Food_Reservation> SelectById(int resId) //get all reservations under an id from Reservation db and put into list { string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection myConn = new SqlConnection(DBConnect); string sqlStmt = "Select * from ReservationFood where userId = @paraId and reservationState = 'Active'"; SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn); da.SelectCommand.Parameters.AddWithValue("@paraId", resId); DataSet ds = new DataSet(); da.Fill(ds); List <Food_Reservation> empList = new List <Food_Reservation>(); int rec_cnt = ds.Tables[0].Rows.Count; for (int i = 0; i < rec_cnt; i++) { DataRow row = ds.Tables[0].Rows[i]; int id = int.Parse(row["reservationId"].ToString()); string name = row["reservationName"].ToString(); string date = row["reservationDate"].ToString(); string time = row["reservationTime"].ToString(); int pax = int.Parse(row["reservationPax"].ToString()); string state = row["reservationState"].ToString(); string qr = row["reservationQR"].ToString(); string image = row["reservationImage"].ToString(); Food_Reservation obj = new Food_Reservation(id, name, date, time, pax, state, qr, image); empList.Add(obj); } return(empList); }
protected void BtnConfirm_Click(object sender, EventArgs e) { Food_Reservation res = new Food_Reservation(); res = res.GetReservationByIdSingle(int.Parse(Session["ResId"].ToString())); res.CancelReservation(res.Id); Response.Redirect("List_Reservation_Food.aspx"); }
private void loadRepeater() { Food_Reservation res = new Food_Reservation(); resList = res.GetReservationById(int.Parse(Session["tourist_id"].ToString())); RepeaterReserves.DataSource = resList; RepeaterReserves.DataBind(); }
protected void DetailsRes(object source, RepeaterCommandEventArgs e) { RepeaterItem item1 = e.Item; Label resId = (Label)item1.FindControl("LbId"); Food_Reservation res = new Food_Reservation(); Session["ResId"] = resId.Text; Response.Redirect("Reservation_Food_QR.aspx"); }
protected void BtnConfirm_Click(object sender, EventArgs e) { if (Session["tourist_id"] == null && Session["tourguide_id"] == null) { Response.Redirect("Login.aspx"); } else { try { Label1.Text = Session["tourist_id"].ToString(); } catch (NullReferenceException) { Label1.Text = Session["tourguide_id"].ToString(); } Session["ResName"] = lbName.Text.ToString(); Session["ResLoc"] = lbPlace.Text.ToString(); Session["ResDate"] = tbDate.Text.ToString(); Session["ResTime"] = TbTime.Text.ToString(); Session["ResPax"] = TbPax.Text.ToString(); Random random = new Random(); //check whether a code exists already string code = random.Next(1000000, 9999999).ToString(); Food_Reservation res = new Food_Reservation(); List <String> codeList = res.GetQRCodesList(); while (true && codeList != null) { if (codeList.Contains(code)) { code = random.Next(1000000, 9999999).ToString(); } else { break; } } Food_Reservation td = new Food_Reservation(); td.InsertReservation(lbName.Text, tbDate.Text, TbTime.Text, int.Parse(TbPax.Text), int.Parse(Session["tourist_id"].ToString()), code, LbImg.Text); Response.Redirect("Reservation_Food_Confirmed.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["ResId"] != null) { string ResId = Session["ResId"].ToString(); // Retrieve TDMaster records by Id Food_Reservation td = new Food_Reservation(); td = td.GetReservationByIdSingle(int.Parse(ResId)); lbName.Text = td.Name; lbTiming.Text = td.Date + " | " + td.Time; lbPax.Text = td.Pax.ToString(); int reservationId = td.Id; string code = "touristhelp20200208080154.azurewebsites.net/Reservation_Food_QR_Claim.aspx?ResId=" + reservationId; QRCodeGenerator qrGenerator = new QRCodeGenerator(); QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.Q); System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image(); imgBarCode.Height = 150; imgBarCode.Width = 150; using (Bitmap bitMap = qrCode.GetGraphic(20)) { using (MemoryStream ms = new MemoryStream()) { bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png); byte[] byteImage = ms.ToArray(); imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage); } PlaceHolder1.Controls.Add(imgBarCode); } } else { Response.Redirect("List_Reservation_Food.aspx"); } if (Session["tourist_id"] == null && Session["tourguide_id"] == null) { BtnConfirm.Text = "Login to reserve"; BtnConfirm.CausesValidation = false; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Session["tourist_id"] == null && Session["tourguide_id"] == null) { Response.Redirect("Login.aspx"); } else { try { Label1.Text = Session["tourist_id"].ToString(); } catch (NullReferenceException) { Label1.Text = Session["tourguide_id"].ToString(); } } // to check for any expired reservationd Food_Reservation res = new Food_Reservation(); resList = res.GetReservationById(int.Parse(Session["tourist_id"].ToString())); for (int i = 0; i < resList.Count; i++) { DateTime currDate = DateTime.Today; if (DateTime.Parse(resList[i].Date) < currDate.Date) { res.CancelReservation(resList[i].Id); } } loadRepeater(); } //Michaels daily reward check, remove if causing error Session["user_id"] = Session["tourist_id"]; string user_id = Session["user_id"].ToString(); int userId = Convert.ToInt32(user_id); // Retrieve TDMaster records by account Reward td = new Reward(); td = td.GetRewardById(user_id); DateTime dateNow = DateTime.Now; //DateTime NextDayDate = dateNow.AddHours(24); if (td.loggedInLog == true && td.loggedInDate.Date != DateTime.Now.Date) { int loginCount = td.loginCount; int loginStreak = td.loginStreak; int creditBalance = td.creditBalance; bool renewLogIn = false; DateTime loggedInDate = td.loggedInDate; bool newDateCheck = false; int remainBonusDays = td.remainBonusDays; td.updateLoggedIn(userId, loginCount, loginStreak, creditBalance, remainBonusDays, renewLogIn, loggedInDate, newDateCheck); } if (td.loggedInLog == false) { int timeDifference = DateTime.Compare(td.loggedInDate, dateNow); if (dateNow.Subtract(td.loggedInDate) <= TimeSpan.FromHours(24)) { int loginCount = td.loginCount + 1; int loginStreak = td.loginStreak + 1; int creditBalance = td.creditBalance + 5; bool loggedInLog = true; DateTime loggedInDate = DateTime.Now; bool newDateCheck = true; int remainBonusDays = td.remainBonusDays - 1; td.updateLoggedIn(userId, loginCount, loginStreak, creditBalance, remainBonusDays, loggedInLog, loggedInDate, newDateCheck); if (loginStreak % 10 == 0) { creditBalance = td.creditBalance + td.bonusCredits + 5; remainBonusDays = td.remainBonusDays + 9; td.updateBonus(userId, loginStreak, creditBalance, remainBonusDays); } } else if (dateNow.Subtract(td.loggedInDate) > TimeSpan.FromHours(24)) { int loginCount = td.loginCount + 1; int loginStreak = 0; int creditBalance = td.creditBalance + 5; bool loggedInLog = true; DateTime loggedInDate = DateTime.Now; bool newDateCheck = true; int remainBonusDays = 10; td.updateLoggedIn(userId, loginCount, loginStreak, creditBalance, remainBonusDays, loggedInLog, loggedInDate, newDateCheck); } } if (td.loginCount == 100) { string loyaltyTier = "Gold"; int bonuscredits = 15; td.updateLoyaltyBonus(userId, loyaltyTier, bonuscredits); } if (td.loginCount == 200) { string loyaltyTier = "Diamond"; int bonuscredits = 20; td.updateLoyaltyBonus(userId, loyaltyTier, bonuscredits); } //Michaels daily reward check, remove if causing error }