public static int CountTheNumberOfTicketsSoldByShowTime(string showTimesID) { string query = "Select count (id) from Ve where idLichChieu ='" + showTimesID + "' and TrangThai = 1 "; return((int)DataProvider.ExecuteScalar(query)); }
public static int CountToltalTicketByShowTime(string showTimesID) { string query = "Select count (id) from Ve where idLichChieu ='" + showTimesID + "'"; return((int)DataProvider.ExecuteScalar(query)); }