// PUT api/TNapi/5
public IHttpActionResult PutTypeName(int id, TypeName typename)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != typename.TypeNameID)
{
return(BadRequest());
}
db.Entry(typename).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TypeNameExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Index(DepartmentBatchUpdateVM[] data)
{
if (ModelState.IsValid)
{
foreach (var item in data)
{
var dept = db.Department.Find(item.DepartmentId);
dept.Name = item.Name;
dept.Budget = item.Budget;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(from p in db.Department
select new DepartmentCreationVM()
{
DepartmentId = p.DepartmentID,
Name = p.Name,
Budget = p.Budget,
StartDate = p.StartDate
}));
}
// PUT api/StudentAPI/5
public IHttpActionResult PutStudent(int id, Student student)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != student.StudentID)
{
return(BadRequest());
}
db.Entry(student).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "CourseID,Title,Credits")] Course course)
{
if (ModelState.IsValid)
{
db.Courses.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(course));
}
public ActionResult Create([Bind(Include = "TypeNameID,typename1,parentid")] TypeName typename)
{
if (ModelState.IsValid)
{
db.TypeNames.Add(typename);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(typename));
}
public ActionResult Create([Bind(Include = "StudentID,LastName,FirstName,EnrollmentDate")] Student student)
{
if (ModelState.IsValid)
{
db.Students.Add(student);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(student));
}
public ActionResult Create(Department department)
{
if (ModelState.IsValid)
{
db.Department.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.InstructorID = new SelectList(db.Person, "ID", "FirstName");
return(View(department));
}
public ActionResult Create([Bind(Include = "AreaID,areaname,x_coord,y_coord")] AREA area)
{
if (ModelState.IsValid)
{
db.AREAs.Add(area);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(area));
}
public ActionResult Create([Bind(Include = "DepartmentID,Name,Budget,StartDate,InstructorID,RowVersion")] Department department)
{
if (ModelState.IsValid)
{
db.Department.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.InstructorID = new SelectList(db.Person, "ID", "LastName", department.InstructorID);
return(View(department));
}
public ActionResult Create([Bind(Include = "ID,LastName,FirstName,HireDate,EnrollmentDate,Discriminator")] Person person)
{
if (ModelState.IsValid)
{
db.Person.Add(person);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID = new SelectList(db.OfficeAssignment, "InstructorID", "Location", person.ID);
return(View(person));
}
public ActionResult Create([Bind(Include = "CourseID,Title,Credits,DepartmentID,CreatedOn")] Course course)
{
if (ModelState.IsValid)
{
db.Course.Add(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Department, "DepartmentID", "Name", course.DepartmentID);
return(View(course));
}
public ActionResult UpdateCredits(int credit)
{
var data = db.Course.ToList();
foreach (var item in data)
{
item.Credits += credit;
}
db.SaveChanges();
return(Content(sb.ToString(), "text/plain"));
}
public ActionResult Create([Bind(Include = "DataTableID,industrytype,tatol,years,areaid,bp")] DataTable datatable)
{
if (ModelState.IsValid)
{
db.DataTables.Add(datatable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.areaid = new SelectList(db.AREAs, "AreaID", "areaname", datatable.areaid);
ViewBag.industrytype = new SelectList(db.TypeNames, "TypeNameID", "typename1", datatable.industrytype);
return(View(datatable));
}
public ActionResult Create([Bind(Include = "EnrollmentID,Grade,CourseID,StudentID")] Enrollment enrollment)
{
if (ModelState.IsValid)
{
db.Enrollments.Add(enrollment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", enrollment.CourseID);
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "LastName", enrollment.StudentID);
return(View(enrollment));
}
public ActionResult Create(CoursesCreateOrEdit course)
{
if (ModelState.IsValid)
{
var c = db.Course.Create();
c.InjectFrom(course);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Department, "DepartmentID", "Name", course.DepartmentID);
return(View(course));
}
public ActionResult Create(CourseEdit course)
{
if (ModelState.IsValid)
{
Course newItem = new Course();
newItem.InjectFrom(course);
db.Course.Add(newItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Department, "DepartmentID", "Name", course.DepartmentID);
return(View(course));
}
public ActionResult Index(DepartmentBatchUpdateVM[] data)
{
if (ModelState.IsValid)
{
foreach (var item in data)
{
var dept = db.Department.Find(item.DepartmentId);
dept.Name = item.Name;
dept.Budget = item.Budget;
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ViewBag.DepartmentList));
}
public void DeleteStudent(int id)
{
ContosoUniversityEntities contextObj = new ContosoUniversityEntities();
contextObj.Students.Remove(contextObj.Students.First(stud => stud.StudentID == id));
contextObj.SaveChanges();
}
private void AddingNewEnrollment(int studentId, int courseId)
{
Enrollment newEnrollment = new Enrollment();
ContosoUniversityEntities contextObj = new ContosoUniversityEntities();
//Adding new entry to Enrollment
newEnrollment.CourseID = courseId;
newEnrollment.Date = DateTime.Now;
newEnrollment.StudentID = studentId;
contextObj.Enrollments.Add(newEnrollment);
contextObj.SaveChanges();
}
private void AddingNewStudent(string firstName, string lastName, DateTime birthDate, string email = "Has not specified")
{
Student newStudent = new Student();
ContosoUniversityEntities contextObj = new ContosoUniversityEntities();
//Adding new Student
newStudent.FirstName = firstName;
newStudent.LastName = lastName;
newStudent.BirthDate = birthDate;
newStudent.Email = email;
contextObj.Students.Add(newStudent);
contextObj.SaveChanges();
}
public ActionResult Create(DepartmentCreationVM data)
{
if (ModelState.IsValid)
{
db.Department.Add(new Department()
{
Budget = data.Budget,
Name = data.Name,
StartDate = data.StartDate
});
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(data));
}
public void UpdateStudentData(int id, string name, string email = null)
{
ContosoUniversityEntities contextObj = new ContosoUniversityEntities();
Student student = contextObj.Students.First(stud => stud.StudentID == id);
if (name != null)
{
string[] arr = name.Split(' ');
if (arr.Length > 1)
{
student.FirstName = arr[0];
student.LastName = arr[1];
student.Email = email;
contextObj.SaveChanges();
}
}
}
public ActionResult List(IList <CourseBatchViewModel> data)
{
var db = new ContosoUniversityEntities();
if (ModelState.IsValid)
{
foreach (var item in data)
{
var dbitem = db.Course.Find(item.CourseID);
dbitem.Title = item.Title;
dbitem.Credits = item.Credits;
}
db.SaveChanges();
//return Json(data);
return(RedirectToAction("List"));
}
else
{
return(View(db.Course.ToList()));
}
}
static void Main(string[] args)
{
Console.WriteLine(DateTime.Now + "\t" + "Started.");
using (var db = new ContosoUniversityEntities())
{
Console.WriteLine(DateTime.Now + "\t" + "Query Started.");
db.Database.Log = (log) => { Console.WriteLine(log); };
//QueryData(db);
db.Database.Log = null;
//AddNewRecord(db);
//UpdateData(db);
//DeleteData(db);
//多對多關聯新增(db);
var c = db.Course.Find(1);
Console.WriteLine(db.Entry(c).State);
c.Credits++;
Console.WriteLine(db.Entry(c).State);
var ce = db.Entry(c);
Console.WriteLine("修改前: " + ce.OriginalValues.GetValue <int>("Credits"));
Console.WriteLine("修改後: " + ce.CurrentValues.GetValue <int>("Credits"));
var cc = new Course()
{
Title = "Hello 2",
Department = db.Department.Find(5)
};
db.Course.Add(cc);
var ce2 = db.Entry(cc);
if (ce2.State == System.Data.Entity.EntityState.Added)
{
ce2.Entity.CreatedOn = DateTime.Now;
}
db.SaveChanges();
Console.WriteLine(db.Entry(c).State);
//Console.WriteLine(DateTime.Now + "\t" + "SaveChanges Started.");
//try
//{
// db.SaveChanges();
//}
//catch (DbEntityValidationException ex)
//{
// throw ex;
//}
//Console.WriteLine(DateTime.Now + "\t" + "Query Started.");
//QueryData(db);
}
Console.WriteLine(DateTime.Now + "\t" + "Ended.");
}