public void insert(baiviet bv)
{
SqlConnection con = db.Getconnect();
con.Open();
SqlCommand cmd = new SqlCommand("thembaiviet", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@newsid", System.Data.SqlDbType.Int).Value = bv.Newsid;
cmd.Parameters.Add("@cateID", System.Data.SqlDbType.Int).Value = bv.Cateid;
cmd.Parameters.Add("@title", System.Data.SqlDbType.NText).Value = bv.Title;
cmd.Parameters.Add("@username", System.Data.SqlDbType.NText).Value = bv.username;
cmd.Parameters.Add("@description", System.Data.SqlDbType.NText).Value = bv.description;
cmd.Parameters.Add("@content", System.Data.SqlDbType.NText).Value = bv.content;
cmd.Parameters.Add("@author", System.Data.SqlDbType.NText).Value = bv.author;
cmd.Parameters.Add("@picture", System.Data.SqlDbType.NText).Value = bv.picture;
cmd.Parameters.Add("@createdate", System.Data.SqlDbType.DateTime).Value = bv.createdate;
cmd.Parameters.Add("@link", System.Data.SqlDbType.NText).Value = bv.link;
cmd.Parameters.Add("@active", System.Data.SqlDbType.Int).Value = bv.active;
cmd.Parameters.Add("@views", System.Data.SqlDbType.Int).Value = bv.views;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void Them(FeedBack t)
{
SqlConnection con = db.Getconnect();
con.Open();
SqlCommand cmd = new SqlCommand("ThemFeedBack", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@newsid", SqlDbType.VarChar).Value = t.newid;
cmd.Parameters.Add("@readername", SqlDbType.NVarChar).Value = t.readername;
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = t.email;
cmd.Parameters.Add("@content", SqlDbType.NVarChar).Value = t.content;
cmd.Parameters.Add("@active", SqlDbType.Int).Value = t.active;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}