public async Task <IActionResult> Edit(int id, [Bind("Id,Name,DateOfBirth,Speciality,SchoolId")] TeachersModel teachersModel)
{
if (id != teachersModel.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(teachersModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TeachersModelExists(teachersModel.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["SchoolId"] = new SelectList(_context.Schools, "Id", "Id", teachersModel.SchoolId);
return(View(teachersModel));
}
public List <TeachersModel> GetTeachersByName(string name)
{
string FirstName = "'" + name + "'";
List <TeachersModel> teacherList = new List <TeachersModel>();
using (var connection = new SqlConnection(this.ConnectionString))
{
connection.Open();
//Command (SQL QUEERY)
// string nameQuery = "SELECT * FROM Teachers WHERE Name = @FirstName";
// SqlCommand allCommand = new SqlCommand(nameQuery, connection);
SqlCommand allCommand = new SqlCommand("SELECT * FROM Teachers WHERE Name =" + FirstName, connection);
// READ ROW BY ROW READER
using (var reader = allCommand.ExecuteReader())
{
//Read ROW BY ROW
while (reader.Read())
{
TeachersModel teacher = new TeachersModel();
teacher.Id = reader.GetInt32(0);
teacher.Name = reader.GetString(1);
teacher.Surname = reader.GetString(2);
teacherList.Add(teacher);
}
}
}
return(teacherList);
}
public TeachersModel InsertOrUpdate(TeachersModel model)
{
if (model.Id > 0)
{
var find = dbcontext.Teachers.Find(model.Id);
if (find != null)
{
var mappedTeachers = mapper.Map <TeachersModel, Teachers>(model, find);
dbcontext.Teachers.Update(mappedTeachers);
dbcontext.SaveChanges();
return(model);
}
else
{
return(null);
}
}
else
{
var mappedTeachers = mapper.Map <Teachers>(model);
dbcontext.Teachers.Add(mappedTeachers);
dbcontext.SaveChanges();
model.Id = mappedTeachers.Id;
return(model);
}
}
private static List <TeachersModel> GetTeachers()
{
string expressSql = "getTeachers";
List <TeachersModel> allTeachers = new List <TeachersModel>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(expressSql, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
var teachers = command.ExecuteReader();
if (teachers.HasRows)
{
while (teachers.Read())
{
TeachersModel t = new TeachersModel
{
IdTeacher = teachers.GetInt32(0),
NameTeacher = teachers.GetString(1)
};
allTeachers.Add(t);
}
}
teachers.Close();
return(allTeachers);
}
}
private TeachersModel GetTeacher(int IdGroup)
{
string expressSql = "getTeacher";
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
SqlCommand command = new SqlCommand(expressSql, connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter TeacherIdPar = new SqlParameter // parameter for id
{
ParameterName = "@IdGroup",
Value = IdGroup
};
command.Parameters.Add(TeacherIdPar); // add
var g = command.ExecuteReader();
g.Read();
TeachersModel res = new TeachersModel
{
IdTeacher = g.GetInt32(0),
NameTeacher = g.GetString(1)
};
g.Close();
return(res);
}
}
public List <TeachersModel> GetTeachersBySurName(string Surname)
{
List <TeachersModel> teacherList = new List <TeachersModel>();
using (var connection = new SqlConnection(this.ConnectionString))
{
connection.Open();
//Command (SQL QUEERY)
SqlCommand allCommand = new SqlCommand("SELECT * FROM Teachers Where SurName = " + Surname, connection);
// READ ROW BY ROW READER
using (var reader = allCommand.ExecuteReader())
{
//Read ROW BY ROW
while (reader.Read())
{
TeachersModel teacher = new TeachersModel();
teacher.Id = reader.GetInt32(0);
teacher.Name = reader.GetString(1);
teacher.Surname = reader.GetString(2);
teacherList.Add(teacher);
}
}
}
return(teacherList);
}
public List <Model.TeachersModel> getTeachersNameList(string training_base_code, string professional_base_code)
{
List <Model.TeachersModel> list = new List <TeachersModel>();
string sql = string.Format("select * from GP_Teachers_login where training_base_code=@training_base_code and professional_base_code=@professional_base_code");
SqlParameter[] prams = { db.MakeInParam("@training_base_code", SqlDbType.NVarChar, 50, training_base_code),
db.MakeInParam("@professional_base_code", SqlDbType.NVarChar, 50, professional_base_code) };
DataTable dt = db.RunDataTable(sql, prams);
foreach (DataRow dr in dt.Rows)
{
Model.TeachersModel model = new TeachersModel();
model.teachers_name = dr["teachers_name"].ToString();
model.teachers_real_name = dr["teachers_real_name"].ToString();
model.training_base_code = dr["training_base_code"].ToString();
model.training_base_name = dr["training_base_name"].ToString();
model.professional_base_code = dr["professional_base_code"].ToString();
model.professional_base_name = dr["professional_base_name"].ToString();
model.dept_code = dr["dept_code"].ToString();
model.dept_name = dr["dept_name"].ToString();
list.Add(model);
}
return(list);
}
private static void LoadMockData()
{
TeachersModel teacherMock = new TeachersModel();
{
teacherMock.Id = 3064;
teacherMock.Name = "Tamar";
teacherMock.Surname = "Zemach";
teacherMock.courses.Add("Calculus2"); // is this really how you add a course?
teacherMock.courses.Add("Real Time");
teacherMock.courses.Add("Operating Systems");
};
_allTeachers.Add(teacherMock);
TeachersModel teacherMock1 = new TeachersModel();
{
teacherMock1.Id = 30644;
teacherMock1.Name = "Tamar";
teacherMock1.Surname = "Cohen";
teacherMock1.courses.Add("Migdar"); // is this really how you add a course?
teacherMock1.courses.Add("Law");
teacherMock1.courses.Add("Calculus2");
};
_allTeachers.Add(teacherMock1);
}
public ActionResult AddTeacher(FormCollection fc)
{
int a;
string ischeck = fc["checkall"];
if (ischeck == "on")
{
a = 1;
}
else
{
a = 0;
}
//SqlParameterCollection
TeachersModel model = new TeachersModel();
model.Tid = fc["teacherNO"];
model.Title = fc["teacherTitle"];
model.TeacherRoom = fc["teacherRoom"];
model.TeacherName = fc["teacherName"];
model.Phone = fc["teacherTel"];
model.Password = "******";
model.Islimit = 1;
model.Indentify = a;
model.Email = fc["teacherEmail"];
model.College = fc["college"];
DBHelper.Insert <TeachersModel>(model);
//return Json(new jsondata(1, "添加成功！"), JsonRequestBehavior.AllowGet);
return(Redirect("/#!/Home/Teacher"));
}
public TeachersViewModel()
{
this.context = new TimetableCourseProject();
context.Teachers.Load();
TeachersDatabase = context.Teachers.Local;
Teachers = new ObservableCollection <Teachers>(TeachersDatabase);
teachersModel = new TeachersModel();
}
private void btnDeleban_Click(object sender, EventArgs e)
{
TeacherBLL teacher = new TeacherBLL();
TeachersModel model = new TeachersModel();
model.Teacher_ID = Convert.ToInt32(databanzhuren.SelectedRows[0].Cells["教师编号"].Value);
teacher.DeleTeacher(model);
GetAllTeacher();
}
public DataTable GetDataTable(TeachersModel model)
{
string sql = string.Format("select * from GP_Teachers_login where teachers_name=@teachers_name and teachers_password=@teachers_password");
SqlParameter[] prams = { db.MakeInParam("@teachers_name", SqlDbType.VarChar, 50, model.teachers_name),
db.MakeInParam("@teachers_password", SqlDbType.VarChar, 50, model.teachers_password) };
DataTable dt = db.RunDataTable(sql, prams);
return(dt);
}
public bool UpdateTeacher(int id, TeachersModel teacher)
{
using (var connection = new SqlConnection(this.ConnectionString))
{
connection.Open();
//Command (SQL QUEERY)
SqlCommand allCommand = new SqlCommand("UPDATE Teachers SET Name = teacher.name,SurName=teacher.Surname WHERE Id = " + id, connection);
// READ ROW BY ROW READER
}
return(true);
}
public int AddTeacher(TeachersModel newTeacher)
{
using (var connection = new SqlConnection(this.ConnectionString))
{
connection.Open();
//Command (SQL QUEERY)
SqlCommand allCommand = new SqlCommand("INSERT INTO Teachers (Id,Name,Surname) VALUES (newTeacher.Id,newTeacher.Name,newTeacher.SurName)");
// READ ROW BY ROW READER
}
return(1);
}
public ActionResult InfoTeacher(TeachersModel te)
{
try
{
te.Tid = collegeid(te.College) + te.TeacherName;
string insertteacher = string.Format("INSERT INTO [dbo].[teachers] ([tid], [teachername], [phone], [email], [college], [indentify], [title], [islimit], [password], [teacherroom]) VALUES (N'{0}', N'{1}', N'{2}', N'{3} ', N'{4}', 0, N' {5}', 0, N'123', N'{6}')", te.Tid, te.TeacherName, te.Phone, te.Email, te.College, te.Title, te.TeacherRoom);
DBHelper.ExecuteNonQuery(insertteacher, CommandType.Text, null);
//DBHelper.Insert<TeachersModel>(te);
return(Json(new mkjson("添加成功！", 0)));
}
catch (Exception) { return(Json(new mkjson("添加失败！", 1))); }
}
public async Task <IActionResult> Create(int SchoolId, [Bind("Id,Name,DateOfBirth,Speciality,SchoolId")] TeachersModel teachersModel)
{
if (ModelState.IsValid)
{
teachersModel.SchoolId = SchoolId;
_context.Add(teachersModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(teachersModel));
}
public TeachersModel GetTeacher(int id)
{
TeachersModel output = new TeachersModel();
output.TeacherId = id;
output.FirstName = GetRandomItem(firstNames);
output.LastName = GetRandomItem(lastNames);
output.PicPath = GetRandomItem(PicsPaths);
output.Specialty = GetRandomItem(Specialty);
return(output);
}
public void teacherAdd_Method(object paramert)
{
if (IsValid(ValidatesAddProperties, out AddErrors))
{
AddErrors += teachersModel.Add(TeachersModel.getTeacherObject(AddName, AddSurname, AddPatronymic, AddShortPulpitName));
MessageBox.Show(AddErrors, "Результат добавления");
FilterTeachers();
}
else
{
MessageBox.Show("Заполните поля корректно!", "Результат добавления");
}
}
public async Task <IActionResult> UpdateTeacher(TeachersModel teacherModel)
{
if (!ModelState.IsValid)
{
return(BadRequest(new { error = "Invalid Fields" }));
}
var teacher = await _userRepository.UpdateAsync(teacherModel);
if (teacher == null)
{
return(BadRequest(new { Error = "Cant update this Entity something went wrong" }));
}
return(Ok(teacher));
}
public async Task <IActionResult> AddTeacher(TeachersModel teacher)
{
if (!ModelState.IsValid)
{
return(BadRequest(new { error = "Invalid Fields" }));
}
var newTeacher = await _userRepository.AddAsync(teacher);
if (newTeacher == null)
{
return(BadRequest(new { error = "Can't Add The Entity please check inputs" }));
}
return(Ok(newTeacher));
}
public bool UpdateTeacher(int id, TeachersModel teacher)
{
var temp = GetTeacherById(id);
if (temp != null)
{
temp.Id = teacher.Id;
temp.Name = teacher.Name;
temp.Surname = teacher.Surname;
//need to copy the list of courses
return(true);
}
return(false);
}
private void btnUPban_Click(object sender, EventArgs e)
{
TeacherBLL teacher = new TeacherBLL();
TeachersModel model = new TeachersModel();
model.Teacher_ID = Convert.ToInt32(this.databanzhuren.SelectedRows[0].Cells["教师编号"].Value);
model.Teacher_Name = this.txtbanName.Text;
model.Teacher_Tel = this.txtbanTel.Text;
model.Teacher_Sex = this.cmbbansex.SelectedItem.ToString();
model.Teacher_InDate = this.daTimeru.Value;
model.Teacher_Birthday = this.daTimechu.Value;
model.Teacher_Origin = this.txtdidian.Text;
teacher.UPTeacher(model);
GetAllTeacher();
}
public static void Test()
{
TeachersModel model = new TeachersModel();
model.College = "信息工程学院";
model.Email = "*****@*****.**";
model.Indentify = 1;
model.Islimit = 1;
model.Password = "******";
model.Phone = "13650421544";
model.TeacherName = "刘莉(讲师（高校）)";
model.Tid = "1994";
model.Title = "教授";
model.TeacherRoom = "物理教研室";
DBHelper.Update <TeachersModel>(model);
}
public ActionResult AddSalaryRecord()
{
ViewBag.UniversityCampusList = new UniversityCampusModel().GetAll();
ViewBag.DesignationsList = new TeachersModel().GetAllDesignation();
if (Convert.ToInt32(Request.QueryString["ID"]) != 0 && Request.QueryString["ID"] != null && Request.QueryString["ID"] != "")
{
int ID = Convert.ToInt32(Request.QueryString["ID"]);
SalaryRecord edit = new TeachersModel().GetRByID(ID);
return(View(edit));
}
else
{
return(View());
}
}
public ActionResult CreateStudent(int IdGroup)
{
TeachersModel teach = GetTeacher(IdGroup);
List <OrgModel> Orgs = GetOrg(teach.IdTeacher);
int selectedIndex = Orgs.ElementAt(0).IdOrganization;
List <EmployeeModel> Employee = GetEmployee(selectedIndex);
CreateStudentModel createStudentModel = new CreateStudentModel
{
EmployeeList = GetStudentsOfGroup(IdGroup),
IdStudyGroup = IdGroup,
NameStudyGroup = GetGroup(IdGroup),
NameTeacher = teach.NameTeacher,
Organizations = new SelectList(Orgs, "IdOrganization", "NameOrganization"),
Employee = new SelectList(Employee, "IdEmployee", "NameEmployee")
};
return(View(createStudentModel));
}
public ActionResult AddTeacher()
{
ViewBag.ContriesList = new CountryModel().GetAll();
ViewBag.CitiesList = new CityModel().GetAll();
ViewBag.UniversityCampusList = new UniversityCampusModel().GetAll();
ViewBag.DesignationsList = new TeachersModel().GetAllDesignation();
if (Convert.ToInt32(Request.QueryString["ID"]) != 0 && Request.QueryString["ID"] != null && Request.QueryString["ID"] != "")
{
int ID = Convert.ToInt32(Request.QueryString["ID"]);
Teacher EditUser = new TeachersModel().GetByID(ID);
return(View(EditUser));
}
else
{
return(View());
}
}
public List <TeachersModel> GetAllTeachers()
{
List <TeachersModel> teacherList = new List <TeachersModel>();
using (var connection = new SqlConnection(this.ConnectionString))
{
connection.Open();
//Command (SQL QUEERY)
SqlCommand allCommand = new SqlCommand("SELECT * FROM Teachers", connection);
// READ ROW BY ROW READER
using (var reader = allCommand.ExecuteReader())
{
//Read ROW BY ROW
while (reader.Read())
{
TeachersModel teacherModel = new TeachersModel();
teacherModel.Id = reader.GetInt32(0);
teacherModel.Name = reader.GetString(1);
teacherModel.Surname = reader.GetString(2);
teacherList.Add(teacherModel);
}
}
allCommand = new SqlCommand("SELECT * FROM Courses", connection);
using (var reader = allCommand.ExecuteReader())
{
while (reader.Read())
{
string tempCourseName = reader.GetString(1);
var tempId = reader.GetInt32(2);
foreach (TeachersModel t in teacherList)
{
if (tempId == t.Id)
{
t.courses.Add(tempCourseName); // Does this work?????
}
}
}
}
}
return(teacherList);
}
private void teacherRemove_Method(object parametr)
{
if (editButtonContent.Equals("Изменить"))
{
if (IsValid(ValidatesChangeProperties, out ChangeErrors))
{
ChangeErrors = teachersModel.Remove(TeachersModel.getTeacherObject(changeName, changeSurname, changePatronymic, changeShortPulpitName));
MessageBox.Show(ChangeErrors, "Результат удаления");
FilterTeachers();
}
else
{
MessageBox.Show("Заполните корректно поля!", "Результат удаления");
}
}
else
{
MessageBox.Show("Для удаления отмените операцию \"Изменение\" нажав на кнопку\"Отмена\"", "", MessageBoxButton.OK, MessageBoxImage.Exclamation);
}
}
private void teacherChange_Method(object parametr)
{
if (editButtonContent.Equals("Изменить"))
{
if (IsValid(ValidatesChangeProperties, out ChangeErrors))
{
if (teachersModel.IsExist(TeachersModel.getTeacherObject(changeName, changeSurname, changePatronymic, changeShortPulpitName)))
{
EditButtonContent = "Сохранить";
CancelVisibility = Visibility.Visible;
changedTeacher = TeachersModel.getTeacherObject(changeName, changeSurname, changePatronymic, changeShortPulpitName);
return;
}
else
{
MessageBox.Show("Изменяемого объекта не существует", "Результат изменения");
}
}
else
{
MessageBox.Show("Заполните корректно поля!", "Результат Изменения");
}
}
else if (editButtonContent.Equals("Сохранить"))
{
if (IsValid(ValidatesChangeProperties, out ChangeErrors))
{
MessageBox.Show(teachersModel.Change(changedTeacher, TeachersModel.getTeacherObject(changeName, changeSurname, changePatronymic, changeShortPulpitName)), "Результат изменения");
EditButtonContent = "Изменить";
CancelVisibility = Visibility.Collapsed;
FilterTeachers();
}
else
{
MessageBox.Show("Заполните корректно поля!", "Результат изменения");
}
}
}
public TeachersModel GetTeacherById(int id)
{
TeachersModel teacher = null;
using (var connection = new SqlConnection(this.ConnectionString))
{
connection.Open();
//Command (SQL QUEERY)
SqlCommand allCommand = new SqlCommand("SELECT * FROM Teachers Where Id = " + id, connection);
// READ ROW BY ROW READER
using (var reader = allCommand.ExecuteReader())
{
//Read ROW BY ROW
while (reader.Read())
{
teacher = new TeachersModel();
teacher.Id = reader.GetInt32(0);
teacher.Name = reader.GetString(1);
teacher.Surname = reader.GetString(2);
}
}
}
return(teacher);
}
