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;
}
}
}
