public IActionResult EditCourse(int?id) { //get the UID from the Session int uID = Convert.ToInt32(HttpContext.Session.GetString("uID")); //reads from the session //get the Course object from the DB using the DALCourse class DALCourses dp = new DALCourses(configuration); DALStudent ds = new DALStudent(configuration); Student stu = ds.getStudent(uID); viewModelStudentCourse courseList = new viewModelStudentCourse(); courseList.UID = stu.UID; courseList.AddedCourse = new Courses(); courseList.AddedCourse.UID = stu.UID; /// This is new courseList.SelectedCourses = new Courselist(); courseList.SelectedCourses.Courses = dp.getCourses(stu.UID.ToString()); courseList.FirstName = stu.FirstName; courseList.LastName = stu.LastName; courseList.StudentEmail = stu.StudentEmail; courseList.Courses = new Courselist(); courseList.Courses.Courses = dp.GetCourseAvailableForStudent(uID); //send the view return(View(courseList)); }
public IActionResult EditCourse(viewModelStudentCourse viewModel) { //get the UID from the Session int uID = Convert.ToInt32(HttpContext.Session.GetString("uID")); //reads from the session //get the Course object from the DB using the DALCourse class DALCourses dp = new DALCourses(configuration); DALStudent ds = new DALStudent(configuration); Student stu = ds.getStudent(uID); dp.UpdateCourses(viewModel.AddedCourse.ClassID.ToString(), viewModel.AddedCourse.UID); viewModelStudentCourse courseList = new viewModelStudentCourse(); courseList.UID = stu.UID; courseList.FirstName = stu.FirstName; courseList.LastName = stu.LastName; courseList.StudentEmail = stu.StudentEmail; courseList.Courses = new Courselist(); courseList.Courses.Courses = dp.GetCourseAvailableForStudent(uID); //send the view // return View(courseList); return(RedirectToAction("EditCourse", new { uID = uID })); }
private void btnSave_Click(object sender, EventArgs e) { if (!validateStudent()) { return; } string message = string.Empty; TheStudent.StudentID = Convert.ToInt32(textBoxID.Text); TheStudent.Name = textBoxName.Text; TheStudent.Gender = comboBoxGender.Text; TheStudent.Group = comboBoxGroup.Text; TheStudent.Courses = _courseList; try { if (TheStudent.SerialNo > 0) { DALStudent.Update(TheStudent); } else { DALStudent.Insert(TheStudent); } MessageBox.Show("Record Saved Successfully"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public IActionResult UpdateCourse(string class1, string class2, string class3) { //get the uid from the session int uID = Convert.ToInt32(HttpContext.Session.GetString("uID")); //reads from the session DALCourses dp = new DALCourses(configuration); dp.UpdateCourses(class1, uID); dp.UpdateCourses(class2, uID); dp.UpdateCourses(class3, uID); viewModelStudentCourse vwcourse = new viewModelStudentCourse(); vwcourse.Courses = new Courselist(); vwcourse.Courses.Courses = new List <Courses>(); //vwcourse.Courses.Courses.Add(dp.getCourses(class1)); //vwcourse.Courses.Courses.Add(dp.getCourses(class2)); //vwcourse.Courses.Courses.Add(dp.getCourses(class3)); DALStudent ds = new DALStudent(configuration); Student stu = ds.getStudent(uID); vwcourse.UID = uID; vwcourse.FirstName = stu.FirstName; vwcourse.LastName = stu.LastName; vwcourse.StudentEmail = stu.StudentEmail; //vwcourse.ClassTime = stu.ClassTime; return(View("UpdateCourse", vwcourse)); }
private void BtnGiveBook_Click(object sender, EventArgs e) { // Burada öğrencinin okuduğu kitaplar nesnesini üretiyoruz StudentReadInfo studentread = new StudentReadInfo(); // Üretilen nesnenin hangi öğrenci olduğunu Comboboxtan gelen veriyi StudentList içinde bulup seçtirilir studentread.StudentId = DALStudent.StudentList().FirstOrDefault(n => n.StudentName == comboBox1.SelectedItem.ToString()); // Üretilen nesnenin hangi kitap olduğunu Comboboxtan gelen veriyi BookList içinde bulup seçtirilir studentread.BookId = DALBook.BookList().FirstOrDefault(n => n.bookName == comboBox2.SelectedItem.ToString()); // Öğrencinin okuduğu kitaplar nesnesi üzerinde bulunan kitapın alınma tarihine DateTimePickerdan gelen değeri atanır studentread.TakenDate = dateTimePicker1.Value.Date.ToString(); // Entity katmanında TakenDate String olarak tutulduğu için gerekli tip dönüşüm işlemleri yapılır DateTime DueDate = Convert.ToDateTime(studentread.TakenDate); // DueDate kitabın teslim edilme tarihini teslim eder bunu DatetimePickerden gelen tarihe 15gün ekleyerek elde edilir. DueDate = DueDate.AddDays(15); // Entity'miz String olduğu için tekrar tip dönüşümü yapılır studentread.GivenDate = DueDate.ToString(); // Entitymizin Kitabın verilip verilmediğini isGiven değişkeni üzerinde saklanır // Kitap verildiği taktirde isGiven true olur. studentread.isGiven = true; // Gerekli mantıksal işlemler yapılması için LLStudentBookSave methoduna gönderilir. LogicStudentRead.LLStudentBookSave(studentread); MessageBox.Show("Kitap Verildi"); // Verilen kitapın alınıp alınmadığını tutan isBookAvailable özelliği ->Busy olarak değiştirilir. studentread.BookId.isBookAvailable = "Busy"; // Kitabın durumunu güncellemek için LLStudentBookUpdate methoduna gönderilir LogicStudentRead.LLStudentBookUpdate(studentread.BookId); MessageBox.Show("Kitap Durumu Güncellendi"); }
private void studentGenderInfo() { int erkek = DALStudent.StudentList().Where(m => m.StudentGender == "ERKEK").Count(); int kadın = DALStudent.StudentList().Where(m => m.StudentGender == "KADIN").Count(); chart3.Titles.Add("Student Gender Info"); chart3.Series["Öğrenci"].IsValueShownAsLabel = true; chart3.Series["Öğrenci"].Points.AddXY("Erkek", erkek); chart3.Series["Öğrenci"].Points.AddXY("Kadın", kadın); }
// Logic Layer ana form üzerinden erişilen bir katmandır ve gerekli mantıksal kontrollerin katman olarak geçer // Gerekli kontrolleri başarılı bir şekilde geçen Logic Methodlar Data Access Layerdan uygun methodu çağırarak programın çalışmasına devam edilir public static int LLStudentSignIn(EntityStudent student) { if (student.StudentUserName != "" && student.StudentName != "" && student.StudentLastName != "" && student.Password != "" && student.Repassword != "" && student.Password == student.Repassword) { return(DALStudent.StudentSignin(student)); } else { return(-1); } }
public IActionResult DeleteStudent() { //get the uid from the session int uID = Convert.ToInt32(HttpContext.Session.GetString("uID")); //reads from the session DALStudent dp = new DALStudent(configuration); Student student = dp.getStudent(uID); dp.DeleteStudent(uID); return(View(student)); }
public static bool LLStudentUpdate(EntityStudent ent) { if (ent.StudentName != "" && ent.StudentLastName != "" && ent.Password != "" && ent.Repassword != "") { return(DALStudent.StudentUpdate(ent)); } else { return(false); } }
public IActionResult UpdateStudent(Student student) { //get the uid from the session int uID = Convert.ToInt32(HttpContext.Session.GetString("uID")); //reads from the session student.UID = uID; DALStudent dp = new DALStudent(configuration); dp.UpdateUser(student); return(View("Registration", student)); }
public IActionResult EditStudent() { //get the UID from the Session int uID = Convert.ToInt32(HttpContext.Session.GetString("uID")); //reads from the session //get the Student object from the DB using the DALStudent class DALStudent dp = new DALStudent(configuration); Student student = dp.getStudent(uID); //send the view return(View(student)); }
private void buttonDelete_Click(object sender, EventArgs e) { try { DALStudent.Delete(_theStudent); RefreshStudentList(); MessageBox.Show("Record Deleted Successfully"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void RefreshStudentList() { try { StudentList = DALStudent.GetAllStudent(); var bindList = new BindingList <Student>(StudentList); //what is var? dataGridViewStudentFile.DataSource = bindList; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! BURAYA SON KEZ BAK !!!!!!!!!!!!!!!!!!!!!!!!!!!!! private void BtnTakeBook_Click(object sender, EventArgs e) { // Burada öğrencinin okuduğu kitaplar nesnesini üretiyoruz StudentReadInfo studentread = new StudentReadInfo(); // Üretilen nesnenin hangi öğrenci olduğunu Comboboxtan gelen veriyi StudentList içinde bulup seçtirilir studentread.StudentId = DALStudent.StudentList().FirstOrDefault(n => n.StudentName == comboBox1.SelectedItem.ToString()); // Üretilen nesnenin hangi kitap olduğunu Comboboxtan gelen veriyi BookList içinde bulup seçtirilir studentread.BookId = DALBook.BookList().FirstOrDefault(n => n.bookName == comboBox2.SelectedItem.ToString()); DateTime date = DateTime.Now; var shortDate = date.ToString("yyyy-MM-dd"); studentread.GivenDate = shortDate.ToString(); studentread.BookId.isBookAvailable = "Available"; LogicStudentRead.LLStudentBookUpdate(studentread.BookId); MessageBox.Show("Kitap Durumu Güncellendi"); }
protected virtual bool DoStore() { try { DALStudent student = new DALStudent(); if (cand != null) { student.Insert(cand); } return(true); } catch { ShowMsgBox(this, "数据库读写错误"); return(false); } }
public static bool LLStudentLogIn(EntityStudent student) { foreach (EntityStudent item in DALStudent.StudentList()) { if (item.StudentUserName == student.StudentUserName && item.Password == student.Password) { student.StudentId = item.StudentId; student.StudentName = item.StudentName; student.StudentLastName = item.StudentLastName; student.StudentUserName = item.StudentUserName; student.Password = item.Password; student.Repassword = item.Repassword; student.StudentGender = item.StudentGender; student.StudentDebt = item.StudentDebt; return(true); } } return(false); }
public bool Insert(DALStudent user) { int res = 0; using (var connection = new SQLiteConnection(connectionString)) { SQLiteCommand command = new SQLiteCommand(null, connection); { try { command.CommandText = $"INSERT INTO {UserTableName} ({DALStudent.StudentNameColumn},{DALStudent.StudentPasswordColumn},{DALStudent.StudentIdColumn})" + $"VALUES (@nameVal,@passwordVal,@idVal)"; SQLiteParameter nameParam = new SQLiteParameter(@"nameVal", user.Name); SQLiteParameter passwordParam = new SQLiteParameter(@"passwordVal", user.Password); SQLiteParameter idParam = new SQLiteParameter(@"idVal", user.Id); command.Parameters.Add(nameParam); command.Parameters.Add(passwordParam); command.Parameters.Add(idParam); command.Prepare(); connection.Open(); res = command.ExecuteNonQuery(); } catch (Exception e) { if (e != null) { res = -1; } } finally { command.Dispose(); connection.Close(); } } } return(res > 0); }
public IActionResult Registration(viewModelStudentCourse student) { //send it to the DB //validate the info DALStudent dp = new DALStudent(configuration); int uID = dp.addStudent(student); student.UID = uID; student.Courses = new Courselist(); student.Courses.Courses = dp.getCourses(student.UID); //save the User ID to the session HttpContext.Session.SetString("uID", uID.ToString()); //write to the session string strUID = HttpContext.Session.GetString("uID"); //reads from the session return(View(student)); }
public IActionResult GetReport(viewModelStudentCourse student) { //get the UID from the Session int uID = Convert.ToInt32(HttpContext.Session.GetString("uID")); //reads from the session //get the Student object from the DB using the DALStudent class DALCourses dp = new DALCourses(configuration); DALStudent ds = new DALStudent(configuration); //student.Courses.Courses = dp.getReport(student.UID); viewModelStudentCourse courseList = new viewModelStudentCourse(); //courseList.UID = stu.UID; //student.FirstName = FirstName; //student.LastName = LastName; //student.StudentEmail = StudentEmail; //send the view return(View("GetReport")); }
}//update() call public static bool deleteStudent(EntityStudent estud) { bool b = DALStudent.deleteStudent(estud); return(b); }//delete() call
public static List <EntityStudent> LLStudentList() { return(DALStudent.StudentList()); }
public StudentLogic(ApplicationDbContextData context) { _dal = new DALStudent(context); _dalschool = new DALSchool(context); _dalteacher = new DalTeacher(context); }
protected override DALObj ConvertReaderToObject(SQLiteDataReader reader) { DALStudent ret = new DALStudent(reader.GetString(0), reader.GetInt32(1), reader.GetString(2)); return(ret); }
}//get all rec() call public static DataSet getSingeStudentData(EntityStudent estud) { DataSet dsget = DALStudent.getSingeStudentData(estud); return(dsget); } //fetch record according to id call
}//delete() call public static DataSet getStudentData(EntityStudent estud) { DataSet dsget = DALStudent.getStudentData(estud); return(dsget); }//get all rec() call
}//insertion() call public static bool updateStudent(EntityStudent estud) { bool b = DALStudent.updateStudent(estud); return(b); }//update() call
public static bool insertStudent(EntityStudent estud) { bool b = DALStudent.insertStudent(estud); return(b); }//insertion() call