// GET api/<controller>
public IEnumerable<object> Get()
{
using (var db = new CSBCDbContext())
{
var repo = new DirectorRepository(db);
var data = repo.GetAll(1);
return data;
}
}
public void PopulateList()
{
using (var db = new CSBCDbContext())
{
var rep = new DirectorRepository(db);
var board = rep.GetAll().ToList<Director>().Where(b => b.CompanyID == 1).OrderBy(b => b.Seq);
repBoard.DataSource = board;
repBoard.DataBind();
}
}
public void GetDirectorVolunteersTest()
{
using (var db = new CSBCDbContext())
{
var rep = new DirectorRepository(db);
var records = rep.GetDirectorVolunteers(1);
Assert.IsTrue(records.Any());
foreach(vw_Directors record in records)
{
Assert.IsTrue(record.PeopleID != 0);
Assert.IsTrue(record.Name != String.Empty);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Repeater1.DataSource = DirectorRepository.GetAllDirectors();
Repeater1.DataBind();
if (Request.QueryString["ID"] != null)
{
int id = int.Parse(Request.QueryString["ID"]);
DirectorRepository.DeleteDirector(id);
Response.Redirect("ListOfDirectors.aspx");
}
}
public IActionResult Index()
{
var repository = new DirectorRepository(HttpContext.Session);
var viewModels = repository.Directors
.Select(director => new DirectorViewModel
{
Id = director.Id,
FullName = $"{director.Name}, {director.LastName}",
Age = director.BirthDate.HasValue
? director.BirthDate.Value.CalculateAge(director.Deceased).ToString()
: "Onbekend"
});
return(View(viewModels));
}
public IActionResult Update(Guid id)
{
var repository = new DirectorRepository(HttpContext.Session);
var director = repository.Get(id);
var viewModel = new DirectorUpdateViewModel
{
Name = director.Name,
LastName = director.LastName,
BirthDate = director.BirthDate ?? default,
Deceased = director.Deceased ?? default,
};
return(View(viewModel));
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
Director director = new Director();
if (btnKaydet.Text == "Güncelle")
{
director.DirectorName = txtDirectorName.Text;
int id = int.Parse(Request.QueryString["ID"]);
DirectorRepository.UpdateDirector(id, txtDirectorName.Text);
Response.Redirect("DirectorList.aspx");
}
director.DirectorName = txtDirectorName.Text;
DirectorRepository.AddDirector(director);
Response.Redirect("DirectorList.aspx");
}
public void InsertDirectorTest()
{
using (var db = new CSBCDbContext())
{
var repHouse = new HouseholdRepository(db);
var house = repHouse.Insert(new Household {CompanyID=2, Name="Frost"});
var repPeople = new PersonRepository(db);
var person = repPeople.Insert(new Person { FirstName = "Jack", LastName = "Frost", HouseID = house.HouseID });
var rep = new DirectorRepository(db);
var director = new Director{ PeopleID = person.PeopleID, CompanyID = 2, Title = "President" };
var records = rep.Insert(director);
Assert.IsTrue(records.PeopleID != 0);
Assert.IsTrue(records.Title != String.Empty);
//rep.Delete
}
}
protected void btnKaydet_Click(object sender, EventArgs e)
{
Director _director = new Director()
{
DirectorName = txtDirectorName.Text
};
if (Request.QueryString["ID"] == null)
{
DirectorRepository.AddDirector(_director);
}
else
{
_director.DirectorID = int.Parse(Request.QueryString["ID"]);
DirectorRepository.UpdateDirector(_director);
}
Response.Redirect("DirectorList.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
ddlDirector.DataSource = DirectorRepository.GetAllDirectors();
ddlDirector.DataTextField = "DirectorName";
ddlDirector.DataValueField = "DirectorID";
ddlDirector.DataBind();
ddlTypes.DataSource = TypeRepository.GetAllTypes();
ddlTypes.DataTextField = "TypeName";
ddlTypes.DataValueField = "TypeID";
ddlTypes.DataBind();
Film _film = FilmRepository.GetFilm(int.Parse(Request.QueryString["ID"]));
txtFilmDescription.Text = _film.Description;
txtFilmName.Text = _film.FilmName;
txtPublishDate.Text = _film.PublishDate.ToString();
ddlDirector.SelectedValue = _film.DirectorID.ToString();
ddlTypes.SelectedValue = _film.TypeID.ToString();
}
public IActionResult Update(Guid id, DirectorUpdateViewModel viewModel)
{
if (!TryValidateModel(viewModel))
{
return(View(viewModel));
}
var repository = new DirectorRepository(HttpContext.Session);
var director = new Person(viewModel.Name, viewModel.LastName)
{
BirthDate = viewModel.BirthDate,
Deceased = viewModel.Deceased
};
repository.Update(id, director);
return(RedirectToAction(nameof(Index)));
}
public IActionResult CreatedMovieOverview(HomeCreateMovieVm vm)
{
ActorRepository actorRepo = new ActorRepository();
DirectorRepository directorRepo = new DirectorRepository();
HomeShowMovieVM vmToShow = new HomeShowMovieVM();
Movie createdMovie = new Movie();
createdMovie.Actors = vm.ActorCheckboxes.Where(checkbox => checkbox.IsSelected)
.Select(checkbox =>
{
return(actorRepo.GetActors().FirstOrDefault(a => checkbox.ActorId == a.Id));
}).ToList();
createdMovie.Title = vm.Title;
createdMovie.Directors = new List <Director>()
{
directorRepository.GetDirectors().FirstOrDefault(d => d.Id == vm.SelectedDirector)
};
vmToShow.Movie = createdMovie;
return(View(vmToShow));
}
public async void GetAllDirectors_ReturnAllDirectors_OrderedById()
{
// Arrange
IList <Director> directors = GenerateDirectors();
var movieContextMock = new Mock <MovieContext>();
movieContextMock.Setup(d => d.Directors).ReturnsDbSet(directors);
var logger = Mock.Of <ILogger <DirectorRepository> >();
var directorRepository = new DirectorRepository(movieContextMock.Object, logger);
// Act
var allDirectors = await directorRepository.GetAllDirectors();
// Assert
Assert.Equal(3, allDirectors.Count);
Assert.Equal(1, allDirectors[0].DirectorID);
Assert.Equal(2, allDirectors[1].DirectorID);
Assert.Equal(3, allDirectors[2].DirectorID);
Assert.Equal("Kathryn Bigelow", allDirectors[0].DirectorName);
Assert.Equal("Guy Ritchie", allDirectors[1].DirectorName);
Assert.Equal("James Cameron", allDirectors[2].DirectorName);
}
public HomeController()
{
movieRepository = new MovieRepository();
actorRepository = new ActorRepository();
directorRepository = new DirectorRepository();
}
public void GetDirectorsTest()
{
var rep = new DirectorRepository(new CSBCDbContext());
var directors = rep.GetAll(1);
Assert.IsTrue(directors.Count<vw_Directors>() > 1);
}
public DirectorService(DbEntitiesContext context)
{
directorRepository = new DirectorRepository(context);
}
public DirectorAccess()
{
_directorRepository = new DirectorRepository();
}
public DirectorService()
{
_directorRepository = new DirectorRepository();
}
public DirectorService()
: base(new DbEntitiesContext())
{
directorRepository = new DirectorRepository();
}
private void LoadVolunteerList()
{
try
{
using (var db = new CSBCDbContext())
{
var rep = new DirectorRepository(db);
var directors = rep.GetDirectorVolunteers(Master.CompanyId);
var _with1 = cboBM;
_with1.DataSource = directors;
_with1.DataValueField = "PeopleID";
_with1.DataTextField = "Name";
_with1.DataBind();
_with1.Items.Insert(0, new ListItem(String.Empty, "0"));
}
}
catch (Exception ex)
{
lblError.Text = "LoadFlagged::" + ex.Message;
}
}
private void DeleteRecord(int directorId)
{
var rep = new DirectorRepository(new CSBCDbContext());
try
{
var director = rep.GetById(directorId);
rep.Delete(director); //oDirectors.DELRow(directorId, (int)Session["CompanyID"]);
}
catch (Exception ex)
{
lblError.Text = "DELRow::" + ex.Message;
}
}
private void AddRecord()
{
using (var db = new CSBCDbContext())
{
try
{
var director = new Director();
director.PeopleID = Int32.Parse(cboBM.SelectedItem.Value);
director.Title = txtTitle.Text;
if (cobPhones.Items[0].Selected == true)
director.PhonePref = "None";
if (cobPhones.Items[1].Selected == true)
director.PhonePref = "HOME";
if (cobPhones.Items[2].Selected == true)
director.PhonePref = "CELL";
if (cobPhones.Items[3].Selected == true)
director.PhonePref = "WORK";
director.CompanyID = Master.CompanyId;
director.EmailPref = (chkEmail.Checked ? 1: 0);
director.Seq = Convert.ToInt32(txtSequence.Text);
director.CreatedUser = Master.UserName;
var rep = new DirectorRepository(db);
rep.Insert(director);
}
catch (Exception ex)
{
lblError.Text = "ADDRow::" + ex.Message;
}
}
}
protected void grdBM_RowCommand(object sender, GridViewCommandEventArgs e)
{
var id = Convert.ToInt32(e.CommandArgument);
var rep = new DirectorRepository(new CSBCDbContext());
var director = rep.GetById(id);
DirectorId = id;
LoadRow(director);
}
public DirectorRepositoryTests()
{
_mockContext = new Mock <HorrorContext>();
_mockRepo = new DirectorRepository(_mockContext.Object, Mock.Of <ILogger <DirectorRepository> >());
}
private void ResetRepositories()
{
_movieRepository = null;
_directorRepository = null;
}
public void EndUp()
{
_directorRepository = null;
_directorController = null;
}
public void SetUp()
{
_fakeDirectorRepository = new FakeDirectorRepository();
_directorRepository = new DirectorRepository();
}
public AddMovieCommandHandler(ApplicationDbContext db, WriteMovieRepository movieRepository, DirectorRepository directorRepository, ChannelQueue <MovieAddedEvent> channel)
{
_db = db;
_movieRepository = movieRepository;
_directorRepository = directorRepository;
_channel = channel;
}
public List<vw_Directors> GetAllRecords()
{
var rep = new DirectorRepository(new CSBCDbContext());
return rep.GetAll(Master.CompanyId).ToList<vw_Directors>();
}
public PeopleController()
{
actorRepository = new ActorRepository();
directorRepository = new DirectorRepository();
}
private void UpdRow(long RowID)
{
using (var db = new CSBCDbContext())
{
try
{
var rep = new DirectorRepository(db);
var director = new Director();
director.PeopleID = Int32.Parse(cboBM.SelectedItem.Value.ToString());
director.Title = txtTitle.Text;
if (cobPhones.Items[0].Selected == true)
director.PhonePref = ePhoneType.NONE.ToString();
if (cobPhones.Items[1].Selected == true)
director.PhonePref = ePhoneType.HOME.ToString();
if (cobPhones.Items[2].Selected == true)
director.PhonePref = ePhoneType.CELL.ToString();
if (cobPhones.Items[3].Selected == true)
director.PhonePref = ePhoneType.WORK.ToString();
director.EmailPref = chkEmail.Checked ? 1 : 0;
director.Seq = Convert.ToInt32(txtSequence.Text);
director.CompanyID = Master.CompanyId;
director.CreatedUser = Master.UserName;
rep.Update(director);
}
catch (Exception ex)
{
lblError.Text = "UpdRow::" + ex.Message;
}
}
}
private void onOk(object sender, EventArgs e)
{
if (formValidator.Validate())
{
try
{
using (DirectorRepository repo = new DirectorRepository())
{
director = repo.SaveNew(director);
}
}
catch (BusinessEntityRepositoryException ex)
{
MessageBox.Show(this, ex.Message + ":\n\n" + ex.InnerException.Message,
"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
DialogResult = DialogResult.None;
return;
}
DialogResult = DialogResult.OK;
}
}
