protected void Page_Load(object sender, EventArgs e)
{
iletisimID = Request.QueryString["iletisimID"];
islem = Request.QueryString["islem"];
if (islem == "sil")
{
string sil = "Delete From Iletisim Where iletisimID= '" + iletisimID + "'";
ConnectionQuerry.ExecuteQueries(sil);
}
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings[0].ConnectionString);
string sorgu = "Select * From Iletisim ";
SqlCommand cmd = new SqlCommand(sorgu, cnn);
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataList1.DataSource = dr;
DataList1.DataBind();
cnn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string sil = "Delete from Araba where Marka= '" + DropDownList1.Text + "'";
ConnectionQuerry.ExecuteQueries(sil);
Response.Redirect("AraçGöster.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["kullaniciadi"] == null)
{
Response.Redirect("Giris.aspx");
}
arabaID = Request.QueryString["arabaID"];
islem = Request.QueryString["islem"];
if (islem == "sil")
{
string sil = "Delete from Araba where arabaID='" + arabaID + "'";
ConnectionQuerry.ExecuteQueries(sil);
}
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings[0].ConnectionString);
string sorgu = "Select * From Araba ";
SqlCommand cmd = new SqlCommand(sorgu, cnn);
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataList1.DataSource = dr;
DataList1.DataBind();
cnn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
if (DropDownList1.Text != "")
{
string Sil = "Delete From Duyurular Where Baslik= '" + DropDownList1.Text + "'";
ConnectionQuerry.ExecuteQueries(Sil);
Response.Redirect("DuyuruSil.aspx");
Label2.Visible = true;
Label2.Text = "Duyuru Başarıyla Silinmiştir.";
}
}
protected void btnkaydet_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile == false)
{
txtfiyat.Text = "Resim seçiniz.";
}
else
{
FileUpload1.SaveAs(Server.MapPath("/arabaresim/") + FileUpload1.FileName);
string sorgu = "insert into Araba(Marka,Model,Fiyat,VitesTürü,Yakıt,KoltukSayısı,Klima,Resimler,Segment) Values('" + txtmarka.Text + "','" + txtmodel.Text + "','" + txtfiyat.Text + "','" + DropDownList1.Text + "','" + DropDownList2.Text + "','" + DropDownList4.Text + "','" + DropDownList3.Text + "','/arabaresim/" + FileUpload1.FileName + "','" + DropDownList5.Text + "')";
ConnectionQuerry.ExecuteQueries(sorgu);
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
if (fl_duyururesim.HasFile == false)
{
Label1.Text = "Resim seçiniz.";
}
else
{
fl_duyururesim.SaveAs(Server.MapPath("/duyururesim/") + fl_duyururesim.FileName);
string sorgu = "insert into Duyurular(duyuruBaslik,duyuruKonu,duyuruIcerik,duyuruResim) Values('" + txt_duyurubaslik.Text.ToString() + "','" + txt_duyurukonu.Text.ToString() + "','" + txt_duyuruicerik.Text.ToString() + "','/duyururesim/" + fl_duyururesim.FileName + "')";
ConnectionQuerry.ExecuteQueries(sorgu);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Panel2.Visible = false;
if (Session["kullaniciadi"] == null)
{
Response.Redirect("Giris.aspx");
}
duyuruID = Request.QueryString["duyuruID"];
islem = Request.QueryString["islem"];
if (islem == "sil")
{
string sil = "Delete from Duyurular where duyuruID='" + duyuruID + "'";
ConnectionQuerry.ExecuteQueries(sil);
}
SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings[0].ConnectionString);
string sorgu = "Select * From Duyurular ";
SqlCommand cmd = new SqlCommand(sorgu, cnn);
cnn.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataList1.DataSource = dr;
DataList1.DataBind();
cnn.Close();
if (islem == "göster")
{
Panel1.Visible = false;
Panel2.Visible = true;
SqlConnection cnn1 = new SqlConnection(ConfigurationManager.ConnectionStrings[0].ConnectionString);
string sorgu1 = "Select * From Duyurular where duyuruID = '" + duyuruID + "'";
SqlCommand cmd1 = new SqlCommand(sorgu1, cnn1);
cnn1.Open();
SqlDataReader dr1 = cmd1.ExecuteReader();
DataList2.DataSource = dr1;
DataList2.DataBind();
cnn1.Close();
}
}