private void btnRemove_Click(object sender, EventArgs e)
{
if (lstRecord.SelectedItems.Count < 1)
{
MsgBox.Show("您必須先選擇一筆資料");
}
if (lstRecord.SelectedItems.Count == 1)
{
string updateID = lstRecord.SelectedItems[0].Tag.ToString();
if (MsgBox.Show("您確定將此筆異動資料永久刪除?", "確認", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
try
{
EditStudent.RemoveUpdateRecord(updateID);
//紀錄 Log，刪除異動紀錄
StringBuilder deleteDesc = new StringBuilder("");
deleteDesc.AppendLine("學生姓名：" + ((_AccessHelper.StudentHelper.GetStudents(RunningID).Count > 0) ? _AccessHelper.StudentHelper.GetStudents(RunningID)[0].StudentName + " " : "未知 "));
deleteDesc.AppendLine("刪除異動紀錄： " + lstRecord.SelectedItems[0].SubItems[0].Text + " " + lstRecord.SelectedItems[0].SubItems[1].Text);
CurrentUser.Instance.AppLog.Write(EntityType.Student, EntityAction.Delete, RunningID, deleteDesc.ToString(), Title, "");
_bgWorker.RunWorkerAsync();
}
catch (Exception ex)
{
MsgBox.Show("異動資料刪除失敗：" + ex.Message);
}
}
}
}
private void редактироватьЗаписьОКурсантеToolStripMenuItem_Click(object sender, EventArgs e)
{
if (Students_dGV.SelectedRows.Count <= 0)
{
MessageBox.Show("Не выбрана строка для редактирования", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
AutoschoolDataSet dataSetForAllStudent;
dataSetForAllStudent = BusinessLogic.ReadStudents();
AddEditStudentForm EditStudent;
if (GroupName != "")
{
EditStudent = new AddEditStudentForm(GroupName, dataSetForAllStudent.Students, dataSetForAllStudent.Groups,
dataSetForAllStudent.Instructors, dataSetForAllStudent.Students.Rows.Find(Students_dGV.SelectedRows[0].Cells["ID"].Value));
}
else
{
EditStudent = new AddEditStudentForm(null, dataSetForAllStudent.Students, dataSetForAllStudent.Groups,
dataSetForAllStudent.Instructors, dataSetForAllStudent.Students.Rows.Find(Students_dGV.SelectedRows[0].Cells["ID"].Value));
}
EditStudent.Text = "Редактирование курсанта";
EditStudent.ShowDialog();
if (EditStudent.DialogResult == DialogResult.OK)
{
dataSetForAllStudent = BusinessLogic.WriteStudents(dataSetForAllStudent);
if (GroupName != "")
{
ReloadStudents(GroupName);
}
}
}
//private void GetGradeYearClassList(string gradeyearID)
//{
// _WaitToGetClass = gradeyearID;
// cboClass.Items.Clear();
// if (!_getClassBackgroundWorker.IsBusy)
// {
// _getClassBackgroundWorker.RunWorkerAsync(gradeyearID);
// }
//}
public override void Save()
{
ValidateStudentNumber(); //在驗一次學生是否重覆，因為在某些狀態不會啟動驗證程式。
if (_errors.HasError)
{
FISCA.Presentation.Controls.MsgBox.Show("輸入資料未通過驗證，請修正後再儲存");
return;
}
//EditStudent.Update(_valueManager.GetRequest("StudentList", "Student", "Field", "Condition", "ID", RunningID));
DSXmlHelper helper = new DSXmlHelper("StudentList");
helper.AddElement("Student");
helper.AddElement("Student", "Field");
foreach (string key in _valueManager.GetDirtyItems().Keys)
{
string elementName = (key == "Department" ? "OverrideDeptID" : key);
string value = _valueManager.GetDirtyItems()[key];
helper.AddElement("Student/Field", elementName, value);
}
helper.AddElement("Student", "Condition");
helper.AddElement("Student/Condition", "ID", RunningID);
EditStudent.Update(new DSRequest(helper));
//LogUtility.LogChange(_valueManager, RunningID, GetStudentName());
//Student.Instance.InvokBriefDataChanged(RunningID);
//SmartSchool.Broadcaster.Events.Items["學生/資料變更"].Invoke(RunningID);
Student.Instance.SyncDataBackground(RunningID);
SaveButtonVisible = false;
}
public async Task <IActionResult> UpdateStudent(int index, EditStudent editStudent)
{
editStudent.Index = $"s{index}";
await _mediator.Send(editStudent);
return(NoContent());
}
private void ListBox_KeyDown(object sender, System.Windows.Input.KeyEventArgs e)
{
if (e.Key == System.Windows.Input.Key.Delete) //проверяем нажата ли делит
{ // удаление по клавише delete
if (listBox.SelectedIndex > -1) //проверяем чтобы хоть кто то был выделен
{
int si = cBoxGroup.SelectedIndex;
GroupViewModel groupViewModel = cBoxGroup.SelectedItem as GroupViewModel;
StudentViewModel studentViewModel = listBox.SelectedItem as StudentViewModel;
groupService.RemoveStudentFromGroup(groupViewModel.GroupId, studentViewModel.StudentId);
groups = groupService.GetAll(); // для обновления окна
cBoxGroup.DataContext = groups; // для обновления окна
cBoxGroup.SelectedIndex = si; // для обновления окна
}
}
if (e.Key == System.Windows.Input.Key.Insert)
{// обновление по клавише Insert
// не работает
if (listBox.SelectedIndex > -1)
{
StudentViewModel studentViewModel = listBox.SelectedItem as StudentViewModel;
var dialog = new EditStudent(studentViewModel);
var result = dialog.ShowDialog();
if (result == true)
{
groupService.UpdateStudent(studentViewModel);
dialog.Close();
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
EditStudent EditStudentForm = new EditStudent(datosBin, EstudianteActual);
EditStudentForm.ShowDialog();
datosBin.RecargarEstudiantes();
EstudianteActual = datosBin.Estudiantes.First(x => x.ID_Estudiante == EstudianteActual.ID_Estudiante);
StudentsMenu_Load(null, null);
}
private void TablaEstudiantes_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
Estudiante student = datosBin.Estudiantes.First(x => x.ID_Estudiante == (int)TablaEstudiantes.SelectedRows[0].Cells[0].Value);
EditStudent EditStudentForm = new EditStudent(datosBin, student, true);
EditStudentForm.ShowDialog();
datosBin.RecargarEstudiantes();
TablaEstudiantes.DataSource = datosBin.Estudiantes;
TablaEstudiantes.Refresh();
}
public void CannotEditStudentIfNotFound()
{
var editStudent = new EditStudent(new StudentRepositoryStub());
editStudent.Execute(new EditStudentRequest
{
Registration = "REG001",
Name = "John Doe",
BirthDate = new DateTime(1993, 11, 29)
});
}
private void EdytujStudenta_Click(object sender, RoutedEventArgs e)
{
var row = (StudentsTable)ListaStudentowDg.SelectedItem;
EditStudent EdytujStudenta = new EditStudent(row);
bool? result = EdytujStudenta.ShowDialog();
if (result == true)
{
WyszykajTb_KeyUp(null, null);
ListaStudentowDg_SelectionChanged(null, null);
}
}
public bool UpdateStudent(EditStudent model)
{
using (var ctx = new ApplicationDbContext())
{
var entity =
ctx
.Students
.Single(e => e.Id == model.StudentId);
entity.FirstName = model.StudentFirstName;
entity.LastName = model.StudentLastName;
entity.GradeLevel = model.StudentGradeLevel;
return(ctx.SaveChanges() > 0);
}
}
public ActionResult Edit(int id)
{
var service = CreateStudentService();
var detail = service.GetStudentById(id);
var model =
new EditStudent
{
StudentId = detail.StudentId,
StudentFirstName = detail.StudentFirstName,
StudentLastName = detail.StudentLastName,
StudentGradeLevel = detail.StudentGradeLevel
};
return(View(model));
}
private void Button_Click(object sender, RoutedEventArgs e)
{
var student = new StudentViewModel();
student.DateOfBirth = new DateTime(1990, 01, 01);
var dialog = new EditStudent(student);
var result = dialog.ShowDialog();
if (result == true)
{
var group = (GroupViewModel)cBoxGroup.SelectedItem;
group.Students.Add(student);
groupService.AddStudentToGroup(group.GroupId, student);
dialog.Close();
}
}
private void btEditUpdate_Click(object sender, EventArgs e)
{
short level = 2;
if (rbEditPostGrad.Checked)
{
level = 1;
}
else if (rbEditUnderGrad.Checked)
{
level = 0;
}
EditStudent es = new EditStudent(tbEditStuID.Text, tbEditFName.Text, tbEditLName.Text, tbEditEmail.Text,
tbEditPhone.Text, tbEditA1.Text, tbEditA2.Text, tbEditCity.Text,
cbEditCounty.Text, level, cbEditCourse.Text, username);
MessageBox.Show($"Updated Student: {tbEditFName.Text} {tbEditLName.Text}");
}
private void btnHomeEdit_Click(object sender, EventArgs e)
{
EditStudent editStudent = new EditStudent();
EditStudentForm editStudentForm = new EditStudentForm();
if (dgvStudents.SelectedRows.Count > 0)
{
string selectedRow = dgvStudents.SelectedRows[0].Cells[0].Value.ToString();
foreach (DataGridViewRow row in dgvStudents.SelectedRows)
{
editStudent.StudentID = int.Parse(row.Cells[0].Value.ToString());
editStudent.FirstName = row.Cells[1].Value.ToString();
editStudent.Surname = row.Cells[2].Value.ToString();
editStudent.Email = row.Cells[3].Value.ToString();
editStudent.Phone = row.Cells[4].Value.ToString();
editStudent.AddressLine1 = row.Cells[5].Value.ToString();
editStudent.AddressLine2 = row.Cells[6].Value.ToString();
editStudent.City = row.Cells[7].Value.ToString();
editStudent.County = row.Cells[8].Value.ToString();
if (row.Cells[9].Value.ToString() == "Postgraduate")
{
editStudent.Level = "Postgraduate";
}
else if (row.Cells[9].Value.ToString() == "Undergraduate")
{
editStudent.Level = "Undergraduate";
}
editStudent.Course = row.Cells[10].Value.ToString();
editStudentForm.EditStudentList.Add(editStudent);
}
editStudentForm.Show();
}
else
{
MessageBox.Show("Select Full Row");
}
}
public ActionResult Edit(int id, EditStudent model)
{
if (!ModelState.IsValid)
{
return(View(model));
}
if (model.StudentId != id)
{
ModelState.AddModelError("", "Id Mismatch");
return(View(model));
}
var service = CreateStudentService();
if (service.UpdateStudent(model))
{
TempData["SaveResult"] = "The student was updated.";
return(RedirectToAction("Index"));
}
ModelState.AddModelError("", "The student could not be updated.");
return(View(model));
}
public void EditStudentButton_Click(object sender, EventArgs e)
{
var rowHandler = gridView3.FocusedRowHandle;
//stud.IdStudent = Convert.ToInt32(gridView3.GetRowCellValue(rowHandler, "id"));
stud.FirstName = gridView3.GetRowCellValue(rowHandler, "FirstName").ToString();
stud.LastName = gridView3.GetRowCellValue(rowHandler, "LastName").ToString();
stud.Gender = gridView3.GetRowCellValue(rowHandler, "Gender").ToString();
stud.BirthDate = Convert.ToDateTime(gridView3.GetRowCellValue(rowHandler, "BirthDate").ToString());
stud.Email = gridView3.GetRowCellValue(rowHandler, "Email").ToString();
stud.PhoneNumber = gridView3.GetRowCellValue(rowHandler, "PhoneNumber").ToString();
stud.Faculty = gridView3.GetRowCellValue(rowHandler, "Faculty").ToString();
stud.FacultyStartYear = Convert.ToInt32(gridView3.GetRowCellValue(rowHandler, "FacultyStartYear")).ToString();
EditStudent andrei = new EditStudent(stud);
andrei.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
EditStudent ed = new EditStudent();
ed.ShowDialog();
}
private void editbtn_Click(object sender, EventArgs e)
{
EditStudent editcourse = new EditStudent(stud);
editcourse.ShowDialog();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNumber.Text))
{
MsgBox.Show("請輸入核準文號。");
return;
}
DateTime date;
if (!DateTime.TryParse(dtpDate.DateString, out date))
{
MsgBox.Show("日期格式不正確。");
return;
}
// 修改名冊本身的日期與文號
DSXmlHelper helper = new DSXmlHelper("AuthorizeBatchRequest");
helper.AddElement("AuthorizeBatch");
helper.AddElement("AuthorizeBatch", "Field");
helper.AddElement("AuthorizeBatch/Field", "ADNumber", txtNumber.Text);
helper.AddElement("AuthorizeBatch/Field", "ADDate", dtpDate.DateString);
helper.AddElement("AuthorizeBatch", "Condition");
helper.AddElement("AuthorizeBatch/Condition", "ID", _provider.ID);
try
{
EditStudent.ModifyUpdateRecordBatch(new DSRequest(helper));
}
catch (Exception ex)
{
MsgBox.Show("編輯核准文號失敗：" + ex);
}
// 修改其包含的異動紀錄文號
helper = new DSXmlHelper("UpdateRequest");
helper.AddElement("UpdateRecord");
helper.AddElement("UpdateRecord", "Field");
helper.AddElement("UpdateRecord/Field", "ADNumber", txtNumber.Text);
helper.AddElement("UpdateRecord/Field", "ADDate", dtpDate.DateString);
helper.AddElement("UpdateRecord", "Condition");
if (_provider.GetEntities().Length <= 0) //名冊中沒有任何學生，就不更新學生的核準文號了。
{
return;
}
foreach (IEntryFormat entity in _provider.GetEntities())
{
helper.AddElement("UpdateRecord/Condition", "ID", entity.ID);
}
try
{
EditStudent.ModifyUpdateRecord(new DSRequest(helper));
if (DataSaved != null)
{
DataSaved(this, null);
}
}
catch (Exception ex)
{
MsgBox.Show("編輯核准文號失敗：" + ex);
}
string batchName = "";
string schoolYear = "";
string semester = "";
if (_provider.ID != "")
{
DSResponse dsrsp = QueryStudent.GetUpdateRecordBatch(_provider.ID);
DSXmlHelper helper_ = dsrsp.GetContent();
//填上名冊的 學年、學期、名稱
foreach (XmlNode node in helper_.GetElements("UpdateRecordBatch"))
{
schoolYear = node.SelectSingleNode("SchoolYear").InnerText;
semester = node.SelectSingleNode("Semester").InnerText;
batchName = node.SelectSingleNode("Name").InnerText;
}
// log，2018/3/1 穎驊新增，因應高雄 [10-03][01] 整個學年度核准過的文號的異動名冊全部不見了 項目
// 本異動名冊 原只有新增會有系統紀錄，現在調整刪除、登打文號都會有紀錄
JHSchool.PermRecLogProcess prlp = new JHSchool.PermRecLogProcess();
string desc = "登錄文號" + schoolYear + "學年度,第" + semester + "學期," + batchName + "名冊,日期:" + dtpDate.DateString + ",文號:" + txtNumber.Text;
prlp.SaveLog("教務.名冊", "登錄文號", desc);
}
this.Close();
}
private void btnOK_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtNumber.Text))
{
MsgBox.Show("請輸入核准文號。");
return;
}
DateTime date;
if (!DateTime.TryParse(dtpDate.DateString, out date))
{
MsgBox.Show("日期格式不正確。");
return;
}
// 修改名冊本身的日期與文號
DSXmlHelper helper = new DSXmlHelper("AuthorizeBatchRequest");
helper.AddElement("AuthorizeBatch");
helper.AddElement("AuthorizeBatch", "Field");
helper.AddElement("AuthorizeBatch/Field", "ADNumber", txtNumber.Text);
helper.AddElement("AuthorizeBatch/Field", "ADDate", dtpDate.DateString);
helper.AddElement("AuthorizeBatch", "Condition");
helper.AddElement("AuthorizeBatch/Condition", "ID", _provider.ID);
try
{
EditStudent.ModifyUpdateRecordBatch(new DSRequest(helper));
}
catch (Exception ex)
{
MsgBox.Show("編輯核准文號失敗：" + ex);
}
// 修改其包含的異動紀錄文號
helper = new DSXmlHelper("UpdateRequest");
helper.AddElement("UpdateRecord");
helper.AddElement("UpdateRecord", "Field");
helper.AddElement("UpdateRecord/Field", "ADNumber", txtNumber.Text);
helper.AddElement("UpdateRecord/Field", "ADDate", dtpDate.DateString);
helper.AddElement("UpdateRecord", "Condition");
if (_provider.GetEntities().Length <= 0) //名冊中沒有任何學生，就不更新學生的核准文號了。
{
return;
}
foreach (IEntryFormat entity in _provider.GetEntities())
{
helper.AddElement("UpdateRecord/Condition", "ID", entity.ID);
}
try
{
EditStudent.ModifyUpdateRecord(new DSRequest(helper));
if (DataSaved != null)
{
DataSaved(this, null);
}
}
catch (Exception ex)
{
MsgBox.Show("編輯核准文號失敗：" + ex);
}
this.Close();
}
public bool Save()
{
if (_Action == UpdateRecordAction.None)
{
return(false);
}
bool _saved = false;
DSXmlHelper helper = new DSXmlHelper("InsertRequest");
helper.AddElement("UpdateRecord");
helper.AddElement("UpdateRecord", "Field");
if (_Action != UpdateRecordAction.Update)
{
helper.AddElement("UpdateRecord/Field", "RefStudentID", _StudentID);
}
helper.AddElement("UpdateRecord/Field", "ContextInfo");
XmlDocument contextInfo = new XmlDocument();
XmlElement root = contextInfo.CreateElement("ContextInfo");
contextInfo.AppendChild(root);
foreach (XmlNode node in GetElement().ChildNodes)
{
//Log，紀錄修改後的資料
if (afterData.ContainsKey(node.Name))
{
afterData.Remove(node.Name);
}
afterData.Add(node.Name, node.InnerText);
// 如果是 Previous 開頭的全丟到 ContextInfo 中
if (node.Name.StartsWith("Previous") ||
node.Name.StartsWith("Graduate") ||
node.Name == "NewStudentNumber" ||
node.Name == "LastUpdateCode" ||
node.Name == "NewData")
{
XmlNode importNode = node.Clone();
importNode = contextInfo.ImportNode(importNode, true);
root.AppendChild(importNode);
}
else
{
helper.AddElement("UpdateRecord/Field", node.Name, node.InnerText);
}
}
//將 contextInfo 這個 document 的資料塞進 ContextInfo 的 CdataSection 裡
helper.AddXmlString("UpdateRecord/Field/ContextInfo", root.OuterXml);
if (_Action == UpdateRecordAction.Update)
{
// 補上條件
helper.AddElement("UpdateRecord", "Condition");
helper.AddElement("UpdateRecord/Condition", "ID", _UpdateRecordID);
}
try
{
if (IsValid())
{
if (_Action == UpdateRecordAction.Update)
{
EditStudent.ModifyUpdateRecord(new DSRequest(helper));
}
else
{
EditStudent.InsertUpdateRecord(new DSRequest(helper));
}
_saved = true;
}
}
catch (Exception ex)
{
if (_Action == UpdateRecordAction.Update)
{
MsgBox.Show("修改異動資料失敗：" + ex.Message);
}
else
{
MsgBox.Show("新增異動資料失敗：" + ex.Message);
}
}
//#region 處理 Log，寫入 Log
////--- 這段用到 AccessHelp 先註解,之後再寫
//StringBuilder desc = new StringBuilder("");
//desc.AppendLine("學生姓名：" + ((_AccessHelper.StudentHelper.GetStudents(_StudentID).Count > 0) ? _AccessHelper.StudentHelper.GetStudents(_StudentID)[0].StudentName + " " : "未知 "));
//if (_Action == UpdateRecordAction.Update)
// desc.AppendLine("修改異動紀錄： " + beforeData["UpdateDate"] + " " + beforeData["UpdateDescription"] + " ");
//else
// desc.AppendLine("新增異動紀錄： " + afterData["UpdateDate"] + " " + afterData["UpdateDescription"] + " ");
//foreach (string var in afterData.Keys)
//{
// if (beforeData[var] != afterData[var])
// {
// if (_Action == UpdateRecordAction.Update)
// desc.AppendLine("欄位「" + _EnChDict[var] + "」由「" + beforeData[var] + "」變更為「" + afterData[var] + "」");
// else
// desc.AppendLine("新增欄位「" + _EnChDict[var] + "」為「" + afterData[var] + "」");
// }
//}
//EntityAction entityAction = EntityAction.Insert;
//if (_Action == UpdateRecordAction.Update)
// entityAction = EntityAction.Update;
//CurrentUser.Instance.AppLog.Write(EntityType.Student, entityAction, _StudentID, desc.ToString(), "異動資料", "");
// ///---
//#endregion
#region 之前的儲存做法
//if (_Action == UpdateRecordAction.Insert)
//{
// DSXmlHelper helper = new DSXmlHelper("InsertRequest");
// helper.AddElement("UpdateRecord");
// helper.AddElement("UpdateRecord", "Field");
// helper.AddElement("UpdateRecord/Field", "RefStudentID", _StudentID);
// helper.AddElement("UpdateRecord/Field", "ContextInfo");
// XmlDocument contextInfo = new XmlDocument();
// XmlElement root = contextInfo.CreateElement("ContextInfo");
// contextInfo.AppendChild(root);
// foreach (XmlNode node in GetElement().ChildNodes)
// {
// afterData.Add(node.Name, node.InnerText);
// // 如果是 Previous 開頭的全丟到 ContextInfo 中
// if (node.Name.StartsWith("Previous") || node.Name.StartsWith("Graduate") || node.Name == "NewStudentNumber" || node.Name == "LastUpdateCode")
// {
// XmlNode importNode = node.Clone();
// importNode = contextInfo.ImportNode(importNode, true);
// root.AppendChild(importNode);
// }
// else
// {
// helper.AddElement("UpdateRecord/Field", node.Name, node.InnerText);
// }
// }
// // 將 contextInfo 這個 document 的資料塞進 ContextInfo 的 CdataSection 裡
// helper.AddXmlString("UpdateRecord/Field/ContextInfo", root.OuterXml);
// DSRequest dsreq = new DSRequest(helper);
// try
// {
// if (IsValid())
// {
// EditStudent.InsertUpdateRecord(dsreq);
// _saved = true;
// }
// }
// catch (Exception ex)
// {
// MsgBox.Show("新增異動資料失敗：" + ex.Message);
// }
//}
//else
//{
// DSXmlHelper helper = new DSXmlHelper("UpdateRequest");
// helper.AddElement("UpdateRecord");
// helper.AddElement("UpdateRecord", "Field");
// helper.AddElement("UpdateRecord/Field", "RefStudentID", _StudentID);
// helper.AddElement("UpdateRecord/Field", "ContextInfo");
// XmlDocument contextInfo = new XmlDocument();
// XmlElement root = contextInfo.CreateElement("ContextInfo");
// contextInfo.AppendChild(root);
// foreach (XmlNode node in GetElement().ChildNodes)
// {
// afterData.Add(node.Name, node.InnerText);
// if (node.Name.StartsWith("Previous") || node.Name.StartsWith("Graduate") || node.Name == "NewStudentNumber" || node.Name == "LastUpdateCode")
// {
// XmlNode importNode = node.Clone();
// importNode = contextInfo.ImportNode(importNode, true);
// root.AppendChild(importNode);
// }
// else
// {
// helper.AddElement("UpdateRecord/Field", node.Name, node.InnerText);
// }
// }
// // 將 contextInfo 這個 document 的資料塞進 ContextInfo 的 CdataSection 裡
// helper.AddXmlString("UpdateRecord/Field/ContextInfo", root.OuterXml);
// // 補上條件
// helper.AddElement("UpdateRecord", "Condition");
// helper.AddElement("UpdateRecord/Condition", "ID", _UpdateRecordID);
// try
// {
// if (IsValid())
// {
// EditStudent.ModifyUpdateRecord(new DSRequest(helper));
// _saved = true;
// }
// }
// catch (Exception ex)
// {
// MsgBox.Show("修改異動資料失敗：" + ex.Message);
// }
//}
#endregion
return(_saved);
}
