private void delete_onclick(object sender, EventArgs e)
{
LecturerModel objLecModel = new LecturerModel();
objLecModel.Name = titleTxt.Text + " " + nameTxt.Text;
objLecModel.EmpId = empIdTxt.Text;
objLecModel.Faculty = facultyTxt.Text;
objLecModel.Department = deptmntTxt.Text;
objLecModel.Center = centerTxt.Text;
objLecModel.Building = buildingtxt.Text;
objLecModel.Level = lvlTxt.Text;
objLecModel.Rank = rankTxt.Text;
objLecturer.deleteLecturer(objLecModel);
loadData();
nameTxt.Text = "";
empIdTxt.Text = "";
facultyTxt.Text = "";
deptmntTxt.Text = "";
centerTxt.Text = "";
buildingtxt.Text = "";
lvlTxt.Text = "";
rankTxt.Text = "";
}
public void Update(int id, LecturerModel model)
{
var lecturer = _repo.Get <Lecturer>(model.LecturerId);
var entity = model.Edit(lecturer, model);
_repo.Update(model.LecturerId, entity);
}
public ActionResult SelectAllUsers()
{
if (Session["USER"] != null)
{
if (lecturer.IsAdmin == 1)
{
if (lecturer.Priority >= 7)
{
LecturerModel lecturer = new LecturerModel();
AccountModel account = new AccountModel();
List <AccountModel> accounts = account.GetAccount(null, null);
List <LecturerModel> lecturerList = lecturer.GetLecturer(null, null);
foreach (LecturerModel item in lecturerList)
{
foreach (AccountModel item2 in accounts)
{
if (item.AccId == item2.AccId)
{
item.Username = item2.Username;
item.Password = item2.Password;
item.Priority = item2.Priority;
item.IsAdmin = item2.IsAdmin;
}
}
}
return(View(lecturerList));
}
}
}
return(RedirectToAction("Index", "Home"));
}
private bool isValidModel(LecturerModel model)
{
return(!model.Name.Equals(string.Empty) &&
!model.Pulpit.Equals(string.Empty) &&
!model.LectureHall.Equals(string.Empty) &&
!model.PhoneNumber.Equals(string.Empty));
}
public ActionResult Login(FormCollection form)
{
LecturerModel lecturer = new LecturerModel(form["Username"].ToString(), form["Password"].ToString());
List <AccountModel> accounts = lecturer.GetAccount(null, new List <string> {
"username = '******'", "AccPassword = '******'"
});
if (accounts.Count > 0)
{
List <LecturerModel> lecList = lecturer.GetLecturer(null, new List <string> {
"AccountID = " + accounts[0].AccId
});
lecturer = new LecturerModel(accounts[0].Username, accounts[0].Password, accounts[0].Priority, accounts[0].IsAdmin);
lecturer.AccId = accounts[0].AccId;
lecturer.Name = lecList[0].Name;
lecturer.Surname = lecList[0].Surname;
lecturer.Cell = lecList[0].Cell;
lecturer.Email = lecList[0].Email;
lecturer.Level = lecList[0].Level;
lecturer.LectID = lecList[0].LectID;
System.Web.HttpContext.Current.Session["USER"] = lecturer;
return(View("~/Views/Home/Index.cshtml"));
}
else
{
lecturer = null; //Invalid Credentials, Reset Lecturer Object
return(View("~/Views/Account/Login.cshtml", lecturer));
}
}
public async Task <ResponseModel> Insert(LecturerModel model)
{
ResponseModel response = new ResponseModel();
try
{
Lecturer md = new Lecturer();
md.Name = model.Name;
md.Avatar = model.Avatar;
md.Gender = model.Gender;
md.DateOfBirth = model.DateOfBirth;
md.Phone = model.Phone;
md.Mobile = model.Mobile;
md.Fax = model.Fax;
md.Email = model.Email;
md.Rating = model.Rating;
md.IsWorkInCenter = model.IsWorkInCenter;
md.TrainingCenterId = model.TrainingCenterId;
md.IsActive = model.IsActive;
md.CreateBy = base.UserId;
md.CreateDate = DateTime.Now;
await _context.LecturerRepository.AddAsync(md).ConfigureAwait(true);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public async Task <ResponseModel> Delete(LecturerModel model)
{
ResponseModel response = new ResponseModel();
try
{
Lecturer md = await _context.LecturerRepository.FirstOrDefaultAsync(m => m.Id == model.Id);
if (!md.RowVersion.SequenceEqual(model.RowVersion))
{
response.ResponseStatus = Core.CommonModel.Enums.ResponseStatus.OutOfDateData;
return(response);
}
md.Deleted = true;
md.UpdateBy = base.UserId;
md.UpdateDate = DateTime.Now;
_context.LecturerRepository.Update(md);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public void insertLecturer(LecturerModel objLec)
{
try
{
string Query = "Insert into lecturers(lecturer_name,emp_id,faculty,department,center,building,level_s,rank_s) " + "values('"
+ objLec.Name + "','"
+ objLec.EmpId + "','"
+ objLec.Faculty + "','"
+ objLec.Department + "','"
+ objLec.Center + "','"
+ objLec.Building + "','"
+ objLec.Level + "','"
+ objLec.Rank + "')";
SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection);
SqlDataReader myReader;
DBConnection.OpenConnection();
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
}
DBConnection.CloseConnection();
}
catch (Exception ex)
{
}
}
public List <LecturerModel> getLecturers()
{
List <LecturerModel> listLecturer = new List <LecturerModel>();
try
{
string Query = "Select lecturer_name,emp_id,faculty,department,center,building,level_s,rank_s from lecturers";
SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection);
SqlDataReader myReader;
DBConnection.OpenConnection();
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
LecturerModel objLecturer = new LecturerModel();
objLecturer.Name = myReader["lecturer_name"].ToString();
objLecturer.EmpId = myReader["emp_id"].ToString();
objLecturer.Faculty = myReader["faculty"].ToString();
objLecturer.Department = myReader["department"].ToString();
objLecturer.Center = myReader["center"].ToString();
objLecturer.Building = myReader["building"].ToString();
objLecturer.Level = myReader["level_s"].ToString();
objLecturer.Rank = myReader["rank_s"].ToString();
listLecturer.Add(objLecturer);
}
}
catch (Exception ex)
{
}
return(listLecturer);
}
private void EditCurrentLecturer(object obj)
{
var view = CollectionViewSource.GetDefaultView(Lecturers);
LecturerModel selectedLecturer = view.CurrentItem as LecturerModel;
foreach (var subject in SpecialtiesCollection.Instance.SpecWithStudents)
{
if (selectedLecturer.Subjects.Contains(subject.Key))
{
LecturerStudents.AddRange(subject.Value);
}
}
this.CurrentLecturer.FirstName = selectedLecturer.FirstName;
this.CurrentLecturer.LastName = selectedLecturer.LastName;
this.CurrentLecturer.PersonalNumber = selectedLecturer.PersonalNumber;
this.CurrentLecturer.Gender = selectedLecturer.Gender;
this.CurrentLecturer.Title = selectedLecturer.Title;
this.CurrentLecturer.Faculty = selectedLecturer.Faculty;
this.CurrentLecturer.CurrentSubjects = string.Join(", ", selectedLecturer.Subjects);
this.CurrentLecturer.Region = selectedLecturer.Region;
this.CurrentLecturer.BirthDate = selectedLecturer.BirthDate;
this.CurrentLecturer.Students = string.Join(", ", LecturerStudents);
}
private IEnumerable <LecturerModel> GetSampleLecturers(LecturerModel student = null)
{
List <LecturerModel> common = new List <LecturerModel>()
{
new LecturerModel()
{
Id = 1, Email = "*****@*****.**", Phone = "8 911 929-22-22", Le_First_Name = "Bob", Le_Last_Name = "Marley"
},
new LecturerModel()
{
Id = 2, Email = "*****@*****.**", Phone = "8 811 919-22-22", Le_First_Name = "Bob1", Le_Last_Name = "Marley1"
},
new LecturerModel()
{
Id = 3, Email = "*****@*****.**", Phone = "8 911 939-22-22", Le_First_Name = "Bob2", Le_Last_Name = "Marley2"
},
};
if (student != null)
{
common[student.Id] = student;
}
//var result = from commonModel in common group commonModel by commonModel.St_Last_Name;
return(common);
}
private void OkButton_Click(object sender, EventArgs e)
{
var selectedRows = Lecturers.SelectedRows;
LecturerModel model = GetLecturerModelFromRow(selectedRows[0]);
DataContainer.LecturerModel = model;
this.Close();
}
private void DeleteCurrentLecturer(object obj)
{
var view = CollectionViewSource.GetDefaultView(Lecturers);
LecturerModel selectedLecturer = view.CurrentItem as LecturerModel;
Lecturers.Remove(selectedLecturer);
}
public async Task <LecturerModel> AddLecturer(LecturerModel model)
{
var addLecturer = new Lecturer().Assign(model);
_context.Lecturers.Add(addLecturer);
await _context.SaveChangesAsync();
return(new LecturerModel().Assign(addLecturer));
}
private void AddLecturerToTable(LecturerModel model)
{
int rowNum = Lecturers.Rows.Add();
Lecturers.Rows[rowNum].Cells[0].Value = model.Name;
Lecturers.Rows[rowNum].Cells[1].Value = model.Pulpit;
Lecturers.Rows[rowNum].Cells[2].Value = model.LectureHall;
Lecturers.Rows[rowNum].Cells[3].Value = model.DateOfBirth;
Lecturers.Rows[rowNum].Cells[4].Value = model.PhoneNumber;
}
public async Task Edit(LecturerModel item)
{
await Task.Run(() =>
{
var element = lecturers.Where(x => x.Id == item.Id).FirstOrDefault();
lecturers.Remove(element);
lecturers.Add(item);
});
}
public async Task Add(LecturerModel item)
{
if (lecturers.Where(x => x.FirstName.ToLower() == item.FirstName.ToLower() && x.LastName.ToLower() == item.LastName.ToLower()).Count() == 0)
{
await Task.Run(() => {
item.Id = lecturers.Count;
item.Id++;
lecturers.Add(item);
});
}
}
private void AddButton_Click(object sender, EventArgs e)
{
LecturerModel model = GetLecturerModelFromInputs();
if (isValidModel(model))
{
DataContainer.Lecturers.Add(model);
DataContainer.SerializeLecturers();
AddLecturerToTable(model);
}
}
public void AddMail_Exception()
{
LecturersService service = new LecturersService();
LecturerModel expected = new LecturerModel()
{
Id = 4,
Le_Last_Name = "ddad",
Le_First_Name = "sasd",
Phone = "8 999 222-11-11",
Email = "23233.ru"
};
Assert.Throws <InvalidMailExeption>(() => service.AddLecturer(expected));
}
public void AddName_Exception()
{
LecturersService service = new LecturersService();
LecturerModel expected = new LecturerModel()
{
Id = 4,
Le_Last_Name = "242df34",
Le_First_Name = "s41s",
Phone = "8 999 222-11-11",
Email = "*****@*****.**"
};
Assert.Throws <InvalidNameException>(() => service.AddLecturer(expected));
}
public void AddPhone_Exception()
{
LecturersService service = new LecturersService();
LecturerModel expected = new LecturerModel()
{
Id = 4,
Le_Last_Name = "ddds",
Le_First_Name = "ssad",
Phone = "42s4d323",
Email = "*****@*****.**",
};
Assert.Throws <InvalidPhoneException>(() => service.AddLecturer(expected));
}
public ActionResult Create(LecturerModel model)
{
ViewBag.programmes = new SelectList(_attmgr.GetProgrammes(), "ProgrammeId", "ProgrammeName");
ViewBag.colleges = new SelectList(_attmgr.GetColleges(), "CollegeId", "CollegeName");
if (!ModelState.IsValid)
{
TempData["Message"] = "Lecturer is not valid";
return(View("Create", model));
}
_attmgr.Add(model);
TempData["Message"] = "Lecturer has been successfully added";
return(RedirectToAction("Index"));
}
public async Task <LecturerModel> AssignCourseToLecturer(LecturerModel model)
{
var getlecturer = await _context.Lecturers.FirstOrDefaultAsync(l => l.Id == model.Id);
getlecturer.Courses = model.Courses.Select(x => new Courses()
{
CourseCode = x.CourseCode,
CourseDescription = x.CourseDescription,
Id = x.Id,
CourseUnit = x.CourseUnit
}).ToList();
await _context.SaveChangesAsync();
return(new LecturerModel().Assign(getlecturer));
}
private void SaveCurrentLecturer(object obj)
{
var view = CollectionViewSource.GetDefaultView(Lecturers);
LecturerModel selectedLecturer = view.CurrentItem as LecturerModel;
selectedLecturer.FirstName = this.CurrentLecturer.FirstName;
selectedLecturer.LastName = this.CurrentLecturer.LastName;
selectedLecturer.PersonalNumber = this.CurrentLecturer.PersonalNumber;
selectedLecturer.Gender = this.CurrentLecturer.Gender;
selectedLecturer.Title = this.CurrentLecturer.Title;
selectedLecturer.Faculty = this.CurrentLecturer.Faculty;
selectedLecturer.Subjects = this.CurrentLecturer.CurrentSubjects.Split(", ".ToArray()).ToList();
selectedLecturer.Region = this.CurrentLecturer.Region;
selectedLecturer.BirthDate = this.CurrentLecturer.BirthDate;
}
public void FindLecturersById_ValidCall()
{
Mock <ILecturerRepository> mockGradeRepository = MockLecturerRepository;
mockGradeRepository.Setup(mr => mr.FindByID(It.IsAny <int>()))
.Returns((int s) => GetSampleLecturers().Where(x => x.Id == s).FirstOrDefault());
_mockLecturerRepository = mockGradeRepository.Object;
int checkingId = 1;
LecturerModel expected = _mockLecturerRepository.FindByID(checkingId);
var t = GetSampleLecturers().Where(x => x.Id == checkingId);
Assert.True(expected != null); // Test if null
Assert.That(expected.Le_Last_Name, Is.EqualTo(GetSampleLecturers().FirstOrDefault(x => x.Id == checkingId).Le_Last_Name));
}
public ActionResult Edit(LecturerModel model)
{
ViewBag.colleges = new SelectList(_attmgr.GetColleges(), "CollegeId", "CollegeName");
ViewBag.programmes = new SelectList(_attmgr.GetProgrammeByCollegeId(model.CollegeId ?? 0), "ProgrammeId", "ProgrammeName");
if (ModelState.IsValid)
{
if (model == null)
{
TempData["Message"] = "Lecturer is not found";
return(View("Index"));
}
_attmgr.Update(model.LecturerId, model);
return(RedirectToAction("Index"));
}
return(View(model));
}
public ActionResult ForgotPassword(int accid, FormCollection form)
{
LecturerModel lecturer = new LecturerModel();
List <AccountModel> accounts = lecturer.GetAccount(null, new List <string> {
"id = " + accid + ""
});
HttpCookie gdsjhgfjhsdgjhf = new HttpCookie("gdsjhgfjhsdgjhf", accid.ToString());
Response.Cookies.Add(gdsjhgfjhsdgjhf);
if (form["password"].ToString() != null)
{
lecturer.Password = form["password"].ToString();
lecturer.ChangeAccount(new List <string> {
"id = " + accid + ""
});
}
return(View());
}
private static void ValidateLecturerName(LecturerModel lec)
{
if (lec == null)
{
throw new ArgumentNullException(nameof(lec));
}
_regex = new Regex(RegexName);
if (!_regex.IsMatch(lec.Le_First_Name))
{
Log.MakeLog(LoggerOperations.Error, "InvalidNameException");
throw new InvalidNameException(lec.Le_First_Name);
}
if (!_regex.IsMatch(lec.Le_Last_Name))
{
Log.MakeLog(LoggerOperations.Error, "InvalidNameException");
throw new InvalidNameException(lec.Le_Last_Name);
}
}
public void deleteLecturer(LecturerModel objlecture)
{
try
{
string Query = "Delete from college_db.lecturers where emp_id = '" + objlecture.EmpId + "'";
MySqlConnection con = new MySqlConnection(DBConnection.ConnectionString);
MySqlCommand cmd = new MySqlCommand(Query, con);
MySqlDataReader myReader;
con.Open();
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
}
con.Close();
}
catch (Exception ex)
{
}
}
public void deleteLecturer(LecturerModel objlecture)
{
try
{
string Query = "Delete from lecturers where emp_id = '" + objlecture.EmpId + "'";
SqlCommand cmd = new SqlCommand(Query, DBConnection.DatabaseConnection);
SqlDataReader myReader;
DBConnection.OpenConnection();
myReader = cmd.ExecuteReader();
while (myReader.Read())
{
}
DBConnection.CloseConnection();
}
catch (Exception ex)
{
}
}
