public IQueryable<County> GetCounties(ProlianceConnection conn, string prjAccount, string attrib)
{
//CurrentUser = (ProlianceUser)CurrentContext.Session["user"];
using (var proliance = new LookupProxy(conn, prjAccount))
{
try
{
var ver = proliance.GetLookupVersionByType("ProjectOfficeUnitType");
var query = from item in ver.Items.AsEnumerable()
where item.Attributes[0].Value.ToString() == attrib
select new County
{
Code = item.Code,
FullCode = item.FullCode,
Description = item.Description,
level = item.Level,
Display = item.Code + " : " + item.Description,
SortValue = item.SortValue
};
return query.AsQueryable();
}
catch (Exception ex)
{
throw new Exception("Error occured reading lookup: ", ex);
}
}
}
private void addNewSkillType_Click(object sender, EventArgs e)
{
var skilltype = new Lookup.EmployeeSkillTypeView();
skilltype.ShowList();
var result = skilltype.ShowDialog(this);
if (result == DialogResult.OK)
{
var store = new LookupProxy();
this.skillTypeBindingSource.DataSource = store.Context.EmployeeSkillTypes.ToList();
}
}
private void addNewCompetencyType_Click(object sender, EventArgs e)
{
var comptype = new Lookup.CompetencyTypeView();
comptype.ShowList();
var result = comptype.ShowDialog(this);
if (result == DialogResult.OK)
{
var store = new LookupProxy();
this.cometencyTypeListBindingSource.DataSource = store.Context.CompetencyTypes.ToList();
}
}
private void addNewDepartmrnthyperLinkEdit_Click(object sender, EventArgs e)
{
var picker = new Lookup.OrganizationNodeTypeView();
picker.ShowList();
var result = picker.ShowDialog(this);
if (result == DialogResult.OK)
{
var store = new LookupProxy();
this.organizationBindingSource.DataSource = store.Context.OrganizationNodeTypes.ToList();
}
}
private void addBenefitsTypehyperLinkEdit_Click(object sender, EventArgs e)
{
var picker = new Lookup.BenefitTypeView();
picker.ShowList();
var result = picker.ShowDialog(this);
if (result == DialogResult.OK)
{
var store = new LookupProxy();
this.benefitTypeBindingSource.DataSource = store.Context.BenefitTypes.ToList();
}
}
private void addEducationLevelHyperLinkEdit_Click(object sender, EventArgs e)
{
var picker = new Lookup.EducationLevelView();
picker.ShowList();
var result = picker.ShowDialog(this);
if (result == DialogResult.OK)
{
var store = new LookupProxy();
this.educationLevelBindingSource.DataSource = store.Context.EducationLevels.ToList();
}
}
private void addNationalityHyperLinkEdit_Click(object sender, EventArgs e)
{
var picker = new Lookup.NationalityView();
picker.ShowList();
var result = picker.ShowDialog(this);
if (result == DialogResult.OK)
{
var store = new LookupProxy();
this.nationalityBindingSource.DataSource = store.Context.Nationalities.ToList();
}
}
private void addNewCategoryhyperLinkEdit_Click(object sender, EventArgs e)
{
var picker = new Lookup.TrainingCategoryView();
picker.ShowList();
var result = picker.ShowDialog(this);
if (result == DialogResult.OK)
{
var store = new LookupProxy();
this.trainingCategoryBindingSource.DataSource = store.Context.TrainingCategories.ToList();
}
}
private static void executeClient(Object obj)
{
LookupProxy lookupProxy = LookupProxy.GetInstance();
ICalculadora calculadora = new CalculadoraProxy(lookupProxy.Lookup("calculadora"));
for (int i = 0; i < 10000; i++)
{
var watch = new System.Diagnostics.Stopwatch();
watch.Start();
calculadora.Eval(i + "*2+1");
watch.Stop();
tempoTranscorrido += watch.ElapsedMilliseconds;
tempos.Add(watch.ElapsedMilliseconds);
}
}
public SRH()
{
LookupProxy proxy = LookupProxy.GetInstance();
proxy.Register("calculadora", aor);
}
public IQueryable<ProjectStatus> GetProjectStatus(ProlianceConnection conn, string prjAccount)
{
//CurrentUser = (ProlianceUser)CurrentContext.Session["user"];
using (var proliance = new LookupProxy(conn, prjAccount))
{
try
{
var ver = proliance.GetLookupVersionByType("ProjectSecuredStatusType");
var query = from item in ver.Items.AsEnumerable()
where item.Level == 0
select new ProjectStatus
{
Code = item.Code,
FullCode = item.FullCode,
Description = item.Description,
level = item.Level,
Display = item.Code + " : " + item.Description,
SortValue = item.SortValue
};
return query.AsQueryable();
}
catch (Exception ex)
{
throw new Exception("Error occured reading lookup: ", ex);
}
}
}
