public PriceSeatOfRoomType GetPriceSeatOfRoomType(MySqlDataReader reader)
{
string rtName = reader.GetString("rt_name");
string stType = reader.GetString("st_type");
double price = reader.GetDouble("price");
PriceSeatOfRoomType priceSeatOfRoomType = new PriceSeatOfRoomType(rtName, stType, price);
return(priceSeatOfRoomType);
}
private PriceSeatOfRoomType GetPriceSeatOfRoomTypeExecQuery(string query)
{
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
MySqlCommand command = new MySqlCommand(query, connection);
PriceSeatOfRoomType priceSeatOfRoomType = null;
using (reader = command.ExecuteReader())
{
while (reader.Read())
{
priceSeatOfRoomType = priceSeatOfRoomTypeDAL.GetPriceSeatOfRoomType(reader);
}
}
connection.Close();
return(priceSeatOfRoomType);
}
public void GetPriceSeatsOfRoomTypeByRTNameTest1()
{
string rtName = "3D";
List <PriceSeatOfRoomType> priceSeatsOfRoomType = priceSeatOfRoomTypeDAL.GetPriceSeatsOfRoomTypeByRTName(rtName);
query = $"select * from PriceSeatsOfRoomTypes where rt_name = '" + rtName + "' order by rand() limit 1;";
PriceSeatOfRoomType priceSeatOfRoomTypeRand = GetPriceSeatOfRoomTypeExecQuery(query);
query = $"select * from PriceSeatsOfRoomTypes where rt_name = '" + rtName + "' order by st_type asc limit 1;";
PriceSeatOfRoomType priceSeatOfRoomTypeTop = GetPriceSeatOfRoomTypeExecQuery(query);
query = $"select * from PriceSeatsOfRoomTypes where rt_name = '" + rtName + "' order by st_type desc limit 1;";
PriceSeatOfRoomType priceSeatOfRoomTypeBottom = GetPriceSeatOfRoomTypeExecQuery(query);
Assert.NotNull(priceSeatsOfRoomType);
Assert.NotNull(priceSeatOfRoomTypeRand);
Assert.NotNull(priceSeatOfRoomTypeTop);
Assert.NotNull(priceSeatOfRoomTypeBottom);
Assert.Contains(priceSeatOfRoomTypeRand, priceSeatsOfRoomType);
Assert.True(priceSeatsOfRoomType.IndexOf(priceSeatOfRoomTypeTop) == 0);
Assert.True(priceSeatsOfRoomType.IndexOf(priceSeatOfRoomTypeBottom) == (priceSeatsOfRoomType.Count - 1));
}
public double PrintTicket(ScheduleDetail sched, Schedule sche, Room room, Movie movie, PriceSeatOfRoomType psort, User user, Cinema cine, string seat)
{
string a = "";
string b = "";
int inde = (cine.CineAddress.Length) / 2;
for (int j = inde; j > 0; j--)
{
if (cine.CineAddress[j - 1] == ',')
{
a = cine.CineAddress.Substring(0, j);
b = cine.CineAddress.Substring(j + 1, cine.CineAddress.Length - inde);
break;
}
}
string price = pricevalid(psort.Price);
string[] left = { cine.CineName, a, b, cine.CinePhone,
DateTime.Now.ToString("dd/MM/yyyy") + " " + sched.SchedTimeStart?.ToString("HH:mm") +
" - " + sched.SchedTimeEnd?.ToString("HH:mm"), movie.MovieName,
psort.STType + " Ghế" + " Rạp", price + " " + seat + " " + room.RoomName,
"Gồm" + " Seat" + " Cinema", "5% VAT", DateTime.Now.ToString("HH:mm dd/MM/yyyy") + " " + user.Username };
string[] right = { cine.CineName, a, b, movie.MovieName, "Time: " + sched.SchedTimeStart?.ToString("HH:mm") +
" - " + sched.SchedTimeEnd?.ToString("HH:mm"), "Date: " + DateTime.Now.ToString("dd/MM/yyyy"),
"Hall: " + room.RoomName, "Seat: " + seat, psort.STType, "Price: " + price, DateTime.Now.ToString("HH:mm dd/MM/yyyy") };
int length = 0;
int length1 = 0;
int length2 = 0;
if ((left[2]).Length > left[5].Length)
{
length = (left[2] + left[2]).Length;
length1 = left[2].Length;
length2 = left[2].Length;
}
else if (true)
{
length = (left[5] + left[5]).Length;
length1 = left[5].Length;
length2 = left[5].Length;
}
for (int i = 0; i < length + 7; i++)
{
Console.Write("_");
}
Console.WriteLine();
for (int i = 0; i < left.Length; i++)
{
string lefti;
if (i > 5 && i < 9)
{
string[] arr = left[i].Split(" ");
Console.Write("| " + arr[0]);
for (int l = 0; l < 12 - arr[0].ToString().Length; l++)
{
Console.Write(" ");
}
Console.Write(arr[1]);
for (int j = 0; j < 7 - arr[1].ToString().Length; j++)
{
Console.Write(" ");
}
Console.Write(arr[2]);
for (int o = 0; o < length1 - 12 - 7 - arr[2].Length; o++)
{
Console.Write(" ");
}
}
else
{
lefti = "| " + left[i];
Console.Write(lefti);
for (int j = 0; j < length1 - lefti.Length + 2; j++)
{
Console.Write(" ");
}
}
string righti = " | " + right[i];
Console.Write(righti);
for (int k = 0; k < length2 - righti.Length + 3; k++)
{
Console.Write(" ");
}
Console.WriteLine(" |");
}
for (int i = 0; i < length + 7; i++)
{
Console.Write("_");
}
Console.WriteLine();
return(psort.Price);
}
