private void btnSave_Click(object sender, EventArgs e)
{
if (id == 0)
{
var isExist = db.Customers
.Any(x => x.Plaque.ToUpper() == txtPlaque.Text.ToUpper() && !x.Deleted);
if (isExist)
{
MessageBox.Show("Plaka ile daha önce kayıt mevcuttur", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var add = new Customer();
add.Plaque = txtPlaque.Text;
add.NameSurname = txtNameSurname.Text;
add.Telephone = txtTelephone.Text;
add.BrandId = (int)cmbBrand.SelectedValue;
add.SerieId = (int)cmbSerie.SelectedValue;
add.Year = txtYear.Text;
add.Color = txtColor.Text;
add.Comment = txtComment.Text;
db.Customers.Add(add);
db.SaveChanges();
MessageBox.Show("Ekleme işlemi başarılı", "Kayıt", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnClean.PerformClick();
}
}
else
{
var customer = db.Customers
.FirstOrDefault(x => x.Id == id);
if (customer != null)
{
customer.Plaque = txtPlaque.Text;
customer.NameSurname = txtNameSurname.Text;
customer.Telephone = txtTelephone.Text;
customer.BrandId = (int)cmbBrand.SelectedValue;
customer.SerieId = (int)cmbSerie.SelectedValue;
customer.Year = txtYear.Text;
customer.Color = txtColor.Text;
customer.Comment = txtComment.Text;
db.SaveChanges();
MessageBox.Show("Güncelleme işlemi başarılı", "Kayıt", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnClean.PerformClick();
}
else
{
MessageBox.Show("Müşteri bulunamadı.", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
FrmCustomerList.frmCustomerList.GridFill();
this.Close();
}
public ServiceResult Post(Brand brand)
{
var result = new ServiceResult {
IsSuccess = true
};
context.Brands.Add(brand);
context.SaveChanges();
return(result);
}
public ServiceResult Post(Tariff tariff)
{
var result = new ServiceResult {
IsSuccess = true
};
context.Tariffs.Add(tariff);
context.SaveChanges();
return(result);
}
public ServiceResult Post(CarParkingSpace model)
{
var result = new ServiceResult {
IsSuccess = true
};
model.Status = false;
context.CarParkingSpaces.Add(model);
context.SaveChanges();
return(result);
}
private void btnAdd_Click(object sender, EventArgs e)
{
var tbl = new Brand();
tbl.BrandName = txtBrandName.Text;
db.Brands.Add(tbl);
db.SaveChanges();
MessageBox.Show("Araç markası eklendi", "Kayıt", MessageBoxButtons.OK, MessageBoxIcon.Information);
BrandList();
Clean();
}
public ServiceResult Post(SerieModel model)
{
var result = new ServiceResult {
IsSuccess = true
};
var serie = new Serie
{
BrandId = model.BrandId,
SerieName = model.SerieName
};
context.Series.Add(serie);
context.SaveChanges();
return(result);
}
private void btnPay_Click(object sender, EventArgs e)
{
var customer = db.Customers
.Include(x => x.CarParkingSpaces)
.FirstOrDefault(x => x.Plaque == cmbPlaque.Text);
if (customer != null)
{
if (tariff != null)
{
var sell = new Sell
{
Amount = tariff.Amount,
CarParkingSpaceId = customer.CarParkingSpaceId.Value,
CustomerId = customer.Id,
EntryDate = customer.EntryDate.Value,
ExitDate = DateTime.Now,
Time = (decimal)hour
};
db.Sells.Add(sell);
}
customer.CarParkingSpaceId = null;
customer.EntryDate = null;
customer.CarParkingSpaces.Status = false;
db.SaveChanges();
PlaqueLoad();
MessageBox.Show("Ödeme işlemi başarılı", "Ödeme", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void btnProcess_Click(object sender, EventArgs e)
{
var emptyParking = db.CarParkingSpaces
.FirstOrDefault(x => x.ParkingSpaces == cmbParkSpace.Text);
emptyParking.Status = true;
var customer = db.Customers
.Include(x => x.CarParkingSpaces)
.FirstOrDefault(x => x.Id == id);
// mevcutta otoparkta başka bir yerde ise yeri değiştiriliyor
if (customer.CarParkingSpaceId != null)
{
customer.CarParkingSpaces.Status = false;
}
if (customer != null)
{
customer.EntryDate = DateTime.Now;
customer.CarParkingSpaceId = (int)cmbParkSpace.SelectedValue;
}
db.SaveChanges();
this.Close();
FrmCustomerList.frmCustomerList.GridFill();
MessageBox.Show("Park yeri kaydedildi", "Kayıt", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dialog = new DialogResult();
dialog = MessageBox.Show("Silmek istiyor musunuz?", "Silme Onayı", MessageBoxButtons.YesNo);
if (dialog == DialogResult.Yes)
{
using (CarParkDbContext db = new CarParkDbContext())
{
int id = int.Parse(dataGridCustomerList.CurrentRow.Cells[0].Value.ToString());
var customer = db.Customers
.Include(x => x.CarParkingSpaces)
.FirstOrDefault(x => x.Id == id);
if (customer != null)
{
customer.Deleted = true;
customer.CarParkingSpaces.Status = false;
db.SaveChanges();
MessageBox.Show("Kayıt silindi", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clean();
GridFill();
}
else
{
MessageBox.Show("Müşteri bulunamadı", "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
public ServiceResult Delete(int id)
{
var result = new ServiceResult {
IsSuccess = false
};
var customer = context.Customers
.Include(x => x.CarParkingSpaces)
.FirstOrDefault(x => x.Id == id);
if (customer != null)
{
customer.Deleted = true;
if (customer.CarParkingSpaces != null)
{
customer.CarParkingSpaces.Status = false;
}
context.SaveChanges();
result.IsSuccess = true;
}
return(result);
}
public ServiceResult MyAccountEdit(UserProfileModel model)
{
var result = new ServiceResult {
IsSuccess = false
};
var data = context.Users.Find(model.Id);
if (data != null)
{
data.NameSurname = model.NameSurname;
data.BirthDate = model.BirthDate;
data.Gender = model.Gender;
context.SaveChanges();
result.IsSuccess = true;
}
return(result);
}
public ServiceResult Post(SellModel sell)
{
var result = new ServiceResult {
IsSuccess = false
};
var customer = context.Customers
.Include(x => x.CarParkingSpaces)
.FirstOrDefault(x => x.Id == sell.CustomerId);
if (customer != null)
{
if (sell != null)
{
var model = new Sell
{
Amount = sell.Amount,
CarParkingSpaceId = customer.CarParkingSpaceId.Value,
CustomerId = customer.Id,
EntryDate = customer.EntryDate.Value,
ExitDate = DateTime.Now,
Time = (decimal)sell.Hour
};
context.Sells.Add(model);
customer.CarParkingSpaceId = null;
customer.EntryDate = null;
customer.CarParkingSpaces.Status = false;
context.SaveChanges();
result.IsSuccess = true;
}
}
else
{
result.Message = "Müşteri Bulunamadı!";
}
return(result);
}
