public bool PrimEkle(Prim p)
{
bool Sonuc = false;
SqlCommand comm = new SqlCommand("Insert into Primler (PersonelID,PrimTutar,Donem) values(@PersonelID,@Tutar,@Donem)", conn);
comm.Parameters.Add("@PersonelID", SqlDbType.Int).Value = p._personelID;
comm.Parameters.Add("@Tutar", SqlDbType.Float).Value = p._primTutar;
comm.Parameters.Add("@Donem", SqlDbType.VarChar).Value = p._donem;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
try
{
Sonuc = Convert.ToBoolean(comm.ExecuteNonQuery());
}
catch (SqlException ex)
{
string hata = ex.Message;
}
finally { conn.Close(); }
return(Sonuc);
}
public Prim PrimleriGetir(int ID, Prim p)
{
SqlCommand comm = new SqlCommand("Select pr.PersonelID, PersonelAd, PersonelSoyad,PrimTutar,Donem from Personel p inner join Primler pr on p.PersonelID=pr.PersonelID where pr.Silindi=0 and PrimID=@ID", conn);
comm.Parameters.Add("@ID", SqlDbType.Int).Value = ID;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataReader dr = comm.ExecuteReader();
if (dr.Read())
{
p.PersonelID = Convert.ToInt32(dr[0]);
p.PersonelAd = dr[1].ToString();
p.PersonelSoyad = dr[2].ToString();
p.PrimTutar = Convert.ToDouble(dr[3]);
p.Donem = dr[4].ToString();
}
dr.Close();
conn.Close();
return(p);
}