private void GuncelYil_SelectedIndexChanged(object sender, EventArgs e) { ToplamMesai(GuncelYil.Text); Ay.Items.Clear(); Ay.Text = null; int deneme = int.Parse(GuncelYil.SelectedItem.ToString()); var item = Adibahce.Shift.Where(x => x.Yil_ID == deneme).ToList(); Yil.DataSource = item; Yil.Refresh(); var query = Adibahce.Shift.Where(x => x.Yil_ID == deneme).Select(x => x.Ay_ID).Distinct(); foreach (var model in query) { Ay.Items.Add(model); } #region Ozet var model1 = Adibahce.Personel.Select(x => new { İsim = x.PersonelAdSoyad, Maaş = x.PersonelMaas, SaatÜcreti = x.PersonelMaas / 300, GüncelMesaiSaati = x.PersonelMesaiSaat, GüncelTutar = (x.PersonelMaas / 300) * x.PersonelMesaiSaat }).ToList(); Ozet.DataSource = model1; Ozet.Refresh(); #endregion }
public void Yenile() { #region PersonelComboBoxYenile PersonelCbx.Items.Clear(); var combobox = Adibahce.Personel.Select(x => x.PersonelAdSoyad); foreach (var query in combobox) { PersonelCbx.Items.Add(query); } #endregion #region YılTarihiYenile GuncelYil.Items.Clear(); var deneme = Adibahce.Shift.Select(x => new { x.Yil_ID }).Distinct(); foreach (var model in deneme) { GuncelYil.Items.Add(model.Yil_ID); } #endregion #region DataGridViewYenile var item = Adibahce.Shift.Where(x => x.Ay_ID == DateTime.Now.Month).ToList(); Yil.DataSource = item; Yil.Refresh(); #endregion #region Ozet var model1 = Adibahce.Personel.Select(x => new { İsim = x.PersonelAdSoyad, Maaş = x.PersonelMaas, SaatÜcreti = x.PersonelMaas / 300, GüncelMesaiSaati = x.PersonelMesaiSaat, GüncelTutar = (x.PersonelMaas / 300) * x.PersonelMesaiSaat }).ToList(); Ozet.DataSource = model1; Ozet.Refresh(); #endregion }
private void Ay_SelectedIndexChanged(object sender, EventArgs e) { ToplamMesai(Ay.Text); Gun.Items.Clear(); int a = int.Parse(Ay.SelectedItem.ToString()); if (PersonelCbx.SelectedItem == null) { var item = Adibahce.Shift.Where(x => x.Ay_ID == a).ToList(); Yil.DataSource = item; Yil.Refresh(); } else { var item = Adibahce.Shift.Where(x => x.PersonelAdSoyad == PersonelCbx.SelectedItem.ToString()).Where(x => x.Ay_ID == a).ToList(); Yil.DataSource = item; Yil.Refresh(); } #region Ozet var model1 = Adibahce.Personel.Select(x => new { İsim = x.PersonelAdSoyad, Maaş = x.PersonelMaas, SaatÜcreti = x.PersonelMaas / 300, GüncelMesaiSaati = x.PersonelMesaiSaat, GüncelTutar = (x.PersonelMaas / 300) * x.PersonelMesaiSaat }).ToList(); Ozet.DataSource = model1; Ozet.Refresh(); #endregion int yiltext = int.Parse(GuncelYil.Text); int aytext = int.Parse(Ay.Text); var deneme = Adibahce.Shift.Where(x => x.Yil_ID == yiltext && x.Ay_ID == aytext).Select(x => x.Gun_ID).Distinct().ToList(); foreach (var item in deneme) { Gun.Items.Add(item); } }