public async Task <IActionResult> GetAllAssignments() { using (SqlConnection con = new SqlConnection(ConnectionString)) { con.Open(); try { Assignments rets = await TempWorksAPI.SearchAssignmentFromTempworksAsync(); foreach (Assignment ass in rets.data) { DataLayer.TempWorks.AddAssignmentProc(con, ass); if (ass.jobOrderId != 0) { WorkSite site = await TempWorksAPI.GetWorksiteFromTempworksAsync(ass.jobOrderId); DataLayer.TempWorks.AddWorkSiteProc(con, site, DataLayer.TempWorks.AddAddressProc(con, site.address)); } } } catch (Exception ex) { _context.SaveErrorProc(con, "Error in employees", ex.Message); return(BadRequest(ex.Message)); } } return(Ok("Success")); }
public static bool AddWorkSiteProc(SqlConnection con, WorkSite model, int addressID) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.Parameters.Add(new SqlParameter("@WorkSiteId", model.worksiteId)); cmd.Parameters.Add(new SqlParameter("@WorkSiteName", model.worksiteName)); cmd.Parameters.Add(new SqlParameter("@isActive", model.isActive)); cmd.Parameters.Add(new SqlParameter("@CustomerId", model.customerId)); cmd.Parameters.Add(new SqlParameter("@DepartmentName", model.departmentName)); cmd.Parameters.Add(new SqlParameter("@AddressID", addressID)); cmd.Parameters.Add(new SqlParameter("@Directions", model.directions)); cmd.Parameters.Add(new SqlParameter("@DressCode", model.dressCode)); cmd.Parameters.Add(new SqlParameter("@TimeClockTimeZoneId", model.timeClockTimeZoneId)); cmd.Parameters.Add(new SqlParameter("@isDaylightSavingsTimeObserved", model.isDaylightSavingsTimeObserved)); cmd.Parameters.Add(new SqlParameter("@isPublicTransportationAccessible", model.isPublicTransportationAccessible)); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "prAddWOrkSite"; int count = cmd.ExecuteNonQuery(); } return(true); }
public HttpResponseMessage InsertWorkSite(int workSiteId, string workSiteName, string com, string comBoss, string workManage, string remark) { using (WorkDataClassesDataContext db = new WorkDataClassesDataContext()) { WorkSite wt = new WorkSite { WorkSiteId = workSiteId, WorkSiteName = workSiteName, Company = com, CompanyBoss = comBoss, WorkManage = workManage, Remark = remark }; int wCnt = db.WorkSite.Where(n => n.WorkSiteId == wt.WorkSiteId).Count(); string json; if (wCnt == 0) { db.WorkSite.InsertOnSubmit(wt); db.SubmitChanges(); json = "ok"; } else { json = "error"; } json = JsonConvert.SerializeObject(json); return(HttpResponseMessageToJson.ToJson(json)); } }
public void WorkSite_PublicProperties() { var workSiteTypeId = 36; var workSiteType = new Response { Id = workSiteTypeId }; var name = "Worksite Name"; var address = new Address(); var sca = true; var federalContractWorkPerformed = true; var numEmployees = 5; var employees = new List <Employee>(); var model = new WorkSite { WorkSiteTypeId = workSiteTypeId, WorkSiteType = workSiteType, Name = name, Address = address, SCA = sca, FederalContractWorkPerformed = federalContractWorkPerformed, NumEmployees = numEmployees, Employees = employees }; Assert.AreEqual(workSiteTypeId, model.WorkSiteTypeId); Assert.AreEqual(workSiteType, model.WorkSiteType); Assert.AreEqual(name, model.Name); Assert.AreEqual(address, model.Address); Assert.AreEqual(sca, model.SCA); Assert.AreEqual(federalContractWorkPerformed, model.FederalContractWorkPerformed); Assert.AreEqual(numEmployees, model.NumEmployees); Assert.AreEqual(employees, model.Employees); }
public void MoveWorkers() { WorkSite other = worksite.type == WorkSite.Farm ? WorkSite.Pyramid : WorkSite.Farm; if (value < worksite.workers.Count) { for (int i = 0; i < (worksite.workers.Count - value); i++) { worksite.workers[i].MoveToSite(other); } } else if (value > worksite.workers.Count) { Site otherSite = Site.Create(other); for (int i = 0; i < value; i++) { try { otherSite.workers[i].MoveToSite(worksite.type); } catch (System.ArgumentOutOfRangeException) { ; } } } }
private void Initialize() { ResGovernmentAnnouncementLink resGovernmentAnnouncementLink = new ResGovernmentAnnouncementLink(); ResAnnouncement resAnnouncement = new ResAnnouncement(); WorkSite announcementWorkSite = new WorkSite(); WM_GetGovernmentAnnouncementInfo wm_GetGovernmentAnnouncementInfo = new WM_GetGovernmentAnnouncementInfo(); announcementWorkSite.SetOrReplaceWorkSiteInput(resGovernmentAnnouncementLink) .SetOrReplaceWorkSiteOutput(resAnnouncement) .SetOrReplaceWorkMachine(wm_GetGovernmentAnnouncementInfo); announcementWorkSite.AddResourceEventHandler(resAnnouncement); announcementWorkSite.Status = WorkSiteStatus.Executable; AddWorkSite(announcementWorkSite); Status = WorkPipelineStatus.Executable; }
public static Site Create(WorkSite worksite) { switch (worksite) { case WorkSite.Farm: return(GameObject.Find("Farm").GetComponent <Farm>()); case WorkSite.Pyramid: return(GameObject.Find("Pyramid").GetComponent <Pyramid>()); case WorkSite.Settlement: return(GameObject.Find("Settlement").GetComponent <Settlement>()); default: return(null); } }
public void MoveToSite(WorkSite site, Vector2?altPosition = null) { if (this.site != site) { lastSite = this.site; Site.Create(this.site).Unregister(this); Site.Create(site).Register(this); } this.site = site; if (altPosition.HasValue) { SetTargetPosition(altPosition.Value); } else { SetTargetPosition(Site.Create(site).GetRandomPosition()); } }
public static async System.Threading.Tasks.Task <WorkSite> GetWorksiteFromTempworksAsync(int id) { using (HttpClient client = new HttpClient()) { // Call asynchronous network methods in a try/catch block to handle exceptions client.DefaultRequestHeaders.Add("x-tw-token", APIKey); var result = await client.GetAsync("https://api.ontempworks.com/JobOrders/" + id.ToString() + "/Worksite"); //if(result.StatusCode!=System.Net.HttpStatusCode.OK) //throw new Exception(result.Content.) //string contnet = await result.Content.ReadAsStringAsync(); WorkSite ret = await result.Content.ReadFromJsonAsync <WorkSite>(); // Above three lines can be replaced with new helper method below // string responseBody = await client.GetStringAsync(uri); return(ret); } }
public async Task <IActionResult> AddAssignments([FromBody] Assignments models) { string conStr = "Server=employnetdata.database.windows.net;Database=DataSurf;Trusted_Connection=false;User Id=employnet;password=Employ1Now!"; using (SqlConnection con = new SqlConnection(conStr)) { try { con.Open(); if (models.data == null || models.data.Count() == 0) { _context.SaveError("Nothing to process, end of asssignments", ""); return(Ok("success")); } int start = models.data[0].assignmentId; _context.SaveError("Add Bulk Assignment", "Total " + models.data.Count() + " records, starting at id " + start.ToString()); foreach (Assignment model in models.data) { DataLayer.TempWorks.AddAssignmentProc(con, model); if (model.jobOrderId != 0) { WorkSite site = await TempWorksAPI.GetWorksiteFromTempworksAsync((int)model.jobOrderId); DataLayer.TempWorks.AddWorkSiteProc(con, site, DataLayer.TempWorks.AddAddressProc(con, site.address)); } } //_context.SaveChanges(); } catch (Exception ex) { _context.SaveError("Error in assignments", ex.Message); return(BadRequest(ex.Message)); } _context.SaveError("End of bulk assignments", "Total " + models.data.Count() + " records, starting at id " + models.data[0].assignmentId); } return(Ok("Success")); }
public WorkProgressGump(WorkSite wpoint) : base(50, 50) { WorkSite = wpoint; this.Closable = true; this.Disposable = true; this.Dragable = true; this.Resizable = false; this.AddPage(0); this.AddBackground(0, 0, 348, 256, 9270); this.AddBackground(21, 20, 306, 214, 9200); this.AddLabel(28, 29, 52, String.Format("Work Site Progress")); //title of gump this.AddLabel(31, 59, 0, String.Format("Labour Complete: {0}%", WorkSite.PercentComplete)); //labour complete % this.AddLabel(31, 80, 0, String.Format("{0} Collected: {1} of {2} Required", WorkSite.ResourceType.ToString(), WorkSite.GetAmount(WorkSite.ResourceType, true), (WorkSite.ResourcesRequired * (WorkSite.TotalPointsRequired - WorkSite.ProgressPoints)))); //# collected % this.AddLabel(31, 99, 0, String.Format("Required Skill: {0} {1}", WorkSite.SkillLevel, WorkSite.RequiredSkill)); //Skills needed this.AddLabel(31, 139, 0, String.Format("Total Workers: {0}", WorkSite.TotalWorkers)); //hides collected % this.AddImage(299, 208, 5560); if (WorkSite.PercentComplete < 100 && WorkSite.TotalPointsRequired > 0) //if complete, do not allow to apply for work! { this.AddLabel(36, 179, 0, @"Begin Working"); this.AddButton(134, 178, 247, 248, (int)Buttons.Button1, GumpButtonType.Reply, 0); } }
public void CreateWorkers(int num, WorkSite site) { if (supplies.food >= num) { numWorkers += num; supplies.DecreaseFood(num); Site worksite = Site.Create(site); for (int i = 0; i < num; i++) { GameObject instance = null; switch (site) { case WorkSite.Farm: instance = CreateInstance(Site.Create(WorkSite.Farm).GetRandomPosition(), transform.rotation); break; case WorkSite.Pyramid: instance = CreateInstance(Site.Create(WorkSite.Pyramid).GetRandomPosition(), transform.rotation); break; case WorkSite.Settlement: instance = CreateInstance(Site.Create(WorkSite.Settlement).GetRandomPosition(), transform.rotation); break; } Worker worker = instance.GetComponent <Worker>(); worker.hp = 100; worker.speed = Random.Range(0.2f, 0.5f); worker.foodConsumption = Random.Range(0.01f, 0.5f); worker.site = site; worksite.Register(worker); } Notify(this); } }
public ApplicationServiceMock() { _fileRepositoryMock = new FileRepository(@"TestUploads\"); _attachmentRepositoryMock = new AttachmentRepositoryMock(); // Arrange var einToTest = "41-9876543"; var testFileContents = "test"; var data = Encoding.ASCII.GetBytes(testFileContents); using (var memoryStream = new MemoryStream(data)) { var fileName = "test.txt"; // Arrange var einToTest1 = "41-9876544"; var fileName1 = "test1.txt"; var einToTest2 = "41-9876545"; var fileName2 = "test2.txt"; var einToTest3 = "41-9876546"; var fileName3 = "test3.txt"; var einToTest4 = "41-9876547"; var fileName4 = "test4.txt"; var service = new AttachmentService(_fileRepositoryMock, _attachmentRepositoryMock); var sCAAttachment = service.UploadAttachment(einToTest, memoryStream.ToArray(), fileName, "text/plain"); var sCAWageDeterminationAttachment = service.UploadAttachment(einToTest1, memoryStream.ToArray(), fileName1, "text/plain"); var pieceRateWageInfoAttachment = service.UploadAttachment(einToTest2, memoryStream.ToArray(), fileName2, "text/plain"); var mostRecentPrevailingWageSurveyAttachment = service.UploadAttachment(einToTest3, memoryStream.ToArray(), fileName3, "text/plain"); var hourlyWageInfoAttachment = service.UploadAttachment(einToTest4, memoryStream.ToArray(), fileName4, "text/plain"); var address = new Section14c.Domain.Models.Address { City = "Test City", County = "Some County", State = "VA", StreetAddress = "123 Main St", ZipCode = "12345" }; var employerInfoProvidingFacilitiesDeductionType = new EmployerInfoProvidingFacilitiesDeductionType { ProvidingFacilitiesDeductionType = new Response { Display = "Test" } }; ICollection <EmployerInfoProvidingFacilitiesDeductionType> eProvidingFacilitiesDeductionType = new List <EmployerInfoProvidingFacilitiesDeductionType> { employerInfoProvidingFacilitiesDeductionType }; EmployerInfo employer = new EmployerInfo { SCAAttachmentId = "1234567890", SCAAttachment = sCAAttachment, PhysicalAddress = address, TemporaryAuthority = true, HasTradeName = false, ProvidingFacilitiesDeductionType = eProvidingFacilitiesDeductionType }; SourceEmployer sEmployee = new SourceEmployer { EmployerName = "Some Name" }; ICollection <SourceEmployer> sourceEmployer = new List <SourceEmployer> { sEmployee }; PrevailingWageSurveyInfo prevailingWageSurveyInfo = new PrevailingWageSurveyInfo { AttachmentId = "1234567890", Attachment = mostRecentPrevailingWageSurveyAttachment, SourceEmployers = sourceEmployer }; PieceRateWageInfo pieceRateWageInfo = new PieceRateWageInfo { AttachmentId = "1234567890", Attachment = pieceRateWageInfoAttachment, SCAWageDeterminationAttachmentId = "1234567890", SCAWageDeterminationAttachment = sCAWageDeterminationAttachment, MostRecentPrevailingWageSurvey = prevailingWageSurveyInfo }; HourlyWageInfo hourlyWageInfo = new HourlyWageInfo { AttachmentId = "1234567890", Attachment = hourlyWageInfoAttachment, MostRecentPrevailingWageSurvey = prevailingWageSurveyInfo, SCAWageDeterminationAttachment = sCAWageDeterminationAttachment }; Response res = new Response { Display = "Response Test 1", IsActive = true }; WIOAWorker worker1 = new WIOAWorker { FullName = "Test 1", WIOAWorkerVerified = res, }; ICollection <WIOAWorker> wIOAWorkerCol = null; wIOAWorkerCol = new List <WIOAWorker>() { worker1 }; ICollection <Employee> employees = null; var emp = new Employee() { AvgHourlyEarnings = 1, AvgWeeklyHours = 1, CommensurateWageRate = "1", PrevailingWage = 1, Name = "test", NumJobs = 1, PrimaryDisability = new Response() { Display = "Sample Data" }, ProductivityMeasure = 1.2, TotalHours = 1.0, WorkType = "Some Type" }; employees = new List <Employee>() { emp }; ICollection <WorkSite> workSites = null; var ws = new WorkSite() { Employees = employees, WorkSiteType = new Response() { Display = "Work Site Type" }, Name = "This Is A Tribute", SCA = false }; workSites = new List <WorkSite>() { ws, ws, ws }; WIOA wIOA = new WIOA { WIOAWorkers = wIOAWorkerCol, }; applicationSubmission = new ApplicationSubmission { Employer = employer, PieceRateWageInfo = pieceRateWageInfo, HourlyWageInfo = hourlyWageInfo, WIOA = wIOA, PayType = new Response() { Display = "Both" }, WorkSites = workSites, EIN = "11-1111111", Id = "CE7F5AA5-6832-43FE-BAE1-80D14CD8F666", TotalNumWorkSites = 1, ContactName = "Tester", ContactPhone = "123=345-1234", ContactEmail = "*****@*****.**" }; applicationSubmissionCollection = new List <ApplicationSubmission>(); applicationSubmissionCollection.Add(applicationSubmission); } }