private float GetValueOf(Stud key)
{
switch (key)
{
case Stud.Id:
return(Id);
case Stud.Grade:
return(Grade);
case Stud.Class:
return(Class);
case Stud.Attempts:
return(Attempts.Count);
case Stud.Fails:
return(Attempts.Count(x => !x.Success));
case Stud.Succeeds:
return(Attempts.Count(x => x.Success));
case Stud.SuccessRatio:
return(Attempts.Count(x => x.Success) / (float)Attempts.Count());
case Stud.FailRatio:
return(Attempts.Count(x => !x.Success) / (float)Attempts.Count());
default:
throw new Exception("Enumeration not implemented yet");
}
}
public void CancelChanges()
{
if (IsNew)
{
Code = 0;
Title = null;
Teacher = null;
DaysOfWeek = 0;
StartDate = new DateTime(0001, 01, 01);
FinishDate = new DateTime(0001, 01, 01);
RaisePropertyChanged(nameof(Course));
}
else
{
var change = (from c in App.Model.ChangeTracker.Entries <Course>()
where c.Entity == Course
select c).FirstOrDefault();
if (change != null)
{
change.Reload();
RaisePropertyChanged(nameof(Title));
RaisePropertyChanged(nameof(Teacher));
RaisePropertyChanged(nameof(DaysOfWeek));
RaisePropertyChanged(nameof(StartDate));
RaisePropertyChanged(nameof(FinishDate));
RaisePropertyChanged(nameof(StartTime));
RaisePropertyChanged(nameof(EndTime));
Stud.RefreshFromModel(Course.Student);
Students.RefreshFromModel(Course.Student);
NonStudents.RefreshFromModel(AllStudents.Except(Students));
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("MbrStud,ImeStud,PrezStud,PbrRod,PbrStan,DatRodStud,JmbgStud")] Stud stud)
{
if (id != stud.MbrStud)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(stud);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudExists(stud.MbrStud))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["PbrRod"] = new SelectList(_context.Mjestos, "Pbr", "NazMjesto", stud.PbrRod);
ViewData["PbrStan"] = new SelectList(_context.Mjestos, "Pbr", "NazMjesto", stud.PbrStan);
return(View(stud));
}
public Stud Update(Stud studChanges)
{
var stud = Context.Students.Attach(studChanges);
stud.State = Microsoft.EntityFrameworkCore.EntityState.Modified;
Context.SaveChanges();
return(studChanges);
}
public ActionResult DeleteConfirmed(int id)
{
Stud stud = db.Studs.Find(id);
db.Studs.Remove(stud);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void AddStudent(params Student[] Stud)
{
Console.WriteLine("Counting:{0}", Stud.Count());
Console.ReadLine();
foreach (Student stud in Stud)
{
Student.Add(stud);
}
}
//public void AddStud([FromBody] Stud student) => studentRepository.Add(student);
public ActionResult <Stud> PostStud(Stud stud)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid Data"));
}
studentRepository.AddStud(stud);
return(Ok("Added Successfully."));
}
public ActionResult Edit(Stud stud)
{
if (ModelState.IsValid)
{
db.Entry(stud).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stud));
}
//
// GET: /Stud/Delete/5
public ActionResult Delete(int id = 0)
{
Stud stud = db.Studs.Find(id);
if (stud == null)
{
return(HttpNotFound());
}
return(View(stud));
}
public ActionResult Edit([Bind(Include = "Id,Name,Age,Mykid,Health,TotalFees,Overmin,Statuspay,Datepay,Monthpay,DateAttend,StatusAttend")] Stud stud)
{
if (ModelState.IsValid)
{
db.Entry(stud).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stud));
}
public static void Main()
{
Student E = new Student();
E.GetInfo();
Stud Stud = new Stud();
Stud.GetInfo();
Console.ReadLine();
}
public ActionResult Create(Stud stud)
{
if (ModelState.IsValid)
{
db.Studs.Add(stud);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stud));
}
public async Task <IActionResult> Create([Bind("MbrStud,ImeStud,PrezStud,PbrRod,PbrStan,DatRodStud,JmbgStud")] Stud stud)
{
if (ModelState.IsValid)
{
_context.Add(stud);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["PbrRod"] = new SelectList(_context.Mjestos, "Pbr", "NazMjesto", stud.PbrRod);
ViewData["PbrStan"] = new SelectList(_context.Mjestos, "Pbr", "NazMjesto", stud.PbrStan);
return(View(stud));
}
public void insertIntoStud(Stud stud)
{
try
{
studentContext context = new studentContext();
context.Stud.Add(stud);
context.SaveChanges();
}
catch (System.Exception e)
{
throw new Exception(e.Message);
}
}
static void Main(string[] args)
{
StudentDAO studentDAO = new StudentDAO();
// try
// {
// StudentDAO studentDAO = new StudentDAO();
// Stud stud = new Stud();
// stud.Sid = "2001";
// stud.Fname = "Kashish";
// stud.Dob = Convert.ToDateTime("10-10-2000");
// studentDAO.insertIntoStud(stud);
// System.Console.WriteLine("Data Added");
// }
// catch (System.Exception e)
// {
// System.Console.WriteLine(e.Message);
// throw;
// }
// try
// {
// IEnumerable<Stud> students = studentDAO.getAllStudentsList("1005");
// foreach (var item in students)
// {
// System.Console.WriteLine(item.Sid + item.Fname + item.Dob);
// }
// }
// catch (System.Exception e)
// {
// System.Console.WriteLine(e.Message);
// }
try
{
// IEnumerable<Stud> students = studentDAO.getAllStudentsList("1005");
// foreach (var item in students)
// {
// System.Console.WriteLine(item.Sid + item.Fname + item.Dob);
// }
Stud st = new Stud();
st.Sid = "1001";
st.Fname = "Kandarp";
//studentDAO.updateStudent(st);
studentDAO.deleteStudent(st);
}
catch (System.Exception e)
{
System.Console.WriteLine(e.Message);
}
}
public Stud AddStud(Stud stud)
{
var students = new Stud()
{
StudId = stud.StudId,
Name = stud.Name,
PhoneNumber = stud.PhoneNumber,
Address = stud.Address,
};
Context.Set <Stud>().Add(stud);
Context.SaveChanges();
return(stud);
}
// GET: Studs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Stud stud = db.Studs.Find(id);
if (stud == null)
{
return(HttpNotFound());
}
return(View(stud));
}
public string CreateStudent([FromBody] Student student)
{
try
{
Console.WriteLine(student.ToString());
Stud.insert(student);
return("Student created successfully");
}
catch (System.Exception error)
{
return("Eroare: " + error.Message);
throw;
}
}
public void updateStudent(Stud student)
{
try
{
using (var db = new studentContext())
{
var std = db.Stud.First(x => x.Sid == student.Sid);
std.Fname = student.Fname;
db.SaveChanges();
}
}
catch (System.Exception)
{
throw;
}
}
public void deleteStudent(Stud student)
{
try
{
using (var db = new studentContext())
{
var std = db.Stud.First(x => x.Sid == student.Sid);
db.Stud.Remove(std);
db.SaveChanges();
}
}
catch (System.Exception)
{
throw;
}
}
static void Main(string [] args)
{
int i;
List <Stud> myset = new List <Stud>();
Stud s1 = new Stud();
s1.sno = 101; s1.sname = "黎明";
myset.Add(s1);
Stud s2 = new Stud();
s2.sno = 103; s2.sname = "王宏";
myset.Add(s2);
Stud s3 = new Stud();
s3.sno = 108; s3.sname = "那英";
myset.Add(s3);
Stud s4 = new Stud();
s4.sno = 105; s4.sname = "张伟";
myset.Add(s4);
Console.WriteLine("元素序列：");
Console.WriteLine(" 下标 学号 姓名");
i = 0;
foreach (Stud st in myset)
{
Console.WriteLine(" {0} {1} {2}", i, st.sno, st.sname);
i++;
}
Console.WriteLine("容量：{0}", myset.Capacity);
Console.WriteLine("元素个数：{0}", myset.Count);
Console.WriteLine("在索引2处插入一个元素");
Stud s5 = new Stud();
s5.sno = 106; s5.sname = "陈兵";
myset.Insert(2, s5);
Console.WriteLine("元素序列：");
Console.WriteLine(" 下标 学号 姓名");
i = 0;
foreach (Stud st in myset)
{
Console.WriteLine("{ 0} { 1} { 2}", i, st.sname, st.sname);
i++;
}
}
private void InputButton_Click(object sender, RoutedEventArgs e)
{
switch (type)
{
case "man":
if (current < size)
{
men[current].Fio = tb_Name.Text;
current++;
}
break;
case "school":
if (current < size)
{
School sch = new School(tb_Name.Text)
{
Year = int.Parse(tb_Year.Text)
};
men[current] = sch;
current++;
}
break;
case "student":
if (current < size)
{
Stud st = new Stud(tb_Name.Text, int.Parse(tb_Year.Text), tb_VYZ.Text);
men[current] = st;
current++;
}
break;
case "zaoch":
if (current < size)
{
Stud zch = new Stud(tb_Name.Text, int.Parse(tb_Year.Text), tb_VYZ.Text, tb_Reason.Text);
men[current] = zch;
current++;
}
break;
}
}
private void SaveChanges()
{
if (IsNew && Valid() && !HasErrors)
{
App.Model.course.Add(Course);
DateTime Occurence = StartDate;
while ((int)Occurence.DayOfWeek != DaysOfWeek + 1)
{
Occurence = Occurence.AddDays(+1);
}
do
{
CourseOccurrence c = new CourseOccurrence(Occurence, Course);
App.Model.courseoccurrence.Add(c);
Occurence = Occurence.AddDays(+7);
} while (Occurence.CompareTo(FinishDate) <= 0);
IsNew = false;
}
else if (!IsNew && Valid() && !HasErrors)
{
Occurences();
}
if (Stud.Count() < Course.Student.Count())
{
foreach (var m in Course.Student)
{
var presences = App.Model.presence.Where(p => p.Student == m.Id && p.CourseOccurrence.Course.Code == Course.Code).Include("CourseOccurrence.Presence").Include("Students");
App.Model.presence.RemoveRange(presences);
}
Course.Student.Clear();
}
while (Stud.Count != 0)
{
Course.Student.Add(Stud.First());
Stud.Remove(Stud.First());
}
App.Model.SaveChanges();
App.Messenger.NotifyColleagues(App.MSG_COURSE_CHANGED, Course);
CoursesOccurrence.RefreshFromModel(App.Model.courseoccurrence.Where(c => c.Course.Code == Course.Code));
HistoriquePrésences();
Stud = new ObservableCollection <Student>(Course.Student);
}
static void Main(string[] args)
{
//create Students (objects)
Student s1 = new Student("Nick", 19);
Student s2 = new Student("Bella", 18);
Student s3 = new Student("Victor", 21);
Student s4 = new Student("Susie", 20);
s1.Level = "Sophomore";
s3.Level = "Graduate";
s2.Major = "English";
s4.Major = "History";
//create filestream to save the info from ToString() into the file.txt
FileStream f = new FileStream("file.text", FileMode.OpenOrCreate, FileAccess.ReadWrite);
// streamWriter is used to write into the file.txt
StreamWriter s = new StreamWriter(f);
//create an array of students (or list)- to applay methods to each of them
Student[] stud_array = new Student[] { s1, s2, s3, s4 };
//use foreach
foreach (var Stud in stud_array)
{
//Prints out info as a list / from array
Console.WriteLine(Stud.DisplayInformation());
Console.WriteLine("");
Console.WriteLine("---------------------------------------------------------------------------------------------------------------------");
//saves info in the file.txt
Stud.ToString();
//method to write into streamWriter object (s) - after that the file.txt is created with saved info:
s.WriteLine(Stud.ToString());
}
// always close the objects: streamwriter and filestream - after being done with them
s.Close();
f.Close();
Console.WriteLine("Press any key to exit.");
Console.ReadKey();
}
public IHttpActionResult Update(Stud updatedstud)
{
var student = _db.Student.Find(updatedstud.Id);
if (student != null)
{
student.LastName = updatedstud.LastName;
student.Firstname = updatedstud.Firstname;
student.Gender = updatedstud.Gender;
student.SchoolLastAttended = updatedstud.SchoolLastAttended;
_db.Entry(student).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
return(Ok(student));
}
else
{
return(BadRequest("Student not found"));
}
}
public static bool AddDay(int _Day, int _month, int _ID_Teacher, string _Familiya, string _Name, int _Mark)
{
int _ID_Student = 0;
foreach (student Stud in Detki)
{
if (Stud.ReturnFamily() == _Familiya && Stud.ReturnName() == _Name)
{
_ID_Student = Stud.ID;
}
}
if (_ID_Student != 0)
{
Days.Add(new day(_Day, _month, _ID_Teacher, _ID_Student, _Mark));
//Saveinfo();
return(true);
}
else
{
//Saveinfo();
return(false);
}
}
public string DeleteStudentById([FromRoute] int id)
{
Stud.deleteById(id);
return("Student removed successfully");
}
static void Main(string[] args)
{
EntitiesContext context = new EntitiesContext();
StudDAO dao = new StudDAO();
Stud sdao = new Stud();
////Add Students
//sdao = new Stud() { Name = "Bob", Tel = "912345678", Class = "Informática" };
//dao.Add(sdao);
//sdao = new Stud() { Name = "Ale", Tel = "912345679", Class = "Informática" };
//dao.Add(sdao);
//sdao = new Stud() { Name = "Lui", Tel = "912345670", Class = "Informática" };
//dao.Add(sdao);
//sdao = new Stud() { Name = "Jot", Tel = "912345671", Class = "Segurança" };
//dao.Add(sdao);
//Console.WriteLine(Properties.Resources.Add + "\n\n");
//Console.ReadKey();
//Mostrar todos
Console.WriteLine("> Mostrar todos <");
var search = from p in context.Studs select p;
foreach (var stud in search)
{
Console.WriteLine(stud.Name);
}
Console.WriteLine(Properties.Resources.Cons + "\n\n");
Console.ReadKey();
//Mostrar todos + Curso
Console.WriteLine("> Mostrar todos + Curso <");
search = from p in context.Studs select p;
foreach (var stud in search)
{
Console.WriteLine(stud.Name + " from " + stud.Class);
}
Console.WriteLine(Properties.Resources.Cons + "\n\n");
Console.ReadKey();
//Mostrar only Informática
Console.WriteLine("> Mostrar todos de Informática <");
search = from p in context.Studs where (p.Class == "Informática") select p;
IList <Stud> res = search.ToList();
foreach (var stud in res)
{
Console.WriteLine(stud.Name);
}
Console.WriteLine(Properties.Resources.Cons + "\n\n");
Console.ReadKey();
//Order by Tel
Console.WriteLine("> Ordernar por Telefone <");
search = from p in context.Studs orderby p.Tel select p;
res = search.ToList();
foreach (var stud in res)
{
Console.WriteLine(stud.Name + "\tTel: " + stud.Tel);
}
Console.WriteLine(Properties.Resources.Cons + "\n\n");
Console.ReadKey();
//Decrease name order by
Console.WriteLine("> Ordenar, decrescentemente, pelo nome <");
search = from p in context.Studs orderby p.Name descending select p;
res = search.ToList();
foreach (var stud in res)
{
Console.WriteLine(stud.Name + "\tTel: " + stud.Tel);
}
Console.WriteLine(Properties.Resources.Cons + "\n\n");
Console.ReadKey();
//Finaliza
Console.WriteLine(Properties.Resources.Fim);
Console.ReadKey();
}
public void Put(int StudId, [FromBody] Stud stud) => studentRepository.Update(stud);
public void Add(Stud stud)
{
context.Studs.Add(stud);
context.SaveChanges();
}
