public ActionResult BuyTicket(TicketsSale item)
{
Manager manager = new Manager();
manager.SetSoldItems(item);
return(RedirectToAction("Tickets"));
}
public TicketsSale GetByID(int ID)
{
string commandStr = $"{selectCommandStr} WHERE ID = {ID}";
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(commandStr, connection))
{
connection.Open();
TicketsSale item = new TicketsSale();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
item.ID = ID;
item.MovieName = Convert.ToString(reader["MovieName"]);
item.Price = Convert.ToDecimal(reader["Price"]);
item.Quantity = Convert.ToInt32(reader["Quantity"]);
item.TotalAmount = item.Price * item.Quantity;
}
return(item);
}
}
}
public ActionResult BuyTicketModal(int id)
{
Manager manager = new Manager();
TicketsSale item = manager.GetByID(id);
return(PartialView("~/Views/Shared/_BuyTicket.cshtml", item));
}
public void SetSoldItems(TicketsSale item)
{
string commandStr = $@"
INSERT
INTO SoldTickets(MovieID, Quantity, Amount, FirstName, PhoneNumber, eMail, CardNumber, Comments)
VALUES
(
'{item.ID}',
'{item.Quantity}',
'{item.TotalAmount}',
'{item.FirstName}',
'{item.PhoneNumber}',
'{item.eMail}',
'{item.CardNumber}',
'{item.Comments}'
)" ;
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(commandStr, connection))
{
connection.Open();
command.ExecuteNonQuery();
}
}
}
public decimal TotalAmount(int id, int selectedVal)
{
Manager manager = new Manager();
TicketsSale item = manager.GetByID(id);
decimal amount = item.Price * selectedVal;
return(amount);
}
