public Project4 GetById(int pid)
{
using (masterContext db = new masterContext())
{
return(db.Project4.Find(pid));
}
}
public Employee GetById(string Eid)
{
using (masterContext db = new masterContext())
{
return(db.Employee.Find(Eid));
}
}
public void Update()
{
using (masterContext con = new masterContext()){
System.Console.Write("Enter Id: ");
int gameId = int.Parse(Console.ReadLine());
var game = con.Games.Find(gameId);
if (game != null)
{
System.Console.WriteLine("Enter new Players amount: ");
game.Players = long.Parse(Console.ReadLine());
System.Console.WriteLine("Enter new game's mark: ");
game.Mark = double.Parse(Console.ReadLine());
if (con.SaveChanges() == 0)
{
Console.ForegroundColor = ConsoleColor.Red;
System.Console.WriteLine("Error! Game wasn't update");
Console.ForegroundColor = ConsoleColor.White;
}
else
{
Console.ForegroundColor = ConsoleColor.Green;
System.Console.WriteLine("Game was successfully updated");
Console.ForegroundColor = ConsoleColor.White;
}
}
}
}
public void Create()
{
using (masterContext con = new masterContext()){
Games game = new Games();
System.Console.Write("Enter name of game: ");
game.Name = Console.ReadLine();
System.Console.Write("Enter amount of players: ");
game.Players = long.Parse(Console.ReadLine());
System.Console.Write("Enter mark of this game: ");
game.Mark = double.Parse(Console.ReadLine());
con.Add(game);
if (con.SaveChanges() > 0)
{
Console.ForegroundColor = ConsoleColor.Green;
System.Console.WriteLine($"{game.Name} was successfully added");
Console.ForegroundColor = ConsoleColor.White;
}
else
{
Console.ForegroundColor = ConsoleColor.Red;
System.Console.WriteLine("Error");
Console.ForegroundColor = ConsoleColor.White;
}
}
}
public async Task <IActionResult> Post([FromBody] GraphQLQuery query)
{
var schema = new Schema {
Query = new VeterinaryQuery()
};
masterContext masterContext = new masterContext();
var result = await new DocumentExecuter().ExecuteAsync(_ =>
{
_.Schema = schema;
_.Query = query.Query;
_.UserContext = masterContext;
}).ConfigureAwait(false);
if (result.Errors?.Count > 0)
{
return(BadRequest());
}
masterContext.Dispose();
return(Ok(result));
}
public List <Project4> GetAll()
{
using (masterContext db = new masterContext())
{
return(db.Project4.ToList());
}
}
public List <Employee> GetAll()
{
using (masterContext db = new masterContext())
{
return(db.Employee.ToList());
}
}
public void Update(Employee item)
{
using (masterContext db = new masterContext())
{
db.Employee.Update(item);
db.SaveChanges();
}
}
public void Update(Project4 item)
{
using (masterContext db = new masterContext())
{
db.Project4.Update(item);
db.SaveChanges();
}
}
public void Delete(string Eid)
{
using (masterContext db = new masterContext())
{
Employee e = db.Employee.Find(Eid);
db.Employee.Remove(e);
db.SaveChanges();
}
}
public async Task <ActionResult <IEnumerable <Pets> > > Get()
{
using (masterContext context = new masterContext())
{
return(await context
.Pets
.ToListAsync());
}
}
public void Delete(int pid)
{
using (masterContext db = new masterContext())
{
Project4 p = db.Project4.Find(pid);
db.Project4.Remove(p);
db.SaveChanges();
}
}
public BasicAuthenticationHandler(
IOptionsMonitor <AuthenticationSchemeOptions> options,
ILoggerFactory logger,
UrlEncoder encoder,
ISystemClock clock,
masterContext context)
: base(options, logger, encoder, clock)
{
_context = context;
}
public async Task <ActionResult <IEnumerable <Pets> > > Get(int id)
{
using (masterContext context = new masterContext())
{
return(await context
.Pets
.Where(p => p.OwnerId == id)
.ToListAsync());
}
}
public async Task <ActionResult <IEnumerable <AnimalType> > > Get()
{
using (masterContext context = new masterContext())
{
return(await context
.AnimalType
.Include(p => p.Pets)
.ToListAsync());
}
}
public IActionResult DeleteStudent(string indexNumber)
{
var context = new masterContext();
var studentInDb = context.Student.Find(indexNumber);
context.Student.Remove(studentInDb);
context.SaveChanges();
return(NoContent());
}
public async Task <ActionResult <Pets> > Post([FromBody] Pets value)
{
using (masterContext context = new masterContext())
{
var newPet = await context.Pets.AddAsync(value);
await context.SaveChangesAsync();
return(newPet.Entity);
}
}
public async Task <ActionResult <AnimalType> > Post([FromBody] AnimalType value)
{
using (masterContext context = new masterContext())
{
var newType = await context.AnimalType.AddAsync(value);
await context.SaveChangesAsync();
return(newType.Entity);
}
}
public async Task <ActionResult <AnimalType> > Get(int id)
{
using (masterContext context = new masterContext())
{
return(await context
.AnimalType
.Include(p => p.Pets)
.Where(p => p.TypeId == id)
.FirstOrDefaultAsync());
}
}
static void Main(string[] args)
{
using (masterContext db = new masterContext())
{
Item i = new Item()
{
ItemName = "afhhbcd", Itemprice = 100
};
db.Add(i);
db.SaveChanges();
}
}
public IActionResult EntrollStudent(EnrollStudentPayload payload)
{
if (
String.IsNullOrEmpty(payload.IndexNumber) ||
String.IsNullOrEmpty(payload.FirstName) ||
String.IsNullOrEmpty(payload.LastName) ||
String.IsNullOrEmpty(payload.BirthDate) ||
String.IsNullOrEmpty(payload.Studies)
)
{
return(BadRequest("Wypełnij wszystkie dane"));
}
var context = new masterContext();
var study = context.Studies.Single(s => s.Name.Equals(payload.Studies));
if (study == null)
{
return(BadRequest("Nie ma takich studiów"));
}
var enrollment = context.Enrollment
.Where(e => e.Semester.Equals(1))
.SingleOrDefault(e => e.IdStudy.Equals(study.IdStudy));
if (enrollment == null)
{
enrollment = new Enrollment
{
Semester = 1,
IdStudy = study.IdStudy,
StartDate = DateTime.Now
};
context.Enrollment.Add(enrollment);
context.SaveChanges();
}
var student = new Student
{
IndexNumber = payload.IndexNumber,
FirstName = payload.FirstName,
LastName = payload.LastName,
BirthDate = DateTime.Parse(payload.BirthDate),
Role = "student",
IdEnrollment = enrollment.IdEnrollment
};
context.Student.Add(student);
context.SaveChanges();
return(Ok("Enrolled"));
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
using (var dbcontext = new masterContext())
{
List <Customer> customers = dbcontext.Customers.ToList();
foreach (var c in customers)
{
System.Console.WriteLine(c.FirstName);
}
}
}
public AnimalTypeType()
{
Field(x => x.TypeId);
Field(x => x.TypeName);
Field(x => x.Pets, type: typeof(ListGraphType <PetsType>))
.Resolve(
context => {
masterContext masterContext = (masterContext)context.UserContext;
return(masterContext.Pets.Where(x => x.TypeId == context.Source.TypeId).ToList());
}
);
}
public async Task <ActionResult <AnimalType> > UpdateType(int id, [FromBody] AnimalType value)
{
using (masterContext context = new masterContext())
{
AnimalType animalType = await context.AnimalType.Where(p => p.TypeId == id).FirstOrDefaultAsync();
animalType.TypeName = value.TypeName;
var editedType = context.AnimalType.Update(animalType);
await context.SaveChangesAsync();
return(editedType.Entity);
}
}
public PersonType()
{
Field(x => x.Id);
Field(x => x.Name);
Field(x => x.LastName);
Field(x => x.Miemployee, type: typeof(BooleanGraphType));
Field(x => x.Pets, type: typeof(ListGraphType <PetsType>))
.Resolve(
context => {
masterContext masterContext = (masterContext)context.UserContext;
return(masterContext.Pets.Where(x => x.OwnerId == context.Source.Id).ToList());
}
);
}
public PetsType()
{
Field(x => x.PetId);
Field(x => x.OwnerId, type: typeof(IntGraphType));
Field(x => x.PetName);
Field(x => x.TypeId, type: typeof(IntGraphType));
Field(x => x.Type, type: typeof(AnimalTypeType))
.Resolve(
context => {
masterContext masterContext = (masterContext)context.UserContext;
return(masterContext.AnimalType.Where(x => x.TypeId == context.Source.TypeId).FirstOrDefault());
}
);
}
public async Task <ActionResult <Pets> > UpdatePet(int id, [FromBody] Pets value)
{
using (masterContext context = new masterContext())
{
Pets pet = await context.Pets.Where(p => p.PetId == id).FirstOrDefaultAsync();
pet.OwnerId = value.OwnerId;
pet.TypeId = value.TypeId;
pet.PetName = value.PetName;
var editedPet = context.Pets.Update(pet);
await context.SaveChangesAsync();
return(editedPet.Entity);
}
}
public IActionResult promote(PromoteStudentsPayload payload)
{
var context = new masterContext();
var study = context.Studies.Single(s => s.Name.Equals(payload.Studies));
if (study == null)
{
return(BadRequest("Nie ma takich studiów"));
}
var oldEnrolment = context.Enrollment
.Where(e => e.Semester.Equals(payload.Semester))
.SingleOrDefault(e => e.IdStudy.Equals(study.IdStudy));
if (oldEnrolment == null)
{
return(BadRequest("Nie znaleziono zapisów na podane studia"));
}
var newEnrolment = context.Enrollment
.Where(e => e.Semester.Equals(payload.Semester + 1))
.SingleOrDefault(e => e.IdStudy.Equals(study.IdStudy));
if (newEnrolment == null)
{
var newEnrollment = new Enrollment()
{
Semester = oldEnrolment.Semester + 1,
IdStudy = study.IdStudy,
StartDate = DateTime.Now
};
context.Enrollment.Add(newEnrolment);
context.SaveChanges();
}
var studentsToPromote = context.Student.Where(s => s.IdEnrollment.Equals(oldEnrolment.IdEnrollment))
.AsEnumerable();
foreach (var student in studentsToPromote)
{
student.IdEnrollment = newEnrolment.IdEnrollment;
}
context.SaveChanges();
return(Ok("All students promoted :)"));
}
public IActionResult PutStudent(PutStudentPayload payload, string indexNumber)
{
var context = new masterContext();
var studentInDb = context.Student.Find(indexNumber);
if (studentInDb == null)
{
return(NotFound());
}
studentInDb.FirstName = payload.FirstName ?? studentInDb.FirstName;
studentInDb.LastName = payload.LastName ?? studentInDb.LastName;
studentInDb.BirthDate = payload.BirthDate ?? studentInDb.BirthDate;
context.SaveChanges();
return(Ok("Aktualizacja zakończona"));
}
public IActionResult CreateStudent(CreateStudentPayload payload)
{
var context = new masterContext();
var student = new Student
{
BirthDate = payload.BirthDate,
FirstName = payload.FirstName,
LastName = payload.LastName,
Role = payload.Role,
IndexNumber = payload.IndexNumber,
};
context.Student.Add(student);
context.SaveChanges();
return(Ok(student));
}
