public RemarkController()
{
rb = new RemarkBll();
pb = new ProjectBll();
sb = new StudentBll();
cb = new ClassBll();
}
/// <summary>
/// 查询学生是否已经选题
/// </summary>
/// <returns></returns>
public ActionResult QueryWhetherChooseThesis()
{
string sno = Session["account"].ToString();
bool flag = new StudentBll().HasChooseThesis(sno);
return(Json(new { isChoose = flag }));
}
public StudentEditPresenter(StudentEditView studentEditView, StudentBll studentBll)
{
this._studentEditView = studentEditView;
_studentBll = studentBll;
UpdateForm();
}
private void ViewStudentReport()
{
StudentBll studentBll = new StudentBll();
List <Student> list = studentBll.GetStudents();
var student = new DataTable("Students");
student.Columns.Add("Id");
student.Columns.Add("Name");
student.Columns.Add("RollNo");
student.Columns.Add("Address");
student.Columns.Add("Username");
student.Columns.Add("Password");
foreach (Student c in list)
{
DataRow dr = student.NewRow();
dr["Id"] = c.Id;
dr["Name"] = c.Name;
dr["RollNo"] = c.RollNumber;
dr["Address"] = c.Address;
dr["Username"] = c.UserName;
dr["Password"] = c.Password;
student.Rows.Add(dr);
}
ReportViewer.LocalReport.DataSources.Clear();
ReportViewer.LocalReport.DataSources.Add(new Microsoft.Reporting.WinForms.ReportDataSource("StudentReportDataSet", student));
ReportViewer.LocalReport.ReportPath = @"C:\Users\M.Jahangeer\documents\visual studio 2013\Projects\TeacherFacilitationSystem\TeacherFacilitationSystem\StudentReport.rdlc";
ReportViewer.LocalReport.EnableExternalImages = true;
ReportViewer.RefreshReport();
}
private void Btn_FindStudent(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(TextBox1.Text) && string.IsNullOrEmpty(TextBox2.Text))
{
MessageBox.Show("Search fields, Name or RollNo is empty.");
return;
}
var studentBll = new StudentBll();
Student student = studentBll.GetStudentData(TextBox1.Text, TextBox2.Text);
if (student == null)
{
MessageBox.Show("No such student exists.");
return;
}
TextBox1.Text = student.Name;
TextBox2.Text = student.RollNumber;
TextBox3.Text = student.Address;
TextBox4.Text = student.UserName;
TextBox5.Text = student.Password;
rollnumber = student.RollNumber;
}
private void Btn_Update_Detail(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(TextBox1.Text) ||
string.IsNullOrEmpty(TextBox2.Text) ||
string.IsNullOrEmpty(TextBox3.Text) ||
string.IsNullOrEmpty(TextBox4.Text) ||
string.IsNullOrEmpty(TextBox5.Text))
{
MessageBox.Show("One of fields are empty.");
return;
}
var student = new Student
{
Name = TextBox1.Text,
Address = TextBox3.Text,
UserName = TextBox4.Text,
Password = TextBox5.Text,
RollNumber = rollnumber
};
var studentBll = new StudentBll();
if (studentBll.UpdateStudent(student))
{
MessageBox.Show("Record Updated");
Close();
}
else
{
MessageBox.Show("Some thing went wrong.");
Close();
}
}
/// <summary>
/// 查询毕业年份为x，审核通过的教师拟定的论题
/// </summary>
/// <returns></returns>
public ActionResult QueryTeacherThesis()
{
int usingYear = Convert.ToInt32(HttpContext.Application["userYear"]);
var thesisList = new StudentBll().QueryTeacherThesisBll(usingYear);
return(Json(thesisList, JsonRequestBehavior.AllowGet));
}
public MarkBll EditMark(StudentBll student, int grade, TeachersWorkloadBll teachersWorkload)
{
Student stud = mapper.Map <Student>(student);
TeachersWorkload tw = mapper.Map <TeachersWorkload>(teachersWorkload);
Mark mark = db.Marks.Get(m => (m.Student.Id == student.Id) && (m.TeachersWorkload.Id == teachersWorkload.Id)).SingleOrDefault();
MarkBll markBll;
if (mark == null)
{
try
{
markBll = AddMark(grade, stud, tw, true);
}
catch
{
return(null);
}
}
else
{
try
{
markBll = EditMark(mark, grade);
}
catch
{
return(null);
}
}
return(markBll);
}
protected void Page_Load(object sender, EventArgs e)
{
//TODO 改成从session里获取值
student = (Student)Session["loginuser"];
StudentBll sbll = new StudentBll();
string op = Request.QueryString["op"];
try
{
student = sbll.GetModel(student.StuAccount);
if (op == "update")
{
string phone = Context.Request["phone"].ToString();
string Email = Context.Request["Email"].ToString();
Student newStu = new Student();
College college = new College();
Profession pro = new Profession();
newStu.StuAccount = student.StuAccount;
newStu.RealName = student.RealName;
newStu.StuPwd = student.StuPwd;
newStu.Sex = student.Sex;
newStu.college = student.college;
newStu.profession = student.profession;
newStu.Phone = phone;
newStu.Email = Email;
updata(newStu);
}
}
catch (Exception ex)
{
LogHelper.Error(this.GetType(), ex);
}
}
public StudentFormController(StudentForm studentForm, StudentBll studentBll, CourseBll courseBll)
{
_studentForm = studentForm;
_studentBll = studentBll;
_courseBll = courseBll;
UpdateForm();
}
private void GetData()
{
var studentBll = new StudentBll();
List <Student> list = studentBll.GetStudents();
StudentDataGrid.ItemsSource = list;
}
public GradeBook GetMyMarks()
{
var userName = userService.GetCurrentUserId();
if (string.IsNullOrEmpty(userName))
{
throw new ArgumentNullException("userName is not available", userName);
}
Student student = db.Students.Get(s => s.Identity.UserName == userName).SingleOrDefault();
if (student == null)
{
throw new ArgumentException("This student does not exists", userName);
}
var st = mapper.Map <StudentBll>(student);
var gr = db.Groups.Get(gro => gro.Id == student.GroupId).SingleOrDefault();
StudentBll studentBll = mapper.Map <StudentBll>(student);
IEnumerable <MarkBll> studentMarks = markService.GetAllMarks(studentBll);
var marks = new List <MarkBll>(studentMarks);
GradeBook gradeBook = new GradeBook()
{
Student = studentBll,
Marks = studentMarks
};
return(gradeBook);
}
private void GetStudents()
{
site = new DBSite();
StudentBll stBll = new StudentBll();
string classIDs = ddlPresentClass.SelectedValue;
//try
{
// List<StudentBll.StudenEntity> students = stBll.GetStudents(site);
List <StudentBll.StudenEntity> students = stBll.GetStudentsByClass(site, "", classIDs);
//total_records = students.Count;
gridView1.DataSource = students;
gridView1.DataBind();
}
//catch (Exception exception)
//{
// util.HandleExpception(exception, Response);
//}
//finally
//{
// site.Close();
//}
}
public TeacherFormPresenter(TeacherEditView teacherEditView, StudentBll studentBll, TeacherBll teacherBll)
{
_teacherEditView = teacherEditView;
_studentBll = studentBll;
_teacherBll = teacherBll;
UpdateForm();
}
protected void GetStudents()
{
StudentBll sBll = new StudentBll();
//StudentBll.StudenEntity st = sBll.GetStudents(site, util.CheckNullInt(lblStudentMasterId.Text));
List <StudentBll.StudenEntity> st = sBll.GetStudentsByClass(site, "", GetSelectedIds(gridView2, 1));
gridView1.DataSource = st;
gridView1.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
site = new DBSite();
StudentBll stBll = new StudentBll();
List <string> student_id_list = new List <string>();
try
{
foreach (GridViewRow gr in gridView1.Rows)
{
CheckBox cb = (CheckBox)gr.Cells[0].FindControl("myCheckBox");
if (cb.Checked)
{
//if (stBll.IsStudentPresentInAttendance(site, util.CheckNullInt(gr.Cells[2].Text)))
//{
// lblError.Text = "Can't Delete Record:'" + gr.Cells[4].Text + "' This Student is being entered in Attendance Entry.";
// lblError.Visible = true;
// ClearSuccessMessage();
// return;
//}
student_id_list.Add(gr.Cells[3].Text);
}
}
if (student_id_list.Count < 1)
{
lblError.Text = "Can't Delete Records. Select at least one Record ";
lblError.Visible = true;
ClearSuccessMessage();
return;
}
string st_ids = util.ConvertListToCommaSeparatedString(student_id_list);
site.BeginTrans();
stBll.DeleteStudent(site, st_ids);
site.Commit();
lblMessage.Text = " [ " + student_id_list.Count + "] Record Deleted ";
lblMessage.Visible = true;
ClearErrorMessage();
}
catch (Exception del_exception)
{
site.RollBack();
util.HandleExpception(del_exception, Response);
}
finally
{
site.Close();
}
GetStudents();
}
public Quiz()
{
InitializeComponent();
//_count++;
var stBll = new StudentBll();
_list = stBll.GetQuestionsList();
ShowQuestion();
}
/// <summary>
/// 实现分页
/// </summary>
/// <param name="strWhere">搜索条件</param>
public void getdata(String strWhere)
{
string currentPage = Request.QueryString["currentPage"];
if (currentPage == null || currentPage.Length <= 0)
{
currentPage = "1";
}
string userType = Session["state"].ToString();
string userCollege = "";
//usertype=2 为分院管理员登录
if (userType == "2")
{
Teacher tea = (Teacher)Session["user"];
int userCollegeId = tea.college.ColID;
if (strWhere == null || strWhere == "")
{
userCollege = "collegeId=" + "'" + userCollegeId + "'";
}
else
{
userCollege = "collegeId=" + "'" + userCollegeId + "'" + "and" + "(" + strWhere + ")";
}
StudentBll pro = new StudentBll();
TableBuilder tabuilder = new TableBuilder()
{
StrTable = "V_Student",
StrWhere = userCollege,
IntColType = 0,
IntOrder = 0,
IntPageNum = int.Parse(currentPage),
IntPageSize = pagesize,
StrColumn = "stuAccount",
StrColumnlist = "*"
};
getCurrentPage = int.Parse(currentPage);
ds = pro.SelectBypage(tabuilder, out count);
}
else
{
StudentBll pro = new StudentBll();
TableBuilder tabuilder = new TableBuilder()
{
StrTable = "V_Student",
StrWhere = strWhere == null ? "" : strWhere,
IntColType = 0,
IntOrder = 0,
IntPageNum = int.Parse(currentPage),
IntPageSize = pagesize,
StrColumn = "stuAccount",
StrColumnlist = "*"
};
getCurrentPage = int.Parse(currentPage);
ds = pro.SelectBypage(tabuilder, out count);
}
}
public static void Run()
{
Console.WriteLine($"开始运行{nameof(Demo1)}");
StudentBll studentBll = new StudentBll();
IEnumerable <Student> students = studentBll.GetStudents();
foreach (Student student in students)
{
Console.WriteLine(student);
}
Console.WriteLine($"结束运行{nameof(Demo1)}");
}
public static void Run()
{
Console.WriteLine($"开始运行{nameof(Demo1)}");
var studentBll = new StudentBll();
var students = studentBll.GetStudents();
foreach (var student in students)
{
Console.WriteLine(student);
}
Console.WriteLine($"结束运行{nameof(Demo1)}");
}
IEnumerable <MarkBll> IMarkService.GetAllMarks(StudentBll student)
{
IEnumerable <Mark> marks = db.Marks.Get(m => m.StudentId == student.Id);
if (marks == null)
{
return(null);
}
IEnumerable <MarkBll> marksbll = mapper.Map <IEnumerable <MarkBll> >(marks);
return(marksbll);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
site = new DBSite();
StudentBll stBll = new StudentBll();
// 777
List <StudentBll.StudenEntity> students = stBll.SearchStudents(site, txtSearch.Text);
// total_records = students.Count;
gridView1.DataSource = students;
gridView1.DataBind();
}
//student see the teacher content
public ActionResult StudentView()
{
if (StudentSessionControl())
{
try
{
int Id = Convert.ToInt32(Session["StudentId"]);
var _Student = db.Students.FirstOrDefault(x => x.Id == Id);
var _Batch = db.Batchs.FirstOrDefault(x => x.Id == _Student.BatchId);
var _Content = _ShareContentBll.StudentContentShowViewModels(_Student, _Batch);
if (_Content != null)
{
StudentBll _StudentBll = new StudentBll();
RoutineBll _RoutineBll = new RoutineBll();
//list of course
int UserId = Convert.ToInt32(Session["StudentId"]);
var StudentInfo = db.Students.Where(s => s.Id == UserId).FirstOrDefault();
var ListOfAssignCourse = _RoutineBll.CourseDepartments(StudentInfo);
//room assign list
var RoomAssingList = _RoutineBll.RoomAssignViewModels(StudentInfo);
ViewBag.RoomAssignList = RoomAssingList;
ViewBag.CourseAssignForStudent = ListOfAssignCourse;
//classmates
var StudentId = db.Students.Where(s => s.Id == UserId).FirstOrDefault();
ViewBag.StudentsList = _StudentBll.StudentsListForStudentShow(StudentId);
//Course list all
ViewBag.CourseListAll = db.Courses.Where(w => w.DepartmentId == StudentInfo.DepartmentId).ToList().OrderBy(x => x.Semester);
//post content
ViewBag.Content = _Content;
}
else
{
ViewBag.Content = null;
}
//get comments list
var CommentsList = _ShareContentBll.AllShareCommentViewModels();
ViewBag.Comments = CommentsList;
//get Thanks list
var ThanksList = db.ThanksButtons.ToList();
ViewBag.Thanks = ThanksList;
return(View());
}
catch (Exception)
{
RedirectToAction("Login", "Students");
}
}
return(StudentLoginFaild());
}
protected void GetStudentsByClass()
{
ddlStudent.Items.Clear();
site = new DBSite();
StudentBll stBLL = new StudentBll();
List <StudentBll.StudenEntity> studentList = stBLL.GetStudentsByClass(site, "", ddlClass.SelectedValue);
foreach (StudentBll.StudenEntity st in studentList)
{
ddlStudent.Items.Add(new ListItem(st.StudentName, st.StudentMasterId.ToString()));
}
}
private void GetData()
{
StudentBll studentBll = new StudentBll();
list = studentBll.GetAnnouncements();
AnnouncementComboBox.DataContext = list;
for (int i = 0; i < list.Count; i++)
{
ComboBoxItem item = new ComboBoxItem();
item.Content = list[i].Title;
AnnouncementComboBox.Items.Add(item);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
Student aStudent = new Student();
aStudent.RegistationNumber = regNoTextBox.Text;
aStudent.Email = emailTextBox.Text;
aStudent.Address = addressTextBox.Text;
StudentBll aStudentBll = new StudentBll();
string msg = aStudentBll.SaveIntoDataBase(aStudent);
MessageBox.Show(msg);
}
public bool IsDuplicateCardNo(DBSite site, string cardNo, int studentId)
{
StudentBll sBll = new StudentBll();
if (sBll.IsDuplicateCard(site, cardNo, studentId))
{
lblError.Visible = true;
lblError.Text = "Id Card No '" + cardNo + "' already exists in our System.";
txtIdCardNo.Focus();
return(true);
}
return(false);
}
/// <summary>
/// 分页
/// </summary>
/// <param name="strWhere"></param>
public void getdata(String strWhere)
{
loginUser = (Teacher)Session["user"];
collegeName = loginUser.college.ColName.ToString();
string currentPage = Request.QueryString["currentPage"];
if (currentPage == null || currentPage.Length <= 0)
{
currentPage = "1";
}
BLL.StudentBll sdao = new StudentBll();
StudentBll pro = new StudentBll();
string account = "collegeName = '" + collegeName + "'";
string Account = "collegeName = '" + collegeName + "' and ";
int state = int.Parse(Session["state"].ToString());
if (state == 2)
{
TableBuilder tabuilder = new TableBuilder()
{
StrTable = "V_Plan",
StrWhere = strWhere == null || strWhere == "" ? account : Account + strWhere,
IntColType = 0,
IntOrder = 0,
IntPageNum = int.Parse(currentPage),
IntPageSize = pagesize,
StrColumn = "planId",
StrColumnlist = "*"
};
getCurrentPage = int.Parse(currentPage);
plands = pro.SelectBypage(tabuilder, out count);
}
else
{
TableBuilder tabuilder = new TableBuilder()
{
StrTable = "V_Plan",
StrWhere = strWhere == null || strWhere == "" ? "" : strWhere,
IntColType = 0,
IntOrder = 0,
IntPageNum = int.Parse(currentPage),
IntPageSize = pagesize,
StrColumn = "planId",
StrColumnlist = "*"
};
getCurrentPage = int.Parse(currentPage);
plands = pro.SelectBypage(tabuilder, out count);
}
}
public void RefreshStudentRecentSubjectTest()
{
StudentBll bll = new StudentBll();
List <int> subjectIds = new List <int>();
subjectIds.Add(10208);
subjectIds.Add(10004);
//for (int index = 1; index <= 2; index++)
//{
// subjectIds.Add(10205 + index);
//}
bll.RefreshStudentRecentSubject(10000, subjectIds);
}
/// <summary>
/// 实现分页
/// </summary>
/// <param name="strWhere">搜索条件</param>
///
public void getdata(String strWhere)
{
DefenceGroup defenceGroup = defenceBll.SelectGroup(Convert.ToInt32(Session["defenGroupId"]));
if (defenceGroup != null)
{
leaderAccount = defenceGroup.leader;
memberAccount = defenceGroup.member;
recordAccount = defenceGroup.recorder;
string currentPage = Request.QueryString["currentPage"];
if (currentPage == null || currentPage.Length <= 0)
{
currentPage = "1";
}
string userType = Session["state"].ToString();
string userCollege = "";
//usertype=2 为分院管理员登录
if (userType == "2")
{
int userCollegeId = tea.college.ColID;
if (strWhere == null || strWhere == "")
{
userCollege = @"collegeId = " + userCollegeId + " and teaAccount not like " + leaderAccount + " and teaAccount not like " + memberAccount + " and teaAccount not like " + recordAccount
+ " and crossTea not like " + leaderAccount + " and crossTea not like " + memberAccount + " and crossTea not like " + recordAccount + " and state=0";
}
else
{
userCollege = @"collegeId = " + userCollegeId + " and teaAccount not like " + leaderAccount + " and teaAccount not like " + memberAccount + " and teaAccount not like " + recordAccount
+ " and crossTea not like " + leaderAccount + " and crossTea not like " + memberAccount + " and crossTea not like " + recordAccount + " and state=0 and " + strWhere;
}
StudentBll pro = new StudentBll();
TableBuilder tabuilder = new TableBuilder()
{
StrTable = "V_DefenAndStudent",
StrWhere = userCollege,
IntColType = 0,
IntOrder = 0,
IntPageNum = int.Parse(currentPage),
IntPageSize = pagesize,
StrColumn = "titleRecordId",
StrColumnlist = "titleRecordId,collegeName,proName,stuAccount,realName"
};
getCurrentPage = int.Parse(currentPage);
ds = pro.SelectBypage(tabuilder, out count);
}
}
}
