public ArtistEvent UpdateArtistEvent(int id, int idEvent, ArtistEvent artistEventRequest)
{
var artistEventExist = _context.ArtistEvent.Where(e => e.IdEvent == idEvent && e.IdArtist == id).Any();
if (!artistEventExist)
{
throw new Exception($"Nie ma eventu w ktorym wystepuje artysta z id = {id} oraz eventu z id = {idEvent}");
}
else
{
var artistEvent = _context.Event.Where(e => e.IdEvent == idEvent).Single();
if (artistEvent.StartDate < artistEventRequest.PerformanceDate && artistEvent.EndDate > artistEventRequest.PerformanceDate)
{
var e1 = new ArtistEvent
{
IdArtist = id,
IdEvent = idEvent,
PerformanceDate = artistEventRequest.PerformanceDate
};
_context.Attach(e1);
_context.Entry(e1).Property("PerformanceDate").IsModified = true;
_context.SaveChanges();
}
else
{
throw new Exception($"Nieprawidlowa data, lub data nie miesci sie pomiedzy rozpoczeciem eventu a jego zakonczeniem.");
}
}
return(artistEventRequest);
}
public IActionResult DeleteStudent(string id)
{
var db = new s17188Context();
var s = db.Student.Where(s => s.IndexNumber == id).First();
db.Student.Remove(s);
db.SaveChanges();
return(Ok("Usuwanie ukonczone"));
}
public IActionResult UpdateStudent(ModelsGenerated.Student student, string id)
{
var db = new s17188Context();
var s1 = new ModelsGenerated.Student
{
IndexNumber = id,
FirstName = student.FirstName
};
db.Attach(s1);
db.Entry(s1).Property("FirstName").IsModified = true;
db.SaveChanges();
return(Ok(s1));
}
public EnrollStudentResponse EnrollStudent(EnrollStudentRequest enrollStudent)
{
var db = new s17188Context();
EnrollStudentResponse response = new EnrollStudentResponse();
response.LastName = enrollStudent.LastName;
response.IndexNumber = enrollStudent.IndexNumber;
var std = new EnrollStudentRequest();
std.IndexNumber = enrollStudent.IndexNumber;
std.FirstName = enrollStudent.FirstName;
std.LastName = enrollStudent.LastName;
std.BirthDate = enrollStudent.BirthDate.Replace('.', '/');
std.Studies = enrollStudent.Studies;
response.status = "Ok";
DateTime myDateTime = Convert.ToDateTime(std.BirthDate);
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff");
var study = db.Studies
.Where(s => s.Name == std.Studies);
if (study.Count() == 0)
{
response.status = "Studia nie istnieja";
}
int idstudies = study.Single().IdStudy;
var enrollment = db.Enrollment
.Where(e => e.IdStudy == idstudies)
.OrderBy(e => e.StartDate);
int idenrollment;
DateTime localDate;
if (enrollment.Count() == 0)
{
response.status = "Semestr nie istnieje";
Random random = new Random();
localDate = DateTime.Now;
int num = random.Next(4, 20);
idenrollment = num;
var newEnrollment = new ModelsGenerated.Enrollment
{
IdEnrollment = idenrollment,
Semester = 1,
IdStudy = idstudies,
StartDate = localDate
};
db.Enrollment.Add(newEnrollment);
try
{
db.SaveChanges();
}
catch (Exception exc)
{
response.status = "Semestr istnieje " + exc.Message.ToString();
}
}
else
{
idenrollment = enrollment.Single().IdEnrollment;
localDate = (DateTime)enrollment.Single().StartDate;
}
ModelsGenerated.Enrollment enroll = new ModelsGenerated.Enrollment();
enroll.IdEnrollment = enrollment.FirstOrDefault().IdEnrollment;
enroll.IdStudy = enrollment.First().IdStudy;
enroll.Semester = enrollment.First().Semester;
enroll.StartDate = enrollment.First().StartDate;
response.enrollment = enroll;
response.status = "Student dodany";
var newStudent = new ModelsGenerated.Student
{
IndexNumber = std.IndexNumber,
FirstName = std.FirstName,
LastName = std.LastName,
IdEnrollment = idenrollment,
BirthDate = localDate
};
db.Student.Add(newStudent);
try
{
db.SaveChanges();
}
catch (Exception exc)
{
response.status = "Student istnieje lub wystapil blad w bazie: " + exc.Message.ToString();
}
return(response);
//using (SqlConnection con = new SqlConnection(DataSQLCon))
//using (SqlCommand com = new SqlCommand())
//{
// com.Connection = con;
// con.Open();
// var tran = con.BeginTransaction();
// try
// {
// com.CommandText = "select idStudy from Studies where Name=@Name";
// com.Parameters.AddWithValue("Name", std.Studies);
// com.Transaction = tran;
// var stud = com.ExecuteReader();
// if (!stud.Read())
// {
// tran.Rollback();
// response.status = "Studia nie istnieja";
// }
// int idstudies = (int)stud["idStudy"];
// stud.Close();
// System.Diagnostics.Debug.WriteLine("STUD AFTER");
// com.CommandText = "select idEnrollment,StartDate from Enrollment where idStudy=@idStudy order by StartDate";
// com.Parameters.AddWithValue("idStudy", idstudies);
// int idenrollment;
// DateTime localDate;
// var enroll = com.ExecuteReader();
// if (!enroll.Read())
// {
// response.status = "Semestr nie istnieje";
// Random random = new Random();
// localDate = DateTime.Now;
// int num = random.Next(4,20);
// idenrollment = num;
// com.CommandText = "INSERT INTO Enrollment VALUES(@id,@Semestr,@IdStudies,@StartDate)";
// com.Parameters.AddWithValue("id", num);
// com.Parameters.AddWithValue("Semestr", 1);
// com.Parameters.AddWithValue("IdStudies", idstudies);
// com.Parameters.AddWithValue("StartDate", localDate);
// enroll.Close();
// System.Diagnostics.Debug.WriteLine("SEMM");
// com.ExecuteNonQuery();
// }
// else
// {
// idenrollment = (int)enroll["IdEnrollment"];
// localDate = (DateTime)enroll["StartDate"];
// enroll.Close();
// }
// try
// {
// Models.Enrollment enrollment = new Models.Enrollment();
// enrollment.IdEnrollment = idenrollment;
// enrollment.IdStudy = idstudies;
// enrollment.Semester = 1;
// enrollment.StartDate = localDate.ToString();
// response.enrollment = enrollment;
// com.CommandText = "select IndexNumber from Student where IndexNumber=@IndexNumber";
// com.Parameters.AddWithValue("IndexNumber", std.IndexNumber);
// response.status = "Student dodany";
// com.CommandText = "INSERT INTO Student(IndexNumber, FirstName, LastName, BirthDate, idEnrollment) VALUES(@Index, @Fname, @Lname, @Bdate, @idEnrollment)";
// com.Parameters.AddWithValue("Index", std.IndexNumber);
// com.Parameters.AddWithValue("Fname", std.FirstName);
// com.Parameters.AddWithValue("Lname", std.LastName);
// com.Parameters.AddWithValue("idEnrollment", idenrollment);
// com.Parameters.AddWithValue("Bdate", sqlFormattedDate);
// com.ExecuteNonQuery();
// tran.Commit();
// }
// catch (SqlException exc)
// {
// tran.Rollback();
// response.status = "Student istnieje lub wystapil blad w bazie: " + exc.Message.ToString();
// }
// }
// catch (SqlException exc)
// {
// tran.Rollback();
// response.status = exc.Message.ToString();
// }
// return response;
//}
}