protected void Page_Load(object sender, EventArgs e)
{
if (Session["loginSession"] == null)
{
Response.Write("<script>location.href='/Login.aspx';</script>");
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "location.href='/Login.aspx';", true);
return;
}
else
{
if (Session["loginIden"].ToString() != "Teacher")
{
Response.Write("<script>location.href='/Login.aspx';</script>");
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "location.href='/Login.aspx';", true);
return;
}
if (Session["modifyErrorMsg"] != null) // 修改失败
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "errorMsg",
"$(document).ready(function(){changeBorderColor('#" + Session["modifyErrorID"] + "','" + Session["modifyErrorMsg"] + "');});", true);
Session["modifyErrorID"] = null;
Session["modifyErrorMsg"] = null;
}
if (!IsPostBack)
{
Models.Teacher teacher = BLL_Teacher.query(Session["loginSession"].ToString());
inputUsername.Text = teacher.username;
selectorSex.SelectedIndex = Boolean.Parse(teacher.sex) ? 0 : 1;
inputYear.Text = teacher.age;
}
}
}
public string Save(Models.Teacher teacher)
{
if (IsEmailExists(teacher))
{
return("Email Already Exixts");
}
return(teacherGateway.Save(teacher));
}
public Models.Teacher CreateTeacher(Guid divisionId, string firstName, string lastName, string email, string phone, string highlightColor, bool isActive)
{
Division division = this.DataContext.Get <Division>().Where(x => x.Id == divisionId).FirstOrDefault();
if (division == null)
{
throw new InvalidOperationException($"Division ({divisionId}) does not exist.");
}
if (String.IsNullOrEmpty(highlightColor))
{
Random rand = new Random();
highlightColor = Commons.Ultility.GetHighlightColor(rand);
}
Models.Profile profile = new Models.Profile()
{
Id = Guid.NewGuid(),
FirstName = firstName,
LastName = lastName,
Email = email,
Phone = phone,
HighlightColor = highlightColor,
IsDeleted = false
};
Models.Account account = new Models.Account()
{
Id = Guid.NewGuid(),
Profile = profile,
IsActive = isActive,
IsDeleted = false
};
Models.Teacher teacher = new Models.Teacher()
{
Id = Guid.NewGuid(),
Account = account,
IsActive = isActive,
IsDeleted = false,
};
TeacherDivision teacherDivision = new TeacherDivision()
{
Id = Guid.NewGuid(),
TeacherId = teacher.Id,
DivisionId = divisionId
};
teacher.TeacherDivisions.Add(teacherDivision);
this.DataContext.Insert <Models.Profile>(profile);
this.DataContext.Insert <Models.Account>(account);
this.DataContext.Insert <Models.Teacher>(teacher);
this.DataContext.Insert <TeacherDivision>(teacherDivision);
return(teacher);
}
private Models.Teacher AddNewTeacher()
{
var teacher = new Models.Teacher()
{
Name = "TeacherTest",
};
var addedTeacher = _teacherRepository.GenericsDbContext.Add(teacher);
_teacherRepository.GenericsDbContext.SaveChanges();
return(teacher);
}
public void UpdateRecord(int id, Models.Teacher ts)
{
var data = context.Teachers.SingleOrDefault(s => s.TeacherId == id);
data.TeacherName = ts.TeacherName;
data.TeacherDepartment = ts.TeacherDepartment;
data.TeacherExprience = ts.TeacherExprience;
data.TeacherSalary = ts.TeacherSalary;
context.SaveChanges();
}
protected void btnAddTeachers_Click(object sender, EventArgs e)
{
DepartmentAdminDAL dal = new DepartmentAdminDAL();
var crnRow = this.dvwTeacherCourse.Rows[1];
var crnCell = crnRow.Cells[1];
var crn = int.Parse(crnCell.Text);
string teacherID = this.ddlTeachers.SelectedValue;
TeacherDAL tdal = new TeacherDAL();
Models.Teacher teacher = tdal.GetTeacherByTeacherID(teacherID);
dal.AssignTeacherToCourse(teacher, crn);
}
public async Task insertTeacher(Models.Teacher teacher)
{
Models.Db.Faculty dbFaculty = await this.getDbFaculty(briefName : teacher.faculty.briefName);
if (dbFaculty == null)
{
throw new System.ArgumentException("invalid faculty");
}
this.Database.ExecuteSqlCommand(
"insert into teacher (name, faculty_id) values ({0}, {1})",
teacher.name, dbFaculty.id);
}
public async Task updateTeacher(int id, Models.Teacher update)
{
Models.Db.Faculty dbFaculty = await this.getDbFaculty(briefName : update.faculty.briefName);
if (dbFaculty == null)
{
throw new System.ArgumentException("invalid faculty");
}
this.Database.ExecuteSqlCommand(
"update teacher set name={0}, faculty_id={1} where id={2}",
update.name, dbFaculty.id, id);
}
public string Save(Models.Teacher teacher)
{
string query =
"INSERT INTO Teacher(Name,TeacherAddress,Email,ContactNo,DesignationId,DepartmentId,CreditToBeTaken,TakenCredit) VALUES ('" +
teacher.Name + "','" + teacher.Address + "','" + teacher.Email + "','" + teacher.ContactNo + "','" +
teacher.DesignationId + "','" + teacher.DepartmentId + "','" + teacher.CreditToBeTaken + "','0.00')";
Connection.Open();
Command.CommandText = query;
int rowsEffected = Command.ExecuteNonQuery();
Connection.Close();
return("Teacher Saved Successfully");
}
/// <summary>
/// Shows info on the teacher that can be deleted.
/// <example> /Teacher/DeleteConfirm </example>
/// </summary>
/// <param></param>
/// <return>Routes back to selected teacher if canceled.</return>
public ActionResult DeleteConfirm(int?id)
{
Models.Teacher NewTeacher = new Models.Teacher();
if (id == null)
{
NewTeacher = null;
}
else
{
TeacherDataController controller = new TeacherDataController();
NewTeacher = controller.ShowTeacher((int)id);
}
return(View(NewTeacher));
}
public ActionResult Login(Models.Teacher user)
{
if (ModelState.IsValid)
{
if (Helpers.IsValid.CheckIsValid(user.LoginId, user.PassWD))
{
FormsAuthentication.SetAuthCookie(user.LoginId, true);
return(RedirectToAction("Index", "Home"));
}
else
{
ModelState.AddModelError("", "Felaktig inloggning!");
}
}
return(View(user));
}
public ActionResult CreateTeacher()
{
int schoolid = User.GetSchoolID();
BLL.ACBaseExecService.ExecSQL("Delete Teachers Where SchoolID={0}", schoolid);
string s = Request.Form["data"];
BllTeacher bc = new BllTeacher();
foreach (var c in s.Split('\n'))
{
Models.Teacher mc = new Models.Teacher();
mc.TeacherName = c;
mc.SchoolID = schoolid;
bc.Add(mc, false);
}
bc.Save();
return Content("T");
}
protected void buttonSubmit_Click(object sender, EventArgs e)
{
if (Session["loginSession"] == null || Session["loginIden"].ToString() != "Teacher")
{
return;
}
string username = Session["loginSession"].ToString();
string oldpassword = inputOldPassword.Text.Trim();
string sex = selectorSex.SelectedValue;
string password = inputPassword.Text.Trim();
string age = inputYear.Text.Trim();
if (!BLL_Teacher.login(username, oldpassword))
{
Session["modifyErrorID"] = "stdContentMoudle_stdContent_inputOldPassword";
Session["modifyErrorMsg"] = "原密码输入错误！";
Response.Write("<script>location.href='/Teacher/Modify.aspx';</script>");
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "location.href='/Teacher/Modify.aspx';", true);
return;
}
Models.Teacher teacher = null;
if (password.Length == 0)
{
teacher = new Models.Teacher(username, "", sex, age);
}
else
{
teacher = new Models.Teacher(username, password, sex, age);
}
if (BLL_Teacher.modify(teacher))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "alert", "alert('修改成功，刷新页面查看更新后的内容！');", true);
Response.Write("<script>location.href='/Teacher/Modify.aspx';</script>");
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "transfer", "location.href='/Teacher/Modify.aspx';", true);
}
else
{
Session["modifyErrorID"] = "stdContentMoudle_stdContent_inputOldPassword";
Session["modifyErrorMsg"] = "原密码输入错误！";
Response.Write("<script>location.href='/Teacher/Modify.aspx';</script>");
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "location.href='/Teacher/Modify.aspx';", true);
}
}
public ActionResult Teacher_registration(Models.Teacher teacher)
{
ViewBag.Message = "Your Course page.";
if (ModelState.IsValid)
{
db.Teachers.Add(teacher);
try
{
db.SaveChanges();
return(RedirectToAction("Teacher_registration"));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
}
}
return(View());
}
public IActionResult Update(Models.Teacher teacher)
{
ViewBag.ListFaculty = new SelectList(_db.Faculties.ToList(), "Id", "Name");
if (ModelState.IsValid)
{
try
{
_db.Update(teacher);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception e)
{
ModelState.AddModelError("", e.Message);
}
}
return(View(teacher));
}
private void fetchData() // wczytanie wiadomości z serwera
{
// obecnie zalogowany student
Models.Teacher teacher = ((MainWindow)Application.Current.MainWindow).loggedUser;
// jeśli odebrane
if (type == "received")
{
MessagesList.Clear();
foreach (Models.Message message in _context.Message)
{
if (message.Teacher == teacher)
{
if (message.SenderId != teacher.Id)
{
MessagesList.Add(message);
}
}
}
MessagesList = MessagesList.OrderByDescending(m => m.Date).ToList();
MessageBox.ItemsSource = null;
MessageBox.ItemsSource = MessagesList;
MainLabel.Content = "Odebrane";
}
// jeśli wysłane
else if (type == "sent")
{
MessagesList.Clear();
foreach (Models.Message message in _context.Message)
{
if (message.Teacher == teacher)
{
if (message.SenderId == teacher.Id)
{
MessagesList.Add(message);
}
}
}
MessagesList = MessagesList.OrderByDescending(m => m.Date).ToList();
MessageBox.ItemsSource = null;
MessageBox.ItemsSource = MessagesList;
MainLabel.Content = "Wysłane";
}
}
/// <summary>
/// Adds new teacher to the database database.
/// <example> /Teacher/List </example>
/// </summary>
/// <param></param>
/// <return>List of all teacher names</return>
//POST : /Teacher/Create
public ActionResult Create(string TeacherFname, string TeacherLname, float Salary)
{
//Identify this method is running
//Identify the inpiuts provided from the form
Debug.WriteLine(TeacherFname);
Debug.WriteLine(TeacherLname);
Debug.WriteLine(Salary);
Models.Teacher NewTeacher = new Models.Teacher();
NewTeacher.TeacherFname = TeacherFname;
NewTeacher.TeacherLname = TeacherLname;
NewTeacher.Salary = Salary;
TeacherDataController controller = new TeacherDataController();
controller.AddTeacher(NewTeacher);
return(RedirectToAction("List"));
}
private void AddData(HttpContext context)
{
var teaModel = new Models.Teacher();
teaModel.TeacherId = Guid.NewGuid();
SetModelValue(teaModel, context);
teaModel.CreateTime = DateTime.Now;
teaModel.LastModifyTime = DateTime.Now;
var teaBll = new BLL.Teacher();
var result = false;
var msg = "";
try
{
//var sysUserMo = new Models.SysUser();
//var sysuserbll = new BLL.SysUser();
//sysUserMo.UserRole = (int)EnumUserRole.Student;
//sysUserMo.UserName = teaModel.TeacherName;
//sysUserMo.UserId = teaModel.TeacherId;
//sysUserMo.UserPassWord = Common.defaultPwd;
//sysUserMo.UserAccount = teaModel.IdentityNo;
//sysuserbll.Add(sysUserMo);
result = teaBll.Add(teaModel);
if (!result)
{
msg = "保存失败！";
}
}
catch (Exception ex)
{
LogHelper.WriteLogofExceptioin(ex);
result = false;
msg = ex.Message;
}
// var str = JsonConvert.SerializeObject(new { success = result, errorMsg = msg});
context.Response.Write(msg);
}
public async Task <IActionResult> Create(TeacherCreateViewModel vm)
{
if (ModelState.IsValid)
{
var user = new Person()
{
UserName = vm.Username,
Name = vm.Name,
Email = vm.Name,
PhoneNumber = vm.Sdt,
};
var result = await _userManager.CreateAsync(user, vm.Password);
if (result.Succeeded)
{
await _userManager.AddToRoleAsync(user, SD.Teacher);
var s = await _userManager.FindByNameAsync(user.UserName);
var teacher = new Models.Teacher()
{
PersonId = s.Id, FacultyId = vm.FaculityId
};
_db.Teachers.Add(teacher);
_db.SaveChanges();
return(RedirectToAction("index", "Teacher", new { area = "admin" }));
}
else
{
foreach (var er in result.Errors)
{
ModelState.AddModelError("", er.Description);
}
}
}
ViewBag.ListFaculty = new SelectList(_db.Faculties.ToList(), "Id", "Name");
return(View(vm));
}
protected void AvailableCourses_SelectedIndexChanged(object sender, EventArgs e)
{
int crn = (int)this.AvailableCoursesGrid.SelectedValue;
HttpContext.Current.Session["chosenCRN"] = crn;
CourseDAL courseGetter = new CourseDAL();
Course courseToAdd = courseGetter.GetCourseByCRN(crn);
TeacherDAL dal = new TeacherDAL();
Models.Teacher instructor = dal.GetTeacherByCRN(crn);
string instructorName = instructor != null ? instructor.Name : "TBA";
this.lblCourseToAdd.Text = "Course to Add: " + courseToAdd.CRN + " " + courseToAdd.Name + " " +
courseToAdd.SectionNumber + " Instructor: " + instructorName;
CourseSignUpHelper degreeChecker = new CourseSignUpHelper();
var current = HttpContext.Current.Session["User"] as User;
if (!degreeChecker.CheckIfCourseContributesToMajor(crn, current.UserId))
{
this.lblCourseToAdd.Text +=
Environment.NewLine + "This course does not contribute to your degree program.";
}
}
/// <summary>
/// Receives a POST request containing information about an existing teacher in the system, with new values. Conveys this information to the API, and redirects to the "Teacher Show" page of our updated teacher.
/// </summary>
/// <param name="id">Id of the Author to update</param>
/// <param name="TeacherFname">The updated first name of the teacher</param>
/// <param name="TeacherLname">The updated last name of the teacher</param>
/// <param name="Salary">The updated salary of the teacher.</param>
/// <param name="HireDate">The updated hire date of the teacher.</param>
/// <param name="EmployeeNumber">The updated employee number of the teacher.</param>
/// <returns>A dynamic webpage which provides the current information of the teacher.</returns>
/// <example>
/// POST : /Author/Update/10
/// FORM DATA / POST DATA / REQUEST BODY
/// {
/// "TeacherFname":Chris
/// "TeacherLname":Kinsman
/// "Salary":1000.00
/// "HireDate":12,12,2020
/// "EmployeeNumber":T402
/// }
/// </example>
public ActionResult Update(int id, string TeacherFname, string TeacherLname, string Salary, string HireDate, string EmployeeNumber)
{
//Identify this method is running
//Identify the inpiuts provided from the form
Debug.WriteLine(TeacherFname);
Debug.WriteLine(TeacherLname);
Debug.WriteLine(Salary);
Debug.WriteLine(HireDate);
Debug.WriteLine(EmployeeNumber);
Models.Teacher NewTeacher = new Models.Teacher();
NewTeacher.TeacherFname = TeacherFname;
NewTeacher.TeacherLname = TeacherLname;
NewTeacher.Salary = Salary;
NewTeacher.HireDate = HireDate;
NewTeacher.EmployeeNumber = EmployeeNumber;
TeacherDataController controller = new TeacherDataController();
controller.UpdateTeacher(id, NewTeacher);
return(RedirectToAction("Show/" + id));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.Teacher GetModel(Guid TeacherId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 TeacherId,IdentityNo,TeacherName,Gender,Title,Dept,CreateTime,LastModifyTime, Picture, Post, Research, Mobile, Status, Description from Teacher ");
strSql.Append(" where TeacherId=@TeacherId ");
SqlParameter[] parameters = {
new SqlParameter("@TeacherId", SqlDbType.UniqueIdentifier,16) };
parameters[0].Value = TeacherId;
Models.Teacher model = new Models.Teacher();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
public Models.Teacher UpdateTeacher(Guid id, Guid divisionId, string firstName, string lastName, string email, string phone, string highlightColor, bool isActive)
{
Models.Teacher teacher = this.GetById(id);
if (teacher == null)
{
throw new InvalidOperationException($"Teacher ({id}) does not exist.");
}
teacher.IsActive = isActive;
Division division = this.DataContext.Get <Division>().Where(x => x.Id == divisionId).FirstOrDefault();
if (division == null)
{
throw new InvalidOperationException($"Division ({divisionId}) does not exist.");
}
if (teacher.TeacherDivisions.Count(x => x.DivisionId == divisionId) <= 0)
{
// Remove existing
teacher.TeacherDivisions.Clear();
// Add
TeacherDivision teacherDivision = new TeacherDivision()
{
Id = Guid.NewGuid(),
TeacherId = teacher.Id,
DivisionId = division.Id
};
teacher.TeacherDivisions.Add(teacherDivision);
}
Models.Account account = this.DataContext.Get <Models.Account>().Where(x => x.Id == teacher.AccountId).FirstOrDefault();
if (account == null)
{
throw new InvalidOperationException($"Account ({teacher.AccountId}) does not exist.");
}
account.IsActive = isActive;
Models.Profile profile = this.DataContext.Get <Models.Profile>().Where(x => x.Id == account.ProfileId).FirstOrDefault();
if (profile == null)
{
throw new InvalidOperationException($"Profile ({account.ProfileId}) does not exist.");
}
if (String.IsNullOrEmpty(highlightColor))
{
Random rand = new Random();
highlightColor = Commons.Ultility.GetHighlightColor(rand);
}
profile.FirstName = firstName;
profile.LastName = lastName;
profile.Email = email;
profile.Phone = phone;
profile.HighlightColor = highlightColor;
this.DataContext.Update <Models.Profile, Guid>(profile, x => x.FirstName, x => x.LastName, x => x.Email, x => x.Phone);
this.DataContext.Update <Models.Account, Guid>(account, x => x.IsActive);
this.DataContext.Update <Models.Teacher, Guid>(teacher, x => x.IsActive);
return(teacher);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.Teacher DataRowToModel(DataRow row)
{
Models.Teacher model = new Models.Teacher();
if (row != null)
{
if(row["TeacherId"]!=null && row["TeacherId"].ToString()!="")
{
model.TeacherId= new Guid(row["TeacherId"].ToString());
}
if(row["IdentityNo"]!=null)
{
model.IdentityNo=row["IdentityNo"].ToString();
}
if(row["TeacherName"]!=null)
{
model.TeacherName=row["TeacherName"].ToString();
}
if(row["Gender"]!=null && row["Gender"].ToString()!="")
{
model.Gender=int.Parse(row["Gender"].ToString());
}
if(row["Title"]!=null)
{
model.Title=row["Title"].ToString();
}
if(row["Dept"]!=null)
{
model.Dept=row["Dept"].ToString();
}
if(row["CreateTime"]!=null && row["CreateTime"].ToString()!="")
{
model.CreateTime=DateTime.Parse(row["CreateTime"].ToString());
}
if(row["LastModifyTime"]!=null && row["LastModifyTime"].ToString()!="")
{
model.LastModifyTime=DateTime.Parse(row["LastModifyTime"].ToString());
}
if (row["Picture"] != null && row["Picture"].ToString() != "")
{
model.Picture = row["Picture"].ToString();
}
if (row["Post"] != null && row["Post"].ToString() != "")
{
model.Post = row["Post"].ToString();
}
if (row["Research"] != null && row["Research"].ToString() != "")
{
model.Research = row["Research"].ToString();
}
if (row["Mobile"] != null && row["Mobile"].ToString() != "")
{
model.Mobile = row["Mobile"].ToString();
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["Description"] != null && row["Description"].ToString() != "")
{
model.Description = row["Description"].ToString();
}
/*
, Picture, Post, Research, Mobile, Status, Description*/
}
return model;
}
public void InsertRecord(Models.Teacher ts)
{
context.Teachers.Add(ts);
context.SaveChanges();
}
private void Page_Loaded(object sendet, RoutedEventArgs e)
{
Models.Teacher teacher = ((MainWindow)Application.Current.MainWindow).loggedUser;
mainLabel.Content = "Strona główna nauczyciela";
teacherLabel.Content = teacher.ToString();
}
public bool IsEmailExists(Models.Teacher teacher)
{
return(teacherGateway.IsEmailExists(teacher));
}
