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 bool Ekle(KiralikBilgileri obje)
{
try
{
Baglanti.BaglantiKontrol();
var strSql = @"
[dbo].[KiralikBilgileri]
([KiralikId]
,[AracId]
,[FirmaId]
,[MusteriId]
,[KiralikZamanBaslangic]
,[KiralikZamanBitis]
,[AracKmId]
,[KiralikUcret])
VALUES
('" + obje.AracId + "','" + obje.FirmaId + "', '" + obje.MusteriId
+ "', '" + obje.KiralikZamanBaslangic + "', '" + obje.KiralikZamanBitis + "','" + obje.AracKmId + "'"
+ ",'" + obje.KiralikUcret + "');";
SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex) { }
return(false);
}
public bool KiralananıSal(int id)
{
try
{
Baglanti.BaglantiKontrol();
string strSql = @"UPDATE Araclar SET KiralandiMi = 0 WHERE AracId = '" + id + "'";
Baglanti.VeriGuncelle(strSql);
return(true);
}
catch (Exception ex) { }
return(false);
}
public bool Ekle(Sehirler obje)
{
try
{
Baglanti.BaglantiKontrol();
var strSql = @"
INSERT INTO [dbo].[Sehirler]
([SehirAdi])
VALUES
('" + obje.SehirAdi + "');";
SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex) { }
return(false);
}
public bool Ekle(AracKmler obje)
{
try
{
Baglanti.BaglantiKontrol();
var strSql = @"
INSERT INTO [dbo].[AracKmler]
([AracId]
,[AracBaslangicKm]
,[AracBitisKm]
VALUES
('" + obje.AracId + "','" + obje.AracBaslangicKm + "', '" + obje.AracBitisKm + "',);";
SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{ }
return(false);
}
public bool Ekle(Kullanicilar obje)
{
try
{
Baglanti.BaglantiKontrol();
var strSql = @"
INSERT INTO [dbo].[Kullanicilar]
([KullaniciAd]
,[KullaniciSoyad]
,[FirmaId]
,[KullaniciAdi]
,[KullaniciParola]
,[RolId])
VALUES
('" + obje.KullaniciAd + "','" + obje.KullaniciSoyad + "', '" + obje.FirmaId
+ "', '" + obje.KullaniciAdi + "', '" + obje.KullaniciParola + "','" + obje.RolId + "');";
SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
sqlCommand.ExecuteNonQuery();
return(true);
}
catch (Exception ex) { }
return(false);
}
public bool Ekle(Musteriler obje)
{
try
{
Baglanti.BaglantiKontrol();
var strSql = @"
INSERT INTO[dbo].[Musteriler]
([MusteriAd]
,[MusteriSoyad]
,[MusteriEhliyetNo]
,[MusteriTCKNo]
,[MusteriTelNo]
,[MusteriEmail])
VALUES
('" + obje.MusteriAd + "','" + obje.MusteriSoyad + "', '" + obje.MusteriEhliyetNo
+ "', '" + obje.MusteriTCKNo + "', '" + obje.MusteriTelNo + "','" + obje.MusteriEmail + "');";
SqlCommand sqlCommand = new SqlCommand(strSql, Baglanti.sqlConnection);
sqlCommand.ExecuteNonQuery();
}
catch (Exception ex)
{ }
return(false);
}
