public bool MarkaEkle(Marka m) { bool Sonuc = false; SqlCommand comm = new SqlCommand("insert into Markalar (SinifID,MarkaAd, Aciklama) values (@SinifID,@MarkaAd, @Aciklama)", conn); comm.Parameters.Add("@MarkaAd", SqlDbType.VarChar).Value = m._MarkaAd; comm.Parameters.Add("@Aciklama", SqlDbType.VarChar).Value = m._Aciklama; comm.Parameters.Add("@SinifID", SqlDbType.Int).Value = m._sinifID; 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 bool MarkaGuncelle(Marka m) { bool Sonuc = false; SqlCommand comm = new SqlCommand("update Markalar set MarkaAd=@MarkaAd, Aciklama=@Aciklama,SinifID=@SinifID where MarkaID=@MarkaID", conn); comm.Parameters.Add("@MarkaID", SqlDbType.Int).Value = m._markaID; comm.Parameters.Add("@MarkaAd", SqlDbType.VarChar).Value = m._MarkaAd; comm.Parameters.Add("@Aciklama", SqlDbType.VarChar).Value = m._Aciklama; comm.Parameters.Add("@SinifID", SqlDbType.Int).Value = m._sinifID; 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); }