private void swAllPresent_Checked(object sender, RoutedEventArgs e)
{
if (dataGrid.Items.Count != 0)
{
using (var db = new DataClass.myDbContext())
{
for (int i = 0; i < _initialCollection.Count; i++)
{
dataGrid.SelectedIndex = i;
dynamic selectedItem = dataGrid.SelectedItems[0];
//Add to Attendance
var Attendance = new DataClass.Tables.Attendance();
Attendance.StudentId = (long)selectedItem.Id;
Attendance.Exist = true;
Attendance.Date = strDate;
db.Attendances.Add(Attendance);
db.SaveChanges();
//remove items from list
UpdateList(Convert.ToInt64(selectedItem.Id), 10);
}
}
}
}
private void updateGroup(long id, string GroupName)
{
using (var db = new DataClass.myDbContext())
{
var EditGroup = db.Groups.Find(id);
EditGroup.GroupName = GroupName;
db.SaveChanges();
}
}
private void deleteUser(long id)
{
using (var db = new DataClass.myDbContext())
{
var DeleteUser = db.Users.Find(id);
db.Users.Remove(DeleteUser);
db.SaveChanges();
}
}
private void addGroup(string GroupName)
{
using (var db = new DataClass.myDbContext())
{
var group = new DataClass.Tables.Group();
group.GroupName = GroupName;
db.Groups.Add(group);
db.SaveChanges();
}
}
private void updateUser(long id, string Username, string Password)
{
using (var db = new DataClass.myDbContext())
{
var EditUser = db.Users.Find(id);
EditUser.Username = Username;
EditUser.Password = Password;
db.SaveChanges();
}
}
private void updateAttendance(long AttendanceId, long StudentId, bool Exist, string Date)
{
using (var db = new DataClass.myDbContext())
{
var EditAttendance = db.Attendances.FirstOrDefault(x => x.StudentId == StudentId && x.Id == AttendanceId);
EditAttendance.Exist = Exist;
EditAttendance.Date = Date;
db.SaveChanges();
}
}
private void updateSchool(long id, string Name, string Base, string Admin, string Year)
{
using (var db = new DataClass.myDbContext())
{
var EditSchool = db.Schools.Find(id);
EditSchool.SchoolName = Name;
EditSchool.Base = Base;
EditSchool.Admin = Admin;
EditSchool.Year = Year;
db.SaveChanges();
}
}
private void addUser(string Username, string Password)
{
using (var db = new DataClass.myDbContext())
{
var User = new DataClass.Tables.User();
User.Username = Username;
User.Password = Password;
db.Users.Add(User);
db.SaveChanges();
}
}
private void updateScore(long ScoreId, long StudentId, string Score, string Date, string Book, string Desc)
{
using (var db = new DataClass.myDbContext())
{
var EditScore = db.Scores.FirstOrDefault(x => x.Id == ScoreId);
EditScore.Scores = Score;
EditScore.Book = Book;
EditScore.Date = Date;
EditScore.Desc = Desc;
EditScore.StudentId = StudentId;
db.SaveChanges();
}
}
private void addSchool(string Name, string Base, string Admin, string Year)
{
using (var db = new DataClass.myDbContext())
{
var School = new DataClass.Tables.School();
School.SchoolName = Name;
School.Base = Base;
School.Admin = Admin;
School.Year = Year;
db.Schools.Add(School);
db.SaveChanges();
}
}
private void deleteAttendance(long StudentId, long AttendanceId)
{
try
{
using (var db = new DataClass.myDbContext())
{
var DeleteAttendance = db.Attendances.FirstOrDefault(x => x.StudentId == StudentId && x.Id == AttendanceId);
db.Attendances.Remove(DeleteAttendance);
db.SaveChanges();
}
}
catch (Exception)
{
}
}
private void addStudent(long BaseId, string Name, string LName, string FName, string Gender, byte[] Image)
{
using (var db = new DataClass.myDbContext())
{
var Student = new DataClass.Tables.Student();
Student.BaseId = BaseId;
Student.Name = Name;
Student.LName = LName;
Student.FName = FName;
Student.Gender = Gender;
Student.Image = Image;
db.Students.Add(Student);
db.SaveChanges();
}
}
private void updateStudent(long id, long BaseId, string Name, string LName, string FName, string Gender, byte[] Image)
{
using (var db = new DataClass.myDbContext())
{
var EditStudent = db.Students.Find(id);
EditStudent.Name = Name;
EditStudent.LName = LName;
EditStudent.FName = FName;
EditStudent.Gender = Gender;
EditStudent.BaseId = BaseId;
EditStudent.Image = Image;
db.SaveChanges();
}
}
private void deleteScore(long ScoreId)
{
try
{
using (var db = new DataClass.myDbContext())
{
var DeleteScore = db.Scores.Where(x => x.Id == ScoreId).ToList();
db.Scores.RemoveRange(DeleteScore);
db.SaveChanges();
}
}
catch (Exception)
{
}
}
private void deleteQuestion(long SchoolId, string Book)
{
try
{
using (var db = new DataClass.myDbContext())
{
var DeleteQuestion = db.Questions.Where(x => x.SchoolId == SchoolId && x.Book == Book).ToList();
db.Questions.RemoveRange(DeleteQuestion);
db.SaveChanges();
}
}
catch (Exception)
{
}
}
private void updateAQuestions(long id, long GroupId, string Class, string QuestionText, string Case1, string Case2, string Case3, string Case4, int Answer, string Date)
{
using (var db = new DataClass.myDbContext())
{
var EditAQuestions = db.AQuestions.Find(id);
EditAQuestions.GroupId = GroupId;
EditAQuestions.Class = Class;
EditAQuestions.QuestionText = QuestionText;
EditAQuestions.Case1 = Case1;
EditAQuestions.Case2 = Case2;
EditAQuestions.Case3 = Case3;
EditAQuestions.Case4 = Case4;
EditAQuestions.Answer = Answer;
EditAQuestions.Date = Date;
db.SaveChanges();
}
}
private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
using (var db = new DataClass.myDbContext())
{
var data = new DataClass.Tables.AHistory()
{
UserId = _UserId,
FalseItem = _False,
TrueItem = _True,
NoneItem = _None,
GroupName = _GroupName,
DatePass = strDate
};
db.AHistories.Add(data);
db.SaveChanges();
}
}
private void deleteSchool(long id)
{
using (var db = new DataClass.myDbContext())
{
var checkQuery = db.Students.Where(x => x.BaseId == id).Any();
if (checkQuery)
{
MainWindow.main.showGrowlNotification(NotificationKEY: AppVariable.Delete_Exist_KEY, param: new[] { "مدرسه", "دانش آموزان" });
}
else
{
var DeleteSchool = db.Schools.Find(id);
db.Schools.Remove(DeleteSchool);
db.SaveChanges();
MainWindow.main.showGrowlNotification(AppVariable.Deleted_KEY, true, txtSchool.Text, "مدرسه");
}
}
}
private void addAttendance(long StudentId, bool Exist, string Date)
{
try
{
using (var db = new DataClass.myDbContext())
{
var Attendance = new DataClass.Tables.Attendance();
Attendance.StudentId = StudentId;
Attendance.Exist = Exist;
Attendance.Date = Date;
db.Attendances.Add(Attendance);
db.SaveChanges();
}
}
catch (Exception)
{
}
}
private void deleteSchool(long id)
{
using (var db = new DataClass.myDbContext())
{
var checkQuery = db.Students.Where(x => x.BaseId == id).Any();
if (checkQuery)
{
MainWindow.main.ShowDeleteExistNotification("مدرسه", "دانش آموزان");
}
else
{
var DeleteSchool = db.Schools.Find(id);
db.Schools.Remove(DeleteSchool);
db.SaveChanges();
MainWindow.main.getexHint();
MainWindow.main.ShowDeletedNotification(true, txtSchool.Text, "مدرسه");
}
}
}
private void addAQuestions(long GroupId, string Class, string QuestionText, string Case1, string Case2, string Case3, string Case4, int Answer, string Date)
{
using (var db = new DataClass.myDbContext())
{
var aQuestion = new DataClass.Tables.AQuestion();
aQuestion.GroupId = GroupId;
aQuestion.Class = Class;
aQuestion.QuestionText = QuestionText;
aQuestion.Case1 = Case1;
aQuestion.Case2 = Case2;
aQuestion.Case3 = Case3;
aQuestion.Case4 = Case4;
aQuestion.Answer = Answer;
aQuestion.Date = Date;
db.AQuestions.Add(aQuestion);
db.SaveChanges();
}
}