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(); }