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); }