예제 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {//trebuie sa aflu id-ul clientului ca sa stiu al cui cos e
            if (!Page.IsPostBack)
            {
                string connString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Users\\vali\\Downloads\\mine-licenta\\licenta\\licenta\\App_Data\\ASPNETDB.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True";
                string query_id   = "select ClientId from aspnet_Users where UserId='" + Membership.GetUser().ProviderUserKey + "' ;";

                SqlConnection  con        = new SqlConnection(connString);
                SqlDataAdapter my_adapter = new SqlDataAdapter(query_id, con);
                DataSet        dss        = new DataSet();
                my_adapter.Fill(dss, "user");
                con.Close();

                idClient = dss.Tables["user"].Rows[0][0].ToString();

                RepeaterCart.DataSource = ShowCart();
                RepeaterCart.DataBind();

                Client master = (Client)Page.Master;
                if (master != null)
                {
                    master.UpdateCart(idClient);
                }
            }
        }
예제 #2
0
    private void LoadData()
    {
        using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
        {
            PelangganLogin Pelanggan = (PelangganLogin)Session["PelangganLogin"];

            //MENCARI TRANSAKSI SESSION
            var TransaksiECommerceDetail = db.TBTransaksiECommerceDetails
                                           .Where(item => item.TBTransaksiECommerce.IDPelanggan == Pelanggan.IDPelanggan);

            if (TransaksiECommerceDetail.Count() > 0)
            {
                MultiView1.ActiveViewIndex = 1;

                RepeaterCart.DataSource = TransaksiECommerceDetail
                                          .Select(item => new
                {
                    item.IDTransaksiECommerceDetail,
                    Foto = "/images/cover/" + item.TBStokProduk.TBKombinasiProduk.IDProduk + ".jpg",
                    item.TBStokProduk.TBKombinasiProduk.Nama,
                    item.Quantity,
                    Harga = item.TBStokProduk.HargaJual,
                    Total = (item.Quantity * item.TBStokProduk.HargaJual)
                })
                                          .ToArray();
                RepeaterCart.DataBind();
            }
            else
            {
                MultiView1.ActiveViewIndex = 0;
            }
        }
    }
예제 #3
0
    private void LoadData()
    {
        using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
        {
            PelangganLogin Pelanggan = (PelangganLogin)Session["PelangganLogin"];

            //MENCARI TRANSAKSI SESSION
            var TransaksiECommerce = db.TBTransaksiECommerces
                                     .FirstOrDefault(item => item.IDPelanggan == Pelanggan.IDPelanggan);

            if (TransaksiECommerce != null)
            {
                var TransaksiECommerceDetail = TransaksiECommerce.TBTransaksiECommerceDetails;

                StokProduk_Class ClassStokProduk = new StokProduk_Class(db);

                var Result = ClassStokProduk.ValidasiStokProdukTransaksi(TransaksiECommerceDetail.ToArray());

                LiteralWarning.Text = "";

                foreach (var item in Result)
                {
                    LiteralWarning.Text += item + "<br/>";
                }

                MultiView1.ActiveViewIndex = 1;

                RepeaterCart.DataSource = TransaksiECommerceDetail
                                          .Select(item => new
                {
                    item.IDTransaksiECommerceDetail,
                    Foto = "/images/cover/" + item.TBStokProduk.TBKombinasiProduk.IDProduk + ".jpg",
                    item.TBStokProduk.TBKombinasiProduk.Nama,
                    item.Quantity,
                    Harga = item.TBStokProduk.HargaJual,
                    Total = (item.Quantity * item.TBStokProduk.HargaJual)
                })
                                          .ToArray();
                RepeaterCart.DataBind();

                var total = TransaksiECommerceDetail.Sum(item => item.Quantity * item.TBStokProduk.HargaJual).ToString();
                LiteralTotal.Text = total.ToFormatHarga();
            }
            else
            {
                MultiView1.ActiveViewIndex = 0;
            }
        }
    }
예제 #4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
            {
                //VALIDASI STOK PRODUK
                ValidasiStokProdukTransaksi(db);

                //PROVINSI
                DropDownListProvinsi.DataSource     = db.TBKurirProvinsis.OrderBy(item => item.Nama).ToArray();
                DropDownListProvinsi.DataValueField = "IDKurirProvinsi";
                DropDownListProvinsi.DataTextField  = "Nama";
                DropDownListProvinsi.DataBind();
                DropDownListProvinsi.Items.Insert(0, new ListItem {
                    Selected = true, Text = "- Pilih Provinsi -", Value = "0"
                });

                PelangganLogin Pelanggan = (PelangganLogin)Session["PelangganLogin"];

                var Data = db.TBPelanggans
                           .FirstOrDefault(item => item.IDPelanggan == Pelanggan.IDPelanggan);

                if (Data != null)
                {
                    TextBoxNamaLengkap.Text  = Data.NamaLengkap;
                    TextBoxAlamatEmail.Text  = Data.Email;
                    TextBoxNomorTelepon.Text = Data.Handphone;

                    var Alamat = Data.TBAlamats
                                 .OrderByDescending(item => item.IDAlamat)
                                 .FirstOrDefault();

                    if (Alamat != null)
                    {
                        TextBoxAlamat.Text  = Alamat.AlamatLengkap;
                        TextBoxKodePos.Text = Alamat.KodePos;
                    }

                    //MENCARI TRANSAKSI SESSION
                    var TransaksiECommerceDetail = db.TBTransaksiECommerceDetails
                                                   .Where(item => item.TBTransaksiECommerce.IDPelanggan == Pelanggan.IDPelanggan);

                    if (TransaksiECommerceDetail.Count() > 0)
                    {
                        RepeaterCart.DataSource = TransaksiECommerceDetail
                                                  .Select(item => new
                        {
                            item.IDTransaksiECommerceDetail,
                            Foto = "/images/cover/" + item.TBStokProduk.TBKombinasiProduk.IDProduk + ".jpg",
                            item.TBStokProduk.TBKombinasiProduk.Nama,
                            item.Quantity,
                            Harga = item.TBStokProduk.HargaJual,
                            Total = (item.Quantity * item.TBStokProduk.HargaJual)
                        })
                                                  .ToArray();
                        RepeaterCart.DataBind();
                    }
                    else
                    {
                        Response.Redirect("_Cart.aspx");
                    }
                }
                else
                {
                    Response.Redirect("_Cart.aspx");
                }
            }
        }
    }