public List <Araclar> FirmaIdyeGoreGetir(int id) { List <Araclar> araclar = null; Araclar arac = null; DataTable dt = repo.FirmaIdyeGoreGetir(id); if (dt != null) { araclar = new List <Araclar>(); for (int i = 0; i < dt.Rows.Count; i++) { arac = new Araclar() { FirmaId = Convert.ToInt32(dt.Rows[i]["FirmaId"]), AracMarka = dt.Rows[i]["AracMarka"].ToString(), AracModel = dt.Rows[i]["AracModel"].ToString(), AracId = Convert.ToInt32(dt.Rows[i]["AracId"]), AracYil = Convert.ToInt32(dt.Rows[i]["AracYil"]), AracGerekenEhliyetYili = Convert.ToInt32(dt.Rows[i]["AracGerekenEhliyetYili"]), AracGerekenMinimumYas = Convert.ToInt32(dt.Rows[i]["AracGerekenMinimumYas"]), AracKoltukSayisi = Convert.ToInt32(dt.Rows[i]["AracKoltukSayisi"]), AracGunlukFiyat = Convert.ToDecimal(dt.Rows[i]["AracGunlukFiyat"]), AracAirbagDurumu = Convert.ToBoolean(dt.Rows[i]["AracAirbagDurumu"]), AracBagajHacmi = Convert.ToDecimal(dt.Rows[i]["AracGunlukFiyat"]), AracGunlukKmSiniri = Convert.ToInt32(dt.Rows[i]["AracGunlukKmSiniri"]), AracPlakaNo = Convert.ToString(dt.Rows[i]["AracPlakaNo"]), KiralandiMi = Convert.ToBoolean(dt.Rows[i]["KiralandiMi"]) }; araclar.Add(arac); } } return(araclar); }
private void button1_Click(object sender, EventArgs e) { if (HelperLayer.Helper.AlanKontrol(this)) { AraclarRepository repo = new AraclarRepository(); Araclar b = new Araclar() { AracMarka = txt_AracMarka.Text, AracModel = txt_AracModel.Text, AracYil = Convert.ToInt32(txt_AracYil.Text), AracGerekenEhliyetYili = Convert.ToInt32(txt_AracGerekenEhliyetYil.Text), AracGerekenMinimumYas = Convert.ToInt32(txt_AracYasSinir.Text), AracKoltukSayisi = Convert.ToInt32(txt_AracKoltukSayisi.Text), AracGunlukFiyat = Convert.ToDecimal(txt_AracGunlukFiyat.Text), AracAirbagDurumu = true, AracBagajHacmi = Convert.ToDecimal(txt_AracBagajHacmi.Text), AracGunlukKmSiniri = Convert.ToInt32(txt_AracGunlukKmSinir.Text), FirmaId = firmalar.Find(x => x.FirmaAdi == cmb_firma.SelectedItem.ToString()).FirmaId, AracPlakaNo = txt_AracPlaka.Text }; if (repo.Ekle(b)) { MessageBox.Show("Eklendi"); } else { MessageBox.Show("Eklenemedi"); } } else { MessageBox.Show("Alanlar boş geçilemez"); } }
public bool Ekle(Araclar obje) { try { Baglanti.BaglantiKontrol(); var strSql = @" INSERT INTO [dbo].[Araclar] ([AracMarka] ,[AracModel] ,[AracYil] ,[AracGerekenEhliyetYili] ,[AracGerekenMinimumYas] ,[AracKoltukSayisi] ,[AracGunlukFiyat] ,[AracAirbagDurumu] ,[AracBagajHacmi] ,[AracGunlukKmSiniri] ,[FirmaId] ,[AracPlakaNo]) ,[Vergi] VALUES ('" + obje.AracMarka + "','" + obje.AracModel + "', '" + obje.AracYil + "', '" + obje.AracGerekenEhliyetYili + "', '" + obje.AracGerekenMinimumYas + "','" + obje.AracKoltukSayisi + "','" + obje.AracGunlukFiyat + "','" + obje.AracAirbagDurumu + "','" + obje.AracBagajHacmi + "','" + obje.AracGunlukKmSiniri + "','" + obje.FirmaId + "','" + obje.AracPlakaNo + "'" + obje.Vergi + "');"; SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection); sqlCommand.ExecuteNonQuery(); return(true); } catch (Exception ex) { } return(false); }
public ActionResult AracSilControl(string txtPlaka) //model ve marka tablosunda kalıyor bilgi { using (araclazim db = new araclazim()) { Araclar silinecekAracId = null; foreach (var item in db.Araclar.ToList()) { if (item.plaka.Equals(txtPlaka)) { silinecekAracId = item; } } foreach (var item in db.RezervasyonIstekleri.ToList()) { if (item.aracId == silinecekAracId) { item.aracId = null; } } var silinecek_gecikmeCeza = db.GecikmeCezalari; var silinecekArac = db.Araclar.Where(arc => arc.plaka == txtPlaka).ToList(); db.Araclar.Remove(db.Araclar.Find(silinecekArac[0].Id)); db.SaveChanges(); } return(RedirectToAction("aracSil")); }
private void btnKaydet_Click(object sender, EventArgs e) { if (txtMarkaAd.Text.Trim() != "" && txtModel.Text.Trim() != "" && txtHavalimaniAdi.Text.Trim() != "" && txtFirmaAdi.Text.Trim() != "") { Araclar a = new Araclar(); a.FirmaID = Convert.ToInt32(txtFirmaID.Text); a.HavalimaniID = Convert.ToInt32(txtHavalimaniID.Text); a.ModelID = Convert.ToInt32(txtModelID.Text); a.Fiyat = Convert.ToDouble(txtFiyat.Text); if (a.AracEkle(a)) { MessageBox.Show("Araç Tanımlanması başarı ile eklendi."); a.AraclariGetir(lvAraclar); Temizle(); btnKaydet.Enabled = false; btnDegistir.Enabled = true; btnSil.Enabled = true; } else { MessageBox.Show("Araç eklenemedi."); } } else { MessageBox.Show("Firma Adı,Havalimani Adı,Model ve Marka Adı boş bırakılamaz."); } }
public ActionResult Create(Araclar araclar, IEnumerable <HttpPostedFileBase> ResimDosya) { if (ModelState.IsValid) { if (ResimDosya != null) { foreach (var item in ResimDosya) { item.SaveAs(Server.MapPath($"~/Content/images/{item.FileName}")); araclar.Foto = "/Content/images/" + item.FileName; } } araclar.dateTime = DateTime.Now; araclar.SaveUser = -1; araclar.UpdateDate = DateTime.Now; araclar.UpdateUser = -1; db.Araclars.Add(araclar); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.VitesId = new SelectList(db.yVites, "Id", "Vites", araclar.VitesId); ViewBag.YakitTipiId = new SelectList(db.yYakitTipis, "Id", "YTipi", araclar.YakitTipiId); ViewBag.SehirId = new SelectList(db.Sehirler, "Id", "Sehir", araclar.SehirId); return(View(araclar)); }
private void FormPersonelEkleme_Load(object sender, EventArgs e) { this.Location = new Point(50, 100); Araclar.ComboBoxDepartmanGetir(cmbDepartmanSec); cmbDepartmanSec.SelectedItem = null; cmbDepartmanSec.SelectedText = "Departman Seçiniz..."; }
public void AktifPasifYap(object nesne) { if (nesne is PersonelIletisim) { PersonelIletisim iletisim = (from p in db.PersonelIletisim where p.ID == ((PersonelIletisim)nesne).ID select p).FirstOrDefault(); iletisim.AktifMi = false; db.SaveChanges(); } else if (nesne is PersonelEgitim) { PersonelEgitim egitim = (from p in db.PersonelEgitim where p.ID == ((PersonelEgitim)nesne).ID select p).FirstOrDefault(); egitim.AktifMi = false; db.SaveChanges(); } else if (nesne is UnvanIslem) { UnvanIslem islem = (from p in db.UnvanIslem where p.PersonelID == ((UnvanIslem)nesne).PersonelID && p.UnvanID == ((UnvanIslem)nesne).UnvanID select p).FirstOrDefault(); islem.AktifMi = false; db.SaveChanges(); } else if (nesne is Araclar) { Araclar arac = (from a in db.Araclar where a.AracID == ((Araclar)nesne).AracID select a).FirstOrDefault(); arac.AktifMi = false; db.SaveChanges(); } else if (nesne is BirimIslem) { BirimIslem islem = (from p in db.BirimIslem where p.PersonelID == ((BirimIslem)nesne).PersonelID && p.BirimID == ((BirimIslem)nesne).BirimID select p).FirstOrDefault(); islem.AktifMi = false; db.SaveChanges(); } else if (nesne is int) { Personel personel = (from p in db.Personel where p.ID == ((int)nesne) select p).FirstOrDefault(); personel.AktifMi = !(personel.AktifMi); db.SaveChanges(); } else if (nesne is YetkiIslem) { YetkiIslem islem = (from p in db.YetkiIslem where p.PersonelID == ((YetkiIslem)nesne).PersonelID && p.AktifMi == true select p).FirstOrDefault(); islem.AktifMi = false; db.SaveChanges(); } }
private void FormZimmetGuncelleme_Load(object sender, EventArgs e) { this.Location = new Point(50, 100); Araclar.ComboBoxPersonelGetir(cmbPersonelGuncelle); cmbPersonelGuncelle.SelectedItem = null; cmbPersonelGuncelle.SelectedText = "Personel Seçiniz..."; ZimmetListele(); }
private void FormZimmetListele_Load(object sender, EventArgs e) { this.Location = new Point(50, 100); Araclar.ComboBoxDepartmanGetir(cmbDepartmanTip); cmbDepartmanTip.SelectedItem = null; cmbDepartmanTip.SelectedText = "Departman Seçiniz..."; ZimmetListele(); }
private void FormZimmetEkle_Load(object sender, EventArgs e) { this.Location = new Point(50, 100); Araclar.ComboBoxPersonelGetir(cmbPersonel); Araclar.ComboBoxKullaniciGetir(cmbKullanicilar); ZimmetUrunListele(); cmbPersonel.SelectedItem = null; cmbPersonel.SelectedText = "Personel Seçiniz..."; }
public ActionResult Create() { var araclar = new Araclar(); ViewBag.VitesId = new SelectList(db.yVites, "Id", "Vites"); ViewBag.YakitTipiId = new SelectList(db.yYakitTipis, "Id", "YTipi"); ViewBag.SehirId = new SelectList(db.Sehirler, "Id", "Sehir"); return(View(araclar)); }
public async Task <ActionResult> Delete(int id) { Araclar araclar = await db.Araclars.FindAsync(id); db.Araclars.Remove(araclar); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public bool Ekle(int otelid, int musteriid, string yorum) { SqlCommand komut = new SqlCommand("Yorum_Ekle", Araclar.Baglanti); komut.CommandType = CommandType.StoredProcedure; komut.Parameters.AddWithValue("@Otelid", otelid); komut.Parameters.AddWithValue("@Musterid", musteriid); komut.Parameters.AddWithValue("@Yorum", yorum); return(Araclar.Calıstır(komut)); }
public bool Sil(Araclar obje) { try { string strSql = "UPDATE Araclar SET SilindiMi = 1 WHERE AracId = '" + obje.AracId + "'"; Baglanti.VeriGuncelle(strSql); } catch (Exception ex) { } return(false); }
private void button2_Click(object sender, EventArgs e) { Arac sil = new Arac(); sil.AracID = (int)textBox2.Tag; if (!Araclar.Sil(sil)) { MessageBox.Show("Veri Silinemedi.."); } dataGridView1.DataSource = Araclar.Listele(); }
private async void btnAracEkle_Click(object sender, EventArgs e) { try { bool success = false; // Create a HttpClient using (var client = new HttpClient()) { // Setup basics client.BaseAddress = new Uri("http://localhost:52009/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); // Create post body object Araclar arac = new Araclar() { Marka = txtMarka.Text, Model = txtModel.Text, MinYasSiniri = Convert.ToInt32(txtMinYasSiniri.Text), EhliyetYasi = Convert.ToInt32(txtEhliyetYasi.Text), GunukKm = Convert.ToInt32(txtGunlukKm.Text), AnlikKm = Convert.ToInt32(txtAnlikKm.Text), Airbag = byte.Parse(txtAirbag.Text), BagajHacmi = Convert.ToInt32(txtBagajHacmi.Text), GunlukKiralikFiyati = decimal.Parse(txtGunlukKiralikFiyati.Text), Durum = bool.Parse(txtDurum.Text) }; // Serialize C# object to Json Object var serializedProduct = JsonConvert.SerializeObject(arac); // Json object to System.Net.Http content type var content = new StringContent(serializedProduct, Encoding.UTF8, "application/json"); // Post Request to the URI var result = await client.PostAsync("api/Araclar", content); // Check for result if (result.IsSuccessStatusCode) { success = true; } } // Set message depend on success info var message = success ? "done" : "failed"; // Inform user MessageBox.Show("Operation " + message); } catch (Exception ex) { // Inform user MessageBox.Show("Error happened: " + ex.Message); } }
public static Araclar getArac(string plaka) { Araclar arc = new Araclar(); for (int i = 0; i < AraclarList.Count; i++) { if (AraclarList[i].ARC_PLAKA == plaka) { arc = AraclarList[i]; break; } } return arc; }
public bool Ekle(Araclar entity) { try { Context.Set <Araclar>().Add(entity); Context.SaveChanges(); return(true); } catch (Exception ex) { throw new Exception("Business:AraclarBusiness::AracEkle::Error occured.", ex); } }
public static Araclar getArac(int serino) { Araclar arc = new Araclar(); for (int i = 0; i < AraclarList.Count; i++) { if (AraclarList[i].ARC_SERINO == serino) { arc = AraclarList[i]; break; } } return arc; }
private void AraclariGetir() { string Firma = ""; if (cbFirmalar.SelectedItem.ToString() != "") { Firma = cbFirmalar.SelectedItem.ToString(); } Araclar a = new Araclar(); dt = a.AraclariGetir(Firma, txtVites.Text, txtYakit.Text, Havalimani); dgvAraclar.DataSource = dt; }
private void button1_Click(object sender, EventArgs e) { Arac ekle = new Arac(); ekle.AracTuru = comboBox1.SelectedItem.ToString(); ekle.AracKapasitesi = Convert.ToInt32(textBox1.Text); ekle.AracSoforu = textBox2.Text; if (!Araclar.Ekle(ekle)) { MessageBox.Show("Veriler Eklenmedi...."); } dataGridView1.DataSource = Araclar.Listele(); }
private void AraclariGoster_Load(object sender, EventArgs e) { this.Top = 0; this.Left = 0; Araclar a = new Araclar(); Firmalar f = new Firmalar(); f.FirmalarıGetir(cbFirmalar); cbFirmalar.Items.Insert(0, "Tümü"); cbFirmalar.SelectedIndex = 0; dt = a.AraclariGetir(Havalimani); dgvAraclar.DataSource = dt; }
public static Araclar getArac(string plaka) { Araclar arc = new Araclar(); for (int i = 0; i < AraclarList.Count; i++) { if (AraclarList[i].ARC_PLAKA == plaka) { arc = AraclarList[i]; break; } } return(arc); }
private void button3_Click(object sender, EventArgs e) { Arac yenile = new Arac(); yenile.AracID = (int)textBox2.Tag; yenile.AracTuru = comboBox1.SelectedItem.ToString(); yenile.AracKapasitesi = Convert.ToInt32(textBox1.Text); yenile.AracSoforu = textBox2.Text; if (!Araclar.Yenile(yenile)) { MessageBox.Show("Veriler Güncellenemedi...."); } dataGridView1.DataSource = Araclar.Listele(); }
public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Araclar araclar = await db.Araclars.FindAsync(id); if (araclar == null) { return(HttpNotFound()); } return(View(araclar)); }
public static Araclar getArac(int serino) { Araclar arc = new Araclar(); for (int i = 0; i < AraclarList.Count; i++) { if (AraclarList[i].ARC_SERINO == serino) { arc = AraclarList[i]; break; } } return(arc); }
public bool AracKirala(Araclar arac) { try { using (var business = new AraclarBusiness()) { business.AracGuncelle(arac); } return(true); } catch (Exception) { return(false); } }
public ActionResult Edit(Araclar araclar) { if (ModelState.IsValid) { araclar.UpdateDate = DateTime.Now; araclar.UpdateUser = -1; db.Entry(araclar).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.VitesId = new SelectList(db.yVites, "Id", "Vites", araclar.VitesId); ViewBag.YakitTipiId = new SelectList(db.yYakitTipis, "Id", "YTipi", araclar.YakitTipiId); ViewBag.SehirId = new SelectList(db.Sehirler, "Id", "Sehir", araclar.SehirId); return(View(araclar)); }
public bool AracGuncelle(Araclar entity) { try { using (var business = new AraclarBusiness()) { business.AracGuncelle(entity); } return(true); } catch (Exception) { return(false); } }
public bool EkleArac(Araclar entity) { try { using (AraclarBusiness araclarBusiness = new AraclarBusiness()) { araclarBusiness.Ekle(entity); } return(true); } catch (Exception) { return(false); } }
private void btnSil_Click(object sender, EventArgs e) { if (MessageBox.Show("Silmek istediğinizden emin misiniz?", "UYARI", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { Araclar a = new Araclar(); if (a.AracSil(Convert.ToInt32(txtPlakaID.Text))) { MessageBox.Show("Model Silindi."); a.AraclariGetir(lvAraclar); Temizle(); btnSil.Enabled = false; btnDegistir.Enabled = false; } } }