// update
public bool UpdateUniversity(int id, UniversityModel university)
{
using (AttenderEntities ef = new AttenderEntities())
{
University updateUniversity = ef.Universities.FirstOrDefault(a => a.Id == id);
if (updateUniversity == null)
{
return(false);
}
//updateUniversity.Id = university.Id;
updateUniversity.Name = university.Name;
updateUniversity.Country = university.Country;
updateUniversity.City = university.City;
updateUniversity.Address = university.Address;
updateUniversity.Zip = university.Zip;
updateUniversity.Site = university.Site;
updateUniversity.PhoneNumber = university.PhoneNumber;
try{
// ef.Database.ExecuteSqlCommand($"UPDATE [dbo].[University] SET [Name] = {updateUniversity.Name}, [Country] = {updateUniversity.Country},[City] = { updateUniversity.City}, [Address] = { updateUniversity.Address}, [Zip] = { updateUniversity.Zip}, [Site] = { updateUniversity.Site}, [PhoneNumber] = { updateUniversity.PhoneNumber} WHERE [Id] = {id}");
ef.SaveChanges();
}
catch {
return(false);
}
}
return(true);
}
public string GetMemberInfoById(int id)
{
MemberModel member = null;
using (AttenderEntities ef = new AttenderEntities())
{
Member item = ef.Members.FirstOrDefault(a => a.Id == id);
if (item != null)
{
member = new MemberModel()
{
Id = item.Id,
PassportNumber = item.PassportNumber,
FirstName = item.FirstName,
LastName = item.LastName,
Password = item.Password,
PhoneNumber = item.PhoneNumber,
MacAddress = item.MacAddress,
Mail = item.Mail
};
return(member.FirstName + " " + member.LastName + " " + member.PassportNumber);
}
}
return("No person");
}
// update
public bool UpdateLessonTime(int id, LessonTimeModel lessonTime)
{
using (AttenderEntities ef = new AttenderEntities())
{
LessonTime updateLessonTime = ef.LessonTimes.FirstOrDefault(a => a.Id == id);
if (updateLessonTime == null)
{
return(false);
}
//updateLessonTime.CourseId = lessonTime.CourseId;
updateLessonTime.LessonDate = lessonTime.LessonDate;
updateLessonTime.StartTime = lessonTime.StartTime;
updateLessonTime.EndTime = lessonTime.EndTime;
updateLessonTime.ActualStartTime = lessonTime.ActualStartTime;
updateLessonTime.ClassRoom = lessonTime.ClassRoom;
try
{
ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
// Create;
public bool AddMember(MemberModel newMember)
{
using (AttenderEntities ef = new AttenderEntities())
{
Member member = new Member()
{
//Id = newMember.Id,
PassportNumber = newMember.PassportNumber,
FirstName = newMember.FirstName,
LastName = newMember.LastName,
Password = newMember.Password,
PhoneNumber = newMember.PhoneNumber,
MacAddress = newMember.MacAddress,
Mail = newMember.Mail
};
ef.Members.Add(member);
try
{
ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
// Create;
public bool AddUniversity(UniversityModel newUniversity)
{
using (AttenderEntities ef = new AttenderEntities())
{
University university = new University()
{
// Id = newUniversity.Id,
Name = newUniversity.Name,
Country = newUniversity.Country,
City = newUniversity.City,
Address = newUniversity.Address,
Zip = newUniversity.Zip,
Site = newUniversity.Site,
PhoneNumber = newUniversity.PhoneNumber
};
ef.Universities.Add(university);
try{
//ef.Database.ExecuteSqlCommand($"INSERT INTO [dbo].[University] ([Name],[Country],[City],[Address],[Zip],[Site],[PhoneNumber]) VALUES ({university.Name} , {university.Country} , {university.City}, {university.Address} , {university.Zip}, {university.Site} , {university.PhoneNumber})");
ef.SaveChanges();
}
catch {
return(false);
}
}
return(true);
}
// recieving password and mail
public string getPassAndMail(string Email, string Password)
{
string str = "";
using (AttenderEntities ef = new AttenderEntities())
{
Member item = ef.Members.FirstOrDefault(a => a.Mail == Email && a.Password == Password);
if (item != null)
{
member = new MemberModel()
{
Id = item.Id,
PassportNumber = item.PassportNumber,
FirstName = item.FirstName,
LastName = item.LastName,
Password = item.Password,
PhoneNumber = item.PhoneNumber,
MacAddress = item.MacAddress,
Mail = item.Mail
};
str = item.Password;
str += item.Mail;
}
}
return(str);
}
// update
public bool UpdateLessonAttending(int id, LessonAttendingModel lesoonAttending)
{
using (AttenderEntities ef = new AttenderEntities())
{
LessonAttending updateLessonAttending = ef.LessonAttendings.FirstOrDefault(a => a.Id == id);
if (updateLessonAttending == null)
{
return(false);
}
updateLessonAttending.LessonId = lesoonAttending.LessonId;
updateLessonAttending.StudentId = lesoonAttending.StudentId;
updateLessonAttending.CheckTimeStart = lesoonAttending.CheckTimeStart;
updateLessonAttending.CheckTimeEnd = lesoonAttending.CheckTimeEnd;
try
{
ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
// update
public bool UpdateMemberRole(int id, MemberRoleModel memberRole)
{
using (AttenderEntities ef = new AttenderEntities())
{
MemberRole updateMemberRole = ef.MemberRoles.FirstOrDefault(a => a.Id == id);
if (updateMemberRole == null)
{
return(false);
}
//updateMemberRole.Id = memberRole.Id;
updateMemberRole.MemberId = memberRole.MemberId;
updateMemberRole.UniversityId = memberRole.UniversityId;
updateMemberRole.Role = memberRole.Role;
try
{
ef.Database.ExecuteSqlCommand($"UPDATE [dbo].[MemberRole] SET [MemberId] = {updateMemberRole.MemberId},[UniversityId] = {updateMemberRole.UniversityId},[Role] = { updateMemberRole.Role} WHERE [Id] = {id}");
//ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
//Read
public List <LessonTimeModel> GetAllCourses(int id)
{
List <LessonTimeModel> courses = new List <LessonTimeModel>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (LessonTime item in ef.LessonTimes)
{
if (item.CourseId == id)
{
courses.Add(new LessonTimeModel()
{
Id = item.Id,
CourseId = item.CourseId,
LessonDate = item.LessonDate,
StartTime = item.StartTime,
EndTime = item.EndTime,
ActualStartTime = item.ActualStartTime,
ClassRoom = item.ClassRoom
});
}
}
}
return(courses);
}
public int CheckWhatLessonIsNow(string date, string hour)
{
LessonTimeModel lessonTime = null;
DateTime rdate = DateTime.Parse(date);
TimeSpan rhour = TimeSpan.Parse(hour);
using (AttenderEntities ef = new AttenderEntities())
{
LessonTime item = ef.LessonTimes.FirstOrDefault(a => a.LessonDate == rdate &&
a.StartTime <= rhour && a.EndTime >= rhour);
if (item != null)
{
lessonTime = new LessonTimeModel()
{
Id = item.Id,
CourseId = item.CourseId,
LessonDate = item.LessonDate,
StartTime = item.StartTime,
EndTime = item.EndTime,
ActualStartTime = TimeSpan.Parse(hour),
ClassRoom = item.ClassRoom
};
return(lessonTime.CourseId);
}
}
return(-1);
}
// update
public bool UpdateMember(int id, MemberModel member)
{
using (AttenderEntities ef = new AttenderEntities())
{
Member updateMember = ef.Members.FirstOrDefault(a => a.Id == id);
if (updateMember == null)
{
return(false);
}
//updateMember.Id = member.Id;
updateMember.PassportNumber = member.PassportNumber;
updateMember.FirstName = member.FirstName;
updateMember.LastName = member.LastName;
updateMember.Password = member.Password;
updateMember.PhoneNumber = member.PhoneNumber;
updateMember.MacAddress = member.MacAddress;
updateMember.Mail = member.Mail;
try
{
ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
// Create;
public bool AddLessonTime(LessonTimeModel newLessonTime)
{
using (AttenderEntities ef = new AttenderEntities())
{
LessonTime lessonTime = new LessonTime()
{
//Id = newLessonTime.Id,
CourseId = newLessonTime.CourseId,
LessonDate = newLessonTime.LessonDate,
StartTime = newLessonTime.StartTime,
EndTime = newLessonTime.EndTime,
ActualStartTime = newLessonTime.ActualStartTime,
ClassRoom = newLessonTime.ClassRoom
};
ef.LessonTimes.Add(lessonTime);
try
{
ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
// update
public bool UpdateCourse(int id, CourseModel course)
{
using (AttenderEntities ef = new AttenderEntities())
{
Course updateCourse = ef.Courses.FirstOrDefault(a => a.Id == id);
if (updateCourse == null)
{
return(false);
}
//updateCourse.Id = course.Id;
updateCourse.Name = course.Name;
updateCourse.Code = course.Code;
updateCourse.LectureId = course.LectureId;
updateCourse.DepartmentId = course.DepartmentId;
try
{
ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
// Checking if registration is valid
public bool CheckRegistration(string Passport, string Password, string Mac)
{
string hashedData = ComputeSha256Hash(Password);
string disablePassword = ComputeSha256Hash("Used");
using (AttenderEntities ef = new AttenderEntities())
{
Member updateMember = ef.Members.FirstOrDefault(a => a.PassportNumber == Passport && a.Password == hashedData);
Member member = updateMember;
if (updateMember != null)
{
updateMember.PassportNumber = member.PassportNumber;
updateMember.FirstName = member.FirstName;
updateMember.LastName = member.LastName;
updateMember.Password = disablePassword;
updateMember.PhoneNumber = member.PhoneNumber;
updateMember.MacAddress = Mac;
updateMember.Mail = member.Mail;
try
{
ef.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
else
{
return(false);
}
}
}
// Create;
public bool AddLessonAttending(LessonAttendingModel newLessonAttending)
{
using (AttenderEntities ef = new AttenderEntities())
{
LessonAttending lessonAttending = new LessonAttending()
{
//Id = newLessonAttending.Id,
LessonId = newLessonAttending.LessonId,
StudentId = newLessonAttending.StudentId,
CheckTimeStart = newLessonAttending.CheckTimeStart,
CheckTimeEnd = newLessonAttending.CheckTimeEnd
};
ef.LessonAttendings.Add(lessonAttending);
try
{
ef.SaveChanges();
}
catch
{
return(false);
}
}
return(true);
}
// Sending Mail by passportId
public void SendMailsByPassportId(string passportId)
{
System.Net.Mail.MailMessage mailMessage = new System.Net.Mail.MailMessage();
using (AttenderEntities ef = new AttenderEntities())
{
Member member = ef.Members.FirstOrDefault(a => a.PassportNumber == passportId);
if (member != null)
{
MemberRole role = ef.MemberRoles.FirstOrDefault(a => a.MemberId == member.Id);
if (role != null)
{
memberRole = new MemberRoleModel()
{
Id = role.Id,
MemberId = role.MemberId,
UniversityId = role.UniversityId,
Role = role.Role
};
}
if (role.Role == "s")
{
Random rnd = new Random();
int num = rnd.Next();
string res = num.ToString();
string hashedData = ComputeSha256Hash(res);
// updating password in the database with hashed password
UpdatePassword(member.Id, member, hashedData);
mailMessage.To.Add(member.Mail);
mailMessage.Subject = "Attender Registration";
mailMessage.Body = "Dear " + member.FirstName + " " + member.LastName + "," + Environment.NewLine +
"Please follow the instructions and enter your credentials in the website bellow:"
+ Environment.NewLine + "Your disposable password is: " + res + Environment.NewLine + "http://*****:*****@gmail.com", "Attender App");
mailMessage.Attachments.Add(new System.Net.Mail.Attachment("C:\\Users\\barpi\\Desktop\\Attender\\Instrutions Finding Mac address.pdf"));
SmtpClient stmpMail = new SmtpClient();
stmpMail.Host = "smtp.gmail.com";
stmpMail.Credentials = new NetworkCredential("*****@*****.**", "Attender");
stmpMail.EnableSsl = true;
stmpMail.Port = 587;
try
{
stmpMail.Send(mailMessage);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
}
}
}
}
public int GetUniversityById(int memberId)
{
using (AttenderEntities ef = new AttenderEntities())
{
MemberRole item = ef.MemberRoles.FirstOrDefault(a => a.MemberId == memberId);
if (item != null)
{
return(item.UniversityId);
}
}
return(0);
}
public int CheckIfLecCourse(int courseId, int lecturerId)
{
using (AttenderEntities ef = new AttenderEntities())
{
Course item = ef.Courses.FirstOrDefault(a => a.Id == courseId && a.LectureId == lecturerId);
if (item != null)
{
return(1);
}
}
return(0);
}
public int GetIdByMemberId(int memberId, string role)
{
using (AttenderEntities ef = new AttenderEntities())
{
MemberRole item = ef.MemberRoles.FirstOrDefault(a => a.MemberId == memberId && a.Role == role);
if (item != null)
{
return(item.Id);
}
}
return(0);
}
public bool CheckIfExists(int studentId, int courseId)
{
using (AttenderEntities ef = new AttenderEntities())
{
CourseStudent item = ef.CourseStudents.FirstOrDefault(a => a.StudentId == studentId && a.CourseId == courseId);
if (item != null)
{
return(true);
}
}
return(false);
}
public List <string> GetAllCoursespp()
{
List <string> courses = new List <string>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (Course item in ef.Courses)
{
courses.Add("Id" + " " + item.Id + ":" + " " + item.Name);
}
}
return(courses);
}
public string GetRoleById(int memberId)
{
string memberRole = null;
using (AttenderEntities ef = new AttenderEntities())
{
MemberRole item = ef.MemberRoles.FirstOrDefault(a => a.MemberId == memberId);
if (item != null)
{
memberRole = item.Role;
}
}
return(memberRole);
}
public bool DeleteStudentFromAll(int studentId)
{
using (AttenderEntities ef = new AttenderEntities())
{
try
{
ef.Database.ExecuteSqlCommand($"DELETE FROM [dbo].[CourseStudents] WHERE StudentId = {studentId}");
}
catch
{
return(false);
}
}
return(true);
}
//Get Courses By Lecturer Id
public List <string> GetAllCourses(int id)
{
List <string> Courses = new List <string>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (Course item in ef.Courses)
{
if (item.LectureId == id)
{
Courses.Add(item.Id.ToString() + " " + item.Name);
}
}
}
return(Courses);
}
//Read
public List <int> GetStudentsAttendingpp(int lessonId)
{
List <int> idis = new List <int>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (LessonAttending item in ef.LessonAttendings)
{
if (item.LessonId == lessonId)
{
idis.Add(item.StudentId);
}
}
}
return(idis);
}
//Read
public List <string> GetDepartmentsByUniId(int id)
{
List <string> departments = new List <string>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (Department item in ef.Departments)
{
if (item.Id == id)
{
departments.Add("Id" + " " + item.Id + ":" + " " + item.Name);
}
}
}
return(departments);
}
//Read
public List <string> GetAllCoursesIdName(int id)
{
List <string> courses = new List <string>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (LessonTime item in ef.LessonTimes)
{
if (item.CourseId == id)
{
courses.Add("Id: " + item.Id + " Date: " + item.LessonDate);
}
}
}
return(courses);
}
//Read
public List <CourseStudentModel> GetAllCourseStudent()
{
List <CourseStudentModel> courseStudents = new List <CourseStudentModel>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (CourseStudent item in ef.CourseStudents)
{
courseStudents.Add(new CourseStudentModel()
{
Id = item.Id,
StudentId = item.StudentId,
CourseId = item.CourseId
});
}
}
return(courseStudents);
}
//Read
public List <int> GetAllLessonIdsNow(string date, string hour)
{
DateTime rdate = DateTime.Parse(date);
TimeSpan rhour = TimeSpan.Parse(hour);
List <int> lessonTimes = new List <int>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (LessonTime item in ef.LessonTimes)
{
if (item.LessonDate == rdate && item.StartTime <= rhour && item.EndTime >= rhour)
{
lessonTimes.Add(item.CourseId);
}
}
}
return(lessonTimes);
}
// Gets list of lecturers
public List <string> GetAllLecturers(int uni)
{
List <string> members = new List <string>();
using (AttenderEntities ef = new AttenderEntities())
{
foreach (Member item in ef.Members)
{
string role = memberRoleBll.GetRoleById(item.Id);
int uniId = memberRoleBll.GetUniversityById(item.Id);
if ((role == "l" || role == "h") && uniId == uni)
{
members.Add("Id" + " " + item.Id + ":" + " " + item.FirstName + " " + item.LastName);
}
}
}
return(members);
}
