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