void KayitSil() { DialogResult re = MessageBox.Show("Kayıt Silinsin mi?", "Dikkat", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); if (re == DialogResult.Yes) { try { Sube sube = managerSube.GetById(txtSubeKodu.Text, true); if (!UserInfo.Kullanici.Adminmi.Value) { MessageBox.Show("Sadece admin kullanıcı şube silebilir"); return; } if (sube != null && UserInfo.Sube.Id == sube.Id) { MessageBox.Show("Bulunduğunuz şubeyi silemezsiniz"); return; } managerSube.BeginTransaction(); managerSube.Delete(sube); LoadAllSube(); btnYeni_Click(this, EventArgs.Empty); } catch (Exception exc) { MessageBox.Show(exc.Message); LogWrite.Write(exc); } finally { try { managerSube.CommitChanges(); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } } } }
void Kaydet() { Sube sube = new Sube(); //AssignSubeValue(sube); try { sube = managerSube.GetById(txtSubeKodu.Text, false); if (sube == null) { sube = new Sube(); } AssignSubeValue(sube); sube.Id = txtSubeKodu.Text; BeginTransaction(); managerSube.SaveOrUpdate(sube); LoadAllSube(); YeniKayit(); } catch (Exception) { } finally { try { CommitTransaction(); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } } }
public void UpdateSube(Sube model) { Sube sube = repository.Find(x => x.Id == model.Id); sube.isim = model.isim; repository.Update(); }
void AssignSubeValue(Sube sube) { sube.SubeIsmi = txtSubeIsmi.Text; sube.Adres = txtAdres.Text; sube.VergiNo = txtVergiNo.Text; sube.VergiDairesi = txtVergiDairesi.Text; sube.Aktif = chkAktif.Checked ? true : false; sube.Merkezmi = chkMerkez.Checked ? true : false; }
public void UpdateDepartman(Departman model, int dropSube) { Departman departman = repository.Find(x => x.Id == model.Id); Sube sube = repositorySube.Find(x => x.Id == dropSube); departman.isim = model.isim; departman.Sube = sube; repository.Update(); }
public static bool Sil(Sube nesne) { SqlCommand sil = new SqlCommand("SubeSil", Tools.Baglanti); sil.CommandType = CommandType.StoredProcedure; sil.Parameters.AddWithValue("@SubeID", nesne.SubeID); return(Tools.ExecuteNonQuery(sil)); }
private void button2_Click(object sender, EventArgs e) { Sube sil = new Sube(); sil.SubeID = (int)textBox1.Tag; if (!Subeler.Sil(sil)) { MessageBox.Show("Veri Silinemedi.."); } dataGridView1.DataSource = Subeler.Listele(); }
public void UpdateEkip(Ekip model, int subedrop, int departmandrop) { Sube sube = repositorySube.Find(x => x.Id == subedrop); Departman departman = repositoryDepartman.Find(x => x.Id == departmandrop); Ekip ekip = repository.Find(x => x.Id == model.Id); ekip.isim = model.isim; ekip.Sube = sube; ekip.Departman = departman; repository.Update(); }
public static bool Yenile(Sube nesne) { SqlCommand kaydet = new SqlCommand("SubeYenile", Tools.Baglanti); kaydet.CommandType = CommandType.StoredProcedure; kaydet.Parameters.AddWithValue("@SubeID", nesne.SubeID); kaydet.Parameters.AddWithValue("@SubeAdi", nesne.SubeAdi); kaydet.Parameters.AddWithValue("@SubeIl", nesne.SubeIl); kaydet.Parameters.AddWithValue("@SubeIlce", nesne.SubeIlce); kaydet.Parameters.AddWithValue("@TeslimDurumu", nesne.TeslimDurumu); return(Tools.ExecuteNonQuery(kaydet)); }
public void SetOgretmenPropInConst() { //Arrange Ders ders = new Ders("Test Ders"); Sube sube = new Sube("Test Sube"); Ogretmen ogretmen = new Ogretmen("Test Ogretmen"); //Act Egitim egitim = new Egitim(ders, ogretmen, sube); // Assert Assert.AreEqual(ogretmen, egitim.Ogretmen); }
public void AddDepartman(Departman model, int Id) { Sube sube = repositorySube.Find(x => x.Id == Id); Departman departman = new Departman() { isim = model.isim, Sube = sube, }; sube.Departmens.Add(departman); repository.Insert(departman); }
public int DeleteSube(int?Id) { Sube sube = repository.Find(x => x.Id == Id); if (sube.Departmens.Count() != 0 || sube.Ekips.Count() != 0 || sube.Kisis.Count() != 0) { return(0); } else { repository.Delete(sube); return(1); } }
private void button1_Click(object sender, EventArgs e) { Sube ekle = new Sube(); ekle.SubeAdi = textBox1.Text; ekle.SubeIl = textBox2.Text; ekle.SubeIlce = textBox3.Text; ekle.TeslimDurumu = textBox4.Text; if (!Subeler.Ekle(ekle)) { MessageBox.Show("Veriler Eklenmedi...."); } dataGridView1.DataSource = Subeler.Listele(); }
public void AddEkip(Ekip model, int subedrop, int departmandrop) { Sube sube = repositorySube.Find(x => x.Id == subedrop); Departman departman = repositoryDepartman.Find(x => x.Id == departmandrop); Ekip ekip = new Ekip() { isim = model.isim, Departman = departman, Sube = sube }; sube.Ekips.Add(ekip); departman.Ekips.Add(ekip); repository.Insert(ekip); }
private void button3_Click(object sender, EventArgs e) { Sube yenile = new Sube(); yenile.SubeID = (int)textBox1.Tag; yenile.SubeAdi = textBox1.Text; yenile.SubeIl = textBox2.Text; yenile.SubeIlce = textBox3.Text; yenile.TeslimDurumu = textBox4.Text; if (!Subeler.Yenile(yenile)) { MessageBox.Show("Veriler Güncellenemedi...."); } dataGridView1.DataSource = Subeler.Listele(); }
private void btnDuzelt_Click(object sender, EventArgs e) { try { Sube sube = managerSube.GetById(txtSubeKodu.Text, true); AssignSubeValue(sube); managerSube.SaveOrUpdate(sube); managerSube.CommitChanges(); LoadAllSube(); } catch (Exception exc) { LogWrite.Write(exc); MessageBox.Show(exc.Message); } }
public void UpdateKisi(Kisi model, int subedrop, int departmandrop, int ekipdrop) { Sube sube = repositorySube.Find(x => x.Id == subedrop); Departman departman = repositoryDepartman.Find(x => x.Id == departmandrop); Ekip ekip = repositoryEkip.Find(x => x.Id == ekipdrop); Kisi kisi = repositoryKisi.Find(x => x.Id == model.Id); kisi.isim = model.isim; kisi.soyisim = model.soyisim; kisi.Statu = model.Statu; kisi.Sube = sube; kisi.dogumTarihi = model.dogumTarihi; kisi.Departman = departman; kisi.Ekip = ekip; kisi.maas = model.maas; repositoryKisi.Update(); }
public List <Sube> Filter([FromBody] Sube entity) { Expression <Func <Sube, bool> > predicate = PredicateBuilder.New <Sube>(true); if (entity.Ad != null) { predicate = predicate.And(x => x.Ad == entity.Ad); } if (entity.Il != null) { predicate = predicate.And(x => x.Il == entity.Il); } if (entity.Ilce != null) { predicate = predicate.And(x => x.Ilce == entity.Ilce); } return(_subeRepo.Filter(predicate)); }
public List <KodIsim> StokKods(string stokKodIsim, Sube sube) { //ICriteria criteria = Session.CreateCriteria(typeof(Stok)).SetProjection(Projections.Property("Id")) // .Add(Expression.Like("Id", stokKod, MatchMode.Start)).SetMaxResults(GetMaxResult); //ICriteria subeCriteria = criteria.CreateCriteria("Sube"); //subeCriteria.Add(NHibernate.Criterion.Expression.Eq("Id", sube.Id)); //return criteria.List<string>() as List<string>; //IQuery query = Session.CreateQuery("select st.Id from Stok st where st.Sube=:sube and st.Id like :st").SetString("st", stokKod + "%").SetEntity("sube", sube).SetMaxResults(10); //return (List<string>)query.List<string>(); KodIsim kodIsim = null; return(Session.QueryOver <Stok>().Where(x => (x.Sube == sube || x.SubelerdeOrtak == true) && (x.Id.IsLike(stokKodIsim, MatchMode.Anywhere) || x.StokAdi.IsLike(stokKodIsim, MatchMode.Anywhere))) .SelectList(liste => liste.SelectGroup(c => c.Id).WithAlias(() => kodIsim.Kod) .SelectGroup(c => c.StokAdi).WithAlias(() => kodIsim.Isim) ).TransformUsing(Transformers.AliasToBean <KodIsim>()) .Take(GetMaxResult).List <KodIsim>() as List <KodIsim>); }
protected override void GuncelNesneOlustur() { currentEnttiy = new Sube { Id = id, Kod = txtKod.Text, SubeAdi = txtSubeAdi.Text, GrupAdi = txtGrupAdi.Text, SiraNo = (int)txtSiraNo.Value, IbanNo = txtIbanNo.Text, Telefon = txtTelefon.Text, Fax = txtFax.Text, Adres = txtAdres.Text, AdresIlId = Convert.ToInt64(txtAdresIl.Id), AdresIlceId = Convert.ToInt64(txtAdresIlce.Id), Logo = (byte[])imgLogo.EditValue, Durum = tglDurum.IsOn }; ButonEnabledDurumu(); }
public List <Sube> SubeListe() { List <Sube> liste = new List <Sube>(); DbConnection connection = GetConnection(); connection.Open(); DbCommand cmd = connection.CreateCommand(); cmd.CommandText = "select SUBE_KODU from Sube"; cmd.Connection = connection; DbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { Sube sube = new Sube { Id = Convert.ToString(dr[0]) }; liste.Add(sube); } return(liste); }
public void AddKisi(Kisi model, int subedrop, int departmandrop, int ekipdrop) { Sube sube = repositorySube.Find(x => x.Id == subedrop); Departman departman = repositoryDepartman.Find(x => x.Id == departmandrop); Ekip ekip = repositoryEkip.Find(x => x.Id == ekipdrop); Kisi kisi = new Kisi() { isim = model.isim, soyisim = model.soyisim, maas = model.maas, dogumTarihi = model.dogumTarihi, Statu = model.Statu, Sube = sube, Departman = departman, Ekip = ekip }; sube.Kisis.Add(kisi); departman.Kisis.Add(kisi); ekip.Kisis.Add(kisi); repositoryKisi.Insert(kisi); }
public ActionResult AddSube(Sube model) { repoSube.AddSube(model); return(RedirectToAction("Index", "Sube")); }
protected void btnSube_Click(object sender, EventArgs e) { Sube sube; Adres adres; Il il; Ilce ilce; int selectedRowIndex = gvSube.SelectedIndex; try { if (selectedRowIndex < 0) { sube = new Sube(); adres = new Adres(); il = new Il(); ilce = new Ilce(); var i = ddlSubeIl.SelectedIndex; var ie = ddlSubeIlce.SelectedItem.Text.ToString(); il = db.Iller.Find(i); ilce = (from ii in db.Iller join iiee in db.Ilceler on ii.Id equals iiee.IlId where iiee.IlId == i && iiee.Ad == ie select iiee).SingleOrDefault(); adres.IlId = i; adres.IlceId = ilce.Id; adres.Mahalle = tbSubeMahalle.Text; adres.Sokak = tbSubeSokak.Text; db.Adresler.Add(adres); db.SaveChanges(); sube.Ad = tbSubeAd.Text; sube.Tel = tbSubeTel.Text; sube.AdresId = adres.Id; db.Subeler.Add(sube); lblSubeSonuc.Text = "Şube başarıyla eklenmiştir."; } else { int subeId = Convert.ToInt32(tbSubeId.Text); sube = db.Subeler.Find(subeId); int adresId = Convert.ToInt32(sube.AdresId); adres = db.Adresler.Find(adresId); var i = ddlSubeIl.SelectedIndex; var ie = ddlSubeIlce.SelectedItem.Text.ToString(); il = db.Iller.Find(i); ilce = (from ii in db.Iller join iiee in db.Ilceler on ii.Id equals iiee.IlId where iiee.IlId == i && iiee.Ad == ie select iiee).SingleOrDefault(); adres.IlId = i; adres.IlceId = ilce.Id; adres.Mahalle = tbSubeMahalle.Text; adres.Sokak = tbSubeSokak.Text; sube.Ad = tbSubeAd.Text; sube.Tel = tbSubeTel.Text; lblSubeSonuc.Text = "Sube başarıyla güncellenmiştir."; } db.SaveChanges(); } catch (Exception) { lblSubeSonuc.Text = "İşlem başarısız olmuştur."; } gvSubeDataBind(); clearSube(); }
protected override void Seed(DatabaseContext context) { for (int i = 0; i < 10; i++) { Sube sube = new Sube() { isim = FakeData.NameData.GetCompanyName(), }; context.Subes.Add(sube); for (int k = 0; k < 5; k++) { Departman departman = new Departman() { isim = FakeData.NameData.GetCompanyName(), Sube = sube, }; context.Departmens.Add(departman); for (int j = 0; j < 5; j++) { Ekip ekip = new Ekip() { isim = FakeData.NameData.GetCompanyName(), Departman = departman, Sube = sube }; context.Ekips.Add(ekip); } } } context.SaveChanges(); Repository <Departman> departmans = new Repository <Departman>(); Repository <Ekip> ekips = new Repository <Ekip>(); Repository <Sube> subes = new Repository <Sube>(); Kisi calisan = new Kisi() { isim = "Cihad", soyisim = "İnan", Statu = Statu.mudur, dogumTarihi = new DateTime(1994, 9, 2), maas = 4000, Departman = departmans.Find(x => x.Id == 1), Ekip = ekips.Find(x => x.Id == 1), Sube = subes.Find(x => x.Id == 1) }; context.Kisis.Add(calisan); Kisi calisan2 = new Kisi() { isim = "ebu", soyisim = "İnan", Statu = Statu.uzman, dogumTarihi = new DateTime(1994, 2, 4), maas = 4600, Departman = departmans.Find(x => x.Id == 2), Ekip = ekips.Find(x => x.Id == 2), Sube = subes.Find(x => x.Id == 2) }; context.Kisis.Add(calisan2); context.SaveChanges(); }
public void AddSube(Sube model) { repository.Insert(model); }
private void cmbSubeKodu_SelectedIndexChanged(object sender, EventArgs e) { Sube sube = (Sube)cmbSubeKodu.SelectedItem; txtSubeIsmi.Text = sube.SubeIsmi; }
public bool Delete([FromBody] Sube entity) { return(_subeRepo.Delete(entity)); }
public ActionResult UpdateSube(Sube sube) { repoSube.UpdateSube(sube); return(RedirectToAction("Index", "Sube")); }
public async Task <bool> Create([FromBody] Sube sube) { return(await _subeRepo.CreateAsync(sube)); }