public BusquedaGrupalController()
{
_context = new ApplicationDbContext();
validator = new ValidatePerson(_context);
auth = new ValidateAuth();
activeDirectory = new ADClass();
}
public AuthController()
{
_context = new ApplicationDbContext();
validator = new ValidateToken();
validateauth = new ValidateAuth();
activeDirectory = new ADClass();
}
public IHttpActionResult ProjectGeneral(int user)
{
FiltroUser us = new FiltroUser(user);
//convertir precio a float o double y cantidad a int!!
var queryProduct =
"select p.\"PrjCode\" as \"codigo_proyecto\"," +
"\r\np.\"PrjName\" as \"nombre_proyecto\"," +
"\r\np.\"U_Sucursal\" as \"regional\"," +
"\r\np.\"U_PEI_PO\" as \"pei_po\"," +
"\r\np.\"U_UORGANIZA\" as \"unidad_organizacional\"," +
"\r\np.\"ValidTo\" as \"valido_hasta\", p.\"ValidFrom\" " +
"\r\nas \"valido_desde\" from ucatolica.oprj p " +
"\r\nwhere p.\"Active\" = 'Y' " +
"\r\nand p.\"ValidTo\" >= current_date " +
"\r\ngroup by p.\"PrjCode\"," +
"\r\np.\"PrjName\", p.\"U_Sucursal\", p.\"U_PEI_PO\", " +
"\r\np.\"U_UORGANIZA\", p.\"ValidTo\", p.\"ValidFrom\" order by " +
"\r\np.\"PrjCode\", p.\"PrjName\"";
var rawresult = _context.Database.SqlQuery <Project>(queryProduct).ToList();
var AD = new ADClass();
var data = AD.FiltrarRegional(new FiltroUser(user), rawresult.AsQueryable()).ToList();
var formatedData = data.Select(x => new
{
nombre = x.codigo_proyecto + " - " + x.nombre_proyecto,
x.codigo_proyecto,
x.nombre_proyecto,
x.regional,
valido_hasta = x.valido_hasta.ToString("dd/MM/yyyy"),
valido_desde = x.valido_desde.ToString("dd/MM/yyyy"),
});
return(Ok(formatedData));
}
public ContractController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
B1 = B1Connection.Instance();
AD = new ADClass();
}
public PeopleController()
{
_context = new ApplicationDbContext();
validator = new ValidatePerson(_context);
auth = new ValidateAuth();
activeDirectory = new ADClass();
B1 = B1Connection.Instance();
}
public Frm_MotorParam()
{
InitializeComponent();
LoadtreeView1(DeviceRsDef.AxisList);
MotionCard = DeviceRsDef.MotionCard;
DAch1 = new DAClass(MotionCard, 0);
DAch2 = new DAClass(MotionCard, 1);
ADch1 = new ADClass(MotionCard, 0);
ADch2 = new ADClass(MotionCard, 1);
Encode = new List <EncodeClass>();
for (int i = 0; i < 4; i++)
{
Encode.Add(new EncodeClass(MotionCard, i));
}
}
public RolController()
{
_context = new ApplicationDbContext();
validator = new ValidatePerson(_context);
activeDirectory = new ADClass();
}
public CivilController()
{
_context = new ApplicationDbContext();
auth = new ValidateAuth();
AD = new ADClass();
}
public IHttpActionResult Put(int id, [FromBody] People person)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
People personInDB = _context.Person.FirstOrDefault(d => d.Id == id);
if (personInDB == null)
{
return(NotFound());
}
person = validator.CleanName(person);
// log changes
ChangesLogs log = new ChangesLogs();
log.AddChangesLog(personInDB, person, new List <string>()
{
"TypeDocument", "Document", "Ext", "Names", "FirstSurName", "SecondSurName", "BirthDate", "Gender",
"Nationality", "UseMariedSurName", "UseSecondSurName", "MariedSurName", "PhoneNumber", "PersonalEmail", "OfficePhoneNumber", "OfficePhoneNumberExt",
"HomeAddress", "UcbEmail", "AFP", "NUA", "Insurance", "InsuranceNumber"
});
//--------------------------REQUIRED COLS--------------------------
personInDB.TypeDocument = cleanText(person.TypeDocument);
personInDB.Document = person.Document;
personInDB.Ext = cleanText(person.Ext);
personInDB.Names = cleanText(person.Names);
personInDB.FirstSurName = cleanText(person.FirstSurName);
personInDB.SecondSurName = cleanText(person.SecondSurName);
personInDB.BirthDate = person.BirthDate;
personInDB.Gender = cleanText(person.Gender);
personInDB.Nationality = cleanText(person.Nationality);
personInDB.UseMariedSurName = (int)person.UseMariedSurName;
personInDB.UseSecondSurName = person.UseSecondSurName;
//------------------------NON REQUIRED COLS--------------------------
personInDB.MariedSurName = cleanText(person.MariedSurName);
personInDB.PhoneNumber = person.PhoneNumber;
personInDB.PersonalEmail = person.PersonalEmail;
personInDB.OfficePhoneNumber = person.OfficePhoneNumber;
personInDB.OfficePhoneNumberExt = person.OfficePhoneNumberExt;
personInDB.HomeAddress = person.HomeAddress;
personInDB.UcbEmail = person.UcbEmail;
personInDB.AFP = cleanText(person.AFP);
personInDB.NUA = person.NUA;
personInDB.Insurance = person.Insurance;
personInDB.InsuranceNumber = person.InsuranceNumber;
//register updated time
personInDB.UpdatedAt = DateTime.Now;
var ADauth = new ADClass();
var usr = auth.getUser(Request);
var rols = ADauth.getUserRols(usr);
var canUpdatePending = false;
foreach (var rol in rols)
{
if (rol.Name == "GPS Admin" || rol.Name == "Admin")
{
canUpdatePending = true;
break;
}
}
if (canUpdatePending)
{
personInDB.Pending = person.Pending;
}
_context.SaveChanges();
return(Ok(personInDB));
}
public IHttpActionResult Get(int id, [FromUri] string by = "Id")
{
People personInDB = null;
switch (by)
{
case "Id":
personInDB = _context.Person.FirstOrDefault(d => d.Id == id);
break;
case "Contract":
var con = _context.ContractDetails.Include(x => x.People).FirstOrDefault(d => d.Id == id);
personInDB = con == null ? null : con.People;
break;
}
if (personInDB == null)
{
return(NotFound());
}
var ADauth = new ADClass();
var usr = auth.getUser(Request);
var rols = ADauth.getUserRols(usr);
var canUpdatePending = false;
foreach (var rol in rols)
{
if (rol.Name == "GPS Admin" || rol.Name == "Admin")
{
canUpdatePending = true;
break;
}
}
dynamic res = new JObject();
res.Id = personInDB.Id;
res.CUNI = personInDB.CUNI;
res.Document = personInDB.Document;
res.TypeDocument = personInDB.TypeDocument;
res.Ext = personInDB.Ext;
res.FullName = personInDB.GetFullName();
res.FirstSurName = personInDB.FirstSurName;
res.SecondSurName = personInDB.SecondSurName;
res.Names = personInDB.Names;
res.MariedSurName = personInDB.MariedSurName == null ? "" : personInDB.MariedSurName;
res.UseMariedSurName = personInDB.UseMariedSurName;
res.UseSecondSurName = personInDB.UseSecondSurName;
res.Pending = personInDB.Pending;
res.canUpdatePending = personInDB.Pending && canUpdatePending;
var c = personInDB.GetLastContract(_context, date: DateTime.Now);
res.Contract = c != null;
res.ContractId = c == null ? (dynamic)"" : c.Id;
res.PositionsId = c == null ? (dynamic)"" : c.Positions.Id;
res.Positions = c == null ? "" : c.Positions.Name;
res.PositionDescription = c == null ? "" : c.PositionDescription;
res.AI = c == null ? false : c.AI;
res.Dedication = c == null ? "" : c.Dedication;
res.Linkage = c == null ? "" : c.Link.Value;
res.DependencyId = c == null ? (dynamic)"" : c.Dependency.Id;
res.Dependency = c == null ? "" : c.Dependency.Name;
res.Branches = c == null ? null : _context.Branch.FirstOrDefault(x => x.Id == c.Dependency.BranchesId).Name;
res.StartDatestr = c == null ? (dynamic)"" : c.StartDate.ToString("dd MMM yyyy", new CultureInfo("es-ES"));
res.EndDatestr = c == null ? (dynamic)"" : c.EndDate == null ? "" : c.EndDate.Value.ToString("dd MMM yyyy", new CultureInfo("es-ES"));
res.StartDate = c == null ? (dynamic)"" : c.StartDate.ToString("MM/dd/yyyy");
res.EndDate = c == null ? (dynamic)"" : c.EndDate == null ? "" : c.EndDate.Value.ToString("MM/dd/yyyy");
res.Gender = personInDB.Gender;
res.BirthDatestr = personInDB.BirthDate.ToString("dd MMM yyyy", new CultureInfo("es-ES"));
res.BirthDate = personInDB.BirthDate.ToString("MM/dd/yyyy");
res.Nationality = personInDB.Nationality;
res.AFP = personInDB.AFP;
res.NUA = personInDB.NUA;
res.Insurance = personInDB.Insurance;
res.UcbEmail = personInDB.UcbEmail;
res.PersonalEmail = personInDB.PersonalEmail;
res.Age = DateTime.Now.Year - personInDB.BirthDate.Year;
var u = _context.CustomUsers.FirstOrDefault(x => x.PeopleId == personInDB.Id);
res.UserName = u == null ? "" : u.UserPrincipalName; return(Ok(res));
}
public CustomUserController()
{
_context = new ApplicationDbContext();
validator = new ValidateToken();
activeDirectory = new ADClass();
}
