public static List <ChiPhiModel> getAll()
{
List <ChiPhiModel> list = new List <ChiPhiModel>();
string cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnstring);
cnn.Open();
string sql = "SELECT * FROM tour_chiphi";
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.HasRows)
{
while (reader.Read())
{
ChiPhiModel chiphi = new ChiPhiModel();
chiphi.chiphi_id = reader.GetInt32(0);
chiphi.doan_id = reader.GetInt32(1);
chiphi.chiphi_total = reader.GetDecimal(2);
chiphi.chiphi_chitiet = reader.GetString(3);
list.Add(chiphi);
}
reader.NextResult();
}
return(list);
}
public static void Insert(ChiPhiModel chiphi)
{
string cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnstring);
cnn.Open();
string sql = "INSERT INTO tour_chiphi(doan_id, chiphi_total, chiphi_chitiet) VALUES @doanid, @total, @chitiet";
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.Parameters.AddWithValue("@doanid", chiphi.doan_id);
cmd.Parameters.AddWithValue("@total", chiphi.chiphi_total);
cmd.Parameters.AddWithValue("@chitiet", chiphi.chiphi_chitiet);
cmd.ExecuteNonQuery();
}
public static void Update(ChiPhiModel chiphi)
{
string cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnstring);
cnn.Open();
string sql = "UPDATE tour_chiphi SET doan_id = @doanid, chiphi_total = @total, chiphi_chitiet = @chitiet WHERE chiphi_id = @id";
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.Parameters.AddWithValue("@id", chiphi.chiphi_id);
cmd.Parameters.AddWithValue("@doanid", chiphi.doan_id);
cmd.Parameters.AddWithValue("@total", chiphi.chiphi_total);
cmd.Parameters.AddWithValue("@chitiet", chiphi.chiphi_chitiet);
cmd.ExecuteNonQuery();
}
public static ChiPhiModel getDetail(int id)
{
ChiPhiModel chiphi = new ChiPhiModel();
string cnnstring = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection cnn = new SqlConnection(cnnstring);
cnn.Open();
string sql = "SELECT * FROM tour_chiphi WHERE chiphi_id=id";
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
chiphi.chiphi_id = reader.GetInt32(0);
chiphi.doan_id = reader.GetInt32(1);
chiphi.chiphi_total = reader.GetDecimal(2);
chiphi.chiphi_chitiet = reader.GetString(3);
}
return(chiphi);
}