static void Main(string[] args)
{
StudentsDB studentsDB = new StudentsDB();
//Console.WriteLine(studentsDB.ConnectionString);
try
{
//studentsDB.SelectDB("SELECT * FROM Persons;");
Person person = new Person
{
LastName = "Lansakaya",
FirstName = "Natalina",
Birthday = new DateTime(1986, 2, 14),
GroupId = 1
};
//добавили нашего студента
studentsDB.PersonInsert(person);
//посмотрели нашего студента
//studentsDB.SelectDB("SELECT * FROM Persons;");
//studentsDB.PersonDelete(7);
studentsDB.PersonUpdate(8, "Beam");
studentsDB.SelectDB("SELECT * FROM Persons;");
Console.WriteLine(studentsDB.RecordCount("Persons"));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.ReadKey();
}
static void Main(string[] args)
{
StudentsDB studentsDB = new StudentsDB();
//Console.WriteLine(studentsDB.ConnectionString);
try
{
//studentsDB.SelectDB("SELECT * FROM Persons;");
Person person = new Person
{
LastName = "Miller",
FirstName = "Glenn",
Birthday = new DateTime(1997, 6, 18),
GroupId = 2
};
//добавили нашего студента
//studentsDB.PersonInsert(person);
//посмотрели нашего студента
//studentsDB.SelectDB("SELECT * FROM Persons;");
studentsDB.PersonDelete(7);
studentsDB.SelectDB("SELECT * FROM Persons;");
Console.WriteLine(studentsDB.RecordCount("Persons"));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.ReadKey();
}
public ActionResult Post([FromBody] StudentsDB studentDB)
{
data.Student.Add(studentDB);
data.SaveChanges();
// CreatedAtRouteResult = funcion de ASP.Net para redireccionar lo que agrega
return(new CreatedAtRouteResult("Student", new { id = studentDB.id }, studentDB));
}
public Authorisation()
{
var startup = new Startup();
InitializeComponent();
StudentsDB.InitiliseDelegates(TableDBWorkerService.WriteInFile, TableDBWorkerService.ReadFromFile <Account>);
}
static void Main(string[] args)
{
using (var db = new StudentsDB())
{
//db.Database.Log = str => Console.WriteLine("EF>> {0}", str);
var students_count = db.Students.Count();
Console.WriteLine("Students in DB: {0}", students_count);
}
using (var db = new StudentsDB())
if (!db.Groups.Any())
{
var student_n = 1;
for (var group_n = 1; group_n <= 10; group_n++)
{
var group = new StudentsGroup
{
Name = $"Group {group_n}"
};
for (var i = 0; i < 10; i++)
{
var student = new Student
{
Name = $"Student {student_n}",
Surname = $"Surname {student_n}",
Patronymic = $"Patronymic {student_n}",
};
group.Students.Add(student);
student_n++;
//db.Students.Add(student); // в этом нет необходимости!
}
db.Groups.Add(group);
}
db.Database.Log = str => Console.WriteLine("EF>> {0}", str);
db.SaveChanges();
}
using (var db = new StudentsDB())
{
db.Database.Log = str => Console.WriteLine("EF>> {0}", str);
var students_group_id_7 = db.Students
//.Include(student => student.Group)
.Where(student => student.Group.Id == 7).ToArray();
Console.ReadLine();
Console.WriteLine(students_group_id_7[0].Group.Name);
}
Console.ReadLine();
}
void AddStudentToDB()
{
var studentsDB = new StudentsDB();
studentsDB.addStudent(new Student(Name, Family, MdlName, StudGroup, Login, Passw, Ipaddress, 0));
studentsDB.close();
// MenuUIManager.Instance.OpenTaskPanel();
MenuUIManager.Instance.OpenTaskPanel();
}
public ActionResult Put(int id, [FromBody] StudentsDB value)
{
if (id != value.id)
{
return(BadRequest());
}
data.Entry(value).State = EntityState.Modified;
data.SaveChanges();
return(Ok());
}
public IHttpActionResult Get()
{
try
{
return(Ok(StudentsDB.GetAllStudents()));
}
catch (Exception ex)
{
//return BadRequest(ex.Message);
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
public void StatsGeneralVisualization()
{
var sessionsDB = new SessionsDB();
successCompletedTrainingsCounter.text = sessionsDB.getNumberCompletedSessions().ToString();
runningTrainingsCounter.text = sessionsDB.getNumberRunningSessions().ToString();
sessionsDB.close();
var studentsDB = new StudentsDB();
registeredStudentsCounter.text = studentsDB.getNumberRegisteredStudents().ToString();
studentsDB.close();
}
//[EnableCors( "*", "*", "*")]
public IHttpActionResult Get()
{
try
{
return(Ok(StudentsDB.GetAllStudents()));
}
catch (Exception ex)
{
//return BadRequest(ex.Message);
return(BadRequest("could not get all the students!\n -- " + ex.Message));
//return Content(HttpStatusCode.BadRequest,ex);
}
}
private void userLoginButton_Click(object sender, EventArgs e)
{
if (firstNameTB.TextLength != 0 && secondNameTB.TextLength != 0 && groupTB.TextLength != 0)
{
sdb = new StudentsDB();
sdb.insert_student(secondNameTB.Text, firstNameTB.Text, groupTB.Text);
//sdb.show_students();
this.result = true;
this.Close();
}
else
{
MessageBox.Show("Пожалуйста, заполните все поля формы входа.", "Не все поля заполнены", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public IHttpActionResult Get(int id)
{
try
{
Student res = StudentsDB.GetStudentById(id);
if (res == null)
{
return(Content(HttpStatusCode.NotFound, $"student with id= {id} was not found!"));
}
return(Ok(res));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
//[DisableCors]
public IHttpActionResult Post([FromBody] Student val)
{
//return StudentsDB.GetStudentByEmailAndPassword(val.Email, val.Password);
try
{
Student res = StudentsDB.InsertStudentToDb(val);
if (res == null)
{
return(Content(HttpStatusCode.BadRequest, $"could not insert student {val.ToString()} or already exists !"));
}
return(Created(new Uri(Url.Link("GetStudentById", new { id = res.ID })), res));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public void SpawnStudentsTP()
{
studentChangableButtons.Clear();
foreach (Transform child in SLListContentTP.transform)
{
Destroy(child.gameObject);
}
var studentsDB = new StudentsDB();
var reader = studentsDB.getAllStudents();
var i = 0;
while (reader.Read())
{
SpawnStudentTP(i, Convert.ToInt32(reader[0]), reader[1].ToString(), reader[2].ToString(),
reader[3].ToString(), reader[4].ToString(), reader[5].ToString(), Convert.ToInt32(reader[8]));
i++;
}
studentsDB.close();
}
public void SpawnStudentsL()
{
foreach (Transform child in SLListContentL.transform)
{
Destroy(child.gameObject);
}
var studentsDB = new StudentsDB();
var reader = studentsDB.getAllStudents();
var i = 0;
while (reader.Read())
{
SpawnStudentL(i, Convert.ToInt32(reader[0]), reader[1].ToString(), reader[2].ToString(),
reader[3].ToString(), reader[4].ToString(), reader[5].ToString(),
reader[6].ToString(), reader[7].ToString(), Convert.ToInt32(reader[8]));
i++;
}
studentsDB.close();
}
public IHttpActionResult LoginUser([FromBody] Student loginStudent)
{
try
{
Student s = StudentsDB.LoginUser(loginStudent.Email, loginStudent.Password);
if (s != null)
{
return(Ok(s));
}
else
{
return(Content(HttpStatusCode.NotFound, $"student with email={loginStudent.Email} and pass={loginStudent.Password} was not found for login!"));
}
}
catch (Exception ex)
{
return(Content(HttpStatusCode.InternalServerError, ex));
}
}
public static void UnloadButtonStudentClick(int studentDbId)
{
var studentsDB = new StudentsDB();
var outputFile = new StringBuilder();
var reader = studentsDB.findStudentById(studentDbId);
reader.Read();
var id = Convert.ToInt32(reader[0]);
var name = reader[1].ToString();
var family = reader[2].ToString();
var mdlName = reader[3].ToString();
var studGroup = reader[4].ToString();
var login = reader[5].ToString();
var password = reader[6].ToString();
var ipaddress = reader[7].ToString();
outputFile.AppendLine("");
outputFile.AppendLine("Студент:");
outputFile.AppendLine("");
var newLine = string.Format("Id: {0}", id);
outputFile.AppendLine(newLine);
newLine = string.Format("Имя: {0}", name);
outputFile.AppendLine(newLine);
newLine = string.Format("Отчество: {0}", mdlName);
outputFile.AppendLine(newLine);
newLine = string.Format("Фамилия: {0}", family);
outputFile.AppendLine(newLine);
newLine = string.Format("Группа: {0}", studGroup);
outputFile.AppendLine(newLine);
newLine = string.Format("Логин: {0}", login);
outputFile.AppendLine(newLine);
newLine = string.Format("Пароль (MD5): {0}", password);
outputFile.AppendLine(newLine);
newLine = string.Format("IP адрес: {0}", ipaddress);
outputFile.AppendLine(newLine);
var outputFileFilePath = "c:\\" + login + "_student.txt";
File.WriteAllText(outputFileFilePath, outputFile.ToString());
reader.Close();
studentsDB.close();
}
private void SLFindNameChangedL(string currInput)
{
foreach (Transform child in SLListContentL.transform)
{
Destroy(child.gameObject);
}
var studentsDB = new StudentsDB();
var reader = studentsDB.findStudentsLike(currInput);
var i = 0;
while (reader.Read())
{
SpawnStudentL(i, Convert.ToInt32(reader[0]), reader[1].ToString(), reader[2].ToString(),
reader[3].ToString(), reader[4].ToString(), reader[5].ToString(),
reader[6].ToString(), reader[7].ToString(), Convert.ToInt32(reader[8]));
i++;
}
;
studentsDB.close();
}
public IHttpActionResult Delete(int id)
{
try
{
Student s = StudentsDB.GetStudentById(id);
if (s != null)
{
int res = StudentsDB.DeleteStudentById(id);
if (res == 1)
{
return(Ok());
}
return(Content(HttpStatusCode.BadRequest, $"student with id {id} exsits but could not be deleted!!!"));
}
return(Content(HttpStatusCode.NotFound, "student with id = " + id + " was not found to delete!!!"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult Put(Student student2Update)
{
try
{
Student s = StudentsDB.GetStudentById(student2Update.ID);
if (s != null)
{
int res = StudentsDB.UpdateStudent(student2Update);
if (res == 1)
{
return(Ok());
}
return(Content(HttpStatusCode.NotModified, $"student with id {student2Update.ID} exsits but could not be modified!!!"));
}
return(Content(HttpStatusCode.NotFound, "student with id = " + student2Update.ID + " was not found to update!!!"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public void SpawnStudentsS()
{
SLFindName.onValueChanged.AddListener(currInput => SLFindNameChangedStudentsS(currInput));
foreach (Transform child in SLListContent.transform)
{
Destroy(child.gameObject);
}
var studentsDB = new StudentsDB();
var reader = studentsDB.getAllStudents();
var i = 0;
while (reader.Read())
{
SpawnStudentS(i, Convert.ToInt32(reader[0]), reader[1].ToString(), reader[2].ToString(),
reader[3].ToString(), reader[4].ToString(), reader[5].ToString(),
reader[6].ToString(), Convert.ToInt32(reader[8]));
i++;
}
studentsDB.close();
toggleAllButtons.PrefabType = 2;
unloadAllChecked.IsTeacher = false;
toggleAllButtons.AnalizeChecks();
}
private void Switch()
{
if (isInGroup)
{
return;
}
isOn = !isOn;
tickImage.gameObject.SetActive(isOn);
if (isTeacher)
{
var teachersDB = new TeachersDB();
teachersDB.checkTeacher(userDbId, isOn);
teachersDB.close();
}
else
{
var studentsDB = new StudentsDB();
studentsDB.checkStudent(userDbId, isOn);
studentsDB.close();
}
toggleAllButtons.AnalizeChecks();
}
public StudentsController(StudentsDB context)
{
_context = context;
}
//opt1 - time efficient
//[DisableCors]
public Student Get(string email, string password)
{
return(StudentsDB.GetStudentByEmailAndPassword(email, password));
}
public UniversitiesController(StudentsDB context)
{
_context = context;
}
public EditSurveyController(StudentsDB context)
{
_context = context;
}
static void Main(string[] args)
{
using (var db = new StudentsDB())
{
//db.Database.Log = str => Console.WriteLine("EF>> {0}", str);
var students_count = db.Students.Count();
Console.WriteLine("Количество студентов в БД {0}", students_count);
}
using (var db = new StudentsDB())
if (db.Groups.Count() == 0)
{
var students_n = 1;
for (var i = 1; i <= 10; i++)
{
var group = new Group
{
Name = $"Группа {i}",
Students = new List <Student>()
};
for (var j = 0; j < 10; j++)
{
var student = new Student
{
Name = $"Имя {students_n}",
SurName = $"Фамилия {students_n}",
Patronymic = $"Отчество {students_n}",
Birthday = DateTime.Now.Subtract(TimeSpan.FromDays(365 / 4 * (students_n + 10)))
};
students_n++;
group.Students.Add(student);
}
db.Groups.Add(group);
}
db.SaveChanges();
}
//using (var db = new StudentsDB())
//{
// var students_count = db.Students.Count();
// Console.WriteLine("Количество студентов в БД {0}", students_count);
//}
using (var db = new StudentsDB())
if (db.Courses.Count() == 0)
{
var rnd = new Random();
for (var i = 1; i <= 10; i++)
{
var course = new Course
{
Name = $"Курс {i}",
Students = new List <Student>()
};
for (var j = 0; j < 10; j++)
{
var student_id = rnd.Next(1, 101);
if (course.Students.Any(s => s.Id == student_id))
{
continue;
}
var student = db.Students.First(s => s.Id == student_id);
course.Students.Add(student);
}
db.Courses.Add(course);
}
db.SaveChanges();
}
using (var db = new StudentsDB())
{
var empty_courses = db.Courses.Where(course => course.Students.Count() == 0);
foreach (var course in empty_courses)
{
Console.WriteLine(course.Name);
}
var empty_students = db.Students.Where(student => student.Courses.Count() == 0);
foreach (var student in empty_students)
{
Console.WriteLine("[{0}] {1} {2} {3} {4}",
student.Id,
student.SurName,
student.Name,
student.Patronymic,
student.Birthday);
}
Console.WriteLine("Студентов без курсов {0}", empty_students.Count());
var course_info = db.Courses.Select(course => new
{
CourseName = course.Name,
StudentsCount = course.Students.Count(),
StudentNames = course.Students.Select(student => student.Name)
});
foreach (var info in course_info)
{
Console.WriteLine("{0}({1}) - {2}",
info.CourseName, info.StudentsCount, string.Join(",", info.StudentNames));
}
}
Console.WriteLine("Конец...");
Console.ReadLine();
}
public Startup()
{
ConfigureServices();
StudentsDB.InitiliseDelegates(TableDBWorkerService.WriteInFile, TableDBWorkerService.ReadFromFile <Account>);
}
static async Task Main(string[] args)
{
const string connection_str = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Students.DB;Integrated Security=True";
//var service_collection = new ServiceCollection();
//service_collection.AddDbContext<StudentsDB>(opt => opt.UseSqlServer(connection_str));
//var services = service_collection.BuildServiceProvider();
//new DbContextOptionsBuilder().sq
//new StudentsDB()
//using (var db = services.GetRequiredService<StudentsDB>())
//{
//}
using (var db = new StudentsDB(new DbContextOptionsBuilder <StudentsDB>().UseSqlServer(connection_str).Options))
{
//await db.Database.EnsureCreatedAsync();
await db.Database.MigrateAsync();
var students_count = await db.Students.CountAsync();
Console.WriteLine("Число студентов в БД = {0}", students_count);
}
using (var db = new StudentsDB(new DbContextOptionsBuilder <StudentsDB>().UseSqlServer(connection_str).Options))
{
var k = 0;
if (await db.Students.CountAsync() == 0)
{
for (var i = 0; i < 10; i++)
{
var group = new Group
{
Name = $"Группа {i}",
Description = $"Описание группы {i}",
Students = new List <Student>()
};
for (var j = 0; j < 10; j++)
{
var student = new Student
{
Name = $"Студент {k}",
Surname = $"Surname {k}",
Patronymic = $"Patronymic {k}",
//Description = $"Description {k}"
};
k++;
group.Students.Add(student);
}
await db.Groups.AddAsync(group);
}
await db.SaveChangesAsync();
}
}
using (var db = new StudentsDB(new DbContextOptionsBuilder <StudentsDB>().UseSqlServer(connection_str).Options))
{
var students = await db.Students.
Include(s => s.Group).
Where(s => s.Group.Name == "Группа 5").
ToArrayAsync();
foreach (var student in students)
{
Console.WriteLine("[{0}] {1} - {2}", student.Id, student.Name, student.Group.Name);
}
}
Console.WriteLine("Главный поток работу закончил!");
Console.ReadLine();
}
