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 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);
}
}
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 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 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 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 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 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 ButtonKembali_Click(object sender, EventArgs e)
{
try
{
Response.Redirect("Default.aspx");
}
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 EventData(object sender, EventArgs e)
{
try
{
LoadDataPegawai(new DataClassesDatabaseDataContext());
}
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 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 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 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);
}
}
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())
{
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);
}
}
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);
}
}
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 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);
}
}
