Exemplo n.º 1
0
        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);
        }
Exemplo n.º 2
0
        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);
        }
Exemplo n.º 3
0
        private async void Checkout_Load(object sender, EventArgs e)
        {
            location_list = await CLocation.RetrieveLocationList();

            comboBox_Pincode.Items.AddRange(location_list.ToArray());
        }
Exemplo n.º 4
0
        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
                    }
                    );
                }
            }
        }
Exemplo n.º 5
0
        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);
        }
Exemplo n.º 6
0
        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);
        }