// GET: WorkTypes
public ActionResult Index()
{
WorkTypeRepository repo = new WorkTypeRepository(context);
List <WorkType> workTypes = repo.GetWorkTypes();
return(View(workTypes));
}
public ActionResult Index()
{
var repo = new WorkTypeRepository(_context);
var workTypes = repo.GetWorkTypes();
return(View(workTypes));
}
public async Task Work_Type_Repository_Should_Remove_Work_Type_Async()
{
// Arrange
var context = TestSetUpHelper.CreateDbContext();
var repository = new WorkTypeRepository(context);
var expectedEntity = new WorkType()
{
Id = 40,
Name = "TestName",
EstimatedTime = 1,
EstimatedCost = 100
};
await repository.AddAsync(expectedEntity);
await context.SaveChangesAsync();
// Act
await repository.RemoveAsync(expectedEntity.Id);
await context.SaveChangesAsync();
var actualEntity = await repository.GetByIdAsync(expectedEntity.Id);
// Assert
Assert.Null(actualEntity);
}
public ActionResult Edit(int?id)
{
// Kick them out if they don't offer an ID.
if (id == null)
{
return(RedirectToAction("Index"));
}
WorkDoneRepository workDoneRepo = new WorkDoneRepository();
WorkDone workDone = workDoneRepo.GetById(id.Value);
// Kick them out if the try a non-existant ID.
if (workDone == null)
{
return(RedirectToAction("Index"));
}
// Populate DropDownLists
ClientRepository clientRepo = new ClientRepository();
List <Client> clients = clientRepo.GetClients();
WorkTypeRepository workTypeRepo = new WorkTypeRepository();
List <WorkType> workTypes = workTypeRepo.GetWorkTypes();
// Bind the View Model
EditWorkDone model = new EditWorkDone(clients, workTypes);
model.Id = id.Value;
model.ClientId = workDone.ClientId;
model.WorkTypeId = workDone.WorkTypeId;
model.StartedOn = workDone.StartedOn;
model.EndedOn = workDone.EndedOn;
return(View("Edit", model));
}
public ActionResult Create(CreateWorkDone model)
{
try
{
// Get the client and work type based on values submitted from
// the form
Client client = new ClientRepository(context).GetById(model.ClientId);
WorkType workType = new WorkTypeRepository(context).GetById(model.WorkTypeId);
// Create an instance of the work done with the client and work
// type
WorkDone workDone = new WorkDone(client, workType); /////////
new WorkDoneRepository(context).Insert(workDone);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
}
// Create a view model
CreateWorkDoneView viewModel = new CreateWorkDoneView();
// Copy over the values from the values submitted
viewModel.ClientId = model.ClientId;
viewModel.StartedOn = model.StartedOn;
viewModel.WorkTypeId = model.WorkTypeId;
// Go get the value for the drop-downs, again.
viewModel.Clients = new ClientRepository(context).GetClients();
viewModel.WorkTypes = new WorkTypeRepository(context).GetWorkTypes();
return(View("Create", viewModel));
}
public LogicSystem()
{
_daySummaryRepository = new RepositoryFactory().GetDaySummaryRepository();
_employeeRepository = new RepositoryFactory().GetEmployeeRepository();
_personRepository = new RepositoryFactory().GetPersonRepository();
_workTypeRepository = new RepositoryFactory().GetWorkTypeRepository();
_dailyRecordRepository = new RepositoryFactory().GetDailyRecordRepository();
_permissionRepository = new RepositoryFactory().GetPermissionRepository();
}
public ActionResult Delete(int id, DeleteWorkType workType)
{
WorkTypeRepository repo = new WorkTypeRepository();
WorkType newWorkType = new WorkType(id, workType.Name, 0);
repo.Delete(newWorkType);
return(RedirectToAction("Index"));
}
public void Read_NotThrowsException_StateIsValid()
{
var workTypeKey = new WorkTypeTableEntity
{
WorkTypeId = Guid.Parse("00000000-4001-0000-0000-000000000000"),
};
var workTypeRepository = new WorkTypeRepository(TestEnvironment.DBSettings);
var workType = workTypeRepository.Read(workTypeKey);
Assert.IsNotNull(workType);
}
public void Update_NotThrowsException_StateIsValid()
{
var workTypeKey = new WorkTypeTableEntity
{
WorkTypeId = Guid.Parse("00000000-4001-0000-0000-000000000000"),
};
var workTypeRepository = new WorkTypeRepository(TestEnvironment.DBSettings);
var workType = workTypeRepository.Read(workTypeKey);
workType.UpdateTime = DateUtil.Now;
Assert.IsTrue(workTypeRepository.Update(workType));
}
public ActionResult Edit(int id)
{
var repo = new WorkTypeRepository(_context);
var workType = repo.GetById(id);
var formModel = new EditWorkType
{
Id = workType.Id,
Name = workType.Name,
Rate = workType.Rate
};
return(View(formModel));
}
public ActionResult Create()
{
// Populate DropDownLists
ClientRepository clientRepo = new ClientRepository();
List <Client> clients = clientRepo.GetClients();
WorkTypeRepository workTypeRepo = new WorkTypeRepository();
List <WorkType> workTypes = workTypeRepo.GetWorkTypes();
// Bind model
CreateWorkDone workDone = new CreateWorkDone(clients, workTypes);
return(View("Create", workDone));
}
public ActionResult Create()
{
var clientRepo = new ClientRepository(_context);
var clientItems = clientRepo.GetSelectListItems();
var workTypeRepo = new WorkTypeRepository(_context);
var workTypeItems = workTypeRepo.GetSelectListItems();
var formModel = new CreateWorkDone
{
ClientItems = clientItems,
WorkTypeItems = workTypeItems
};
return(View(formModel));
}
public ActionResult Create(CreateWorkType workType)
{
WorkTypeRepository repo = new WorkTypeRepository(context);
try
{
WorkType newWorkType = new WorkType(0, workType.Name, workType.Rate);
repo.Insert(newWorkType);
return(RedirectToAction("Index"));
}
catch (DbUpdateException ex)
{
HandleDbUpdateException(ex);
}
return(View("Create", workType));
}
public ActionResult Edit(EditWorkDone model)
{
if (ModelState.IsValidField("StartedOn") && ModelState.IsValidField("EndedOn"))
{
if (model.StartedOn > model.EndedOn)
{
ModelState.AddModelError("", "Start date must be before end date");
}
else
{
try
{
// Get the client and work type based on values submitted from
// the form
Client client = new ClientRepository(context).GetById(model.ClientId);
WorkType workType = new WorkTypeRepository(context).GetById(model.WorkTypeId);
// Create an instance of the work done with the client and work
// type
WorkDone workDone = new WorkDone(model.Id, client, workType, model.StartedOn, model.EndedOn);
new WorkDoneRepository(context).Update(workDone);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{ }
}
}
else
{
ModelState.AddModelError("", "Invalid date values");
}
// Create a view model
EditWorkDoneView viewModel = new EditWorkDoneView();
// Copy over the values from the values submitted
viewModel.ClientId = model.ClientId;
viewModel.StartedOn = model.StartedOn;
viewModel.EndedOn = model.EndedOn;
viewModel.WorkTypeId = model.WorkTypeId;
// Go get the value for the drop-downs, again.
viewModel.Clients = new ClientRepository(context).GetClients();
viewModel.WorkTypes = new WorkTypeRepository(context).GetWorkTypes();
return(View("Edit", viewModel));
}
public void Create_NotThrowsException_StateIsValid()
{
var now = DateUtil.Now;
var workType = new WorkTypeTableEntity
{
WorkTypeId = Guid.NewGuid(),
WorkTypeCode = new string('X', 20),
WorkTypeTree = new string('0', 8),
Name = new string('X', 256),
Description = new string('X', 1024),
SortNo = int.MaxValue,
Status = WorkTypeStatus.NORMAL.ToString(),
CreateTime = DateTimeOffset.MaxValue,
UpdateTime = DateTimeOffset.MaxValue,
};
var workTypeRepository = new WorkTypeRepository(TestEnvironment.DBSettings);
workTypeRepository.Create(workType);
}
public ActionResult Edit(int id, EditWorkType formModel)
{
var repo = new WorkTypeRepository(_context);
try
{
var newWorkType = new WorkType(id, formModel.Name, formModel.Rate);
repo.Update(newWorkType);
return(RedirectToAction("Index"));
}
catch (SqlException se)
{
if (se.Number == 2627)
{
ModelState.AddModelError("Name", "That name is already taken.");
}
}
return(View(formModel));
}
public ActionResult Edit(int?id, EditWorkType editWorkType)
{
if (!id.HasValue)
{
return(RedirectToAction("Index"));
}
WorkTypeRepository repo = new WorkTypeRepository(context);
try
{
WorkType workType = new WorkType(editWorkType.Id, editWorkType.Name, editWorkType.Rate);
repo.Update(workType);
return(RedirectToAction("Index"));
}
catch
{
}
return(View(editWorkType));
}
public ActionResult Edit(int id, EditWorkType workType)
{
WorkTypeRepository repo = new WorkTypeRepository();
try
{
WorkType newWorkType = new WorkType(id, workType.Name, workType.Rate);
repo.Update(newWorkType);
return(RedirectToAction("Index"));
}
catch (SqlException se)
{
if (se.Number == 2627)
{
ModelState.AddModelError("Name", "That name is already taken.");
}
}
return(View("Edit", workType));
}
public ActionResult Edit(int?id)
{
if (!id.HasValue)
{
return(RedirectToAction("Index"));
}
WorkTypeRepository repo = new WorkTypeRepository(context);
WorkType workType = repo.GetById((int)id);
if (workType == null)
{
return(RedirectToAction("Index"));
}
EditWorkType editWorkType = new EditWorkType();
editWorkType.Id = workType.Id;
editWorkType.Name = workType.Name;
editWorkType.Rate = workType.Rate;
return(View(editWorkType));
}
public ActionResult Edit(int id)
{
var repo = new WorkDoneRepository(_context);
var workDone = repo.GetById(id);
var clientRepo = new ClientRepository(_context);
var clientItems = clientRepo.GetSelectListItems();
var workTypeRepo = new WorkTypeRepository(_context);
var workTypeItems = clientRepo.GetSelectListItems();
var formModel = new EditWorkDone()
{
Id = id,
ClientId = workDone.ClientId,
WorkTypeId = workDone.WorkTypeId,
StartedOn = workDone.StartedOn,
EndedOn = workDone.EndedOn,
ClientItems = clientItems,
WorkTypeItems = workTypeItems
};
return(View(formModel));
}
public ActionResult Create(CreateWorkDone workDone)
{
WorkDoneRepository workDoneRepo = new WorkDoneRepository();
// Get DropDownList values
ClientRepository clientRepo = new ClientRepository();
Client client = clientRepo.GetById(workDone.ClientId);
WorkTypeRepository workTypeRepo = new WorkTypeRepository();
WorkType workType = workTypeRepo.GetById(workDone.WorkTypeId);
WorkDone newWorkDone = new WorkDone(0, client, workType, DateTimeOffset.Now);
// If it's good, submit and go back to Index.
if (ModelState.IsValid)
{
workDoneRepo.Insert(newWorkDone);
return(RedirectToAction("Index"));
}
// If it's not good, repost the page with errors.
return(View("Create", workDone));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(RedirectToAction("Index"));
}
WorkTypeRepository repo = new WorkTypeRepository();
WorkType workType = repo.GetById(id.Value);
if (workType == null)
{
return(RedirectToAction("Index"));
}
DeleteWorkType model = new DeleteWorkType();
model.Id = workType.Id;
model.Name = workType.Name;
return(View("Delete", model));
}
public async Task Work_Type_Repository_Should_Get_All_Async()
{
// Arrange
var context = TestSetUpHelper.CreateDbContext();
var repository = new WorkTypeRepository(context);
var expectedEntity = new WorkType()
{
Id = 40,
Name = "TestName",
EstimatedTime = 1,
EstimatedCost = 100
};
await repository.AddAsync(expectedEntity);
await context.SaveChangesAsync();
// Act
var entities = await repository.GetAllAsync();
// Assert
Assert.Single(entities.ToList());
}
public async Task Work_Type_Repository_Should_Update_Work_Type()
{
// Arrange
var context = TestSetUpHelper.CreateDbContext();
var repository = new WorkTypeRepository(context);
var oldUnit = new WorkType()
{
Id = 40,
Name = "TestName",
EstimatedTime = 1,
EstimatedCost = 100
};
var newUnit = new WorkType()
{
Id = 40,
Name = "TestName",
EstimatedTime = 1.5,
EstimatedCost = 150
};
await repository.AddAsync(oldUnit);
await context.SaveChangesAsync();
// Act
oldUnit.Name = newUnit.Name;
oldUnit.EstimatedCost = newUnit.EstimatedCost;
oldUnit.EstimatedTime = newUnit.EstimatedTime;
repository.Update(oldUnit);
await context.SaveChangesAsync();
// Assert
Assert.Equal(newUnit.Name, oldUnit.Name);
Assert.Equal(newUnit.EstimatedCost, oldUnit.EstimatedCost);
Assert.Equal(newUnit.EstimatedTime, oldUnit.EstimatedTime);
}
public ActionResult Edit(int id, EditWorkDone workDone)
{
WorkDoneRepository workDoneRepo = new WorkDoneRepository();
// Populate DropDowns
ClientRepository clientRepo = new ClientRepository();
Client client = clientRepo.GetById(workDone.ClientId);
WorkTypeRepository workTypeRepo = new WorkTypeRepository();
WorkType workType = workTypeRepo.GetById(workDone.WorkTypeId);
// Repopulate DropDown Lists
ClientRepository clientsRepo = new ClientRepository();
List <Client> clients = clientsRepo.GetClients();
WorkTypeRepository workTypesRepo = new WorkTypeRepository();
List <WorkType> workTypes = workTypesRepo.GetWorkTypes();
WorkDone newWorkDone = new WorkDone(id, client, workType, workDone.StartedOn, workDone.EndedOn);
// Populate View Model
EditWorkDone editWorkDone = new EditWorkDone(clients, workTypes);
editWorkDone.ClientId = workDone.ClientId;
editWorkDone.WorkTypeId = workDone.WorkTypeId;
editWorkDone.StartedOn = workDone.StartedOn;
editWorkDone.EndedOn = workDone.EndedOn;
// If it's good, submit and go back.
if (ModelState.IsValid)
{
workDoneRepo.Update(newWorkDone);
return(RedirectToAction("Index"));
}
// If it's not, show page again.
return(View("Edit", editWorkDone));
}
public IEnumerable <WorkType> GetWorkTypes()
{
IWorkTypeRepository workTypeRepository = new WorkTypeRepository(DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow));
return(workTypeRepository.GetAll().OrderBy(p => p.Sequence).ToList());
}
public WorkTypeController()
{
workTypeRepository = new WorkTypeRepository(Settings.GetStringDB());
}
