public void Static_CreateOrRepo_with_invalid_ServiceProvider()
{
//arrange
//act
//assert
Assert.Throws <ArgumentNullException>(() => ServiceRepo.CreateOrRepo(null));
}
public ServiceReportControlViewModel()
{
_serviceRepo = new ServiceRepo();
Services = new ReactiveList <Service>(GetServices())
{
ChangeTrackingEnabled = true
};
RefreshCommand = ReactiveCommand.Create(Refresh);
StockCommand = ReactiveCommand.Create(Stock);
}
public ServiceHomeForm()
{
InitializeComponent();
this.Load += ServiceHomeForm_Load;
_serviceRepo = new ServiceRepo();
clientRepo = new ClientRepo();
_tokenRepo = new TokenRepo();
gvRunningTokens.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
gvUpcommingTokens.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
}
public int UpdateService(ServiceRepo s1)
{
string sqlString = "UPDATE [dbo].[ProvidedService] SET Date = @Date, Hours = @Hours, Km = @Km, Comment = @comment WHERE ID = @id";
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Date", s1.Date));
command.Parameters.Add(new SqlParameter("@Hours", s1.Hours));
command.Parameters.Add(new SqlParameter("@Km", s1.Km));
command.Parameters.Add(new SqlParameter("@id", s1.ID));
command.Parameters.Add(new SqlParameter("@comment", s1.Comment));
return(ExecuteSql(sqlString));
}
public void Static_CreateOrRepo_with_custom_ServiceProvider()
{
//arrange
var pro = new Mock <IServiceProvider>();
//act
var svcPro = ServiceRepo.CreateOrRepo(pro.Object);
//assert
Assert.NotNull(svcPro);
Assert.Same(svcPro, ServiceRepo.Instance);
}
static void Main(string[] args)
{
Console.WriteLine("Printing all Services");
using (var repo = new ServiceRepo())
{
repo.Delete(repo.GetOne(2));
foreach (Service c in repo.GetAll())
{
Console.WriteLine(c);
}
}
Console.ReadLine();
}
public int NewService(ServiceRepo s1)
{
string sqlString = "INSERT INTO ProvidedService (Employee_ID, Case_ID, Date, Hours, Km, Comment) VALUES " +
"((SELECT ID FROM Employee WHERE FirstName = @fName AND LastName = @lName)," +
" @Case_ID, @Date, @Hours, @Km, @Comment)";
string[] names = s1.EmployeeName.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries);
command.Parameters.Clear();
command.Parameters.Add(new SqlParameter("@Case_ID", s1.CaseID));
command.Parameters.Add(new SqlParameter("@Date", s1.Date));
command.Parameters.Add(new SqlParameter("@Hours", s1.Hours));
command.Parameters.Add(new SqlParameter("@Km", s1.Km));
command.Parameters.Add(new SqlParameter("@Comment", s1.Comment));
command.Parameters.Add(new SqlParameter("@fName", names[0]));
command.Parameters.Add(new SqlParameter("@lName", names[1]));
return(ExecuteSql(sqlString));
}
public IEnumerable <User> GetByCityRange(string city, int range)
{
LatLng london = new LatLng(51.509865, -0.118092);
ServiceRepo repo = new ServiceRepo();
var londonUsers = repo.GetUsersByCity(city);
var allUsers = repo.GetUsers().ToList();
for (int i = 0; i < allUsers.Count(); i++)
{
allUsers[i].Distance = Distance(london, new LatLng(allUsers[i].latitude, allUsers[i].longitude));
}
var closest = allUsers.OrderBy(x => x.Distance).Where(x => x.Distance <= range);
var results = londonUsers.Concat(closest);
return(results);
}
public void Static_CreateOrRepo_expect_override_behaviour()
{
//arrange
var pro = new Mock <IServiceProvider>();
var workflowRuntime = new Mock <IWorkflowHost <TaskRuntime> >().Object;
pro.Setup(p => p.GetService(It.Is <Type>(t => t == typeof(IWorkflowHost <TaskRuntime>)))).Returns(workflowRuntime).Verifiable();
//act
var svcPro = ServiceRepo.CreateOrRepo(pro.Object);
var svcWorkflow = ServiceRepo.Instance.GetServiceOf <IWorkflowHost <TaskRuntime> >();
var svcWorkflowAnother = ServiceRepo.Instance.GetService(typeof(IWorkflowHost <TaskRuntime>));
//assert
Assert.NotNull(svcPro);
Assert.Same(svcPro, ServiceRepo.Instance);
Assert.Same(workflowRuntime, svcWorkflow);
Assert.Same(workflowRuntime, svcWorkflowAnother);
pro.Verify(p => p.GetService(It.Is <Type>(t => t == typeof(IWorkflowHost <TaskRuntime>))),
Times.Exactly(2));
}
public MainWindow()
{
InitializeComponent();
Stopwatch stopWatch = new Stopwatch();
stopWatch.Start();
executorRepo = new ExecutorRepo();
directionsRepo = new DirectionsRepo();
serviceRepo = new ServiceRepo();
grantAgreementRepo = new GrantAgreementRepo();
historyRepo = new HistoryRepo();
stopWatch.Stop();
TimeSpan ts1 = stopWatch.Elapsed;
string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts1.Hours, ts1.Minutes, ts1.Seconds, ts1.Milliseconds);
Console.WriteLine(elapsedTime);
SetCulture();
}
public void Static_CreateOrRepo_with_valid_ServiceProvider()
{
//arrange
var pro = new Mock <IServiceProvider>();
var id = Helper.GetJobId();
var job = Helper.GetFakeJob().Object;
pro.Setup(p => p.GetService(It.Is <Type>(t => t == typeof(JobId)))).Returns(id).Verifiable();
pro.Setup(p => p.GetService(It.Is <Type>(t => t == typeof(IFakeJob)))).Returns(job).Verifiable();
//act
var svcPro = ServiceRepo.CreateOrRepo(pro.Object);
var svcId = ServiceRepo.Instance.GetServiceOf <JobId>();
var svcJob = ServiceRepo.Instance.GetServiceOf <IFakeJob>();
//assert
Assert.NotNull(svcPro);
Assert.Same(svcPro, ServiceRepo.Instance);
Assert.NotNull(svcId);
Assert.NotNull(svcJob);
Assert.Same(svcId, id);
Assert.Same(svcJob, job);
}
public ServiceManager()
{
_serviceRepo = new ServiceRepo();
}
