public void MaasOde(Maas m) { SqlCommand comm = new SqlCommand("Insert into MaasHareketleri(PersonelID, Donem, CalistigiGun, Hakedis, Alacak, Borc) values(@PersonelID, @Donem, @CalistigiGun, @Hakedis, @Alacak, @Borc)", conn); comm.Parameters.Add("@PersonelID", SqlDbType.Int).Value = m.PersonelID; comm.Parameters.Add("@Donem", SqlDbType.VarChar).Value = m.Donem; comm.Parameters.Add("@CalistigiGun", SqlDbType.Float).Value = m.CalistigiGun; comm.Parameters.Add("@Hakedis", SqlDbType.Float).Value = m.Hakedis; comm.Parameters.Add("@Alacak", SqlDbType.Float).Value = m.Alacak; comm.Parameters.Add("@Borc", SqlDbType.Float).Value = m.Borc; if (conn.State == ConnectionState.Closed) { conn.Open(); } try { if (Convert.ToBoolean(comm.ExecuteNonQuery())) { XtraMessageBox.Show("Seçilen personelin maaşı ödendi."); } } catch (SqlException ex) { string hata = ex.Message; } finally { conn.Close(); } }
public double CalistigiGunHesapla(Maas m) { SqlCommand comm = new SqlCommand("Select Count(Donem) from MesaiHareketleri where PersonelID=@PersonelID and Donem=@Donem", conn); comm.Parameters.Add("@PersonelID", SqlDbType.Int).Value = m._personelID; comm.Parameters.Add("@Donem", SqlDbType.VarChar).Value = m._donem; if (conn.State == ConnectionState.Closed) { conn.Open(); } CalistigiGun = Convert.ToDouble(comm.ExecuteScalar()); conn.Close(); return(CalistigiGun); }
public double SabitMaasGetir(Maas m) { SqlCommand comm = new SqlCommand("Select SabitMaas from Personel where PersonelID=@PersonelID", conn); comm.Parameters.Add("@PersonelID", SqlDbType.Int).Value = m._personelID; if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dr = comm.ExecuteReader(); dr.Read(); Personel p = new Personel(); p.SabitMaas = Convert.ToDouble(dr["SabitMaas"]); dr.Close(); conn.Close(); return(p.SabitMaas); }
private DataSet MaasHesapla(Maas m) { SqlCommand comm = new SqlCommand("Insert into MaasHareketleri(PersonelID,Donem,CalistigiGun,Hakedis,Alacak,Borc) values(@PersonelID,@Donem,@CalistigiGun,@Hakedis,@Alacak,@Borc)", conn); comm.Parameters.Add("@PersonelID", SqlDbType.Int).Value = m._personelID; comm.Parameters.Add("@Donem", SqlDbType.VarChar).Value = m._donem; comm.Parameters.Add("@CalistigiGun", SqlDbType.Float).Value = m._calistigiGun; comm.Parameters.Add("@Hakedis", SqlDbType.Money).Value = m._hakedis; comm.Parameters.Add("@Alacak", SqlDbType.Money).Value = m._alacak; comm.Parameters.Add("@Borc", SqlDbType.Money).Value = m._borc; if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); da.Fill(ds); conn.Close(); return(ds); }
public double HakedisHesapla(Maas m) { TabanMaas = (SabitMaasGetir(m) / 22) * CalistigiGunHesapla(m); SqlCommand comm = new SqlCommand("Select sum(FazlaMesai), sum(EksikMesai) from MesaiHareketleri where PersonelID=@PersonelID", conn); comm.Parameters.Add("@PersonelID", SqlDbType.Int).Value = m._personelID; comm.Parameters.Add("@Donem", SqlDbType.VarChar).Value = m._donem; if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dr = comm.ExecuteReader(); dr.Read(); FazlaMesaiSaati = Convert.ToDouble(dr[0]); FazlaMesaiUcreti = FazlaMesaiSaati * 20; CezaSaati = Convert.ToDouble(dr[1]); CezaUcreti = CezaSaati * 10; Hakedis = TabanMaas + FazlaMesaiUcreti - CezaUcreti; dr.Close(); conn.Close(); return(Hakedis); }
public void MaaslariGetir(ListView liste, ComboBox SeciliDonem, string ID) { liste.Items.Clear(); Maas m = new Maas(); m._personelID = Convert.ToInt32(ID); m._donem = SeciliDonem.SelectedItem.ToString(); string calistigiGun = CalistigiGunHesapla(m).ToString(); string hakedilen = HakedisHesapla(m).ToString(); List <int> list = EksikFazlaMesaiToplamGetir(SeciliDonem, ID); SqlCommand comm = new SqlCommand("Select p.PersonelID, PersonelAd, PersonelSoyad, mh.Donem, SabitMaas from Personel p inner join MesaiHareketleri mh on p.PersonelID = mh.PersonelID where p.silindi = 0 and Donem=@Donem and p.PersonelID=@PersonelID", conn); comm.Parameters.Add("@Donem", SqlDbType.VarChar).Value = SeciliDonem.SelectedItem.ToString(); comm.Parameters.Add("@PersonelID", SqlDbType.Int).Value = Convert.ToInt32(ID); if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlDataReader dr = comm.ExecuteReader(); if (dr.HasRows) { dr.Read(); liste.Items.Add(dr[0].ToString()); liste.Items[0].SubItems.Add(dr[1].ToString()); liste.Items[0].SubItems.Add(dr[2].ToString()); liste.Items[0].SubItems.Add(dr[3].ToString()); liste.Items[0].SubItems.Add(dr[4].ToString()); liste.Items[0].SubItems.Add(list[0].ToString()); liste.Items[0].SubItems.Add(list[1].ToString()); liste.Items[0].SubItems.Add(hakedilen); liste.Items[0].SubItems.Add(calistigiGun); } dr.Close(); conn.Close(); }