protected void Page_Load(object sender, EventArgs e)
{
SQLBaglanti bag = new SQLBaglanti();
if (!Page.IsPostBack)
{
if (Session["KoleksiyonerEmail"] != null)
{
//kategori çek
SqlCommand cmd = new SqlCommand("Select * from Kategori", bag.baglan());
SqlDataReader dr = cmd.ExecuteReader();
DropDownListKategori.DataTextField = "KategoriAdi";
DropDownListKategori.DataValueField = "KategoriID";
DropDownListKategori.DataSource = dr;
DropDownListKategori.DataBind();
string kEmail = Session["KoleksiyonerEmail"].ToString();
SqlCommand cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", bag.baglan());
SqlDataReader drSession = cmdSession.ExecuteReader();
DatalistProfilBilgi.DataSource = drSession;
DatalistProfilBilgi.DataBind();
}
else
{
Response.Redirect("KullaniciGiris.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["admin"] == null)
{
Response.Redirect("anasayfa.aspx");
}
if (!IsPostBack)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
var menu = db.Menus.FirstOrDefault(x => x.m_id == id);
var kat = (from d in db.Kategoris
orderby d.k_eklenme_tarihi descending
select new
{
k_id = d.k_id,
k_ad = d.k_ad
}).ToList();
DropDownListKategori.DataSource = kat;
DropDownListKategori.DataTextField = "k_ad";
DropDownListKategori.DataValueField = "k_id";
txtBaslik.Text = menu.m_baslik;
txtAciklama.Text = menu.m_aciklama;
txtFiyat.Text = menu.m_fiyat.ToString();
image.ImageUrl = menu.m_resim;
DropDownListKategori.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["admin"] == null)
{
Response.Redirect("anasayfa.aspx");
}
var kat = (from d in db.Kategoris
orderby d.k_eklenme_tarihi descending
select new
{
k_id = d.k_id,
k_ad = d.k_ad
}).ToList();
DropDownListKategori.DataSource = kat;
DropDownListKategori.DataTextField = "k_ad";
DropDownListKategori.DataValueField = "k_id";
DropDownListKategori.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
UrunID = Request.QueryString["UrunID"];
if (Page.IsPostBack == false)
{
if (Session["KoleksiyonerEmail"] != null)
{
//kategori çek
SqlCommand cmd = new SqlCommand("Select * from Kategori ", baglan.baglan());
SqlDataReader dr = cmd.ExecuteReader();
DropDownListKategori.DataTextField = "KategoriAdi";
DropDownListKategori.DataValueField = "KategoriID";
DropDownListKategori.DataSource = dr;
DropDownListKategori.DataBind();
SqlCommand cmdUrunGetir = new SqlCommand("Select * from Urun where UrunID='" + UrunID + "'", baglan.baglan());
SqlDataReader druGuncelle = cmdUrunGetir.ExecuteReader();
DataTable dtuGuncelle = new DataTable("tablo");
dtuGuncelle.Load(druGuncelle);
DataRow row = dtuGuncelle.Rows[0];
txtUrunAdi.Text = row["UrunAdi"].ToString();
txtFiyat.Text = row["UrunFiyat"].ToString();
txtAciklama.Text = row["Aciklama"].ToString();
txtIlanSuresi.Text = row["IhaleSuresi"].ToString();
DropDownListKategori.SelectedItem.Text = row["KategoriAdi"].ToString();
string kEmail = Session["KoleksiyonerEmail"].ToString();
SqlCommand cmdSession = new SqlCommand("Select * from Koleksiyoner where KoleksiyonerEmail='" + kEmail + "'", baglan.baglan());
SqlDataReader drSession = cmdSession.ExecuteReader();
DatalistProfilBilgi.DataSource = drSession;
DatalistProfilBilgi.DataBind();
}
else
{
Response.Redirect("KullaniciGiris.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"];
Tempat_Class ClassTempat = new Tempat_Class(db);
Warna_Class ClassWarna = new Warna_Class(db);
AtributProduk_Class ClassAtributProduk = new AtributProduk_Class(db);
PemilikProduk_Class ClassPemilikProduk = new PemilikProduk_Class(db);
DropDownListTempat.DataSource = ClassTempat.Data();
DropDownListTempat.DataValueField = "IDTempat";
DropDownListTempat.DataTextField = "Nama";
DropDownListTempat.DataBind();
DropDownListTempat.SelectedValue = Pengguna.IDTempat.ToString();
DropDownListKategori.DataSource = db.TBKategoriProduks.ToArray();
DropDownListKategori.DataTextField = "Nama";
DropDownListKategori.DataValueField = "IDKategoriProduk";
DropDownListKategori.DataBind();
DropDownListKategori.Items.Insert(0, new ListItem {
Value = "-1", Text = "- Semua -"
});
DropDownListKategori.Items.Insert(1, new ListItem {
Value = "0", Text = " "
});
DropDownListPemilik.DataSource = ClassPemilikProduk.Data();
DropDownListPemilik.DataTextField = "Nama";
DropDownListPemilik.DataValueField = "IDPemilikProduk";
DropDownListPemilik.DataBind();
DropDownListPemilik.Items.Insert(0, new ListItem {
Value = "-1", Text = "- Semua -"
});
DropDownListVarian.DataSource = ClassAtributProduk.Data();
DropDownListVarian.DataTextField = "Nama";
DropDownListVarian.DataValueField = "IDAtributProduk";
DropDownListVarian.DataBind();
DropDownListVarian.Items.Insert(0, new ListItem {
Value = "-1", Text = "- Semua -"
});
DropDownListWarna.DataSource = ClassWarna.Data();
DropDownListWarna.DataTextField = "Nama";
DropDownListWarna.DataValueField = "IDWarna";
DropDownListWarna.DataBind();
DropDownListWarna.Items.Insert(0, new ListItem {
Value = "-1", Text = "- Semua -"
});
DropDownListVendor.DataSource = db.TBVendors.ToArray();
DropDownListVendor.DataTextField = "Nama";
DropDownListVendor.DataValueField = "IDVendor";
DropDownListVendor.DataBind();
DropDownListVendor.Items.Insert(0, new ListItem {
Value = "-1", Text = "- Semua -"
});
DropDownListVendor.Items.Insert(1, new ListItem {
Value = "0", Text = " "
});
}
}
else
{
LinkDownload.Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!string.IsNullOrWhiteSpace(Request.QueryString["do"]))
{
if (Request.QueryString["do"] == "opname")
{
LabelJudul.Text = "Stock Opname";
}
else if (Request.QueryString["do"] == "waste")
{
LabelJudul.Text = "Pembuangan Bahan Baku Rusak";
}
else if (Request.QueryString["do"] == "restock")
{
LabelJudul.Text = "Restock Bahan Baku";
}
else if (Request.QueryString["do"] == "return")
{
LabelJudul.Text = "Retur ke Tempat Supplier";
}
else
{
Response.Redirect("/WITAdministrator/BahanBaku/Stok/Default.aspx");
}
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"];
Tempat_Class ClassTempat = new Tempat_Class(db);
List <ListItem> ListData = new List <ListItem>();
DropDownListJenisStok.Items.Insert(0, new ListItem {
Value = "0", Text = "Semua"
});
DropDownListJenisStok.Items.Insert(1, new ListItem {
Value = "1", Text = "Ada Stok", Selected = true
});
DropDownListJenisStok.Items.Insert(2, new ListItem {
Value = "2", Text = "Tidak Ada Stok"
});
DropDownListJenisStok.Items.Insert(3, new ListItem {
Value = "3", Text = "Minus"
});
DropDownListTempat.Items.AddRange(ClassTempat.DataDropDownList().Where(item => item.Value != "0").ToArray());
DropDownListTempat.SelectedValue = Pengguna.IDTempat.ToString();
DropDownListKategori.DataSource = db.TBKategoriBahanBakus.ToArray();
DropDownListKategori.DataTextField = "Nama";
DropDownListKategori.DataValueField = "IDKategoriBahanBaku";
DropDownListKategori.DataBind();
DropDownListKategori.Items.Insert(0, new ListItem {
Value = "0", Text = "-Semua-"
});
DropDownListSatuan.DataSource = db.TBSatuans.ToArray();
DropDownListSatuan.DataTextField = "Nama";
DropDownListSatuan.DataValueField = "IDSatuan";
DropDownListSatuan.DataBind();
DropDownListSatuan.Items.Insert(0, new ListItem {
Value = "0", Text = "-Semua-"
});
}
}
else
{
Response.Redirect("/WITAdministrator/BahanBaku/Stok/Default.aspx");
}
}
}
