protected void DetailsView3_ItemInserting(object sender, DetailsViewInsertEventArgs e) //course 插入判断
{
CourseManager course = new CourseManager();
TeacherManager t = new TeacherManager();
if (e.Values["num"] == null || e.Values["teacher"] == null || e.Values["name"] == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败！course表中num,teacher,name字段都不能为空');", true);
e.Cancel = true;
return;
}
if (course.GetCourseByNum(e.Values["num"].ToString()) != null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败！course表中num已存在');", true);
e.Cancel = true;
return;
}
if (t.GetTeacher(e.Values["teacher"].ToString()) == null)
{
ScriptManager.RegisterClientScriptBlock(UpdatePanel1, this.GetType(), "msg1", "alert('插入失败！course表中外键teacher不存在');", true);
e.Cancel = true;
return;
}
}
private void registerButton_Click(object sender, EventArgs e)
{
if (!ValidateInfo())
{
return;
}
int id = TeacherManager.Register(
passwordTextBox.Text,
nameTextBox.Text,
brandTextBox.Text,
maleRadioButton.Checked ? SexType.Male : SexType.Female,
phoneTextBox.Text);
if (id > 0)
{
MessageBox.Show($"请牢记工号: {Utilities.DbIdConvertToTeaId(id)}",
"注册成功!",
MessageBoxButtons.OK, MessageBoxIcon.Information);
NeedConfirmOnExit = false;
Close();
}
else
{
MessageBox.Show("注册失败,请联系系统管理员", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Delete(int Id)
{
TeacherManager TeacherManager = new TeacherManager();
TeacherManager.DeleteTeacher(Id);
return(Json(true, JsonRequestBehavior.AllowGet));
}
public TeacherController()
{
designationManager = new DesignationManager();
departmentManager = new DepartmentManager();
teacherManager = new TeacherManager();
courseManager = new CourseManager();
}
public ActionResult CreateTeacherForIdari(User user, Teacher teacher)
{
TempData["EventResult"] = TeacherManager.addTeacher(user, teacher);
if (((SG_BLL.Tools.Result)TempData["EventResult"]).Status.Equals("error"))
{
var schools = SchoolManager.GetSchools();
var list = new SelectList(schools, "SchoolId", "Ad");
ViewBag.SchoolList = list;
var items = new List <UnvanHelper>();
ResourceManager rm = new ResourceManager("SinavGorevlendirme.Resources.Genel", typeof(TeacherController).Assembly);
foreach (var unv in Enum.GetValues(typeof(EnumUnvan)))
{
items.Add(new UnvanHelper((int)unv, rm.GetString(unv.ToString())));
}
var unvanList = new SelectList(items, "UnvanId", "Unvan");
ViewBag.UnvanList = unvanList;
return(View());
}
return(RedirectToAction("CreateTeacherForIdari"));
}
public CourseController()
{
departmentManager = new DepartmentManager();
courseManager = new CourseManager();
semesterManager = new SemesterManager();
teacherManager = new TeacherManager();
}
public CourseAssignToTeacherController()
{
courseAssignToTeacherManager = new CourseAssignToTeacherManager();
teacherManager = new TeacherManager();
departmentManager = new DepartmentManager();
courseManager = new CourseManager();
}
public ActionResult ModifyTeacherPaw(string TeacherId)
{
TeacherId = Session["CurrentUser"].ToString(); //获取登录用户名
Teacher teacher = new TeacherManager().GetTeacherById(TeacherId); //调用通过id获取教师信息方法
return(View(teacher));
}
/// <summary>
/// 删除教师信息
/// </summary>
/// <param name="category">下拉列表传值</param>
/// <param name="keyWord">查询关键字</param>
/// <param name="pageIndex">每页索引数</param>
/// <returns></returns>
public ActionResult DeleteTeacher(string category, string keyWord, int pageIndex = 1)
{
int id = Convert.ToInt32(Request.QueryString["id"]);//获取教师id
TeacherManager manager = new TeacherManager();
manager.DeleteTeacherById(id); //调用删除教师方法
List <Teacher> teacher = new List <Teacher>(); //定义教师列表对象
//判断查询关键字是否为空
if (!String.IsNullOrEmpty(category))
{
TeacherQuery cate = (TeacherQuery)Enum.Parse(typeof(TeacherQuery), category);
teacher = new TeacherManager().GetTeacher(cate, keyWord);
}
else
{
teacher = new TeacherManager().GetTeacher();
}
//定义一个pagedList对象
PagedList <Teacher> pagedTeachers = new PagedList <Teacher>(teacher, pageIndex, pageSize);
//提供教师查询方式的下拉框
//调用查询方式
SetDropDownList1(category);
ViewData["keyWord"] = keyWord;
return(View("TeacherList", pagedTeachers));
}
public JsonResult GetTeacherByDepartmentId(int departmentId)
{
var teacher = new TeacherManager().GetAllTeachersByDepartment(departmentId);
var teacherList = teacher.ToList();
return(Json(teacherList));
}
private void departmentComboBox_SelectionChangeCommitted(object sender, EventArgs e)
{
// department wise teacher selection
int deptId = (int)departmentComboBox.SelectedValue;
TeacherManager teacherManager = new TeacherManager();
List <TeacherWithDepartmentViewModel> realteachers = teacherManager.GetAllTeacherWithDepartment(deptId); // -1 means all
teachereComboBox.DataSource = realteachers;
teachereComboBox.ValueMember = "TeacherId";
teachereComboBox.DisplayMember = "TeacherName";
// department wise course selection
CourseManager courseManager = new CourseManager();
List <Course> realCourses = courseManager.GetAllCourses(deptId);
courseCodeComboBox.DataSource = realCourses;
courseCodeComboBox.ValueMember = "Id";
courseCodeComboBox.DisplayMember = "Code";
hiddenDeptId.Text = deptId.ToString();
}
public TeachersPageViewModel()
{
NewTeacherCmd = new CommandBase((o) => { var item = TeacherManager.CreateTeacher(); Selected = item; }, (o) => true);
RemoveTeacherCmd = new CommandBase((o) => RemoveTeacher(), o => IsSelectedNotNull());
SaveChangesCmd = new CommandBase((o) => Selected.Save(), (o) => IsSelectedNotNull() && Selected.IsChanged());
DropChangesCmd = new CommandBase((o) => Selected.Drop(), (o) => IsSelectedNotNull() && !Selected.IsChanged());
}
public AccountController(AccountManager accountManager, TeacherManager teacherManager, DeaneryManager deaneryManager)
: base(accountManager)
{
AccountManager = accountManager;
TeacherManager = teacherManager;
DeaneryManager = deaneryManager;
}
private void saveButton_Click(object sender, EventArgs e)
{
//if --->validaton check
if (Convert.ToInt32(departmentComboBox.SelectedValue) == -1 || designationComboBox.SelectedValue.ToString().Equals("---Select---"))
{
MessageBox.Show(@"Please insert All Feild");
return;
}
Teacher teacher = new Teacher();
teacher.Name = nameTextBox.Text;
teacher.Address = addressTextBox.Text;
teacher.Email = emailTextBox.Text;
teacher.Contact = contactNoTextBox.Text;
teacher.DeptId = Convert.ToInt32(departmentComboBox.SelectedValue);
teacher.Designation = designationComboBox.SelectedValue.ToString();
teacher.CreditToBeTaken = float.Parse(creditToBeTakenTextBox.Text);
TeacherManager teacherManager = new TeacherManager();
string massage = teacherManager.SaveTeacher(teacher);
MessageBox.Show(massage);
}
public JsonResult GetTeacherInformationById(int teacherId)
{
var teacher = new TeacherManager().GetTeacherInformationById(teacherId);
teacher.CourseTaken = new TeacherGateway().GetTotalTakenCourses(teacherId);
return(Json(teacher));
}
//
// GET: /TeacherSub/
public ActionResult teacherAdd()
{
//前台接收的数据
string teacherName = Request["teacherName"] == null ? "" : Request["teacherName"].ToString();
string teacherNo = Request["teacherNo"] == null ? "" : Request["teacherNo"].ToString();
int teacherSex = Request["teacherSex"] == null ? 1 : int.Parse(Request["teacherSex"]);
string teacherDep = Request["teacherDep"] == null ? "" : Request["teacherDep"].ToString();
//帐户密码
string account = Request["account"] == null ? "" : Request["account"].ToString();
string password = Request["password"] == null ? "" : Request["password"].ToString();
string _role = Request["role"] == null?"-1":Request["role"].ToString();
int role = -1;
if (!int.TryParse(_role, out role))
{
role = -1;
}
account_info a = new account_info();
a.account = account;
a.password = password;
a.role = role;
Teacher t = new Teacher();
t.teacherName = teacherName;
t.teacherNo = teacherNo;
t.teacherSex = teacherSex;
t.teacherDep = teacherDep;
t.account = account;
MsgBox mb = new TeacherManager().teacherAdd(t, a);
return(Json(mb));
}
public ActionResult Add(TeacherViewModel teacherViewModel)
{
TeacherManager TeacherManager = new TeacherManager();
TeacherManager.AddTeacher(teacherViewModel);
return(Json(true, JsonRequestBehavior.AllowGet));
}
public JsonResult GetbyID(int ID)
{
TeacherManager TeacherManager = new TeacherManager();
IEnumerable <TeacherViewModel> TeacherList = TeacherManager.GetTeachers(ID);
return(Json(TeacherList.FirstOrDefault(), JsonRequestBehavior.AllowGet));
}
private IEnumerable <TeacherViewModel> ShowTeacherDetails()
{
TeacherManager teacherManager = new TeacherManager();
IEnumerable <TeacherViewModel> teacherDetails = teacherManager.GetTeachers();
return(teacherDetails);
}
public AssignCourseController()
{
departmentManager = new DepartmentManager();
teacherManager = new TeacherManager();
courseManager = new CourseManager();
assignCourseManager = new AssignCourseManager();
resultManager = new ResultManager();
}
public JsonResult GetTeachersByDepartmentId(int departmentId)
{
TeacherManager aTeacherManager = new TeacherManager();
var teachers = aTeacherManager.GetAllTeachers();
var teacherlist = teachers.Where(a => a.DepartmentId == departmentId).ToList();
return(Json(teacherlist, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTeacherInfoById(int Tid)
{
TeacherManager aTeacherManager = new TeacherManager();
var teachers = aTeacherManager.GetAllTeachers();
var teacher = teachers.FirstOrDefault(a => a.Id == Tid);
return(Json(teacher, JsonRequestBehavior.AllowGet));
}
public TeacherController()
{
aDepartmentManager = new DepartmentManager();
aDesignationManager = new DesignationManager();
aTeacherManager = new TeacherManager();
aCourseManager = new CourseManager();
aAssignCourseManager = new AssignCourseManager();
}
public CourseAssignTeacherController()
{
_courseAssignTeacherManager = new CourseAssignTeacherManager();
_departmentManager = new DepartmentManager();
_teacherManager = new TeacherManager();
_courseManager = new CourseManager();
}
public ActionResult EditTeacher()
{
string id = Request.QueryString["id"]; //从前台页面获取id值
Teacher teacher = new TeacherManager().GetTeacherById(id); //通过id获取教师信息
return(View(teacher));
}
public JsonResult GetTeacherCreditByTeacherId(int Tid)
{
TeacherManager ateacherManager = new TeacherManager();
var teacher = ateacherManager.GetAllTeachers();
var studentList = teacher.FirstOrDefault(x => x.TeacherId == Tid);
return(Json(studentList, JsonRequestBehavior.AllowGet));
}
public JsonResult ShowCourse(string RegistrationNo)
{
var studentDetails = aStudentManager.GetStudentDetails(RegistrationNo);
TeacherManager aTeacherManager = new TeacherManager();
var course = aTeacherManager.GetAllCourse(studentDetails.DepartmentId);
return(Json(course));
}
public AllocateClassRoomController()
{
departmentManager = new DepartmentManager();
courseManager = new CourseManager();
allocateClassRoomManager = new AllocateClassRoomManager();
classRoomManager = new ClassRoomManager();
teacherManager = new TeacherManager();
}
public List <TeacherModel> GetAllTeachers()
{
TeacherManager aTeacherManager = new TeacherManager();
//DepartmentManager aDepartmentManager = new DepartmentManager();
//CourseManager aCourseManager = new CourseManager();
//CourseAssignGateway aCourseAssignGateway = new CourseAssignGateway();
return(aTeacherManager.GetAllTeachers());
}
public List <TeacherModel> GetTeachersByDeptId(int deptId)
{
TeacherManager aTeacherManager = new TeacherManager();
//DepartmentManager aDepartmentManager = new DepartmentManager();
//CourseManager aCourseManager = new CourseManager();
//CourseAssignGateway aCourseAssignGateway = new CourseAssignGateway();
return(aTeacherManager.GetTeachersByDepartmentId(deptId));
}
