private void dataGridView1_MouseClick(object sender, MouseEventArgs e)
{
try
{
int id = Convert.ToInt32(dataGridView1.CurrentRow.Cells["ID"].Value.ToString());
//List<Kiralama> kiralamas = new List<Kiralama>();
kiralamas = new Kiralama();
kiralamas = db.Kiralamas.Find(id);
Arabalar arabalar = new Arabalar();
arabalar = db.Arabalars.Find(kiralamas.ArabaID);
Musteriler musteriler = new Musteriler();
musteriler = db.Musterilers.Find(kiralamas.MusteriID);
textBox1.Text = arabalar.Marka.ToString();
textBox2.Text = musteriler.Adi.ToString();
textBox3.Text = kiralamas.AlisTarihi.ToString();
textBox4.Text = kiralamas.TeslimTarihi.ToString();
textBox5.Text = kiralamas.KiralanmaSuresi.ToString();
textBox6.Text = kiralamas.FaturaTutari.ToString();
textBox7.Text = arabalar.Model.ToString();
}
catch (Exception)
{
return;
}
}
public int KiralamaDuzenle(Kiralama kd)
{
try
{
cmd = new SqlCommand("update Kiralama set KiralamaBaslangicTarihi=@KiralamaBaslangicTarihi,KiralamaBitisTarihi=@KiralamaBitisTarihi,KiralamaFiyati=@KiralamaFiyati,KitapID=@KitapID,UyeID=@UyeID where KiralamaID=@KiralamaID", con);
cmd.Parameters.Add("@KiralamaID", SqlDbType.Int).Value = kd.KiralamaID;
cmd.Parameters.Add("@KiralamaBaslangicTarihi", SqlDbType.Date).Value = kd.KiralamaBaslangicTarihi;
cmd.Parameters.Add("@KiralamaBitisTarihi", SqlDbType.Date).Value = kd.KiralamaBitisTarihi;
cmd.Parameters.Add("@KiralamaFiyati", SqlDbType.Money).Value = kd.KiralamaFiyati;
cmd.Parameters.Add("@KitapID", SqlDbType.Int).Value = kd.KitapID;
cmd.Parameters.Add("@UyeID", SqlDbType.Int).Value = kd.UyeID;
BaglantiAyarla();
donendeger2 = cmd.ExecuteNonQuery();
}
catch (Exception)
{
}
finally
{
BaglantiAyarla();
}
return(donendeger2);
}
public async Task <IActionResult> Edit(int id, [Bind("ID,AlışGünü,GeriTeslimGünü,MüsteriID,AracID")] Kiralama kiralama)
{
if (id != kiralama.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(kiralama);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!KiralamaExists(kiralama.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["AracID"] = new SelectList(_context.Araclar, "ID", "ID", kiralama.AracID);
ViewData["MüsteriID"] = new SelectList(_context.Müsteriler, "ID", "ID", kiralama.MüsteriID);
return(View(kiralama));
}
private void btn_s_tamamla_Click(object sender, EventArgs e)
{
bool a = GonderilenKontrol(dtp_alimtarihi.Value.Date, dtp_teslimtarihi.Value.Date);
if (a == false)
{
MessageBox.Show("İstediğiniz Tarihte Araba Dolu Olduğundan Veremiyoruz.");
}
else
{
//TimeSpan fark = dtp_teslimtarihi.Value - dtp_alimtarihi.Value; diğer kullanım
TimeSpan GunFarki = dtp_teslimtarihi.Value.Subtract(dtp_alimtarihi.Value);
int saraba;
saraba = Convert.ToInt32(cmb_s_araba.SelectedValue);
int smusteri;
smusteri = Convert.ToInt32(cmb_s_musteri.SelectedValue);
int b = Convert.ToInt32(GunFarki.Days);
List <Arabalar> arabalars = new List <Arabalar>();
arabalars = db.Cars.Where(x => x.ID == saraba).ToList();
foreach (Arabalar item in arabalars)
{
arabafiyat = item.Fiyat;
}
Kiralama kiralama = new Kiralama();
kiralama.ArabaID = saraba;
kiralama.MusteriID = smusteri;
kiralama.AlisTarihi = Convert.ToDateTime(dtp_alimtarihi.Value.Date);
kiralama.TeslimTarihi = Convert.ToDateTime(dtp_teslimtarihi.Value.Date);
kiralama.KiralanmaSuresi = Convert.ToInt32(GunFarki.Days.ToString());
kiralama.FaturaTutari = Convert.ToDecimal((b * arabafiyat).ToString());
kiralama.AddDate = DateTime.Now;
kiralama.AktifMi = Convert.ToBoolean(cmb_s_aktifmi.SelectedIndex);
db.Kiralamas.Add(kiralama);
db.SaveChanges();
MessageBox.Show("Sözleşme oluşturuldu");
}
DialogResult cancel = new DialogResult();
cancel = MessageBox.Show("Yeni Kayıt eklemek ister misiniz?", "Çıkmak için Hayıra basınız", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (cancel == DialogResult.No)
{
this.Close();
}
else
{
KontrolEt();
dtp_alimtarihi.CustomFormat = " ";
dtp_teslimtarihi.CustomFormat = " ";
}
cmb_s_aktifmi.SelectedIndex = -1;
cmb_s_araba.SelectedIndex = -1;
cmb_s_musteri.SelectedIndex = -1;
dtp_alimtarihi.Text = string.Empty;
dtp_teslimtarihi.Text = string.Empty;
lbl_sure.Text = string.Empty;
lbl_tutar.Text = string.Empty;
//SozlesmeList();
SozlesmeListDataGrid();
}
private void button1_Click(object sender, EventArgs e)
{
bool a = GonderilenKontrol(dateTimePicker1.Value, dateTimePicker2.Value);
if (a == false)
{
MessageBox.Show("İstediğiniz Tarihte Araba Dolu Olduğundan Veremiyoruz.");
}
else
{
Kiralama kiralama = new Kiralama
{
ArabaID = id,
MusteriID = Convert.ToInt32(kid),
AlisTarihi = Convert.ToDateTime(dateTimePicker1.Value),
TeslimTarihi = Convert.ToDateTime(dateTimePicker2.Value),
KiralanmaSuresi = gun,
FaturaTutari = Convert.ToDouble(lbl_tutaR.Text),
AktifMi = true
};
db.Kiralamas.Add(kiralama);
db.SaveChanges();
MessageBox.Show("Araç Kiralandı.");
this.Hide();
}
}
private async void btnKiralamaEkle_ClickAsync(object sender, EventArgs e)
{
try
{
bool success = false;
// Create a HttpClient
using (var client = new HttpClient())
{
// Setup basics
client.BaseAddress = new Uri("http://localhost:49774/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
dateTimeVerilisTarih.Format = DateTimePickerFormat.Custom;
dateTimeVerilisTarih.CustomFormat = "d/M/yyyy h:mm";
dateTimeAlinisTarih.Format = DateTimePickerFormat.Custom;
dateTimeAlinisTarih.CustomFormat = "d/M/yyyy h:mm";
int verilisKm = Convert.ToInt32(txtVerilisKM.Text);
int alisKm = Convert.ToInt32(txtAlinisKM.Text);
// Create post body object
Kiralama kiralama = new Kiralama();
kiralama.aracId = Convert.ToInt32(cmbAracId.Text);
kiralama.musteriId = Convert.ToInt32(cmbMusteriId.Text);
kiralama.sirketId = Convert.ToInt32(cmbSirketId.Text);
kiralama.geriAlisTarihi = dateTimeAlinisTarih.Value;
kiralama.verilisTarihi = dateTimeVerilisTarih.Value;
kiralama.verilisKm = verilisKm;
kiralama.sonKm = alisKm;
kiralama.ucret = (alisKm - verilisKm);
// Serialize C# object to Json Object
var serializedProduct = JsonConvert.SerializeObject(kiralama);
// 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/KiralamaBusiness", content);
// Check for result
if (result.IsSuccessStatusCode)
{
success = true;
}
}
// Set message depend on success info
var message = success ? "başarılı" : "başarısız!";
// Inform user
MessageBox.Show("İşlem " + message);
}
catch (Exception ex)
{
// Inform user
MessageBox.Show("Error happened: " + ex.Message);
}
}
private void dgvw_mevcutsozlesmeler_MouseClick(object sender, MouseEventArgs e)
{
int id = Convert.ToInt32(dgvw_mevcutsozlesmeler.CurrentRow.Cells["ID"].Value.ToString());
updated = db.Kiralamas.Find(id);
cmb_s_araba.Text = updated.Araba.Marka.ToString();
cmb_s_musteri.Text = updated.Musteri.Ad.ToString();
dtp_alimtarihi.Text = updated.AlisTarihi.ToString();
dtp_teslimtarihi.Text = updated.TeslimTarihi.ToString();
cmb_s_aktifmi.SelectedIndex = Convert.ToInt32(updated.AktifMi);
MessageBox.Show("Güncelleme Yapmak için Bütün Alanları seçiniz");
}
public async Task <IActionResult> Create([Bind("ID,AlışGünü,GeriTeslimGünü,MüsteriID,AracID")] Kiralama kiralama)
{
if (ModelState.IsValid)
{
_context.Add(kiralama);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["AracID"] = new SelectList(_context.Araclar, "ID", "ID", kiralama.AracID);
ViewData["MüsteriID"] = new SelectList(_context.Müsteriler, "ID", "ID", kiralama.MüsteriID);
return(View(kiralama));
}
private void btn_s_sil_Click(object sender, EventArgs e)
{
//if (lstvw_s_sozlesmeler.SelectedItems.Count <= 0)
// return;
//int id = Convert.ToInt32(lstvw_s_sozlesmeler.SelectedItems[0].Tag);
int id = Convert.ToInt32(dgvw_mevcutsozlesmeler.CurrentRow.Cells["ID"].Value.ToString());
Kiralama deleted = db.Kiralamas.Find(id);
SilinenSozlesmeler deletedsozlesme = new SilinenSozlesmeler();
DialogResult nodelete = new DialogResult();
nodelete = MessageBox.Show("Kaydı silmek istedğinize emin misiniz?", "Bak siliyorsun dikkat et!!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (nodelete == DialogResult.Yes)
{
deletedsozlesme.ArabaID = Convert.ToInt32(cmb_s_musteri.SelectedValue);
deletedsozlesme.MusteriID = Convert.ToInt32(cmb_s_araba.SelectedValue);
deletedsozlesme.AlisTarihi = Convert.ToDateTime(dtp_alimtarihi.Text);
deletedsozlesme.TeslimTarihi = Convert.ToDateTime(dtp_teslimtarihi.Value);
TimeSpan GunFarki = dtp_teslimtarihi.Value.Subtract(dtp_alimtarihi.Value);
int saraba;
saraba = Convert.ToInt32(cmb_s_araba.SelectedValue);
dgvw_s_aracbilgi.DataSource = db.Cars.Where(x => x.ID == saraba).ToList();
int smusteri;
smusteri = Convert.ToInt32(cmb_s_musteri.SelectedValue);
dgvw_s_musteribilgi.DataSource = db.Customers.Where(x => x.ID == smusteri).ToList();
int b = Convert.ToInt32(GunFarki.Days);
int c = Convert.ToInt32(db.Cars.Where(x => x.ID == saraba).Sum(x => x.Fiyat));
deletedsozlesme.KiralanmaSuresi = Convert.ToInt32(GunFarki.Days.ToString());
deletedsozlesme.FaturaTutari = Convert.ToDecimal((b * c).ToString());
deletedsozlesme.AddDate = updated.AddDate;
deletedsozlesme.UpdateDate = updated.UpdateDate;
deletedsozlesme.DeleteDate = DateTime.Now;
deletedsozlesme.AktifMi = Convert.ToBoolean(cmb_s_aktifmi.SelectedIndex);
deletedsozlesme.DeleteDate = DateTime.Now;
deletedsozlesme.AddDate = updated.AddDate;
deletedsozlesme.UpdateDate = updated.UpdateDate;
db.SilinenSozlesmelers.Add(deletedsozlesme);
db.Kiralamas.Remove(deleted);
db.SaveChanges();
}
cmb_s_aktifmi.SelectedIndex = -1;
cmb_s_araba.SelectedIndex = -1;
cmb_s_musteri.SelectedIndex = -1;
dtp_alimtarihi.Text = string.Empty;
dtp_teslimtarihi.Text = string.Empty;
lbl_sure.Text = string.Empty;
lbl_tutar.Text = string.Empty;
//SozlesmeList();
SozlesmeListDataGrid();
}
public bool UpdateKiralama(Kiralama entity)
{
try
{
bool isSuccess;
using (var repo = new KiralamaRepository())
{
isSuccess = repo.Update(entity);
}
return(isSuccess);
}
catch (Exception ex)
{
throw new Exception("KiralamaBusiness:KiralamaRepository:Güncelleme Hatası", ex);
}
}
public bool InsertKiralama(Kiralama entity)
{
try
{
bool isSuccess;
using (var repo = new KiralamaRepository())
{
isSuccess = repo.Insert(entity);
}
return(isSuccess);
}
catch (Exception ex)
{
throw new Exception("SOABusiness:KiralamaBusiness::InsertKiralama::Error occured.", ex);
}
}
public ActionResult Add(int Id, DateTime startdate, DateTime enddate)
{
string email = Session["Email"].ToString();
Musteri mstri = db.Musteri.FirstOrDefault(x => x.Email == email);
Arac arc = db.Arac.FirstOrDefault(x => x.Id == Id);
arc.Durum = false;
db.Entry(arc).CurrentValues.SetValues(arc);
Kiralama kiralama = new Kiralama();
kiralama.AracId = arc.Id;
kiralama.MüsteriTc = mstri.TC;
kiralama.Baslangıc = startdate;
kiralama.Bitis = enddate;
db.Kiralama.Add(kiralama);
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
private async void btnKiralamaKaydet_Click(object sender, EventArgs e)
{
try
{
bool success = false;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://localhost:64124/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
Kiralama kiralama = new Kiralama()
{
VerilisTarihi = txtVerilisTarihi.Text,
AlinisTarihi = txtAlinisTarihi.Text,
VerilisKilometre = int.Parse(txtVerilisKilometre.Text),
GidilenKilometre = int.Parse(txtGidilenKilometre.Text),
AlinanUcret = int.Parse(txtAlinanUcret.Text),
Kullanici = int.Parse(txtKullanici.Text),
Arac = int.Parse(txtArac.Text)
};
var serializedProduct = JsonConvert.SerializeObject(araba);
var content = new StringContent(serializedProduct, Encoding.UTF8, "application/json");
var result = await client.PostAsync("api/Kiralama", content);
if (result.IsSuccessStatusCode)
{
success = true;
}
}
var message = success ? "done" : "failed";
MessageBox.Show("Operation " + message);
ListeleAraba();
}
catch (Exception ex)
{
MessageBox.Show("Error happened: " + ex.Message);
}
}
public async System.Threading.Tasks.Task <ActionResult> CreateAsync(FormCollection collection)
{
Kiralama yKiralama = new Kiralama();
yKiralama.aracId = Convert.ToInt32(collection["aracId"].ToString());
yKiralama.geriAlisTarihi = Convert.ToDateTime(collection["alisTarihi"]);
yKiralama.verilisTarihi = Convert.ToDateTime(collection["verisTarihi"]);
yKiralama.musteriId = 1;
yKiralama.sonKm = Convert.ToInt32(collection["sonKm"]);
yKiralama.ucret = Convert.ToInt32(collection["ucret"]);
yKiralama.verilisKm = Convert.ToInt32(collection["verilisKm"]);
yKiralama.sirketId = 1;
try
{
// Create a HttpClient
using (var client = new HttpClient())
{
// Setup basics
client.BaseAddress = new Uri("http://localhost:49774/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(
new MediaTypeWithQualityHeaderValue("application/json"));
// Create post body object
// Serialize C# object to Json Object
var serializedProduct = JsonConvert.SerializeObject(yKiralama);
// 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/KiralamaBusiness", content);
// Check for result
return(RedirectToAction("IndexAsync"));
}
}
catch (Exception ex)
{
// Inform user
return(View());
}
}
//Arabalar updated1;
private void btn_kirala_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(listView1.SelectedItems[0].Text);
List <Arabalar> arabalars = new List <Arabalar>();
arabalars = db.Cars.Where(x => x.ID == id).ToList();
rent = db.Cars.Find(id);
//rent.AktifMi = false;
Kiralama kiralama = new Kiralama();
foreach (Arabalar item in arabalars)
{
TimeSpan ks = dateTimePicker2.Value - dateTimePicker1.Value;
kiralama.ArabaID = rent.ID;
kiralama.MusteriID = rent.ID;
kiralama.AlisTarihi = dateTimePicker1.Value;
kiralama.TeslimTarihi = dateTimePicker2.Value;
kiralama.KiralanmaSuresi = Convert.ToInt32(ks.Days.ToString());
kiralama.FaturaTutari = fiyat;
kiralama.AktifMi = true;
//updated1.AktifMi = false;
rent.AktifMi = false;
}
//
//updated1.AktifMi = false;
db.Kiralamas.Add(kiralama);
db.Entry(db.Cars.Find(rent.ID)).CurrentValues.SetValues(rent);
db.SaveChanges();
MessageBox.Show("Kiralama İşlemi Gerçekleştirildi.");
MessageBox.Show("Sözleşme DB'e Eklendi");
ArabaSec();
}
public int KitapKirala(Kiralama kk)
{
try
{
cmd = new SqlCommand("insert into Kiralama (KiralamaBaslangicTarihi,KiralamaBitisTarihi,KiralamaFiyati,KitapID,UyeID) values(@KiralamaBaslangicTarihi, @KiralamaBitisTarihi,@KiralamaFiyati, @KitapID, @UyeID)", con);
cmd.Parameters.Add("@KiralamaBaslangicTarihi", SqlDbType.Date).Value = kk.KiralamaBaslangicTarihi;
cmd.Parameters.Add("@KiralamaBitisTarihi", SqlDbType.Date).Value = kk.KiralamaBitisTarihi;
cmd.Parameters.Add("@KiralamaFiyati", SqlDbType.Money).Value = kk.KiralamaFiyati;
cmd.Parameters.Add("@KitapID", SqlDbType.Int).Value = kk.KitapID;
cmd.Parameters.Add("@UyeID", SqlDbType.Int).Value = kk.UyeID;
BaglantiAyarla();
donendeger2 = cmd.ExecuteNonQuery();
}
catch (Exception)
{
}
finally
{
BaglantiAyarla();
}
return(donendeger2);
}
private void BtnTamamla_Click(object sender, EventArgs e)
{
Araba araba2 = db.Arabalar.FirstOrDefault(x => x.SasiNo == sasiNo);
int id = araba2.ID;
Kiralama kiralama = new Kiralama();
kiralama.GunSayisi = Convert.ToInt32(nmrGunSayisi.Value);
kiralama.Fiyat = Convert.ToDecimal(lblFiyat.Text);
kiralama.Indirim = lblIndirim.Text;
kiralama.MusteriID = uyeId;
kiralama.ID = id;
Araba araba = db.Arabalar.FirstOrDefault(x => x.SasiNo == sasiNo);
araba.KiradaMi = true;
db.Kiralamalar.Add(kiralama);
db.SaveChanges();
MessageBox.Show("Kiralama işlemi başarılı bir şekilde gerçekleşti.");
this.Close();
}
