// Lista studentilor de la curs
public async Task <IActionResult> StudentList()
{
await transform();
ViewModel A = new ViewModel();
A.Notes = obj.Notes.Where(u => u.CursId == CoursID).ToList();
A.Students = A.Notes.Join(obj.Students,
u => u.StudentId,
p => p.Id,
(u, p) => new Student
{
Id = p.Id,
About = p.About,
Age = p.Age,
Email = p.Email,
FirstName = p.FirstName,
LastName = p.LastName,
Telefon = p.Telefon
}).ToList();
Curs p = obj.Cursuri.FirstOrDefault(u => u.Id == CoursID);
ViewBag.CName = p.Name;
ViewBag.Curs = CoursID;
return(View(A.Students));
}
public ActionResult Edit(int id)
{
Curs curs = db.Cursuri.Find(id);
var cursViewModel = new CursViewModel
{
Curs = db.Cursuri.Include("Profesors").Include("Students").First(c => c.CursId == id),
};
if (cursViewModel.Curs == null)
{
return(HttpNotFound());
}
var allProfsList = db.Profesors.ToList();
cursViewModel.AllProfIds = allProfsList.Select(o => new SelectListItem
{
Text = o.Nume + " " + o.Prenume,
Value = o.ProfesorId.ToString()
});
var allStudentsList = db.Students.ToList();
cursViewModel.AllStudentIds = allStudentsList.Select(o => new SelectListItem
{
Text = o.Nume + " " + o.Prenume,
Value = o.StudentId.ToString()
});
return(View(cursViewModel));
}
// Use this for initialization
void Start()
{
Select_Settings("0");
nCurs = GetComponent <Curs>();
nCam = GameObject.FindObjectOfType(typeof(cam)) as cam;
nMain = GameObject.FindObjectOfType(typeof(main)) as main;
}
public ActionResult GetVideoPCSala(int id)
{
List <Sala> sali = new List <Sala>(_db.Sali.ToList());
List <Curs> _cursuri = new List <Curs>(_db.Cursuri.ToList());
Curs curs = _cursuri.Find(x => x.CursId == id);
List <InscriereCursuri> inscrieri = new List <InscriereCursuri>(_db.InscriereCursuri.ToList());
List <SelectListItem> items = new List <SelectListItem>();
var inscrieri_ = inscrieri.GroupBy(x => x)
.Where(g => g.Count() > 1)
.ToDictionary(x => x.Key, y => y.Count());
if (inscrieri.Count() == 0)
{
var data = sali
.Where(x => x.Libera == true && x.Echipament_Video == true && x.PC == true)
.Select(l => new { Value = l.Id.ToString(), Text = l.Nume });
return(Json(data, JsonRequestBehavior.AllowGet));
}
else
{
InscriereCursuri insc = inscrieri.Find(x => x.ClassId == curs.CursId);
inscrieri_.TryGetValue(insc, out int number);
var data = sali.Where(x => x.Capacitate >= number && x.Libera == true && x.Echipament_Video == true &&
x.PC == true).Select(l => new { Value = l.Id.ToString(), Text = l.Nume });
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit(int id, Curs requestCurs)
{
try
{
if (ModelState.IsValid)
{
Curs curs = db.Curses.Find(id);
if (TryUpdateModel(curs))
{
curs = requestCurs;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(requestCurs));
}
else
{
requestCurs.Profesors = GetAllProfesors();
return(View(requestCurs));
}
}
catch (Exception e)
{
requestCurs.Profesors = GetAllProfesors();
return(View(requestCurs));
}
}
public ActionResult New()
{
Curs curs = new Curs();
var cursViewModel = new CursViewModel
{
Curs = curs,
};
var allProfsList = db.Profesors.ToList();
cursViewModel.AllProfIds = allProfsList.Select(o => new SelectListItem
{
Text = o.Nume + " " + o.Prenume,
Value = o.ProfesorId.ToString()
});
var allStudentsList = db.Students.ToList();
cursViewModel.AllStudentIds = allStudentsList.Select(o => new SelectListItem
{
Text = o.Nume + " " + o.Prenume,
Value = o.StudentId.ToString()
});
if (TempData.ContainsKey("message"))
{
ViewBag.message = TempData["message"].ToString();
}
return(View(cursViewModel));
}
public IActionResult RegisterSuccesCurs()
{
Curs A = new Curs();
A = db.Cursuri.FirstOrDefault(u => u.Id == CursID);
return(View(A));
}
public void ExecuteMethodGet(string methodName, int cod)
{
if (methodName.Equals("GetAllStudents"))
{
GetAllStudents();
}
if (methodName.Equals("GetStudent"))
{
this.student = GetStudent(cod);
}
if (methodName.Equals("GetAllProfesors"))
{
GetAllProfesors();
}
if (methodName.Equals("GetProfesor"))
{
profesor = GetProfesor(cod);
}
if (methodName.Equals("GetAllCurs"))
{
GetAllCurs();
}
if (methodName.Equals("GetCurs"))
{
curs = GetCursById(cod);
}
}
public Curs GetCursById(int id)
{
if (dbCon.OpenConnection() == true)
{
String query = "SELECT * FROM curs WHERE id=@id";
var cmd = new MySqlCommand(query, dbCon.Connection);
cmd.Parameters.AddWithValue("@id", id);
var reader = cmd.ExecuteReader();
if (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
string idString = reader["id"].ToString();
string denumireCurs = reader["Denumire"].ToString();
string nrStudentiString = reader["NrStudenti"].ToString();
string idProfesorString = reader["idProfesor"].ToString();
string descriere = reader["Descriere"].ToString();
int idCurs = Convert.ToInt32(idString);
int nrStudenti = Convert.ToInt32(nrStudentiString);
int idProfesor = Convert.ToInt32(idProfesorString);
Curs curs = new Curs(idCurs, denumireCurs, nrStudenti, idProfesor, descriere);
dbCon.CloseConnection();
return(curs);
}
}
dbCon.CloseConnection();
}
return(null);
}
public List <Curs> GetAllCurs()
{
string query = "SELECT * FROM curs";
List <Curs> cursuri = new List <Curs>();
if (dbCon.OpenConnection() == true)
{
var cmd = new MySqlCommand(query, dbCon.Connection);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
string idString = reader["id"].ToString();
string denumire = reader["Denumire"].ToString();
string nrStudentiString = reader["NrStudenti"].ToString();
string idProfesorString = reader["idProfesor"].ToString();
string descriere = reader["Descriere"].ToString();
int id = Convert.ToInt32(idString);
int nrStudenti = Convert.ToInt32(nrStudentiString);
int idProfesor = Convert.ToInt32(idProfesorString);
Curs curs = new Curs(id, denumire, nrStudenti, idProfesor, descriere);
cursuri.Add(curs);
}
dbCon.CloseConnection();
}
dbCon.CloseConnection();
}
return(cursuri);
}
public List <Curs> GetAllCursOfStudent(int idStudent)
{
List <Curs> curses = new List <Curs>();
if (dbCon.OpenConnection() == true)
{
string query = "SELECT * FROM curs c INNER JOIN student_curs sc ON c.id = sc.idCurs INNER JOIN student s ON sc.idStudent = s.id WHERE s.id = @idStudent";
var cmd = new MySqlCommand(query, dbCon.Connection);
cmd.Parameters.AddWithValue("@idStudent", idStudent);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
string idString = reader["id"].ToString();
string denumire = reader["Denumire"].ToString();
string nrStudentiString = reader["NrStudenti"].ToString();
string idProfesorString = reader["idProfesor"].ToString();
string descriere = reader["Descriere"].ToString();
int id = Convert.ToInt32(idString);
int nrStudenti = Convert.ToInt32(nrStudentiString);
int idProfesor = Convert.ToInt32(idProfesorString);
Curs curs = new Curs(id, denumire, nrStudenti, idProfesor, descriere);
curses.Add(curs);
}
}
dbCon.CloseConnection();
}
return(curses);
}
// GET: Curs/Edit/5
public ActionResult Edit(int id)
{
Curs curs = unitOfWork.CursRepository.GetByID(id);
ListaDepartamente(curs.IDDepartament);
return(View(curs));
}
public ActionResult Edit(int id)
{
Curs curs = db.Curses.Find(id);
curs.Profesors = GetAllProfesors();
return(View(curs));
}
public ActionResult New()
{
Curs curs = new Curs();
curs.Profesors = GetAllProfesors();
return(View(curs));
}
public ActionResult Delete(int id)
{
Curs toDelete = db.Cursuri.Find(id);
List <int> sids = new List <int>();
foreach (var sect in toDelete.Sectiuni)
{
sids.Add(sect.SectiuneId);
}
foreach (int sid in sids)
{
Sectiune sectiune = db.Sectiuni.Find(sid);
List <int> fids = new List <int>();
foreach (var fm in sectiune.FileModels)
{
fids.Add(fm.FileId);
}
foreach (int fid in fids)
{
// delete from server
FileInfo fileInfo = new FileInfo(db.FileModels.Find(fid).FilePath);
if (fileInfo.Exists)
{
fileInfo.Delete();
}
db.FileModels.Remove(db.FileModels.Find(fid));
}
db.Sectiuni.Remove(sectiune);
}
db.Cursuri.Remove(toDelete);
TempData["message"] = "Cursul a fost șters";
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Curs/Create
public ActionResult Create(int id)
{
//ViewBag.IDDepartament = new SelectList(db.Departamente, "IDDepartament", "Nume");
Curs curs = unitOfWork.CursRepository.GetByID(id);
ListaDepartamente(curs.IDDepartament);
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
Curs curs = unitOfWork.CursRepository.GetByID(id);
unitOfWork.CursRepository.Delete(id);
unitOfWork.Save();
return(RedirectToAction("Index"));
}
public ActionResult NewStudentAct(int id, int id1)
{
Curs curs = db.Curses.Find(id);
Student studentul = db.Students.Find(id1);
studentul.Curses.Add(curs);
curs.Students.Add(studentul);
db.SaveChanges();
return(RedirectToAction("NewStudent/" + id.ToString()));
}
// Use this for initialization
void Start()
{
nCurs = GameObject.FindObjectOfType(typeof(Curs)) as Curs;
nMain = GameObject.FindObjectOfType(typeof(main)) as main;
JObj = nMain.currObj;
comp = JObj.AddComponent <TargetJoint2D>();
comp.anchor = transform.localPosition;
comp.target = JObj.transform.TransformPoint(comp.anchor);
nMain.currObj = null;
nCurs.Current_Tex = nCurs.SelectCursore_nact;
}
public ActionResult Show(int id)
{
Curs curs = db.Cursuri.Find(id);
SetAccesRights(curs);
if (TempData.ContainsKey("message"))
{
ViewBag.message = TempData["message"];
}
return(View(curs));
}
public ActionResult Create([Bind(Include = "IDCurs,Titlu,Credite,IDDepartament")] Curs curs)
{
if (ModelState.IsValid)
{
unitOfWork.CursRepository.Insert(curs);
unitOfWork.Save();
return(RedirectToAction("Index"));
}
ListaDepartamente(curs.IDDepartament);
return(View(curs));
}
public ActionResult Edit([Bind(Include = "IDCurs,Titlu,Credite,IDDepartament")] Curs curs)
{
if (ModelState.IsValid)
{
unitOfWork.CursRepository.Update(curs);
unitOfWork.Save();
return(RedirectToAction("Index"));
}
ListaDepartamente(curs.IDDepartament);
// ViewBag.IDDepartament = new SelectList(db.Departamente, "IDDepartament", "Nume", curs.IDDepartament);
return(View(curs));
}
public IActionResult DelCurs(int id)
{
Curs obj = new Curs();
LogCurs obv = new LogCurs();
obj = db.Cursuri.FirstOrDefault(u => u.Id == id);
obv = db.LogCurs.FirstOrDefault(u => u.CursId == id);
db.Cursuri.Remove(obj);
db.LogCurs.Remove(obv);
db.SaveChangesAsync();
return(RedirectToAction("ListCurs"));
}
public ActionResult Edit(int id)
{
Sectiune toEdit = db.Sectiuni.Find(id);
if (!CheckProf(toEdit.Curs))
{
return(RedirectToAction("Show", "Cursuri", new { id = toEdit.Curs.CursId }));
}
Curs curs = toEdit.Curs;
ViewBag.curs = curs;
return(View(toEdit));
}
public IActionResult RegCurs(Curs curs)
{
if (ModelState.IsValid)
{
db.Cursuri.Add(curs);
db.SaveChanges();
CursID = curs.Id;
return(RedirectToAction("RegLogCurs"));
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Exclude = "Id")] Curs cursToAdd)
{
try
{
_db.Cursuri.Add(cursToAdd);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private static void ListadoCursosOrdenados()
{
otrosMetodos.titulo();
List <Curso> listaOrdenada = bSharp.CursosOrdenados();
foreach (Curso Curs in listaOrdenada)
{
Console.WriteLine("Curso: " + Curs.ToString());
int cantidadInscripciones = bSharp.cantidadInscripcionesXCurso(Curs);
Console.WriteLine("Número de Inscripciones: " + cantidadInscripciones + "\n");
}
Console.ReadKey();
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Curs curs = _db.Cursuri.Find(id);
if (curs == null)
{
return(HttpNotFound());
}
return(View(curs));
}
public ActionResult Delete(int id)
{
try
{
Curs curs = db.Curses.Find(id);
db.Curses.Remove(curs);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(RedirectToAction("Index"));
}
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
Curs = await _context.Curs.FirstOrDefaultAsync(m => m.ID == id);
if (Curs == null)
{
return(NotFound());
}
return(Page());
}
