public PackageUploadHandle Publish(Package l, List <string> files, bool isNewVersion)
{
OnAuthenticationRequested();
int maxRetries = 5;
int count = 0;
var nv = new ValidateAuth();
ResponseBody pkgResponse = null;
while (pkgResponse == null && count < maxRetries)
{
count++;
pkgResponse = Client.ExecuteAndDeserialize(nv);
}
if (pkgResponse == null)
{
throw new AuthenticationException(
"It looks like you're not logged into Autodesk 360. Log in to submit a package.");
}
var packageUploadHandle = new PackageUploadHandle(l.Header);
return(PublishPackage(isNewVersion, l, files, packageUploadHandle));
}
public BusquedaGrupalController()
{
_context = new ApplicationDbContext();
validator = new ValidatePerson(_context);
auth = new ValidateAuth();
activeDirectory = new ADClass();
}
public ContractController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
B1 = B1Connection.Instance();
AD = new ADClass();
}
public static IQueryable <Civil> findBPInSAP(string CardCode, CustomUser user, ApplicationDbContext _context)
{
var auth = new ValidateAuth();
var query = "select 0 \"Id\",0 \"CreatedBy\",null \"Document\", ocrd.\"CardCode\" \"SAPId\", ocrd.\"CardName\" \"FullName\",ocrd.\"LicTradNum\" \"NIT\", br.\"Id\" \"BranchesId\"" +
" from " + ConfigurationManager.AppSettings["B1CompanyDB"] + ".ocrd" +
" inner join " + ConfigurationManager.AppSettings["B1CompanyDB"] + ".crd8" +
" on ocrd.\"CardCode\" = crd8.\"CardCode\"" +
" inner join " + CustomSchema.Schema + ".\"Branches\" br" +
" on br.\"CodigoSAP\" = crd8.\"BPLId\"" +
" where ocrd.\"validFor\" = 'Y'" +
" and crd8.\"DisabledBP\" = 'N'" +
" and ocrd.\"CardType\" = 'S'" +
" and ocrd.\"CardCode\"= '" + CardCode + "';";
var rawresult = _context.Database.SqlQuery <Civil>(query).ToList();
if (rawresult.Count() == 0)
{
return(null);
}
var res = auth.filerByRegional(rawresult.AsQueryable(), user);
if (res.Count() == 0)
{
return(null);
}
return(res.Cast <Civil>());
}
public AuthController()
{
_context = new ApplicationDbContext();
validator = new ValidateToken();
validateauth = new ValidateAuth();
activeDirectory = new ADClass();
}
private static void ValidateAuthTest()
{
var nv = new ValidateAuth();
var pkgResponse = pmc.ExecuteAndDeserialize(nv);
Console.WriteLine(pkgResponse.message);
}
public IHttpActionResult BP()
{
ValidateAuth auth = new ValidateAuth();
CustomUser user = auth.getUser(Request);
var y = B1conn.getBusinessPartners("*", user: user);
return(Ok(y));
}
public PeopleController()
{
_context = new ApplicationDbContext();
validator = new ValidatePerson(_context);
auth = new ValidateAuth();
activeDirectory = new ADClass();
B1 = B1Connection.Instance();
}
public void Configuration(IAppBuilder app)
{
bool debugmode = false;
app.Use(async(environment, next) =>
{
AccessLogs log = null;
ApplicationDbContext _context = new ApplicationDbContext();
var req = environment.Request;
string endpoint = environment.Request.Path.ToString();
Uri uri = req.Uri;
var seg = uri.Segments;
string verb = environment.Request.Method;
int userid = 0;
Int32.TryParse(environment.Request.Headers.Get("id"), out userid);
string token = environment.Request.Headers.Get("token");
ValidateAuth validator = new ValidateAuth();
int resourceid = 0;
//tiene resourseid
if (Int32.TryParse(seg[seg.Length - 1], out resourceid))
{
endpoint = "";
for (int i = 0; i < seg.Length - 1; i++)
{
endpoint += seg[i];
}
}
bool sup = validator.shallYouPass(userid, token, endpoint, verb, out log);
if (!debugmode && !sup)
{
environment.Response.StatusCode = 401;
environment.Response.Body = new MemoryStream();
var newBody = new MemoryStream();
newBody.Seek(0, SeekOrigin.Begin);
var newContent = new StreamReader(newBody).ReadToEnd();
newContent += "You shall no pass.";
environment.Response.Body = newBody;
environment.Response.Write(newContent);
//log = _context.AccessLogses.FirstOrDefault(x => x.Id == logId);
}
else
{
await next();
//log = _context.AccessLogses.FirstOrDefault(x => x.Id == logId);
}
}
);
//app.UseStaticFiles();
ConfigureAuth(app);
}
public PackageUploadHandle Publish(Package l, List <string> files, bool isNewVersion, bool isTestMode)
{
this.OnRequestAuthentication();
var nv = new ValidateAuth();
var pkgResponse = Client.ExecuteAndDeserialize(nv);
if (pkgResponse == null)
{
throw new AuthenticationException(
"It looks like you're not logged into Autodesk 360. Log in to submit a package.");
}
var packageUploadHandle = new PackageUploadHandle(PackageUploadBuilder.NewPackageHeader(l));
return(PublishPackage(isNewVersion, l, files, packageUploadHandle, isTestMode));
}
public PackageUploadHandle Publish(Package l, List <string> files, bool isNewVersion)
{
dynSettings.Controller.DynamoViewModel.OnRequestAuthentication();
var nv = new ValidateAuth();
var pkgResponse = Client.ExecuteAndDeserialize(nv);
if (pkgResponse == null)
{
throw new AuthenticationException(
"It looks like you're not logged into Autodesk 360. Log in to submit a package.");
}
var packageUploadHandle = new PackageUploadHandle(l.Header);
return(PublishPackage(isNewVersion, l, files, packageUploadHandle));
}
public IHttpActionResult Careers()
//Este endpoint permite obtener la Unidad Organizacional de la carrera
{
ValidateAuth auth = new ValidateAuth();
string query = "select a.\"PrcCode\", a.\"PrcName\", a.\"ValidFrom\", a.\"ValidTo\", a.\"U_NUM_INT_CAR\", a.\"U_Nivel\", b.\"U_CODIGO_DEPARTAMENTO\" as \"UO\", b.\"U_CODIGO_SEGMENTO\", br.\"Id\" as \"BranchesId\" "
+ "from ucatolica.oprc a "
+ "inner join " + ConfigurationManager.AppSettings["B1CompanyDB"] + ".\"@T_GEN_CARRERAS\" b "
+ " on a.\"PrcCode\" = b.\"U_CODIGO_CARRERA\" "
+ "inner join " + CustomSchema.Schema + ".\"Branches\" br "
+ " on br.\"Abr\" = b.\"U_CODIGO_SEGMENTO\" "
+ " WHERE a.\"DimCode\" = " + 3;
var rawresult = _context.Database.SqlQuery <CostCenterCarrera>(query).OrderBy(x => x.PrcCode);
var user = auth.getUser(Request);
var filteredList = auth.filerByRegional(rawresult.AsQueryable(), user).ToList().OrderBy(x => x.PrcCode);
return(Ok(filteredList));
}
public static IQueryable <Civil> findBPInSAP(string CardCode, CustomUser user, ApplicationDbContext _context)
{
string condicion = "";
// Si el codigo de socio comienza con P o H, entonces se busca en socios de negocio, sino es busqueda por CI
if (CardCode.Substring(0, 1).Equals("H") || CardCode.Substring(0, 1).Equals("P"))
{
condicion = " and ocrd.\"CardCode\"= '" + CardCode + "'";
}
else
{
condicion = " and ocrd.\"LicTradNum\"= '" + CardCode + "'";
}
var auth = new ValidateAuth();
var query = "select 0 \"Id\",0 \"CreatedBy\",null \"Document\", ocrd.\"CardCode\" \"SAPId\", ocrd.\"CardName\" \"FullName\",ocrd.\"LicTradNum\" \"NIT\", br.\"Id\" \"BranchesId\"" +
" from " + ConfigurationManager.AppSettings["B1CompanyDB"] + ".ocrd" +
" inner join " + ConfigurationManager.AppSettings["B1CompanyDB"] + ".crd8" +
" on ocrd.\"CardCode\" = crd8.\"CardCode\"" +
" inner join " + CustomSchema.Schema + ".\"Branches\" br" +
" on br.\"CodigoSAP\" = crd8.\"BPLId\"" +
" where ocrd.\"validFor\" = 'Y'" +
" and crd8.\"DisabledBP\" = 'N'" +
" and ocrd.\"CardType\" = 'S'" +
condicion;
var rawresult = _context.Database.SqlQuery <Civil>(query).ToList();
if (rawresult.Count() == 0)
{
return(null);
}
var res = auth.filerByRegional(rawresult.AsQueryable(), user);
if (res.Count() == 0)
{
return(null);
}
return(res.Cast <Civil>());
}
public NombramientoController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
}
public CivilController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
AD = new ADClass();
}
public CauseOfMovementController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
}
public ServContractController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
}
public BranchesController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
}
public DependencyController()
{
_context = new ApplicationDbContext();
validator = new ValidateAuth();
}
public IHttpActionResult saveLastAltaExcel(int id)
{
var tempAlta = _context.TempAltas.Where(x => x.BranchesId == id && x.State == "UPLOADED");
ValidateAuth auth = new ValidateAuth();
CustomUser user = auth.getUser(Request);
if (tempAlta.Count() < 0)
{
return(NotFound());
}
foreach (var alta in tempAlta)
{
var person = new People();
var depId = _context.Dependencies.FirstOrDefault(x => x.Cod == alta.Dependencia).Id;
person = _context.Person.FirstOrDefault(x => x.CUNI == alta.CUNI);
var exist = _context.ContractDetails.Where
(
x =>
x.CUNI == alta.CUNI &&
x.PeopleId == person.Id &&
x.DependencyId == depId &&
x.Dedication == "TH" &&
x.Linkage == 3 &&
x.PositionsId == 26 &&
x.StartDate == alta.StartDate &&
x.EndDate == alta.EndDate
).ToList().Any();
if (!exist)
{
var contract = new ContractDetail();
contract.Id = ContractDetail.GetNextId(_context);
contract.DependencyId = depId;
contract.CUNI = person.CUNI;
contract.PeopleId = person.Id;
contract.BranchesId = alta.BranchesId;
contract.Dedication = "TH";
contract.Linkage = 3;
contract.PositionDescription = "Docente Tiempo Horario";
contract.PositionsId = 26;
contract.StartDate = alta.StartDate;
contract.EndDate = alta.EndDate;
contract.Active = true;
_context.ContractDetails.Add(contract);
alta.State = "INBANKH";
}
else
{
alta.State = "DUPLICATE";
}
}
_context.SaveChanges();
tempAlta = _context.TempAltas.Where(x => x.BranchesId == id && x.State == "INBANKH");
foreach (var alta in tempAlta)
{
var person = new People();
person = _context.Person.FirstOrDefault(x => x.CUNI == alta.CUNI);
var res = B1.AddOrUpdatePerson(user.Id, person, "DOCENTE T.H.");
if (!res.Contains("ERROR"))
{
alta.State = "INSAP";
}
else
{
alta.State = "ERRORINSAP";
}
}
_context.SaveChanges();
return(Ok(tempAlta));
}
public PositionsController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
}
