Example #1
0
        public Student DeleteStudent(Student student)
        {
            var res = _context.Student.FirstOrDefault(s => s.IndexNumber == student.IndexNumber);

            if (res == null)
            {
                return(null);
            }
            _context.Student.Remove(res);
            _context.SaveChanges();
            return(res);
        }
Example #2
0
        public bool AddPet(AddPetReq req)
        {
            var pet = new AddPetReq
            {
                BreedName              = req.BreedName,
                Name                   = req.Name,
                IsMale                 = req.IsMale,
                DateRegistered         = req.DateRegistered,
                ApprocimateDateOfBirth = req.ApprocimateDateOfBirth,
            };
            var idb    = context.BreedType.Where(b => b.Name == pet.BreedName).Select(p => p.IdBreedType).First();
            var idbool = context.BreedType.Where(b => b.Name == pet.BreedName).Select(p => p.IdBreedType).Any();

            if (!idbool)
            {
                var br = new BreedType
                {
                    IdBreedType = context.BreedType.Max(b => b.IdBreedType) + 1,
                    Name        = pet.BreedName,
                };
                context.BreedType.Add(br);
            }
            var np = new Pet
            {
                IdPet                  = context.Pet.Max(p => p.IdPet) + 1,
                IdBreedType            = idb,
                Name                   = pet.Name,
                IsMale                 = pet.IsMale,
                DateRegistered         = pet.DateRegistered,
                ApprocimateDateOfBirth = pet.ApprocimateDateOfBirth
            };

            context.Pet.Add(np);
            context.SaveChanges();
            return(true);
        }