public IEnumerable <Paperwork> GetPaperworkBy(int id)
{
var result = new List <Paperwork>();
using (dbtramiteContext db = new dbtramiteContext())
{
result = db.Paperwork.Where(p => p.FacultyId == id && p.IsActive == 1).ToList();
}
return(result);
}
public IEnumerable <Paperworkreception> GetPaperworkReceptions()
{
var result = new List <Paperworkreception>();
using (dbtramiteContext db = new dbtramiteContext())
{
result = db.Paperworkreception.Where(f => f.IsActive == 1).ToList();
}
return(result);
}
public IEnumerable <Requirement> GetRequirements()
{
var result = new List <Requirement>();
using (dbtramiteContext db = new dbtramiteContext())
{
result = db.Requirement.Where(f => f.IsActive == 1).ToList();
}
return(result);
}
public IEnumerable <Faculty> GetFaculties()
{
var result = new List <Faculty>();
using (dbtramiteContext db = new dbtramiteContext())
{
result = db.Faculty.Where(f => f.IsActive == 1).ToList();
}
return(result);
}
public IEnumerable <Requirement> GetRequisitosBy(int id)
{
var result = new List <Requirement>();
using (dbtramiteContext db = new dbtramiteContext())
{
result = db.Requirement.Where(r => r.PaperWorkId == id)
.Include(re => re.PaperWorkReception).ToList();
foreach (var item in result)
{
item.PaperWorkReception = db.Paperworkreception.Where(p => p.Id == item.PaperWorkReceptionId).Single();
}
}
return(result);
}
public async Task <ActionResult <Faculty> > CreateFaculty(FacultyCriteria item)
{
Faculty result = new Faculty();
using (dbtramiteContext db = new dbtramiteContext())
{
result.Name = item.Name;
result.Description = item.Description;
result.CreatedBy = "1";
result.IsActive = 1;
result.CreatedAt = DateTime.Now;
db.Add(result);
db.SaveChanges();
}
return(result);
}
public async Task <ActionResult <Paperwork> > CreatePaperwork(PaperworkCriteria item)
{
Paperwork result = new Paperwork();
using (dbtramiteContext db = new dbtramiteContext())
{
result.Name = item.Name;
result.FacultyId = item.FacultyId;
result.CreatedBy = "1";
result.IsActive = 1;
result.CreatedAt = DateTime.Now;
db.Add(result);
db.SaveChanges();
}
return(result);
}
public async Task <ActionResult <Paperworkreception> > CreatePaperworkReception(PaperworkreceptionCriteria item)
{
Paperworkreception result = new Paperworkreception();
using (dbtramiteContext db = new dbtramiteContext())
{
result.Name = item.Name;
result.Description = item.Description;
result.Coordinate = new MySqlGeometry(item.Longitude, item.Latitude);
result.CreatedBy = "1";
result.IsActive = 1;
result.CreatedAt = DateTime.Now;
db.Add(result);
db.SaveChanges();
}
return(result);
}
public async Task <ActionResult <Requirement> > CreateRequirement(RequirementCriteria item)
{
Requirement result = new Requirement();
using (dbtramiteContext db = new dbtramiteContext())
{
result.Name = item.Name;
result.Description = item.Description;
result.PaperWorkId = item.PaperWorkId;
result.PaperworkLink = item.PaperworkLink;
result.PaperWorkReceptionId = item.PaperWorkReceptionId;
result.CreatedBy = "1";
result.IsActive = 1;
result.CreatedAt = DateTime.Now;
db.Add(result);
db.SaveChanges();
}
return(result);
}
