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);
}
