public ActionResult MarkaEkle(Marka marka, List <HttpPostedFileBase> image)
{
Resim _resim;
foreach (var item in image)
{
_resim = new Resim();
var extension = Path.GetExtension(item.FileName);
if (image != null && (extension == ".jpg" || extension == ".png" || extension == ".jpeg"))
{
var path = Server.MapPath("~/UploadImages");
var RandomFileName = Path.GetRandomFileName();
var Name = Path.ChangeExtension(RandomFileName, ".jpg");
var final = Path.Combine(path, Name);
item.SaveAs(final);
_resim.Ad = Name;
marka.Resim.Add(_resim);
}
}
_marka.PostMarka(marka);
ViewBag.Ekleme = "true";
return(View("MarkaIslem", _marka.GetMarkas()));
}
private void btnEkle_Click(object sender, EventArgs e)
{
Marka m = new Marka()
{
MarkaAdi = txtmarkaAd.Text
};
MarkaRepository rep = new MarkaRepository();
int mid = 0;
bool result = rep.MarkaEkle(m, out mid);
if (result == true)
{
MarkaLabel lbl = new MarkaLabel();
lbl.Text = txtmarkaAd.Text;
lbl.MarkaId = mid;
MarkalarForm f = (MarkalarForm)Application.OpenForms["MarkalarForm"];
if (f != null)
{
f.MarkaLabelEkle(lbl);
}
txtmarkaAd.Clear();
MessageBox.Show("Eklendi");
}
else
{
MessageBox.Show("hata olustu");
}
}
public async Task UpdateMarka(int id, Marka marka)
{
var updateData = await context.Markas.FindAsync(id);
updateData.Name = marka.Name;
context.SaveChanges();
}
public ActionResult MarkaAktifguncelle(int?id)
{
Marka marka = _markaManagement.Get(x => x.id == id);
return(View(marka));
}
public ActionResult MarkaEkle(Marka mrk, HttpPostedFileBase fileUpload)
{
int resimId = -1;
if (fileUpload != null)
{
Image img = Image.FromStream(fileUpload.InputStream);
int width = Convert.ToInt32(ConfigurationManager.AppSettings["MarkaWidth"].ToString());
int height = Convert.ToInt32(ConfigurationManager.AppSettings["MarkaHeight"].ToString());
string name = "/Content/MarkaResim/" + Guid.NewGuid() + Path.GetExtension(fileUpload.FileName);
//resim çektiğimiz yer, resmin uzantısını alır.
Bitmap bm = new Bitmap(img, width, height);
bm.Save(Server.MapPath(name));
Resim rsm = new Resim(); //resim tanımladık
rsm.OrtaYol = name;
Context.Baglanti.Resims.Add(rsm);
Context.Baglanti.SaveChanges();
if (rsm.Id != null)
{
resimId = rsm.Id;
}
}
if (resimId != -1)
{
mrk.ResimId = resimId;
}
Context.Baglanti.Markas.Add(mrk);
Context.Baglanti.SaveChanges();
return(RedirectToAction("Markalar"));
}
private void cbMarkalar_SelectedIndexChanged(object sender, EventArgs e)
{
Marka m = new Marka();
txtMarkaAd.Text = cbMarkalar.SelectedItem.ToString();
txtMarkaID.Text = m.MarkaIDGetir(txtMarkaAd.Text).ToString();
}
static public void DodajDoLsty(Marka marka, string rej, string usterka)
{
if (!samochody.Any(s => s.PobierzRejestracje() == rej && s.Marka != marka))
{
samochody.Add(Samochod.StworzSamochod(marka, rej, usterka));
}
}
public async Task <int> UpdateMarkaAsync(Marka marka)
{
marka.Nosaukums = marka.Nosaukums.ToUpper();
// pārbaudam vai marka jau esistē
var exist = await _context.Markas.AsNoTracking()
.Where(m => m.Id != marka.Id && m.Nosaukums == marka.Nosaukums)
.CountAsync();
if (exist > 0)
{
throw new BadRequestException("Marka ar šādu nosaukumu jau eksistē");
}
_memoryCache.Remove("VEHICLE-BRANDS");
var brand = await _context.Markas.Where(m => m.Id == marka.Id).FirstAsync();
// nepieciešams atjaunināt arī transportlīdzekļu markas
var vehicles = await _context.Transportlidzekli.Where(t => t.Marka == brand.Nosaukums).ToListAsync();
vehicles.ForEach(v => v.Marka = marka.Nosaukums);
brand.Nosaukums = marka.Nosaukums;
return(await _context.SaveChangesAsync());
}
private void btnEkle_Click(object sender, EventArgs e)
{
Marka m = new Marka();
m.MarkaAdi = txtMarkaAdi.Text;
//Marka m = new Marka() //üsttekinin farklı hali
//{
// MarkaAdi = txtMarkaAdi.Text
//};
MarkaRepository rep = new MarkaRepository();
int mid = 0;
bool result = rep.MarkaEkle(m, out mid);
if (result)
{
MarkaLabel lbl = new MarkaLabel();
lbl.Text = txtMarkaAdi.Text;
lbl.MarkaId = 0;
MarkalarForm f = (MarkalarForm)Application.OpenForms["MarkalarForm"];
if (f != null)
{
f.MarkaLabelEkle(lbl);
}
txtMarkaAdi.Clear();
MessageBox.Show("Eklendi");
}
else
{
MessageBox.Show("Hata");
}
}
public ActionResult MarkaEkle(Marka marka, HttpPostedFileBase fileUpload)
{
int resimId = -1;
if (fileUpload != null)
{
Image image = Image.FromStream(fileUpload.InputStream);
int width = Convert.ToInt32(ConfigurationManager.AppSettings["MarkaWidht"].ToString());
int height = Convert.ToInt32(ConfigurationManager.AppSettings["MarkaHeight"].ToString());
string name = "/Content/MarkaResim/" + Guid.NewGuid() + Path.GetExtension(fileUpload.FileName);
Bitmap bm = new Bitmap(image, width, height);
bm.Save(Server.MapPath(name));
Resim rsm = new Resim();
rsm.Ortayol = name;
db.Resim.Add(rsm);
db.SaveChanges();
if (rsm.Id != 0)
{
resimId = rsm.Id;
}
}
if (resimId != -1)
{
marka.ResimId = resimId;
}
db.Marka.Add(marka);
db.SaveChanges();
return(RedirectToAction("Markalar"));
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
try
{
var marka = new Marka
{
Aktif = cbAktif.Checked,
EklenmeTarihi = DateTime.Now,
MarkaAciklamasi = txtMarkaAciklamasi.Text,
MarkaAdi = txtMarkaAdi.Text
};
if (FuMarkaLogo.HasFile) //Eğer resim yükleme elemanından bir resim seçilmişse
{
FuMarkaLogo.SaveAs(Server.MapPath("~/Uploads/" + FuMarkaLogo.FileName)); //file uploaddan seçilen resmi sunucudaki uploads klasörüne kaydet
marka.MarkaLogo = FuMarkaLogo.FileName;
}
if (string.IsNullOrEmpty(lblId.Text))
{
markaManager.Add(marka);//yukarda oluşturduğumuz marka nesnesini veritabanına ekle
}
else
{
marka.Id = int.Parse(lblId.Text);
markaManager.Update(marka);
}
Response.Redirect("MarkaYonetimi.aspx");//Sayfayı yönlendir
}
catch (Exception)
{
lblMesaj.Text = "Hata Oluştu";
}
}
static void Main(string[] args)
{
Kolekcja czekolady = new Kolekcja();
czekolady[0] = new Marka("Wedel");
czekolady[1] = new Marka("Milka");
czekolady[2] = new Marka("Wawel");
czekolady[3] = new Marka("Lint");
czekolady[4] = new Marka("Nussbeisser");
czekolady[5] = new Marka("Terravita");
czekolady[6] = new Marka("Ritter");
czekolady[7] = new Marka("Alpen Gold");
czekolady[7] = new Marka("Deco Morreno");
czekolady[7] = new Marka("Toblerone");
Iterator iterator = czekolady.DodajIterator();
Console.WriteLine("Przeszukanie Kolekcji:");
for (Marka marka = iterator.Pierwsza();
!iterator.Gotowe; marka = iterator.Kolejna())
{
Console.WriteLine(marka.Nazwa);
}
Console.WriteLine();
}
private void btnSacuvajMarka_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(txtNazivMarke.Text))
{
tbPoruka1.Text = "Morate uneti naziv marke vozila.";
return;
}
tbPoruka1.Text = "";
Marka novaMarka = new Marka();
novaMarka.NazivMarke = txtNazivMarke.Text;
if (String.IsNullOrEmpty(txtIDMarke.Text) != true)
{
Marka staraMarka = Marka.UcitajMarku(Convert.ToInt32(txtIDMarke.Text));
staraMarka.Azuriraj(novaMarka);
}
else
{
if (novaMarka.PostojiDuplikat())
{
tbPoruka1.Text = "Ova marka već postoji u bazi. Ne možete sačuvati duplikat.";
return;
}
novaMarka.Sacuvaj();
}
UcitajListuMarki();
}
private void btnObrisiMarka_Click(object sender, RoutedEventArgs e)
{
if (dgPregledMarke.Items.Count > 0)
{
DataRowView red = (DataRowView)dgPregledMarke.SelectedItems[0];
int id = Convert.ToInt32(red[0]);
try
{
MessageBoxResult rez = MessageBox.Show(@"Da li ste sigurni?",
"Upozorenje",
MessageBoxButton.YesNo, MessageBoxImage.Question);
if (rez != MessageBoxResult.Yes)
{
return;
}
Marka marka = Marka.UcitajMarku(id);
marka.Obrisi();
UcitajListuMarki();
}
catch (InvalidOperationException)
{
MessageBox.Show("Niste izabrali red.", "Greška",
MessageBoxButton.OK, MessageBoxImage.Error);
}
catch (Exception ex)
{
MessageBox.Show($"Došlo je do greške prilikom pokušaja brisanja podataka: { ex.Message }.", "Greška",
MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
public ActionResult MarkaEkle(Marka mrk, HttpPostedFileBase filee)
{
int resimID = -1;
if (filee != null)
{
Image img = Image.FromStream(filee.InputStream);
int width = Convert.ToInt32(ConfigurationManager.AppSettings["MarkaWidth"].ToString());
int height = Convert.ToInt32(ConfigurationManager.AppSettings["MarkaHeight"].ToString());
string name = "/Content/MarkaResim/" + Guid.NewGuid() + Path.GetExtension(filee.FileName);
Bitmap bm = new Bitmap(img, width, height);
bm.Save(Server.MapPath(name));
Resim rsm = new Resim();
rsm.OrtaYol = name;
_resimManagement.Add(rsm);
if (rsm.id != null)
{
resimID = rsm.id;
}
}
if (resimID != -1)
{
mrk.ResimID = resimID;
}
_markaManagement.Add(mrk);
return(RedirectToAction("Markalar"));
}
private void buttonMarkaUsun_Click(object sender, EventArgs e)
{
Marka doUsuniecia = (Marka)listBoxMarkaAuta.SelectedItem;
_ctx.Marka.Remove(doUsuniecia);
_ctx.SaveChanges();
}
private void btnKaydet_Click(object sender, EventArgs e)
{
if (txtMarkaAd.Text.Trim() != "")
{
Marka m = new Marka();
if (m.MarkaVarmi(txtMarkaAd.Text, Convert.ToInt32(txtSinifID.Text)))
{
MessageBox.Show("Marka zaten kayıtlı!");
}
else
{
m.MarkaAd = txtMarkaAd.Text.ToUpper();
m.Aciklama = txtAciklama.Text.ToUpper();
m.SinifID = Convert.ToInt32(txtSinifID.Text);
if (m.MarkaEkle(m))
{
MessageBox.Show("Marka başarı ile eklendi.");
m.MarkalariGetir(lvMarkalar);
Temizle();
btnKaydet.Enabled = false;
btnDegistir.Enabled = true;
btnSil.Enabled = true;
}
else
{
MessageBox.Show("Marka eklenemedi.");
}
}
}
else
{
MessageBox.Show("Marka Adı boş bırakılamaz.");
}
}
public void Execute(NapraviIzmeniMarku request)
{
if (request == null)
{
throw new NullReferenceException("Marka");
}
if (Context.Marke.Any(m => m.MarkaAutomobila == request.Marka))
{
throw new EntityAlreadyExists("Marka");
}
var marka = new Marka
{
MarkaAutomobila = request.Marka,
DateCreated = DateTime.Now
};
try
{
Context.Marke.Add(marka);
Context.SaveChanges();
}
catch (Exception)
{
throw new EntryPointNotFoundException();
}
}
public static bool MarkaKaydet(VMMArka Al) //Marka Kaydet
{
using (DBCON db = new DBCON())
{
try
{
bool Control = db.Marka.Any(p => p.MarkaAdi == Al.MarkaAdi);
if (Control == true)
{
return(false);
}
else
{
Marka Ekle = new Marka
{
MarkaAdi = Al.MarkaAdi
};
db.Marka.Add(Ekle);
db.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,CategoryId")] Marka marka)
{
if (id != marka.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(marka);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MarkaExists(marka.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CategoryId"] = new SelectList(_context.Category, "Id", "Name", marka.CategoryId);
return(View(marka));
}
public ActionResult Create(Marka data)
{
#region Ekleme
try
{
if (ModelState.IsValid)
{
if (db.Marka.Any(x => x.MarkaAdi.Equals(data.MarkaAdi)))
{
ModelState.AddModelError("MarkaAdi", "Bu Marka adı zaten kayıtlı");
return(View(data));
}
else
{
mr.Insert(data);
}
return(RedirectToAction("List"));
}
}
catch (DataException)
{
ModelState.AddModelError(string.Empty, "Kayıt Eklenemedi");
}
return(View(data));
#endregion
}
public async Task <IActionResult> Edit(int id, [Bind("Id,MarkaAdi,MarkaAciklamasi,EklenmeTarihi,Aktif,MarkaLogo")] Marka marka)
{
if (id != marka.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(marka);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MarkaExists(marka.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(marka));
}
public void Guncelle(Marka item)
{
Marka updated = _ac.Markalar.Find(item.MarkaID);
_ac.Entry(updated).CurrentValues.SetValues(item);
_ac.SaveChanges();
}
public IHttpActionResult PutMarka(int id, Marka marka)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != marka.MarkaId)
{
return(BadRequest());
}
db.Entry(marka).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!MarkaExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult MarkaEkle(Marka mrk, HttpPostedFileBase fileUpload)
{
int resimId = -1;
if (fileUpload != null)
{
Image img = Image.FromStream(fileUpload.InputStream);
int width = Convert.ToInt32(ConfigurationManager.AppSettings["MarkaResimWidth"].ToString()); //Web Config de <add key="DegerİsmiYazılır" value="Deger Atanır" şeklinde eklediğimiz width ve height leri burak ConfigurationManager.AppSettings ile ulaşarak int değer içine atadık/>
int height = Convert.ToInt32(ConfigurationManager.AppSettings["MarkaResimHeight"].ToString()); //Web Config de <add key="DegerİsmiYazılır" value="Deger Atanır" şeklinde eklediğimiz width ve height leri burak ConfigurationManager.AppSettings ile ulaşarak int değer içine atadık/>
// Guid 24 basamaklı eşi benzeri olmayan bir string ifade verir
string name = "/Content/MarkaResim/" + Guid.NewGuid() + Path.GetExtension(fileUpload.FileName);
Bitmap bm = new Bitmap(img, width, height);
bm.Save(Server.MapPath(name));
Resim rsm = new Resim();
rsm.OrtaYol = name;
Context.Baglanti.Resim.Add(rsm);
Context.Baglanti.SaveChanges();
if (rsm.Id != null)
{
resimId = rsm.Id;
}
}
if (resimId != -1)
{
mrk.ResimID = resimId;
}
Context.Baglanti.Marka.Add(mrk);
Context.Baglanti.SaveChanges();
return(RedirectToAction("Markalar"));
}
public ActionResult DeleteConfirmed(int id)
{
Marka marka = db.Marka.Find(id);
db.Marka.Remove(marka);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult MarkaSil(int id)
{
Marka mrk = Context.Baglanti.Markas.FirstOrDefault(x => x.Id == id);
Context.Baglanti.Markas.Remove(mrk);
Context.Baglanti.SaveChanges();
return(RedirectToAction("Markalar"));
}
public ActionResult MarkaSil(Marka m)
{
var sorgu = ent.Marka.Where(u => u.Id == m.Id).FirstOrDefault();
sorgu.Deleted = true;
ent.SaveChanges();
return(RedirectToAction("Markalar"));
}
public async Task <Marka> AddMarka(Marka marka)
{
await _context.Markat.AddAsync(marka);
await _context.SaveChangesAsync();
return(marka);
}
public int Update(Marka marka)
{
Marka yeniMarka = _context.Markalar.Find(marka.MarkaId);
yeniMarka.MarkaAdi = marka.MarkaAdi;
etkilenenKayit = _context.SaveChanges();
return(etkilenenKayit);
}
public List<Marka> MarkaListesi()
{
BaglantiAc();
string query = "select *from Markalar";
SqlCommand cmd = new SqlCommand(query, baglanti);
//Create a data reader and Execute the command
SqlDataReader dataReader = cmd.ExecuteReader();
List<Marka> markaList = new List<Marka>();
if (dataReader != null)
{
//Read the data and store them in the list
while (dataReader.Read())
{
Marka marka = new Marka();
marka.id = Convert.ToInt32(dataReader["id"] + "");
marka.adi = dataReader["adi"] + "";
markaList.Add(marka);
}
//close Data Reader
dataReader.Close();
//close Connection
this.BaglantiKapat();
//return list to be displayed
return markaList;
}
else
{
return null;
}
}
