public ScreeningModel GetScreeningById(string screening_id)
{
string queryString = "select * from screening where screening_id=@screening_id";
var result = new ScreeningModel();
using (MySqlConnection conn = new MySqlConnection(connectionstring))
{
conn.Open();
using (MySqlCommand cmd = new MySqlCommand(queryString, conn))
{
cmd.Parameters.Add(new MySqlParameter("@screening_id", screening_id));
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
result = new ScreeningModel()
{
screening_id = reader.GetString("screening_id"),
film_id = reader.GetString("film_id"),
start_time = reader.GetDateTime("start_time"),
hall_id = reader.GetString("hall_id"),
};
}
reader.Close();
}
conn.Close();
}
return(result);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
Button button = (Button)e.OriginalSource;
ScreeningModel screening = model.screenings.Find(x => x.time.ToString() == button.Content.ToString());
this.Frame.Navigate(typeof(WebViewPage), ReserveLinkCreator.MakeReserveUri(screening.time, screening.hall));
}
public ActionResult Screening(ScreeningModel model)
{
if (ModelState.IsValid)
{
var screening = new ProviderApplicationScreeningDTO();
screening.ProviderApplicationId = Convert.ToInt32(Session["ProviderApplicationId"]);
screening.ActiveSchoolReadinessContract = model.ActiveSchoolReadinessContract == "Yes";
screening.AllInstructorsHaveAgreed = model.AllInstructorsHaveAgreed == "Yes";
screening.AttendingCount = model.AttendingCount;
screening.BirthTo5YearOldReadinessCount = model.BirthTo5YearOldReadinessCount;
var errorMessages = this._providerApplicationService.ScreenProviderApplication(screening);
model.ErrorMessages = errorMessages;
if (string.IsNullOrEmpty(errorMessages))
{
return(View("Eligible"));
}
return(View("NotEligible", model));
}
return(View("Screening", model));
}
public List <SqlParameter> BuildSqlParameters(ScreeningModel screening)
{
List <SqlParameter> procParams = new List <SqlParameter>
{
new SqlParameter("ContactID", screening.ContactID),
new SqlParameter("InitialContactDate", screening.InitialContactDate),
new SqlParameter("InitialServiceCoordinatorID",
screening.InitialServiceCoordinatorID ?? (object)DBNull.Value),
new SqlParameter("PrimaryServiceCoordinatorID",
screening.PrimaryServiceCoordinatorID ?? (object)DBNull.Value),
new SqlParameter("ScreeningDate", screening.ScreeningDate),
new SqlParameter("ScreeningTypeID", screening.ScreeningTypeID ?? (object)DBNull.Value),
new SqlParameter("AssessmentID", screening.AssessmentID ?? (object)DBNull.Value),
new SqlParameter("ScreeningScore", screening.ScreeningScore ?? (object)DBNull.Value),
new SqlParameter("ScreeningResultID", screening.ScreeningResultsID ?? (object)DBNull.Value),
new SqlParameter("ScreeningStatusID", screening.ScreeningStatusID ?? (object)DBNull.Value)
};
if (screening.ScreeningID <= 0)
{
procParams.Insert(1, new SqlParameter("ProgramID", screening.ProgramID));
}
else
{
procParams.Insert(0, new SqlParameter("ScreeningID", screening.ScreeningID));
procParams.Add(new SqlParameter("SubmittedByID", screening.SubmittedByID ?? (object)DBNull.Value));
}
procParams.Add(new SqlParameter("ResponseID", screening.ResponseID.GetValueOrDefault(0) <= 0 ? (object)DBNull.Value : screening.ResponseID));
procParams.Add(new SqlParameter("ModifiedOn", screening.ModifiedOn ?? DateTime.Now));
return(procParams);
}
public Response <ScreeningModel> UpdateScreening(ScreeningModel screening)
{
var screeningRepository = _unitOfWork.GetRepository <ScreeningModel>(SchemaName.ECI);
List <SqlParameter> procParams = BuildSqlParameters(screening);
Response <ScreeningModel> spResults = new Response <ScreeningModel>();
using (var transactionScope = _unitOfWork.BeginTransactionScope())
{
try
{
spResults = screeningRepository.ExecuteNQStoredProc("usp_UpdateScreening", procParams);
if (spResults.ResultCode != 0)
{
spResults.ResultCode = spResults.ResultCode;
spResults.ResultMessage = spResults.ResultMessage;
}
if (!screening.ForceRollback.GetValueOrDefault(false))
{
_unitOfWork.TransactionScopeComplete(transactionScope);
}
}
catch (Exception ex)
{
_logger.Error(ex);
spResults.ResultCode = -1;
spResults.ResultMessage = "An unexpected error has occurred!";
}
}
return(spResults);
}
public async Task <IActionResult> Edit(int?id)
{
if (id != null)
{
Screening screening = await db.Screenings.FirstOrDefaultAsync(p => p.ScreeningId == id);
if (screening != null)
{
var vm = new ScreeningModel();
vm.Movies = db.Movies
.Select(a => new SelectListItem()
{
Value = a.MovieId.ToString(),
Text = a.Title
})
.ToList();
vm.Audithoriums = db.Audithoria
.Select(a => new SelectListItem()
{
Value = a.AudithoriumId.ToString(),
Text = a.Name
})
.ToList();
ViewBag.vm = vm.Movies;
ViewBag.vm1 = vm.Audithoriums;
return(View(screening));
}
}
return(NotFound());
}
public void DeleteScreening(ScreeningModel screening)
{
connection.Open();
SqlCommand command = new SqlCommand("DELETE FROM Screening WHERE Id = @Id", connection);
command.Parameters.AddWithValue("@Id", screening.Id);
command.ExecuteNonQuery();
connection.Close();
}
public void Should_ReturnAnScreening_WhenGettingAScreeningById()
{
//Arrange
//Id = 1012
//Act
ScreeningModel screening = screeningLogic.GetScreeningById(1012);
//Assert
Assert.True(screening.Id == 1012);
}
public void AddScreening(ScreeningModel screening)
{
screeningsTemp.Add(new ScreeningDto
{
Id = screening.Id,
MovieId = screening.MovieId,
HallId = screening.HallId,
DateOfScreening = screening.DateOfScreening,
TimeOfScreening = screening.TimeOfScreening
});
}
public void Should_ReturnAScreening_WhenGettingAScreeningById()
{
//Arrange
screeningLogic.AddScreening(new ScreeningModel {
Id = 5, DateOfScreening = DateTime.Today.AddYears(102)
});
//Act
ScreeningModel screening = screeningLogic.GetScreeningById(5);
//Assert
Assert.True(screening.Id == 5 && screening.DateOfScreening == DateTime.Today.AddYears(102));
}
public void Should_EditAnScreening_WhenEditingAScreening()
{
//Arrange
ScreeningModel screening = new ScreeningModel {
Id = 1, DateOfScreening = DateTime.Today.AddYears(101)
};
//Act
screeningLogic.EditScreening(screening);
//Assert
Assert.True(screeningLogic.GetScreenings()[0].DateOfScreening == DateTime.Today.AddYears(101));
}
public void Should_AddAnScreening_WhenAddingAScreening()
{
//Arrange
ScreeningModel screening = new ScreeningModel {
Id = 10, DateOfScreening = DateTime.Today.AddYears(100)
};
//Act
screeningLogic.AddScreening(screening);
//Assert
Assert.True(screeningLogic.GetScreeningById(10).DateOfScreening == DateTime.Today.AddYears(100));
}
public void AddScreening(ScreeningModel screening)
{
connection.Open();
SqlCommand command = new SqlCommand("INSERT INTO Screening OUTPUT Inserted.Id VALUES (@IdMovie, @IdHall, @DateOfScreening, @TimeOfScreening)", connection);
command.Parameters.AddWithValue("@IdMovie", screening.MovieId);
command.Parameters.AddWithValue("@IdHall", screening.HallId);
command.Parameters.AddWithValue("@DateOfScreening", screening.DateOfScreening);
command.Parameters.AddWithValue("@TimeOfScreening", screening.TimeOfScreening);
//MovieModel newMovie = new MovieModel(((int)command.ExecuteScalar()), screening.Id, screening.MovieId);
command.ExecuteScalar();
connection.Close();
}
public void AddScreening(ScreeningModel screening)
{
using (SqlConnection conn = new SqlConnection(_connection.connectionString))
{
conn.Open();
SqlCommand command = new SqlCommand("INSERT INTO Screening VALUES (@IdMovie, @IdHall, @DateOfScreening, @TimeOfScreening)", conn);
command.Parameters.AddWithValue("@IdMovie", screening.MovieId);
command.Parameters.AddWithValue("@IdHall", screening.HallId);
command.Parameters.AddWithValue("@DateOfScreening", screening.DateOfScreening);
command.Parameters.AddWithValue("@TimeOfScreening", screening.TimeOfScreening);
command.ExecuteScalar();
}
}
public void EditScreening(ScreeningModel screening)
{
using (SqlConnection conn = new SqlConnection(_connection.connectionString))
{
conn.Open();
SqlCommand command = new SqlCommand(@"UPDATE Screening SET IdMovie = @IdMovie, IdHall = @IdHall, DateOfScreening = @DateOfScreening,
TimeOfScreening = @TimeOfScreening WHERE Id = @Id", conn);
command.Parameters.AddWithValue("@Id", screening.Id);
command.Parameters.AddWithValue("@IdMovie", screening.MovieId);
command.Parameters.AddWithValue("@IdHall", screening.HallId);
command.Parameters.AddWithValue("@DateOfScreening", screening.DateOfScreening);
command.Parameters.AddWithValue("@TimeOfScreening", screening.TimeOfScreening);
command.ExecuteNonQuery();
}
}
public IHttpActionResult PostScreening(ScreeningPostModel screeningModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var film = db.Films.Find(screeningModel.Film);
var screen = db.Screens.Find(screeningModel.Screen);
var screening = new Screening(screen, screeningModel.Date, film);
db.Screenings.Add(screening);
db.SaveChanges();
var screeningModelToReturn = new ScreeningModel(screening);
return(CreatedAtRoute("DefaultApi", new { id = screening.Id }, screeningModelToReturn));
}
//other things
//List
//Add
//details
//Edit
//Delete
public List <ScreeningModel> GetScreenings()
{
//using ASPNETCinema.Models; added
Screenings = new List <ScreeningModel>();
connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM Screening", connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ScreeningModel screening = new ScreeningModel(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3), reader.GetTimeSpan(4));
Screenings.Add(screening);
}
}
connection.Close();
return(Screenings);
}
public void Should_GetScreeningsFromTheList_WhenGettingScreenings()
{
//Arrange
ScreeningModel screening = new ScreeningModel {
Id = 10, DateOfScreening = DateTime.Today.AddYears(103)
};
screeningLogic.AddScreening(screening);
bool found = false;
//Act
if (screeningLogic.GetScreenings()[4].Id == 10 && screeningLogic.GetScreenings()[4].DateOfScreening == DateTime.Today.AddYears(103))
{
found = true;
}
//Assert
Assert.True(found);
}
public async Task <IActionResult> Create()
{
var vm = new ScreeningModel();
vm.Movies = db.Movies
.Select(a => new SelectListItem()
{
Value = a.MovieId.ToString(),
Text = a.Title
})
.ToList();
vm.Audithoriums = db.Audithoria
.Select(a => new SelectListItem()
{
Value = a.AudithoriumId.ToString(),
Text = a.Name
})
.ToList();
ViewBag.vm = vm.Movies;
ViewBag.vm1 = vm.Audithoriums;
return(View());
}
public static ScreeningModel ToModel(this ScreeningViewModel model)
{
if (model == null)
{
return(null);
}
var result = new ScreeningModel
{
ContactID = model.ContactID,
ScreeningID = model.ScreeningID,
ProgramID = model.ProgramID,
ProgramName = model.ProgramName,
InitialContactDate = model.InitialContactDate,
InitialServiceCoordinatorID = model.InitialServiceCoordinatorID,
InitialServiceCoordinator = model.InitialServiceCoordinator,
PrimaryServiceCoordinatorID = model.PrimaryServiceCoordinatorID,
PrimaryServiceCoordinator = model.PrimaryServiceCoordinator,
ScreeningDate = model.ScreeningDate,
ScreeningTypeID = model.ScreeningTypeID,
ScreeningType = model.ScreeningType,
AssessmentID = model.AssessmentID,
AssessmentName = model.AssessmentName,
ScreeningResultsID = model.ScreeningResultsID,
ScreeningResult = model.ScreeningResult,
ScreeningScore = model.ScreeningScore,
ScreeningStatusID = model.ScreeningStatusID,
ScreeningStatus = model.ScreeningStatus,
SubmittedByID = model.SubmittedByID,
SubmittedBy = model.SubmittedBy,
ResponseID = model.ResponseID ?? 0,
SectionID = model.SectionID ?? 0,
ModifiedOn = model.ModifiedOn
};
return(result);
}
public void EditScreening(ScreeningModel screening)
{
_context.EditScreening(screening);
}
public bool IsItAfterOrBeforeTheScreening(TimeSpan timeOfScreening, int movieId, ScreeningModel screeningDatabase)
{
foreach (var movieAlreadyScreening in Repository.GetMovies())
{
if (movieAlreadyScreening.Id == screeningDatabase.MovieId)
{
TimeSpan lenghtScreening = new TimeSpan(0, Int32.Parse(movieAlreadyScreening.MovieLenght), 0);
TimeSpan lenghtMovie = new TimeSpan(0, Int32.Parse(Repository.GetMovie(movieId).MovieLenght), 0);
if ((timeOfScreening > screeningDatabase.TimeOfScreening && timeOfScreening > screeningDatabase.TimeOfScreening.Add(lenghtScreening)) ||
(timeOfScreening < screeningDatabase.TimeOfScreening && timeOfScreening.Add(lenghtMovie) < screeningDatabase.TimeOfScreening))
{
return(true);
}
return(false);
}
}
return(true);
}
public IHttpActionResult UpdateScreening(ScreeningModel screening)
{
return(new HttpResult <Response <ScreeningModel> >(_eciRuleEngine.UpdateScreening(screening), Request));
}
public Response <ScreeningModel> UpdateScreening(ScreeningModel screeningModel)
{
return(_ScreeningService.UpdateScreening(screeningModel));
}
public Response <ScreeningModel> AddScreening(ScreeningModel screening)
{
return(_ScreeningService.AddScreening(screening));
}
public void AddScreening(ScreeningModel screening)
{
Repository.AddScreening(screening);
}
public void EditScreening(ScreeningModel screening)
{
Repository.EditScreening(screening);
}
public IHttpActionResult UpdateScreening(ScreeningModel eciScreening)
{
return(new HttpResult <Response <ScreeningModel> >(_eciDataProvider.UpdateScreening(eciScreening), Request));
}
public void EditScreening(ScreeningModel screening)
{
edit = screening.Id;
editDate = screening.DateOfScreening;
}
public void AddScreening(ScreeningModel screening)
{
_context.AddScreening(screening);
}
