private void LoadData() { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { ProdukKategori_Class ClassProdukKategori = new ProdukKategori_Class(db); RepeaterProdukKategori.DataSource = ClassProdukKategori .Data() .Where(item => item.IDProdukKategori > 1) .Select(item => new { item.IDProdukKategori, KategoriUtama = item.IDProdukKategoriParent.HasValue ? item.TBProdukKategori1.Nama : "", item.Nama, item.Deskripsi, IsActive = item._IsActive }); RepeaterProdukKategori.DataBind(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void ButtonOk_Click(object sender, EventArgs e) { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { ProdukKategori_Class ClassProdukKategori = new ProdukKategori_Class(db); if (ButtonOk.Text == "Tambah") { ClassProdukKategori.Tambah(DropDownListKategoriParent.SelectedValue.ToInt(), TextBoxNama.Text, TextBoxDeskripsi.Text); } else if (ButtonOk.Text == "Ubah") { ClassProdukKategori.Ubah(Request.QueryString["id"].ToInt(), DropDownListKategoriParent.SelectedValue.ToInt(), TextBoxNama.Text, TextBoxDeskripsi.Text, CheckBoxActive.Checked); } db.SubmitChanges(); Response.Redirect("Default.aspx"); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void ButtonSimpan_Click(object sender, EventArgs e) { try { PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"]; using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { DiscountKombinasiProduk_Class ClassDiscountKombinasiProduk = new DiscountKombinasiProduk_Class(db); ClassDiscountKombinasiProduk.Hapus(Request.QueryString["id"].ToInt()); db.SubmitChanges(); foreach (RepeaterItem item in RepeaterKombinasiProduk.Items) { var HiddenFieldIDKombinasiProduk = (HiddenField)item.FindControl("HiddenFieldIDKombinasiProduk"); var TextBoxDiscount = (TextBox)item.FindControl("TextBoxDiscount"); ClassDiscountKombinasiProduk.Tambah(Request.QueryString["id"].ToInt(), HiddenFieldIDKombinasiProduk.Value.ToInt(), TextBoxDiscount.Text.ToDecimal()); } Notifikasi_Class Notifikasi_Class = new Notifikasi_Class(db, Pengguna.IDPengguna, EnumAlert.success, "Discount Grup Pelanggan " + LabelGrupPelanggan.Text + " Berhasil Disimpan"); db.SubmitChanges(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void ButtonOk_Click(object sender, EventArgs e) { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { Atribut_Class ClassAtribut = new Atribut_Class(db); if (ButtonOk.Text == "Tambah") { ClassAtribut.Tambah(DropDownListAtributGrup.SelectedValue.ToInt(), TextBoxNama.Text, CheckBoxPilihan.Checked); } else if (ButtonOk.Text == "Ubah") { ClassAtribut.Ubah(Request.QueryString["id"].ToInt(), DropDownListAtributGrup.SelectedValue.ToInt(), TextBoxNama.Text, CheckBoxPilihan.Checked); } db.SubmitChanges(); Response.Redirect("Default.aspx"); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { AtributGrup_Class ClassAtributGrup = new AtributGrup_Class(db); var AtributGrup = ClassAtributGrup.Cari(Request.QueryString["id"].ToInt()); if (AtributGrup != null) { TextBoxNama.Text = AtributGrup.Nama; ButtonOk.Text = "Ubah"; } else { ButtonOk.Text = "Tambah"; } } } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { LoadData(); using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { db.TBMenubarPenggunaGrups.DeleteAllOnSubmit(db.TBMenubarPenggunaGrups.Where(item => item.IDGrupPengguna == 1)); db.SubmitChanges(); foreach (var item in db.TBMenubars) { db.TBMenubarPenggunaGrups.InsertOnSubmit(new TBMenubarPenggunaGrup { IDMenubar = item.IDMenubar, IDGrupPengguna = 1 }); } db.SubmitChanges(); } } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void RepeaterPelanggan_ItemCommand(object source, RepeaterCommandEventArgs e) { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { Pelanggan_Class ClassPelanggan = new Pelanggan_Class(db); if (e.CommandName == "Hapus") { ClassPelanggan.Hapus(e.CommandArgument.ToInt()); } else if (e.CommandName == "UbahStatus") { ClassPelanggan.UbahStatus(e.CommandArgument.ToInt()); } LoadDataPelanggan(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { Menubar_Class ClassMenubar = new Menubar_Class(db); ClassMenubar.EnumMenubarModulDropdownList(DropDownListEnumMenubarModul); DropDownListMenuLevel1.DataSource = ClassMenubar.DataParent().Where(item => item.IDMenubar != Request.QueryString["id"].ToInt()); DropDownListMenuLevel1.DataTextField = "Nama"; DropDownListMenuLevel1.DataValueField = "IDMenubar"; DropDownListMenuLevel1.DataBind(); DropDownListMenuLevel1.Items.Insert(0, new ListItem { Value = "0", Text = "- Parent Level 1-" }); DropDownListMenuLevel2.Items.Insert(0, new ListItem { Value = "0", Text = "- Parent Level 2-" }); var Menubar = ClassMenubar.Cari(Request.QueryString["id"].ToInt()); if (Menubar != null) { if (Menubar.LevelMenu == 2) { DropDownListMenuLevel1.SelectedValue = Menubar.IDMenubarParent.ToString(); PanelIconVisible(); } else if (Menubar.LevelMenu == 3) { DropDownListMenuLevel1.SelectedValue = Menubar.TBMenubar1.IDMenubarParent.ToString(); PanelIconVisible(); DropDownListMenuLevel2.SelectedValue = Menubar.IDMenubarParent.ToString(); } DropDownListEnumMenubarModul.SelectedValue = Menubar.EnumMenubarModul.ToString(); TextBoxUrutan.Text = Menubar.Urutan.ToString(); TextBoxKode.Text = Menubar.Kode; TextBoxNama.Text = Menubar.Nama; TextBoxUrl.Text = Menubar.Url; TextBoxIcon.Text = Menubar.Icon; LabelKeterangan.Text = "Ubah"; ButtonSimpan.Text = "Ubah"; } else { LabelKeterangan.Text = "Tambah"; ButtonSimpan.Text = "Tambah"; } } } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void ButtonCari_Click(object sender, EventArgs e) { try { LoadData(); } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void DropDownListMenubarParent_SelectedIndexChanged(object sender, EventArgs e) { try { PanelIconVisible(); } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void EventData(object sender, EventArgs e) { try { LoadStokHabis(new Konfigurasi_Class(((PenggunaLogin)Session["PenggunaLogin"]).IDGrupPengguna)); } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void EventData(object sender, EventArgs e) { try { LoadDataPelanggan(); } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void EventData(object sender, EventArgs e) { try { LoadDataPegawai(new DataClassesDatabaseDataContext()); } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void ButtonKembali_Click(object sender, EventArgs e) { try { Response.Redirect("Default.aspx"); } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { GrupPelanggan_Class GrupPelanggan_Class = new GrupPelanggan_Class(db); var PelangganGrup = GrupPelanggan_Class.Cari(db, Request.QueryString["id"].ToInt()); if (PelangganGrup != null) { ProdukKategori_Class ClassProdukKategori = new ProdukKategori_Class(db); DiscountProdukKategori_Class ClassDiscountGrupPelanggan = new DiscountProdukKategori_Class(db); LabelGrupPelanggan.Text = PelangganGrup.Nama; RepeaterProdukKategori.DataSource = ClassProdukKategori.Data(); RepeaterProdukKategori.DataBind(); var DataDiscount = ClassDiscountGrupPelanggan.Data(Request.QueryString["id"].ToInt()); foreach (RepeaterItem item in RepeaterProdukKategori.Items) { var HiddenFieldIDProdukKategori = (HiddenField)item.FindControl("HiddenFieldIDProdukKategori"); var TextBoxDiscount = (TextBox)item.FindControl("TextBoxDiscount"); var Data = DataDiscount.FirstOrDefault(item2 => item2.IDProdukKategori == HiddenFieldIDProdukKategori.Value.ToInt()); if (Data != null) { TextBoxDiscount.Text = Data.Discount.ToString(); } else { TextBoxDiscount.Text = "0"; } } } else { Response.Redirect("Default.aspx"); } } } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { LoadData(); } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } } }
protected void ButtonPrevious_Click(object sender, EventArgs e) { try { DataDisplay DataDisplay = new DataDisplay(); if (DataDisplay.Prev(DropDownListHalaman)) { LoadDataPegawai(new DataClassesDatabaseDataContext()); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void ButtonNext_Click(object sender, EventArgs e) { try { DataDisplay DataDisplay = new DataDisplay(); if (DataDisplay.Next(DropDownListHalaman)) { LoadStokHabis(new Konfigurasi_Class(((PenggunaLogin)Session["PenggunaLogin"]).IDGrupPengguna)); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void ButtonNext_Click(object sender, EventArgs e) { try { DataDisplay DataDisplay = new DataDisplay(); if (DataDisplay.Next(DropDownListHalaman)) { LoadDataPelanggan(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
private void LoadData() { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { DataDisplay DataDisplay = new DataDisplay(); TBPelanggan[] ListData = null; ListData = db.TBPelanggans .Where(item => item.TanggalLahir.HasValue && item.TanggalLahir.Value.Month == DropDownListBulan.SelectedValue.ToInt() && item.NamaLengkap.ToLower().Contains(TextBoxCari.Text.ToLower())) .OrderBy(item => item.TanggalLahir.Value.Day).ToArray(); int skip = 0; int take = 0; DataDisplay.Proses(ListData.Count(), DropDownListHalaman, DropDownListJumlahData, out take, out skip); RepeaterPelanggan.DataSource = ListData .Skip(skip) .Take(take) .Select(item => new { Grup = item.TBGrupPelanggan.Nama, item.NamaLengkap, item.Email, item.Handphone, item.TanggalLahir, Status = item._IsActive, Transaksi = item.TBTransaksis.Where(item2 => item2.IDStatusTransaksi == (int)EnumStatusTransaksi.Complete).Count(), Nominal = item.TBTransaksis.Where(item2 => item2.IDStatusTransaksi == (int)EnumStatusTransaksi.Complete).Sum(item2 => item2.GrandTotal), Quantity = item.TBTransaksis.Where(item2 => item2.IDStatusTransaksi == (int)EnumStatusTransaksi.Complete).Sum(item2 => item2.JumlahProduk) }) .ToArray(); RepeaterPelanggan.DataBind(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
private void LoadData() { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { JenisPembayaran_Class ClassJenisPembayaran = new JenisPembayaran_Class(db); RepeaterJenisPembayaran.DataSource = ClassJenisPembayaran.Data().Where(item => item.IDJenisPembayaran != 1 && item.IDJenisPembayaran != 2); RepeaterJenisPembayaran.DataBind(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
private void LoadData() { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { AtributGrup_Class ClassAtributGrup = new AtributGrup_Class(db); RepeaterAtributGrup.DataSource = ClassAtributGrup.Data(); RepeaterAtributGrup.DataBind(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
private void LoadData() { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { DiscountEvent_Class ClassDiscountEvent = new DiscountEvent_Class(db); RepeaterDiscountEvent.DataSource = ClassDiscountEvent.Data(); RepeaterDiscountEvent.DataBind(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
private void LoadData() { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { GrupPelanggan_Class GrupPelanggan_Class = new GrupPelanggan_Class(db); RepeaterGrupPelanggan.DataSource = GrupPelanggan_Class.Data(db); RepeaterGrupPelanggan.DataBind(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { LoadData(); } else { LinkDownload.Visible = false; } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { Menubar_Class ClassMenubar = new Menubar_Class(db); Tempat_Class ClassTempat = new Tempat_Class(db); ClassTempat.DropDownList(DropDownListTempat); ClassMenubar.EnumStatusDiscountEventDropdownList(DropDownListEnumStatusDiscountEvent); DiscountEvent_Class ClassDiscountEvent = new DiscountEvent_Class(db); var Pengguna = (PenggunaLogin)Session["PenggunaLogin"]; var DiscountEvent = ClassDiscountEvent.Cari(Request.QueryString["id"].ToInt()); if (DiscountEvent != null) { DropDownListTempat.SelectedValue = DiscountEvent.IDTempat.ToString(); TextBoxNama.Text = DiscountEvent.Nama; TextBoxTanggalAwal.Text = DiscountEvent.TanggalAwal.ToString("d MMMM yyyy"); TextBoxTanggalAkhir.Text = DiscountEvent.TanggalAkhir.ToString("d MMMM yyyy"); DropDownListEnumStatusDiscountEvent.SelectedValue = DiscountEvent.EnumStatusDiscountEvent.ToString(); ButtonOk.Text = "Ubah"; PanelDiscount.Visible = true; LoadData(); } else { ButtonOk.Text = "Tambah"; } } } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void RepeaterDiscountEvent_ItemCommand(object source, RepeaterCommandEventArgs e) { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { DiscountEvent_Class ClassDiscountEvent = new DiscountEvent_Class(db); if (e.CommandName == "Hapus") { ClassDiscountEvent.Hapus(e.CommandArgument.ToInt()); LoadData(); } } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void RepeaterMenu_ItemCommand(object source, RepeaterCommandEventArgs e) { try { if (e.CommandName == "Ubah") { Response.Redirect("Pengaturan.aspx?id=" + e.CommandArgument.ToString()); } else if (e.CommandName == "Hapus") { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { Menubar_Class ClassMenubar = new Menubar_Class(db); ClassMenubar.Hapus(e.CommandArgument.ToInt()); } LoadData(); } else if (e.CommandName == "Urutkan") { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { Menubar_Class ClassMenubar = new Menubar_Class(db); TextBox TextBoxUrutan = (TextBox)e.Item.FindControl("TextBoxUrutan"); ClassMenubar.PengaturanUrutan(e.CommandArgument.ToInt(), TextBoxUrutan.Text.ToInt()); db.SubmitChanges(); } LoadData(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { ProdukKategori_Class ClassProdukKategori = new ProdukKategori_Class(db); ClassProdukKategori.DropDownList(DropDownListKategoriParent); DropDownListKategoriParent.Items.Remove(DropDownListKategoriParent.Items.FindByValue("1")); DropDownListKategoriParent.Items.Insert(0, new ListItem { Value = "0", Text = "- Kategori Utama -" }); var Data = ClassProdukKategori.Cari(Request.QueryString["id"].ToInt()); if (Data != null && Data.IDProdukKategori != 1) { DropDownListKategoriParent.SelectedValue = Data.IDProdukKategoriParent.HasValue ? Data.IDProdukKategoriParent.Value.ToString() : "0"; TextBoxNama.Text = Data.Nama; TextBoxDeskripsi.Text = Data.Deskripsi; CheckBoxActive.Checked = Data._IsActive; ButtonOk.Text = "Ubah"; } else { CheckBoxActive.Checked = true; ButtonOk.Text = "Tambah"; } } } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext()) { PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"]; Tempat_Class ClassTempat = new Tempat_Class(db); AtributProduk_Class ClassAtributProduk = new AtributProduk_Class(db); KategoriProduk_Class KategoriProduk_Class = new KategoriProduk_Class(); PemilikProduk_Class ClassPemilikProduk = new PemilikProduk_Class(db); DropDownListCariTempat.Items.AddRange(ClassTempat.DataDropDownList()); DropDownListCariTempat.Items.RemoveAt(0); DropDownListCariTempat.SelectedValue = Pengguna.IDTempat.ToString(); DropDownListCariPemilikProduk.Items.AddRange(ClassPemilikProduk.Dropdownlist()); DropDownListCariAtributProduk.Items.AddRange(ClassAtributProduk.Dropdownlist()); DropDownListCariKategori.Items.AddRange(KategoriProduk_Class.Dropdownlist(db)); DropDownListCariProduk.DataSource = db.TBProduks.OrderBy(item => item.Nama).ToArray(); DropDownListCariProduk.DataValueField = "IDProduk"; DropDownListCariProduk.DataTextField = "Nama"; DropDownListCariProduk.DataBind(); DropDownListCariProduk.Items.Insert(0, new ListItem { Text = "-Semua-", Value = "0" }); LoadData(); } } catch (Exception ex) { AlertMessage_Class.ShowException(this, ex, Request.Url.PathAndQuery); } } }