public static void InsertData()
{
Console.WriteLine("Add new Student");
Console.Write("StudnetID: ");
int studentID = Int32.Parse(Console.ReadLine());
Console.Write("Student name: ");
string studentName = Console.ReadLine();
Console.Write("Student gender: ");
string studentGender = Console.ReadLine();
Console.Write("Address: ");
string address = Console.ReadLine();
var student = new Student(studentID, studentName, studentGender, address);
using (var db = new StudentDemoEntities())
{
db.Students.Add(student);
db.SaveChanges();
}
Console.WriteLine("Created!!!");
Console.ReadLine();
}
public static void UpdateData()
{
Console.Write("Select student id that you want update information: ");
int studentId = Int32.Parse(Console.ReadLine());
Console.WriteLine("--------------------------------------");
Console.WriteLine("Select information student need update");
Console.WriteLine("1. Update name");
Console.WriteLine("2. Update gender");
Console.WriteLine("3. Update address");
string choice = Console.ReadLine();
switch (choice)
{
case "1":
Console.Write("New Student Name: ");
string StudentNameNew = Console.ReadLine();
using (var db = new StudentDemoEntities())
{
var updateName = (from u in db.Students where u.StudentID == studentId select u).Single();
updateName.StudentName = StudentNameNew;
db.SaveChanges();
}
Console.WriteLine("Update Success!!!");
break;
case "2":
Console.Write("New Student Gender: ");
string StudentGenderNew = Console.ReadLine();
using (var db = new StudentDemoEntities())
{
var updateName = (from u in db.Students where u.StudentID == studentId select u).Single();
updateName.StudentGender = StudentGenderNew;
db.SaveChanges();
}
Console.WriteLine("Update Success!!!");
break;
case "3":
Console.Write("New Student Address: ");
string StudentAddressNew = Console.ReadLine();
using (var db = new StudentDemoEntities())
{
var updateName = (from u in db.Students where u.StudentID == studentId select u).Single();
updateName.Address = StudentAddressNew;
db.SaveChanges();
}
Console.WriteLine("Update Success!!!");
break;
default:
Console.WriteLine("Input from 1 to 3");
Console.ReadLine();
break;
}
}
public static void DeleteData()
{
Console.Write("Input a StudnetID that you want delete: ");
int studentID = Int32.Parse(Console.ReadLine());
using (var db = new StudentDemoEntities())
{
var delete = (from d in db.Students where d.StudentID == studentID select d).Single();
db.Students.Remove(delete);
db.SaveChanges();
}
Console.WriteLine("Deleted!!!");
Console.ReadLine();
}
public static void ViewData()
{
using (var db = new StudentDemoEntities())
{
var select = from s in db.Students select s;
foreach (var data in select)
{
Console.WriteLine("ID: {0}", data.StudentID);
Console.WriteLine("Student name: {0}", data.StudentName);
Console.WriteLine("Student gender: {0}", data.StudentGender);
Console.WriteLine("Address: {0}", data.Address);
}
}
Console.ReadLine();
}