protected void Button2_Click(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String fname = TextBox1.Text; String lname = TextBox2.Text; String addr = TextBox3.Text; String addr_proof = FileUpload1.PostedFile.FileName; String photo_id = FileUpload2.PostedFile.FileName; String phone = TextBox4.Text; String email = TextBox5.Text; String pword = TextBox6.Text; String alerts = RadioButtonList1.Text; String addrProofFolder = HttpContext.Current.Server.MapPath("~/Address ID"); String addrProofTarget = Path.Combine(addrProofFolder, addr_proof); FileUpload1.SaveAs(addrProofTarget); String photoProofFolder = HttpContext.Current.Server.MapPath("~/Photo ID"); String photoProofTarget = Path.Combine(photoProofFolder, photo_id); FileUpload2.SaveAs(photoProofTarget); String uname=Request.Cookies["Car-Trading"]["Username"].ToString(); DatabaseHandler obj = new DatabaseHandler(); obj.UpdateCustomerInfo(fname, lname, addr, addrProofTarget, photoProofTarget, phone, email, pword, alerts, uname); Response.Redirect("CustomerHome.aspx"); }
protected void Button2_Click(object sender, EventArgs e) { String bidAmount = TextBox1.Text; DatabaseHandler obj = new DatabaseHandler(); String auctionId = Session["auctionId"].ToString(); DataSet ds = obj.GetAuctionCarInfo(auctionId); int basePrice = Convert.ToInt32(ds.Tables[0].Rows[0]["CAR_BASE_PRICE"].ToString()); if (Convert.ToInt32(bidAmount) < basePrice) { Label9.Text = "Bid amount must be more than base price"; Label9.ForeColor = System.Drawing.ColorTranslator.FromHtml("#FF0000"); } else { obj.PlaceAuctionBid(Request.Cookies["Car-Trading"]["Username"].ToString(), bidAmount); DataSet ds1 = new DataSet(); DatabaseHandler obj1 = new DatabaseHandler(); ds1 = obj.GetAuctionBids(auctionId); GridView1.DataSource = ds1; GridView1.DataBind(); Panel1.Visible = false; Label9.Text = "Bid placed !"; Label9.ForeColor = System.Drawing.ColorTranslator.FromHtml("#00FF00"); } }
protected void Button2_Click(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String sellerName = TextBox1.Text; String sellerCountry = TextBox2.Text; String sellerCity = TextBox3.Text; String sellerStreet = TextBox4.Text; String sellerPhone = TextBox5.Text; String sellerEmail = TextBox6.Text; String sellerBankName = TextBox7.Text; String sellerBankAccountNum = TextBox8.Text; String sellerPassword = TextBox9.Text; String sellerIdProof = FileUpload1.PostedFile.FileName; String IdProofFolder = HttpContext.Current.Server.MapPath("~/Seller ID"); String IdProofTarget = Path.Combine(IdProofFolder, sellerIdProof); FileUpload1.SaveAs(IdProofTarget); String sellerId = Request.QueryString["sellerId"].ToString(); EncryptDecrypt obj = new EncryptDecrypt(); sellerId = obj.Decrypt(HttpUtility.UrlDecode(sellerId)); DatabaseHandler obj1 = new DatabaseHandler(); obj1.UpdateSellerInfo(sellerName, sellerCountry, sellerCity, sellerStreet, sellerPhone, sellerEmail, sellerIdProof, sellerBankName, sellerPhone, sellerPassword, sellerId); Response.Redirect("SellerHome.aspx?sellerId=" + Request.QueryString["sellerId"].ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String auctionId=Request.QueryString["auctionId"].ToString(); DatabaseHandler obj = new DatabaseHandler(); DataSet ds = obj.GetAuctionWinnerUsername(auctionId); if (ds == null) Label1.Text = "Auction not found or currently in progress"; else { Panel1.Visible = true; Label1.Text = "Auction No. " + auctionId; Label2.Text = ds.Tables[0].Rows[0]["WINNER_USERNAME"].ToString(); ds = obj.GetAuctionWinnerBid(Label2.Text); Label4.Text = ds.Tables[0].Rows[0]["CUSTOMER_BID_AMOUNT"].ToString(); ds = obj.GetAuctionCarInfo(auctionId); Label3.Text = ds.Tables[0].Rows[0]["CAR_BASE_PRICE"].ToString(); Label6.Text = ds.Tables[0].Rows[0]["CAR_BRAND"].ToString(); Label7.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NAME"].ToString(); Label8.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NUMBER"].ToString(); String sellerId=ds.Tables[0].Rows[0]["SELLER_ID"].ToString(); ds=obj.GetSellerName(sellerId); Label9.Text = ds.Tables[0].Rows[0]["SELLER_NAME"].ToString(); } }
protected void LinkButton2_Click(object sender, EventArgs e) { String brand = TextBox1.Text; String modelName = TextBox2.Text; String modelNum = TextBox3.Text; String carAvailableDate = TextBox4.Text; String frontImg = FileUpload1.PostedFile.FileName; String sideImg = FileUpload2.PostedFile.FileName; String rearImg = FileUpload3.PostedFile.FileName; String frontImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Front"); String frontImgTarget = Path.Combine(frontImgFolder, frontImg); FileUpload1.SaveAs(frontImgTarget); String sideImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Side"); String sideImgTarget = Path.Combine(sideImgFolder, sideImg); FileUpload2.SaveAs(sideImgTarget); String rearImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Rear"); String rearImgTarget = Path.Combine(rearImgFolder, rearImg); FileUpload3.SaveAs(rearImgTarget); DatabaseHandler obj = new DatabaseHandler(); obj.InsertUpcomingCar(brand, modelName, modelNum, frontImgTarget, sideImgTarget, rearImgTarget, carAvailableDate); Response.Write("Car Added"); TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); this.UnobtrusiveValidationMode = System.Web.UI.UnobtrusiveValidationMode.None; if (!IsPostBack) Wizard1.ActiveStepIndex = 0; Panel2.Visible = false; Panel3.Visible = false; String customerUsername = Request.Cookies["Car-Trading"]["Username"].ToString(); DatabaseHandler obj = new DatabaseHandler(); DataSet ds = obj.GetCustomerAddressPhone(customerUsername); String customerAddress = ds.Tables[0].Rows[0]["CUSTOMER_ADDRESS"].ToString(); Label1.Text = customerAddress; String carId = Request.QueryString["carId"].ToString(); String sellerId = Request.QueryString["sellerId"].ToString(); EncryptDecrypt obj1 = new EncryptDecrypt(); carId = obj1.Decrypt(HttpUtility.UrlDecode(carId)); sellerId = obj1.Decrypt(HttpUtility.UrlDecode(sellerId)); ds = obj.GetSellerName(sellerId); Label2.Text = ds.Tables[0].Rows[0]["SELLER_NAME"].ToString(); ds = obj.GetCarInfo(carId); Label3.Text = ds.Tables[0].Rows[0]["CAR_BRAND"].ToString(); Label4.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NAME"].ToString(); Label5.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NUMBER"].ToString(); Label6.Text = ds.Tables[0].Rows[0]["CAR_POSSESSION_TYPE"].ToString(); Label7.Text = ds.Tables[0].Rows[0]["CAR_PRICE"].ToString(); Label13.Text = Label2.Text; Label14.Text = Label7.Text; ImageButton1.ImageUrl = "~\\Car\\Front\\" + Path.GetFileName(ds.Tables[0].Rows[0]["CAR_FRONT_IMAGE"].ToString()); ImageButton1.Width = 150; ImageButton1.Height = 150; }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String sellerUsername = Request.Cookies["Car-Trading"]["Username"].ToString(); DatabaseHandler obj=new DatabaseHandler(); DataSet ds = obj.GetSellerId(sellerUsername); String sellerId = ds.Tables[0].Rows[0]["SELLER_ID"].ToString(); ds = obj.GetSellerAuctionInfo(sellerId); if (ds == null) Label8.Text = "You have no auction currently in progress"; else { Table1.Visible = true; Table2.Visible = true; Label1.Text = ds.Tables[0].Rows[0]["CAR_BRAND"].ToString(); Label2.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NAME"].ToString(); Label3.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NUMBER"].ToString(); Label4.Text = ds.Tables[0].Rows[0]["CAR_PRICE"].ToString(); Label5.Text = ds.Tables[0].Rows[0]["AUCTION_START_TIME"].ToString(); Label6.Text = ds.Tables[0].Rows[0]["AUCTION_END_TIME"].ToString(); Label7.Text = ds.Tables[0].Rows[0]["AUCTION_BIDS"].ToString(); String auctionId = ds.Tables[0].Rows[0]["AUCTION_ID"].ToString(); if(Label7.Text!="0") { ds = obj.GetAuctionBids(auctionId); GridView1.DataSource = ds; GridView1.DataBind(); } } }
protected void Button2_Click(object sender, EventArgs e) { String uname = TextBox1.Text; String pword = TextBox2.Text; String type = RadioButtonList1.Text; DatabaseHandler obj = new DatabaseHandler(); int status = obj.Login(uname, pword, type); if (status == 1 && type == "A Customer") { HttpCookie cookie = new HttpCookie("Car-Trading"); if(CheckBox1.Checked) cookie.Expires = DateTime.Now.AddDays(10); cookie["Username"] = uname; Response.Cookies.Add(cookie); Response.Redirect("CustomerHome.aspx"); } else if (status == 1 && type == "A Seller") { HttpCookie cookie = new HttpCookie("Car-Trading"); if(CheckBox1.Checked) cookie.Expires = DateTime.Now.AddDays(10); cookie["Username"] = uname; Response.Cookies.Add(cookie); Response.Redirect("SellerHome.aspx"); } else Response.Write("Login failed"); }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); DataSet ds = new DataSet(); String orderId=Request.QueryString["orderId"].ToString(); EncryptDecrypt obj=new EncryptDecrypt(); orderId=obj.Decrypt(HttpUtility.UrlDecode(orderId)); DatabaseHandler obj1 = new DatabaseHandler(); ds = obj1.GetSellerPendingOrderInfo(orderId); Label1.Text = ds.Tables[0].Rows[0]["CAR_BRAND"].ToString(); Label2.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NAME"].ToString(); Label3.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NUMBER"].ToString(); Label4.Text = ds.Tables[0].Rows[0]["CAR_PRICE"].ToString(); Label5.Text = ds.Tables[0].Rows[0]["CAR_STOCK_QUANTITY"].ToString(); Label6.Text = ds.Tables[0].Rows[0]["CAR_POSSESSION_TYPE"].ToString(); Label7.Text = ds.Tables[0].Rows[0]["CUSTOMER_FIRST_NAME"].ToString() + " " + ds.Tables[0].Rows[0]["CUSTOMER_LAST_NAME"].ToString(); Label8.Text = ds.Tables[0].Rows[0]["CUSTOMER_PHONE_NUMBER"].ToString(); Label9.Text = ds.Tables[0].Rows[0]["CUSTOMER_ADDRESS"].ToString(); Label10.Text = ds.Tables[0].Rows[0]["PAYMENT_MODE"].ToString(); Label11.Text = ds.Tables[0].Rows[0]["ORDER_DATE"].ToString(); if (Label5.Text == "0") { Label13.Visible = true; Button1.Enabled = false; Label13.Text = "This car is out of stock"; } }
protected void Button2_Click(object sender, EventArgs e) { String name = TextBox1.Text; String country = DropDownList1.Text; String city = DropDownList2.Text; String street=TextBox2.Text; String num = TextBox3.Text; String email = TextBox4.Text; String sellerProof = FileUpload1.PostedFile.FileName; String bank = DropDownList4.Text; String accountNum = TextBox5.Text; String uname = TextBox6.Text; String pword = TextBox7.Text; String sellerProofFolder = HttpContext.Current.Server.MapPath("~/Seller ID"); String sellerProofTarget = Path.Combine(sellerProofFolder, sellerProof); FileUpload1.SaveAs(sellerProofTarget); DatabaseHandler obj = new DatabaseHandler(); String sellerId = "SEL_" + DateTime.Now.Ticks.ToString(); obj.InsertSeller(sellerId, name, country, city, street, num, email, sellerProofTarget, bank, accountNum, uname, pword); HttpCookie cookie = new HttpCookie("Car-Trading"); cookie.Expires = DateTime.Now.AddDays(10); cookie["Username"] = uname; Response.Cookies.Add(cookie); EncryptDecrypt obj1 = new EncryptDecrypt(); sellerId = HttpUtility.HtmlEncode(obj1.Encrypt(sellerId)); Response.Redirect("SellerHome.aspx?sellerId=" + sellerId); }
protected void Button1_Click(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String orderId = Request.QueryString["orderId"].ToString(); EncryptDecrypt obj = new EncryptDecrypt(); orderId = obj.Decrypt(HttpUtility.UrlDecode(orderId)); DatabaseHandler obj1 = new DatabaseHandler(); String sellerUsername = Request.Cookies["Car-Trading"]["Username"].ToString(); DataSet ds = obj1.GetSellerId(sellerUsername); String sellerId = ds.Tables[0].Rows[0]["SELLER_ID"].ToString(); ds = obj1.GetSellerPendingOrderInfo(orderId); String customerId = ds.Tables[0].Rows[0]["CUSTOMER_ID"].ToString(); String carId = ds.Tables[0].Rows[0]["CAR_ID"].ToString(); String oldStock = Label5.Text; int oldStock1 = Convert.ToInt32(oldStock); int newStock = oldStock1-1; String newStock1 = newStock.ToString(); obj1.DecrementCarStock(carId, newStock1); String paymentMode = Label10.Text; String customerAddr = Label9.Text; String orderDate = Label11.Text; obj1.InsertCompletedOrder(orderId, customerId, carId, sellerId, paymentMode, customerAddr, orderDate); Label13.Visible = true; Label13.Text = "Order Completed"; Button1.Enabled = false; }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String sellerId = null; try { sellerId = Request.QueryString["sellerId"].ToString(); EncryptDecrypt obj = new EncryptDecrypt(); sellerId = obj.Decrypt(HttpUtility.UrlDecode(sellerId)); } catch(System.NullReferenceException exc) { String sellerUsername = Request.Cookies["Car-Trading"]["Username"].ToString(); DatabaseHandler x = new DatabaseHandler(); DataSet ds1 = x.GetSellerId(sellerUsername); sellerId = ds1.Tables[0].Rows[0]["SELLER_ID"].ToString(); } DatabaseHandler obj1 = new DatabaseHandler(); DataSet ds = new DataSet(); ds = obj1.GetSellerHomeInfo(sellerId); Label1.Text = ds.Tables[0].Rows[0]["SELLER_NAME"].ToString(); Label2.Text = ds.Tables[0].Rows[0]["SELLER_COUNTRY"].ToString(); Label3.Text = ds.Tables[0].Rows[0]["SELLER_CITY"].ToString(); Label4.Text = ds.Tables[0].Rows[0]["SELLER_STREET"].ToString(); Label5.Text = ds.Tables[0].Rows[0]["SELLER_PHONE_NUMBER"].ToString(); Label6.Text = ds.Tables[0].Rows[0]["SELLER_EMAIL_ID"].ToString(); Label7.Text = ds.Tables[0].Rows[0]["SELLER_BANK"].ToString(); Label8.Text = ds.Tables[0].Rows[0]["SELLER_BANK_ACCOUNT_NUMBER"].ToString(); Image1.ImageUrl = "~\\Seller ID\\" + Path.GetFileName(ds.Tables[0].Rows[0]["SELLER_ID_PROOF"].ToString()); Image1.Width = 100; Image1.Height = 100; }
protected void LinkButton2_Click(object sender, EventArgs e) { String fname=TextBox2.Text; String lname=TextBox1.Text; String addr=TextBox3.Text; String addrProof=FileUpload1.PostedFile.FileName; String photoId=FileUpload2.PostedFile.FileName; String num=TextBox4.Text; String email=TextBox9.Text; String uname=TextBox5.Text; String pword=TextBox6.Text; String alerts=RadioButtonList1.Text; String id = "CUST_" + DateTime.Now.Ticks.ToString(); String addrProofFolder = HttpContext.Current.Server.MapPath("~/Address ID"); String addrProofTarget = Path.Combine(addrProofFolder, addrProof); FileUpload1.SaveAs(addrProofTarget); String photoProofFolder = HttpContext.Current.Server.MapPath("~/Photo ID"); String photoProofTarget = Path.Combine(photoProofFolder, photoId); FileUpload2.SaveAs(photoProofTarget); DatabaseHandler obj = new DatabaseHandler(); obj.InsertCustomer(id, fname, lname, addr, addrProofTarget, photoProofTarget, num, email, uname, pword, alerts); HttpCookie cookie = new HttpCookie("Car-Trading"); cookie.Expires = DateTime.Now.AddMinutes(1); cookie["Username"] = uname; Response.Cookies.Add(cookie); Response.Redirect("CustomerHome.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); EncryptDecrypt obj1 = new EncryptDecrypt(); String carId = obj1.Decrypt(HttpUtility.UrlDecode(Request.QueryString["carId"].ToString())); String sellerId = obj1.Decrypt(HttpUtility.UrlDecode(Request.QueryString["sellerId"].ToString())); if (carId == null || sellerId == null) Response.Redirect("Error.aspx"); else { DatabaseHandler obj = new DatabaseHandler(); DataSet ds = obj.GetCarInfo(carId); Label1.Text = ds.Tables[0].Rows[0]["CAR_BRAND"].ToString() + " " + ds.Tables[0].Rows[0]["CAR_MODEL_NAME"].ToString(); Label2.Text = ds.Tables[0].Rows[0]["CAR_BRAND"].ToString(); Label3.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NAME"].ToString(); Label4.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NUMBER"].ToString(); Label5.Text = ds.Tables[0].Rows[0]["CAR_POSSESSION_TYPE"].ToString(); Label6.Text = ds.Tables[0].Rows[0]["CAR_YEAR_OF_PURCHASE"].ToString(); Label7.Text = ds.Tables[0].Rows[0]["CAR_PRICE"].ToString(); Label8.Text = ds.Tables[0].Rows[0]["CAR_ENGINE"].ToString(); Label9.Text = ds.Tables[0].Rows[0]["CAR_FUEL"].ToString(); ImageButton1.ImageUrl = "~\\Car\\Front\\" + Path.GetFileName(ds.Tables[0].Rows[0]["CAR_FRONT_IMAGE"].ToString()); ImageButton1.Width = 100; ImageButton1.Height = 100; ImageButton2.ImageUrl = "~\\Car\\Side\\" + Path.GetFileName(ds.Tables[0].Rows[0]["CAR_SIDE_IMAGE"].ToString()); ImageButton2.Width = 100; ImageButton2.Height = 100; ImageButton3.ImageUrl = "~\\Car\\Rear\\" + Path.GetFileName(ds.Tables[0].Rows[0]["CAR_REAR_IMAGE"].ToString()); ImageButton3.Width = 100; ImageButton3.Height = 100; ds = obj.GetSellerName(sellerId); Label10.Text = ds.Tables[0].Rows[0]["SELLER_NAME"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { this.UnobtrusiveValidationMode = System.Web.UI.UnobtrusiveValidationMode.None; if (!checkCookie()) Response.Redirect("Login.aspx"); String auctionId = Session["auctionId"].ToString(); DatabaseHandler obj = new DatabaseHandler(); DataSet ds = obj.GetAuctionCarInfo(auctionId); Label1.Text = ds.Tables[0].Rows[0]["CAR_BRAND"].ToString(); Label2.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NAME"].ToString(); Label3.Text = ds.Tables[0].Rows[0]["CAR_MODEL_NUMBER"].ToString(); Label4.Text = ds.Tables[0].Rows[0]["CAR_PRODUCTION_YEAR"].ToString(); Label5.Text = ds.Tables[0].Rows[0]["CAR_BASE_PRICE"].ToString(); Label7.Text = ds.Tables[0].Rows[0]["CAR_ENGINE"].ToString(); Label8.Text = ds.Tables[0].Rows[0]["CAR_FUEL"].ToString(); ImageButton1.ImageUrl = "~\\Car\\Front\\" + Path.GetFileName(ds.Tables[0].Rows[0]["CAR_FRONT_IMAGE"].ToString()); ImageButton2.ImageUrl = "~\\Car\\Side\\" + Path.GetFileName(ds.Tables[0].Rows[0]["CAR_SIDE_IMAGE"].ToString()); ImageButton3.ImageUrl = "~\\Car\\Rear\\" + Path.GetFileName(ds.Tables[0].Rows[0]["CAR_REAR_IMAGE"].ToString()); DataSet ds1 = new DataSet(); ds1 = obj.GetAuctionBids(auctionId); if (ds1 == null) Label9.Text = "No bids have been placed for this car yet"; else { Label9.Text = ds1.Tables[0].Rows.Count + " bid(s) placed on this car"; GridView1.DataSource = ds1; GridView1.DataBind(); } }
public Frontend() { InitializeComponent(); db = new DatabaseHandler(); db.InitDatabase(); audioManager = new AudioManager(this); }
private ItemHandler() { this._picture = new Dictionary<uint, Bitmap>(); this._handler = DatabaseHandler.GetInstance(); this._items = new ObservableCollection<Item>(); this._items.CollectionChanged += EventItemCollectionChanged; this._nullImage = null; }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); DatabaseHandler obj = new DatabaseHandler(); DataSet ds = obj.GetAuctions(); GridView1.DataSource = ds; GridView1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); int flag = 0; DataSet ds = new DataSet(); DatabaseHandler obj = new DatabaseHandler(); ds = obj.GetAllCars(); if (ds == null) Label1.Text = "No car to display"; else { int count = ds.Tables[0].Rows.Count; TableRow tr = new TableRow(); for (int i = 0; i < count; i++) { TableCell tc = new TableCell(); ImageButton imgbutton = new ImageButton(); imgbutton.ImageUrl = "~\\Car\\Front\\" + Path.GetFileName(ds.Tables[0].Rows[i]["CAR_FRONT_IMAGE"].ToString()); imgbutton.Width = 150; imgbutton.Height = 150; imgbutton.CssClass = "image-zoom"; tc.Controls.Add(imgbutton); LinkButton lbutton1 = new LinkButton(); String brand = ds.Tables[0].Rows[i]["CAR_BRAND"].ToString(); String model = ds.Tables[0].Rows[i]["CAR_MODEL_NAME"].ToString(); lbutton1.Text = brand + " " + model; tc.Controls.Add(lbutton1); String carId = ds.Tables[0].Rows[i]["CAR_ID"].ToString(); String sellerId = ds.Tables[0].Rows[i]["SELLER_ID"].ToString(); EncryptDecrypt obj1 = new EncryptDecrypt(); carId = HttpUtility.UrlEncode(obj1.Encrypt(carId)); sellerId = HttpUtility.UrlEncode(obj1.Encrypt(sellerId)); lbutton1.PostBackUrl = "CarDetails.aspx?carId=" + carId + "&sellerId=" + sellerId; imgbutton.PostBackUrl = "CarDetails.aspx?carId=" + carId + "&sellerId=" + sellerId; tc.Attributes.Add("width", "150px"); tc.Attributes.Add("height", "150px"); flag++; if (flag % 5 != 0) { tr.Controls.Add(tc); } else { Table1.Rows.Add(tr); tr = new TableRow(); tr.Controls.Add(tc); } } Table1.Rows.Add(tr); Table1.CellSpacing = 30; } }
protected void LinkButton1_Click(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String customerUsername = Request.Cookies["Car-Trading"]["Username"].ToString(); DatabaseHandler obj=new DatabaseHandler(); DataSet ds=obj.GetCustomerId(customerUsername); String customerId = ds.Tables[0].Rows[0]["CUSTOMER_ID"].ToString(); EncryptDecrypt obj1 = new EncryptDecrypt(); customerId = HttpUtility.UrlEncode(obj1.Encrypt(customerId)); Response.Redirect("CustomerBuyCar.aspx?carId=" + Request.QueryString["carId"].ToString() + "&sellerId=" + Request.QueryString["sellerId"].ToString() + "&customerId=" + customerId); }
protected void LinkButton1_Click(object sender, EventArgs e) { Panel1.Visible = true; int flag = 1; DatabaseHandler obj = new DatabaseHandler(); EncryptDecrypt obj1 = new EncryptDecrypt(); String sellerId = obj1.Decrypt(HttpUtility.UrlDecode(Request.QueryString["sellerId"].ToString())); DataSet ds = obj.GetSellerCars(sellerId); if (ds.Tables[0].Rows.Count == 0) { Label7.Text = "This seller has no car in stock"; LinkButton1.Visible = false; } else { int count1 = ds.Tables[0].Rows.Count; TableRow tr = new TableRow(); for (int i = 0; i < count1; i++) { LinkButton1.Visible = false; TableCell tc = new TableCell(); Image img = new Image(); img.ImageUrl = "~\\Car\\Front\\" + Path.GetFileName(ds.Tables[0].Rows[i]["CAR_FRONT_IMAGE"].ToString()); img.Width = 150; img.Height = 150; tc.Controls.Add(img); LinkButton lbutton1 = new LinkButton(); String brand = ds.Tables[0].Rows[i]["CAR_BRAND"].ToString(); String model = ds.Tables[0].Rows[i]["CAR_MODEL_NAME"].ToString(); lbutton1.Text = brand + " " + model; tc.Controls.Add(lbutton1); String carId = ds.Tables[0].Rows[i]["CAR_ID"].ToString(); DataSet ds1 = obj.GetCarSeller(carId); carId = HttpUtility.UrlEncode(obj1.Encrypt(carId)); sellerId = HttpUtility.UrlEncode(obj1.Encrypt(sellerId)); lbutton1.PostBackUrl = "CarDetails.aspx?carId=" + carId + "&sellerId=" + sellerId; tc.Attributes.Add("width", "150px"); tc.Attributes.Add("height", "150px"); flag++; if (flag % 5 != 0) tr.Controls.Add(tc); else { Table1.Rows.Add(tr); tr.Controls.Add(tc); tr = new TableRow(); } } Table1.Rows.Add(tr); Table1.CellSpacing = 30; } }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String sellerUsername = Request.Cookies["Car-Trading"]["Username"].ToString(); DataSet ds = new DataSet(); DatabaseHandler obj=new DatabaseHandler(); ds = obj.GetSellerId(sellerUsername); String sellerId = ds.Tables[0].Rows[0]["SELLER_ID"].ToString(); ds = obj.GetSellerCarStock(sellerId); GridView1.DataSource = ds; GridView1.DataBind(); }
private void saveEventButton_Click(object sender, EventArgs e) { DatabaseHandler db = new DatabaseHandler(); Event ev = new Event(); ev.Name = eventNameTB.Text; ev.Info = eventInfoRTB.Text; if (validateEvent(ev)) { db.saveEvent(ev); this.Close(); } else { MessageBox.Show(errorMessage); } }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); DatabaseHandler obj = new DatabaseHandler(); DataSet ds = obj.GetAllAuctionInfo(); if (ds == null) Label1.Text = "No live auction"; else { GridView1.DataSource = ds; GridView1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); EncryptDecrypt obj1=new EncryptDecrypt(); String sellerId=obj1.Decrypt(HttpUtility.UrlDecode(Request.QueryString["sellerId"].ToString())); DatabaseHandler obj = new DatabaseHandler(); DataSet ds = obj.GetSellerInfo(sellerId); Label1.Text = ds.Tables[0].Rows[0]["SELLER_NAME"].ToString(); Label2.Text = ds.Tables[0].Rows[0]["SELLER_COUNTRY"].ToString(); Label3.Text = ds.Tables[0].Rows[0]["SELLER_CITY"].ToString(); Label4.Text = ds.Tables[0].Rows[0]["SELLER_STREET"].ToString(); Label5.Text = ds.Tables[0].Rows[0]["SELLER_PHONE_NUMBER"].ToString(); Label6.Text = ds.Tables[0].Rows[0]["SELLER_EMAIL_ID"].ToString(); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); String sellerUsername = Request.Cookies["Car-Trading"]["Username"].ToString(); DataSet ds = new DataSet(); DatabaseHandler obj=new DatabaseHandler(); ds = obj.GetSellerId(sellerUsername); String sellerId = ds.Tables[0].Rows[0]["SELLER_ID"].ToString(); EncryptDecrypt obj1=new EncryptDecrypt(); sellerId=HttpUtility.UrlEncode(obj1.Encrypt(sellerId)); String carId=GridView1.SelectedRow.Cells[0].Text; carId=HttpUtility.UrlEncode(obj1.Encrypt(carId)); Response.Redirect("SellerDisplayCarStockInfo.aspx?sellerId=" + sellerId + "&carId=" + carId); }
protected void Page_Load(object sender, EventArgs e) { if (!checkCookie()) Response.Redirect("Login.aspx"); int flag = 0; DataSet ds = new DataSet(); DatabaseHandler obj = new DatabaseHandler(); ds = obj.GetUpcomingCars(); if (ds == null) Label1.Text = "No car to display"; else { int count = ds.Tables[0].Rows.Count; TableRow tr = new TableRow(); for (int i = 0; i < count; i++) { TableCell tc = new TableCell(); Image img = new Image(); img.ImageUrl = "~\\Car\\Front\\" + Path.GetFileName(ds.Tables[0].Rows[i]["CAR_FRONT_IMAGE"].ToString()); img.Width = 150; img.Height = 150; img.ID = "ImageID"; img.CssClass = "image-zoom"; tc.Controls.Add(img); Label label1 = new Label(); String carBrand = ds.Tables[0].Rows[i]["CAR_BRAND"].ToString(); String carModelName = ds.Tables[0].Rows[i]["CAR_MODEL_NAME"].ToString(); String carModelNumber = ds.Tables[0].Rows[i]["CAR_MODEL_NUMBER"].ToString(); label1.Text = carBrand + " " + carModelName + " " + carModelNumber; tc.Controls.Add(label1); tc.Attributes.Add("width", "150px"); tc.Attributes.Add("height", "150px"); flag++; if (flag % 5 != 0) { tr.Controls.Add(tc); } else { Table1.Rows.Add(tr); tr = new TableRow(); tr.Controls.Add(tc); } } Table1.Rows.Add(tr); Table1.CellSpacing = 30; } }
public List<AppUser> GetAll() { List<AppUser> allUsers = new List<AppUser>(); DatabaseHandler dh = new DatabaseHandler(); DataTable dt = dh.GetAllAppUsers(); foreach (DataRow dr in dt.Rows) { AppUser user = new AppUser(); user.AppUserId = dr["AppUserID"].ToString(); user.AppUserPassword = dr["Password"].ToString(); user.Email = ""; user.Name = dr["Name"].ToString(); allUsers.Add(user); } return allUsers; }
protected void Button2_Click(object sender, EventArgs e) { String brand = TextBox1.Text; String modelName = TextBox2.Text; String modelNum = TextBox3.Text; String possessionType = RadioButtonList1.Text; String yearOfPurchase = DropDownList2.Text; String carPrice = TextBox4.Text; String carEngine = TextBox5.Text; String carStock = TextBox8.Text; String fuelType = DropDownList1.Text; String frontImg = FileUpload1.PostedFile.FileName; String sideImg = FileUpload2.PostedFile.FileName; String rearImg = FileUpload3.PostedFile.FileName; String frontImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Front"); String frontImgTarget = Path.Combine(frontImgFolder, frontImg); FileUpload1.SaveAs(frontImgTarget); String sideImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Side"); String sideImgTarget = Path.Combine(sideImgFolder, sideImg); FileUpload2.SaveAs(sideImgTarget); String rearImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Rear"); String rearImgTarget = Path.Combine(rearImgFolder, rearImg); FileUpload3.SaveAs(rearImgTarget); DatabaseHandler obj = new DatabaseHandler(); String carId = "CAR_" + DateTime.Now.Ticks.ToString(); obj.InsertCar(carId, brand, modelName, modelNum, possessionType, yearOfPurchase, carPrice, carEngine, fuelType, frontImgTarget, sideImgTarget, rearImgTarget); String sellerUsername = Request.Cookies["Car-Trading"]["Username"]; DataSet ds = obj.GetSellerId(sellerUsername); String sellerId = ds.Tables[0].Rows[0]["SELLER_ID"].ToString(); ds = obj.GetSellerName(sellerId); String sellerName = ds.Tables[0].Rows[0]["SELLER_NAME"].ToString(); obj.InsertSellerCar(sellerId, carId, carStock); Response.Write("Car Added"); TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox8.Text = ""; RadioButtonList1.ClearSelection(); }
protected void Button2_Click(object sender, EventArgs e) { String brandName = TextBox1.Text; String modelName = TextBox2.Text; String modelNum=TextBox3.Text; String carYear = DropDownList2.Text; String carPrice = TextBox4.Text; String carEngine = TextBox5.Text; String carFuel = DropDownList1.Text; String frontImg = FileUpload1.PostedFile.FileName; String sideImg = FileUpload2.PostedFile.FileName; String rearImg = FileUpload3.PostedFile.FileName; String auctionStartTime=TextBox6.Text; String auctionEndTime=TextBox7.Text; String frontImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Front"); String frontImgTarget = Path.Combine(frontImgFolder, frontImg); FileUpload1.SaveAs(frontImgTarget); String sideImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Side"); String sideImgTarget = Path.Combine(sideImgFolder, sideImg); FileUpload2.SaveAs(sideImgTarget); String rearImgFolder = HttpContext.Current.Server.MapPath("~\\Car\\Rear"); String rearImgTarget = Path.Combine(rearImgFolder, rearImg); FileUpload3.SaveAs(rearImgTarget); DatabaseHandler obj = new DatabaseHandler(); DataSet ds = obj.GetSellerId(Request.Cookies["Car-Trading"]["Username"].ToString()); String sellerId = ds.Tables[0].Rows[0]["SELLER_ID"].ToString(); String carId = "CAR_" + DateTime.Now.Ticks.ToString(); String auctionId = "AUCTION_" + DateTime.Now.Ticks.ToString(); obj.InsertCar(carId, brandName, modelName, modelNum, "Old", carYear, carPrice, carEngine, carFuel, frontImgTarget, sideImgTarget, rearImgTarget); obj.InsertAuctionInfo(auctionId, sellerId, carId, auctionStartTime, auctionEndTime, "0"); Label1.Text = "Car added for auction"; TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; TextBox6.Text = ""; TextBox7.Text = ""; DropDownList1.ClearSelection(); DropDownList2.ClearSelection(); }
public void RegisterNewUser() // poate fi transforata in bool prin schimbare return si decomentare { bool valid = false; string username = usernameField.text; string email = emailField.text; string password = passwordField.text; string passwordConfirm = passwordConfirmField.text; if (username.Equals("")) { errorBoxMsg.text = "Username field is empty!"; Debug.Log("Username field is empty!"); //return false; } else if (email.Equals("")) { errorBoxMsg.text = "Email field is empty!"; Debug.Log("Email field is empty!"); //return false; } else if (IsValidEmail(email) == false) { errorBoxMsg.text = "Email is not valid"; Debug.Log("Email is not valid"); //return false; } else if (password.Equals("")) { errorBoxMsg.text = "Password field is empty!"; Debug.Log("Password field is empty!"); //return false; } else if (password.Length < 6) { errorBoxMsg.text = "The password is too short!"; Debug.Log("The password is too short!"); //return false; } else if (passwordConfirm.Equals("")) { errorBoxMsg.text = "Confirm Password field is empty!"; Debug.Log("Confirm Password field is empty!"); //return false; } else if (!(password.Equals(passwordConfirm))) { errorBoxMsg.text = "The passwords don't match!"; Debug.Log("The passwords don't match!"); //return false; } else { bool temp = true; DatabaseHandler.GetUserByUsername(username, user_returnat => { if (user_returnat == null) //se poate face insert { Debug.Log($"The username is available"); //Debug.Log($"Name: {usernameField.text}, Email: {emailField.text}, Password: {passwordField.text} PasswordConfirm: {passwordConfirmField.text}"); UserCredentials newUser = new UserCredentials(usernameField.text, passwordField.text, emailField.text); DatabaseHandler.PostUser(newUser, () => Debug.Log("User created successfully!")); errorBoxMsg.text = "User created successfully"; LoginScript.CurrentUser = usernameField.text; LoginScript.CurrentUserPassword = passwordField.text; LoginScript.CurrentUserEmail = emailField.text; SceneManager.LoadScene("MenuScene"); // Temporary temp = true; } else if (user_returnat.username.Equals(username)) { errorBoxMsg.text = "The username is already in use. Use another!"; Debug.Log($"The username is already in use. Use another!"); temp = false; } } ); //return temp; } if (valid == true) { errorBoxMsg.text = "Succes"; } //return valid; }
public static void EndElection() { DatabaseHandler.EndElection(); }
// POST api/values public HttpResponseMessage Post([FromBody] JToken postData, HttpRequestMessage request) { JObject result = (JObject)JsonConvert.DeserializeObject(postData.ToString()); DataTable responseObj = new DataTable(); string json = string.Empty; json = JsonConvert.SerializeObject(responseObj); DatabaseHandler dh = new DatabaseHandler(configFilePath); QueryDispatcher qd = new QueryDispatcher(dh, configFilePath); var response = this.Request.CreateResponse(HttpStatusCode.OK); try { if (request.RequestUri.AbsolutePath == "/api/Values/cancel_reservation") { qd.CancelReservation(result["reservation_id"].ToString()); response.Content = new StringContent("", Encoding.UTF8, "application/json"); } else if (request.RequestUri.AbsolutePath == "/api/Values/make_reservation") { response = qd.CreateNewReservation(result["email"].ToString(), JsonConvert.DeserializeObject <List <string> >(result["flights"].ToString()), Convert.ToInt32(result["number_of_tickets"])); response.Content = new StringContent("", Encoding.UTF8, "application/json"); return(response); } else if (request.RequestUri.AbsolutePath == "/api/Values/user_reservations") { response.Content = new StringContent(qd.FindUserReservations(result["user_id"].ToString()), Encoding.UTF8, "application/json"); } else if (request.RequestUri.AbsolutePath == "/api/Values/add_flight") { return(qd.AddFlight(result["route_id"].ToString(), result["departure_time_GMT"].ToString(), result["arrival_time_GMT"].ToString(), Convert.ToInt32(result["ticket_price"].ToString()), result["airplane_IATA"].ToString())); } else if (request.RequestUri.AbsolutePath == "/api/Values/cancel_flight") { return(qd.RemoveFlight(result["flight_id"].ToString())); } else if (request.RequestUri.AbsolutePath == "/api/Values/add_route") { return(qd.AddRoute(result["source_airport"].ToString(), result["destination_airport"].ToString(), result["airline_id"].ToString(), result["equipment"].ToString())); } else if (request.RequestUri.AbsolutePath == "/api/Values/remove_route") { return(qd.RemoveRoute(result["route_id"].ToString())); } else if (request.RequestUri.AbsolutePath == "/api/Values/add_airport") { return(qd.AddAirport(result["name"].ToString(), result["city"].ToString(), result["country"].ToString(), result["IATA"].ToString(), result["ICAO"].ToString(), Convert.ToDouble(result["lat"].ToString()), Convert.ToDouble(result["lon"].ToString()), Convert.ToDouble(result["timezone"].ToString()))); } else if (request.RequestUri.AbsolutePath == "/api/Values/remove_airport") { return(qd.RemoveAirport(result["airport_id"].ToString())); } else if (request.RequestUri.AbsolutePath == "/api/Values/add_airplane") { return(qd.AddAirplane(result["name"].ToString(), result["IATA"].ToString(), result["ICAO"].ToString(), Convert.ToInt32(result["cruise_speed"].ToString()), Convert.ToInt32(result["num_of_seats"].ToString()))); } else if (request.RequestUri.AbsolutePath == "/api/Values/remove_airplane") { return(qd.RemoveAirplane(result["IATA"].ToString())); } else if (request.RequestUri.AbsolutePath == "/api/Values/add_airline") { return(qd.AddAirline(result["name"].ToString(), result["IATA"].ToString(), result["ICAO"].ToString(), bool.Parse(result["is_active"].ToString()), Convert.ToInt32(result["rating"].ToString()))); } else if (request.RequestUri.AbsolutePath == "/api/Values/remove_airline") { return(qd.RemoveAirline(result["id"].ToString())); } else if (request.RequestUri.AbsolutePath == "/api/Values/sign_up") { return(qd.SignUp(result["email"].ToString(), result["full_name"].ToString(), DateTime.Parse(result["DOB"].ToString()), result["passport_id"].ToString())); } else if (request.RequestUri.AbsolutePath == "/api/Values/is_admin") { response.Content = new StringContent(qd.IsAdmin(result["email"].ToString(), result["password"].ToString()), Encoding.UTF8, "application/json"); } } catch (Exception e) { Console.WriteLine(e); response.StatusCode = HttpStatusCode.BadRequest; } response.Headers.Add("Access-Control-Allow-Origin", "*"); return(response); }
public static void StartElection() { DatabaseHandler.StartElection(); }
private void clearDatabase_Click(object sender, EventArgs e) { DatabaseHandler.getInstance().ClearDatabase(); }
public static async void checkmutes(IGuild guild) { var guildobj = DatabaseHandler.GetGuild(guild.Id); if (guildobj?.ModerationSetup.Mutes.MutedUsers.Any() != true) { return; } var mutedrole = guild.Roles.FirstOrDefault(x => x.Id == guildobj.ModerationSetup.Mutes.mutedrole); if (mutedrole == null) { return; } foreach (var mute in guildobj.ModerationSetup.Mutes.MutedUsers.ToList()) { try { if (!mute.expires) { continue; } var removemute = false; var muteduser = await guild.GetUserAsync(mute.userid); if (muteduser == null) { removemute = true; } else { if (mute.expiry < DateTime.UtcNow) { removemute = true; if (!muteduser.RoleIds.Contains(mutedrole.Id)) { await muteduser.RemoveRoleAsync(mutedrole); } } } if (removemute) { guildobj.ModerationSetup.Mutes.MutedUsers.Remove(mute); await guildobj.ModLog(new EmbedBuilder { Title = "Mute Auto Removed - Expired", Description = $"User: {muteduser?.Username}\n" + $"UserID: {muteduser?.Id}", Color = Color.DarkGreen }, guild); } } catch (Exception e) { Logger.LogMessage(e.ToString(), LogSeverity.Error); } } guildobj.Save(); }
public SageWoodResponse PaySageWoodElectricity(string MNo, string amount, string transactionId) { SageWoodResponse woodResponse = new SageWoodResponse(); string rawRequest; DatabaseHandler dh = new DatabaseHandler(); try { string clientId = "2019112800001"; string opName = "UDEMO"; string password = "******"; string meterno = "14012018064"; string date = DateTime.Now.ToString("yyyyMMddHHmmss").ToString(); string randomnumber = GenerateRandomNumber().ToString(); MeterInfo custInfo = new MeterInfo(); ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls; ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback (delegate { return(true); }); EANDeviceID deviceId = new EANDeviceID(); deviceId.ean = clientId; GenericDeviceID genericDeviceID = new GenericDeviceID(); genericDeviceID.id = clientId; PurchaseValueCurrency purchaseValue = new PurchaseValueCurrency(); purchaseValue.amt = new Currency(); purchaseValue.amt.symbol = "UGX"; purchaseValue.amt.value = Decimal.Parse("10"); Electricity electricity = new Electricity(); MsgID msg = new MsgID(); msg.dateTime = DateTime.Now.ToString("yyyyMMddHHmmss").ToString(); msg.uniqueNumber = randomnumber; AuthCred authCred = new AuthCred(); authCred.opName = opName; authCred.password = password; authCred.newPassword = ""; MsgID messageId = msg; AuthCred creds = authCred; MeterDetail meter = new MeterDetail(); meter.msno = meterno; Cash pay = new Cash(); pay.tenderAmt = new Currency(); pay.tenderAmt.symbol = "UGX"; pay.tenderAmt.value = Decimal.Parse("100"); VendIDMethod vendIDMethod = new VendIDMethod(); vendIDMethod.meterIdentifier = meter; CreditVendReq request = new CreditVendReq(); XMLVendService21 sageWood = new XMLVendService21(); request.clientID = deviceId; request.msgID = msg; request.authCred = authCred; request.terminalID = genericDeviceID; request.idMethod = vendIDMethod; request.resource = electricity; request.purchaseValue = purchaseValue; request.payType = pay; rawRequest = XmlCreditVend(request); CreditVendResp response = sageWood.CreditVendRequest(request); Tx tx = response.creditVendReceipt.transactions.tx[0]; CreditVendTx creditVendTx = (CreditVendTx)tx; CreditVendReceipt resp = response.creditVendReceipt; STS1Token sts1Token = (STS1Token)creditVendTx.creditTokenIssue.token; woodResponse.Token = sts1Token.stsCipher; woodResponse.ReceiptNo = response.creditVendReceipt.receiptNo; woodResponse.Units = creditVendTx.creditTokenIssue.units.value.ToString(); string rawResponse = XmlCreditVendResp(response); //log raw request and response dh.LogRequestAndResponse("SAGEWOOD", transactionId, rawRequest, rawResponse); } catch (SoapException soapException) { // XMLVendFaultResp xmlVendFaultResp = XMLDeserialize.Deserialize(soapException.Detail); // if (xmlVendFaultResp.fault.GetType() == //typeof(UnknownMeterEx)) // { // Console.WriteLine("Unknown Meter Serial Number!"); // } // else // { // string fert = xmlVendFaultResp.fault.GetType().ToString(); // Console.WriteLine("Unexpected XMLVend Fault Response" + // "received: (" + xmlVendFaultResp.fault.GetType().ToString() // + ")" + xmlVendFaultResp.fault.desc); // } dh.LogError(soapException.Detail.InnerXml, transactionId, DateTime.Now, "SAGEWOOD"); } catch (Exception ex) { Console.WriteLine("Error: " + ex); dh.LogError(ex.ToString(), transactionId, DateTime.Now, "SAGEWOOD"); } return(woodResponse); }
public static int GetSeatId(int centerId) { return(DatabaseHandler.GetSeatIdFromCenterId(centerId)); }
public GuildHelper(GuildHandler guildHandler, DiscordSocketClient client, DatabaseHandler database) { _client = client; _guildHandler = guildHandler; _database = database; }
public void removeFromClientOptions() { string query = string.Format(QueryStrings.Option.deleteOptionFromSystem, this.optionGuid); DataTable systemData = DatabaseHandler.getInstance().getFromStringQuery(query); }
public static int GetCenterStatus(int centerId) { return(DatabaseHandler.GetCenterStatus(centerId)); }
public IEnumerator AfterSignRaised(bool combo) { foreach (var letter in titleLetters) { Destroy(letter.GetComponent <Draggable>()); } AudioClip sound; if (!combo && StoryHandler.madeSignFall) { sound = SoundHandler.sound.ca; StoryHandler.scrambledSign = true; DatabaseHandler.PostVariableToDatabase(1, "scrambledSign"); } else if (!combo && !StoryHandler.madeSignFall) { sound = SoundHandler.sound.cb; StoryHandler.scrambledSign = true; DatabaseHandler.PostVariableToDatabase(1, "scrambledSign"); } else { sound = SoundHandler.sound.cc; StoryHandler.scrambledSign = false; DatabaseHandler.PostVariableToDatabase(1, "nScrambledSign"); } SoundHandler.sound.Play(sound); if (!combo && !StoryHandler.madeSignFall) { yield return(new WaitForSeconds(3.5f)); foreach (var letter in titleLetters) { foreach (var letterHolder in letterHolders) { if (letterHolder.name[0] == letter.name[0]) { letter.transform.position = letterHolder.transform.position; } } } } var t = sound.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t); } while (t >= 0) { if (Skip) { Skip = false; t = 1; } t -= Time.deltaTime; yield return(null); } StartCoroutine(GameStillNotLoading()); }
private void Awake() { dbHandler = GameObject.Find("DatabaseHandler").GetComponent <DatabaseHandler>(); graph = GameObject.Find("Window_Graph").GetComponent <WindowGraph>(); }
private IEnumerator BigCrash() { SoundHandler.sound.Play(SoundHandler.sound._d); var t = SoundHandler.sound._d.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t); } while (t >= 0) { if (Skip) { Skip = false; t = 1; } t -= Time.deltaTime; yield return(null); } optionBox.playerChoice = 0; optionBox.PopupOptionBox("WHAT DO YOU WANT TO SAY?", "YES", "NO"); while (optionBox.playerChoice == 0) { yield return(null); } if (optionBox.playerChoice == 1) { StoryHandler.saidYes = true; DatabaseHandler.PostVariableToDatabase(1, "saidYes"); SoundHandler.sound.Play(SoundHandler.sound._eb); var t1 = SoundHandler.sound._eb.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t1); } while (t1 >= 0) { if (Skip) { Skip = false; t1 = 1; } t1 -= Time.deltaTime; yield return(null); } } else { DatabaseHandler.PostVariableToDatabase(1, "nSaidYes"); SoundHandler.sound.Play(SoundHandler.sound._ea); var t1 = SoundHandler.sound._ea.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t1); } while (t1 >= 0) { if (Skip) { Skip = false; t1 = 1; } t1 -= Time.deltaTime; yield return(null); } } DatabaseHandler.PostVariableToDatabase(1, isSkipMode ? "finishedChapterSkip" : "finishedChapterNormal"); SceneManager.LoadScene(8); optionBox.playerChoice = 0; }
/// <summary> /// Attempts to get a previously created announcement message based on values that were stored in the DB. /// If the located message does not match the current event it will be deleted. /// If nothing can be located, it does nothing. /// </summary> /// <returns></returns> public async Task TryAttachPreviousAnnounceMessage() { var testEvent = _calendar.GetTestEvent(); //Get the last known message _oldMessage = DatabaseHandler.GetAnnouncementMessage(); //No message found in the DB, do nothing. Likely to happen when DB is new. if (_oldMessage == null) { if (_data.RSettings.ProgramSettings.Debug) { _ = _log.LogMessage("No message found in DB to reattach to", false, color: LOG_COLOR); } return; } //Make sure a test is valid if (!testEvent.IsValid) { if (_data.RSettings.ProgramSettings.Debug) { _ = _log.LogMessage("No valid test found to post", false, color: LOG_COLOR); } return; } _ = _log.LogMessage("Attempting to get old announcement message\n" + $"{_oldMessage.AnnouncementId} that was created at {_oldMessage.AnnouncementDateTime}", false, color: LOG_COLOR); var eventEditTime = _calendar.GetTestEventNoUpdate().EventEditTime; if (eventEditTime != null && eventEditTime.Value.Equals(_oldMessage.AnnouncementDateTime)) { try { PlaytestAnnouncementMessage = await _data.AnnouncementChannel.GetMessageAsync(_oldMessage.AnnouncementId) as IUserMessage; if (PlaytestAnnouncementMessage != null) { _ = _log.LogMessage($"Retrieved old announcement! ID: {PlaytestAnnouncementMessage.Id}", false, color: LOG_COLOR); } var lastEditTime = _calendar.GetTestEventNoUpdate().LastEditTime; if (lastEditTime != null) { _lastSeenEditTime = lastEditTime.Value; } } catch { _ = _log.LogMessage("Unable to retrieve old announcement message!", false, color: LOG_COLOR); } } else { _ = _log.LogMessage("Messages do not match, deleting old message", false, color: LOG_COLOR); try { await _data.AnnouncementChannel.DeleteMessageAsync(_oldMessage.AnnouncementId); PlaytestAnnouncementMessage = null; } catch { _ = _log.LogMessage("Could not delete old message - it was likely deleted manually", false, color: LOG_COLOR); } } }
public IEnumerator FinishEditor() { Destroy(GameObject.Find("LeaveEditorButton")); EditorHandler.activated = false; GPlayerController.activated = false; GPlayerController.editorMode = false; if (StoryHandler.leftEditor) { DatabaseHandler.PostVariableToDatabase(1, "nLeftEditor"); } DatabaseHandler.PostVariableToDatabase(1, "nDeletedPlayer"); if (StoryHandler.likedGirlGame) { SoundHandler.sound.Play(SoundHandler.sound._bc); yield return(new WaitForSeconds(SoundHandler.sound._bc.length)); } else { optionBox.playerChoice = 0; SoundHandler.sound.Play(SoundHandler.sound._bb); var t = SoundHandler.sound._bb.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t); } while (t >= 0) { if (Skip) { Skip = false; t = 1; } t -= Time.deltaTime; yield return(null); } optionBox.PopupOptionBox("WHAT DO YOU THINK OF THE GAME NOW?", "IT'S GREAT", "IT'S STILL BAD"); while (optionBox.playerChoice == 0) { yield return(null); } if (optionBox.playerChoice == 1) { StoryHandler.likedGirlGameAgain = true; DatabaseHandler.PostVariableToDatabase(1, "likedGirlGameAgain"); SoundHandler.sound.Play(SoundHandler.sound._ca); var t1 = SoundHandler.sound._ca.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t1); } while (t1 >= 0) { if (Skip) { Skip = false; t1 = 1; } t1 -= Time.deltaTime; yield return(null); } } else { DatabaseHandler.PostVariableToDatabase(1, "nLikedGirlGameAgain"); SoundHandler.sound.Play(SoundHandler.sound._cb); yield return(SoundHandler.sound._cb.length); } optionBox.playerChoice = 0; } StartCoroutine(BigCrash()); }
public SageWoodResponse ValidateSageWoodMeter(string meterNo) { string rawRequest; SageWoodResponse woodResponse = new SageWoodResponse(); DatabaseHandler dh = new DatabaseHandler(); try { string clientId = "2019112800001"; string opName = "UDEMO"; string password = "******"; //string meterno = "14012018064";//replace with user input string date = DateTime.Now.ToString("yyyyMMddHHmmss").ToString(); string randomnumber = GenerateRandomNumber().ToString(); MeterInfo custInfo = new MeterInfo(); ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls; ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback (delegate { return(true); }); EANDeviceID deviceId = new EANDeviceID(); deviceId.ean = clientId; GenericDeviceID genericDeviceID = new GenericDeviceID(); genericDeviceID.id = clientId; PurchaseValueCurrency purchaseValue = new PurchaseValueCurrency(); purchaseValue.amt = new Currency(); purchaseValue.amt.symbol = "UGX"; purchaseValue.amt.value = Decimal.Parse("10"); Electricity electricity = new Electricity(); MsgID msg = new MsgID(); msg.dateTime = DateTime.Now.ToString("yyyyMMddHHmmss").ToString(); msg.uniqueNumber = randomnumber; AuthCred authCred = new AuthCred(); authCred.opName = opName; authCred.password = password; authCred.newPassword = ""; MsgID messageId = msg; AuthCred creds = authCred; MeterDetail meter = new MeterDetail(); meter.msno = meterNo; VendIDMethod vendIDMethod = new VendIDMethod(); vendIDMethod.meterIdentifier = meter; ConfirmCustomerReq request = new ConfirmCustomerReq(); XMLVendService21 sageWood = new XMLVendService21(); request.clientID = deviceId; request.msgID = msg; request.authCred = authCred; request.terminalID = genericDeviceID; request.idMethod = vendIDMethod; rawRequest = XmlConfirmCustomerReq(request); ConfirmCustomerResp response = sageWood.ConfirmCustomerRequest(request); string rawResponse = XmlConfirmCustomerResp(response); //log raw request and response dh.LogRequestAndResponse("SAGEWOOD", meterNo, rawRequest, rawResponse); foreach (ConfirmCustResult meterDetails in response.confirmCustResult) { woodResponse.Name = meterDetails.custVendDetail.name; woodResponse.Msno = meterDetails.custVendDetail.accNo; woodResponse.Address = meterDetails.custVendDetail.address; woodResponse.ContactNo = meterDetails.custVendDetail.contactNo; woodResponse.AccNo = meterDetails.custVendDetail.accNo; woodResponse.LocRef = meterDetails.custVendDetail.locRef; woodResponse.DaysOflastPurchase = meterDetails.custVendDetail.daysLastPurchase; woodResponse.StatusCode = "0"; woodResponse.StatusDescription = "SUCCESS"; } } catch (SoapException soapException) { //XMLVendFaultResp xmlVendFaultResp = XMLDeserialize.Deserialize(soapException.Detail); // if (xmlVendFaultResp.fault.GetType() == //typeof(UnknownMeterEx)) // { // Console.WriteLine("Unknown Meter Serial Number!"); // } // else // { // string fert = xmlVendFaultResp.fault.GetType().ToString(); // Console.WriteLine("Unexpected XMLVend Fault Response" + // "received: (" + xmlVendFaultResp.fault.GetType().ToString() // + ")" + xmlVendFaultResp.fault.desc); // } dh.LogError(soapException.Detail.InnerXml, meterNo, DateTime.Now, "SAGEWOOD"); woodResponse.StatusCode = "100"; woodResponse.Name = "INVALID METER NUMBER"; } catch (Exception ex) { Console.WriteLine("Error: " + ex); dh.LogError(ex.ToString(), meterNo, DateTime.Now, "SAGEWOOD"); woodResponse.StatusCode = "100"; woodResponse.Name = "INVALID METER NUMBER"; } return(woodResponse); }
public IEnumerator StartRandomGame2() { ClickHandler.Active = false; optionBox.playerChoice = 0; if (!StoryHandler.gaveUpFirstPuzzle) { SoundHandler.sound.Play(SoundHandler.sound.w); var t = SoundHandler.sound.w.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t); } while (t >= 0) { if (Skip) { Skip = false; t = 1; } t -= Time.deltaTime; yield return(null); } optionBox.PopupOptionBox("WHAT DO YOU WANT TO SAY?", "I LIKED IT", "YOUR GAME IS BETTER"); while (optionBox.playerChoice == 0) { yield return(null); } if (optionBox.playerChoice == 1) { StoryHandler.likedSimonGame = true; DatabaseHandler.PostVariableToDatabase(1, "likedSimonGame"); SoundHandler.sound.Play(SoundHandler.sound.xb); var t1 = SoundHandler.sound.xb.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t1); } while (t1 >= 0) { if (Skip) { Skip = false; t1 = 1; } t1 -= Time.deltaTime; yield return(null); } if (StoryHandler.likedGirlGame) { SoundHandler.sound.Play(SoundHandler.sound.xba); var t2 = SoundHandler.sound.ua.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t2); } while (t2 >= 0) { if (Skip) { Skip = false; t2 = 1; } t2 -= Time.deltaTime; yield return(null); } } SoundHandler.sound.PlaySecondary(SoundHandler.sound.loadingSound); gameStarterImage.enabled = true; gameStarterAnimator.enabled = true; gameStarterAnimator.Play("Opacity100P"); yield return(new WaitForSeconds(SoundHandler.sound.loadingSound.length)); SceneManager.LoadScene(7); } else { DatabaseHandler.PostVariableToDatabase(1, "nLikedSimonGame"); SoundHandler.sound.Play(SoundHandler.sound.xa); var t1 = SoundHandler.sound.xa.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t1); } while (t1 >= 0) { if (Skip) { Skip = false; t1 = 1; } t1 -= Time.deltaTime; yield return(null); } if (StoryHandler.likedGirlGame) { SoundHandler.sound.Play(SoundHandler.sound.xaa); var t2 = SoundHandler.sound.ua.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t2); } while (t2 >= 0) { if (Skip) { Skip = false; t2 = 1; } t2 -= Time.deltaTime; yield return(null); } } ClickHandler.Active = true; } optionBox.playerChoice = 0; } else { SoundHandler.sound.Play(SoundHandler.sound.wa); var t = SoundHandler.sound.wa.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t); } while (t >= 0) { if (Skip) { Skip = false; t = 1; } t -= Time.deltaTime; yield return(null); } if (StoryHandler.likedGirlGame) { SoundHandler.sound.Play(SoundHandler.sound.xba); var t1 = SoundHandler.sound.xba.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t1); } while (t1 >= 0) { if (Skip) { Skip = false; t1 = 1; } t1 -= Time.deltaTime; yield return(null); } } SoundHandler.sound.PlaySecondary(SoundHandler.sound.loadingSound); gameStarterImage.enabled = true; gameStarterAnimator.enabled = true; gameStarterAnimator.Play("Opacity100P"); yield return(new WaitForSeconds(SoundHandler.sound.loadingSound.length)); SceneManager.LoadScene(7); } }
//opens a new search page public async void Search() { await Navigation.PushAsync(new SearchPage(DatabaseHandler.GetDatabase().GetLocations())); }
//pre initialization private void PreInit() { //init the database DatabaseHandler.InitDatabase(); ImageBaseHandler.InitImageBaseHanlder(); }
private void Reqister_Click(object sender, EventArgs e) { DatabaseHandler handler = new DatabaseHandler(); handler.Reqister(textBox_Username.Text, textBox_email.Text, textBox_password.Text); }
public IEnumerator StartRandomGame() { optionBox.playerChoice = 0; ClickHandler.Active = false; yield return(new WaitForSeconds(1f)); SoundHandler.sound.Play(SoundHandler.sound.m); var t = SoundHandler.sound.m.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t); } while (t >= 0) { if (Skip) { Skip = false; t = 1; } t -= Time.deltaTime; yield return(null); } optionBox.PopupOptionBox("WHAT DO YOU WANT TO DO?", "TELL HIM", "REMAIN SILENT"); while (optionBox.playerChoice == 0) { yield return(null); } StoryHandler.saidName = optionBox.playerChoice == 1; optionBox.playerChoice = 0; if (StoryHandler.saidName) { DatabaseHandler.PostVariableToDatabase(1, "saidName"); SoundHandler.sound.Play(SoundHandler.sound.na); var t1 = SoundHandler.sound.na.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t1); } while (t1 >= 0) { if (Skip) { Skip = false; t1 = 1; } t1 -= Time.deltaTime; yield return(null); } } else { DatabaseHandler.PostVariableToDatabase(1, "nSaidName"); SoundHandler.sound.Play(SoundHandler.sound.nb); var t2 = SoundHandler.sound.nb.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t2); } while (t2 >= 0) { if (Skip) { Skip = false; t2 = 1; } t2 -= Time.deltaTime; yield return(null); } } SoundHandler.sound.Play(SoundHandler.sound.o); var t3 = SoundHandler.sound.o.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t3); } while (t3 >= 0) { if (Skip) { Skip = false; t3 = 1; } t3 -= Time.deltaTime; yield return(null); } infoBox.PopupInfoBox("TRY DRAGGING THE BLOCKS TO THE LIGHT", 5); giveUpButtonScript.PopdownGiveUpButton(); onFirstPuzzle = true; ClickHandler.Active = true; }
public static void BlockCenter() { DatabaseHandler.BlockCenter(CenterId); }
private void SaveConnectionForLater(IncomingLoginAttempt args) { DatabaseHandler.AddRecordToSavedConnections(args); }
public async Task OnCommandExecutedAsync(Optional <CommandInfo> command, ICommandContext context, IResult result) { bool error_state = false; switch (result) { case WestbotCommandResult customResult: if (!customResult.Get_reaction()) { break; //no reaction needed } if (customResult.IsSuccess) { error_state = AcceptState.Accept; } else { error_state = AcceptState.Error; } break; default: if (!string.IsNullOrEmpty(result.ErrorReason)) { error_state = AcceptState.Error; } else { error_state = AcceptState.Accept; } break; } string reaction_type; if (!error_state) { reaction_type = "Accept"; } else { reaction_type = "Error"; } int ReturnValue = DatabaseHandler.EmoteOrEmoji(reaction_type); if (ReturnValue == 0) { //Emojis string ReturnString = DatabaseHandler.GetRandomEmoji(reaction_type); Emoji emoji_to_add = new Emoji(ReturnString); await context.Message.AddReactionAsync(emoji_to_add); } else { //emotes long ReturnID = DatabaseHandler.GetRandomEmote(reaction_type); UInt64 ResultID = (UInt64)ReturnID; IEmote emote_to_add = context.Guild.Emotes.FirstOrDefault(x => x.Id == ResultID); //var emote_to_add = Context.Guild.GetEmoteAsync(result); await context.Message.AddReactionAsync((IEmote)emote_to_add); } }
public ReservationController(ReservationContext context, UserManager <Teacher> userManager) { _reservationContext = context; _databaseHandler = new DatabaseHandler(context); _userManager = userManager; }
public void UpdateSelfInDB() { DatabaseHandler db = new DatabaseHandler(); db.UpdatePatient(this); }
public int DeleteWithStoredProc(string storedProc, params object[] storedProcParameters) { int rowsAffected = DatabaseHandler.ExecuteNonQuery(storedProc, storedProcParameters); return(rowsAffected); }
public IEnumerator FinishFirstPuzzle(bool failed = false) { if (!failed) { giveUpButtonScript.PopupGiveUpButton(); } foreach (var square in GameObject.FindGameObjectsWithTag("Square")) { square.GetComponent <BoxCollider2D>().enabled = false; } if (failed) { StoryHandler.gaveUpFirstPuzzle = true; DatabaseHandler.PostVariableToDatabase(1, "gaveUpFirstPuzzle"); } else { DatabaseHandler.PostVariableToDatabase(1, "nGaveUpFirstPuzzle"); } SoundHandler.sound.Play(failed ? SoundHandler.sound.pa : SoundHandler.sound.p); var t = failed ? SoundHandler.sound.pa.length : SoundHandler.sound.p.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t); } while (t >= 0) { if (Skip) { Skip = false; t = 1; } t -= Time.deltaTime; yield return(null); } var sound = SoundHandler.sound.qb; if (StoryHandler.likedGirlGame) { sound = SoundHandler.sound.qa; } SoundHandler.sound.Play(sound); var t1 = sound.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t1); } while (t1 >= 0) { if (Skip) { Skip = false; t1 = 1; } t1 -= Time.deltaTime; yield return(null); } if (StoryHandler.madeSignFall && StoryHandler.scrambledSign && !StoryHandler.wentToGuyGame) { sound = SoundHandler.sound.rb; } else { sound = SoundHandler.sound.ra; } SoundHandler.sound.Play(sound); var t2 = sound.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t2); } while (t2 >= 0) { if (Skip) { Skip = false; t2 = 1; } t2 -= Time.deltaTime; yield return(null); } infoBox.PopupInfoBox(StoryHandler.likedGirlGame ? "PAUL LEFT THE GAME" : "SERENA AND PAUL LEFT THE GAME", 6); optionBox.playerChoice = 0; yield return(new WaitForSeconds(2)); SoundHandler.sound.Play(SoundHandler.sound.s); var t3 = SoundHandler.sound.s.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t3); } while (t3 >= 0) { if (Skip) { Skip = false; t3 = 1; } t3 -= Time.deltaTime; yield return(null); } optionBox.PopupOptionBox("WHAT DO YOU WANT TO DO?", "GO WITH SIMON", "STAY WITH DAVE"); while (optionBox.playerChoice == 0) { yield return(null); } sound = optionBox.playerChoice == 1 ? SoundHandler.sound.ta : SoundHandler.sound.tb; optionBox.playerChoice = 0; SoundHandler.sound.Play(sound); var t4 = sound.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t4); } while (t4 >= 0) { if (Skip) { Skip = false; t4 = 1; } t4 -= Time.deltaTime; yield return(null); } sound = failed ? SoundHandler.sound.taa : SoundHandler.sound.tba; SoundHandler.sound.Play(sound); var t5 = sound.length; if (isSkipMode) { skipButtonScript.PopupSkipButton(t5); } while (t5 >= 0) { if (Skip) { Skip = false; t5 = 1; } t5 -= Time.deltaTime; yield return(null); } SoundHandler.sound.PlaySecondary(SoundHandler.sound.loadingSound); gameStarterImage.enabled = true; gameStarterAnimator.enabled = true; gameStarterAnimator.Play("Opacity100BL"); yield return(new WaitForSeconds(SoundHandler.sound.loadingSound.length)); SceneManager.LoadScene(5); }
public SchedulerService(DatabaseHandler database) { _database = database; }