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