private void LoadPage() { DataTable tempIL = OrderTable.DT; RepeaterOrder.DataSource = null; RepeaterOrder.DataBind(); RepeaterOrder.DataSource = tempIL; RepeaterOrder.DataBind(); LabelTotal.Text = "Grand Total: ₱ " + OrderTable.getTotal(); }
protected void Order() { if (Session["LabId"] != null) { dtorder = operation.GetOrderReportGenerated(Session["LabId"].ToString()); if (dtorder != null) { RepeaterOrder.DataSource = dtorder; RepeaterOrder.DataBind(); } } }
protected void PatientOrder() { if (Session["LabId"] != null && Request.QueryString["pid"] != null) { dtorder = operation.PatientOrder(Session["LabId"].ToString(), Request.QueryString["pid"].ToString()); if (dtorder != null) { RepeaterOrder.DataSource = dtorder; RepeaterOrder.DataBind(); } } }
protected void GetOrder() { string ptc = Request.QueryString["PTC"].ToString(); string sql = "SELECT orderno AS Code,supplierid AS SupplierCode,suppliernm AS Supplier,shtime AS Date," + "ywyid AS ClerkCode,ywynm AS Clerk,depid AS DepCode,depnm AS Dep,totalstate AS OrderState," + "marid AS MaterialCode,marnm AS MaterialName,marcz AS Attribute,margb AS GB," + "margg AS MaterialStandard,marunit AS Unit,zxnum AS Number,recgdnum AS ArrivedNumber,recdate AS ArrivedDate," + "price AS UnitPrice,taxrate AS TaxRate,ctprice AS CTUP,amount AS Amount,ctamount AS CTA," + "planmode AS PlanMode,ptcode AS PTC,detailstate AS ItemState " + " FROM View_TBPC_PURORDERDETAIL_PLAN_TOTAL WHERE ptcode='" + ptc + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); RepeaterOrder.DataSource = dt; RepeaterOrder.DataBind(); }
protected void Order() { if (Session["LabId"] != null) { dsorder = operation.GetOrderReportNotGenerated(Session["LabId"].ToString()); if (dsorder != null) { dsorder.Relations.Add(new DataRelation("OrderedTest", dsorder.Tables[0].Columns["OrderID"], dsorder.Tables[1].Columns["OrderID"], false)); dsorder.Relations.Add(new DataRelation("OrderedAllTest", dsorder.Tables[0].Columns["OrderID"], dsorder.Tables[2].Columns["OrderID"], false)); RepeaterOrder.DataSource = dsorder; RepeaterOrder.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { Thread.CurrentThread.CurrentCulture = new CultureInfo("pt-Pt"); if (Session["userlogin"] == null) { if (Session["anonimo"] != null) { OrderDetailsTemps = (List <OrderDetailsTemp>)Session["anonimo"]; lbl_total.Text = OrderDetailsTemps.Sum(o => Convert.ToDecimal((decimal)o.Price * o.Quantity)).ToString("C"); lbl_sub.Text = OrderDetailsTemps.Sum(o => Convert.ToDecimal((decimal)o.Price * o.Quantity)).ToString("C"); numItemInCart.Text = OrderDetailsTemps.Count().ToString(); RepeaterOrder.DataSource = OrderDetailsTemps; RepeaterOrder.DataBind(); } } else { lbl_user.Text = $"Benvido {Session["userlogin"].ToString()}"; btn_login.Text = "Logout"; id = Convert.ToInt32(Session["userId"].ToString()); BindingRepeaterOrder(id); if (Session["userRole"].ToString() == "Reseller") { resellerInfo.Visible = true; } } if (OrderDetailsTemps.Count == 0 || OrderDetailsTemps == null) { btn_checkout.Enabled = false; } }
public void BindingRepeaterOrder(int id) { SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["OnShopCenterConnectionString"].ConnectionString); SqlCommand mycommand = new SqlCommand { CommandType = CommandType.StoredProcedure, CommandText = "GetOrderDetails", Connection = myConn }; mycommand.Parameters.AddWithValue("@userId", id); myConn.Open(); var reader = mycommand.ExecuteReader(); SqlMoney money = 0.0m; while (reader.Read()) { numItemInCart.Text = reader.GetInt32(7).ToString(); lbl_total.Text = ((decimal)reader.GetSqlMoney(8)).ToString("C"); lbl_sub.Text = ((decimal)reader.GetSqlMoney(8)).ToString("C"); SqlMoney price = reader.GetSqlMoney(2); if (Session["userRole"].ToString() == "Reseller") { price -= price * (SqlMoney)0.2; money += price * reader.GetInt32(5); lbl_sub.Text = money.ToString(); lbl_total.Text = money.ToString(); } string base64 = string.Empty; if (reader[9] != null && reader[9].ToString().Length > 1) { base64 = Convert.ToBase64String((byte[])reader[9]); } string path; if (string.IsNullOrEmpty(base64)) { path = "../Config/images/no-image.png"; } else { path = $"data:image/jpeg;base64,{base64}"; } OrderDetailsTemps.Add(new OrderDetailsTemp { ProductId = reader.GetInt32(0), ProductName = reader.GetString(1), Price = price, Description = reader.GetString(3), Category = reader.GetString(4), Quantity = reader.GetInt32(5), UserId = reader.GetInt32(6), ImagePath = path }); } reader.Close(); myConn.Close(); RepeaterOrder.DataSource = OrderDetailsTemps; RepeaterOrder.DataBind(); }
private void LoadData() { PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"]; Konfigurasi_Class Konfigurasi_Class = new Konfigurasi_Class(Pengguna.IDGrupPengguna); DateTime[] BulanIni = new DateTime[2]; DateTime[] BulanLalu = new DateTime[2]; DateTime[] HariIni = new DateTime[2]; DateTime[] Kemarin = new DateTime[2]; BulanIni = Pengaturan.BulanIni(); BulanLalu = Pengaturan.BulanSebelumnya(); HariIni = Pengaturan.HariIni(); Kemarin = Pengaturan.HariSebelumnya(); #region Aktifitas Transaksi if (Konfigurasi_Class.ValidasiKonfigurasi(EnumKonfigurasi.AktifitasTransaksi)) { PanelAktifitasTransaksi1.Visible = true; //////PanelAktifitasTransaksi2.Visible = true; PanelAktifitasTransaksi3.Visible = true; using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { var _transaksi = db.TBTransaksis .Where(item => item.IDTempat == Pengguna.IDTempat && item.TanggalOperasional.Value.Date >= BulanLalu[0] && item.TanggalOperasional.Value.Date <= BulanIni[1] && item.IDStatusTransaksi == (int)EnumStatusTransaksi.Complete) .Select(item => new { item.IDTempat, item.TanggalOperasional, item.JumlahProduk, item.GrandTotal }).ToArray(); var _transaksiHariIni = _transaksi .Where(item => item.TanggalOperasional.Value.Date >= HariIni[0] && item.TanggalOperasional.Value.Date <= HariIni[1]).ToArray(); var _transaksiKemarin = _transaksi .Where(item => item.TanggalOperasional.Value.Date >= Kemarin[0] && item.TanggalOperasional.Value.Date <= Kemarin[1]).ToArray(); var _pelanggan = db.TBPelanggans .Where(item => item.TanggalDaftar.Value.Date >= BulanLalu[0] && item.TanggalDaftar.Value.Date <= BulanIni[1]).ToArray(); var _pelangganBulanLalu = db.TBPelanggans .Where(item => item.TanggalDaftar.Value.Date >= BulanLalu[0] && item.TanggalDaftar.Value.Date <= BulanLalu[1]).Count(); #region GRAFIK TRANSAKSI string ResultTransaksi = string.Empty; var _dataTransaksi = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanIni[0] && item.TanggalOperasional.Value.Date <= BulanIni[1]) .GroupBy(item => item.TanggalOperasional.Value.Day) .Select(item => new { Key = item.Key, GrandTotal = item.Sum(item2 => item2.GrandTotal) ?? 0 }).ToArray(); Random rd = new Random(); string[] labelsXTanggal = Manage.GetRangeDayOfMonth(Manage.GetJamServer()); ReportChart_Class ClassReport = new ReportChart_Class(); ReportChartLine_Class LineSingle = new ReportChartLine_Class(); LineSingle.Label = "My dataset"; LineSingle.Color = Manage.GetHexadecimalSAP(EnumColorSAP.Hue1); LineSingle.Data = new List <string>(); foreach (var item in labelsXTanggal) { if (_dataTransaksi.FirstOrDefault(item2 => item2.Key.ToString() == item) != null) { LineSingle.Data.Add(_dataTransaksi.FirstOrDefault(item2 => item2.Key.ToString() == item).GrandTotal.ToString()); } else { LineSingle.Data.Add("0"); } } LiteralChartPenjualan.Text = ClassReport.GetChartTrendAnalysis("CanvasChartPenjualan", string.Empty, "Tanggal", "Sales", labelsXTanggal, LineSingle); #endregion #region GRAFIK TRANSAKSI PELANGGAN //LiteralChart.Text += "<script> $(function () { var dataChart = ["; //var dataTransaksi = _transaksiBulanIni // .GroupBy(item => item.TanggalOperasional.Value.Date) // .Select(item => new // { // Key = item.Key, // Jumlah = item.Count() // }).ToArray(); //var dataPelanggan = _pelangganBulanIni // .GroupBy(item => item.TanggalDaftar.Value.Date) // .Select(item => new // { // Key = item.Key, // Jumlah = item.Count() // }).ToArray(); //for (DateTime date = BulanIni[0]; date <= BulanIni[1]; date = date.AddDays(1)) //{ // var _transaksi = dataTransaksi.FirstOrDefault(item => item.Key.Date == date.Date); // int _jumlahTransaksi = 0; // if (_transaksi != null) // _jumlahTransaksi = _transaksi.Jumlah; // var _pelanggan = dataPelanggan.FirstOrDefault(item => item.Key.Date == date.Date); // int _jumlahPelanggan = 0; // if (_pelanggan != null) // _jumlahPelanggan = _pelanggan.Jumlah; // LiteralChart.Text += "{ 'y': '" + date.Day + "', 'Transaksi': " + _jumlahTransaksi + ", 'Pelanggan': " + _jumlahPelanggan + " },"; //} //LiteralChart.Text += "]; Morris.Line({ element: 'graph', data: dataChart, xkey: 'y',"; //LiteralChart.Text += "ykeys: ['Transaksi', 'Pelanggan'],"; //LiteralChart.Text += "labels: ['Transaksi', 'Pelanggan'],"; //LiteralChart.Text += "lineColors:['#0aa699','#d1dade'],"; //LiteralChart.Text += " parseTime: false}); eval(dataChart); });"; //LiteralChart.Text += "</script>"; #endregion LabelPenjualanBulanIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanIni[0] && item.TanggalOperasional.Value.Date <= BulanIni[1]).Sum(item => item.GrandTotal).ToFormatHarga(); LabelQuantityBulanIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanIni[0] && item.TanggalOperasional.Value.Date <= BulanIni[1]).Sum(item => item.JumlahProduk).ToFormatHargaBulat(); LabelPelangganBulanIni.Text = _pelanggan.Where(item => item.TanggalDaftar.Value.Date >= BulanIni[0] && item.TanggalDaftar.Value.Date <= BulanIni[1]).Count().ToFormatHargaBulat(); LabelTransaksiBulanIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanIni[0] && item.TanggalOperasional.Value.Date <= BulanIni[1]).Count().ToFormatHargaBulat(); LabelPenjualanBulanLalu.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanLalu[0] && item.TanggalOperasional.Value.Date <= BulanLalu[1]).Sum(item => item.GrandTotal).ToFormatHarga(); LabelQuantityBulanLalu.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanLalu[0] && item.TanggalOperasional.Value.Date <= BulanLalu[1]).Sum(item => item.JumlahProduk).ToFormatHargaBulat(); LabelPelangganBulanLalu.Text = _pelanggan.Where(item => item.TanggalDaftar.Value.Date >= BulanLalu[0] && item.TanggalDaftar.Value.Date <= BulanLalu[1]).ToFormatHargaBulat(); LabelTransaksiBulanLalu.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= BulanLalu[0] && item.TanggalOperasional.Value.Date <= BulanLalu[1]).Count().ToFormatHargaBulat(); LabelPenjualanHariIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= HariIni[0] && item.TanggalOperasional.Value.Date <= HariIni[1]).Sum(item => item.GrandTotal).ToFormatHarga(); LabelQuantityHariIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= HariIni[0] && item.TanggalOperasional.Value.Date <= HariIni[1]).Sum(item => item.JumlahProduk).ToFormatHargaBulat(); LabelPelangganHariIni.Text = _pelanggan.Where(item => item.TanggalDaftar.Value.Date >= HariIni[0] && item.TanggalDaftar.Value.Date <= HariIni[1]).Count().ToFormatHargaBulat(); LabelTransaksiHariIni.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= HariIni[0] && item.TanggalOperasional.Value.Date <= HariIni[1]).Count().ToFormatHargaBulat(); LabelPenjualanKemarin.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= Kemarin[0] && item.TanggalOperasional.Value.Date <= Kemarin[1]).Sum(item => item.GrandTotal).ToFormatHarga(); LabelQuantityKemarin.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= Kemarin[0] && item.TanggalOperasional.Value.Date <= Kemarin[1]).Sum(item => item.JumlahProduk).ToFormatHargaBulat(); LabelPelangganKemarin.Text = _pelanggan.Where(item => item.TanggalDaftar.Value.Date >= Kemarin[0] && item.TanggalDaftar.Value.Date <= Kemarin[1]).Count().ToFormatHargaBulat(); LabelTransaksiKemarin.Text = _transaksi.Where(item => item.TanggalOperasional.Value.Date >= Kemarin[0] && item.TanggalOperasional.Value.Date <= Kemarin[1]).Count().ToFormatHargaBulat(); } } else { PanelAktifitasTransaksi1.Visible = false; //////PanelAktifitasTransaksi2.Visible = false; PanelAktifitasTransaksi3.Visible = false; } #endregion #region Transaksi Terakhir if (Konfigurasi_Class.ValidasiKonfigurasi(EnumKonfigurasi.TransaksiTerakhir)) { panelTransaksiTerakhir.Visible = true; using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { var TransaksiTerakhir = db.TBTransaksis .Where(item => item.IDStatusTransaksi.HasValue && item.IDTempat == Pengguna.IDTempat) .Select(item => new { item.IDTransaksi, item.IDTempat, item.Nomor, item.TanggalTransaksi, Persentase = Persentase(item.IDStatusTransaksi.Value, item.TBStatusTransaksi.Nama), item.JumlahProduk, item.GrandTotal }).OrderByDescending(item => item.Nomor).Take(10).ToArray(); RepeaterOrder.DataSource = TransaksiTerakhir; RepeaterOrder.DataBind(); } } else { panelTransaksiTerakhir.Visible = false; } #endregion LoadStokHabis(Konfigurasi_Class); #region PO Bahan BakuJatuh Tempo if (Konfigurasi_Class.ValidasiKonfigurasi(EnumKonfigurasi.POBahanBakuJatuhTempo)) { PanelPOBahanBakuJatuhTempo.Visible = true; using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { decimal batas = db.TBStoreKonfigurasis.FirstOrDefault(item => item.IDStoreKonfigurasi == (int)EnumStoreKonfigurasi.JumlahHariSebelumJatuhTempo).Pengaturan.ToDecimal(); RepeaterPOBahanBakuJatuhTempo.DataSource = db.TBPOProduksiBahanBakus .Where(item => item.IDTempat == Pengguna.IDTempat && item.EnumJenisProduksi != (int)PilihanEnumJenisProduksi.ProduksiSendiri && ((int)((item.TanggalJatuhTempo.Value.Date - DateTime.Now.Date).TotalDays) < batas)) .Select(item => new { ClassWarna = Warna((int)((item.TanggalJatuhTempo.Value.Date - DateTime.Now.Date).TotalDays), batas), item.IDPOProduksiBahanBaku, item.TBSupplier.Nama, item.Tanggal, item.TanggalJatuhTempo, }) .OrderBy(item => item.Tanggal) .ToArray(); RepeaterPOBahanBakuJatuhTempo.DataBind(); } } else { PanelPOBahanBakuJatuhTempo.Visible = false; } #endregion #region PO Bahan BakuJatuh Tempo if (Konfigurasi_Class.ValidasiKonfigurasi(EnumKonfigurasi.POProdukJatuhTempo)) { PanelPOBahanBakuJatuhTempo.Visible = true; using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { decimal batas = db.TBStoreKonfigurasis.FirstOrDefault(item => item.IDStoreKonfigurasi == (int)EnumStoreKonfigurasi.JumlahHariSebelumJatuhTempo).Pengaturan.ToDecimal(); RepeaterPOProdukJatuhTempo.DataSource = db.TBPOProduksiProduks .Where(item => item.IDTempat == Pengguna.IDTempat && item.EnumJenisProduksi != (int)PilihanEnumJenisProduksi.ProduksiSendiri && ((int)((item.TanggalJatuhTempo.Value.Date - DateTime.Now.Date).TotalDays) < batas)) .Select(item => new { ClassWarna = Warna((int)((item.TanggalJatuhTempo.Value.Date - DateTime.Now.Date).TotalDays), batas), item.IDPOProduksiProduk, item.TBVendor.Nama, item.Tanggal, item.TanggalJatuhTempo }) .OrderBy(item => item.Tanggal) .ToArray(); RepeaterPOProdukJatuhTempo.DataBind(); } } else { PanelPOProdukJatuhTempo.Visible = false; } #endregion }