public IEnumerable<Passenger> GetPassengerDetail(string mobile_number) { DAL dal = new DAL(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "GetPassengerDetail"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mobile_number", mobile_number); DataTable dt = dal.Execute(cmd); List<Passenger> passengers = new List<Passenger>(); foreach (DataRow dr in dt.Rows) { Passenger passenger = new Passenger { passenger_id = Int64.Parse(dr["passenger_id"].ToString()), passenger_name = dr["passenger_name"].ToString(), mobile_number = dr["mobile_number"].ToString(), email_address = dr["email_address"].ToString() }; passengers.Add(passenger); } return passengers; }
public Passenger AddPassenger(Passenger item) { DAL dal = new DAL(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SavePassenger"; cmd.Parameters.AddWithValue("@mobile_number", item.mobile_number); cmd.Parameters.AddWithValue("@email_address", item.email_address); cmd.Parameters.AddWithValue("@passenger_name", item.passenger_name); int ticketsAdded = dal.ExecuteProcNonQuery(cmd); return item; }
public Passenger AddPassenger(Passenger item) { return repository.AddPassenger(item); }