public ActionResult SaveStudent(StudentVM Model)
{
using (StudentDataContext dc = new StudentDataContext())
{
var student = dc.Student.Where(s => s.ID == Model.ID).FirstOrDefault();
var subject = dc.Subject.Where(s => s.SubjectName.ToLower() == Model.SubjectName.ToLower()).FirstOrDefault();
if (subject == null)
{
subject = new Subject();
subject.SubjectName = Model.SubjectName;
dc.Subject.Add(subject);
dc.SaveChanges();
}
if (student == null)
{
student = new Student();
dc.Student.Add(student);
}
student.FirstName = Model.FirstName;
student.LastName = Model.LastName;
student.Class = Model.Class;
student.SubjectID = subject.ID;
student.Marks = Model.Marks;
dc.SaveChanges();
}
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
static void Main(string[] args)
{
DataContext dbContext = new DataContext(ConnectionString);
Table <Student> students = dbContext.GetTable <Student>();
Console.WriteLine("Until update:");
foreach (var student in students)
{
Console.WriteLine("{0} \t{1} \t{2} \t{3}", student.Id, student.GroupId, student.Name, student.BirthDay.ToShortDateString());
}
Student stud = students.FirstOrDefault();
stud.Name = "Upd424141ated";
dbContext.SubmitChanges();
Console.WriteLine("After update:");
foreach (var student in students)
{
Console.WriteLine("{0} \t{1} \t{2} \t{3}", student.Id, student.GroupId, student.Name, student.BirthDay.ToShortDateString());
}
StudentDataContext StudentdbContext = new StudentDataContext(ConnectionString);
int MinGroupId = 0, MaxGroupId = 0;
StudentdbContext.GetGroupRange(ref MinGroupId, ref MaxGroupId);
Console.WriteLine("Min: " + MinGroupId);
Console.WriteLine("Max: " + MaxGroupId);
}
public IHttpActionResult addStudent([FromBody] SinhVien sinhVien)
{
StudentDataContext st = new StudentDataContext();
try
{
//SinhVien sv = st.SinhViens.FirstOrDefault(x => x.maSV == sinhVien.maSV);
//if (sv.maSV == sinhVien.maSV)
//{
// return Ok("Đã trùng Mã Sinh Viên");
//}
//if (string.IsNullOrEmpty(sinhVien.maSV))
//{
// return Ok(new HttpResponseMessage(HttpStatusCode.NotModified));
//}
//insert data
st.SinhViens.InsertOnSubmit(sinhVien);
st.SubmitChanges();
return(Ok(new HttpResponseMessage(HttpStatusCode.NotModified)));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
static void Main1(string[] args)
{
StudentDataContext SDC = new StudentDataContext();
foreach (Student st in SDC.Students.ToList())
{
Console.WriteLine(st.Id + " : " + st.Name);
}
Console.WriteLine(" ========= ");
Student s = new Student();
s.Id = 4;
s.Name = "PLS";
s.Age = 20;
SDC.Students.InsertOnSubmit(s);
SDC.SubmitChanges();
foreach (Student st in SDC.Students.ToList())
{
Console.WriteLine(st.Id + " : " + st.Name);
}
Console.WriteLine(" ========= ");
SDC.Students.DeleteOnSubmit(
SDC.Students.SingleOrDefault(std => std.Id == 2)
);
SDC.SubmitChanges();
foreach (Student st in SDC.Students.ToList())
{
Console.WriteLine(st.Id + " : " + st.Name);
}
Console.WriteLine(" ========= ");
Console.ReadKey();
}
public AccountController(UserManager <IdentityUser> userManager
, StudentDataContext context
, SignInManager <IdentityUser> signInManager)
{
_userManager = userManager;
_context = context;
_signInManager = signInManager;
}
public JsonResult GetSubjects()
{
using (StudentDataContext dc = new StudentDataContext())
{
var Subjects = dc.Subject.ToList();
return(Json(new { Subjects }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteStudent(int ID)
{
using (StudentDataContext dc = new StudentDataContext())
{
var student = dc.Student.Where(s => s.ID == ID).FirstOrDefault();
dc.Student.Remove(student);
dc.SaveChanges();
}
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
protected void DeleterRecord_Click(object sender, EventArgs e)
{
StudentDataContext dbcontext = new StudentDataContext();
Student student = new Student();
student = dbcontext.Students.Single(x => x.sid == Int32.Parse(id.Text));
dbcontext.Students.DeleteOnSubmit(student);
dbcontext.SubmitChanges();
Label1.Text = "Deleted";
}
protected void DeleterRecord_Click(object sender, EventArgs e)
{
StudentDataContext db = new StudentDataContext();
Student s = new Student();
s = db.Students.Single(x => x.sid == Int32.Parse(id.Text));
db.Students.DeleteOnSubmit(s);
db.SubmitChanges();
Label1.Text = "Record Deleted Successfully";
}
protected void FetchRecord_Click(object sender, EventArgs e)
{
StudentDataContext dbcontext = new StudentDataContext();
Student student = new Student();
int id = Int32.Parse(student_id.Text);
student = dbcontext.Students.SingleOrDefault(x => x.sid == id);
name.Text = student.name;
sem.Text = student.sem.ToString();
cpi.Text = student.cpi.ToString();
mob.Text = student.contactno.ToString();
email.Text = student.email;
}
//新增一筆資料
private void button1_Click(object sender, EventArgs e)
{
StudentDataContext db = new StudentDataContext();
//可直接使用db的table(因為已經被自動宣告了class)來宣告一筆資料
student newStudent = new student()
{
Id = 1, Name = "Tony", Gender = "Male"
};
db.student.InsertOnSubmit(newStudent);
db.SubmitChanges();
MessageBox.Show("Insert success!!");
}
//執行更新Id=1的資料
private void button4_Click(object sender, EventArgs e)
{
using
(System.IO.StreamWriter sw = new System.IO.StreamWriter(@"c:\temp\tempdatacontext.log"))
{
StudentDataContext db = new StudentDataContext();
db.Log = sw;
//assigned streamwriter to the log property of datacontext
student myStudent = db.student.Single(p => p.Id == 1);
myStudent.Name = "TonyCHEN";
db.SubmitChanges();
}
}
//查詢資料並log SQL的命令
private void button2_Click(object sender, EventArgs e)
{
using
(System.IO.StreamWriter sw = new System.IO.StreamWriter(@"c:\temp\tempdatacontext.log"))
{
StudentDataContext db = new StudentDataContext();
//assigned streamwriter to the log property of datacontext
db.Log = sw;
var result = from p in db.student select p;
foreach (var item in result)
{
Console.WriteLine(item.Id + "\t" + item.Name + "\t" + item.Gender);
}
}
}
protected void Insert_Record_Click(object sender, EventArgs e)
{
StudentDataContext db = new StudentDataContext();
Student s = new Student();
s.name = name.Text;
s.sem = Int32.Parse(sem.Text);
s.cpi = float.Parse(cpi.Text);
s.contactno = long.Parse(cno.Text);
s.email = email.Text;
db.Students.InsertOnSubmit(s);
db.SubmitChanges();
Label1.Text = "Record Inserted Successfully";
Label1.ForeColor = System.Drawing.Color.Green;
}
protected void RecordUpdated_Click(object sender, EventArgs e)
{
StudentDataContext db = new StudentDataContext();
Student s = new Student();
int id = Int32.Parse(student_id.Text);
s = db.Students.SingleOrDefault(x => x.sid == id);
s.name = name.Text;
s.sem = int.Parse(sem.Text);
s.cpi = float.Parse(cpi.Text);
s.contactno = long.Parse(mob.Text);
s.email = email.Text;
db.SubmitChanges();
Label2.Text = "Updated";
Label2.ForeColor = System.Drawing.Color.Green;
}
protected void FetchRecord_Click(object sender, EventArgs e)
{
StudentDataContext db = new StudentDataContext();
Student s = new Student();
Panel1.Visible = true;
RecordUpdated.Visible = true;
int id = Int32.Parse(student_id.Text);
s = db.Students.SingleOrDefault(x => x.sid == id);
name.Text = s.name;
sem.Text = s.sem.ToString();
cpi.Text = s.cpi.ToString();
mob.Text = s.contactno.ToString();
email.Text = s.email;
}
//新增一筆資料並log SQL的命令
private void button3_Click_1(object sender, EventArgs e)
{
using
(System.IO.StreamWriter sw = new System.IO.StreamWriter(@"c:\temp\tempdatacontext.log"))
{
StudentDataContext db = new StudentDataContext();
db.Log = sw;
//可直接使用db的table(因為已經被自動宣告了class)來宣告一筆資料
student newStudent = new student()
{
Id = 3, Name = "Sam", Gender = "Male"
};
db.student.InsertOnSubmit(newStudent);
db.SubmitChanges();
}
}
public JsonResult GetStudentDetail(int ID)
{
using (StudentDataContext dc = new StudentDataContext())
{
var details = (from s in dc.Student
join su in dc.Subject on s.SubjectID equals su.ID where s.ID == ID
select new StudentVM()
{
ID = s.ID,
FirstName = s.FirstName,
LastName = s.LastName,
Class = s.Class,
Marks = s.Marks,
SubjectName = su.SubjectName
}).FirstOrDefault();
return(Json(new { details }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetStudents(string Search, int?SubjectID)
{
using (StudentDataContext dc = new StudentDataContext())
{
var details = (from s in dc.Student
join su in dc.Subject on s.SubjectID equals su.ID
select new StudentVM()
{
ID = s.ID,
SubjectID = s.SubjectID,
FirstName = s.FirstName,
LastName = s.LastName,
Class = s.Class,
Marks = s.Marks,
SubjectName = su.SubjectName
}).ToList();
details = details.Where(s => (s.FirstName.Contains(Search) || s.LastName.Contains(Search)) && (SubjectID == null || SubjectID == 0 || s.SubjectID == SubjectID)).ToList();
return(Json(new { details }, JsonRequestBehavior.AllowGet));
}
}
public StudentController(StudentDataContext db)
{
_db = db;
}
public StudentsDataController(StudentDataContext dbContext)
{
_dbContext = dbContext;
}
public StudentsController(StudentDataContext context)
{
this.context = context;
}
public StudentController(StudentDataContext context)
{
_context = context;
}
