public async static Task <CLocation> Retrieve(Int32 pincode) { CLocation ret = null; try { String sql = "SELECT * FROM `location` WHERE `pincode` = @pincode LIMIT 1"; MySqlCommand cmd = new MySqlCommand(sql, Program.conn); cmd.Parameters.AddWithValue("@pincode", pincode); DbDataReader reader = await cmd.ExecuteReaderAsync(); cmd.Dispose(); if (!(await reader.ReadAsync())) { if (!reader.IsClosed) { reader.Close(); } CUtils.LastLogMsg = "Location with pincode '" + pincode + "' not found!"; return(ret); } ret = new CLocation(pincode, reader.GetString(reader.GetOrdinal("city")), reader.GetString(reader.GetOrdinal("state")), reader.GetString(reader.GetOrdinal("country"))); if (!reader.IsClosed) { reader.Close(); } CUtils.LastLogMsg = null; } catch (Exception ex) { #if DEBUG Console.WriteLine(ex.Message + " " + ex.StackTrace); #endif CUtils.LastLogMsg = "Unahandled Exception!"; } return(ret); }
private async void Seller_Home_Product_Add_Load(object sender, EventArgs e) { // Fill Default Fields item = null; extField = new List <extFieldStruct>(); ButtonState = false; cat_list = await CCatagory.RetrieveCatagoryList(0); comboBox_Catagory.Items.AddRange(cat_list.ToArray()); location_list = await CLocation.RetrieveLocationList(); comboBox_Pincode.Items.AddRange(location_list.ToArray()); imgSize = pictureBox_Picture.Size; // Disable Form Auto Size Later Size temp = this.Size; this.AutoSize = false; this.Size = temp; // Enable Size Manager & Force Reset Size Seller_Home_Product_Add_SizeChanged_Custom(null, null); this.SizeChanged += new EventHandler(Seller_Home_Product_Add_SizeChanged_Custom); }
private async void Checkout_Load(object sender, EventArgs e) { location_list = await CLocation.RetrieveLocationList(); comboBox_Pincode.Items.AddRange(location_list.ToArray()); }
private async void tabControl_MAIN_SelectedIndexChanged(object sender, EventArgs e) { if (tabControl_MAIN.SelectedTab.Text.Equals("Inventory")) { dataGridView_Inventory.Rows.Clear(); List <CSeller_Inventory> inv_list = await CSeller_Inventory.RetrieveSellerInventoryList(CUser.cur_user.id); foreach (CSeller_Inventory x in inv_list) { CProduct y = await CProduct.Retrieve(x.product_id); dataGridView_Inventory.Rows.Add ( new object[] { x.product_id, y.name, x.price, x.quantity, x.pincode, x.warranty, x, y } ); } } else if (tabControl_MAIN.SelectedTab.Text.Equals("Orders")) { dataGridView_Orders.Rows.Clear(); List <COrder> order_list = await COrder.RetrieveOrdertBySellerID(CUser.cur_user.id); DistanceMatrixRequest req = new DistanceMatrixRequest(); req.ApiKey = Program.szGoogleMapsAPI_key; req.Mode = DistanceMatrixTravelModes.driving; foreach (COrder x in order_list) { CProduct y = await CProduct.Retrieve(x.product_id); CSeller_Inventory z = await CSeller_Inventory.Retrieve(x.seller_id, x.product_id); CLocation c = await CLocation.Retrieve(x.pincode); String address = x.street + ", " + c.city + ", " + c.state + ", " + c.country + ", " + x.pincode; // Calculate ETA req.Origins = new string[] { z.pincode.ToString() }; req.Destinations = new string[] { x.pincode.ToString() }; DistanceMatrixResponse resp = await GoogleMapsApi.GoogleMaps.DistanceMatrix.QueryAsync(req); TimeSpan ts = resp.Rows.ElementAt <Row>(0).Elements.ElementAt <Element>(0).Duration.Value; ts = ts - (DateTime.Now - x.started_at.AddDays(1)); dataGridView_Orders.Rows.Add ( new object[] { x.id, y.name, z.price, x.quantity, address, x.started_at, (ts.Days) + " Day(s) " + (ts.Hours) + " Hour(s)", x.order_status, x, y, z, c } ); } } }
private async void Customer_Home_Product_Open_Load(object sender, EventArgs e) { // Fill Default Fields textBox_Name.Text = item.name; comboBox_Catagory.Items.Add(await CCatagory.Retrieve(item.catagory_id)); comboBox_Catagory.SelectedIndex = 0; richTextBox_Description.Text = item.description; progressBar_Rating.Value = (Int32)(item.rating * 100.0); location_list = await CLocation.RetrieveLocationList(); comboBox_Pincode.Items.AddRange(location_list.ToArray()); imgSize = item.image.Size; pictureBox_Picture.Image = item.image; // Fill Product Fields List <CProduct_Field> extlist = await CProduct_Field.RetrieveProductFieldList(item.id); foreach (CProduct_Field x in extlist) { tableLayoutPanel3.RowCount++; tableLayoutPanel3.RowStyles.Add(new RowStyle()); Label extLabel = new Label() { TabIndex = 0, Font = new Font("Microsoft Sans Serif", 9.75F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))), Text = x.field_name, Size = new Size(16, 16), Dock = DockStyle.Fill }; TextBox extTextBox = new TextBox() { TabIndex = 1, Text = x.field_value, Size = new Size(16, 16), Dock = DockStyle.Fill, ReadOnly = true }; tableLayoutPanel3.Controls.Add(extLabel, 0, tableLayoutPanel3.RowCount - 1); tableLayoutPanel3.Controls.Add(extTextBox, 1, tableLayoutPanel3.RowCount - 1); } // Retrieve Sellers With Products List <CSeller_Inventory> list1 = await CSeller_Inventory.RetrieveSellerInventoryListByProduct(item.id); if (list1.Count < 1) { comboBox_Pincode.Enabled = false; button_Check.Enabled = false; textBox_Quantity.Enabled = false; button_AddToCart.Enabled = false; } dataGridView_SellerList.Columns.Add("seller_id", "Seller ID"); dataGridView_SellerList.Columns.Add("name", "Seller Name"); dataGridView_SellerList.Columns.Add("price", "Price"); dataGridView_SellerList.Columns.Add("quantity", "Available"); dataGridView_SellerList.Columns.Add("warranty", "Warranty"); dataGridView_SellerList.Columns.Add("shipping_time", "Shipping Time"); // Invisible Containers inside Data Grid dataGridView_SellerList.Columns.Add("extra_1", "extra_1"); dataGridView_SellerList.Columns.Add("extra_2", "extra_2"); dataGridView_SellerList.Columns["extra_1"].Visible = false; dataGridView_SellerList.Columns["extra_2"].Visible = false; for (Int16 i = 0; i < list1.Count; ++i) { CSeller_Inventory x = list1[i]; CUser_Seller y = await CUser_Seller.Retrieve(x.seller_id); dataGridView_SellerList.Rows.Add ( new object[] { x.seller_id, y.name, x.price, x.quantity, x.warranty, null, x, y, } ); } // Disable Form Auto Size Later Size temp = this.Size; this.AutoSize = false; this.Size = temp; // Enable Size Manager & Force Reset Size Customer_Home_Product_Open_SizeChanged_Custom(null, null); this.SizeChanged += new EventHandler(Customer_Home_Product_Open_SizeChanged_Custom); }
private async void Seller_Home_Product_Open_Load(object sender, EventArgs e) { // Fill Default Fields textBox_Name.Text = item.name; comboBox_Catagory.Items.Add(await CCatagory.Retrieve(item.catagory_id)); comboBox_Catagory.SelectedIndex = 0; richTextBox_Description.Text = item.description; progressBar_Rating.Value = (Int32)(item.rating * 100.0); location_list = await CLocation.RetrieveLocationList(); comboBox_Pincode.Items.AddRange(location_list.ToArray()); imgSize = item.image.Size; pictureBox_Picture.Image = item.image; // Fill Product Fields List <CProduct_Field> extlist = await CProduct_Field.RetrieveProductFieldList(item.id); foreach (CProduct_Field x in extlist) { tableLayoutPanel3.RowCount++; tableLayoutPanel3.RowStyles.Add(new RowStyle()); Label extLabel = new Label() { TabIndex = 0, Font = new Font("Microsoft Sans Serif", 9.75F, FontStyle.Regular, GraphicsUnit.Point, ((byte)(0))), Text = x.field_name, Size = new Size(16, 16), Dock = DockStyle.Fill }; TextBox extTextBox = new TextBox() { TabIndex = 1, Text = x.field_value, Size = new Size(16, 16), Dock = DockStyle.Fill, ReadOnly = true }; tableLayoutPanel3.Controls.Add(extLabel, 0, tableLayoutPanel3.RowCount - 1); tableLayoutPanel3.Controls.Add(extTextBox, 1, tableLayoutPanel3.RowCount - 1); } // Retrieve Inventory if Exists invitem = await CSeller_Inventory.Retrieve(CUser.cur_user.id, item.id); if (invitem != null) { textBox_Price.Text = invitem.price.ToString(); textBox_Price.ReadOnly = true; foreach (CLocation x in comboBox_Pincode.Items) { if (x.pincode == invitem.pincode) { comboBox_Pincode.SelectedItem = x; break; } } comboBox_Pincode.Enabled = false; textBox_Warranty.Text = invitem.warranty.ToString(); textBox_Warranty.ReadOnly = true; } // Disable Form Auto Size Later Size temp = this.Size; this.AutoSize = false; this.Size = temp; // Enable Size Manager & Force Reset Size Seller_Home_Product_Open_SizeChanged_Custom(null, null); this.SizeChanged += new EventHandler(Seller_Home_Product_Open_SizeChanged_Custom); }