public static List <LoaiChiPhiModel> getAll()
{
List <LoaiChiPhiModel> list = new List <LoaiChiPhiModel>();
string cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnstring);
cnn.Open();
string sql = "SELECT * FROM tour_loaichiphi";
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.HasRows)
{
while (reader.Read())
{
LoaiChiPhiModel cp = new LoaiChiPhiModel();
cp.cp_id = reader.GetInt32(0);
cp.cp_ten = reader.GetString(1);
cp.cp_mota = reader.GetString(2);
list.Add(cp);
}
reader.NextResult();
}
return(list);
}
public static void Insert(LoaiChiPhiModel cp)
{
string cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnstring);
cnn.Open();
string sql = "INSERT INTO tour_loaichiphi(cp_ten, cp_mota) VALUES @ten, @mota";
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.Parameters.AddWithValue("@ten", cp.cp_ten);
cmd.Parameters.AddWithValue("@mota", cp.cp_mota);
cmd.ExecuteNonQuery();
}
public static void Update(LoaiChiPhiModel cp)
{
string cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnstring);
cnn.Open();
string sql = "UPDATE tour_loaichiphi SET cp_ten = @ten, cp_mota = @mota WHERE cp_id = @id";
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.Parameters.AddWithValue("@id", cp.cp_id);
cmd.Parameters.AddWithValue("@doanid", cp.cp_ten);
cmd.Parameters.AddWithValue("@dsnv", cp.cp_mota);
cmd.ExecuteNonQuery();
}